=CONCATENATE(D37, " ", G37, ": ", AE37, ", ", L37, ", rep", MID(A37, LEN(A37), 1))
Arabidopsis thaliana
ecotype
=LEFT(A37, FIND("_", A37 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A37, FIND("_", A37) + 1, FIND("_", A37, FIND("_", A37) + 1) - FIND("_", A37) - 1)
sample_id
=A37
BioSampleModel
Plant