Mercurial > repos > galaxyp > eggnog_mapper
annotate test-data/eggnogg_tiny_taxa.sh @ 14:d9c3016f7283 draft default tip
planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit 192779247c3385704ebd98a2cc47a210fb1f4d0c
author | galaxyp |
---|---|
date | Thu, 07 Sep 2023 18:51:23 +0000 |
parents | 96cac424c870 |
children |
rev | line source |
---|---|
8
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
1 #!/bin/bash |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
2 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
3 # Script adapted from https://github.com/galaxyproteomics/egglet to produce a minimal eggnog 5.0.2 database |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
4 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
5 sqlite3 $1 << "EOF" |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
6 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
7 CREATE TEMP TABLE species |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
8 AS SELECT * FROM species |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
9 WHERE taxid in (1131266, 436308); |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
10 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
11 CREATE TEMP TABLE synonym |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
12 AS SELECT * FROM synonym |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
13 WHERE taxid in (1131266, 436308); |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
14 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
15 CREATE TEMP TABLE merged |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
16 AS SELECT * FROM merged |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
17 WHERE taxid_old in (1131266, 436308); |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
18 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
19 CREATE TEMP TABLE stats |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
20 AS SELECT * FROM stats; |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
21 |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
22 .backup temp eggnog_tiny_taxa.db |
96cac424c870
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff
changeset
|
23 EOF |