TCRD v5.4.0 =================== This README describes changes from v5.2.0. DrugCentral Update ================== - DrugCentral data updated TDLs regenerated. - Added column drug_activity.dcid for DrugCentral drug IDs, so Pharos can easily link to DrugCentral. GuideToPharmacology =================== - Table chembl_activity renamed to cmpd_activity and refactored to store activities of different types (ie. from different sources): +------------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | target_id | int(11) | YES | MUL | NULL | | | catype | varchar(255) | NO | MUL | NULL | | | cmpd_id_in_src | varchar(255) | NO | | NULL | | | cmpd_name_in_src | text | YES | | NULL | | | smiles | text | YES | | NULL | | | act_value | decimal(10,8) | YES | | NULL | | | act_type | varchar(255) | YES | | NULL | | | reference | text | YES | | NULL | | | pubmed_ids | text | YES | | NULL | | | cmpd_pubchem_cid | int(11) | YES | | NULL | | +------------------+---------------+------+-----+---------+----------------+ - Added table cmpd_activity_type to store names and descriptions of compound types (sources): +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | name | varchar(255) | NO | PRI | NULL | | | description | text | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ Types in TCRDv5.4 are: ChEMBL and Guide to Pharmacology. - Loaded small molecule activities from GuideToPharmacology. TDLs ==== -TLDs regenereated and reloaded.