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/city etc inside country | text | - | no | 50 |
year | year of isolation | integer | min: 1900; max: 2021 | no | 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 |
bronchopulmonary dysplasia
carrier chorioamnionitis infertility inflammation non-gonococcal urethritis premature birth other |
no | - |
source | biological source of sample; put other sources in detailed_source field | text |
cervical swab
semen urethral swab urine vaginal swab other |
no | - |
species | text |
Ureaplasma urealyticum
Ureaplasma parvum |
yes | - | |
serovar | integer | min: 1; max: 14 | no | 2 | |
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 |
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 |