=CONCATENATE(D47, " ", G47, ": ", AE47, ", ", L47, ", rep", MID(A47, LEN(A47), 1))
Arabidopsis thaliana
ecotype
=LEFT(A47, FIND("_", A47 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A47, FIND("_", A47) + 1, FIND("_", A47, FIND("_", A47) + 1) - FIND("_", A47) - 1)
sample_id
=A47
BioSampleModel
Plant