=CONCATENATE(D101, " ", G101, ": ", AE101, ", ", L101, ", rep", MID(A101, LEN(A101), 1))
Arabidopsis thaliana
ecotype
=LEFT(A101, FIND("_", A101 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A101, FIND("_", A101) + 1, FIND("_", A101, FIND("_", A101) + 1) - FIND("_", A101) - 1)
sample_id
=A101
BioSampleModel
Plant