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