=CONCATENATE(D45, " ", G45, ": ", AE45, ", ", L45, ", rep", MID(A45, LEN(A45), 1))
Arabidopsis thaliana
ecotype
=LEFT(A45, FIND("_", A45 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A45, FIND("_", A45) + 1, FIND("_", A45, FIND("_", A45) + 1) - FIND("_", A45) - 1)
sample_id
=A45
BioSampleModel
Plant