=CONCATENATE(D38, " ", G38, ": ", AE38, ", ", L38, ", rep", MID(A38, LEN(A38), 1))
Arabidopsis thaliana
ecotype
=LEFT(A38, FIND("_", A38 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A38, FIND("_", A38) + 1, FIND("_", A38, FIND("_", A38) + 1) - FIND("_", A38) - 1)
sample_id
=A38
BioSampleModel
Plant