=CONCATENATE(D87, " ", G87, ": ", AE87, ", ", L87, ", rep", MID(A87, LEN(A87), 1))
Arabidopsis thaliana
ecotype
=LEFT(A87, FIND("_", A87 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A87, FIND("_", A87) + 1, FIND("_", A87, FIND("_", A87) + 1) - FIND("_", A87) - 1)
sample_id
=A87
BioSampleModel
Plant