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 | city/region inside country | text | - | no | 50 |
year | year of isolation | integer | min: 1900; max: 2021 | no | 4 |
host | if other, please add host to the comments field | text |
cattle
pig poultry other unknown |
yes | - |
age_yr | age in years | integer | min: 0; max: 120 | no | - |
age_mth | month part of age (0-23) for hosts under 2 years old | integer | min: 0; max: 23 | no | - |
physiological_status | physiological status of host/carrier - please add other status to the comments field | text |
lactating adult cow
non-lactating adult cow non-lactating nulliparous heifer other |
no | - |
sex | sex of patient | text |
male
female |
no | - |
disease | please put other diseases in comments field | text |
asymptomatic/subclinical mastitis
clinical mastitis healthy intramammary infection other |
no | - |
source | biological source of sample - please put other detailed sources in comments field | text |
bulk tank milk sample
farm environment milk sample from mammary gland skin swab from epidermal lesion or wound skin swab from extramammary body site skin swab from teat or udder other unknown |
yes | - |
epidemiology | basis of study | text |
clinical diagnostic sample
dairy herd field study swine herd field study other |
no | - |
species_identification | species identification method | text |
biochemical typing
growth characteristics DNA sequence-based typing PCR-based typing unknown |
yes | - |
coagulase_phenotype | coagulase activity | text |
+
- |
no | - |
methicillin_susceptibility | phenotypic classification of potential relevance | text |
R
S |
no | - |
antimicrobial_susceptibility | antimicrobial susceptibility testing of isolate was completed | text |
yes
no |
no | - |
ENA_accession | ENA SRA accession number to access short read data | text | - | no | 30 |
NCBI_nucleotide_accession | NCBI nucleotide number | text | - | no | 30 |
NCBI_assembly_accession | NCBI assembly number | text | - | no | 30 |
NCBI_biosample_accession | NCBI biosample number | text | - | no | 30 |
NCBI_bioproject_accession | NCBI bioproject number | text | - | 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 |