=CONCATENATE(D80, " ", G80, ": ", AE80, ", ", L80, ", rep", MID(A80, LEN(A80), 1))
Arabidopsis thaliana
ecotype
=LEFT(A80, FIND("_", A80 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A80, FIND("_", A80) + 1, FIND("_", A80, FIND("_", A80) + 1) - FIND("_", A80) - 1)
sample_id
=A80
BioSampleModel
Plant