=CONCATENATE(D19, " ", G19, ": ", AE19, ", ", L19, ", rep", MID(A19, LEN(A19), 1))
Arabidopsis thaliana
ecotype
=LEFT(A19, FIND("_", A19 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A19, FIND("_", A19) + 1, FIND("_", A19, FIND("_", A19) + 1) - FIND("_", A19) - 1)
sample_id
=A19
BioSampleModel
Plant