Difference between revisions of "Virulence"
Jump to navigation
Jump to search
(Created page with "<br /> === Cross references from uniparc: === <br /><syntaxhighlight lang="sqlite3"> select BB.db_name,AA.n from (select A.db_id,count(*) as n from (select * from uniparc_cro...") |
|||
| Line 5: | Line 5: | ||
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; | 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; | ||
</syntaxhighlight><br /> | </syntaxhighlight><br /> | ||
| + | |||
| + | {| class="wikitable" | ||
| + | ! Database | ||
| + | ! Count | ||
| + | |- | ||
| + | | EMBL | ||
| + | | 12441 | ||
| + | |- | ||
| + | | UniProtKB/ | ||
| + | | 11971 | ||
| + | |- | ||
| + | | RefSeq | ||
| + | | 11749 | ||
| + | |- | ||
| + | | EMBLWGS | ||
| + | | 9526 | ||
| + | |- | ||
| + | | SEED | ||
| + | | 9414 | ||
| + | |- | ||
| + | | EnsemblBac | ||
| + | | 9071 | ||
| + | |- | ||
| + | | PATRIC | ||
| + | | 8246 | ||
| + | |- | ||
| + | | EMBL_CON | ||
| + | | 5115 | ||
| + | |- | ||
| + | | PRF | ||
| + | | 5008 | ||
| + | |- | ||
| + | | UniProtKB/ | ||
| + | | 4630 | ||
| + | |- | ||
| + | | EPO | ||
| + | | 3054 | ||
| + | |- | ||
| + | | EnsemblFun | ||
| + | | 2803 | ||
| + | |- | ||
| + | | USPTO | ||
| + | | 2375 | ||
| + | |- | ||
| + | | JPO | ||
| + | | 1997 | ||
| + | |- | ||
| + | | KIPO | ||
| + | | 455 | ||
| + | |- | ||
| + | | PDB | ||
| + | | 227 | ||
| + | |- | ||
| + | | EnsemblPro | ||
| + | | 184 | ||
| + | |- | ||
| + | | Ensembl | ||
| + | | 15 | ||
| + | |- | ||
| + | | SGD | ||
| + | | 13 | ||
| + | |- | ||
| + | | WBParaSite | ||
| + | | 11 | ||
| + | |- | ||
| + | | UniProtKB/ | ||
| + | | 10 | ||
| + | |- | ||
| + | | EnsemblPla | ||
| + | | 5 | ||
| + | |- | ||
| + | | EMBL_TSA | ||
| + | | 3 | ||
| + | |- | ||
| + | | TAIR | ||
| + | | 3 | ||
| + | |- | ||
| + | | VEGA | ||
| + | | 2 | ||
| + | |- | ||
| + | | EnsemblMet | ||
| + | | 2 | ||
| + | |- | ||
| + | | TROME | ||
| + | | 1 | ||
| + | |- | ||
| + | | VectorBase | ||
| + | | 1 | ||
| + | |} | ||
Revision as of 17:08, 25 April 2019
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;
| Database | Count |
|---|---|
| EMBL | 12441 |
| UniProtKB/ | 11971 |
| RefSeq | 11749 |
| EMBLWGS | 9526 |
| SEED | 9414 |
| EnsemblBac | 9071 |
| PATRIC | 8246 |
| EMBL_CON | 5115 |
| PRF | 5008 |
| UniProtKB/ | 4630 |
| EPO | 3054 |
| EnsemblFun | 2803 |
| USPTO | 2375 |
| JPO | 1997 |
| KIPO | 455 |
| PDB | 227 |
| EnsemblPro | 184 |
| Ensembl | 15 |
| SGD | 13 |
| WBParaSite | 11 |
| UniProtKB/ | 10 |
| EnsemblPla | 5 |
| EMBL_TSA | 3 |
| TAIR | 3 |
| VEGA | 2 |
| EnsemblMet | 2 |
| TROME | 1 |
| VectorBase | 1 |