=CONCATENATE(D166, " ", G166, ": ", AE166, ", ", L166, ", rep", MID(A166, LEN(A166), 1))
Arabidopsis thaliana
ecotype
=LEFT(A166, FIND("_", A166 & "_") - 1)
dev_stage
not applicable
collection_date
not collected
geo_loc_name
not applicable
tissue
root
treatment
=MID(A166, FIND("_", A166) + 1, FIND("_", A166, FIND("_", A166) + 1) - FIND("_", A166) - 1)
sample_id
=A166
BioSampleModel
Plant