{
  "_id": "6a1acedf1d7bb097a09e013a",
  "Package": "GEOmetadb",
  "Type": "Package",
  "Title": "A compilation of metadata from NCBI GEO",
  "Version": "1.75.0",
  "Date": "2026-03-24",
  "Author": "Jack Zhu and Sean Davis",
  "Maintainer": "Jack Zhu <zhujack@mail.nih.gov>",
  "biocViews": "Infrastructure",
  "Description": "The NCBI Gene Expression Omnibus (GEO) represents the\nlargest public repository of microarray data. However, finding\ndata of interest can be challenging using current tools.\nGEOmetadb is an attempt to make access to the metadata\nassociated with samples, platforms, and datasets much more\nfeasible. This is accomplished by parsing all the NCBI GEO\nmetadata into a SQLite database that can be stored and queried\nlocally. GEOmetadb is simply a thin wrapper around the SQLite\ndatabase along with associated documentation. Finally, the\nSQLite database is updated regularly as new data is added to\nGEO and can be downloaded at will for the most up-to-date\nmetadata. GEOmetadb paper:\nhttp://bioinformatics.oxfordjournals.org/cgi/content/short/24/23/2798",
  "VignetteBuilder": "knitr",
  "License": "Artistic-2.0",
  "Repository": "https://bioc.r-universe.dev",
  "Date/Publication": "2026-04-28 12:32:50 UTC",
  "RemoteUrl": "https://github.com/bioc/GEOmetadb",
  "RemoteRef": "HEAD",
  "RemoteSha": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-30 08:16:41 UTC",
    "User": "root"
  },
  "MD5sum": "f87167e75bd1f4463451eb19c56c19b4",
  "_user": "bioc",
  "_type": "src",
  "_file": "GEOmetadb_1.75.0.tar.gz",
  "_fileid": "57c7756eee17da93bee92c6def3b0b1ee24c6ecd3e8906d95edeed5de7f9fbbd",
  "_filesize": 525586,
  "_sha256": "57c7756eee17da93bee92c6def3b0b1ee24c6ecd3e8906d95edeed5de7f9fbbd",
  "_created": "2026-05-30T08:16:41.000Z",
  "_published": "2026-05-30T11:49:51.851Z",
  "_jobs": [
    {
      "job": 78635999730,
      "time": 140,
      "config": "bioc-checks",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7306773879"
    },
    {
      "job": 78635999741,
      "time": 214,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7306780512"
    },
    {
      "job": 78635999740,
      "time": 170,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7306776483"
    },
    {
      "job": 78635999734,
      "time": 84,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "7307960107"
    },
    {
      "job": 78635999732,
      "time": 86,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7307960525"
    },
    {
      "job": 78635831112,
      "time": 199,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7306760470"
    },
    {
      "job": 78635999733,
      "time": 116,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7306771625"
    },
    {
      "job": 78635999745,
      "time": 94,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "WARNING",
      "artifact": "7306769535"
    },
    {
      "job": 78635999748,
      "time": 90,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "WARNING",
      "artifact": "7306769315"
    },
    {
      "job": 78635999743,
      "time": 106,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "WARNING",
      "artifact": "7306770958"
    }
  ],
  "_bioccheck": {
    "error": 2,
    "warning": 3,
    "note": 15
  },
  "_buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/bioc/GEOmetadb",
  "_commit": {
    "id": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
    "author": "A Wokaty <andres.wokaty@sph.cuny.edu>",
    "committer": "A Wokaty <andres.wokaty@sph.cuny.edu>",
    "message": "bump x.y.z version to odd y following creation of RELEASE_3_23 branch\n",
    "time": 1777379570
  },
  "_maintainer": {
    "name": "Jack Zhu",
    "email": "zhujack@mail.nih.gov",
    "login": "zhujack8",
    "description": "",
    "uuid": 129963942
  },
  "_distro": "noble",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R.utils",
      "role": "Depends"
    },
    {
      "package": "RSQLite",
      "role": "Depends"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "dplyr",
      "role": "Suggests"
    },
    {
      "package": "dbplyr",
      "role": "Suggests"
    },
    {
      "package": "tm",
      "role": "Suggests"
    },
    {
      "package": "wordcloud",
      "role": "Suggests"
    }
  ],
  "_owner": "bioc",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-44",
      "n": 2
    },
    {
      "week": "2026-13",
      "n": 3
    },
    {
      "week": "2026-18",
      "n": 2
    }
  ],
  "_tags": [],
  "_bioc": [
    {
      "branch": "devel",
      "version": "1.75.0",
      "bioc": "3.24"
    },
    {
      "branch": "release",
      "version": "1.74.0",
      "bioc": "3.23"
    }
  ],
  "_topics": [
    "infrastructure"
  ],
  "_userbio": {
    "uuid": 2286807,
    "type": "organization",
    "name": "Bioconductor",
    "description": "Software for the analysis and comprehension of high-throughput genomic data"
  },
  "_downloads": {
    "count": 645,
    "source": "https://www.bioconductor.org/packages/stats/bioc/GEOmetadb"
  },
  "_mentions": 27,
  "_searchresults": 247,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/GEOmetadb.html",
    "extra/readme.html",
    "extra/readme.md",
    "manual.pdf"
  ],
  "_realowner": "bioc",
  "_cranurl": false,
  "_exports": [
    "columnDescriptions",
    "geoConvert",
    "getBiocPlatformMap",
    "getSQLiteFile"
  ],
  "_help": [
    {
      "page": "GEOmetadb-package",
      "title": "Query NCBI GEO metadata from a local SQLite database",
      "topics": [
        "GEOmetadb-package",
        "GEOmetadb"
      ]
    },
    {
      "page": "columnDescriptions",
      "title": "Get column descriptions for the GEOmetadb database",
      "topics": [
        "columnDescriptions"
      ]
    },
    {
      "page": "geoConvert",
      "title": "Cross-reference between GEO data types",
      "topics": [
        "geoConvert"
      ]
    },
    {
      "page": "getBiocPlatformMap",
      "title": "Get mappings between GPL and Bioconductor microarry annotation packages",
      "topics": [
        "getBiocPlatformMap"
      ]
    },
    {
      "page": "getSQLiteFile",
      "title": "Download and unzip the most recent GEOmetadb SQLite file",
      "topics": [
        "getSQLiteFile"
      ]
    }
  ],
  "_readme": "https://github.com/bioc/GEOmetadb/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "fastmap",
    "glue",
    "lifecycle",
    "memoise",
    "pkgconfig",
    "R.methodsS3",
    "R.oo",
    "R.utils",
    "rlang",
    "RSQLite",
    "vctrs"
  ],
  "_vignettes": [
    {
      "source": "GEOmetadb.Rmd",
      "filename": "GEOmetadb.html",
      "title": "Using the GEOmetadb Package",
      "author": "Jack Zhu and Sean Davis",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview of GEOmetadb",
        "Citing GEOmetadb",
        "What is GEOmetadb?",
        "Conversion capabilities",
        "What GEOmetadb is not",
        "Getting Started",
        "Getting the GEOmetadb database",
        "A word about SQL",
        "Examples",
        "Interacting with the database",
        "Writing SQL queries and getting results",
        "Conversion of GEO entity types",
        "Mappings between GPL and Bioconductor microarry annotation packages",
        "More advanced queries",
        "A wordcloud of GSE titles",
        "Using dplyr with GEOmetadb",
        "Cleanup",
        "sessionInfo()"
      ],
      "created": "2014-09-21 23:22:36",
      "modified": "2026-03-24 11:13:54",
      "commits": 16
    }
  ],
  "_score": 6.568788212315347,
  "_indexed": true,
  "_nocasepkg": "geometadb",
  "_universes": [
    "bioc",
    "zhujack8"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.75.0",
      "date": "2026-05-30T08:20:04.000Z",
      "distro": "noble",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "81c2f97b30fd662b53725b83a17cf51bff4f27c47b742ce31a5dc401e81b7e0e",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.75.0",
      "date": "2026-05-30T08:19:27.000Z",
      "distro": "noble",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "5ca5fc1f5dbfcaf8ced6f4889b729c56334ecce8f7c4b9b82fe7c43f1be0ba3e",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.75.0",
      "date": "2026-05-30T11:49:18.000Z",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "f4f1cd2ad453980cfa93f8cac1fcd04e29d7edef93e2c7b904f8760aa187c357",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.75.0",
      "date": "2026-05-30T11:49:19.000Z",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "dd1b8bbd4795cb5e3e42da3b8f6abbec47ccf89b41b5a848d890b04d86a8d0dd",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.75.0",
      "date": "2026-05-30T08:18:51.000Z",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "c255057627f3b20458a0c33fd4f5c66034c390102e8cafc4a18ad19cf774bfa3",
      "status": "success",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.75.0",
      "date": "2026-05-30T08:18:05.000Z",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "08880205978a348c026abe28ca188a798bf9efd257ded02b3a13f7a54b24e58a",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.75.0",
      "date": "2026-05-30T08:18:03.000Z",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "9a8dd19b2c26b7dc76375e36e40e3424e170fed9fc9961fcb661dd1dfea35d4c",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.75.0",
      "date": "2026-05-30T08:18:21.000Z",
      "commit": "28688e04f4e57b52f6478c510fc3f5d253b1cf3a",
      "fileid": "df4f19598c39672ec58ce2cc70f96963d11498b3c71fc6a04b9ab94397baf33a",
      "status": "success",
      "check": "WARNING",
      "buildurl": "https://github.com/r-universe/bioc/actions/runs/26678950122"
    }
  ]
}