=CONCATENATE(D56, " ", G56, ": ", AE56, ", ", L56, ", rep", MID(A56, LEN(A56), 1))
Arabidopsis thaliana
ecotype
=LEFT(A56, FIND("_", A56 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A56, FIND("_", A56) + 1, FIND("_", A56, FIND("_", A56) + 1) - FIND("_", A56) - 1)
sample_id
=A56
BioSampleModel
Plant