=CONCATENATE(D54, " ", G54, ": ", AE54, ", ", L54, ", rep", MID(A54, LEN(A54), 1))
Arabidopsis thaliana
ecotype
=LEFT(A54, FIND("_", A54 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A54, FIND("_", A54) + 1, FIND("_", A54, FIND("_", A54) + 1) - FIND("_", A54) - 1)
sample_id
=A54
BioSampleModel
Plant