rnacentral_chemical_components_distributionrnacentral_databases_by_num_organismsrnacentral_databases_by_num_sequencesrnacentral_feedback_distribution_by_assemblyrnacentral_feedback_overlap_analysisrnacentral_interactions_by_taxidrnacentral_modifications_distributionrnacentral_total_chemical_componentsrnacentral_total_databasesrnacentral_total_interactionsrnacentral_unique_interactions_per_interacting_id
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_interactionsgroup by interacting_idorder by "Unique Interactions" desclimit 10;
Dashboards
The query is used in the dashboards: