=CONCATENATE(D30, " ", G30, ": ", AE30, ", ", L30, ", rep", MID(A30, LEN(A30), 1))
Arabidopsis thaliana
ecotype
=LEFT(A30, FIND("_", A30 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A30, FIND("_", A30) + 1, FIND("_", A30, FIND("_", A30) + 1) - FIND("_", A30) - 1)
sample_id
=A30
BioSampleModel
Plant