=CONCATENATE(D42, " ", G42, ": ", AE42, ", ", L42, ", rep", MID(A42, LEN(A42), 1))
Arabidopsis thaliana
ecotype
=LEFT(A42, FIND("_", A42 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A42, FIND("_", A42) + 1, FIND("_", A42, FIND("_", A42) + 1) - FIND("_", A42) - 1)
sample_id
=A42
BioSampleModel
Plant