Virulence
Jump to navigation
Jump to search
Cross references from uniparc:
select BB.db_name,AA.n from (select A.db_id,count(*) as n from (select * from uniparc_cross_references t1 inner join crossref_databases t2 on t1.db_id=t2.db_id group by uniparc_id,t2.db_id) A group by A.db_id) AA inner join crossref_databases BB on AA.db_id=BB.db_id order by n DESC;