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-
genbank_accessionGenbank accession number for full genome text - no 30
countrycountry where strain was isolated text
Afghanistan
Albania
Algeria
Andorra
Angola
Antigua & Barbuda
Argentina
Armenia
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bhutan
Bolivia
Bosnia & Herzegovina
Botswana
Brazil
Brunei
Bulgaria
Burkina Faso
Burma
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Central African Republic
Chad
Chile
China
Colombia
Comoros
Congo [DRC]
Costa Rica
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Fiji
Finland
France
Gabon
Georgia
Germany
Ghana
Greece
Grenada
Guadeloupe
Guatemala
Guinea
Guinea Bissau
Guyana
Haiti
Honduras
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Isle of Man
Israel
Italy
Ivory Coast
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macedonia
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia
Moldavia
Moldova
Monaco
Mongolia
Montenegro
Morocco
Mozambique
Namibia
Nauru
Nepal
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
None
North Korea
Norway
Oman
Pakistan
Palau
Palestinian territories
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Poland
Portugal
Qatar
Reunion
Romania
Russia
Rwanda
Samoa
San Marino
São Tomé and Príncipe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Korea
Spain
Sri Lanka
St. Kitts & Nevis
St. Lucia
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syria
Tahiti
Taiwan
Tajikistan
Tanzania
Thailand
The Gambia
The Netherlands
Togo
Tonga
Trinidad & Tobago
Tunisia
Turkey
Turkmenistan
Tuvalu
UK
USA
Uganda
Ukraine
United Arab Emirates
Uruguay
Uzbekistan
Vanuatu
Vatican City
Venezuela
Vietnam
Yemen
Zambia
Zimbabwe
Unknown
yes -
regionDepartment (Colombia, Peru), Province (Ecuador). When other country mark 'N/A' text
Colombia - Amazonas
Colombia - Antioquia
Colombia - Arauca
Colombia - Atlantico
Colombia - Bogota
Colombia - Bolivar
Colombia - Boyacá
Colombia - Caldas
Colombia - Caquetá
Colombia - Casanare
Colombia - Cauca
Colombia - Cesar
Colombia - Chocó
Colombia - Cordoba
Colombia - Cundinamarca
Colombia - Guainía
Colombia - Guaviare
Colombia - Huila
Colombia - La Guajira
Colombia - Magdalena
Colombia - Meta
Colombia - Nariño
Colombia - Norte de Santander
Colombia - Putumayo
Colombia - Quindío
Colombia - Risaralda
Colombia - San Andres y Providencia
Colombia - Santander
Colombia - Sucre
Colombia - Tolima
Colombia - Valle del Cauca
Colombia - Vaupés
Colombia - Vichada
Ecuador - Azuay
Ecuador - Bolivar
Ecuador - Cañay
Ecuador - Carchi
Ecuador - Chimborazo
Ecuador - Cotopaxi
Ecuador - El Oro
Ecuador - Esmeraldas
Ecuador - Galapagos
Ecuador - Guayas
Ecuador - Imbabura
Ecuador - Loja
Ecuador - Los Rios
Ecuador - Manabi
Ecuador - Morona-Santiago
Ecuador - Napo
Ecuador - Orellana
Ecuador - Pastaza
Ecuador - Pichincha
Ecuador - Santa Elena
Ecuador - Santo Domingo de los Tsachilas
Ecuador - Sucumbios
Ecuador - Tungurahua
Ecuador - Zamora - Chinchipe
Peru - Amazonas
Peru - Ancash
Peru - Apurimac
Peru - Arequipa
Peru - Ayacucho
Peru - Cajamarca
Peru - Callao
Peru - Cusco
Peru - Huancavelica
Peru - Huanuco
Peru - Ica
Peru - Junin
Peru - La Libertad
Peru - Lambayeque
Peru - Lima
Peru - Loreto
Peru - Madre de Dios
Peru - Moquegua
Peru - Pasco
Peru - Piura
Peru - Puno
Peru - San Martin
Peru - Tacna
Peru - Tumbes
Peru - Ucayali
N/A
Unknown
yes -
city_towncity or town text - no 50
host text
human
non-human
unknown
yes -
detailed_hostspecify when non-human - please put other sources in comments field text
Lutzomyia verrucarum
Lutzomyia peruensis
Lutzomyia maranonensis
other
no -
yearyear of sample collection integer min: 1900; max: 2022 no 4
illness_phaseset N/A for non-human isolates text
acute phase (Oroya fever)
chronic phase (Peruvian Wart)
asymptomatic
N/A
unknown
yes -
age_yrage in years integer min: 0; max: 120 no -
age_mthmonth part of age (0-11) for patients under 1 year old integer min: 0; max: 11 no -
sexsex of patient/carrier text
male
female
no -
infection text
vectorial
mother-to-child
transfusion
other
no -
sourcebiological source of sample (please put other sources in comments field) text
blood
LCR
wart
other
no -
epidemiology text
endemic
imported - internal movement from endemic to non endemic area within endemic countries
imported - tourist/traveler returning from endemic countries
imported - migrant from endemic countries living outside
vectorial origin
no -
outbreak bool - no -
amoxicillin_plug_clavulanic_acidMIC (mg/L) text - no -
amoxicillin_plug_clavulanic_acid_diskhalo (mm) text - no -
ampicillinMIC (mg/L) text - no -
ampicillin_diskhalo (mm) text - no -
ceftazidimeMIC (mg/L) text - no -
ceftazidime_diskhalo (mm) text - no -
ceftriaxoneMIC (mg/L) text - no -
ceftriaxone_diskhalo (mm) text - no -
ciprofloxacinMIC (mg/L) text - no -
ciprofloxacin_diskhalo (mm) text - no -
azithromycinMIC (mg/L) text - no -
azithromycin_diskhalo (mm) text - no -
erythromycinMIC (mg/L) text - no -
erythromycin_diskhalo (mm) text - no -
chloramphenicolMIC (mg/L) text - no -
chloramphenicol_diskhalo (mm) text - no -
rifampicinMIC (mg/L) text - no -
rifampicin_diskhalo (mm) text - no -
cotrimoxazoleMIC (mg/L) text - no -
cotrimoxazole_diskhalo (mm) text - no -
streptomycinMIC (mg/L) text - no -
streptomycin_diskhalo (mm) text - no -
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