=CONCATENATE(D46, " ", G46, ": ", AE46, ", ", L46, ", rep", MID(A46, LEN(A46), 1))
Arabidopsis thaliana
ecotype
=LEFT(A46, FIND("_", A46 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A46, FIND("_", A46) + 1, FIND("_", A46, FIND("_", A46) + 1) - FIND("_", A46) - 1)
sample_id
=A46
BioSampleModel
Plant