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 | - |
country | country where strain was isolated | text | yes | - | |
region | Region/city etc inside country | text | - | no | 30 |
year | year of isolation | integer | - | no | 4 |
month | month of isolation | integer | 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 | no | - | |
source_of_human_sample | biological source of sample, please put other source in comments field | text | 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 | 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 | 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 | 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 |
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 |