=CONCATENATE(D43, " ", G43, ": ", AE43, ", ", L43, ", rep", MID(A43, LEN(A43), 1))
Arabidopsis thaliana
ecotype
=LEFT(A43, FIND("_", A43 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A43, FIND("_", A43) + 1, FIND("_", A43, FIND("_", A43) + 1) - FIND("_", A43) - 1)
sample_id
=A43
BioSampleModel
Plant