=CONCATENATE(D20, " ", G20, ": ", AE20, ", ", L20, ", rep", MID(A20, LEN(A20), 1))
Arabidopsis thaliana
ecotype
=LEFT(A20, FIND("_", A20 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A20, FIND("_", A20) + 1, FIND("_", A20, FIND("_", A20) + 1) - FIND("_", A20) - 1)
sample_id
=A20
BioSampleModel
Plant