Difference between revisions of "Dumping Script"
From WormBaseWiki
Jump to navigationJump to search| Line 1: | Line 1: | ||
| + | The dumping script lives here: | ||
| + | |||
| + | /home/postgres/work/citace_upload/papers/dumpPapAce.pl | ||
| + | |||
The dumping script will check for any dead gene IDs attached to papers and comment them out of the .ace file until they are fixed/deleted from postgres by a curator. | The dumping script will check for any dead gene IDs attached to papers and comment them out of the .ace file until they are fixed/deleted from postgres by a curator. | ||
| − | |||
The AQL query that finds all dead genes in WB is: | The AQL query that finds all dead genes in WB is: | ||
| Line 8: | Line 11: | ||
Back to [[2010_-_Paper_Pipeline:_Documentation_and_Instructions]] | Back to [[2010_-_Paper_Pipeline:_Documentation_and_Instructions]] | ||
| + | |||
| + | |||
| + | The dumping script will also check that all associated genes are in the format: WBGenennnnnnnn where the 8 n's correspond to numbers. | ||
[[Category:Curation]] | [[Category:Curation]] | ||
Revision as of 18:53, 30 August 2010
The dumping script lives here:
/home/postgres/work/citace_upload/papers/dumpPapAce.pl
The dumping script will check for any dead gene IDs attached to papers and comment them out of the .ace file until they are fixed/deleted from postgres by a curator.
The AQL query that finds all dead genes in WB is:
select all class gene where ->Species like "*elegans" and ->Status like "Dead"
Back to 2010_-_Paper_Pipeline:_Documentation_and_Instructions
The dumping script will also check that all associated genes are in the format: WBGenennnnnnnn where the 8 n's correspond to numbers.
