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...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
<br /> | <br /> | ||
| − | === Cross references from uniparc: === | + | ===Cross references from uniparc (database version 2019_02):=== |
<br /><syntaxhighlight lang="sqlite3"> | <br /><syntaxhighlight lang="sqlite3"> | ||
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 /> | ||
| + | |||
| + | * Total number of uniparc entries 14155<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 | ||
| + | |} | ||
Latest revision as of 17:10, 25 April 2019
Cross references from uniparc (database version 2019_02):
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;
- Total number of uniparc entries 14155
| 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 |