=CONCATENATE(D174, " ", G174, ": ", AE174, ", ", L174, ", rep", MID(A174, LEN(A174), 1))
Arabidopsis thaliana
ecotype
=LEFT(A174, FIND("_", A174 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A174, FIND("_", A174) + 1, FIND("_", A174, FIND("_", A174) + 1) - FIND("_", A174) - 1)
sample_id
=A174
BioSampleModel
Plant