Description of database fields

Order columns by clicking their headings. Reset default order.

field namecommentsdata typeallowed valuesrequiredmaximum length (characters)
idprimary key integer - yes 5
isolateisolate name text - yes 20
aliasesalternative names for isolatetext (multiple)-no-
referencesPubMed ids that link to publications that describe or include recordinteger (multiple)-no-
countrycountry 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
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 -
state_or_province text
Acre
Aguascalientes
Alabama
Alagoas
Alajuela
Alaska
Amapa
Amazonas
Arizona
Arkansas
Bahia
Baja California
Baja California Sur
California
Campeche
Cartago
Ceara
Chiapas
Chihuahua
Coahuila
Colima
Colorado
Connecticut
Delaward
District of Columbia
Distrito Federal
Durango
Espirito Santo
Florida
Georgia
Goias
Guanacaste
Guanajuato
Guerrero
Hawaii
Heredia
Hidalgo
Idaho
Illinois
Indiana
Iowa
Jalisco
Kansas
Kentucky
Limon
Louisiana
Maine
Maranhao
Maryland
Massachusetts
Mato Grosso
Mato Grosso do Sul
Mexico State
Michigan
Michoacan
Minas Gerais
Minnesota
Mississippi
Missouri
Montana
Morelos
Nayarit
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Nuevo Leon
Oaxaca
Ohio
Oklahoma
Oregon
Para
Paraiba
Parana
Pennsylvania
Pernambuco
Piaui
Puebla
Puntarenas
Queretaro
Quintana Roo
Rhode Island
Rio de Janeiro
Rio Grande do Norte
Rio Grande do Sul
Rondonia
Roraima
San Jose
San Luis Potosi
Santa Catarina
Sao Paulo
Sergipe
Sinaloa
Sonora
South Carolina
South Dakota
Tabasco
Tamaulipas
Tennessee
Texas
Tlaxcala
Tocantins
Utah
Veracruz
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Yucatan
Zacatecas
other
no -
county text - no 30
city text - no 30
host_speciesif 'other' then please add full host species name to the comments field text
Acer griseum
Acer macrophyllum
Acer negundo
Acer palmatum
Acer rubrum
Acer saccharum
Alnus rhombifolia
Ambrosia psilostachya
Ambrosia trifida
Ampelopsis cordata
Carya illinoinensis
Celtis occidentalis
Cercis canadensis
Cercis occidentalis
Chionanthus sp.
Citrus sinensis
Citrus sp.
Coffea arabica
Coffea sp.
Cornus kousa
Encelia farinosa
Erythrina sp.
Fraxinus americana
Fraxinus sp.
Ginkgo biloba
Gleditsia triacanthos
Graphocephala atropunctata
Hamamelis sp.
Hedera helix
Helianthus sp.
Hemerocallis sp.
Homalodisca lacerta
Homalodisca vitripennis
Iva annua
Jacaranda mimosifolia
Koelreuteria bipinnata
Lagerstroemia indica
Liquidambar styraciflua
Lupinus aridorum
Lupinus villosus
Magnolia grandiflora
Magnolia sp.
Malus sp.
Medicago sativa
Metrosideros sp.
Morus alba
Morus rubra
Morus sp.
Myoporum sp.
Nandina domestica
Nerium oleander
Nerium oleander L.
Olea europaea
Paulownia tomentosa
Platanus occidentalis
Platanus sp.
Pluchea odorata
Polygala myrtifolia
Prunus armeniaca
Prunus avium
Prunus cerasifera
Prunus domestica
Prunus dulcis
Prunus persica
Prunus sp.
Pyrus pyrifolia
Quercus coccinea
Quercus falcate
Quercus laevis
Quercus michauxii
Quercus nigra
Quercus palustris
Quercus phellos
Quercus robur
Quercus rubra
Quercus shumardii
Quercus sp.
Ratibida columnaris
Rubus sp.
Salix sp.
Salvia mellifera
Sambucus canadensis
Sapindus drummondii
Sapindus saponaria
Sequoia sempervirens
Solidago virgaurea
Spartium junceum
Ulmus americana
Ulmus crassifolia
Vaccinium corymbosum
Vaccinium hybrid
Vinca minor
Vinca sp.
Viola sp.
Vitis aestivalis
Vitis aestivalis hybrid
Vitis girdiana
Vitis rotundifolia
Vitis sp.
Vitis vinifera
Xanthium strumarium
other
yes -
variety text - no 30
yearyear of isolation integer min: 1900; max: 2021 no 4
decade text
1950s
1960s
1970s
1980s
1990s
2000s
2010s
2020s
no -
ATCC_no text - no 12
commentsany other comments text - no 1000
sendersender unique name, link to users integer Click for list of sender ids yes 4
curatorcurator who entered data,link to users integer Click for list of curator ids yes 4
date_entereddate first entered date - yes 10
datestampdate last modified date - yes 10