=CONCATENATE(D57, " ", G57, ": ", AE57, ", ", L57, ", rep", MID(A57, LEN(A57), 1))
Arabidopsis thaliana
ecotype
=LEFT(A57, FIND("_", A57 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A57, FIND("_", A57) + 1, FIND("_", A57, FIND("_", A57) + 1) - FIND("_", A57) - 1)
sample_id
=A57
BioSampleModel
Plant