v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Docs Home

turbot/rnacentral

0Controls

0Variables

rnacentral_chemical_components_distribution rnacentral_databases_by_num_organisms rnacentral_databases_by_num_sequences rnacentral_feedback_distribution_by_assembly rnacentral_feedback_overlap_analysis rnacentral_interactions_by_taxid rnacentral_modifications_distribution rnacentral_total_chemical_components rnacentral_total_databases rnacentral_total_interactions rnacentral_unique_interactions_per_interacting_id

Query: rnacentral_feedback_overlap_analysis

Usage

powerpipe query rnacentral.query.rnacentral_feedback_overlap_analysis

SQL

select
  assembly_id,
  count(*) FILTER (where should_ignore = false) as "Relevant Feedbacks",
  count(*) FILTER (where should_ignore = true) as "Ignored Feedbacks"
from
  rnacen.rnc_feedback_overlap
group by
  assembly_id;

Dashboards

The query is used in the dashboards:

RNAcentral Dashboard