| 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 | - |
| 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
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 |
- |
| region | Region/city etc inside country |
text |
- |
no |
30 |
| year | year of isolation |
integer |
- |
no |
4 |
| month | month of isolation |
integer |
1
2
3
4
5
6
7
8
9
10
11
12
|
no |
- |
| human_disease | please put other diseases in comments field |
text |
gastrointestinal tract syndromes
skin and soft tissue infections
blood borne infections
respiratory tract infections
urogenital tract infections
other
|
no |
- |
| human_cases | please put other cases in comments field |
text |
healthy contact
foodborne
waterborne
trauma
nosocomial
bites - zoonoses
post-surgery
natural disaster
other
|
no |
- |
| source_of_human_sample | biological source of sample, please put other source in comments field |
text |
stools
diarrhea
blood
ascitic fluid
wounds
urine
soft tissue
sputum
nasopharyngeal and tracheal secretion
rectal swabs
other
|
no |
- |
| human_age_yr | age in years |
integer |
- |
no |
- |
| human_age_mth | month part of age (1-12) for patients under 1 year old |
integer |
1
2
3
4
5
6
7
8
9
10
11
12
|
no |
- |
| water_strains | source of water sample; please put other source water in comments fields |
text |
fresh water
brackish - saline water
drinking water
other
|
no |
- |
| food_strains | source of food sample; please put other food source in comments fields |
text |
milk and dairy products
seafood
vegetables
poultry
meats (beef,pork,veal, etc)
other
|
no |
- |
| environmental_strains | source of environmental sample |
text |
- |
no |
40 |
| fish_and_aquatic_organisms_strains | species of isolation |
text |
- |
no |
40 |
| other_animal_strains | species of isolation |
text |
- |
no |
40 |
| species | please put other species in comments field |
text |
Aeromonas allosaccharophila
Aeromonas aquariorum
Aeromonas bestiarum
Aeromonas bivalvium
Aeromonas caviae
Aeromonas encheleia
Aeromonas eucrenophila
Aeromonas hydrophila
Aeromonas jandaei
Aeromonas media
Aeromonas molluscorum
Aeromonas popoffii
Aeromonas salmonicida
Aeromonas schubertii
Aeromonas simiae
Aeromonas sobria
Aeromonas spp.
Aeromonas tecta
Aeromonas trota or A. enteropelogenes
Aeromonas veronii
other
|
no |
- |
| serogroup | if you select 'other' please provide further details in the comments field |
text |
- |
no |
20 |
| DNA_hybridization_group | if you select 'other' please provide further details in the comments field |
text |
HG1
HG2
HG3
HG4
HG5
HG6
HG7
HG8
HG9
HG10
HG11
HG12
HG13
HG14
HG15
HG16
HG17
other
|
no |
- |
| motility | |
integer |
0
1
|
no |
- |
| Voges_Proskauer | |
integer |
0
1
|
no |
- |
| gas_from_glucose | |
integer |
0
1
|
no |
- |
| acid_from_L_aribinose | |
integer |
0
1
|
no |
- |
| citrate | |
integer |
0
1
|
no |
- |
| acid_from_sucrose | |
integer |
0
1
|
no |
- |
| ampicillin_R | |
integer |
0
1
|
no |
- |
| cephalothin_R | |
integer |
0
1
|
no |
- |
| esculin_hydrolysis | |
integer |
0
1
|
no |
- |
| indole | |
integer |
0
1
|
no |
- |
| acid_from_D_mannitol | |
integer |
0
1
|
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 |