=CONCATENATE(D55, " ", G55, ": ", AE55, ", ", L55, ", rep", MID(A55, LEN(A55), 1))
Arabidopsis thaliana
ecotype
=LEFT(A55, FIND("_", A55 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A55, FIND("_", A55) + 1, FIND("_", A55, FIND("_", A55) + 1) - FIND("_", A55) - 1)
sample_id
=A55
BioSampleModel
Plant