aminoacid_variant


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
aminoacid_variant_id serial 10 √ nextval('aminoacid_variant_aminoacid_variant_id_seq'::regclass)
epitope_2697049_e_envelope_.aminoacid_variant_id Implied ConstraintR
epitope_2697049_m_membrane_.aminoacid_variant_id Implied ConstraintR
epitope_2697049_n_nucleocap.aminoacid_variant_id Implied ConstraintR
epitope_2697049_ns3_orf3a_p.aminoacid_variant_id Implied ConstraintR
epitope_2697049_ns6_orf6_pr.aminoacid_variant_id Implied ConstraintR
epitope_2697049_ns7a_orf7a_.aminoacid_variant_id Implied ConstraintR
epitope_2697049_ns7b_orf7b.aminoacid_variant_id Implied ConstraintR
epitope_2697049_ns8_orf8_pr.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp10.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp11.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp12_rna_d.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp13_helic.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp14_3_to_.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp15_endor.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp16_2_o_r.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp1_leader.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp2.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp3.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp4.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp5_3c_lik.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp6.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp7.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp8.aminoacid_variant_id Implied ConstraintR
epitope_2697049_nsp9.aminoacid_variant_id Implied ConstraintR
epitope_2697049_orf10_prote.aminoacid_variant_id Implied ConstraintR
epitope_2697049_orf1a_polyp.aminoacid_variant_id Implied ConstraintR
epitope_2697049_orf1ab_poly.aminoacid_variant_id Implied ConstraintR
epitope_2697049_spike_surfa.aminoacid_variant_id Implied ConstraintR
annotation_id int4 10 null
annotation.annotation_id aminoacid_variant_annotation_id_fkeyR
sequence_aa_original varchar 2147483647 null

Affected amino acid sequence from the corresponding reference sequence of the chosen Virus
sequence_aa_alternative varchar 2147483647 null

Changed amino acid sequence (in the target sequence) with respect to the reference one
start_aa_original int4 10 √ null

Coordinate where the change starts on the reference sequrence
variant_aa_length int4 10 null

Length of amino acid change in units of impacted residues
variant_aa_type varchar 2147483647 null

Type of amino acid change (SUB = substitution, INS = insertion, DEL = deletion)

Indexes

Constraint Name Type Sort Column(s)
aminoacid_variant_pkey Primary key Asc aminoacid_variant_id
aa__ann_id Performance Asc annotation_id
aa__start_original Performance Asc start_aa_original
aa__var_type_lower Performance
aa__var_type_normal Performance Asc variant_aa_type

Relationships

Close relationships within degrees of separation