Description of database fields
Order columns by clicking their headings. Reset default order.
| field name | comments | data type | allowed values | required |
|---|---|---|---|---|
| id | primary key | int | - | yes |
| isolate | isolate name | text | - | yes |
| 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 Northern Mariana Islands North Korea North Macedonia 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 Ukraine United Arab Emirates Uruguay USA US Minor Outlying Islands US Virgin Islands Uzbekistan Vanuatu Venezuela Vietnam Wallis and Futuna Islands Western Sahara Yemen Zambia Zimbabwe Unknown |
yes |
| region | region/city etc inside country | text | - | no |
| year | year of isolation | int | min: 1900; max: 2019 | no |
| date_received | date received by laboratory (may be approximate) | date | max: 2019-06-26 | no |
| date_sampled | date sample was taken | date | max: 2019-06-26 | no |
| non_culture | result comes from non-culture diagnosis | bool | - | no |
| epidemiological_year | epidemiological year for study in format mm/yyyy-mm/yyyy | text | - | no |
| age_yr | age in years | int | min: 0; max: 120 | no |
| age_mth | month part of age (0-11) for patients under 1 year old | int | 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 |
carrier healthy contact sporadic case endemic epidemic MSM MSW pandemic |
no | |
| species | text |
Neisseria meningitidis Neisseria lactamica Neisseria gonorrhoeae Neisseria animalis Neisseria animaloris Neisseria bacilliformis Neisseria bergeri Neisseria canis Neisseria cinerea Neisseria dentiae Neisseria dentrificans Neisseria dumasiana Neisseria elongata Neisseria elongata subsp. elongata Neisseria elongata subsp. glycolytica Neisseria elongata subsp. nitroreducens Neisseria flava Neisseria flavescens Neisseria iguanae Neisseria macacae Neisseria mucosa Neisseria mucosa subsp. heidelbergensis Neisseria musculi Neisseria oralis Neisseria perflava Neisseria polysaccharea Neisseria shayeganii Neisseria sicca Neisseria skkuensis Neisseria subflava Neisseria tadorna Neisseria wadsworthii Neisseria weaveri Neisseria zoodegmatis Neisseria sp. Non-Neisseria sp. |
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 |
A B C E W W/Y X Y Z H J K L W NG other |
no |
| genogroup | group determined by genotypic means | text |
A B C E W W/Y X Y Z H J K L cnl |
no |
| 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 |
A4 Cluster ET-37 Complex ET-5 Complex Lineage 3 Lineage IV Subgroup I Subgroup II Subgroup III Subgroup IV-I Subgroup IV-II Subgroup V Subgroup VI Subgroup VII Subgroup VIII Subgroup IX Subgroup X other |
no | |
| serotype | text | - | no | |
| sero_subtype | text | - | no | |
| ET_no | text | - | no | |
| penicillin | MIC in mg/l | text | - | no |
| penicillin_range | MIC value range | text |
<=0.06 (susceptible) >0.06 - 1 (intermediate) >1 (resistant) |
no |
| amoxicillin | MIC in mg/l | text | - | no |
| sulphonamide | MIC in mg/l | text | - | no |
| ceftriaxone | MIC in mg/l | text | - | no |
| ceftriaxone_range | MIC value range | text |
<=0.06 (susceptible) >0.06 (not susceptible) |
no |
| chloramphenicol | MIC in mg/l | text | - | no |
| chloramphenicol_range | MIC value range | text |
<=2 (susceptible) >2 - <8 (intermediate) >=8 (resistant) |
no |
| cefotaxime | MIC in mg/l | text | - | no |
| cefotaxime_range | MIC value range | text |
<=0.06 (susceptible) >0.06 (not susceptible) |
no |
| rifampicin | MIC in mg/l | text | - | no |
| rifampicin_range | MIC value range | text |
<=1 (susceptible) >1 (resistant) |
no |
| ciprofloxacin | MIC in mg/l | text | - | no |
| 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 |
| cefixime | MIC in mg/l | text | - | no |
| azithromycin | MIC in mg/l | text | - | no |
| spectinomycin | MIC in mg/l | text | - | no |
| ENA_accession | ENA SRA accession number to access short read data | text | - | no |
| 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 |
| comments | any other comments | text | - | no |
| sender | sender unique name, link to users | int | Click for list of sender ids | yes |
| curator | curator who entered data,link to users | int | Click for list of curator ids | yes |
| date_entered | date first entered | date | - | yes |
| datestamp | date last modified | date | - | yes |