=CONCATENATE(D58, " ", G58, ": ", AE58, ", ", L58, ", rep", MID(A58, LEN(A58), 1))
Arabidopsis thaliana
ecotype
=LEFT(A58, FIND("_", A58 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A58, FIND("_", A58) + 1, FIND("_", A58, FIND("_", A58) + 1) - FIND("_", A58) - 1)
sample_id
=A58
BioSampleModel
Plant