=CONCATENATE(D187, " ", G187, ": ", AE187, ", ", L187, ", rep", MID(A187, LEN(A187), 1))
Arabidopsis thaliana
ecotype
=LEFT(A187, FIND("_", A187 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A187, FIND("_", A187) + 1, FIND("_", A187, FIND("_", A187) + 1) - FIND("_", A187) - 1)
sample_id
=A187
BioSampleModel
Plant