=CONCATENATE(D23, " ", G23, ": ", AE23, ", ", L23, ", rep", MID(A23, LEN(A23), 1))
Arabidopsis thaliana
ecotype
=LEFT(A23, FIND("_", A23 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A23, FIND("_", A23) + 1, FIND("_", A23, FIND("_", A23) + 1) - FIND("_", A23) - 1)
sample_id
=A23
BioSampleModel
Plant