<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>

CC BY-SA 4.0
2020-02-10T17:01:09.557Z
took me like 20 minutes to find it, therefore I thought it might be worth sharing this with others.
Kamil S Jaron
CC BY-SA 4.0
2020-02-10T16:59:40.240Z
2020-02-10T16:59:40.240Z
Kamil S Jaron
<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>

CC BY-SA 4.0
2020-02-11T17:29:12.603Z
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.
Mack123456
<identifiers><conversion>
how to get FlyBase ID conversion table
# 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.  

---

