Home>Organisms>Oral Streptococcus>Oral Streptococcus isolates>Plugins>Description of database fields

Description of database fields

Order columns by clicking their headings. Reset default order.

field name	comments	data type	allowed values	required	maximum length (characters)
id	primary key	integer	-	yes	5
isolate	isolate name	text	-	yes	20
aliases	alternative names for isolate	text (multiple)	-	no	-
references	PubMed ids that link to publications that describe or include record	integer (multiple)	-	no	-
species		text	Streptococcus acidominimus Streptococcus agalactiae Streptococcus alactolyticus Streptococcus anginosus Streptococcus australis Streptococcus azizii Streptococcus bovimastitidis Streptococcus caballi Streptococcus canis Streptococcus castoreus Streptococcus catagoni Streptococcus chenjunshii Streptococcus chosunense Streptococcus constellatus Streptococcus criceti Streptococcus cristatus Streptococcus cuniculi Streptococcus danieliae Streptococcus devriesei Streptococcus didelphis Streptococcus downei Streptococcus dysgalactiae Streptococcus entericus Streptococcus equi Streptococcus equinus Streptococcus ferus Streptococcus gallolyticus Streptococcus gordonii Streptococcus halichoeri Streptococcus halitosis Streptococcus halotolerans Streptococcus henryi Streptococcus hillyeri Streptococcus himalayensis Streptococcus hyointestinalis Streptococcus hyovaginalis Streptococcus ictaluri Streptococcus ilei Streptococcus infantarius Streptococcus infantis Streptococcus iniae Streptococcus intermedius Streptococcus koreensis Streptococcus lactarius Streptococcus loxodontisalivarius Streptococcus lutetiensis Streptococcus macacae Streptococcus macedonicus Streptococcus marimammalium Streptococcus marmotae Streptococcus massiliensis Streptococcus merionis Streptococcus minor Streptococcus mitis Streptococcus mutans Streptococcus oralis Streptococcus oricebi Streptococcus orisasini Streptococcus orisratti Streptococcus ovis Streptococcus ovuberis Streptococcus pacificus Streptococcus panodentis Streptococcus pantholopis Streptococcus parasanguinis Streptococcus parasuis Streptococcus parauberis Streptococcus pasteurianus Streptococcus penaeicida Streptococcus periodonticum Streptococcus peroris Streptococcus pharyngis Streptococcus phocae Streptococcus pluranimalium Streptococcus plurextorum Streptococcus pneumoniae Streptococcus porci Streptococcus porcinus Streptococcus pseudopneumoniae Streptococcus pseudoporcinus Streptococcus pyogenes Streptococcus ratti Streptococcus respiraculi Streptococcus rubneri Streptococcus ruminantium Streptococcus salivarius Streptococcus saliviloxodontae Streptococcus sanguinis Streptococcus shenyangsis Streptococcus sinensis Streptococcus sobrinus Streptococcus suis Streptococcus symci Streptococcus thermophilus Streptococcus thoraltensis Streptococcus timonensis Streptococcus troglodytae Streptococcus uberis Streptococcus urinalis Streptococcus ursoris Streptococcus vaginalis Streptococcus varani Streptococcus vestibularis Streptococcus vicugnae Streptococcus xiaochunlingii Streptococcus zalophi Streptococcus sp. Non-Streptococcus sp.	no	-
country	country where strain was isolated	text	Afghanistan Åland Islands Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire, Sint Eustatius and Saba Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory British Virgin Islands Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China China [Hong Kong] China [Macao] Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo [DRC] Congo [Republic] Cook Islands Costa Rica Croatia Cuba Curaçao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands (Malvinas) Faroe Islands Fiji Finland France French Guiana French Polynesia French Southern Territories Gabon Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard Island and McDonald Islands Holy See Honduras Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Ivory Coast Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island North Korea North Macedonia Northern Mariana Islands Norway Oman Pakistan Palau Palestinian territories Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Poland Portugal Puerto Rico Qatar Réunion Romania Russia Russia [Asia] Russia [Europe] Rwanda Saint Barthélemy Saint Helena Saint Kitts and Nevis Saint Lucia Saint Martin (French Part) Saint Pierre and Miquelon Saint Vincent and the Grenadines Samoa San Marino São Tomé and Príncipe Sark Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Sint Maarten (Dutch part) Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the South Sandwich Islands South Korea South Sudan Spain Sri Lanka Sudan Suriname Svalbard and Jan Mayen Islands Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand The Gambia The Netherlands Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda UK UK [England] UK [Northern Ireland] UK [Scotland] UK [Wales] Ukraine United Arab Emirates Uruguay US Minor Outlying Islands US Virgin Islands USA Uzbekistan Vanuatu Venezuela Vietnam Wallis and Futuna Islands Western Sahara Yemen Zambia Zimbabwe Unknown	yes	-
year		integer	-	no	4
source		text	blood dentine endodontic infection plaque saliva supra-gingival plaque tongue	no	-
carious		text	caries free caries lesions root caries lesions	no	-
serotype		text	-	no	15
age_yrs	age of patient	integer	-	no	4
comments		text	-	no	256
bioproject_accession	ENA/SRA bioproject accession number	text (multiple)	-	no	20
biosample_accession	ENA/SRA biosample accession number	text (multiple)	-	no	20
ENA_run_accession	ENA/SRA accession number to access short read data. This should start either ERR, SRR, or DRR.	text	-	no	15
sender	sender unique name, link to users	integer	Click for list of sender ids	yes	4
curator	curator who entered data,link to users	integer	Click for list of curator ids	yes	4
date_entered	date first entered	date	-	yes	10
datestamp	date last modified	date	-	yes	10