=CONCATENATE(D18, " ", G18, ": ", AE18, ", ", L18, ", rep", MID(A18, LEN(A18), 1))
Arabidopsis thaliana
ecotype
=LEFT(A18, FIND("_", A18 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A18, FIND("_", A18) + 1, FIND("_", A18, FIND("_", A18) + 1) - FIND("_", A18) - 1)
sample_id
=A18
BioSampleModel
Plant