=CONCATENATE(D142, " ", G142, ": ", AE142, ", ", L142, ", rep", MID(A142, LEN(A142), 1))
Arabidopsis thaliana
ecotype
=LEFT(A142, FIND("_", A142 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A142, FIND("_", A142) + 1, FIND("_", A142, FIND("_", A142) + 1) - FIND("_", A142) - 1)
sample_id
=A142
BioSampleModel
Plant