search_multimir: Search the multiMiR Database Given a MySQL Query

In KechrisLab/multiMiR: Integration of multiple microRNA-target databases with their disease and drug associations

Search the multiMiR Database Given a MySQL Query

Description

This is a function for directly querying the multiMiR database with MySQL queries. Given a MySQL query, it searches and retrieves result from the multiMiR database on the multiMiR web server. To use search_multimir directly, users will need to be familiar with MySQL and multiMiR table structures. Users are advised to use get_multimir instead.

Usage

search_multimir(query)

search.multimir(query)

Arguments

query

a character string for the MySQL query.

Details

search.multimir() has been deprecated and replaced with the search_multimir() version.

Value

search_multimir returns a data frame containing results from the multiMiR web server.

Examples

  ## show all tables in the multiMiR database
  tables <- search_multimir(query="show tables")

  ## show the structure of table diana_microt
  microt <- search_multimir(query="describe diana_microt")

  ## search for validated target genes of hsa-miR-18a-3p in miRecords
  qry <- paste("SELECT m.mature_mirna_acc, m.mature_mirna_id,",
               "    t.target_symbol, t.target_entrez, t.target_ensembl,",
               "    i.experiment, i.support_type, i.pubmed_id",
               "FROM mirna AS m INNER JOIN mirecords AS i INNER JOIN target",
               "AS t ON (m.mature_mirna_uid=i.mature_mirna_uid AND",
               "    i.target_uid=t.target_uid)",
               "WHERE m.mature_mirna_id='hsa-miR-18a-3p'")
  result <- search_multimir(query = qry)

KechrisLab/multiMiR documentation built on Feb. 12, 2023, 8:26 p.m.