Cottongen

Data Template


Template	stock_cotton	download

Headers


Column	Description
* stock_name	Primary ID or name of stock. The most important ID or name (unique and stable at least within the breeding program) should be in this column. For mapping population, follow the naming convention of each database.
* stock_type	Select from the three choices (accession, population or panel).
accession_type	Types of an accession (breeding_research_material, cultivar, wild_unimproved, etc.). accession_type is required when the stock_type is accession.
* genus	Genus to which the stock belongs to.
* species	Species name. Enter 'sp.' to represent one unknown species, 'spp.' to represent multiple unknown species.
USDA_PI	USDA_PI in the GRIN database. Multiple USDA_PI, separated by comma or semi-colon, can be added.
institutional_name	Institutional name(s). separated by comma or semi-colon, can be added.
subspecies	Subspecies name.
description	Any description for the stock.
* secondary_ID	Alternate ID or name that is commonly used to refer to the entry.
maternal_parent	Stock_name for the seed parent of this entry. This stock_name must also have its own record in this table (it should be entered before being listed as a parent).
paternal_parent	Stock_name for the pollen parent of this entry. This stock_name must also have its own record in this table (it should be entered before being listed as a parent).
mutation_parent	Stock_name of the mutation parent. This stock_name must also have its own record in this table (it should be entered before being listed as a parent).
selfing_parent	Stock_name of the selfing parent. This stock_name must also have its own record in this table (it should be entered before being listed as a parent).
alias	A concatenation of all other less commonly used names or designations for the entry. the aliases. The format is 'Alias type1:Alias1; Alias type2:Alias2'. When there is no specific type for aliases, just write the aliases without the specific type. (eg. Collector:98HT-227; Site:W6 21306; ABC-1; 21306) The format is 'Alias type1:Alias1; Alias type2:Alias2'. When there is no specific type for an alias, just write the aliases without the specific type. (eg. Collector:98HT-227; Site:W6 21306; ABC-1; 21306).
cultivar	Cultivar name if It is a named, cultivated variety.
pedigree	Any additional pedigree information: When the exact parents are not known, or any additional information beyond just parents (eg. Red-fruit sport of Jonathan, Pyrus sp. X Cydonia sp., etc.).
dataset_name	Name of the dataset that cross belongs to. This is required if 'cross_number' is specified.
cross_number	Cross number of a cross that generated the progeny; Must also be found in the Cross table.
advanced_to_2nd	Yes if it is advanced to 2nd phase, No otherwise. Leave it empty if the selection decision is yet to be made.
advanced_to_3rd	Yes if it is advanced to 3rd phase, No otherwise.
advanced_to_4th	Yes if it is advanced to 4th phase, No otherwise.
ploidy	Number of sets of chromosomes (e.g. 2x).
ploidy_equation	Equation of the ploidy of the plant. Example 2n = 2x = YY.
origin_detail	The origin for the variety (especially for wild variety).
origin_country	The original country for the variety (especially for wild variety).
population_size	Only for type 'population'.
germplasm_center	Stock center or lab where the stock is distributed. Otherwise, provide the details of the contact person in contact column (from whom the material can be obtained) in the 'Contact' sheet.
comments	Any comments on the stock.
image	Image ID of any associated image (Detailed info in 'Image' sheet.) Multiple images, separated by comma, can be added.
reference	Reference where the stock is originally described (pub_id), Multiple references, separated by comma, can be added.
##property_name	Special columns (##) : followed by name of the custom property.

* Required field

cvterms


cv.name	cvterm.name
MAIN	accession
MAIN	accession_type
MAIN	advanced_to_2nd
MAIN	advanced_to_3rd
MAIN	advanced_to_4th
MAIN	alias
MAIN	comments
MAIN	cross_experiment
MAIN	cultivar
MAIN	description
MAIN	germplasm_center
MAIN	institutional_name
MAIN	is_a_maternal_parent_of
MAIN	is_a_mutation_parent_of
MAIN	is_a_paternal_parent_of
MAIN	is_a_selfing_parent_of
MAIN	maternal_parent
MAIN	mutation_parent
MAIN	origin_country
MAIN	origin_detail
MAIN	paternal_parent
MAIN	pedigree
MAIN	ploidy
MAIN	ploidy_equation
MAIN	population
MAIN	population_size
MAIN	progeny
MAIN	secondary_id
MAIN	selfing_parent
MAIN	subspecies
MAIN	usda_gmal
MAIN	usda_pi

Returns to the template list page

Search form