dbSNP-Q

dbSNP-Q facilitates structured access to the NCBI dbSNP relational database for querying single nucleotide polymorphisms (SNPs) and other genetic variations across organisms to support interpretation in genome-wide association studies (GWAS).

Key Features:

• Local MySQL database: Provides a downloadable local MySQL implementation of the dbSNP database tailored to specific organisms.
• Task-oriented table classification: Classifies dbSNP tables according to common research tasks to guide task-specific queries.
• Custom task tables: Generates custom tables for each defined task to streamline query processes.
• Entity-relationship diagrams: Produces entity-relationship diagrams derived from relevant dbSNP tables to represent the relational structure of the data.
• Querying capabilities: Implements query tools for extracting data from dbSNP tables and columns for downstream analysis.

Scientific Applications:

• Genomic mapping: Query SNP coordinates and annotations for precise mapping tasks across organisms.
• Functional analysis of SNPs and genes: Support investigations into the functional properties and annotations of SNPs and genes.
• Allele frequency studies: Retrieve allele frequency data for population genetics and variation analyses.
• Experimental data integration: Combine experimental datasets with dbSNP variant information to aid interpretation of genetic association results.

Methodology:

Downloads and installs a local MySQL copy of dbSNP; classifies dbSNP tables by research task; generates custom tables per task; produces entity-relationship diagrams from dbSNP tables; and provides query tools to extract data from tables and columns.