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)