=CONCATENATE(D78, " ", G78, ": ", AE78, ", ", L78, ", rep", MID(A78, LEN(A78), 1))
Arabidopsis thaliana
ecotype
=LEFT(A78, FIND("_", A78 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A78, FIND("_", A78) + 1, FIND("_", A78, FIND("_", A78) + 1) - FIND("_", A78) - 1)
sample_id
=A78
BioSampleModel
Plant