=CONCATENATE(D111, " ", G111, ": ", AE111, ", ", L111, ", rep", MID(A111, LEN(A111), 1))
Arabidopsis thaliana
ecotype
=LEFT(A111, FIND("_", A111 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A111, FIND("_", A111) + 1, FIND("_", A111, FIND("_", A111) + 1) - FIND("_", A111) - 1)
sample_id
=A111
BioSampleModel
Plant