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 | id - primary key | integer | - | yes | 6 |
| strain | strain name - use first letter of the genus followed by the first three letters of the species name_supergroup letter_host or strain additional code (e.g. Dmel_A_wMel). As substitute of species and genus (when unknown) use first three letters of the first taxonomic level known | text | - | yes | 20 |
| aliases | alternative names for strain | text (multiple) | - | no | - |
| references | PubMed ids that link to publications that describe or include record | integer (multiple) | - | no | - |
| supergroup | text | no | - | ||
| host_infection_status | text |
single infection
double infection AB other |
no | - | |
| host_common_name | text | - | yes | 30 | |
| host_genus | text | - | no | 20 | |
| host_species | text | - | no | 30 | |
| host_family | text | - | no | 30 | |
| host_order | text | - | yes | 30 | |
| host_class | text | - | yes | 30 | |
| host_phylum | text |
Arthropoda
Nematoda Spermatophyta other |
no | - | |
| host_phenotype | Wolbachia-induced phenotype | text |
CI
MK PI FI other |
no | - |
| host_source | text |
lab strain
field isolate other |
no | - | |
| lab_strain_name | text | - | no | 30 | |
| lab_strain_provider | Optionally choose one of the senders in the list. Leave blank if unknown | integer | Click for list of sender ids | no | 4 |
| country | country where strain was isolated | text | yes | - | |
| state_or_province | host original source | text | - | no | 30 |
| locality | host original source | text | - | no | 30 |
| location | GPS coordinate | geography_point | latitude [min: -90; max: 90], longitude [min: -180; max: 180] | no | - |
| date_coll | Use the format YYYY-MM-DD (if only the year is known, insert YYYY-01-01) | date | - | no | 12 |
| coll_ref | text | - | no | 20 | |
| dna_stage | text |
embryo
larva pupa young adult other |
no | - | |
| sex | text |
F
M other |
no | - | |
| dna_source | text | no | - | ||
| host_seq_id | Indicate host sequence identification code, if known | text | - | no | 20 |
| host_co1 | Insert host COI Genbank accession number | text | - | no | 20 |
| host_link | text | - | no | 50 | |
| comments | text | - | no | 1000 | |
| host_determined_by | Enter name and affiliation of person who determined the host. Leave blank if unknown | text | - | no | 150 |
| collected_by | Enter name and affiliation of person who collected the sample. Leave blank if unknown | text | - | no | 150 |
| additional_genes | Genbank search term for additional genes | text | - | no | 30 |
| sender | user who sent data, links to users table | integer | Click for list of sender ids | yes | 10 |
| curator | curator who entered data, links to user table | integer | Click for list of curator ids | yes | 10 |
| date_entered | date first entered | date | - | yes | 10 |
| datestamp | date last modified | date | - | yes | 10 |