Reactome pathway names from IDs?
1
0
Entering edit mode
enricoferrero ▴ 580
@enricoferrero-6037
Last seen 16 days ago
Switzerland

I have a bunch of Reactome ID that I'd like to annotate with Reactome pathway names.

Is there a way to do this through biomaRt?

If not, is reactome.db my best option? I found this in the package manual:

Mappings were based on data provided by: Reactome http://www.reactome.org/download/current/sql.gz & http://www.reactome.org/download/current/sql_dn.gz With a date stamp from the source of: 2010- Dec-21

Is reactome.db kept up to date with Reactome?

Thank you,

biomart reactome reactome.db id • 1.3k views
ADD COMMENT
3
Entering edit mode
@james-w-macdonald-5106
Last seen 15 hours ago
United States

Yes, it's kept up to date. For any annotation package, there is the SQLite database that actually contains all the data, and then a thin package wrapper that allows people to query the database without having to know any SQL. This particular package is generated in collaboration between Willem Ligtenberg and Bioconductor. He generates some of the tables in the SQLite DB, then sends it to us, and we put in the rest. So that part gets updated every six months, and it's really the only important part.

To generate the package we then take the package from the last release, dump out the database, and put the new one in there, increment the version number, and build. So everything except the SQLite database is old, having been originally generated back in 2010. This includes the part you show above - if you go to that website, there isn't even a sql.gz file in there! Probably hasn't been one for years.

Probably more than you wanted to know, but hope it helps.

ADD COMMENT
1
Entering edit mode

Thank you James for answering this.
Indeed, every six months we update the reactome.db package.
Once there were some issues when Reactome changed their database dumps, but we updated our end, and everything is functioning fine again.

ADD REPLY
0
Entering edit mode

Thanks both!
May I suggest to update the docs by removing that misleading statement?
Cheers,

ADD REPLY
1
Entering edit mode

sure, and done! :)

ADD REPLY
0
Entering edit mode

Hi Willem,

Please note that I didn't use the package you sent me for this last annotation build. I just took the SQLite DB and put it into the package from the last release, because there was something wrong with the code in the package you sent me. In other words, after I updated the SQLite DB with our data, and then did a build and check, it failed. So I downloaded a source version of reactome.db from last release, extracted it, put the SQLite DB into that package, bumped the version and then built/checked. That did work.

So if you are updating the docs in whatever package shell you used, don't bother. Instead, get the source version of the current release package and update that instead. Then when you send to Val (next time), she should be able to use what you send directly.

Does that make sense?

Jim

ADD REPLY
0
Entering edit mode

yes it does. :)

ADD REPLY

Login before adding your answer.

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