=CONCATENATE(D99, " ", G99, ": ", AE99, ", ", L99, ", rep", MID(A99, LEN(A99), 1))
Arabidopsis thaliana
ecotype
=LEFT(A99, FIND("_", A99 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A99, FIND("_", A99) + 1, FIND("_", A99, FIND("_", A99) + 1) - FIND("_", A99) - 1)
sample_id
=A99
BioSampleModel
Plant