=CONCATENATE(D22, " ", G22, ": ", AE22, ", ", L22, ", rep", MID(A22, LEN(A22), 1))
Arabidopsis thaliana
ecotype
=LEFT(A22, FIND("_", A22 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A22, FIND("_", A22) + 1, FIND("_", A22, FIND("_", A22) + 1) - FIND("_", A22) - 1)
sample_id
=A22
BioSampleModel
Plant