virus mutation db

Tables (9)

Binding_Effect

  • binding_effect_id — INT — Primary key — NOT NULL
  • mutation_id — INT — Foreign key → Mutation.mutation_id — NOT NULL
  • target_id — INT — Foreign key → Binding_Target.target_id — NOT NULL
  • affinity_change — VARCHAR(50)
  • measurement_method — VARCHAR(100)
  • confidence_score — DECIMAL(4,2)
  • description — TEXT

Binding_Target

  • target_id — INT — Primary key — NOT NULL
  • organism_id — INT — Foreign key → Organism.organism_id
  • target_name — VARCHAR(100) — NOT NULL
  • target_type — VARCHAR(50)
  • biological_role — TEXT

Domain

  • domain_id — INT — Primary key — NOT NULL
  • protein_id — INT — Foreign key → Protein.protein_id — NOT NULL
  • domain_name — VARCHAR(100) — NOT NULL
  • start_position — INT — NOT NULL
  • end_position — INT — NOT NULL
  • domain_function — TEXT

Mutation

  • mutation_id — INT — Primary key — NOT NULL
  • protein_id — INT — Foreign key → Protein.protein_id — NOT NULL
  • mutation_name — VARCHAR(50) — NOT NULL
  • position — INT — NOT NULL
  • original_aa — CHAR(1) — NOT NULL
  • mutated_aa — CHAR(1) — NOT NULL
  • mutation_type — VARCHAR(50)

Mutation_Publication

  • mutation_id — INT — Foreign key → Mutation.mutation_id — NOT NULL
  • publication_id — INT — Foreign key → Publication.publication_id — NOT NULL
  • evidence_type — VARCHAR(100)
  • summary — TEXT

Organism

  • organism_id — INT — Primary key — NOT NULL
  • scientific_name — VARCHAR(100) — NOT NULL
  • common_name — VARCHAR(100)
  • taxonomy_id — VARCHAR(50)
  • organism_type — VARCHAR(50) — NOT NULL

Protein

  • protein_id — INT — Primary key — NOT NULL
  • organism_id — INT — Foreign key → Organism.organism_id — NOT NULL
  • protein_name — VARCHAR(100) — NOT NULL
  • gene_name — VARCHAR(100)
  • accession_number — VARCHAR(50)
  • protein_length — INT
  • function_summary — TEXT

Publication

  • publication_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • journal — VARCHAR(100)
  • published_year — INT
  • doi — VARCHAR(100)

Risk_Assessment

  • risk_id — INT — Primary key — NOT NULL
  • mutation_id — INT — Foreign key → Mutation.mutation_id — NOT NULL
  • effect_type — VARCHAR(100) — NOT NULL
  • risk_level — VARCHAR(50) — NOT NULL
  • confidence_score — DECIMAL(4,2)
  • interpretation — TEXT
  • assessment_date — DATE