=CONCATENATE(D102, " ", G102, ": ", AE102, ", ", L102, ", rep", MID(A102, LEN(A102), 1))
Arabidopsis thaliana
ecotype
=LEFT(A102, FIND("_", A102 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
shoot
treatment
=MID(A102, FIND("_", A102) + 1, FIND("_", A102, FIND("_", A102) + 1) - FIND("_", A102) - 1)
sample_id
=A102
BioSampleModel
Plant