metadata: contig_metadata: 15 rows where bioproject = "PRJNA1132896" and tax

15 rows where bioproject = "PRJNA1132896" and tax_phylum = "Euglenozoa"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5386842	5386842	PRJNA1132896_P_NODE_5665_length_265_cov_1.546875_g5574_i0	PRJNA1132896	5665	265	1.546875	4.09921875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	107	5.75e-25	NR	CUG87903.1	75058	g5574	i0	61.6	4.89056603773585	86	33	97.4	0	7	264	3	88	CUG87903.1 pyruvate kinase 2, putative [Bodo saltans]	diamond	1296	107	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
9211666	9211666	PRJNA1132896_P_NODE_7808_length_248_cov_0.880000_g7717_i0	PRJNA1132896	7808	248	0.88	2.1824	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	110	4.01e-26	NR	KAJ9448846.1	91374	g7717	i0	63.4	2.9758064516129	82	30	99.2	0	248	3	22	103	KAJ9448846.1 Adenylate cyclase [Diplonema papillatum]	diamond	738	110	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
11235123	11235123	PRJNA1132896_P_NODE_4189_length_286_cov_1.446009_g4098_i0	PRJNA1132896	4189	286	1.446009	4.13558574	Bodo saltans	75058	Euglenozoa	other_Eukaryota	102	5.03e-23	NR	CUG92417.1	75058	g4098	i0	62.9	1.68881118881119	89	29	93.4	2	2	268	375	459	CUG92417.1 ATPase, putative [Bodo saltans]	diamond	483	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
13037373	13037373	PRJNA1132896_P_NODE_7711_length_248_cov_1.662857_g7620_i0	PRJNA1132896	7711	248	1.662857	4.12388536	Bodo saltans	75058	Euglenozoa	other_Eukaryota	442	1.1399999999999995e-119	NTclustered	gi\|225216789\|gb\|FJ176704.1\|	75058	g7620	i0	98.79	130.677419354839	248	3	100	0	1	248	432	185	Bodo saltans HFCC12 28S ribosomal RNA gene, partial sequence	blastn	32408	442	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
17609434	17609434	PRJNA1132896_P_NODE_5934_length_262_cov_1.105820_g5843_i0	PRJNA1132896	5934	262	1.10582	2.8972484	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	409	1.23e-109	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g5843	i0	95.019	149.858778625954	261	11	99	2	1	260	6336	6595	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	39263	412	0.992718446601942	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
20685049	20685049	PRJNA1132896_P_NODE_8457_length_246_cov_0.890173_g8366_i0	PRJNA1132896	8457	246	0.890173	2.18982558	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	193	1.25e-44	NTclustered	gi\|1002447406\|ref\|XM_015802755.1\|	157538	g8366	i0	82.684	13.0731707317073	231	26	91	13	1	224	1691	1914	Leptomonas pyrrhocoris putative mitochondrial elongation factor 2 (EF2-1) mRNA	blastn	3216	193	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
20685052	20685052	PRJNA1132896_P_NODE_8817_length_245_cov_0.895349_g8726_i0	PRJNA1132896	8817	245	0.895349	2.19360505	Neobodo designis	312471	Euglenozoa	other_Eukaryota	414	2.45e-111	NTclustered	gi\|59891960\|gb\|AY753620.1\|	312471	g8726	i0	97.531	91.4244897959184	243	5	99	1	1	243	1200	1441	Neobodo designis isolate TeToto3 18S ribosomal RNA gene, partial sequence	blastn	22399	414	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
28681117	28681117	PRJNA1132896_P_NODE_4567_length_281_cov_1.384615_g4476_i0	PRJNA1132896	4567	281	1.384615	3.89076815	Bodo saltans	75058	Euglenozoa	other_Eukaryota	54.3	4.88e-6	NR	CUG90372.1	75058	g4476	i0	36	0.950177935943061	89	57	95	0	2	268	232	320	CUG90372.1 histidine phosphatase, putative [Bodo saltans]	diamond	267	54.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29785950	29785950	PRJNA1132896_P_NODE_4591_length_281_cov_1.067308_g4500_i0	PRJNA1132896	4591	281	1.067308	2.99913548	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	47	0.00197	NR	KAJ9452651.1	91374	g4500	i0	36.1	0.65124555160142406	61	34	61.9	2	174	1	1725	1783	KAJ9452651.1 Laminin subunit alpha [Diplonema papillatum]	diamond	183	47	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
30912652	30912652	PRJNA1132896_P_NODE_8534_length_246_cov_0.890173_g8443_i0	PRJNA1132896	8534	246	0.890173	2.18982558	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.1	1.69e-6	NR	KAJ9453699.1	91374	g8443	i0	57.4	1.42682926829268	47	20	57.3	0	8	148	306	352	KAJ9453699.1 Physarolisin [Diplonema papillatum]	diamond	351	55.1	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31555958	31555958	PRJNA1132896_P_NODE_9516_length_243_cov_0.905882_g9425_i0	PRJNA1132896	9516	243	0.905882	2.20129326	Leishmania donovani	5661	Euglenozoa	other_Eukaryota	58.2	3.26e-8	NR	XP_003864984.1	5661	g9425	i0	60.4	1.53086419753086	48	19	59.3	0	146	3	48	95	XP_003864984.1 protein kinase A catalytic subunit isoform 1, partial [Leishmania donovani]	diamond	372	58.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani
31650391	31650391	PRJNA1132896_P_NODE_8897_length_245_cov_0.895349_g8806_i0	PRJNA1132896	8897	245	0.895349	2.19360505	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	64.7	7.14e-10	NR	KAJ9448631.1	91374	g8806	i0	48.1	0.991836734693878	81	41	99.2	1	3	245	1484	1563	KAJ9448631.1 hypothetical protein DIPPA_70151 [Diplonema papillatum]	diamond	243	64.7	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31682001	31682001	PRJNA1132896_P_NODE_5337_length_270_cov_1.436548_g5246_i0	PRJNA1132896	5337	270	1.436548	3.8786796	Bodo saltans	75058	Euglenozoa	other_Eukaryota	125	1.36e-32	NR	CUE62532.1	75058	g5246	i0	63.3	1	90	33	100	0	1	270	119	208	CUE62532.1 long chain fatty acid CoA ligase, putative, partial [Bodo saltans]	diamond	270	125	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31829236	31829236	PRJNA1132896_P_NODE_5997_length_261_cov_1.367021_g5906_i0	PRJNA1132896	5997	261	1.367021	3.56792481	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62.4	5.71e-9	NR	CUG93683.1	75058	g5906	i0	50.7	2.48275862068966	69	31	78.2	2	261	58	408	474	CUG93683.1 phosphoesterase, putative [Bodo saltans]	diamond	648	62.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32819982	32819982	PRJNA1132896_P_NODE_9220_length_244_cov_0.900585_g9129_i0	PRJNA1132896	9220	244	0.900585	2.1974274	Trypanosoma congolense IL3	5692	Euglenozoa	other_Eukaryota	124	5.14e-34	NR	CCC93255.1	1068625	g9129	i0	67.9	6.97131147540984	81	25	99.6	1	243	1	78	157	CCC93255.1 unnamed protein product [Trypanosoma congolense IL3000]	diamond	1701	124	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;