Related Experiment Video
Updated: May 28, 2026

Targeted Next-generation Sequencing and Bioinformatics Pipeline to Evaluate Genetic Determinants of Constitutional Disease
Published on: April 4, 2018
SNPpy--database management for SNP data from genome wide association studies
Faheem Mitha1, Herodotos Herodotou, Nedyalko Borisov
1Department of Biostatistics and Bioinformatics, Duke University, Durham, North Carolina, United States of America. faheem@faheem.info
SNPpy is an open-source database system for managing Genome-Wide Association Studies (GWAS) genotype data. It facilitates merging and filtering data for meta-analyses, offering a practical solution for centralized GWAS data management.
Area of Science:
- Bioinformatics
- Genetics
- Computational Biology
Background:
- Managing large genotype datasets from Genome-Wide Association Studies (GWAS) presents significant challenges.
- Existing methods often lack integrated solutions for data merging, filtering, and validation.
Purpose of the Study:
- To introduce SNPpy, a novel hybrid script database system for efficient genotype data management in GWAS.
- To enable seamless merging of study data with external resources like HapMap and across multiple GWAS for meta-analyses.
Main Methods:
- SNPpy utilizes Python with the SQLAlchemy library and a PostgreSQL database backend.
- The system supports data import from commercial genotyping platforms and the HapMap Project.
- It incorporates data filtering based on phenotype and Single-Nucleotide Polymorphism (SNP) data.
Main Results:
- SNPpy successfully imported genotype and annotation data from two GWAS studies and the HapMap Project.
- The system can export processed datasets into standard formats compatible with statistical analysis software.
- Demonstrated utility in merging and filtering genotype data for downstream analyses.
Conclusions:
- SNPpy provides integrated management and manipulation of GWAS genotype and phenotype data.
- The system offers flexible data validation and filtering capabilities, including patient data validation.
- SNPpy is a practical, extensible, and open-source solution for centralized GWAS data management.
Related Concept Videos
Genome-wide Association Studies-GWAS
GWAS does not require the identification of the target gene involved in...
Single Nucleotide Polymorphisms-SNPs
Comparing Copy Number Variations and SNPs
Copy number variations or CNVs are the structural variations that cover more than 1kb of DNA sequence. The single nucleotide polymorphism (SNP), on the other hand, is a single nucleotide change or a point mutation that is found in more than 1%...
Statistical Software for Data Analysis and Clinical Trials

