http://wiki.docking.org/index.php?action=history&feed=atom&title=One_time_funky_gene_name_cleanup 2026-04-10T04:56:03Z Revision history for this page on the wiki MediaWiki 1.39.1 http://wiki.docking.org/index.php?title=One_time_funky_gene_name_cleanup&diff=9562&oldid=prev 2016-09-08T21:02:32Z

<p>asdf</p> <p><b>New page</b></p><div>era - summer 2016. jji <br /> <br /> &lt;pre&gt;<br /> put on wiki<br /> <br /> put the following text into the wiki<br /> ————<br /> Create a remapping table with old_id, new_id for all names with trailing spaces and the their trimmed counterpart then update sea, ortholog, and activity to set gene_fk=new_id where gene_id=old_id<br /> <br /> new version:<br /> <br /> create temp table genefix as select x.gene_id as old_id, y.gene_id as new_id from chembl21a.gene as x join chembl21a.gene as y on y.name=trim (trailing &#039; &#039; from x.name) where y.gene_id != x.gene_id ; <br /> <br /> update chembl21a.annotation set gene_fk=new_id from genefix where gene_fk=old_id;<br /> Update chembl21a.sea set gene_fk=new_id from genefix where gene_fk=old_id<br /> Update chembl21a.activity set gene_fk=new_id from genefix where gene_fk=old_id<br /> <br /> <br /> 88675 92117<br /> <br /> Create temp table genefix as select x.gene_id as old_id, y.gene_id as new_id from gene as x join gene as y on y.name=trim (trailing &#039; &#039; from x.name) where x.name like &#039;% &#039;;<br /> <br /> Update chemb21a.annotation set gene_fk=new_id from genefix where gene_fk=old_id<br /> Update chembl21a.sea set gene_fk=new_id from genefix where gene_fk=old_id<br /> Update chembl21a.activity set gene_fk=new_id from genefix where gene_fk=old_id<br /> <br /> update chembl21a.gene delete from chembl21a.gene where …<br /> ————<br /> &lt;/pre&gt;</div>

Frodo