=CONCATENATE(D217, " ", G217, ": ", AE217, ", ", L217, ", rep", MID(A217, LEN(A217), 1))
Arabidopsis thaliana
ecotype
=LEFT(A217, FIND("_", A217 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A217, FIND("_", A217) + 1, FIND("_", A217, FIND("_", A217) + 1) - FIND("_", A217) - 1)
sample_id
=A217
BioSampleModel
Plant