query: Functions for querying and interacting with the database

In Bioconductor/hcaquery: Conversion of single cell experiment output files to relational database

Description

funtion returning a list of database table available for querying

function returning a description of a specified database table

function returning instances of all queryable tables

function to execute a SQL statement against tables in the database

function to query a file for a specific subset of genes

Usage

available_tables()

table_description(table_name)

hca_tables()

hca_sql_query(sql_statement)

hca_file_gene_query(genes = character(), file_ident = character())

Arguments

table_name	character() name of database table to be described
sql_statement	character() SQL statement to be interpolated and executed
genes	character() genes of interest
file_ident	character() ID of file to query

Examples

## Not run: available_tables()

## Not run: table_description("genes_tbl")

## Not run: hca_tables()

Bioconductor/hcaquery documentation built on Dec. 17, 2021, 10:56 a.m.