239
edits
Changes
From Genome Analysis Wiki
Jump to navigationJump to search→Creating a SQLite database
=== Creating a SQLite database ===
=== Creating a SQLite database ===
As a starting point, we provide a SQLite database with the following tables:
As a starting point, we provide a SQLite database based on UCSC human genome '''build hg18''', which includes the following tables:
* snp_pos: SNP positions
* snp_pos: SNP positions
* snp_set: maps each SNP to a "set" - for example, all SNPs on the Illumina 1M chip
* snp_set: maps each SNP to a "set" - for example, all SNPs on the Illumina 1M chip
* refsnp_trans: a table that maps SNPs from previous builds to the current build
* refsnp_trans: a table that maps SNPs from previous builds to the current build
To create your own database, we provide a script <code>bin/dbmeister.py</code> that can insert these tables for you. We recommend creating your own database file, rather than inserting tables into the default LocusZoom database. This script is capable of using python's built-in sqlite support, but for faster insertion of tables (about 2x faster), we recommend installing sqlite3 from [http://www.sqlite.org/ www.sqlite.org].
To create your own database, we provide a script <code>bin/dbmeister.py</code> that can insert these tables for you. We recommend creating your own database file, rather than inserting tables into the default LocusZoom database. This script is capable of using python's built-in sqlite support, but for faster insertion of tables (about 2x faster), we recommend installing sqlite3 from [http://www.sqlite.org/ www.sqlite.org].
