Difference between revisions of "Virulence"
Jump to navigation
Jump to search
| 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" | {| class="wikitable" | ||
| − | ! Database | + | !Database |
| − | ! Count | + | !Count |
|- | |- | ||
| − | | EMBL | + | |EMBL |
| − | | 12441 | + | |12441 |
|- | |- | ||
| − | | UniProtKB/ | + | |UniProtKB/ |
| − | | 11971 | + | |11971 |
|- | |- | ||
| − | | RefSeq | + | |RefSeq |
| − | | 11749 | + | |11749 |
|- | |- | ||
| − | | EMBLWGS | + | |EMBLWGS |
| − | | 9526 | + | |9526 |
|- | |- | ||
| − | | SEED | + | |SEED |
| − | | 9414 | + | |9414 |
|- | |- | ||
| − | | EnsemblBac | + | |EnsemblBac |
| − | | 9071 | + | |9071 |
|- | |- | ||
| − | | PATRIC | + | |PATRIC |
| − | | 8246 | + | |8246 |
|- | |- | ||
| − | | EMBL_CON | + | |EMBL_CON |
| − | | 5115 | + | |5115 |
|- | |- | ||
| − | | PRF | + | |PRF |
| − | | 5008 | + | |5008 |
|- | |- | ||
| − | | UniProtKB/ | + | |UniProtKB/ |
| − | | 4630 | + | |4630 |
|- | |- | ||
| − | | EPO | + | |EPO |
| − | | 3054 | + | |3054 |
|- | |- | ||
| − | | EnsemblFun | + | |EnsemblFun |
| − | | 2803 | + | |2803 |
|- | |- | ||
| − | | USPTO | + | |USPTO |
| − | | 2375 | + | |2375 |
|- | |- | ||
| − | | JPO | + | |JPO |
| − | | 1997 | + | |1997 |
|- | |- | ||
| − | | KIPO | + | |KIPO |
| − | | 455 | + | |455 |
|- | |- | ||
| − | | PDB | + | |PDB |
| − | | 227 | + | |227 |
|- | |- | ||
| − | | EnsemblPro | + | |EnsemblPro |
| − | | 184 | + | |184 |
|- | |- | ||
| − | | Ensembl | + | |Ensembl |
| − | | 15 | + | |15 |
|- | |- | ||
| − | | SGD | + | |SGD |
| − | | 13 | + | |13 |
|- | |- | ||
| − | | WBParaSite | + | |WBParaSite |
| − | | 11 | + | |11 |
|- | |- | ||
| − | | UniProtKB/ | + | |UniProtKB/ |
| − | | 10 | + | |10 |
|- | |- | ||
| − | | EnsemblPla | + | |EnsemblPla |
| − | | 5 | + | |5 |
|- | |- | ||
| − | | EMBL_TSA | + | |EMBL_TSA |
| − | | 3 | + | |3 |
|- | |- | ||
| − | | TAIR | + | |TAIR |
| − | | 3 | + | |3 |
|- | |- | ||
| − | | VEGA | + | |VEGA |
| − | | 2 | + | |2 |
|- | |- | ||
| − | | EnsemblMet | + | |EnsemblMet |
| − | | 2 | + | |2 |
|- | |- | ||
| − | | TROME | + | |TROME |
| − | | 1 | + | |1 |
|- | |- | ||
| − | | VectorBase | + | |VectorBase |
| − | | 1 | + | |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 |