=CONCATENATE(D53, " ", G53, ": ", AE53, ", ", L53, ", rep", MID(A53, LEN(A53), 1))
Arabidopsis thaliana
ecotype
=LEFT(A53, FIND("_", A53 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A53, FIND("_", A53) + 1, FIND("_", A53, FIND("_", A53) + 1) - FIND("_", A53) - 1)
sample_id
=A53
BioSampleModel
Plant