[biomart-users] Issue Accessing Phytozome BioMart through R

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[biomart-users] Issue Accessing Phytozome BioMart through R

David Gemperline
Hello,

I am having a problem when trying to query phytozome datasets from R using biomaRt

when performing the following

library("biomaRt")
phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

testdata = getBM(attributes=c("gene_name1", "transcript_name1", "coding"), filters = "organism_id", values ="314", mart = phytozome)

I receive the following error.

Error in getBM(attributes = c("gene_name1", "transcript_name1", "coding"),  :
  The query to the BioMart webservice returned an invalid result: the number of columns in the result table does not equal the number of attributes in the query. Please report this to the mailing list.

wheras a test dataset from ensembl returns without error

library(biomaRt) mart <- useMart("ensembl") datasets <- listDatasets(mart) mart<-useDataset("hsapiens_gene_ensembl",mart) getBM(attributes=c("affy_hg_u95av2","hgnc_symbol","chromosome_name","band"),filters="affy_hg_u95av2",values=c("1939_at","1503_at","1454_at"), mart=mart)

 I suspect its an issue with their configuration, or a possible issue with some redirection, but don't have the experience to troubleshoot the issue. Simpler queries just give an HTML response back that doesnt make sense. 

library("biomaRt")
phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')
testdata = getBM(attributes="gene_description", filters = "organism_id", values ="314", mart = phytozome)

and testdata just returns some garbage HTML 

 gene_description 1 <!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN> 2 <html><head> 3 <title>302 Found</title> 4 </head><body> 5 <h1>Found</h1> 6 <p>The document has moved <a href=https://phytozome.jgi.doe.gov/biomart/martservice?>here</a>.</p> 7                                                                                 </body></html>

Any help would be Greatly Appreciated. I just want to make sure I am not querying their database in a completely incorrect manner.

David

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] Issue Accessing Phytozome BioMart through R

Arek Kasprzyk
Hi David,

are you still having problems with phytozome and Ensembl?

I quickly checked the service response for the registry request:



and they  both seem to responding fine (I am getting redirected to asia because i am traveling right now)


a.





On 20 April 2016 at 08:38, David Gemperline <[hidden email]> wrote:
Hello,

I am having a problem when trying to query phytozome datasets from R using biomaRt

when performing the following

library("biomaRt")
phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

testdata = getBM(attributes=c("gene_name1", "transcript_name1", "coding"), filters = "organism_id", values ="314", mart = phytozome)

I receive the following error.

Error in getBM(attributes = c("gene_name1", "transcript_name1", "coding"),  :
  The query to the BioMart webservice returned an invalid result: the number of columns in the result table does not equal the number of attributes in the query. Please report this to the mailing list.

wheras a test dataset from ensembl returns without error

library(biomaRt) mart <- useMart("ensembl") datasets <- listDatasets(mart) mart<-useDataset("hsapiens_gene_ensembl",mart) getBM(attributes=c("affy_hg_u95av2","hgnc_symbol","chromosome_name","band"),filters="affy_hg_u95av2",values=c("1939_at","1503_at","1454_at"), mart=mart)

 I suspect its an issue with their configuration, or a possible issue with some redirection, but don't have the experience to troubleshoot the issue. Simpler queries just give an HTML response back that doesnt make sense. 

library("biomaRt")
phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')
testdata = getBM(attributes="gene_description", filters = "organism_id", values ="314", mart = phytozome)

and testdata just returns some garbage HTML 

 gene_description 1 <!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN> 2 <html><head> 3 <title>302 Found</title> 4 </head><body> 5 <h1>Found</h1> 6 <p>The document has moved <a href=https://phytozome.jgi.doe.gov/biomart/martservice?>here</a>.</p> 7                                                                                 </body></html>

Any help would be Greatly Appreciated. I just want to make sure I am not querying their database in a completely incorrect manner.

David

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] Issue Accessing Phytozome BioMart through R

Steffen Durinck-2
Hi David,

Is it possible your firewall is blocking the redirecting?  
Things work for me:

> library("biomaRt")

> phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

> listAttributes(phytozome)

                                  name                      description

1                        organism_name                    Organism Name

2                           gene_name1                        Gene Name

3                     gene_description                      Description

4                            chr_name1                  Chromosome Name

5                    gene_chrom_strand                           Strand

6                     gene_chrom_start                  Gene Start (bp)

7                       gene_chrom_end                    Gene End (bp)

8                        transcript_id                PAC Transcript ID



On Wed, Apr 27, 2016 at 6:56 AM, Arek Kasprzyk <[hidden email]> wrote:
Hi David,

are you still having problems with phytozome and Ensembl?

I quickly checked the service response for the registry request:



and they  both seem to responding fine (I am getting redirected to asia because i am traveling right now)


a.





On 20 April 2016 at 08:38, David Gemperline <[hidden email]> wrote:
Hello,

I am having a problem when trying to query phytozome datasets from R using biomaRt

when performing the following

library("biomaRt")
phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

testdata = getBM(attributes=c("gene_name1", "transcript_name1", "coding"), filters = "organism_id", values ="314", mart = phytozome)

I receive the following error.

Error in getBM(attributes = c("gene_name1", "transcript_name1", "coding"),  :
  The query to the BioMart webservice returned an invalid result: the number of columns in the result table does not equal the number of attributes in the query. Please report this to the mailing list.

wheras a test dataset from ensembl returns without error

library(biomaRt) mart <- useMart("ensembl") datasets <- listDatasets(mart) mart<-useDataset("hsapiens_gene_ensembl",mart) getBM(attributes=c("affy_hg_u95av2","hgnc_symbol","chromosome_name","band"),filters="affy_hg_u95av2",values=c("1939_at","1503_at","1454_at"), mart=mart)

 I suspect its an issue with their configuration, or a possible issue with some redirection, but don't have the experience to troubleshoot the issue. Simpler queries just give an HTML response back that doesnt make sense. 

library("biomaRt")
phytozome = useMart('phytozome_mart', host="phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')
testdata = getBM(attributes="gene_description", filters = "organism_id", values ="314", mart = phytozome)

and testdata just returns some garbage HTML 

 gene_description 1 <!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN> 2 <html><head> 3 <title>302 Found</title> 4 </head><body> 5 <h1>Found</h1> 6 <p>The document has moved <a href=https://phytozome.jgi.doe.gov/biomart/martservice?>here</a>.</p> 7                                                                                 </body></html>

Any help would be Greatly Appreciated. I just want to make sure I am not querying their database in a completely incorrect manner.

David

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] Issue Accessing Phytozome BioMart through R

joe carlson
David and I traded some email about this outside this group. I wanted to post the information here so that it is more visible.

This was a biomaRt problem. We use https to connect (a requirement by our infrastructure provider) and biomaRt is set up to use http only. The 'document moved' response is our server telling biomaRt to connect via https, but biomaRt by default does not follow document moved instructions.

There may be patches to biomaRt in the future to allow for optional https connection, but for now there is a workaround to set some global options to curl

options(RCurlOptions=list(followlocation=TRUE, postredir=2L))

The discussion on bioconductor page is https://support.bioconductor.org/p/81088/

On Friday, May 13, 2016 at 1:04:31 PM UTC-7, Steffen Durinck wrote:
Hi David,

Is it possible your firewall is blocking the redirecting?  
Things work for me:

> library("biomaRt")

> phytozome = useMart('phytozome_mart', host="<a href="http://phytozome.jgi.doe.gov" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;">phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

> listAttributes(phytozome)

                                  name                      description

1                        organism_name                    Organism Name

2                           gene_name1                        Gene Name

3                     gene_description                      Description

4                            chr_name1                  Chromosome Name

5                    gene_chrom_strand                           Strand

6                     gene_chrom_start                  Gene Start (bp)

7                       gene_chrom_end                    Gene End (bp)

8                        transcript_id                PAC Transcript ID



On Wed, Apr 27, 2016 at 6:56 AM, Arek Kasprzyk <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="CR0IWiTWCAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">arek.k...@...> wrote:
Hi David,

are you still having problems with phytozome and Ensembl?

I quickly checked the service response for the registry request:

<a href="https://phytozome.jgi.doe.gov/biomart/martservice?type=registry" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFHSMFmOp7EO5Nr5S0Ez_ptCt8HNA&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFHSMFmOp7EO5Nr5S0Ez_ptCt8HNA&#39;;return true;">https://phytozome.jgi.doe.gov/biomart/martservice?type=registry

<a href="http://asia.ensembl.org/biomart/martservice?type=registry" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fasia.ensembl.org%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNG8I_8Z4f9RSc6uRUEYa9nKJ1TUWg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fasia.ensembl.org%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNG8I_8Z4f9RSc6uRUEYa9nKJ1TUWg&#39;;return true;">http://asia.ensembl.org/biomart/martservice?type=registry

and they  both seem to responding fine (I am getting redirected to asia because i am traveling right now)


a.





On 20 April 2016 at 08:38, David Gemperline <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="CR0IWiTWCAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">dcgemp...@...> wrote:
Hello,

I am having a problem when trying to query phytozome datasets from R using biomaRt

when performing the following

library("biomaRt")
phytozome = useMart('phytozome_mart', host="<a href="http://phytozome.jgi.doe.gov" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;">phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

testdata = getBM(attributes=c("gene_name1", "transcript_name1", "coding"), filters = "organism_id", values ="314", mart = phytozome)

I receive the following error.

Error in getBM(attributes = c("gene_name1", "transcript_name1", "coding"),  :
  The query to the BioMart webservice returned an invalid result: the number of columns in the result table does not equal the number of attributes in the query. Please report this to the mailing list.

wheras a test dataset from ensembl returns without error

library(biomaRt) mart <- useMart("ensembl") datasets <- listDatasets(mart) mart<-useDataset("hsapiens_gene_ensembl",mart) getBM(attributes=c("affy_hg_u95av2","hgnc_symbol","chromosome_name","band"),filters="affy_hg_u95av2",values=c("1939_at","1503_at","1454_at"), mart=mart)

 I suspect its an issue with their configuration, or a possible issue with some redirection, but don't have the experience to troubleshoot the issue. Simpler queries just give an HTML response back that doesnt make sense. 

library("biomaRt")
phytozome = useMart('phytozome_mart', host="<a href="http://phytozome.jgi.doe.gov" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;">phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')
testdata = getBM(attributes="gene_description", filters = "organism_id", values ="314", mart = phytozome)

and testdata just returns some garbage HTML 

 gene_description 1 <!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN> 2 <html><head> 3 <title>302 Found</title> 4 </head><body> 5 <h1>Found</h1> 6 <p>The document has moved <a href=<a href="https://phytozome.jgi.doe.gov/biomart/martservice" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHvRr-oOcMbVrKAcs1l6ERcZpG6bg&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHvRr-oOcMbVrKAcs1l6ERcZpG6bg&#39;;return true;">https://phytozome.jgi.doe.gov/biomart/martservice?>here</a>.</p> 7                                                                                 </body></html>

Any help would be Greatly Appreciated. I just want to make sure I am not querying their database in a completely incorrect manner.

David

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="CR0IWiTWCAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">biomart-user...@googlegroups.com.
Visit this group at <a href="https://groups.google.com/group/biomart-users" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;">https://groups.google.com/group/biomart-users.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="CR0IWiTWCAAJ" rel="nofollow" onmousedown="this.href=&#39;javascript:&#39;;return true;" onclick="this.href=&#39;javascript:&#39;;return true;">biomart-user...@googlegroups.com.
Visit this group at <a href="https://groups.google.com/group/biomart-users" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;">https://groups.google.com/group/biomart-users.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: [biomart-users] Issue Accessing Phytozome BioMart through R

David Gemperline
Hello Everyone,

Yes specifying the options workaround did fix my issue. Thanks again for all your help. I apologize about the delay in responses.

David

On Monday, May 16, 2016 at 12:03:33 PM UTC-5, [hidden email] wrote:
David and I traded some email about this outside this group. I wanted to post the information here so that it is more visible.

This was a biomaRt problem. We use https to connect (a requirement by our infrastructure provider) and biomaRt is set up to use http only. The 'document moved' response is our server telling biomaRt to connect via https, but biomaRt by default does not follow document moved instructions.

There may be patches to biomaRt in the future to allow for optional https connection, but for now there is a workaround to set some global options to curl

options(RCurlOptions=list(followlocation=TRUE, postredir=2L))

The discussion on bioconductor page is <a href="https://support.bioconductor.org/p/81088/" target="_blank" rel="nofollow" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fsupport.bioconductor.org%2Fp%2F81088%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHwCHsOlfF7ty86xuzuF8rctmPqdg&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fsupport.bioconductor.org%2Fp%2F81088%2F\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHwCHsOlfF7ty86xuzuF8rctmPqdg&#39;;return true;">https://support.bioconductor.org/p/81088/

On Friday, May 13, 2016 at 1:04:31 PM UTC-7, Steffen Durinck wrote:
Hi David,

Is it possible your firewall is blocking the redirecting?  
Things work for me:

> library("biomaRt")

> phytozome = useMart('phytozome_mart', host="<a href="http://phytozome.jgi.doe.gov" rel="nofollow" target="_blank" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;">phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

> listAttributes(phytozome)

                                  name                      description

1                        organism_name                    Organism Name

2                           gene_name1                        Gene Name

3                     gene_description                      Description

4                            chr_name1                  Chromosome Name

5                    gene_chrom_strand                           Strand

6                     gene_chrom_start                  Gene Start (bp)

7                       gene_chrom_end                    Gene End (bp)

8                        transcript_id                PAC Transcript ID



On Wed, Apr 27, 2016 at 6:56 AM, Arek Kasprzyk <[hidden email]> wrote:
Hi David,

are you still having problems with phytozome and Ensembl?

I quickly checked the service response for the registry request:

<a href="https://phytozome.jgi.doe.gov/biomart/martservice?type=registry" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFHSMFmOp7EO5Nr5S0Ez_ptCt8HNA&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNFHSMFmOp7EO5Nr5S0Ez_ptCt8HNA&#39;;return true;">https://phytozome.jgi.doe.gov/biomart/martservice?type=registry

<a href="http://asia.ensembl.org/biomart/martservice?type=registry" rel="nofollow" target="_blank" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fasia.ensembl.org%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNG8I_8Z4f9RSc6uRUEYa9nKJ1TUWg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fasia.ensembl.org%2Fbiomart%2Fmartservice%3Ftype%3Dregistry\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNG8I_8Z4f9RSc6uRUEYa9nKJ1TUWg&#39;;return true;">http://asia.ensembl.org/biomart/martservice?type=registry

and they  both seem to responding fine (I am getting redirected to asia because i am traveling right now)


a.





On 20 April 2016 at 08:38, David Gemperline <[hidden email]> wrote:
Hello,

I am having a problem when trying to query phytozome datasets from R using biomaRt

when performing the following

library("biomaRt")
phytozome = useMart('phytozome_mart', host="<a href="http://phytozome.jgi.doe.gov" rel="nofollow" target="_blank" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;">phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')

testdata = getBM(attributes=c("gene_name1", "transcript_name1", "coding"), filters = "organism_id", values ="314", mart = phytozome)

I receive the following error.

Error in getBM(attributes = c("gene_name1", "transcript_name1", "coding"),  :
  The query to the BioMart webservice returned an invalid result: the number of columns in the result table does not equal the number of attributes in the query. Please report this to the mailing list.

wheras a test dataset from ensembl returns without error

library(biomaRt) mart <- useMart("ensembl") datasets <- listDatasets(mart) mart<-useDataset("hsapiens_gene_ensembl",mart) getBM(attributes=c("affy_hg_u95av2","hgnc_symbol","chromosome_name","band"),filters="affy_hg_u95av2",values=c("1939_at","1503_at","1454_at"), mart=mart)

 I suspect its an issue with their configuration, or a possible issue with some redirection, but don't have the experience to troubleshoot the issue. Simpler queries just give an HTML response back that doesnt make sense. 

library("biomaRt")
phytozome = useMart('phytozome_mart', host="<a href="http://phytozome.jgi.doe.gov" rel="nofollow" target="_blank" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fphytozome.jgi.doe.gov\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNF_e6p6BuiXRS-d7db8beHYzU3cgg&#39;;return true;">phytozome.jgi.doe.gov", path ="/biomart/martservice/", dataset = 'phytozome')
testdata = getBM(attributes="gene_description", filters = "organism_id", values ="314", mart = phytozome)

and testdata just returns some garbage HTML 

 gene_description 1 <!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN> 2 <html><head> 3 <title>302 Found</title> 4 </head><body> 5 <h1>Found</h1> 6 <p>The document has moved <a href=<a href="https://phytozome.jgi.doe.gov/biomart/martservice" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHvRr-oOcMbVrKAcs1l6ERcZpG6bg&#39;;return true;" onclick="this.href=&#39;https://www.google.com/url?q\x3dhttps%3A%2F%2Fphytozome.jgi.doe.gov%2Fbiomart%2Fmartservice\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHvRr-oOcMbVrKAcs1l6ERcZpG6bg&#39;;return true;">https://phytozome.jgi.doe.gov/biomart/martservice?>here</a>.</p> 7                                                                                 </body></html>

Any help would be Greatly Appreciated. I just want to make sure I am not querying their database in a completely incorrect manner.

David

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to biomart-user...@googlegroups.com.
Visit this group at <a href="https://groups.google.com/group/biomart-users" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;">https://groups.google.com/group/biomart-users.
For more options, visit <a href="https://groups.google.com/d/optout" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to biomart-user...@googlegroups.com.
Visit this group at <a href="https://groups.google.com/group/biomart-users" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/group/biomart-users&#39;;return true;">https://groups.google.com/group/biomart-users.
For more options, visit <a href="https://groups.google.com/d/optout" rel="nofollow" target="_blank" onmousedown="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;" onclick="this.href=&#39;https://groups.google.com/d/optout&#39;;return true;">https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "biomart-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
Visit this group at https://groups.google.com/group/biomart-users.
For more options, visit https://groups.google.com/d/optout.