Creating a local MySQL version of NCBI's Entrez Gene database
is NCBI's repository for gene-specific information. Access to this information either through the Entrez Gene website or by flat files via NCBI's
ftp site can be time consuming and limiting in regards to the number of and what questions you can ask about the data. A better solution for
intense data mining is to create a relational database.
We offer our MySQL based database and data parsing/loading scripts as an easy-to-implement solution to this problem. While the ER diagram describes
the database we created, we also offer the SQL syntax for both the tables and indexes. The scripts will
automatically download Entrez Gene data files, parse them, and load them into a MySQL database.
Files to Download
Descriptions of The Tables