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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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