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
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
(but not a column containing the auto-IDs)

Thank you for your help

Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
Gmod-schema mailing list
[hidden email]

signature.asc (465 bytes) Download Attachment