For the past few days I have been trying to compile the list of gene names that is the most complete possible. To start with, I was given an initial list of genes in an excel file that was taken from the HUGO Gene Nomenclature Committee (HGNC). Unfortunately, the gene names were pasted from the original source (HGNC) to an Excel spreadsheet without modifying the expected format of the column cells. This led to Excel trying to “help” with the formatting of the value inserted, changing those gene names that are similar to dates to an actual date. In the bioinformatics field, misnaming a gene can lead to disastrous consequences such as misdiagnosis of a causal gene in a clinical setting. Thus:
Beware of pasting gene names in an Excel spreadsheet with a default format, as these may be changed into dates.
From my current list of 19,026 genes that I have compiled as of now, here are the names of the genes that have been automatically changed by Excel into dates. In the table below, the first column denotes the date the gene name is changed to, the middle column the Ensembl ID of the gene and the right column the actual name that was changed by Excel into a date.
Sep-01Â Â Â ENSG00000180096Â Â Â SEPT1Â Â Â Sep-02Â Â Â ENSG00000168385Â Â Â Â Â Â SEPT2 Sep-03Â Â Â ENSG00000100167Â Â Â Â Â Â SEPT3 Sep-04Â Â Â ENSG00000108387Â Â Â Â Â Â SEPT4 Sep-05Â Â Â ENSG00000184702Â Â Â Â Â Â SEPT5 Sep-06Â Â Â ENSG00000125354Â Â Â Â Â Â SEPT6 Sep-07Â Â Â ENSG00000122545Â Â Â Â Â Â SEPT7 Sep-08Â Â Â ENSG00000164402Â Â Â Â Â Â SEPT8 Sep-09Â Â Â ENSG00000184640Â Â Â Â Â Â SEPT9 Sep-10Â Â Â ENSG00000186522Â Â Â Â Â Â SEPT10 Sep-11Â Â Â ENSG00000138758Â Â Â Â Â Â SEPT11 Sep-12Â Â Â ENSG00000140623Â Â Â Â Â Â SEPT12 Sep-14Â Â Â ENSG00000154997Â Â Â Â Â Â SEPT14 Mar-01Â Â Â ENSG00000145416Â Â Â Â Â Â MARCH1 Mar-02Â Â Â ENSG00000099785Â Â Â Â Â Â MARCH2 Mar-03Â Â Â ENSG00000173926Â Â Â Â Â Â MARCH3 Mar-04Â Â Â ENSG00000144583Â Â Â Â Â Â MARCH4 Mar-05Â Â Â ENSG00000198060Â Â Â Â Â Â MARCH5 Mar-06Â Â Â ENSG00000145495Â Â Â Â Â Â MARCH6 Mar-07Â Â Â ENSG00000136536Â Â Â Â Â Â MARCH7 Mar-08Â Â Â ENSG00000165406Â Â Â Â Â Â MARCH8 Mar-09Â Â Â ENSG00000139266Â Â Â Â Â Â MARCH9 Mar-10Â Â Â ENSG00000173838Â Â Â Â Â Â MARCH10 Mar-11Â Â Â ENSG00000183654Â Â Â Â Â Â MARCH11 Dec-01Â Â Â ENSG00000173077Â Â Â Â Â Â Â DEC1
Leave a Reply