=CONCATENATE(D197, " ", G197, ": ", AE197, ", ", L197, ", rep", MID(A197, LEN(A197), 1))
Arabidopsis thaliana
ecotype
=LEFT(A197, FIND("_", A197 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A197, FIND("_", A197) + 1, FIND("_", A197, FIND("_", A197) + 1) - FIND("_", A197) - 1)
sample_id
=A197
BioSampleModel
Plant