=CONCATENATE(D171, " ", G171, ": ", AE171, ", ", L171, ", rep", MID(A171, LEN(A171), 1))
Arabidopsis thaliana
ecotype
=LEFT(A171, FIND("_", A171 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A171, FIND("_", A171) + 1, FIND("_", A171, FIND("_", A171) + 1) - FIND("_", A171) - 1)
sample_id
=A171
BioSampleModel
Plant