TCRD v4.6.9 =========== This README describes changes from v4.6.2. PubChem CIDs ------------ - Added column cmpd_pubchem_cid to tables chembl_activity and drug_activity. - Loaded PubChem CIDs Orthologs --------- - Created new table ortholog: +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | protein_id | int(11) | NO | MUL | NULL | | | taxid | int(11) | NO | | NULL | | | species | varchar(255) | NO | | NULL | | | db_id | varchar(255) | YES | | NULL | | | geneid | int(11) | YES | | NULL | | | symbol | varchar(255) | NO | | NULL | | | name | varchar(255) | NO | | NULL | | | mod_url | text | YES | | NULL | | | sources | varchar(255) | NO | | NULL | | +------------+--------------+------+-----+---------+----------------+ - Loaded ortholog data into ortholog table. mod_url is link to respective model organism database (only populated for mouse, rat, zebrafish, fly, worm and yeast orthologs). Monarch Gene-Disease Associations --------------------------------- - Added columns O2S and S2O to disease table. - Loaded Monarch disease associations into disease table. GeneRIF Years ------------- - Added column generif.years. - Loaded years into generif. This is a text field of pipe-delimited years corresponding to the PubMed IDs in generif.pubmed_ids. NB. not all PubMeds have a date, so some years are missing. IMPC Mouse Strain Indo ---------------------- - Removed tdl_info rows where itype is 'IMPC Mice Produced' and 'IMPC Mice In Progress' - Added info_type 'IMPC Clones' and 'IMPC Status' - Loaded new IMPC tdl_infos from latest IMPC file.