<p>All of these data are in the <code>gene_info.gz</code> file on the NCBI FTP site: <a href="https://ftp.ncbi.nlm.nih.gov/gene/DATA/" rel="nofollow noreferrer">https://ftp.ncbi.nlm.nih.gov/gene/DATA/</a>
Specifically, you may want to look at the <code>gene_info.gz</code> file. It has the following fields (shown for an example gene below):</p>
<pre><code>                              #tax_id [  1]: 9606
                               GeneID [  2]: 5768
                               Symbol [  3]: QSOX1
                             LocusTag [  4]: -
                             Synonyms [  5]: Q6|QSCN6
                              dbXrefs [  6]: MIM:603120|HGNC:HGNC:9756|Ensembl:ENSG00000116260
                           chromosome [  7]: 1
                         map_location [  8]: 1q25.2
                          description [  9]: quiescin sulfhydryl oxidase 1
                         type_of_gene [ 10]: protein-coding
   Symbol_from_nomenclature_authority [ 11]: QSOX1
Full_name_from_nomenclature_authority [ 12]: quiescin sulfhydryl oxidase 1
                  Nomenclature_status [ 13]: O
                   Other_designations [ 14]: sulfhydryl oxidase 1|quiescin Q6 sulfhydryl oxidase 1|testis tissue sperm-binding protein Li 62n|thiol oxidase 1
                    Modification_date [ 15]: 20200604
                         Feature_type [ 16]: -
</code></pre>
<p>If you are starting  with a set of NCBI GeneIDs and want this sort of information for just those, you can use <a href="https://www.ncbi.nlm.nih.gov/books/NBK179288/" rel="nofollow noreferrer">Entrez Direct</a> for that. If you are starting with RefSeq transcript or protein accessions, be sure to check out the other files in the FTP path mentioned above.</p>

CC BY-SA 4.0
2020-06-29T17:09:57.817Z
I had tried using this file, but a bug in my code made me think it didn't have what I wanted.  Your answer made me look into it again, and I found the bug.  It's exactly what I needed.
BioBroo
CC BY-SA 4.0
2020-06-29T14:09:55.703Z
2020-06-29T14:09:55.703Z
vkkodali
<p>Go to Ensembl (<a href="https://www.ensembl.org/index.html" rel="nofollow noreferrer">https://www.ensembl.org/index.html</a>), click <code>BioMart</code> on the menu at the top of the page. Select the dataset you want to use, then go to Attributes, select the feature of each gene you want to get. Then click &quot;Results&quot; button to make sure that the table looks like what you want. Then output the results to a file.</p>
<p><a href="https://i.sstatic.net/y0A2l.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/y0A2l.png" alt="enter image description here" /></a></p>

CC BY-SA 4.0
2020-06-29T14:00:38.050Z
This is almost exactly what I'm looking for.  The only thing it is missing is as comprehensive a "Also known as" list.  For example, NCBI lists the PPP4C gene has having a total of 7 symbols, while this data set has 2.
BioBroo
CC BY-SA 4.0
2020-06-29T13:25:34.927Z
2020-06-29T13:25:34.927Z
Phoenix Mu
<p>I would like to do two things:</p>
<p>(1) Obtain a list of all NCBI (Entrez) gene ID's.</p>
<p>(2) Obtain the &quot;Official Symbol&quot;, &quot;Official Full Name&quot;, and &quot;Also known as&quot; fields from the NCBI gene pages for each of those genes.</p>
<p>This information, since it is displayed on the NCBI website, must be located in some databases, but I have not had luck finding a tool that will allow me to extract this information.</p>

<gene><phylogenetics><text-processing>
How can I obtain a list of all NCBI gene ID's along with their full name, symbol, and also known as symbols?
# How can I obtain a list of all NCBI gene ID's along with their full name, symbol, and also known as symbols?

(Asked by: username_0 on 2020-06-29)

I would like to do two things:

(1) Obtain a list of all NCBI (Entrez) gene ID's.

(2) Obtain the "Official Symbol", "Official Full Name", and "Also known as" fields from the NCBI gene pages for each of those genes.

This information, since it is displayed on the NCBI website, must be located in some databases, but I have not had luck finding a tool that will allow me to extract this information.

**Tags:** gene, phylogenetics, text-processing

---

## 2 answers

### Answer by username_1 on 2020-06-29. Score: 3 | Accepted answer

All of these data are in the gene_info.gz file on the NCBI FTP site: https://ftp.ncbi.nlm.nih.gov/gene/DATA/
Specifically, you may want to look at the gene_info.gz file. It has the following fields (shown for an example gene below):
                              #tax_id [  1]: 9606
                               GeneID [  2]: 5768
                               Symbol [  3]: QSOX1
                             LocusTag [  4]: -
                             Synonyms [  5]: Q6|QSCN6
                              dbXrefs [  6]: MIM:603120|HGNC:HGNC:9756|Ensembl:ENSG00000116260
                           chromosome [  7]: 1
                         map_location [  8]: 1q25.2
                          description [  9]: quiescin sulfhydryl oxidase 1
                         type_of_gene [ 10]: protein-coding
   Symbol_from_nomenclature_authority [ 11]: QSOX1
Full_name_from_nomenclature_authority [ 12]: quiescin sulfhydryl oxidase 1
                  Nomenclature_status [ 13]: O
                   Other_designations [ 14]: sulfhydryl oxidase 1|quiescin Q6 sulfhydryl oxidase 1|testis tissue sperm-binding protein Li 62n|thiol oxidase 1
                    Modification_date [ 15]: 20200604
                         Feature_type [ 16]: -

If you are starting  with a set of NCBI GeneIDs and want this sort of information for just those, you can use Entrez Direct for that. If you are starting with RefSeq transcript or protein accessions, be sure to check out the other files in the FTP path mentioned above.

> **Comments:**
> **username_0**: I had tried using this file, but a bug in my code made me think it didn't have what I wanted.  Your answer made me look into it again, and I found the bug.  It's exactly what I needed.  

---

### Answer by username_2 on 2020-06-29. Score: 1

Go to Ensembl (<https://www.ensembl.org/index.html>), click `BioMart` on the menu at the top of the page. Select the dataset you want to use, then go to Attributes, select the feature of each gene you want to get. Then click "Results" button to make sure that the table looks like what you want. Then output the results to a file.

[![enter image description here](https://i.sstatic.net/y0A2l.png)](https://i.sstatic.net/y0A2l.png)

> **Comments:**
> **username_0**: This is almost exactly what I'm looking for.  The only thing it is missing is as comprehensive a "Also known as" list.  For example, NCBI lists the PPP4C gene has having a total of 7 symbols, while this data set has 2.  

---

