=CONCATENATE(D157, " ", G157, ": ", AE157, ", ", L157, ", rep", MID(A157, LEN(A157), 1))
Arabidopsis thaliana
ecotype
=LEFT(A157, FIND("_", A157 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A157, FIND("_", A157) + 1, FIND("_", A157, FIND("_", A157) + 1) - FIND("_", A157) - 1)
sample_id
=A157
BioSampleModel
Plant