=CONCATENATE(D40, " ", G40, ": ", AE40, ", ", L40, ", rep", MID(A40, LEN(A40), 1))
Arabidopsis thaliana
ecotype
=LEFT(A40, FIND("_", A40 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A40, FIND("_", A40) + 1, FIND("_", A40, FIND("_", A40) + 1) - FIND("_", A40) - 1)
sample_id
=A40
BioSampleModel
Plant