# db_webqtl MariaDB schema Table definitions dumped from `db_webqtl` via `mysqldump --no-data`. Schema only, no data. ## Tables - [AccessLog](#accesslog) - [AvgMethod](#avgmethod) - [BACKUP_CaseAttribute_20240601T01_34_02__842794](#backup_caseattribute_20240601t01_34_02__842794) - [BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794](#backup_caseattributexrefnew_20240601t01_34_02__842794) - [BXDSnpPosition](#bxdsnpposition) - [CaseAttribute](#caseattribute) - [caseattributes_audit](#caseattributes_audit) - [CaseAttributeXRef](#caseattributexref) - [CaseAttributeXRefNew](#caseattributexrefnew) - [CeleraINFO_mm6](#celerainfo_mm6) - [Chr_Length](#chr_length) - [Dataset_mbat](#dataset_mbat) - [DatasetMapInvestigator](#datasetmapinvestigator) - [Datasets](#datasets) - [DatasetStatus](#datasetstatus) - [DBList](#dblist) - [DBType](#dbtype) - [Docs](#docs) - [EnsemblChip](#ensemblchip) - [EnsemblProbe](#ensemblprobe) - [EnsemblProbeLocation](#ensemblprobelocation) - [Genbank](#genbank) - [GeneCategory](#genecategory) - [GeneChip](#genechip) - [GeneChipEnsemblXRef](#genechipensemblxref) - [GeneIDXRef](#geneidxref) - [GeneInfo](#geneinfo) - [GeneList](#genelist) - [GeneList081722](#genelist081722) - [GeneList_rn3](#genelist_rn3) - [GeneList_rn33](#genelist_rn33) - [GeneMap_cuiyan](#genemap_cuiyan) - [GeneRIF](#generif) - [GeneRIF_BASIC](#generif_basic) - [GeneRIFXRef](#generifxref) - [Geno](#geno) - [GenoCode](#genocode) - [GenoData](#genodata) - [GenoFile](#genofile) - [GenoFreeze](#genofreeze) - [GenoSE](#genose) - [GenoXRef](#genoxref) - [GORef](#goref) - [H2](#h2) - [Homologene](#homologene) - [InbredSet](#inbredset) - [InbredSetMapInvestigator](#inbredsetmapinvestigator) - [IndelAll](#indelall) - [IndelXRef](#indelxref) - [InfoFiles](#infofiles) - [InfoFilesUser_md5](#infofilesuser_md5) - [Investigators](#investigators) - [LCorrRamin3](#lcorrramin3) - [login](#login) - [MachineAccessLog](#machineaccesslog) - [MappingMethod](#mappingmethod) - [metadata_audit](#metadata_audit) - [mytest1](#mytest1) - [News](#news) - [NStrain](#nstrain) - [Organizations](#organizations) - [Phenotype](#phenotype) - [Probe](#probe) - [ProbeData](#probedata) - [ProbeFreeze](#probefreeze) - [ProbeH2](#probeh2) - [ProbeSE](#probese) - [ProbeSet](#probeset) - [ProbeSetData](#probesetdata) - [ProbeSetFreeze](#probesetfreeze) - [ProbeSetSE](#probesetse) - [ProbeSetXRef](#probesetxref) - [ProbeSetXRef_old](#probesetxref_old) - [ProbeXRef](#probexref) - [Publication](#publication) - [Publication_Test](#publication_test) - [PublishData](#publishdata) - [PublishFreeze](#publishfreeze) - [PublishSE](#publishse) - [PublishXRef](#publishxref) - [pubmedsearch](#pubmedsearch) - [RatSnpPattern](#ratsnppattern) - [role](#role) - [roles_users](#roles_users) - [Sample](#sample) - [SampleXRef](#samplexref) - [SnpAll](#snpall) - [SnpAllele_to_be_deleted](#snpallele_to_be_deleted) - [SnpAllRat](#snpallrat) - [SnpPattern](#snppattern) - [SnpSource](#snpsource) - [Species](#species) - [Strain](#strain) - [StrainXRef](#strainxref) - [TableComments](#tablecomments) - [TableFieldAnnotation](#tablefieldannotation) - [Temp](#temp) - [TempData](#tempdata) - [temporary](#temporary) - [test_table](#test_table) - [Tissue](#tissue) - [TissueProbeFreeze](#tissueprobefreeze) - [TissueProbeSetData](#tissueprobesetdata) - [TissueProbeSetFreeze](#tissueprobesetfreeze) - [TissueProbeSetXRef](#tissueprobesetxref) - [TraitMetadata](#traitmetadata) - [User](#user) - [user](#user) - [user_collection](#user_collection) - [user_openids](#user_openids) - [UserPrivilege](#userprivilege) - [Vlookup](#vlookup) ## AccessLog ```sql CREATE TABLE `AccessLog` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `accesstime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_address` char(20) NOT NULL DEFAULT '0.0.0.0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1511441 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## AvgMethod ```sql CREATE TABLE `AvgMethod` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `AvgMethodId` int(5) DEFAULT NULL, `Name` char(30) NOT NULL DEFAULT '', `Normalization` varchar(30) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## BACKUP_CaseAttribute_20240601T01_34_02__842794 ```sql CREATE TABLE `BACKUP_CaseAttribute_20240601T01_34_02__842794` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(30) NOT NULL DEFAULT '', `Description` varchar(250) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794 ```sql CREATE TABLE `BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0, `StrainId` int(8) unsigned NOT NULL DEFAULT 0, `CaseAttributeId` smallint(5) NOT NULL DEFAULT 0, `Value` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`InbredSetId`,`StrainId`,`CaseAttributeId`), UNIQUE KEY `Id` (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=390448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## BXDSnpPosition ```sql CREATE TABLE `BXDSnpPosition` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Chr` char(2) DEFAULT NULL, `StrainId1` int(11) DEFAULT NULL, `StrainId2` int(11) DEFAULT NULL, `Mb` double DEFAULT NULL, `Mb_2016` double DEFAULT NULL, PRIMARY KEY (`id`), KEY `BXDSnpPosition` (`Chr`,`StrainId1`,`StrainId2`,`Mb`) ) ENGINE=InnoDB AUTO_INCREMENT=7791982 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## CaseAttribute ```sql CREATE TABLE `CaseAttribute` ( `InbredSetId` int(5) unsigned NOT NULL, `CaseAttributeId` int(5) unsigned NOT NULL, `Name` varchar(30) NOT NULL, `Description` varchar(250) NOT NULL, PRIMARY KEY (`InbredSetId`,`CaseAttributeId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## caseattributes_audit ```sql CREATE TABLE `caseattributes_audit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` enum('review','rejected','approved') NOT NULL, `editor` varchar(255) NOT NULL, `json_diff_data` longtext DEFAULT NULL, `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), CONSTRAINT `CONSTRAINT_1` CHECK (json_valid(`json_diff_data`)) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## CaseAttributeXRef ```sql CREATE TABLE `CaseAttributeXRef` ( `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, `CaseAttributeId` smallint(5) NOT NULL DEFAULT 0, `Value` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`ProbeSetFreezeId`,`StrainId`,`CaseAttributeId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## CaseAttributeXRefNew ```sql CREATE TABLE `CaseAttributeXRefNew` ( `InbredSetId` int(5) unsigned NOT NULL, `StrainId` int(20) unsigned NOT NULL, `CaseAttributeId` int(5) unsigned NOT NULL, `Value` varchar(100) NOT NULL, PRIMARY KEY (`InbredSetId`,`StrainId`,`CaseAttributeId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## CeleraINFO_mm6 ```sql CREATE TABLE `CeleraINFO_mm6` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `SNPID` char(14) NOT NULL DEFAULT '', `chromosome` char(3) DEFAULT NULL, `MB_UCSC` double DEFAULT NULL, `MB_celera` double DEFAULT NULL, `allele_B6` char(4) DEFAULT NULL, `allele_D2` char(4) DEFAULT NULL, `allele_AJ` char(4) DEFAULT NULL, `B6_D2` char(1) DEFAULT NULL, `B6_AJ` char(1) DEFAULT NULL, `D2_AJ` char(1) DEFAULT NULL, `MB_UCSC_OLD` double DEFAULT NULL, `allele_S1` char(4) DEFAULT NULL, `allele_X1` char(4) DEFAULT NULL, `flanking5` char(100) DEFAULT NULL, `flanking3` char(100) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `celeraIndex` (`chromosome`,`MB_celera`), KEY `celeraIndex2` (`chromosome`,`MB_UCSC`), KEY `chromosome_2` (`chromosome`,`MB_UCSC`), KEY `MB_UCSC_2` (`MB_UCSC`,`chromosome`), KEY `SNPID` (`SNPID`) ) ENGINE=InnoDB AUTO_INCREMENT=3028848 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Chr_Length ```sql CREATE TABLE `Chr_Length` ( `Name` char(3) NOT NULL DEFAULT '', `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0, `OrderId` smallint(5) unsigned NOT NULL, `Length` int(10) unsigned NOT NULL DEFAULT 0, `Length_2016` int(10) unsigned NOT NULL DEFAULT 0, `Length_mm8` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`SpeciesId`,`OrderId`), UNIQUE KEY `nameIdx` (`SpeciesId`,`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## Dataset_mbat ```sql CREATE TABLE `Dataset_mbat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `switch` int(1) DEFAULT NULL, `species` varchar(255) DEFAULT NULL, `cross` varchar(255) DEFAULT NULL, `tissue` varchar(255) DEFAULT NULL, `database` varchar(255) DEFAULT NULL, `database_LongName` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## DatasetMapInvestigator ```sql CREATE TABLE `DatasetMapInvestigator` ( `Id` mediumint(9) NOT NULL AUTO_INCREMENT, `DatasetId` int(6) NOT NULL, `ProbeFreezeId` int(6) DEFAULT NULL, `InvestigatorId` int(6) NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2409 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Datasets ```sql CREATE TABLE `Datasets` ( `DatasetId` int(6) NOT NULL AUTO_INCREMENT, `ProbeFreezeId` int(8) DEFAULT NULL, `DatasetName` varchar(255) DEFAULT NULL, `GeoSeries` varchar(30) DEFAULT NULL, `PublicationTitle` longtext DEFAULT NULL, `Summary` longtext DEFAULT NULL, `ExperimentDesign` longtext DEFAULT NULL, `AboutCases` longtext DEFAULT NULL, `AboutTissue` longtext DEFAULT NULL, `AboutPlatform` longtext DEFAULT NULL, `AboutDataProcessing` longtext DEFAULT NULL, `Contributors` longtext DEFAULT NULL, `Citation` longtext DEFAULT NULL, `Acknowledgment` longtext DEFAULT NULL, `Notes` longtext DEFAULT NULL, `InvestigatorId` int(5) NOT NULL, `DatasetStatusId` int(5) NOT NULL, PRIMARY KEY (`DatasetId`), UNIQUE KEY `DatasetId` (`DatasetId`) ) ENGINE=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## DatasetStatus ```sql CREATE TABLE `DatasetStatus` ( `DatasetStatusId` int(5) NOT NULL, `DatasetStatusName` varchar(20) DEFAULT NULL, UNIQUE KEY `DatasetStatusId` (`DatasetStatusId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## DBList ```sql CREATE TABLE `DBList` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `DBTypeId` smallint(5) unsigned NOT NULL DEFAULT 0, `FreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `Name` char(50) NOT NULL DEFAULT '', `Code` char(50) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `Cde` (`Code`), KEY `DBIndex` (`DBTypeId`,`FreezeId`) ) ENGINE=InnoDB AUTO_INCREMENT=956 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## DBType ```sql CREATE TABLE `DBType` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` char(30) NOT NULL DEFAULT '', PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Docs ```sql CREATE TABLE `Docs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entry` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## EnsemblChip ```sql CREATE TABLE `EnsemblChip` ( `Id` int(11) NOT NULL, `ProbeSetSize` int(11) NOT NULL, `Name` varchar(40) NOT NULL, `Type` enum('AFFY','OLIGO') DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## EnsemblProbe ```sql CREATE TABLE `EnsemblProbe` ( `Id` int(11) NOT NULL, `ChipId` int(11) NOT NULL, `ProbeSet` varchar(40) DEFAULT NULL, `Name` varchar(40) DEFAULT NULL, `length` int(11) NOT NULL, KEY `EnsemblProbeId` (`Id`), KEY `EnsemblProbeName` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## EnsemblProbeLocation ```sql CREATE TABLE `EnsemblProbeLocation` ( `Chr` char(2) NOT NULL, `Start` int(11) NOT NULL, `Start_2016` int(11) DEFAULT NULL, `End` int(11) NOT NULL, `End_2016` int(11) DEFAULT NULL, `Strand` int(11) NOT NULL, `MisMataches` int(11) DEFAULT NULL, `ProbeId` int(11) NOT NULL, KEY `EnsemblLocationProbeId` (`ProbeId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Genbank ```sql CREATE TABLE `Genbank` ( `Id` varchar(20) NOT NULL DEFAULT '', `Sequence` text DEFAULT NULL, `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`Id`), KEY `Id` (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneCategory ```sql CREATE TABLE `GeneCategory` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` char(255) NOT NULL DEFAULT '', PRIMARY KEY (`Id`), KEY `name_idx` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneChip ```sql CREATE TABLE `GeneChip` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `GeneChipId` int(5) DEFAULT NULL, `GeneChipName` varchar(200) DEFAULT NULL, `Name` char(30) NOT NULL DEFAULT '', `GeoPlatform` char(15) DEFAULT NULL, `Title` varchar(100) DEFAULT NULL, `SpeciesId` int(5) DEFAULT 1, `GO_tree_value` varchar(50) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneChipEnsemblXRef ```sql CREATE TABLE `GeneChipEnsemblXRef` ( `GeneChipId` int(11) NOT NULL, `EnsemblChipId` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneIDXRef ```sql CREATE TABLE `GeneIDXRef` ( `mouse` int(11) NOT NULL DEFAULT 0, `rat` int(11) NOT NULL DEFAULT 0, `human` int(11) NOT NULL DEFAULT 0, KEY `mouse_index` (`mouse`), KEY `rat_index` (`rat`), KEY `human_index` (`human`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneInfo ```sql CREATE TABLE `GeneInfo` ( `Id` int(10) NOT NULL AUTO_INCREMENT, `GeneId` int(10) DEFAULT NULL, `TaxId` int(10) DEFAULT NULL, `SpeciesId` int(10) DEFAULT NULL, `Symbol` varchar(255) DEFAULT NULL, `Alias` longtext DEFAULT NULL, `Chr` char(3) DEFAULT NULL, `Mb` double DEFAULT NULL, `Probe_set_Blat_Mb_start` double DEFAULT NULL, `Probe_set_Blat_Mb_end` double DEFAULT NULL, `BlatSeq` text DEFAULT NULL, `Strand_Probe` char(1) DEFAULT NULL, `Strand_Gene` char(1) DEFAULT NULL, `OMIM` varchar(20) DEFAULT NULL, `HomoloGeneID` varchar(20) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `GeneId_Symbol` (`GeneId`,`Symbol`) ) ENGINE=InnoDB AUTO_INCREMENT=9560977 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneList ```sql CREATE TABLE `GeneList` ( `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1, `Id` int(10) unsigned NOT NULL, `GeneSymbol` varchar(15) DEFAULT NULL, `GeneDescription` mediumtext DEFAULT NULL, `Chromosome` varchar(10) DEFAULT NULL, `TxStart` double DEFAULT NULL, `TxStart_2016` double DEFAULT NULL, `TxEnd` double DEFAULT NULL, `TxEnd_2016` double DEFAULT NULL, `Strand` char(1) DEFAULT NULL, `GeneID` varchar(10) DEFAULT NULL, `NM_ID` varchar(15) DEFAULT NULL, `kgID` varchar(10) DEFAULT NULL, `GenBankID` varchar(15) DEFAULT NULL, `UnigenID` varchar(15) DEFAULT NULL, `ProteinID` varchar(15) DEFAULT NULL, `AlignID` varchar(10) DEFAULT NULL, `exonCount` int(7) NOT NULL DEFAULT 0, `exonStarts` mediumtext DEFAULT NULL, `exonEnds` mediumtext DEFAULT NULL, `cdsStart` double DEFAULT NULL, `cdsStart_2016` double DEFAULT NULL, `cdsEnd` double DEFAULT NULL, `cdsEnd_2016` double DEFAULT NULL, `TxStart_mm8` double DEFAULT NULL, `TxEnd_mm8` double DEFAULT NULL, `Strand_mm8` char(1) DEFAULT NULL, `exonCount_mm8` int(7) DEFAULT NULL, `exonStarts_mm8` mediumtext DEFAULT NULL, `exonEnds_mm8` mediumtext DEFAULT NULL, `cdsStart_mm8` double DEFAULT NULL, `cdsEnd_mm8` double DEFAULT NULL, `Chromosome_mm8` varchar(10) DEFAULT NULL, `Info_mm9` mediumtext DEFAULT NULL, `RGD_ID` int(10) DEFAULT NULL, UNIQUE KEY `geneId` (`SpeciesId`,`Id`), KEY `geneSymbol` (`GeneSymbol`), KEY `geneSymbol2` (`SpeciesId`,`GeneSymbol`), KEY `Loc1` (`SpeciesId`,`Chromosome`,`TxStart`), KEY `Loc2` (`SpeciesId`,`Chromosome`,`TxEnd`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## GeneList081722 ```sql CREATE TABLE `GeneList081722` ( `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1, `Id` int(20) unsigned NOT NULL AUTO_INCREMENT, `GeneSymbol` varchar(20) DEFAULT NULL, `GeneDescription` text DEFAULT NULL, `alias` longtext DEFAULT NULL, `Chr_mm11` varchar(10) DEFAULT NULL, `TxStart_mm11` double DEFAULT NULL, `TxEnd_mm11` double DEFAULT NULL, `Strand_mm11` char(1) DEFAULT NULL, `Chr_mm10` varchar(10) DEFAULT NULL, `TxStart_mm10` double DEFAULT NULL, `TxEnd_mm10` double DEFAULT NULL, `Strand_mm10` char(1) DEFAULT NULL, `Chr_mm9` varchar(10) DEFAULT NULL, `TxStart_mm9` double DEFAULT NULL, `TxEnd_mm9` double DEFAULT NULL, `Strand_mm9` char(1) DEFAULT NULL, `Chr_rn7` varchar(10) DEFAULT NULL, `TxStart_rn7` double DEFAULT NULL, `TxEnd_rn7` double DEFAULT NULL, `Strand_rn7` char(1) DEFAULT NULL, `Chr_rn6` varchar(10) DEFAULT NULL, `TxStart_rn6` double DEFAULT NULL, `TxEnd_rn6` double DEFAULT NULL, `Strand_rn6` char(1) DEFAULT NULL, `GeneID` varchar(15) DEFAULT NULL, `NM_ID` varchar(20) DEFAULT NULL, `kgID` varchar(10) DEFAULT NULL, `GenBankID` varchar(20) DEFAULT NULL, `UnigenID` varchar(20) DEFAULT NULL, `ProteinID` varchar(20) DEFAULT NULL, `AlignID` varchar(10) DEFAULT NULL, `exonCount` int(7) NOT NULL DEFAULT 0, `exonStarts` text DEFAULT NULL, `exonEnds` text DEFAULT NULL, `cdsStart` double DEFAULT NULL, `cdsEnd` double DEFAULT NULL, `RGD_ID` int(20) DEFAULT NULL, `ENSEMBL_ID` varchar(50) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `geneId` (`SpeciesId`,`Id`), KEY `geneSymbol` (`GeneSymbol`), KEY `geneSymbol2` (`SpeciesId`,`GeneSymbol`), KEY `Loc1` (`SpeciesId`,`Chr_mm10`,`TxStart_mm10`), KEY `Loc2` (`SpeciesId`,`Chr_mm10`,`TxEnd_mm10`) ) ENGINE=InnoDB AUTO_INCREMENT=142506 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneList_rn3 ```sql CREATE TABLE `GeneList_rn3` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ProbeSet` varchar(16) DEFAULT NULL, `geneSymbol` varchar(15) DEFAULT NULL, `geneID` varchar(10) DEFAULT NULL, `kgID` varchar(10) DEFAULT NULL, `geneDescription` text DEFAULT NULL, `genBankID` varchar(15) DEFAULT NULL, `unigenID` varchar(15) DEFAULT NULL, `score` int(4) DEFAULT NULL, `qStart` int(3) DEFAULT NULL, `qEnd` int(3) DEFAULT NULL, `qSize` int(3) DEFAULT NULL, `identity` varchar(7) DEFAULT NULL, `chromosome` varchar(8) DEFAULT NULL, `strand` char(1) DEFAULT NULL, `txStart` double DEFAULT NULL, `txEnd` double DEFAULT NULL, `txSize` double DEFAULT NULL, `span` int(7) DEFAULT NULL, `specificity` double DEFAULT NULL, `sequence` text DEFAULT NULL, `flag` int(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `geneSymbol` (`geneSymbol`), KEY `Loc1` (`chromosome`,`txStart`), KEY `Loc2` (`chromosome`,`txEnd`) ) ENGINE=InnoDB AUTO_INCREMENT=14917 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneList_rn33 ```sql CREATE TABLE `GeneList_rn33` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `geneSymbol` varchar(15) DEFAULT NULL, `txStart` double DEFAULT NULL, `txEnd` double DEFAULT NULL, `exonCount` int(7) DEFAULT NULL, `NM_ID` varchar(15) DEFAULT NULL, `chromosome` varchar(8) DEFAULT NULL, `strand` char(1) DEFAULT NULL, `cdsStart` double DEFAULT NULL, `cdsEnd` double DEFAULT NULL, `exonStarts` text DEFAULT NULL, `exonEnds` text DEFAULT NULL, `kgID` varchar(10) DEFAULT NULL, PRIMARY KEY (`id`), KEY `geneSymbol` (`geneSymbol`), KEY `Loc1` (`chromosome`,`txStart`), KEY `Loc2` (`chromosome`,`txEnd`) ) ENGINE=InnoDB AUTO_INCREMENT=9790 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneMap_cuiyan ```sql CREATE TABLE `GeneMap_cuiyan` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `TranscriptID` varchar(255) DEFAULT NULL, `GeneID` varchar(255) DEFAULT NULL, `Symbol` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10537 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GeneRIF ```sql CREATE TABLE `GeneRIF` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `versionId` smallint(5) unsigned NOT NULL DEFAULT 0, `symbol` varchar(30) NOT NULL DEFAULT '', `PubMed_ID` varchar(255) DEFAULT NULL, `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1, `comment` mediumtext DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', `user_ip` varchar(20) DEFAULT NULL, `weburl` varchar(255) DEFAULT NULL, `initial` varchar(10) DEFAULT NULL, `display` tinyint(4) DEFAULT 1, `reason` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`Id`,`versionId`), KEY `name_idx` (`symbol`), KEY `status` (`display`), KEY `timestamp` (`createtime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## GeneRIF_BASIC ```sql CREATE TABLE `GeneRIF_BASIC` ( `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1, `TaxID` int(10) DEFAULT NULL, `GeneId` int(10) unsigned NOT NULL DEFAULT 0, `symbol` varchar(255) NOT NULL DEFAULT '', `PubMed_ID` int(10) unsigned NOT NULL DEFAULT 0, `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', `comment` mediumtext DEFAULT NULL, `VersionId` smallint(5) unsigned NOT NULL, PRIMARY KEY (`GeneId`,`SpeciesId`,`createtime`,`PubMed_ID`,`VersionId`), KEY `symbol` (`symbol`,`SpeciesId`,`createtime`), FULLTEXT KEY `commts` (`comment`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## GeneRIFXRef ```sql CREATE TABLE `GeneRIFXRef` ( `GeneRIFId` int(10) unsigned NOT NULL DEFAULT 0, `versionId` smallint(5) unsigned NOT NULL DEFAULT 0, `GeneCategoryId` smallint(5) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`GeneRIFId`,`versionId`,`GeneCategoryId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## Geno ```sql CREATE TABLE `Geno` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1, `Name` varchar(40) NOT NULL DEFAULT '', `Marker_Name` varchar(40) DEFAULT NULL, `Chr` char(3) DEFAULT NULL, `Mb` double DEFAULT NULL, `Mb_2016` double DEFAULT NULL, `Sequence` longtext DEFAULT NULL, `Source` varchar(40) DEFAULT NULL, `chr_num` smallint(5) unsigned DEFAULT NULL, `Source2` varchar(40) DEFAULT NULL, `Comments` varchar(255) DEFAULT NULL, `used_by_geno_file` varchar(40) DEFAULT NULL, `Mb_mm8` double DEFAULT NULL, `Chr_mm8` char(3) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `species_name` (`SpeciesId`,`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=1140082 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## GenoCode ```sql CREATE TABLE `GenoCode` ( `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 1, `AlleleType` char(3) NOT NULL DEFAULT '', `AlleleSymbol` char(2) NOT NULL DEFAULT '', `DatabaseValue` smallint(5) DEFAULT NULL, PRIMARY KEY (`InbredSetId`,`AlleleType`,`AlleleSymbol`), UNIQUE KEY `InbredSetId_AlleleType` (`InbredSetId`,`AlleleType`), UNIQUE KEY `InbredSetId_AlleleSymbol` (`InbredSetId`,`AlleleSymbol`), UNIQUE KEY `InbredSetId_DatabaseValue` (`InbredSetId`,`DatabaseValue`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GenoData ```sql CREATE TABLE `GenoData` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` int(5) DEFAULT NULL, `value` float NOT NULL, UNIQUE KEY `DataId` (`Id`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## GenoFile ```sql CREATE TABLE `GenoFile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `server` varchar(100) NOT NULL, `InbredSetID` int(11) NOT NULL, `location` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `sort` int(3) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GenoFreeze ```sql CREATE TABLE `GenoFreeze` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(100) NOT NULL DEFAULT '', `FullName` varchar(100) NOT NULL DEFAULT '', `ShortName` varchar(100) NOT NULL DEFAULT '', `CreateTime` date NOT NULL DEFAULT '2001-01-01', `public` tinyint(4) NOT NULL DEFAULT 0, `InbredSetId` smallint(5) unsigned DEFAULT 1, `confidentiality` tinyint(3) unsigned DEFAULT 0, `AuthorisedUsers` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## GenoSE ```sql CREATE TABLE `GenoSE` ( `DataId` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, `error` float NOT NULL, UNIQUE KEY `DataId` (`DataId`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## GenoXRef ```sql CREATE TABLE `GenoXRef` ( `GenoFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `GenoId` int(10) unsigned NOT NULL DEFAULT 0, `DataId` int(10) unsigned NOT NULL DEFAULT 0, `cM` double DEFAULT 0, `Used_for_mapping` char(1) DEFAULT 'N', UNIQUE KEY `ProbeSetId` (`GenoFreezeId`,`GenoId`), UNIQUE KEY `DataId` (`DataId`), KEY `GenoId` (`GenoId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## GORef ```sql CREATE TABLE `GORef` ( `id` int(11) NOT NULL AUTO_INCREMENT, `goterm` varchar(255) DEFAULT NULL, `genes` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17510 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## H2 ```sql CREATE TABLE `H2` ( `DataId` int(10) unsigned NOT NULL DEFAULT 0, `ICH2` double NOT NULL DEFAULT 0, `H2SE` double NOT NULL DEFAULT 0, `HPH2` double NOT NULL DEFAULT 0, UNIQUE KEY `DataId` (`DataId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Homologene ```sql CREATE TABLE `Homologene` ( `HomologeneId` int(11) DEFAULT NULL, `GeneId` int(11) DEFAULT NULL, `TaxonomyId` int(11) DEFAULT NULL, KEY `GeneId` (`GeneId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## InbredSet ```sql CREATE TABLE `InbredSet` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `InbredSetId` int(5) unsigned NOT NULL, `InbredSetName` varchar(100) DEFAULT NULL, `Name` char(30) NOT NULL DEFAULT '', `SpeciesId` smallint(5) unsigned DEFAULT 1, `FullName` varchar(100) DEFAULT NULL, `public` tinyint(3) unsigned DEFAULT 2, `MappingMethodId` char(50) DEFAULT '1', `GeneticType` varchar(255) DEFAULT NULL, `Family` varchar(100) DEFAULT NULL, `FamilyOrder` int(5) DEFAULT NULL, `MenuOrderId` double NOT NULL, `InbredSetCode` varchar(5) DEFAULT NULL, `Description` longtext DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## InbredSetMapInvestigator ```sql CREATE TABLE `InbredSetMapInvestigator` ( `Id` mediumint(9) NOT NULL AUTO_INCREMENT, `InbredSetId` int(6) NOT NULL DEFAULT 0, `InvestigatorId` int(6) NOT NULL DEFAULT 177, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## IndelAll ```sql CREATE TABLE `IndelAll` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `SpeciesId` smallint(5) unsigned DEFAULT 1, `SourceId` smallint(5) unsigned DEFAULT NULL, `Name` char(30) DEFAULT NULL, `Chromosome` char(2) DEFAULT NULL, `Mb_start` double DEFAULT NULL, `Mb_start_2016` double DEFAULT NULL, `Strand` char(1) DEFAULT NULL, `Type` char(15) DEFAULT NULL, `Mb_end` double DEFAULT NULL, `Mb_end_2016` double DEFAULT NULL, `Size` double DEFAULT NULL, `InDelSequence` char(30) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `SnpId` (`SpeciesId`,`Name`), KEY `SnpId2` (`Name`), KEY `Position` (`SpeciesId`,`Chromosome`,`Mb_start`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=142895 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## IndelXRef ```sql CREATE TABLE `IndelXRef` ( `IndelId` int(10) unsigned NOT NULL DEFAULT 0, `StrainId1` smallint(5) unsigned NOT NULL DEFAULT 0, `StrainId2` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`IndelId`,`StrainId1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## InfoFiles ```sql CREATE TABLE `InfoFiles` ( `DatasetId` int(5) DEFAULT NULL, `SpeciesId` int(5) DEFAULT NULL, `TissueId` int(5) DEFAULT NULL, `InbredSetId` int(5) DEFAULT NULL, `GeneChipId` int(5) DEFAULT NULL, `AvgMethodId` int(5) DEFAULT NULL, `InfoFileTitle` longtext DEFAULT NULL, `Specifics` longtext DEFAULT NULL, `Status` varchar(255) DEFAULT NULL, `Title` varchar(255) DEFAULT NULL, `Organism` varchar(255) DEFAULT NULL, `Experiment_Type` longtext DEFAULT NULL, `Summary` longtext DEFAULT NULL, `Overall_Design` longtext DEFAULT NULL, `Contributor` longtext DEFAULT NULL, `Citation` longtext DEFAULT NULL, `Submission_Date` varchar(255) DEFAULT NULL, `Contact_Name` varchar(255) DEFAULT NULL, `Emails` varchar(255) DEFAULT NULL, `Phone` varchar(255) DEFAULT NULL, `URL` varchar(255) DEFAULT NULL, `Organization_Name` varchar(255) DEFAULT NULL, `Department` varchar(255) DEFAULT NULL, `Laboratory` varchar(255) DEFAULT NULL, `Street` varchar(255) DEFAULT NULL, `City` varchar(255) DEFAULT NULL, `State` varchar(255) DEFAULT NULL, `ZIP` varchar(255) DEFAULT NULL, `Country` varchar(255) DEFAULT NULL, `Platforms` varchar(255) DEFAULT NULL, `Samples` longtext DEFAULT NULL, `Species` varchar(255) DEFAULT NULL, `Normalization` varchar(255) DEFAULT NULL, `InbredSet` varchar(255) DEFAULT NULL, `InfoPageName` varchar(255) NOT NULL, `DB_Name` varchar(255) DEFAULT NULL, `Organism_Id` varchar(60) DEFAULT NULL, `InfoPageTitle` varchar(255) DEFAULT NULL, `GN_AccesionId` int(4) DEFAULT NULL, `Tissue` varchar(60) DEFAULT NULL, `AuthorizedUsers` varchar(100) DEFAULT NULL, `About_Cases` longtext DEFAULT NULL, `About_Tissue` longtext DEFAULT NULL, `About_Download` longtext DEFAULT NULL, `About_Array_Platform` longtext DEFAULT NULL, `About_Data_Values_Processing` longtext DEFAULT NULL, `Data_Source_Acknowledge` longtext DEFAULT NULL, `Progreso` varchar(20) DEFAULT NULL, `QualityControlStatus` longtext DEFAULT NULL, `InfoFileId` int(6) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`InfoFileId`), UNIQUE KEY `InfoPageName` (`InfoPageName`), UNIQUE KEY `GN_AccesionId` (`GN_AccesionId`) ) ENGINE=InnoDB AUTO_INCREMENT=1530 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## InfoFilesUser_md5 ```sql CREATE TABLE `InfoFilesUser_md5` ( `Username` varchar(16) DEFAULT NULL, `Password` varchar(32) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Investigators ```sql CREATE TABLE `Investigators` ( `FirstName` varchar(20) DEFAULT NULL, `LastName` varchar(20) DEFAULT NULL, `Address` varchar(200) DEFAULT NULL, `City` varchar(20) DEFAULT NULL, `State` varchar(20) DEFAULT NULL, `ZipCode` varchar(20) DEFAULT NULL, `Phone` varchar(200) DEFAULT NULL, `Email` varchar(200) DEFAULT NULL, `Country` varchar(35) DEFAULT NULL, `Url` text DEFAULT NULL, `UserName` varchar(30) DEFAULT NULL, `UserPass` varchar(255) DEFAULT NULL, `UserDate` datetime /* mariadb-5.3 */ DEFAULT NULL, `UserLevel` int(8) DEFAULT NULL, `active` enum('0','1') DEFAULT NULL, `token` varchar(255) DEFAULT NULL, `OrganizationId` int(5) DEFAULT NULL, `InvestigatorId` int(5) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`InvestigatorId`) ) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## LCorrRamin3 ```sql CREATE TABLE `LCorrRamin3` ( `GeneId1` int(12) unsigned DEFAULT NULL, `GeneId2` int(12) unsigned DEFAULT NULL, `value` double DEFAULT NULL, KEY `GeneId1` (`GeneId1`), KEY `GeneId2` (`GeneId2`), KEY `GeneId1_2` (`GeneId1`,`GeneId2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## login ```sql CREATE TABLE `login` ( `id` varchar(36) NOT NULL, `user` varchar(36) DEFAULT NULL, `timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL, `ip_address` varchar(39) DEFAULT NULL, `successful` tinyint(1) NOT NULL, `session_id` text DEFAULT NULL, `assumed_by` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user` (`user`), KEY `assumed_by` (`assumed_by`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## MachineAccessLog ```sql CREATE TABLE `MachineAccessLog` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `accesstime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_address` char(20) NOT NULL DEFAULT '0.0.0.0', `db_id` tinyint(3) unsigned NOT NULL DEFAULT 0, `data_id` int(10) unsigned DEFAULT NULL, `action` char(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=514946 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## MappingMethod ```sql CREATE TABLE `MappingMethod` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## metadata_audit ```sql CREATE TABLE `metadata_audit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dataset_id` int(11) NOT NULL, `editor` varchar(255) NOT NULL, `json_diff_data` longtext DEFAULT NULL, `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), CONSTRAINT `CONSTRAINT_1` CHECK (json_valid(`json_diff_data`)) ) ENGINE=InnoDB AUTO_INCREMENT=1228 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## mytest1 ```sql CREATE TABLE `mytest1` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` mediumint(8) unsigned NOT NULL DEFAULT 0, `value` float NOT NULL, PRIMARY KEY (`Id`,`StrainId`), KEY `StrainId` (`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## News ```sql CREATE TABLE `News` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` date DEFAULT NULL, `details` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## NStrain ```sql CREATE TABLE `NStrain` ( `DataId` int(10) unsigned DEFAULT NULL, `StrainId` int(20) DEFAULT NULL, `count` varchar(5) DEFAULT NULL, UNIQUE KEY `DataId` (`DataId`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## Organizations ```sql CREATE TABLE `Organizations` ( `OrganizationId` int(5) NOT NULL AUTO_INCREMENT, `OrganizationName` varchar(200) NOT NULL, PRIMARY KEY (`OrganizationId`), UNIQUE KEY `OrganizationId` (`OrganizationId`), UNIQUE KEY `OrganizationName` (`OrganizationName`) ) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Phenotype ```sql CREATE TABLE `Phenotype` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Pre_publication_description` mediumtext DEFAULT NULL, `Post_publication_description` mediumtext DEFAULT NULL, `Original_description` mediumtext DEFAULT NULL, `Units` varchar(100) NOT NULL DEFAULT 'Unknown', `Pre_publication_abbreviation` varchar(60) DEFAULT NULL, `Post_publication_abbreviation` varchar(60) DEFAULT NULL, `Lab_code` varchar(255) DEFAULT NULL, `Submitter` varchar(255) DEFAULT NULL, `Owner` varchar(255) DEFAULT NULL, `Authorized_Users` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `Post_publication_description_Index` (`Post_publication_description`(250)), KEY `Pre_publication_description_Index` (`Pre_publication_description`(250)), KEY `Pre_publication_abbreviation_Index` (`Pre_publication_abbreviation`), KEY `Post_publication_abbreviation_Index` (`Post_publication_abbreviation`), FULLTEXT KEY `index_table` (`Post_publication_description`,`Pre_publication_description`,`Pre_publication_abbreviation`,`Post_publication_abbreviation`,`Lab_code`) ) ENGINE=InnoDB AUTO_INCREMENT=47278 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## Probe ```sql CREATE TABLE `Probe` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0, `Name` char(20) DEFAULT NULL, `Sequence` char(30) DEFAULT NULL, `ExonNo` char(7) DEFAULT NULL, `SerialOrder` double DEFAULT NULL, `Tm` double DEFAULT NULL, `E_GSB` double DEFAULT NULL, `E_NSB` double DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `ProbeSetId` (`ProbeSetId`,`Name`), KEY `SerialOrder` (`ProbeSetId`,`SerialOrder`) ) ENGINE=InnoDB AUTO_INCREMENT=19054073 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## ProbeData ```sql CREATE TABLE `ProbeData` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, `value` float NOT NULL, UNIQUE KEY `DataId` (`Id`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## ProbeFreeze ```sql CREATE TABLE `ProbeFreeze` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `ProbeFreezeId` int(5) DEFAULT NULL, `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0, `TissueId` smallint(5) unsigned NOT NULL DEFAULT 0, `Name` varchar(100) NOT NULL DEFAULT '', `FullName` varchar(100) NOT NULL DEFAULT '', `ShortName` varchar(100) NOT NULL DEFAULT '', `CreateTime` date NOT NULL DEFAULT '0000-00-00', `InbredSetId` smallint(5) unsigned DEFAULT 1, PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## ProbeH2 ```sql CREATE TABLE `ProbeH2` ( `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `ProbeId` int(10) unsigned NOT NULL DEFAULT 0, `h2` double DEFAULT NULL, `weight` double DEFAULT NULL, UNIQUE KEY `ProbeId` (`ProbeFreezeId`,`ProbeId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## ProbeSE ```sql CREATE TABLE `ProbeSE` ( `DataId` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, `error` float NOT NULL, UNIQUE KEY `DataId` (`DataId`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## ProbeSet ```sql CREATE TABLE `ProbeSet` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0, `Name` varchar(100) DEFAULT NULL, `TargetId` varchar(150) DEFAULT NULL, `Symbol` varchar(100) DEFAULT NULL, `description` longtext DEFAULT NULL, `Chr` char(3) DEFAULT NULL, `Mb` double DEFAULT NULL, `Chr_2016` char(3) DEFAULT NULL, `Mb_2016` double DEFAULT NULL, `alias` longtext DEFAULT NULL, `GeneId` varchar(20) DEFAULT NULL, `GenbankId` varchar(1000) DEFAULT NULL, `SNP` int(2) DEFAULT NULL, `BlatSeq` mediumtext DEFAULT NULL, `TargetSeq` mediumtext DEFAULT NULL, `UniGeneId` varchar(100) DEFAULT NULL, `Strand_Probe` char(1) DEFAULT NULL, `Strand_Gene` char(1) DEFAULT NULL, `OMIM` varchar(20) DEFAULT NULL, `comments` mediumtext DEFAULT NULL, `Probe_set_target_region` varchar(255) DEFAULT NULL, `Probe_set_specificity` double DEFAULT NULL, `Probe_set_BLAT_score` double DEFAULT NULL, `Probe_set_Blat_Mb_start` double DEFAULT NULL, `Probe_set_Blat_Mb_end` double DEFAULT NULL, `Probe_set_Blat_Mb_start_2016` double DEFAULT NULL, `Probe_set_Blat_Mb_end_2016` double DEFAULT NULL, `Probe_set_strand` varchar(255) DEFAULT NULL, `Probe_set_Note_by_RW` varchar(255) DEFAULT NULL, `flag` char(1) DEFAULT NULL, `Symbol_H` varchar(100) DEFAULT NULL, `description_H` varchar(255) DEFAULT NULL, `chromosome_H` char(3) DEFAULT NULL, `MB_H` double DEFAULT NULL, `alias_H` varchar(255) DEFAULT NULL, `GeneId_H` varchar(20) DEFAULT NULL, `chr_num` smallint(5) unsigned DEFAULT 30, `name_num` int(10) unsigned DEFAULT 4294967290, `Probe_Target_Description` varchar(225) DEFAULT NULL, `RefSeq_TranscriptId` varchar(255) DEFAULT NULL, `ENSEMBLGeneId` varchar(50) DEFAULT NULL, `Chr_mm8` char(3) DEFAULT NULL, `Mb_mm8` double DEFAULT NULL, `Probe_set_Blat_Mb_start_mm8` double DEFAULT NULL, `Probe_set_Blat_Mb_end_mm8` double DEFAULT NULL, `HomoloGeneID` varchar(20) DEFAULT NULL, `Biotype_ENS` varchar(255) DEFAULT NULL, `ProteinID` varchar(50) DEFAULT NULL, `ProteinName` varchar(50) DEFAULT NULL, `UniProtID` varchar(20) DEFAULT NULL, `Flybase_Id` varchar(25) DEFAULT NULL, `RGD_ID` int(10) DEFAULT NULL, `HGNC_ID` int(10) DEFAULT NULL, `HMDB_ID` varchar(255) DEFAULT NULL, `Confidence` int(5) DEFAULT NULL, `ChEBI_ID` int(10) DEFAULT NULL, `ChEMBL_ID` varchar(100) DEFAULT NULL, `CAS_number` varchar(100) DEFAULT NULL, `PubChem_ID` int(10) DEFAULT NULL, `ChemSpider_ID` int(10) DEFAULT NULL, `UNII_ID` varchar(100) DEFAULT NULL, `EC_number` varchar(100) DEFAULT NULL, `KEGG_ID` varchar(100) DEFAULT NULL, `Molecular_Weight` double DEFAULT NULL, `Nugowiki_ID` int(10) DEFAULT NULL, `Type` varchar(255) DEFAULT NULL, `Tissue` varchar(255) DEFAULT NULL, `PrimaryName` varchar(255) DEFAULT NULL, `SecondaryNames` longtext DEFAULT NULL, `PeptideSequence` varchar(20) DEFAULT NULL, `id64` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `ProbeSetId` (`ChipId`,`Name`), KEY `Name_IDX` (`Name`), KEY `symbol_IDX` (`Symbol`), KEY `RefSeq_TranscriptId` (`RefSeq_TranscriptId`), KEY `GENBANK_IDX` (`GenbankId`), KEY `TargetId` (`TargetId`), KEY `Position` (`Chr`), KEY `GeneId_IDX` (`GeneId`), FULLTEXT KEY `ft_ProbeSet_Symbol` (`Symbol`), FULLTEXT KEY `ft_ProbeSet_RefSeq_TranscriptId` (`RefSeq_TranscriptId`), FULLTEXT KEY `ft_ProbeSet_Name` (`Name`), FULLTEXT KEY `ft_ProbeSet_Alias` (`alias`), FULLTEXT KEY `ft_ProbeSet_full` (`Name`,`description`,`Symbol`,`alias`,`GenbankId`,`UniGeneId`,`Probe_Target_Description`) ) ENGINE=InnoDB AUTO_INCREMENT=13424654 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## ProbeSetData ```sql CREATE TABLE `ProbeSetData` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` int(20) NOT NULL, `value` float NOT NULL, UNIQUE KEY `DataId` (`Id`,`StrainId`), KEY `strainid` (`StrainId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## ProbeSetFreeze ```sql CREATE TABLE `ProbeSetFreeze` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0, `Name` varchar(40) DEFAULT NULL, `Name2` varchar(100) NOT NULL DEFAULT '', `FullName` varchar(100) NOT NULL DEFAULT '', `ShortName` varchar(100) NOT NULL DEFAULT '', `CreateTime` date NOT NULL DEFAULT '0000-00-00', `OrderList` int(5) DEFAULT NULL, `public` tinyint(4) NOT NULL DEFAULT 0, `confidentiality` tinyint(4) NOT NULL DEFAULT 0, `AuthorisedUsers` varchar(300) NOT NULL, `DataScale` varchar(20) NOT NULL DEFAULT 'log2', PRIMARY KEY (`Id`), UNIQUE KEY `FullName` (`FullName`), UNIQUE KEY `Name` (`Name`), KEY `NameIndex` (`Name2`) ) ENGINE=InnoDB AUTO_INCREMENT=1083 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## ProbeSetSE ```sql CREATE TABLE `ProbeSetSE` ( `DataId` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` int(20) NOT NULL, `error` float DEFAULT NULL, PRIMARY KEY (`DataId`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## ProbeSetXRef ```sql CREATE TABLE `ProbeSetXRef` ( `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0, `DataId` int(10) unsigned NOT NULL DEFAULT 0, `Locus_old` char(20) DEFAULT NULL, `LRS_old` double DEFAULT NULL, `pValue_old` double DEFAULT NULL, `mean` double DEFAULT NULL, `se` double DEFAULT NULL, `Locus` varchar(50) DEFAULT NULL, `LRS` double DEFAULT NULL, `pValue` double DEFAULT NULL, `additive` double DEFAULT NULL, `h2` float DEFAULT NULL, PRIMARY KEY (`DataId`), KEY `ProbeSetFreezeId` (`ProbeSetFreezeId`), KEY `ProbeSetId` (`ProbeSetId`), KEY `Locus_2` (`Locus`(5)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## ProbeSetXRef_old ```sql CREATE TABLE `ProbeSetXRef_old` ( `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0, `DataId` int(10) unsigned NOT NULL DEFAULT 0, `Locus_old` char(20) DEFAULT NULL, `LRS_old` double DEFAULT NULL, `pValue_old` double DEFAULT NULL, `mean` double DEFAULT NULL, `se` double DEFAULT NULL, `Locus` varchar(50) DEFAULT NULL, `LRS` double DEFAULT NULL, `pValue` double DEFAULT NULL, `additive` double DEFAULT NULL, `h2` float DEFAULT NULL, PRIMARY KEY (`ProbeSetFreezeId`,`ProbeSetId`), UNIQUE KEY `DataId_IDX` (`DataId`), KEY `Locus_IDX` (`Locus`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## ProbeXRef ```sql CREATE TABLE `ProbeXRef` ( `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `ProbeId` int(10) unsigned NOT NULL DEFAULT 0, `DataId` int(10) unsigned NOT NULL DEFAULT 0, UNIQUE KEY `ProbeId` (`ProbeFreezeId`,`ProbeId`), UNIQUE KEY `DataId_IDX` (`DataId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## Publication ```sql CREATE TABLE `Publication` ( `Id` int(10) NOT NULL AUTO_INCREMENT, `PubMed_ID` int(10) unsigned DEFAULT NULL, `Abstract` mediumtext DEFAULT NULL, `Authors` mediumtext NOT NULL, `Title` varchar(255) DEFAULT NULL, `Journal` varchar(255) DEFAULT NULL, `Volume` varchar(255) DEFAULT NULL, `Pages` varchar(255) DEFAULT NULL, `Month` varchar(255) DEFAULT NULL, `Year` varchar(255) NOT NULL DEFAULT '0', PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`PubMed_ID`), FULLTEXT KEY `index_table` (`Title`,`Abstract`,`Authors`) ) ENGINE=InnoDB AUTO_INCREMENT=39815 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## Publication_Test ```sql CREATE TABLE `Publication_Test` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `PubMed_ID` int(10) unsigned DEFAULT NULL, `Abstract` mediumtext DEFAULT NULL, `Authors` mediumtext NOT NULL, `Title` varchar(255) DEFAULT NULL, `Journal` varchar(255) DEFAULT NULL, `Volume` varchar(255) DEFAULT NULL, `Pages` varchar(255) DEFAULT NULL, `Month` varchar(255) DEFAULT NULL, `Year` varchar(255) NOT NULL DEFAULT '0', PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`PubMed_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=26076 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## PublishData ```sql CREATE TABLE `PublishData` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` int(20) NOT NULL, `value` float(14,6) DEFAULT NULL, UNIQUE KEY `DataId` (`Id`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## PublishFreeze ```sql CREATE TABLE `PublishFreeze` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(100) NOT NULL DEFAULT '', `FullName` varchar(100) NOT NULL DEFAULT '', `ShortName` varchar(100) NOT NULL DEFAULT '', `CreateTime` date NOT NULL DEFAULT '2001-01-01', `public` tinyint(4) NOT NULL DEFAULT 0, `InbredSetId` smallint(5) unsigned DEFAULT 1, `confidentiality` tinyint(3) DEFAULT 0, `AuthorisedUsers` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## PublishSE ```sql CREATE TABLE `PublishSE` ( `DataId` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` int(20) NOT NULL, `error` float NOT NULL, UNIQUE KEY `DataId` (`DataId`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## PublishXRef ```sql CREATE TABLE `PublishXRef` ( `Id` int(10) unsigned NOT NULL, `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0, `PhenotypeId` smallint(5) unsigned NOT NULL DEFAULT 0, `PublicationId` smallint(5) unsigned NOT NULL DEFAULT 0, `DataId` int(10) unsigned NOT NULL DEFAULT 0, `mean` double DEFAULT NULL, `Locus` char(50) DEFAULT NULL, `LRS` double DEFAULT NULL, `additive` double DEFAULT NULL, `Sequence` smallint(5) unsigned NOT NULL DEFAULT 1, `comments` mediumtext NOT NULL, `NSamples` int(11) DEFAULT NULL, UNIQUE KEY `InbredSet` (`InbredSetId`,`Id`), UNIQUE KEY `record` (`InbredSetId`,`PhenotypeId`,`PublicationId`,`Sequence`), UNIQUE KEY `PhenotypeId` (`PhenotypeId`), UNIQUE KEY `DataId` (`DataId`), KEY `InbredSetId` (`InbredSetId`), KEY `Locus_IDX` (`Locus`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## pubmedsearch ```sql CREATE TABLE `pubmedsearch` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pubmedid` bigint(20) DEFAULT NULL, `title` mediumtext DEFAULT NULL, `authorfullname` mediumtext DEFAULT NULL, `authorshortname` mediumtext DEFAULT NULL, `institute` mediumtext DEFAULT NULL, `geneid` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `NewIndex4` (`geneid`), FULLTEXT KEY `NewIndex1` (`institute`), FULLTEXT KEY `NewIndex3` (`authorfullname`,`authorshortname`) ) ENGINE=InnoDB AUTO_INCREMENT=1401371 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## RatSnpPattern ```sql CREATE TABLE `RatSnpPattern` ( `Id` int(12) NOT NULL AUTO_INCREMENT, `SnpId` int(12) NOT NULL, `BN` char(1) DEFAULT NULL, `F344` char(1) DEFAULT NULL, `ACI` char(1) DEFAULT NULL, `BBDP` char(1) DEFAULT NULL, `FHH` char(1) DEFAULT NULL, `FHL` char(1) DEFAULT NULL, `GK` char(1) DEFAULT NULL, `LE` char(1) DEFAULT NULL, `LEW` char(1) DEFAULT NULL, `LH` char(1) DEFAULT NULL, `LL` char(1) DEFAULT NULL, `LN` char(1) DEFAULT NULL, `MHS` char(1) DEFAULT NULL, `MNS` char(1) DEFAULT NULL, `SBH` char(1) DEFAULT NULL, `SBN` char(1) DEFAULT NULL, `SHR` char(1) DEFAULT NULL, `SHRSP` char(1) DEFAULT NULL, `SR` char(1) DEFAULT NULL, `SS` char(1) DEFAULT NULL, `WAG` char(1) DEFAULT NULL, `WLI` char(1) DEFAULT NULL, `WMI` char(1) DEFAULT NULL, `WKY` char(1) DEFAULT NULL, `ACI_N` char(1) DEFAULT NULL, `BN_N` char(1) DEFAULT NULL, `BUF_N` char(1) DEFAULT NULL, `F344_N` char(1) DEFAULT NULL, `M520_N` char(1) DEFAULT NULL, `MR_N` char(1) DEFAULT NULL, `WKY_N` char(1) DEFAULT NULL, `WN_N` char(1) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `SnpId` (`SnpId`) ) ENGINE=InnoDB AUTO_INCREMENT=4711685 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## role ```sql CREATE TABLE `role` ( `the_id` varchar(36) NOT NULL, `name` varchar(80) NOT NULL, `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`the_id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## roles_users ```sql CREATE TABLE `roles_users` ( `user_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL, KEY `user_id` (`user_id`), KEY `role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Sample ```sql CREATE TABLE `Sample` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, `Name` varchar(30) DEFAULT NULL, `Age` smallint(6) NOT NULL DEFAULT 0, `Sex` enum('F','M') NOT NULL DEFAULT 'F', `CreateTime` date NOT NULL DEFAULT '2001-01-01', `TissueType` varchar(30) DEFAULT NULL, `FromSrc` varchar(10) DEFAULT NULL, `ImageURL` varchar(100) DEFAULT NULL, `CELURL` varchar(120) DEFAULT NULL, `DATURL` varchar(100) DEFAULT NULL, `CHPURL` varchar(100) DEFAULT NULL, `RPTURL` varchar(100) DEFAULT NULL, `EXPURL` varchar(100) DEFAULT NULL, `TXTURL` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`StrainId`,`Name`,`CreateTime`) ) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## SampleXRef ```sql CREATE TABLE `SampleXRef` ( `SampleId` smallint(5) unsigned NOT NULL DEFAULT 0, `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`ProbeFreezeId`,`SampleId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## SnpAll ```sql CREATE TABLE `SnpAll` ( `Id` int(20) unsigned NOT NULL AUTO_INCREMENT, `SpeciesId` smallint(5) unsigned DEFAULT 1, `SnpName` char(30) DEFAULT NULL, `Rs` char(30) DEFAULT NULL, `Chromosome` char(2) DEFAULT NULL, `Position` double DEFAULT NULL, `Position_2016` double DEFAULT NULL, `Alleles` char(5) DEFAULT NULL, `Source` char(35) DEFAULT NULL, `ConservationScore` double DEFAULT NULL, `3Prime_UTR` mediumtext DEFAULT NULL, `5Prime_UTR` mediumtext DEFAULT NULL, `Upstream` mediumtext DEFAULT NULL, `Downstream` mediumtext DEFAULT NULL, `Intron` char(1) DEFAULT NULL, `Non_Splice_Site` mediumtext DEFAULT NULL, `Splice_Site` mediumtext DEFAULT NULL, `Intergenic` char(1) DEFAULT NULL, `Exon` char(1) DEFAULT NULL, `Non_Synonymous_Coding` mediumtext DEFAULT NULL, `Synonymous_Coding` mediumtext DEFAULT NULL, `Start_Gained` mediumtext DEFAULT NULL, `Start_Lost` mediumtext DEFAULT NULL, `Stop_Gained` mediumtext DEFAULT NULL, `Stop_Lost` mediumtext DEFAULT NULL, `Unknown_Effect_In_Exon` mediumtext DEFAULT NULL, `Domain` varchar(50) DEFAULT NULL, `Gene` varchar(30) DEFAULT NULL, `Transcript` varchar(50) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `SnpName` (`SnpName`), KEY `Rs` (`Rs`), KEY `Position` (`Chromosome`,`Position`), KEY `Source` (`Source`) ) ENGINE=InnoDB AUTO_INCREMENT=84086331 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## SnpAllele_to_be_deleted ```sql CREATE TABLE `SnpAllele_to_be_deleted` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Base` char(20) DEFAULT NULL, `Info` char(255) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## SnpAllRat ```sql CREATE TABLE `SnpAllRat` ( `Id` int(20) NOT NULL AUTO_INCREMENT, `SpeciesId` int(5) DEFAULT 2, `SnpName` char(30) DEFAULT NULL, `Chromosome` char(2) DEFAULT NULL, `Position` double DEFAULT NULL, `Alleles` char(5) DEFAULT NULL, `Source` char(35) DEFAULT NULL, `ConservationScore` double DEFAULT NULL, `Domain` varchar(50) DEFAULT NULL, `Gene` varchar(30) DEFAULT NULL, `Transcript` varchar(50) DEFAULT NULL, `Function` varchar(50) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `SnpName` (`SnpName`), KEY `Position` (`Chromosome`,`Position`), KEY `Source` (`Source`) ) ENGINE=InnoDB AUTO_INCREMENT=97663615 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## SnpPattern ```sql CREATE TABLE `SnpPattern` ( `SnpId` int(10) unsigned NOT NULL DEFAULT 0, `129P2/OlaHsd` char(1) DEFAULT NULL, `129S1/SvImJ` char(1) DEFAULT NULL, `129S5/SvEvBrd` char(1) DEFAULT NULL, `AKR/J` char(1) DEFAULT NULL, `A/J` char(1) DEFAULT NULL, `BALB/cJ` char(1) DEFAULT NULL, `C3H/HeJ` char(1) DEFAULT NULL, `C57BL/6J` char(1) DEFAULT NULL, `CAST/EiJ` char(1) DEFAULT NULL, `CBA/J` char(1) DEFAULT NULL, `DBA/2J` char(1) DEFAULT NULL, `LP/J` char(1) DEFAULT NULL, `NOD/ShiLtJ` char(1) DEFAULT NULL, `NZO/HlLtJ` char(1) DEFAULT NULL, `PWK/PhJ` char(1) DEFAULT NULL, `SPRET/EiJ` char(1) DEFAULT NULL, `WSB/EiJ` char(1) DEFAULT NULL, `PWD/PhJ` char(1) DEFAULT NULL, `SJL/J` char(1) DEFAULT NULL, `NZL/LtJ` char(1) DEFAULT NULL, `CZECHII/EiJ` char(1) DEFAULT NULL, `CALB/RkJ` char(1) DEFAULT NULL, `ST/bJ` char(1) DEFAULT NULL, `ISS/IbgTejJ` char(1) DEFAULT NULL, `C57L/J` char(1) DEFAULT NULL, `Qsi5` char(1) DEFAULT NULL, `B6A6_Esline_Regeneron` char(1) DEFAULT NULL, `129T2/SvEmsJ` char(1) DEFAULT NULL, `BALB/cByJ` char(1) DEFAULT NULL, `NZB/BlNJ` char(1) DEFAULT NULL, `P/J` char(1) DEFAULT NULL, `I/LnJ` char(1) DEFAULT NULL, `PERC/EiJ` char(1) DEFAULT NULL, `TALLYHO/JngJ` char(1) DEFAULT NULL, `CE/J` char(1) DEFAULT NULL, `MRL/MpJ` char(1) DEFAULT NULL, `PERA/EiJ` char(1) DEFAULT NULL, `IS/CamRkJ` char(1) DEFAULT NULL, `ZALENDE/EiJ` char(1) DEFAULT NULL, `Fline` char(1) DEFAULT NULL, `BTBRT<+>tf/J` char(1) DEFAULT NULL, `O20` char(1) DEFAULT NULL, `C58/J` char(1) DEFAULT NULL, `BPH/2J` char(1) DEFAULT NULL, `DDK/Pas` char(1) DEFAULT NULL, `C57BL/6NHsd` char(1) DEFAULT NULL, `C57BL/6NTac` char(1) DEFAULT NULL, `129S4/SvJae` char(1) DEFAULT NULL, `BPL/1J` char(1) DEFAULT NULL, `BPN/3J` char(1) DEFAULT NULL, `PL/J` char(1) DEFAULT NULL, `DBA/1J` char(1) DEFAULT NULL, `MSM/Ms` char(1) DEFAULT NULL, `MA/MyJ` char(1) DEFAULT NULL, `NZW/LacJ` char(1) DEFAULT NULL, `C57BL/10J` char(1) DEFAULT NULL, `C57BL/6ByJ` char(1) DEFAULT NULL, `RF/J` char(1) DEFAULT NULL, `C57BR/cdJ` char(1) DEFAULT NULL, `129S6/SvEv` char(1) DEFAULT NULL, `MAI/Pas` char(1) DEFAULT NULL, `RIIIS/J` char(1) DEFAULT NULL, `C57BL/6NNIH` char(1) DEFAULT NULL, `FVB/NJ` char(1) DEFAULT NULL, `SEG/Pas` char(1) DEFAULT NULL, `MOLF/EiJ` char(1) DEFAULT NULL, `C3HeB/FeJ` char(1) DEFAULT NULL, `Lline` char(1) DEFAULT NULL, `SKIVE/EiJ` char(1) DEFAULT NULL, `C57BL/6NCrl` char(1) DEFAULT NULL, `KK/HlJ` char(1) DEFAULT NULL, `LG/J` char(1) DEFAULT NULL, `C57BLKS/J` char(1) DEFAULT NULL, `SM/J` char(1) DEFAULT NULL, `NOR/LtJ` char(1) DEFAULT NULL, `ILS/IbgTejJ` char(1) DEFAULT NULL, `C57BL/6JOlaHsd` char(1) DEFAULT NULL, `SWR/J` char(1) DEFAULT NULL, `C57BL/6JBomTac` char(1) DEFAULT NULL, `SOD1/EiJ` char(1) DEFAULT NULL, `NON/LtJ` char(1) DEFAULT NULL, `JF1/Ms` char(1) DEFAULT NULL, `129X1/SvJ` char(1) DEFAULT NULL, `C2T1_Esline_Nagy` char(1) DEFAULT NULL, `C57BL/6NJ` char(1) DEFAULT NULL, `LEWES/EiJ` char(1) DEFAULT NULL, `RBA/DnJ` char(1) DEFAULT NULL, `DDY/JclSidSeyFrkJ` char(1) DEFAULT NULL, `SEA/GnJ` char(1) DEFAULT NULL, `C57BL/6JCrl` char(1) DEFAULT NULL, `EL/SuzSeyFrkJ` char(1) DEFAULT NULL, `HTG/GoSfSnJ` char(1) DEFAULT NULL, `129S2/SvHsd` char(1) DEFAULT NULL, `MOLG/DnJ` char(1) DEFAULT NULL, `BUB/BnJ` char(1) DEFAULT NULL, PRIMARY KEY (`SnpId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## SnpSource ```sql CREATE TABLE `SnpSource` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `Name` char(35) DEFAULT NULL, `DateCreated` date DEFAULT NULL, `DateAdded` date DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Species ```sql CREATE TABLE `Species` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `SpeciesId` int(5) DEFAULT NULL, `SpeciesName` varchar(50) DEFAULT NULL, `Name` char(30) NOT NULL DEFAULT '', `MenuName` char(50) DEFAULT NULL, `FullName` char(100) NOT NULL DEFAULT '', `Family` varchar(50) DEFAULT NULL, `FamilyOrderId` smallint(6) DEFAULT NULL, `TaxonomyId` int(11) DEFAULT NULL, `OrderId` smallint(6) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## Strain ```sql CREATE TABLE `Strain` ( `Id` int(20) NOT NULL AUTO_INCREMENT, `Name` varchar(100) DEFAULT NULL, `Name2` varchar(100) DEFAULT NULL, `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0, `Symbol` varchar(20) DEFAULT NULL, `Alias` varchar(255) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`Name`,`SpeciesId`), KEY `Symbol` (`Symbol`) ) ENGINE=InnoDB AUTO_INCREMENT=88253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## StrainXRef ```sql CREATE TABLE `StrainXRef` ( `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0, `StrainId` int(20) NOT NULL, `OrderId` int(20) DEFAULT NULL, `Used_for_mapping` char(1) DEFAULT 'N', `PedigreeStatus` varchar(255) DEFAULT NULL, PRIMARY KEY (`InbredSetId`,`StrainId`), UNIQUE KEY `Orders` (`InbredSetId`,`OrderId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## TableComments ```sql CREATE TABLE `TableComments` ( `TableName` varchar(100) NOT NULL DEFAULT '', `Comment` text DEFAULT NULL, PRIMARY KEY (`TableName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## TableFieldAnnotation ```sql CREATE TABLE `TableFieldAnnotation` ( `TableField` varchar(100) NOT NULL DEFAULT '', `Foreign_Key` varchar(100) DEFAULT NULL, `Annotation` text DEFAULT NULL, PRIMARY KEY (`TableField`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Temp ```sql CREATE TABLE `Temp` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `dbdisplayname` varchar(255) DEFAULT NULL, `Name` varchar(30) DEFAULT NULL, `description` mediumtext DEFAULT NULL, `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '2004-01-01 12:00:00', `DataId` int(11) NOT NULL DEFAULT 0, `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 1, `IP` varchar(20) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=178077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## TempData ```sql CREATE TABLE `TempData` ( `Id` int(10) unsigned NOT NULL DEFAULT 0, `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0, `value` double NOT NULL DEFAULT 0, `SE` double DEFAULT NULL, `NStrain` smallint(6) DEFAULT NULL, UNIQUE KEY `DataId` (`Id`,`StrainId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## temporary ```sql CREATE TABLE `temporary` ( `tax_id` varchar(20) DEFAULT NULL, `GeneID` varchar(20) DEFAULT NULL, `Symbol` varchar(100) DEFAULT NULL, `OMIM` varchar(100) DEFAULT NULL, `HomoloGene` varchar(100) DEFAULT NULL, `Other_GeneID` varchar(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## test_table ```sql CREATE TABLE `test_table` ( `first_col` int(11) DEFAULT NULL, `second_col` varchar(255) DEFAULT NULL, `third_col` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Tissue ```sql CREATE TABLE `Tissue` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `TissueId` int(5) DEFAULT NULL, `TissueName` varchar(50) DEFAULT NULL, `Name` char(50) DEFAULT NULL, `Short_Name` char(30) NOT NULL DEFAULT '', `BIRN_lex_ID` char(30) DEFAULT NULL, `BIRN_lex_Name` char(30) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `Short_Name` (`Short_Name`), UNIQUE KEY `Name` (`Name`) ) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## TissueProbeFreeze ```sql CREATE TABLE `TissueProbeFreeze` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0, `StrainId` varchar(100) NOT NULL DEFAULT '0', `Name` varchar(100) NOT NULL DEFAULT '', `FullName` varchar(100) NOT NULL DEFAULT '', `ShortName` varchar(100) NOT NULL DEFAULT '', `CreateTime` date NOT NULL DEFAULT '0000-00-00', `InbredSetId` smallint(5) unsigned DEFAULT 1, PRIMARY KEY (`Id`), UNIQUE KEY `Name` (`Name`), UNIQUE KEY `FullName` (`FullName`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## TissueProbeSetData ```sql CREATE TABLE `TissueProbeSetData` ( `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `TissueID` int(10) unsigned NOT NULL DEFAULT 0, `value` float NOT NULL DEFAULT 0, PRIMARY KEY (`Id`,`TissueID`) ) ENGINE=InnoDB AUTO_INCREMENT=90563 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## TissueProbeSetFreeze ```sql CREATE TABLE `TissueProbeSetFreeze` ( `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `TissueProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0, `Name` varchar(40) DEFAULT NULL, `Name2` varchar(100) NOT NULL DEFAULT '', `FullName` varchar(100) NOT NULL DEFAULT '', `ShortName` varchar(100) NOT NULL DEFAULT '', `CreateTime` date NOT NULL DEFAULT '0000-00-00', `public` tinyint(4) NOT NULL DEFAULT 0, `confidentiality` tinyint(4) NOT NULL DEFAULT 0, `AuthorisedUsers` varchar(100) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `FullName` (`FullName`), UNIQUE KEY `Name` (`Name`), KEY `NameIndex` (`Name2`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## TissueProbeSetXRef ```sql CREATE TABLE `TissueProbeSetXRef` ( `TissueProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0, `ProbesetId` int(10) unsigned NOT NULL DEFAULT 0, `DataId` int(10) unsigned NOT NULL DEFAULT 0, `Mean` float DEFAULT 0, `useStatus` char(1) DEFAULT NULL, `Symbol` varchar(100) DEFAULT NULL, `GeneId` varchar(20) DEFAULT NULL, `Chr` char(3) DEFAULT NULL, `Mb` double DEFAULT NULL, `Mb_2016` double DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `Probe_Target_Description` varchar(225) DEFAULT NULL, PRIMARY KEY (`TissueProbeSetFreezeId`,`ProbesetId`), UNIQUE KEY `DataId_IDX` (`DataId`), KEY `symbol_IDX` (`Symbol`), KEY `GeneId_IDX` (`GeneId`), KEY `Position` (`Chr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ``` ## TraitMetadata ```sql CREATE TABLE `TraitMetadata` ( `type` varchar(255) DEFAULT NULL, `value` longtext DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## User ```sql CREATE TABLE `User` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `password` varchar(100) NOT NULL DEFAULT '', `email` varchar(100) DEFAULT NULL, `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', `user_ip` varchar(20) DEFAULT NULL, `lastlogin` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00', `disable` enum('Y','N') DEFAULT 'N', `privilege` enum('guest','user','admin','root') DEFAULT NULL, `grpName` varchar(40) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name_index` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=358 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ``` ## user ```sql CREATE TABLE `user` ( `id` varchar(36) NOT NULL, `email_address` varchar(50) NOT NULL, `password` text NOT NULL, `full_name` varchar(50) DEFAULT NULL, `organization` varchar(50) DEFAULT NULL, `active` tinyint(1) NOT NULL, `registration_info` text DEFAULT NULL, `confirmed` text DEFAULT NULL, `superuser` text DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email_address` (`email_address`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## user_collection ```sql CREATE TABLE `user_collection` ( `id` varchar(36) NOT NULL, `user` varchar(36) DEFAULT NULL, `name` text DEFAULT NULL, `created_timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL, `changed_timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL, `members` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `user` (`user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## user_openids ```sql CREATE TABLE `user_openids` ( `openid_url` varchar(255) NOT NULL, `user_id` varchar(36) NOT NULL, PRIMARY KEY (`openid_url`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## UserPrivilege ```sql CREATE TABLE `UserPrivilege` ( `UserId` int(10) unsigned NOT NULL, `ProbeSetFreezeId` smallint(5) unsigned NOT NULL, `download_result_priv` enum('N','Y') NOT NULL DEFAULT 'N', KEY `userId` (`UserId`,`ProbeSetFreezeId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; ``` ## Vlookup ```sql CREATE TABLE `Vlookup` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `VLProbeSetId` mediumtext DEFAULT NULL, `VLBlatSeq` longtext DEFAULT NULL, `InfoFileId` int(5) DEFAULT NULL, `DatasetId` int(5) DEFAULT NULL, `SpeciesId` int(5) DEFAULT NULL, `TissueId` int(5) DEFAULT NULL, `InbredSetId` int(5) DEFAULT NULL, `GeneChipId` int(5) DEFAULT NULL, `AvgMethodId` int(5) DEFAULT NULL, `InfoPageName` varchar(255) DEFAULT NULL, `GN_AccesionId` int(5) DEFAULT NULL, `Name` varchar(100) DEFAULT NULL, `GeneId` varchar(10) DEFAULT NULL, `Mb` double DEFAULT NULL, `Chr` varchar(10) DEFAULT NULL, `Probe_set_Blat_Mb_start` double DEFAULT NULL, `Probe_set_Blat_Mb_end` double DEFAULT NULL, `Strand` char(1) DEFAULT NULL, `TxStart` double DEFAULT NULL, `TxEnd` double DEFAULT NULL, `cdsStart` double DEFAULT NULL, `cdsEnd` double DEFAULT NULL, `exonCount` int(7) DEFAULT NULL, `exonStarts` mediumtext DEFAULT NULL, `exonEnds` mediumtext DEFAULT NULL, `ProteinID` varchar(15) DEFAULT NULL, `AlignID` varchar(10) DEFAULT NULL, `kgID` varchar(10) DEFAULT NULL, `NM_ID` varchar(15) DEFAULT NULL, `SnpName` char(30) DEFAULT NULL, `Position` double DEFAULT NULL, `HMDB_ID` varchar(255) DEFAULT NULL, `Symbol` varchar(100) DEFAULT NULL, `description` longtext DEFAULT NULL, `alias` longtext DEFAULT NULL, `Full_Description` longtext DEFAULT NULL, `BlatSeq` mediumtext DEFAULT NULL, `ChEBI_ID` int(10) DEFAULT NULL, `ChEMBL_ID` varchar(100) DEFAULT NULL, `CAS_number` varchar(100) DEFAULT NULL, `PubChem_ID` int(10) DEFAULT NULL, `ChemSpider_ID` varchar(10) DEFAULT NULL, `UNII_ID` varchar(100) DEFAULT NULL, `EC_number` varchar(100) DEFAULT NULL, `KEGG_ID` varchar(100) DEFAULT NULL, `Molecular_Weight` varchar(100) DEFAULT NULL, `Nugowiki_ID` varchar(100) DEFAULT NULL, `assembly` varchar(10) DEFAULT NULL, PRIMARY KEY (`Id`), KEY `Id` (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=754396017 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; ```