Entering edit mode
15 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