Mercurial > repos > galaxyp > eggnog_mapper

comparison test-data/eggnogg_tiny.sh @ 7:9d426cb7823b 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:50:15 +0000
parents
children
comparison
equal deleted inserted replaced
6:1d6c4af4b7bc 7:9d426cb7823b
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 og
8 AS SELECT * FROM og
9 WHERE description = 'Cytidylyltransferase'
10 AND level LIKE "651137"
11 LIMIT 1;
12
13 CREATE TEMP TABLE event
14 AS SELECT * FROM event
15 WHERE level=651137
16 AND og='41T2K'
17 LIMIT 20;
18
19 CREATE TEMP TABLE prots
20 AS SELECT * FROM prots
21 WHERE name = "436308.Nmar_0135";
22
23 CREATE TEMP TABLE version
24 AS SELECT * FROM version;
25
26
27 .backup temp eggnog_tiny.db
28 EOF