I have gene symbol list like following.
2-Sep
Hist2h4
5-Mar
Nupr1
7-Sep
5-Mar
15-Sep
11-Sep
Egam-1c
I have not ever seen "2-Sep" and "5-Mar" . These gene symbol are from where? you know?
Furthermore, do you know some ID conversion application able to change the above gene symbol to Ensemble ID.
3 answers
Congrats, someone used Excel on the dataset!
https://nsaunders.wordpress.com/2012/10/22/gene-name-errors-and-excel-lessons-not-learned/
Yep, that happens sometimes. I've seen published manuscripts with "10-Sep" listed as a gene. It's really exhibit A of why you shouldn't use excel.
Here's a translation table, courtesy of Deanna Church:
Wow, some of those I could have predicted. But how the heck does C11orf40 get turned into 1-Nov?!?
My best guess is that some of these are things that happen with non-english settings, but ¯_(ツ)_/¯
Excel.
There is even a paper about this phenomenon: http://bmcbioinformatics.biomedcentral.com/articles/10.1186/1471-2105-5-80
Log in to answer this question.
-
Retrieve only protein coding esnsemble gene ids and gene symbols
written by iibrams07 •
-
How to label columns in HTSeq output
written by mrs97 •
-
Question: Convert Ensembl Transcript Ids Ensmust To Gene Symbol In R
written by sugus
-
How to snps map gene in R (without R packages)
written by mmh7272
-
Add labels in the annotation bar of pheatmap
written by xieshaojun0621
-
Add labels in the annotation bar of pheatmap
written by xieshaojun0621
-
The Most Appropriate Statistical Test
written by cfarmeri
-
How to obtain chi-square statistics for overlaps of three GRanges objects by pair-wise?
written by Jurat Shahidin
-
Indels.vcf and SNPs.vcf from GATK ftp.
written by always_learning
-
Converting Ensemble Gene IDs from mmseq output file
written by Dataminer
They are two different columns and you are viewing date and geneId columns together.
Change the format on the column to "text" in excel and the transformation should get fixed. Then get that list out of Excel ASAP.
How to avoid conversion of gene symbols to date format in Excel