=CONCATENATE(D31, " ", G31, ": ", AE31, ", ", L31, ", rep", MID(A31, LEN(A31), 1))
Arabidopsis thaliana
ecotype
=LEFT(A31, FIND("_", A31 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A31, FIND("_", A31) + 1, FIND("_", A31, FIND("_", A31) + 1) - FIND("_", A31) - 1)
sample_id
=A31
BioSampleModel
Plant