Data Template
Templatephenotype
 download
Headers
ColumnDescription
* dataset_nameName of the phenotyping dataset. It should match a 'dataset_name' column entry in the 'Dataset' sheet.
* stock_nameID of the stock that has been phenotyped. It should match a 'stock_name' column entry in the 'Stock' sheet or 'progeny_name' column entry 'Progeny' sheet.
* genusGenus of the stock
* speciesSpecies of the stock
* sample_IDThe ID of the smallest sample or sub-sample that was tested (Each row should have unique sample_ID). If there is no unique sample ID, users can concatenate a set of columns that gives a unique phenotypic value and those columns become required fields. For example, if a combination of dataset_name, ID, phenotyping_date is unique for the specific phenotype, those three can be concatenated with '_' in between.
primary_orderThe primary order of a sample
secondary_orderThe secondary order of a sample
clone_IDID of a spefic clone if available (eg. individual tree).
evaluatorPerson who did the phenotyping. Multiple person can be entered with ';' in between. It should match 'contact_name' of the Contact sheet.
site_nameSite information where the stock for the phenotyping is planted. It should match 'site_name' in the 'Site' sheet.
rootstockName of the rootstock if the plant is grafted to a rootstock. It should match a 'stock_name' column of the 'Stock' sheet. If the organism of the rootstock and the sample are different, add the organism as prefix of rootstock separated by double colon '::'.
scionName of scion if the stock is rootstock. It should match a 'stock_name' column of the 'Stock' sheet. If the organism of the scion and the sample are different, add the organism as prefix of scion separated by double colon '::'.
previous_entrystock ID of the previous entry.
data_yearPhenotyping date if only year is known.
institutional_nameInstitutional name.
repAny repetition number.
plotPlot name.
rowRow.
positionPosition of the plant.
plant_dateDate of the planting.
pick_dateDate of the sample collection if the collection is done on a different date than the phenotype evaluation.
evaluation_dateDate of phenotype evaluation.
storage_timeTime between collection and phenotyping.
storage_regimeThe condition of sample storage between the collection and phenotyping.
fiber_pkgGroup of samples for phenotyping, can contain samples from multiple germplasm.
commentsAny comments for the phenotyping.
* Required field
cvterms
cv.namecvterm.name
MAINclone
MAINclone_of
MAINcomments
MAINdata_year
MAINevaluation_date
MAINfiber_pkg
MAINinstitutional_name
MAINis_a_rootstock_of
MAINis_a_scion_of
MAINnd_geolocation_id
MAINphenotyping
MAINpick_date
MAINplant_date
MAINplot
MAINposition
MAINprevious_entry
MAINproject_id
MAINrep
MAINrow
MAINsample
MAINsample_of
MAINstorage_regime
MAINstorage_time
BIMS_FIELD_BOOKprimary_order
BIMS_FIELD_BOOKsecondary_order
BIMS_FIELD_BOOKunique_id