Data Template
Template TypePHENOTYPE
Templatephenotype
 download
Headers
ColumnDescription
* dataset_nameName of the phenotyping dataset (project). 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
infraspecific_typeInfraspecific type of the stock as defined in the taxonomic_rank CV
infraspecific_nameInfraspecific name 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.
clone_IDID of a specific clone if available (eg. individual tree).
primary_orderThe primary order of a sample
secondary_orderThe secondary order of a sample
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.
repAny repetition number.
rootstockName of the rootstock if the plant is grafted to a rootstock. It should match a 'stock_name' column of the 'Stock' sheet.
plotPlot name.
rowRow.
positionPosition of the plant.
plant_dateDate of the planting.
data_yearPhenotyping date if only year is known.
evaluation_dateDate of phenotype evaluation.
pick_dateDate of the sample collection if the collection is done on a different date than the phenotype evaluation.
previous_entrystock ID of the previous entry.
barcodeBarcode
fiber_pkgGroup of samples for phenotyping, can contain samples from multiple germplasm.
storage_timeTime between collection and phenotyping.
storage_regimeThe condition of sample storage between the collection and phenotyping.
commentsAny comments for the phenotyping.
#descriptor_nameSpecial columns (#) : followed by descriptor name.
##property_nameFollowed by property (cvterm) name. The data will be stored in property table.
* Required field