=CONCATENATE(D70, " ", G70, ": ", AE70, ", ", L70, ", rep", MID(A70, LEN(A70), 1))
Arabidopsis thaliana
ecotype
=LEFT(A70, FIND("_", A70 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A70, FIND("_", A70) + 1, FIND("_", A70, FIND("_", A70) + 1) - FIND("_", A70) - 1)
sample_id
=A70
BioSampleModel
Plant