test_db

Tables (9)

ChEMBL_UniProt (chem_uni_map_warn)

  • No (Key) — INT(11) — Primary key — NOT NULL
  • Uniprot (accession) — char(20)
  • ChEMBL_ID (chembl_ids) — char(20)
  • protien names (protein_names) — char(100)
  • type — char(30)

Disease Map (dis_map)

  • No — INT(11) — Primary key — NOT NULL
  • diseaseId — varchar(10)
  • name — varchar(200)
  • vocabulary — varchar(10)
  • code — varchar(20)
  • vocabularyName — varchar(250)

Disease_Gene (dis_map_gene_uni)

  • No (Key) — auto_increment — Primary key — NOT NULL
  • UniProtKB (uniprotKB) — varchar(15)
  • gene_id — varchar(15)

Taget_9606_mapping (t_9606_map)

  • Key — Primary key — NOT NULL
  • tid — bigint(20)
  • pref_name — varchar(200)
  • tax_id — bigint(20)
  • chembl_id — varchar(20)
  • Uniprot (accession) — char(20)
  • chembl_ids

Target dictionary (target_dictionary)

  • tid — bigint(20)
  • target-type (target_type) — varchar(30)
  • pref_name — varchar(200)
  • tax_id — bigint(20)
  • organism — varchar(150)
  • chembl_id — varchar(20)
  • species_group_flag — tinyint(4)

Target dictionary 9606 (t_dic_9606)

  • tid — bigint(20)
  • target-type (target_type) — varchar(30)
  • pref_name — varchar(200)
  • tax_id — bigint(20)
  • organism — varchar(150)
  • chembl_id — varchar(20)
  • species_group_flag — tinyint(4)

Target dictionary map INNER (t_9606_map_inner)

  • tid — bigint(20)
  • target_type — varchar(30)
  • pref_name — varchar(200)
  • chembl_id — varchar(20)
  • No — INT(11)
  • accession — char(20)
  • chembl_ids — char(20)
  • protein_names — char(100)
  • type — char(30)

Uniprot-Disease (uni_gene_dis_left)

  • No (Key) — auto_increment — Primary key — NOT NULL
  • No (Field)
  • uniprotKB — int(11)
  • gene_id (Field3) — varchar(15)
  • geneId — varchar(15)
  • geneSymbol — varchar(15)
  • diseaseId — varchar(15)
  • diseaseName — varchar(100)
  • diseaseType — varchar(20)

dis_gene_dis

  • No — INT(11) — Primary key — NOT NULL
  • geneId — varchar(15)
  • geneSymbol — varchar(15)
  • DSI — decial(5,4)
  • DPI — decimal(5,4)
  • diseaseId — varchar(10)
  • diseaseName — varchar(100)
  • diseaseType — varchar(20)
  • diseaseClass — varchar(30)
  • diseaseSemanticType (Field9) — varchar(50)