These gene symbol are from where? What source?
3
3
Entering edit mode
5.7 years ago
cfarmeri ▴ 180

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.

gene symbol • 6.3k views
ADD COMMENT
2
Entering edit mode

Change the format on the column to "text" in excel and the transformation should get fixed. Then get that list out of Excel ASAP.

ADD REPLY
0
Entering edit mode

They are two different columns and you are viewing date and geneId columns together.

ADD REPLY
11
Entering edit mode
ADD COMMENT
1
Entering edit mode

Thanks Ryan! This URL looks so useful.

But This gene symbol list is downloaded from GEO ftp. I open this list file by "cat" UNIX command directly not use Excel.

This is responsible for the data contributor...

ADD REPLY
2
Entering edit mode

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.

ADD REPLY
13
Entering edit mode
5.7 years ago

Here's a translation table, courtesy of Deanna Church:

ADD COMMENT
0
Entering edit mode

Wow, some of those I could have predicted. But how the heck does C11orf40 get turned into 1-Nov?!?

ADD REPLY
1
Entering edit mode

My best guess is that some of these are things that happen with non-english settings, but ¯_(ツ)_/¯

ADD REPLY
0
Entering edit mode

Miller, thank you so much!

This table gives assistance to me.

ADD REPLY
0
Entering edit mode

Also MARC1 ->1-Mar and MARC2 -> 2-Mar

ADD REPLY
1
Entering edit mode
5.7 years ago
igor 12k

Excel.

There is even a paper about this phenomenon: http://bmcbioinformatics.biomedcentral.com/articles/10.1186/1471-2105-5-80

ADD COMMENT
0
Entering edit mode

thanks!

Script to scan for SymbolMutation error in this paper fig4 is so useful.

ADD REPLY

Login before adding your answer.

Traffic: 2295 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6