Database Properties
Database Type: PostgreSQL - 10.22 (Ubuntu 10.22-0ubuntu0.18.04.1)
Tables
| Table / View | Children | Parents | Columns | Type | Comments | 
|---|---|---|---|---|---|
| aminoacid_variant | 28 | 1 | 7 | Table | The Aminoacid Variant table contains subsequences of proteins (i.e., only of a subset of all annotations) that differ from the reference amino acid sequence of the virus species.  | 
                                    
| virus | 2 | 0 | 11 | Table | The Virus table describes the viruses to which sequences belong; they are described by a complex taxonomy.  | 
                                    
| epitope_fragment | 0 | 1 | 5 | Table | The EpitopeFragment table contains the segments of non linear epitopes (each of which is contained within one comprehensive epitope).  | 
                                    
| host_specie | 3 | 0 | 3 | Table | The HostSpecie table represents the identification of the animal species both involved in the extraction of biological material to be sequenced and in the epitope design.  | 
                                    
| variant_impact | 0 | 1 | 5 | Table | We annotate each variant with its predicted impact (using SnpEff).  | 
                                    
| nucleotide_sequence | 0 | 1 | 2 | Table | The table holds string sequences related to the fulls sequence record.  | 
                                    
| annotation_sequence | 0 | 2 | 5 | Table | The table holds sequences related to the specific annotation.  | 
                                    
| experiment_type | 1 | 0 | 4 | Table | Sequences are derived from one experiment of a given type (described in the Experiment Type table) performed to analyse the biological material.  | 
                                    
| epitope | 29 | 2 | 19 | Table | The Epitope table describes the epitopes extracted from IEDB.  | 
                                    
| annotation | 2 | 1 | 8 | Table | Annotations include a number of subsequences representing segments (with their coordinates) of the original sequence with a particular type.  | 
                                    
| sequence | 4 | 4 | 17 | Table | The Sequence table represents a viral sequence of either DNA or RNA. In both cases, sequences are composed of nucleotides (A, C, G, T).  | 
                                    
| nucleotide_variant | 2 | 1 | 8 | Table | The Nucleotide Variant table contains subsequences of the main sequence that differ from the reference sequence of the same virus species.  | 
                                    
| host_sample | 2 | 1 | 12 | Table | An assay is performed on a tissue extracted from an organism that has hosted the virus for an amount of time; this information is collected in the HostSample table.  | 
                                    
| sequencing_project | 1 | 0 | 5 | Table | The Sequencing Project table represents a project in which a particular sequencing activity is carried out.  | 
                                    
| epitope_2697049_nsp7 | 0 | 2 | 25 | View | |
| epitope_2697049_nsp6 | 0 | 2 | 25 | View | |
| epitope_2697049_nsp9 | 0 | 2 | 25 | View | |
| epitope_2697049_nsp8 | 0 | 2 | 25 | View | |
| epitope_2697049_nsp3 | 0 | 2 | 25 | View | |
| epitope_2697049_nsp14_3_to_ | 0 | 2 | 25 | View | |
| epitope_2697049_nsp2 | 0 | 2 | 25 | View | |
| host_sample_view | 0 | 2 | 12 | View | |
| epitope_2697049_ns7a_orf7a_ | 0 | 2 | 25 | View | |
| epitope_2697049_nsp4 | 0 | 2 | 25 | View | |
| epitope_2697049_orf10_prote | 0 | 2 | 25 | View | |
| epitope_2697049_orf1a_polyp | 0 | 2 | 25 | View | |
| epitope_2697049_e_envelope_ | 0 | 2 | 25 | View | |
| epitope_2697049_nsp11 | 0 | 2 | 25 | View | |
| epitope_2697049_orf1ab_poly | 0 | 2 | 25 | View | |
| epitope_2697049_nsp10 | 0 | 2 | 25 | View | |
| epitope_2697049_ns6_orf6_pr | 0 | 2 | 25 | View | |
| epitope_2697049_ns3_orf3a_p | 0 | 2 | 25 | View | |
| epitope_2697049_ns8_orf8_pr | 0 | 2 | 25 | View | |
| epitope_2697049_nsp13_helic | 0 | 2 | 25 | View | |
| epitope_2697049_nsp16_2_o_r | 0 | 2 | 25 | View | |
| epitope_2697049_nsp5_3c_lik | 0 | 2 | 25 | View | |
| epitope_2697049_nsp15_endor | 0 | 2 | 25 | View | |
| epitope_2697049_spike_surfa | 0 | 2 | 25 | View | |
| epitope_2697049_n_nucleocap | 0 | 2 | 25 | View | |
| epitope_2697049_nsp1_leader | 0 | 2 | 25 | View | |
| nucleotide_variant_annotated | 0 | 1 | 8 | View | |
| epitope_2697049_nsp12_rna_d | 0 | 2 | 25 | View | |
| epitope_2697049_ns7b_orf7b | 0 | 2 | 25 | View | |
| epitope_2697049_m_membrane_ | 0 | 2 | 25 | View |