Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-29T17:09:57.817Z
Answers.Text: 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.
Answers.UserDisplayName: BioBroo
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-29T14:09:55.703Z
Answers.LastActivityDate: 2020-06-29T14:09:55.703Z
Answers.UserDisplayName: vkkodali
Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-29T14:00:38.050Z
Answers.Text: 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.
Answers.UserDisplayName: BioBroo
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-29T13:25:34.927Z
Answers.LastActivityDate: 2020-06-29T13:25:34.927Z
Answers.UserDisplayName: Phoenix Mu
Body: <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>
  
Tags: <gene><phylogenetics><text-processing>
Title: How can I obtain a list of all NCBI gene ID's along with their full name, symbol, and also known as symbols?
ThreadText: # 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](https://www.ncbi.nlm.nih.gov/books/NBK179288/) 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.  
  
  ---
  
  