=CONCATENATE(D199, " ", G199, ": ", AE199, ", ", L199, ", rep", MID(A199, LEN(A199), 1))
Arabidopsis thaliana
ecotype
=LEFT(A199, FIND("_", A199 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A199, FIND("_", A199) + 1, FIND("_", A199, FIND("_", A199) + 1) - FIND("_", A199) - 1)
sample_id
=A199
BioSampleModel
Plant