=CONCATENATE(D27, " ", G27, ": ", AE27, ", ", L27, ", rep", MID(A27, LEN(A27), 1))
Arabidopsis thaliana
ecotype
=LEFT(A27, FIND("_", A27 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A27, FIND("_", A27) + 1, FIND("_", A27, FIND("_", A27) + 1) - FIND("_", A27) - 1)
sample_id
=A27
BioSampleModel
Plant