Mercurial > repos > galaxyp > eggnog_mapper

annotate test-data/eggnogg_tiny.sh @ 11:1f2be4ae431f draft default tip

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 07877ba6d3fb6e28e94500f2392db6393cf325fd
author galaxyp
date Tue, 19 Jul 2022 15:14:11 +0000
parents 9d426cb7823b
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
7
9d426cb7823b "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
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
2
9d426cb7823b "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
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
4
9d426cb7823b "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"
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
6
9d426cb7823b "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 og
9d426cb7823b "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 og
9d426cb7823b "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 description = 'Cytidylyltransferase'
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
10 AND level LIKE "651137"
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
11 LIMIT 1;
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
12
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
13 CREATE TEMP TABLE event
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
14 AS SELECT * FROM event
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
15 WHERE level=651137
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
16 AND og='41T2K'
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
17 LIMIT 20;
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
18
9d426cb7823b "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 prots
9d426cb7823b "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 prots
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
21 WHERE name = "436308.Nmar_0135";
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
22
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
23 CREATE TEMP TABLE version
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
24 AS SELECT * FROM version;
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
25
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
26
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
27 .backup temp eggnog_tiny.db
9d426cb7823b "planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit e45c15081260025e470d23975ef5a734d3f8fc66"
galaxyp
parents:
diff changeset
28 EOF