# MySQL dump 8.7
#
# Host: 10.9.208.43    Database: schz_db
#--------------------------------------------------------
# Server version	4.0.18

#
# Table structure for table 'disease'
#

DROP TABLE IF EXISTS `disease`;
CREATE TABLE `disease` (
  `disease_id` int(11) NOT NULL auto_increment,
  `rep_id` int(11),
  `short_name` varchar(15),
  `full_name` varchar(100),
  `name` varchar(15),
  `ens_name` varchar(15) DEFAULT '' NOT NULL,
  `norm_min` int(11),
  `norm_max` int(11),
  `dis_min` int(11),
  `dis_max` int(11),
  `locus` char(1),
  `anticipation` char(2),
  PRIMARY KEY (`disease_id`)
)/*! type=MyISAM */;

#
# Dumping data for table 'disease'
#

LOCK TABLES `disease` WRITE;
INSERT INTO `disease` VALUES (1,5389649,'AIB-I','prostate cancer risk','NCOA3','ENSG00000124151',29,29,29,29,'Q','\r'),(2,5390869,'AIB-I','prostate cancer risk','NCOA3','ENSG00000124151',29,29,29,29,'Q','\r'),(3,5390913,'AIB-I','prostate cancer risk','NCOA3','ENSG00000124151',29,29,29,29,'Q','\r'),(4,1258282,'DRPLA','dentatorubral-pallidoluysian atrophy / Haw River Syndrome','DRPLA','ENSG00000111676',7,25,49,75,'Q','y\r'),(5,616211,'HD','Huntington\'s Disease','HD','ENSG00000125387',10,34,40,121,'Q','y\r'),(6,7459156,'HDL2','Huntington\'s Disease-like 2','JPH3','ENSG00000154118',5,18,50,60,'Q','\r'),(7,6368709,'SBMA','spinal and bulbar muscular atrophy','AR','ENSG00000169083',9,36,38,62,'Q','y\r'),(8,6368728,'SBMA','spinal and bulbar muscular atrophy','AR','ENSG00000169083',9,36,38,62,'Q','y\r'),(9,2313414,'SCA1','spinocerebellar ataxia 1','SCA1','ENSG00000124788',6,39,40,82,'Q','y\r'),(10,2313506,'SCA1','spinocerebellar ataxia 1','SCA1','ENSG00000124788',6,39,40,82,'Q','y\r'),(11,7863737,'SCA2','spinocerebellar ataxia 2','SCA2','ENSG00000089232',13,33,32,200,'Q','y\r'),(12,7863764,'SCA2','spinocerebellar ataxia 2','SCA2','ENSG00000089232',13,33,32,200,'Q','y\r'),(13,6832514,'SCA3_MJD','spinocerebellar ataxia 3 / Machado-Joseph Disease','MJD','ENSG00000066427',13,44,55,84,'Q','y\r'),(14,3820399,'SCA6','spinocerebellar ataxia 6','CACNA1A','ENSG00000141837',4,18,20,29,'Q','\r'),(15,4285758,'SCA7','spinocerebellar ataxia 7','SCA7','ENSG00000163635',4,35,37,306,'Q','y\r'),(16,3847439,'SCA17','spinocerebellar ataxia 17','TBP','ENSG00000112592',25,42,47,63,'Q','\r'),(17,4038874,'ISS','infantile spasm syndrome','ARX','ENSG00000004848',10,16,17,23,'A','\r'),(18,2034334,'CCD','cleidocranial dysplasia','RUNX2','ENSG00000124813',11,17,27,0,'A','y\r'),(19,2034419,'CCD','cleidocranial dysplasia','RUNX2','ENSG00000124813',11,17,27,0,'A','y\r'),(20,0,'BBP','blepharophimosis/ptosis/epicanthus invensus syndrome type B','FOXL2','ENSG00000183770',14,14,10,24,'A','\r'),(21,5609071,'HFGS','hand-foot-genital syndrome','HOXA13','ENSG00000106031',18,18,26,26,'A','\r'),(22,5609101,'HFGS','hand-foot-genital syndrome','HOXA13','ENSG00000106031',18,18,26,26,'A','\r'),(23,5609150,'HFGS','hand-foot-genital syndrome','HOXA13','ENSG00000106031',18,18,26,26,'A','\r'),(24,5609173,'HFGS','hand-foot-genital syndrome','HOXA13','ENSG00000106031',18,18,26,26,'A','\r'),(25,5321791,'syn','synpolydactyly','HOXD13','ENSG00000128714',15,15,22,29,'A','\r'),(26,5321842,'syn','synpolydactyly','HOXD13','ENSG00000128714',15,15,22,29,'A','\r'),(27,5321871,'syn','synpolydactyly','HOXD13','ENSG00000128714',15,15,22,29,'A','\r'),(28,665579,'OPMD','oculopharyngeal muscular dystrophy','PABPN1','ENSG00000100836',6,7,8,13,'A','\r'),(29,6707049,'ZIC2','holoprosencephaly','tcfbr1','ENSG00000043355',15,15,25,25,'A','\r'),(30,6707063,'ZIC2','holoprosencephaly','tcfbr1','ENSG00000043355',15,15,25,25,'A','\r'),(31,6707157,'ZIC2','holoprosencephaly','tcfbr1','ENSG00000043355',15,15,25,25,'A','\r'),(32,6707171,'ZIC2','holoprosencephaly','tcfbr1','ENSG00000043355',15,15,25,25,'A','\r'),(33,6707184,'ZIC2','holoprosencephaly','tcfbr1','ENSG00000043355',15,15,25,25,'A','\r'),(34,7014462,'MD','Myotonic Dystrophy','DMPK','ENSG00000104936',5,37,50,1000,'U','\r'),(35,6268666,'c14orf4','unknown','c14orf4','ENSG00000119669',20,31,0,0,'','\r'),(36,6268694,'c14orf4','unknown','c14orf4','ENSG00000119669',20,31,0,0,'','\r'),(37,5208328,'CTG18.1','possible bipolar disorder','SEF2-1B','ENSG00000141654',10,37,800,2100,'','\r'),(38,4758831,'FRDA','Friedreich\'s ataxia','FRDA','ENSG00000165060',6,32,33,60,'i','\r'),(39,5493392,'SCA8','spinocerebellar ataxia 8','KLHL1','ENSG00000150361',16,92,100,127,'','\r'),(40,8195410,'SCA12','spinocerebellar ataxia 12','PPP2R2B','ENSG00000156475',7,45,55,78,'','\r'),(41,8034800,'FRAXA','Fragile X (A subtype)','FMR1','ENSG00000102081',6,52,230,2000,'U','y\r'),(42,8034806,'FRAXA','Fragile X (A subtype)','FMR1','ENSG00000102081',6,52,230,2000,'U','\r'),(43,8039798,'FRAXE','Fragile X (E subtype)','FMR2','ENSG00000155966',4,39,200,900,'U','y\r'),(44,8039801,'FRAXE','Fragile X (E subtype)','FMR2','ENSG00000155966',4,39,200,900,'U','\r'),(45,8039809,'FRAXE','Fragile X (E subtype)','FMR2','ENSG00000155966',4,39,200,900,'U','\r'),(46,8039813,'FRAXE','Fragile X (E subtype)','FMR2','ENSG00000155966',4,39,200,900,'U','\r'),(47,8039829,'FRAXE','Fragile X (E subtype)','FMR2','ENSG00000155966',4,39,200,900,'U','\r'),(48,8049546,'FRAXF','Fragile X (F subtype)','FAM11A','ENSG00000155984',7,40,306,1008,'U',NULL),(49,7953700,'FRA11B','Jacobsen Syndrome','CBL','ENSG00000110395',11,80,100,1000,'5',NULL),(50,2690745,'DM2','Myotonic Dystrophy 2','ZNF9','ENSG00000169714',104,176,75,11000,'\r',NULL),(51,3963769,'EPM1','progressive myoclonic epilepsy type 1','cystatin B','ENSG00000160213',2,3,30,75,'5',NULL),(52,5132348,'SCA10','spinocerebellar ataxia 10','ATXX_HUMAN','ENSG00000130638',10,22,800,4500,'c',NULL);
UNLOCK TABLES;

