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 | 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 | - |
duplicate_number | To be filled by curators only | text | - | no | 10 |
species | Taxonomic designation | text |
C. belfantii
C. diphtheriae C. pseudotuberculosis C. rouxii C. ulcerans Other Unknown |
yes | - |
biovar | biovar | text |
Belfanti
Gravis Intermedius Mitis Other Unknown |
no | - |
tox_gene_PCR | Identified virulence gene | text |
Positive
Negative N/A |
no | - |
tox_production_Elek | text |
Positive
Negative N/A |
no | - | |
isolation_year | year of isolation | integer | - | no | 4 |
city | city of isolation | text | - | no | 30 |
country | Country where strain was isolated. If any doubt, please search terms here:http://insdc.org/country.html | text | yes | - | |
state_or_locality | additional location info (state/region/department/city) | text | - | no | 60 |
travel_history | If recent travel from a country distinct from the isolation country | text | - | yes | 30 |
host | environment or host | text | - | yes | 30 |
source | clinical site, etc. | text | - | no | 50 |
infection_or_disease | kind of infection or disease | text | - | no | 40 |
other_source_info | text | - | no | 70 | |
resistance_info | Antimicrobial resistance pattern and/or mechanisms | text | - | no | 70 |
comments | Other comments | text | - | no | 1000 |
accession_number | text | - | no | 20 | |
epidemic_cluster | Epidemic clusters | text | - | no | 50 |
sender | user who sent data, links to users table | integer | Click for list of sender ids | yes | 4 |
curator | curator who entered data, links to user table | integer | Click for list of curator ids | yes | 4 |
date_entered | date first entered | date | - | yes | 10 |
datestamp | date last modified | date | - | yes | 10 |
outbreak_or_sporadic | Outbreak or sporadic | text | - | no | 10 |