Why dbConnect GEOmetadb_demo.sqlite shows some information while dbConnect GEOmetadb.sqlite shows no information
0
0
Entering edit mode
7 months ago
nonaddldy ▴ 10
>sqlfile_demo <- getSQLiteFile(destdir = "~/bin/Rpack", destfile = "GEOmetadb.sqlite_demo.gz",type="demo")
>con <- dbConnect(SQLite(),sqlfile_demo)
>getBiocPlatformMap(con)[1:5,]

output:
title      gpl                 bioc_package         manufacturer
1                                      [Maize] Affymetrix Maize Genome Array  GPL4032                                        Affymetrix
2 Agilent-026652 Whole Human Genome Microarray 4x44K v2 (Probe Name version) GPL13497        HsAgilentDesign026652 Agilent Technologies
3     Illumina HumanMethylation27 BeadChip (HumanMethylation27_270596_v.1.2)  GPL8490  IlluminaHumanMethylation27k       Illumina, Inc.
4       Illumina HumanMethylation450 BeadChip (HumanMethylation450_15017482) GPL13534 IlluminaHumanMethylation450k       Illumina, Inc.
5                                   [AG] Affymetrix Arabidopsis Genome Array    GPL71                           ag           Affymetrix
              organism data_row_count
1             Zea mays          17734
2         Homo sapiens          34184
3         Homo sapiens          27578
4         Homo sapiens         485577
5 Arabidopsis thaliana           8297

>object.size(con)

output
2112 bytes

>sqlfile <- getSQLiteFile(destdir = "~/bin/Rpack", destfile = "GEOmetadb.sqlite.gz",type="normal")
>con<-dbConnect(SQLite(),sqlfile)
>getBiocPlatformMap(con)[1:5,]

output
title  gpl bioc_package manufacturer organism data_row_count
NA    <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.1  <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.2  <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.3  <NA> <NA>         <NA>         <NA>     <NA>             NA
NA.4  <NA> <NA>         <NA>         <NA>     <NA>             NA


>object.size(con)

output
2096 bytes

The GEOmetadb.sqlite is complete

R GEO GEOmetadb • 506 views
ADD COMMENT

Login before adding your answer.

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