Description of database fields
Provenance/primary metadata
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 | 6 |
| isolate | isolate name | text | - | yes | 30 |
| 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 (multiple) | - | no | 30 |
| year | year of isolation | integer | min: 1900; max: 2020 | no | 4 |
| date_sampled | date sample was taken | date | max: 2020-10-22 | no | 10 |
| isoyear_sampled | ISO year (this may be different from the Gregorian year recorded in the year field) - value is determined automatically from the contents of the date_sampled field. This cannot be updated manually | integer | - | no | - |
| week_sampled | week of the year - value is determined automatically from the contents of the date_sampled field. This cannot be updated manually | integer | - | no | - |
| date_received | date received by laboratory (may be approximate) | date | max: 2020-10-22 | no | 10 |
| non_culture | result comes from non-culture diagnosis | bool | - | no | - |
| epidemiological_year | epidemiological year for study in format mm/yyyy-mm/yyyy | text | - | no | 15 |
| age_yr | age in years | integer | min: 0; max: 120 | no | - |
| age_range | age range - this will be populated automatically if you enter a value for age_yr | text |
<1
1-4 5-14 15-24 25-44 45-64 65+ |
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 comments field | text |
carrier
meningitis septicaemia meningitis and septicaemia uncomplicated gonorrhoea disseminated gonococcal infection invasive (unspecified/other) other |
no | - |
| source | biological source of sample - please put other sources in comments field | text |
blood
CSF joint fluid rectal swab sputum throat swab urethral swab other |
no | - |
| epidemiology | text | no | - | ||
| species | text | yes | - | ||
| serogroup | group determined by serological means. If you select 'other' please provide further details in the comments field. Values in this field from legacy data may have been determined by genotypic means, but for new data this should only represent values determined by serology. | text | no | - | |
| genogroup | group determined by genotypic means | text | no | - | |
| genogroup_notes | details about genogroup prediction | text | - | no | 512 |
| capsule_group | capsular group value is determined automatically from the contents of the serogroup and genogroup fields. This cannot be updated manually | text | - | no | - |
| MLEE_designation | text | no | - | ||
| serotype | text | - | no | 15 | |
| sero_subtype | text | - | no | 15 | |
| ET_no | text | - | no | 10 | |
| penicillin | MIC in mg/l | text | - | no | 20 |
| penicillin_range | MIC value range | text |
<=0.06 (susceptible)
>0.06 - 1 (intermediate) >1 (resistant) |
no | - |
| amoxicillin | MIC in mg/l | text | - | no | 20 |
| sulphonamide | MIC in mg/l | text | - | no | 20 |
| ceftriaxone | MIC in mg/l | text | - | no | 20 |
| ceftriaxone_range | MIC value range | text |
<=0.06 (susceptible)
>0.06 (not susceptible) |
no | - |
| chloramphenicol | MIC in mg/l | text | - | no | 20 |
| chloramphenicol_range | MIC value range | text |
<=2 (susceptible)
>2 - <8 (intermediate) >=8 (resistant) |
no | - |
| cefotaxime | MIC in mg/l | text | - | no | 20 |
| cefotaxime_range | MIC value range | text |
<=0.06 (susceptible)
>0.06 (not susceptible) |
no | - |
| rifampicin | MIC in mg/l | text | - | no | 20 |
| rifampicin_range | MIC value range | text |
<=1 (susceptible)
>1 (resistant) |
no | - |
| ciprofloxacin | MIC in mg/l | text | - | no | 20 |
| ciprofloxacin_range | MIC value range | text |
<=0.03 (susceptible)
>0.03 - <0.12 (intermediate) >=0.12 (resistant) |
no | - |
| tetracycline | MIC in mg/l | text | - | no | 20 |
| cefixime | MIC in mg/l | text | - | no | 20 |
| azithromycin | MIC in mg/l | text | - | no | 20 |
| spectinomycin | MIC in mg/l | text | - | no | 20 |
| 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 |
| private_project | Leave this blank unless you know what you are doing - entering anything here will hide your data in the public interface | text | - | no | 30 |
| comments | any other comments | text (multiple) | - | no | 500 |
| 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 |
Secondary metadata
Risk factors
| field name | comments | data type | allowed values | required | maximum length (characters) |
|---|---|---|---|---|---|
| UK_school_year | School year that sample subject belonged to (UK) | text |
12
13 other not in full-time education |
no | - |
| persons_in_household | Number of people in the subject's household | integer | min: 1; max: 10 | no | - |
| antibiotic_use | Whether or not the subject recently took antibiotics | text |
yes [currently]
stopped [last month] stopped [last week] no |
no | - |
| current_URTI | current cold or sore throat | boolean | - | no | - |
| cigarettes_per_day | cigarettes smoked per day | text |
0
1-5 6-10 11-20 21+ |
no | - |
| ecigarettes_per_week | Number of e-cigarettes smoked per week | text |
0
1-2 3-6 7+ |
no | - |
| waterpipes_per_month | Number of water pipes (shisha) smoked per month | text |
0
1 2 3-4 5+ |
no | - |
| passive_smoking | exposure to passive smoking (inside or outside) | text |
yes [undefined]
no yes [inside] yes [outside] |
no | - |
| pubs_clubs_per_week | attendance at pubs or clubs per week | text |
0
1 2-3 4-5 6-7 |
no | - |
| persons_kissed_past_week | number of persons kissed in the past week | text |
0
1 2-3 4+ |
no | - |
| regular_partner | regular girlfriend or boyfriend | boolean | - | no | - |
| regular_partner_smokes | regular girlfriend or boyfriend who smokes | boolean | - | no | - |
| ethnicity | - | text |
white
asian black mixed other |
no | - |
Vaccines
| field name | comments | data type | allowed values | required | maximum length (characters) |
|---|---|---|---|---|---|
| Bexsero_reactivity | Prediction of Bexsero coverage. This field is automatically populated. | text |
exact match
cross-reactive none insufficient data |
no | - |
| Bexsero_notes | Explanation of Bexsero_reactivity result. This field is automatically populated. | text | - | no | - |
| Trumenba_reactivity | Prediction of Trumenba coverage. This field is automatically populated. | text |
exact match
cross-reactive none insufficient data |
no | - |
| Trumenba_notes | Explanation of Trumenba_reactivity result. This field is automatically populated. | text | - | no | - |