=CONCATENATE(D59, " ", G59, ": ", AE59, ", ", L59, ", rep", MID(A59, LEN(A59), 1))
Arabidopsis thaliana
ecotype
=LEFT(A59, FIND("_", A59 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A59, FIND("_", A59) + 1, FIND("_", A59, FIND("_", A59) + 1) - FIND("_", A59) - 1)
sample_id
=A59
BioSampleModel
Plant