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 inside country | text | - | no | 50 |
| town_or_city | this field is used in mapping so please try to ensure correct or most common spelling to facilitate GPS coordinates lookup. For US place names, please suffix 2-letter state code in square brackets, e.g. 'Dallas [TX]', to resolve ambiguities. | text | - | no | 50 |
| year | year of isolation | integer | min: 1900; max: 2023 | expected | 4 |
| age_yr | age in years | integer | min: 0; max: 120 | no | - |
| age_mth | month part of age (0-11) for patients under 1 year old | integer | min: 0; max: 11 | no | - |
| sex | sex of patient/carrier | text |
male
female |
no | - |
| disease | please put other diseases in detailed_disease field | text | yes | - | |
| detailed_disease | text | - | no | 60 | |
| source_category | text |
animal
environmental food human unknown |
yes | - | |
| source | biological source of sample; put other sources in detailed_source field | text | yes | - | |
| detailed_source | text | - | no | 60 | |
| epidemiology | text |
commensal
community acquired hospital acquired |
no | - | |
| oxacillin_mic_sign | indicate if MIC result is greater than, less than, or equal the set value | text |
<
> = |
no | - |
| oxacillin_mic | MIC in mg/l | float | - | no | 12 |
| oxacillin_SIR | oxacillin resistance - either S, I or R | text |
S
I R |
no | - |
| methicillin_mic_sign | indicate if MIC result is greater than, less than, or equal the set value | text |
<
> = |
no | - |
| methicillin_mic | MIC in mg/l | float | - | no | 12 |
| methicillin_SIR | oxacillin resistance - either S, I or R | text |
S
I R |
no | - |
| vancomycin_mic_sign | indicate if MIC result is greater than, less than, or equal the set value | text |
<
> = |
no | - |
| vancomycin_mic | MIC in mg/l | float | - | no | 12 |
| vancomycin_SIR | oxacillin resistance - either S, I or R | text |
S
I R |
no | - |
| biofilm_formation | text |
yes
no |
no | - | |
| spa_type | must begin with a small t followed by a number, e.g. t084 (or NT) | text | - | no | 12 |
| 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 |
| rMLST_database_accession | Accession number in rMLST genome database | integer | - | no | 30 |
| 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 |