How can I obtain a list of all NCBI gene ID's along with their full name, symbol, and also known as symbols?

Question

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.

Answer 1

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.

Answer 2

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.