DROP TABLE IF EXISTS `xref_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xref_type` ( `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci, `url` text COLLATE utf8_unicode_ci, `eg_q_url` text COLLATE utf8_unicode_ci, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `xref_type` -- LOCK TABLES `xref_type` WRITE; /*!40000 ALTER TABLE `xref_type` DISABLE KEYS */; INSERT INTO `xref_type` VALUES ('BRENDA',NULL,NULL,NULL),('ChEMBL',NULL,NULL,NULL),('DrugBank',NULL,NULL,NULL),('Ensembl',NULL,NULL,NULL),('ENSG','Ensembl Gene ID',NULL,NULL),('HGNC',NULL,NULL,NULL),('InterPro',NULL,NULL,NULL),('L1000 ID','CMap landmark gene ID. See http://support.lincscloud.org/hc/en-us/articles/202092616-The-Landmark-Genes',NULL,NULL),('MGI ID',NULL,NULL,NULL),('MIM',NULL,NULL,NULL),('NCBI GI',NULL,NULL,NULL),('PANTHER',NULL,NULL,NULL),('PDB',NULL,NULL,NULL),('Pfam',NULL,NULL,NULL),('PROSITE',NULL,NULL,NULL),('PubMed',NULL,NULL,NULL),('RefSeq','RefSeq mappings loaded from UniProt XML',NULL,NULL),('SMART',NULL,NULL,NULL),('STRING','STRING ENSP mappings loaded from UniProt XML',NULL,NULL),('UniGene',NULL,NULL,NULL),('UniProt Keyword','UniProt keyword ids and values',NULL,NULL); /*!40000 ALTER TABLE `xref_type` ENABLE KEYS */; UNLOCK TABLES;