=CONCATENATE(D196, " ", G196, ": ", AE196, ", ", L196, ", rep", MID(A196, LEN(A196), 1))
Arabidopsis thaliana
ecotype
=LEFT(A196, FIND("_", A196 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A196, FIND("_", A196) + 1, FIND("_", A196, FIND("_", A196) + 1) - FIND("_", A196) - 1)
sample_id
=A196
BioSampleModel
Plant