=CONCATENATE(D147, " ", G147, ": ", AE147, ", ", L147, ", rep", MID(A147, LEN(A147), 1))
Arabidopsis thaliana
ecotype
=LEFT(A147, FIND("_", A147 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A147, FIND("_", A147) + 1, FIND("_", A147, FIND("_", A147) + 1) - FIND("_", A147) - 1)
sample_id
=A147
BioSampleModel
Plant