reactome.db: reactome IDs not mapped to pathway names
4
0
Entering edit mode
Johannes Rainer ★ 2.0k
@johannes-rainer-6987
Last seen 7 weeks ago
Italy

dear all,

I think there is a problem with the reactome.db package: in version 1.50.0 most of the pathway IDs are not mapped to pathway names:

library( reactome.db )
reactome.list <- as.list( reactomePATHID2EXTID )
have.name <- names( reactome.list ) %in% ls( reactomePATHID2NAME )
sum( have.name )
length( have.name )

In 3.1.2 with reactome.db 1.50.0 only 1518 of 10373 pathway IDs can be mapped to a pathway name, while in R 3.0.2 with reactome.db version all of the 10469 IDs can be mapped to pathway names.

cheers, jo


sessionInfo for 3.1.2:

R version 3.1.2 (2014-10-31)
Platform: x86_64-apple-darwin14.0.0/x86_64 (64-bit)

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

attached base packages:
[1] parallel  stats4    stats     graphics  grDevices utils     datasets
[8] methods   base     

other attached packages:
[1] reactome.db_1.50.0   RSQLite_1.0.0        DBI_0.3.1           
[4] AnnotationDbi_1.28.1 GenomeInfoDb_1.2.2   IRanges_2.0.0       
[7] S4Vectors_0.4.0      Biobase_2.26.0       BiocGenerics_0.12.0


and for 3.0.2 (without the problem above):

R version 3.0.2 (2013-09-25)
Platform: x86_64-unknown-linux-gnu (64-bit)

locale:
[1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C              
[3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8    
[5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
[7] LC_PAPER=en_US.UTF-8       LC_NAME=C                 
[9] LC_ADDRESS=C               LC_TELEPHONE=C            
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       

attached base packages:
[1] parallel  stats     graphics  grDevices utils     datasets  methods  
[8] base     

other attached packages:
[1] reactome.db_1.46.1   RSQLite_0.11.4       DBI_0.2-7           
[4] AnnotationDbi_1.24.0 Biobase_2.22.0       BiocGenerics_0.8.0  

loaded via a namespace (and not attached):
[1] IRanges_1.20.7 stats4_3.0.2 

annotation pathways • 3.3k views
ADD COMMENT
1
Entering edit mode
@willemligtenberg-6989
Last seen 6.4 years ago
Netherlands

I can finally say that we have found a solution.

It was a long journey, and we will still need a long term solution, since this time they had to generate the file at Reactome, instead of me being able to do it myself. We will continue working together for a better long term solution.

I have submitted the package, and I hope it will make it in the next release. In the mean time, you can download the latest version here:
https://share.openanalytics.eu/data/public/reactome.php

ADD COMMENT
0
Entering edit mode

Hi Willem, glad to hear that a solution is in place. 

btw, the link you posted gives a '404 not found', could you please check it again?

ADD REPLY
0
Entering edit mode

Thanks, pydio didn't like the extra dot in the name I gave the link...
This one works.

ADD REPLY
0
Entering edit mode

Super! the link works now! Will try it out! Thanks a lot!

keep bugging... the name versioning seems odd, 

should it not be 'reactome.db_1.52.0.tar.gz' instead of 'reactome.db_1.0.52.tar.gz', of coz which wont interfere with the installation.

ADD REPLY
0
Entering edit mode

Hi Dan,

did you try whether the package works now?

ADD REPLY
0
Entering edit mode

I defaulted back to my original versioning scheme, sorry about that.
That should not be an issue with the version that would get into Bioconductor.

ADD REPLY
0
Entering edit mode
Dan Du ▴ 210
@dan-du-5270
Last seen 10 weeks ago
Germany

Hi Johannes, 

I got bitten by the same problem recently, currently I have to patch a little to catch those unmapped IDs. 

Hopefully someone sees this... (it is not like you can now easily cc the maintainer like we were on mailing list...)

cheers,

Dan

ADD COMMENT
0
Entering edit mode

hi Dan,

you're right, now we have to hope the developer sees this...

I had to manually install the old reactome.db package (1.48.1), which worked fine. but for now I even completely switched to the "graphite" package for the reactome data. They have a recent reactome within the package (although only human), and also provide the interactions between the genes (which is not available in reactome.db). still, would be fine if the reactome.db package would work again...

cheers, jo

ADD REPLY
0
Entering edit mode
@willemligtenberg-6989
Last seen 6.4 years ago
Netherlands

Hi Dan and Johannes,

I am looking into this. The package was generated by a script and apparently the dumps that reactome made available changed. I have asked for clarification using the contact page on reactome.org.
Thank you for bringing it up, sorry that I missed the issue myself.

Kind regards,

Willem

PS: I didn't know this existed... :)

ADD COMMENT
0
Entering edit mode

I haven't received any response yet. I will see if I can rewrite my queries to only use the normalised database.
This might take a bit though.

ADD REPLY
0
Entering edit mode

Hi all,

I have the same problem with reactome.db for Mus Musculus. I don't know if it can help, but I found that the pathway ID are not the same betweem all the databases included in reactome.db. For example, for cholesterol biosynthesis for mice, the pathway ID in reactomePATHID2EXTID is '5605312'. However, the pathway ID in reactomePATHID2NAME and in reactomePATHNAME2ID is '5943571'. So, the correspondance between the path ID obtained with reactomePATHID2EXTID and the pathway name can not be done. However, for the moment, I didn't find a solution to manually change the path ID in reactomePATHID2EXTID...

For users who are needed path name quickly, the internet site from Genscript (plasmid provider for molecular biology) still present old reactome path ID in the descriptions of their plasmids. If you just copy the path ID from reactomePATHID2EXTID to an internet browser, there will be a link to the genscript website if they are providing gene synthesis for one gene of the pathway. So it is a solution to get the path name manually. This is not an elegant solution, but it can be usefull if one need to finish a reactome analysis in emergency...

Best,

Nicolas

ADD REPLY
0
Entering edit mode

Hello everybody,

 

Do you know if a solution to get pathway names from reactome.db has been found?

Thank you in advance.

Best,

Nicolas
 

ADD REPLY
0
Entering edit mode

Hi Nicolas,

I don't think so; my solution for now is to manually install an older version of the package (so a pre-1.50.0 version).

cheers, jo

ADD REPLY
0
Entering edit mode

Hi Johannes,

It works for me with manual installation of reactome.db_1.48.0

Thank you for your help.

Best,

Nico

ADD REPLY
0
Entering edit mode
@thomas-sandmann-6817
Last seen 7 months ago
USA

Marc Carlson seems to be working with reactome on this problem, which has been discussed in a A: reactome.db is not updated?. Unfortunately, there doesn't seem to be a solution, yet. 

ADD COMMENT

Login before adding your answer.

Traffic: 589 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