how to get all information of a platform for all samples using GEOquery
1
1
Entering edit mode
Nemo ▴ 80
@nemo-7332
Last seen 6.8 years ago
India

Hello, 

I am trying to collect information of all samples but i don't know how to get all information for all samples.

I tired the following, is there a better way to do that ? 

gpl <- getGEO("GPL16791")
data <- gpl@header$sample_id
getInfo <- function(x){
      gps <- getGEO(x)
      gps <- unlist(gps@header)
      gps <- data.frame(gps, stringsAsFactors = F)
      gps <- t(gps)
      gps <- unique(gps)
      return(gps)
}
dat <- lapply(data, FUN = getInfo)

 

geoquery r • 2.9k views
ADD COMMENT
1
Entering edit mode
@sean-davis-490
Last seen 3 months ago
United States

Check out the GEOmetadb package.  

library(GEOmetadb)
s = getSQLiteFile()
con = dbConnect(SQLite(),s)
res = dbGetQuery(con,"select gsm,title,gpl from gsm where gpl='GPL16791'")
dim(res)
head(res)
ADD COMMENT
0
Entering edit mode

@Sean Davis Thanks for your message! I see you are the author! Can you please give me the example how to get all sample information of above platform for example using GEOmetadb ? I looked at the example provided by the package but it is chinese to me :-p 

ADD REPLY
0
Entering edit mode

Edited to include code....

ADD REPLY

Login before adding your answer.

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