=CONCATENATE(D158, " ", G158, ": ", AE158, ", ", L158, ", rep", MID(A158, LEN(A158), 1))
Arabidopsis thaliana
ecotype
=LEFT(A158, FIND("_", A158 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A158, FIND("_", A158) + 1, FIND("_", A158, FIND("_", A158) + 1) - FIND("_", A158) - 1)
sample_id
=A158
BioSampleModel
Plant