Tables


SchemaSpy Analysis of epivirusurf

Generated on Thu Nov 03 18:47 CET 2022

XML Representation
Insertion Order Deletion Order
TABLES 14
VIEWS 30
COLUMNS 831
Constraints 15
Anomalies 0
Routines 0

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