Cottongen

Data Template

Template Type	PHENOTYPE
Template	phenotype
	download

Headers

Column	Description
* dataset_name	Name of the phenotyping dataset. It should match a 'dataset_name' column entry in the 'Dataset' sheet.
* stock_name	ID 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.
* genus	Genus of the stock
* species	Species of the stock
* sample_ID	The 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_ID	ID of a spefic clone if available (eg. individual tree).
primary_order	The primary order of a sample
secondary_order	The secondary order of a sample
evaluator	Person who did the phenotyping. Multiple person can be entered with ';' in between. It should match 'contact_name' of the Contact sheet.
site_name	Site information where the stock for the phenotyping is planted. It should match 'site_name' in the 'Site' sheet.
rep	Any repetition number.
rootstock	Name of the rootstock if the plant is grafted to a rootstock. It should match a 'stock_name' column of the 'Stock' sheet.
plot	Plot name.
row	Row.
position	Position of the plant.
plant_date	Date of the planting.
data_year	Phenotyping date if only year is known.
evaluation_date	Date of phenotype evaluation.
pick_date	Date of the sample collection if the collection is done on a different date than the phenotype evaluation.
previous_entry	stock ID of the previous entry.
barcode	Barcode
fiber_pkg	Group of samples for phenotyping, can contain samples from multiple germplasm.
storage_time	Time between collection and phenotyping.
storage_regime	The condition of sample storage between the collection and phenotyping.
comments	Any comments for the phenotyping.
#descriptor_name	Special columns (#) : followed by descriptor name.
##property_name	Followed by property (cvterm) name. The data will be stored in property table.

* Required field

cvterms

cv.name	cvterm.name
MAIN	barcode
MAIN	clone
MAIN	clone_of
MAIN	comments
MAIN	evaluation_date
MAIN	fiber_pkg
MAIN	nd_geolocation_id
MAIN	phenotyping
MAIN	pick_date
MAIN	plant_date
MAIN	plot
MAIN	position
MAIN	previous_entry
MAIN	project_id
MAIN	row
MAIN	sample
MAIN	sample_of
MAIN	source
MAIN	storage_regime
MAIN	storage_time
BIMS_FIELD_BOOK	primary_order
BIMS_FIELD_BOOK	secondary_order
BIMS_FIELD_BOOK	unique_id

Returns to the template list page

Search form