Virulence - Revision history

Tpillone at 17:10, 25 April 2019

2019-04-25T17:10:01Z

Tpillone at 17:08, 25 April 2019

2019-04-25T17:08:45Z

Tpillone: Created page with "
=== Cross references from uniparc: ===
select BB.db_name,AA.n from (select A.db_id,count() as n from (select from uniparc_cro..."

2019-04-25T17:08:11Z

Created page with " === Cross references from uniparc: === <syntaxhighlight lang="sqlite3"> select BB.db_name,AA.n from (select A.db_id,count(*) as n from (select * from uniparc_cro..."

New page

=== Cross references from uniparc: ===
 <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;
</syntaxhighlight>

@@ Line 1: / Line 1: @@
 <br />
-=== Cross references from uniparc: ===
+===Cross references from uniparc (database version 2019_02):===
 <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;
 </syntaxhighlight><br />
 {| 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
 |}

← Older revision		Revision as of 17:08, 25 April 2019
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
		+	\|}

Virulence - Revision history

Tpillone at 17:10, 25 April 2019

Tpillone at 17:08, 25 April 2019

Tpillone: Created page with " === Cross references from uniparc: === select BB.db_name,AA.n from (select A.db_id,count(*) as n from (select * from uniparc_cro..."

Tpillone: Created page with "
=== Cross references from uniparc: ===
select BB.db_name,AA.n from (select A.db_id,count() as n from (select from uniparc_cro..."