How to create MySQL database with Entrez Gene Database Description and Files

http://jura.wi.mit.edu/entrez_gene/

"Entrez Gene 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 loading script 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 data loading script, which is written in Perl, will automatically download Entrez Gene data files, parse the data and load it into the MySQL database."

How to handle gzip files without decompressing

gzip -cd file.gz | head

How to start interactive session on tarbell

qsub -I

How to install virtualenv

http://iamzed.com/2009/05/07/a-primer-on-virtualenv/

How to start shiny application

Fire up R/RStudio, make sure you have the shiny package installed, and type

   library(shiny)
   runApp('~/vcs/rcg/haky')

where you replace '~/vcs/rcg/haky' with the path to the directory containing the ui.R, server.R and screen.tiff files, and the data subdirectory.  It should fire right up; you can then stop it by sending R an interrupt.