=CONCATENATE(D167, " ", G167, ": ", AE167, ", ", L167, ", rep", MID(A167, LEN(A167), 1))
Arabidopsis thaliana
ecotype
=LEFT(A167, FIND("_", A167 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A167, FIND("_", A167) + 1, FIND("_", A167, FIND("_", A167) + 1) - FIND("_", A167) - 1)
sample_id
=A167
BioSampleModel
Plant