=CONCATENATE(D39, " ", G39, ": ", AE39, ", ", L39, ", rep", MID(A39, LEN(A39), 1))
Arabidopsis thaliana
ecotype
=LEFT(A39, FIND("_", A39 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A39, FIND("_", A39) + 1, FIND("_", A39, FIND("_", A39) + 1) - FIND("_", A39) - 1)
sample_id
=A39
BioSampleModel
Plant