-- MySQL dump 10.11
--
-- Host: localhost    Database: rn4
-- ------------------------------------------------------
-- Server version	5.0.67

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `rgdGene2Raw`
--

DROP TABLE IF EXISTS `rgdGene2Raw`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `rgdGene2Raw` (
  `gene_rgd_id` varchar(255) default NULL,
  `symbol` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `gene_desc` text,
  `chromosome_celera` varchar(255) default NULL,
  `chromosome_31` varchar(255) default NULL,
  `chromosome_34` varchar(255) default NULL,
  `fish_band` varchar(255) default NULL,
  `start_pos_celera` varchar(255) default NULL,
  `stop_pos_celera` varchar(255) default NULL,
  `strand_celera` varchar(255) default NULL,
  `start_pos_31` varchar(255) default NULL,
  `stop_pos_31` varchar(255) default NULL,
  `strand_31` varchar(255) default NULL,
  `start_pos_34` varchar(255) default NULL,
  `stop_pos_34` varchar(255) default NULL,
  `strand_34` varchar(255) default NULL,
  `curated_ref_rgd_id` text,
  `curated_ref_pubmed_id` text,
  `uncurated_pubmed_id` text,
  `ratmap_id` varchar(255) default NULL,
  `entrez_gene` varchar(255) default NULL,
  `uniprot_id` text,
  `rhdb_id` text,
  `uncurated_ref_medline_id` text,
  `genbank_nucleotide` text,
  `tigr_id` text,
  `genbank_protein` text,
  `unigene_id` text,
  `gdb_id` text,
  `sslp_rgd_id` text,
  `sslp_symbol` text,
  `old_symbol` text,
  `old_name` text,
  `qtl_rgd_id` text,
  `qtl_symbol` text,
  `nomenclature_status` text,
  `splice_rgd_id` text,
  `splice_symbol` text,
  `gene_type` varchar(255) default NULL,
  `ensembl_id` text,
  KEY `gene_rgd_id` (`gene_rgd_id`),
  KEY `symbol` (`symbol`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-02-26 13:30:04
