=CONCATENATE(D143, " ", G143, ": ", AE143, ", ", L143, ", rep", MID(A143, LEN(A143), 1))
Arabidopsis thaliana
ecotype
=LEFT(A143, FIND("_", A143 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A143, FIND("_", A143) + 1, FIND("_", A143, FIND("_", A143) + 1) - FIND("_", A143) - 1)
sample_id
=A143
BioSampleModel
Plant