| id | primary key |
integer |
- |
yes |
6 |
| 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 | - |
| biosample | |
text |
- |
no |
20 |
| accession_number | |
text |
- |
no |
20 |
| clade | If not known, put ''Unknown'' |
text |
P1
P2
S1
S2
Unknown
|
no |
- |
| species | if not known, put ''Unknown'' |
text |
abararensis
adleri
ainazelensis
ainlahdjerensis
alexanderi
alstonii
andrefontaineae
bandrabouensis
barantonii
biflexa
borgpetersenii
bourretii
bouyouniensis
brenneri
broomii
chreensis
cinconiae
congkakensis
dzoumogneensis
ellinghausenii
ellisii
fainei
fletcheri
fluminis
gomenensis
gorisiae
haakeii
harrisiae
hartskeerlii
idonii
ilyithenensis
inadai
interrogans
iowaensis
jelokensis
johnsonii
kanakyensis
kemamanensis
kirschneri
kmetyi
kobayashii
koniamboensis
langatensis
levettii
licerasiae
macculloughii
mayottensis
meyeri
mgodei
milleri
montravelensis
mtsangambouensis
neocaledonica
noguchii
noumeaensis
ognonensis
perdikensis
perolatii
plouayensis
ryugenii
saintgironsiae
sanjuanensis
santarosai
sarikeiensis
selangorensis
semungkisensis
stimsonii
terpstrae
tipperaryensis
vanthielii
venezuelensis
weilii
wolbachii
wolffii
yasudae
yanagawae
Other
Unknown
|
yes |
- |
| serogroup | if not known, put ''not examined'' |
text |
- |
yes |
25 |
| serovar | if not known, put ''not examined'' |
text |
- |
yes |
25 |
| isolation_year | year, when the strain was isolated |
integer |
- |
no |
4 |
| sequencing_year | year, when the strain was sequenced |
integer |
- |
no |
4 |
| passage | Number of passages done in the lab, if not known put ''?'' |
text |
- |
no |
10 |
| world_region | world region, where the strain was isolated |
text |
Australia and New Zealand
Caribbean
Central America
Central Asia
Eastern Africa
Eastern Asia
Eastern Europe
Melanesia
Micronesia
Middle Africa
Northern Africa
Northern America
Northern Europe
Polynesia
South America
South-eastern Asia
Southern Africa
Southern Asia
Southern Europe
Western Africa
Western Asia
Western Europe
Unknown
|
yes |
- |
| country | country, where the 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]
Congo [Republic]
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
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
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 |
- |
| city | |
text |
- |
no |
20 |
| host | environment or the actual host. If not known, put ''Unknown'' |
text |
- |
yes |
30 |
| sample_type | body, fluid, organ, etc (e.g. blood, stools). If not known, put ''Unknown'' |
text |
- |
yes |
50 |
| source_lab | laboratory, where the sequencing was done |
text |
- |
yes |
35 |
| resistance_info | |
text |
- |
no |
30 |
| province | |
text |
- |
no |
20 |
| living_area | area, where the patient is living |
text |
rural
urban
|
no |
- |
| season | season, when the patient was infected (e.g. rainy season) |
text |
- |
no |
20 |
| age_yr | age of patient in years |
integer |
- |
no |
20 |
| age_mth | month part of age (0-11) for patients under 1 year old |
integer |
- |
no |
20 |
| sex | sex of patient |
text |
female
male
|
no |
- |
| profession | job of the patient, which could be connected to the infection source |
text |
- |
no |
20 |
| travel | country or region, where the patient was traveling recently |
text |
- |
no |
20 |
| infection_source | provide the infection source, if known |
text |
- |
no |
20 |
| other_diseases | |
text |
- |
no |
20 |
| ethnicity | ethnicity of the patient |
text |
- |
no |
20 |
| reinfection | |
text |
no
yes
|
no |
- |
| days_with_symptoms | Put the number of days with clinical symptoms |
integer |
- |
no |
20 |
| clinical_conditions | Separate conditions with a comma. Suggestions: Headache, Arthralgia, Myalgia, Nausea, Vomiting, Diarrhoea, Constipation, Cough, Rash, abdominal_pain, fever. |
text |
- |
no |
20 |
| seen_rat_last_two_weeks | |
text |
no
yes
|
no |
- |
| outcome_of_infection | |
text |
no
yes
|
no |
- |
| comments | any other comments |
text |
- |
no |
1000 |
| 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 |