Answers.Body: <p>Indeed the web interface does not seem to link the full translation table, but it is available on their <a href="ftp://ftp.flybase.net" rel="nofollow noreferrer">ftp server</a> at <code>releases -&gt; release_ID -&gt; precomputed_files -&gt; genes -&gt; fbgn_fbtr_fbpp_fb_2019_06.tsv.gz</code></p>
  
  <p>For example, <a href="ftp://ftp.flybase.net/releases/FB2019_06/precomputed_files/genes/fbgn_fbtr_fbpp_fb_2019_06.tsv.gz" rel="nofollow noreferrer">this</a> is the latest (<code>FB2019_06</code>) translation table available. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-10T17:01:09.557Z
Answers.Text: took me like 20 minutes to find it, therefore I thought it might be worth sharing this with others.
Answers.UserDisplayName: Kamil S Jaron
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-10T16:59:40.240Z
Answers.LastActivityDate: 2020-02-10T16:59:40.240Z
Answers.UserDisplayName: Kamil S Jaron
Body: <p>FlyBase uses systematic naming of genes, transcripts and proteins in a format <code>FBtypeNUMBER</code>. However, the numbers are not the same for genes and their products. For example gene <code>FBgn0259101</code> transcribes to <code>FBtr0299513</code> and translates to <code>FBpp0288787</code>.</p>
  
  <p>On this <a href="https://flybase.org/convert/id" rel="nofollow noreferrer">webpage</a> users can conver individual IDs, but what If I need to convert practically whole transcriptome? Where can I get the full translation table?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-02-11T17:29:12.603Z
Comments.Text: On the right hand side you can upload file with IDs. You can  upload a file with the whole transcriptome and convert to polypeptide, you can also upload from gene > transcript and then once morte to polypeptide and merge the 2 tables yourself later.
Comments.UserDisplayName: Mack123456
Tags: <identifiers><conversion>
Title: how to get FlyBase ID conversion table
ThreadText: # how to get FlyBase ID conversion table
  
  (Asked by: username_0 on 2020-02-10)
  
  FlyBase uses systematic naming of genes, transcripts and proteins in a format `FBtypeNUMBER`. However, the numbers are not the same for genes and their products. For example gene `FBgn0259101` transcribes to `FBtr0299513` and translates to `FBpp0288787`.
  
  On this [webpage](https://flybase.org/convert/id) users can conver individual IDs, but what If I need to convert practically whole transcriptome? Where can I get the full translation table?
  
  **Tags:** identifiers, conversion
  
  > **Comments:**
  > **username_1**: On the right hand side you can upload file with IDs. You can  upload a file with the whole transcriptome and convert to polypeptide, you can also upload from gene > transcript and then once morte to polypeptide and merge the 2 tables yourself later.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-02-10. Score: 1 | Accepted answer
  
  Indeed the web interface does not seem to link the full translation table, but it is available on their [ftp server](ftp://ftp.flybase.net) at `releases -> release_ID -> precomputed_files -> genes -> fbgn_fbtr_fbpp_fb_2019_06.tsv.gz`
  
  For example, [this](ftp://ftp.flybase.net/releases/FB2019_06/precomputed_files/genes/fbgn_fbtr_fbpp_fb_2019_06.tsv.gz) is the latest (`FB2019_06`) translation table available.
  
  > **Comments:**
  > **username_0**: took me like 20 minutes to find it, therefore I thought it might be worth sharing this with others.  
  
  ---
  
  