Mercurial > repos > galaxyp > eggnog_mapper

comparison test-data/eggnogg_tiny_taxa.sh @ 8:96cac424c870 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
author galaxyp
date Tue, 25 Jan 2022 13:51:50 +0000
parents
children
comparison
equal deleted inserted replaced
7:4e4c6329f6cd 8:96cac424c870
1 #!/bin/bash
2
3 # Script adapted from https://github.com/galaxyproteomics/egglet to produce a minimal eggnog 5.0.2 database
4
5 sqlite3 $1 << "EOF"
6
7 CREATE TEMP TABLE species
8 AS SELECT * FROM species
9 WHERE taxid in (1131266, 436308);
10
11 CREATE TEMP TABLE synonym
12 AS SELECT * FROM synonym
13 WHERE taxid in (1131266, 436308);
14
15 CREATE TEMP TABLE merged
16 AS SELECT * FROM merged
17 WHERE taxid_old in (1131266, 436308);
18
19 CREATE TEMP TABLE stats
20 AS SELECT * FROM stats;
21
22 .backup temp eggnog_tiny_taxa.db
23 EOF