=CONCATENATE(D100, " ", G100, ": ", AE100, ", ", L100, ", rep", MID(A100, LEN(A100), 1))
Arabidopsis thaliana
ecotype
=LEFT(A100, FIND("_", A100 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A100, FIND("_", A100) + 1, FIND("_", A100, FIND("_", A100) + 1) - FIND("_", A100) - 1)
sample_id
=A100
BioSampleModel
Plant