=CONCATENATE(D195, " ", G195, ": ", AE195, ", ", L195, ", rep", MID(A195, LEN(A195), 1))
Arabidopsis thaliana
ecotype
=LEFT(A195, FIND("_", A195 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A195, FIND("_", A195) + 1, FIND("_", A195, FIND("_", A195) + 1) - FIND("_", A195) - 1)
sample_id
=A195
BioSampleModel
Plant