=CONCATENATE(D49, " ", G49, ": ", AE49, ", ", L49, ", rep", MID(A49, LEN(A49), 1))
Arabidopsis thaliana
ecotype
=LEFT(A49, FIND("_", A49 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A49, FIND("_", A49) + 1, FIND("_", A49, FIND("_", A49) + 1) - FIND("_", A49) - 1)
sample_id
=A49
BioSampleModel
Plant