Stanley Wai-Kwong Ng | 21 Jun 2012 16:11
Picon

[BioMart Users] General query

Hi All,

 

I am using biomart in R to get a list of entrez gene Ids for some reactome pathways in humans.

 

I ran the following query last month and it worked with no problems:

 

library("biomaRt")

mart = useMart("REACTOME", dataset="pathway")

pathwayids = getBM(attributes=c("stableidentifier_identifier"),filters="species_selection",values=c("Homo sapiens"), mart=mart)

pathwayids = c(do.call("cbind",pathwayids))

entrezids = getBM(attributes=c("referencedatabase_entrez_gene"),filters="pathway_id_list",values=c(pathwayids[1]), mart=mart)

 

However, I tried to run the commands again last night and today and I get the following error:

 

Error in getBM(attributes = c("referencedatabase_entrez_gene"), filters = "pathway_id_list",  :

  Query ERROR: caught BioMart::Exception::Query: <pre>Query error occurred at web service based data source!

Remote data source: http://www.reactome.org:5555/biomart/martservice?

Query XML:

&lt;?xml version="1.0" encoding="UTF-8"?&gt;

&lt;!DOCTYPE Query&gt;

&lt;Query  virtualSchemaName = "default" limitStart = "" limitSize = "200" count = "" softwareVersion = "0.6" requestId= "biomart-client"&gt;

        &lt;Dataset name = "pathway" interface = "default" &gt;

                                &lt;Attribute name = "referencedatabase_entrez_gene" /&gt;

                &lt;ValueFilter name = "pathway_id_list" value = "REACT_1698"/&gt;

          &lt;/Dataset&gt;

&lt;/Query&gt;

Please ensure the above query XML is well-formed and does not contain illegal characters.

Error message from remote server as below:

Query ERROR: caught BioMart::Exception::Database: Error during query execution: Unknown column 'test_reactome_mart.pathway__referencednasequence__dm.referencedatabase_entrez_gene' in 'field list'

</pre>

 

Can anyone advise on what might be wrong?

 

Thanks,

Stan

 

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Jessica Brothwood | 25 Jun 2012 13:52
Picon
Favicon

[BioMart Users] General query

Hello,

 

Quick question I can’t find an implicit answer for,  if I query using the line:

 

<Filter name = "go_parent_term" value = " GO:0031012 "/>

 

does that return genes associated with that GO term and all of its children?

 

Thanks for any help,

Jessica



This e-mail was sent by GlaxoSmithKline Services Unlimited
(registered in England and Wales No. 1047315), which is a
member of the GlaxoSmithKline group of companies. The
registered address of GlaxoSmithKline Services Unlimited
is 980 Great West Road, Brentford, Middlesex TW8 9GS.
_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users
Arek Kasprzyk | 25 Jun 2012 14:13
Picon

Re: [BioMart Users] General query

Hi Jessica,

yes, this is correct (unless the Ensembl team have changed the rules of the mapping)

a

On Mon, Jun 25, 2012 at 12:52 PM, Jessica Brothwood <jessica.x.brothwood <at> gsk.com> wrote:

Hello,

 

Quick question I can’t find an implicit answer for,  if I query using the line:

 

<Filter name = "go_parent_term" value = " GO:0031012 "/>

 

does that return genes associated with that GO term and all of its children?

 

Thanks for any help,

Jessica



This e-mail was sent by GlaxoSmithKline Services Unlimited
(registered in England and Wales No. 1047315), which is a
member of the GlaxoSmithKline group of companies. The
registered address of GlaxoSmithKline Services Unlimited
is 980 Great West Road, Brentford, Middlesex TW8 9GS.

_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users




_______________________________________________
Users mailing list
Users <at> biomart.org
https://lists.biomart.org/mailman/listinfo/users

Gmane