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 | - |
| genbank_accession | Genbank accession number for full genome | text | - | no | 30 |
| country | country where strain was isolated | text | yes | - | |
| region | Department (Colombia, Peru), Province (Ecuador). When other country mark 'N/A' | text | yes | - | |
| city_town | city or town | text | - | no | 50 |
| host | text |
human
non-human unknown |
yes | - | |
| detailed_host | specify when non-human - please put other sources in comments field | text |
Lutzomyia verrucarum
Lutzomyia peruensis Lutzomyia maranonensis other |
no | - |
| year | year of sample collection | integer | min: 1900; max: 2023 | no | 4 |
| illness_phase | set N/A for non-human isolates | text |
acute phase (Oroya fever)
chronic phase (Peruvian Wart) asymptomatic N/A unknown |
yes | - |
| 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 | - |
| infection | text |
vectorial
mother-to-child transfusion other |
no | - | |
| source | biological source of sample (please put other sources in comments field) | text |
blood
LCR wart other |
no | - |
| epidemiology | text |
endemic
imported - internal movement from endemic to non endemic area within endemic countries imported - tourist/traveler returning from endemic countries imported - migrant from endemic countries living outside vectorial origin |
no | - | |
| outbreak | bool | - | no | - | |
| amoxicillin_plug_clavulanic_acid | MIC (mg/L) | text | - | no | - |
| amoxicillin_plug_clavulanic_acid_disk | halo (mm) | text | - | no | - |
| ampicillin | MIC (mg/L) | text | - | no | - |
| ampicillin_disk | halo (mm) | text | - | no | - |
| ceftazidime | MIC (mg/L) | text | - | no | - |
| ceftazidime_disk | halo (mm) | text | - | no | - |
| ceftriaxone | MIC (mg/L) | text | - | no | - |
| ceftriaxone_disk | halo (mm) | text | - | no | - |
| ciprofloxacin | MIC (mg/L) | text | - | no | - |
| ciprofloxacin_disk | halo (mm) | text | - | no | - |
| azithromycin | MIC (mg/L) | text | - | no | - |
| azithromycin_disk | halo (mm) | text | - | no | - |
| erythromycin | MIC (mg/L) | text | - | no | - |
| erythromycin_disk | halo (mm) | text | - | no | - |
| chloramphenicol | MIC (mg/L) | text | - | no | - |
| chloramphenicol_disk | halo (mm) | text | - | no | - |
| rifampicin | MIC (mg/L) | text | - | no | - |
| rifampicin_disk | halo (mm) | text | - | no | - |
| cotrimoxazole | MIC (mg/L) | text | - | no | - |
| cotrimoxazole_disk | halo (mm) | text | - | no | - |
| streptomycin | MIC (mg/L) | text | - | no | - |
| streptomycin_disk | halo (mm) | text | - | no | - |
| 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 |