turbot/rnacentral

Query: rnacentral_unique_interactions_per_interacting_id

Usage

powerpipe query rnacentral.query.rnacentral_unique_interactions_per_interacting_id

SQL

select
interacting_id as "Interacting ID",
count(DISTINCT intact_id) as "Unique Interactions"
from
rnacen.rnc_interactions
group by
interacting_id
order by
"Unique Interactions" desc
limit 10;

Dashboards

The query is used in the dashboards: