SQL or script for renaming all polypeptides

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQL or script for renaming all polypeptides

Michael Dondrup-3
Hi,
I have imported a genome annotation using the chado gff bulk loader. The bulk loader has assigned
automatic names to all polypeptides (e.g. 'polypeptide-auto767716').
Is there any existing SQL or other code fragment that shows how to accomplish bulk-renaming of protein sequences
in chado from a mapping file?

I would like to assign the correct gene ID and predicted AA sequence to the auto generated
polypeptides from a fasta file with  gene-to-transcript-to-polypeptide mappings in the fasta header.
I can also generate a 3 column
mapping table like:
GeneID TranscriptID ProteinID
EMLSAG00001 EMLSAT00001EMLSAP00001
(but not a column containing the auto-IDs)

Thank you for your help
Michael

------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema

signature.asc (465 bytes) Download Attachment