=CONCATENATE(D172, " ", G172, ": ", AE172, ", ", L172, ", rep", MID(A172, LEN(A172), 1))
Arabidopsis thaliana
ecotype
=LEFT(A172, FIND("_", A172 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A172, FIND("_", A172) + 1, FIND("_", A172, FIND("_", A172) + 1) - FIND("_", A172) - 1)
sample_id
=A172
BioSampleModel
Plant