metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax_clade = "Discoba"

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
27478287	27478287	PRJNA1082072_P_NODE_2183_length_250_cov_0.870056_g2176_i0	PRJNA1082072	2183	250	0.870056	2.17514	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	70.9	4.8e-12	NR	XP_002683268.1	5762	g2176	i0	77.1	0.576	48	11	57.6	0	144	1	51	98	XP_002683268.1 uncharacterized protein NAEGRDRAFT_61558 [Naegleria gruberi]	diamond	144	70.9	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
27509984	27509984	PRJNA1082072_P_NODE_1763_length_271_cov_1.813131_g1756_i0	PRJNA1082072	1763	271	1.813131	4.91358501	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	154	1.48e-46	NR	KAJ9464944.1	91374	g1756	i0	83.3	0.863468634686347	78	13	86.3	0	37	270	1	78	KAJ9464944.1 hypothetical protein DIPPA_18299 [Diplonema papillatum]	diamond	234	154	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27731188	27731188	PRJNA1082072_P_NODE_1724_length_274_cov_1.323383_g1717_i0	PRJNA1082072	1724	274	1.323383	3.62606942	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	156	8.969999999999999e-43	NR	KAJ9446580.1	91374	g1717	i0	82.4	0.996350364963504	91	16	99.6	0	273	1	369	459	KAJ9446580.1 DEAD-box ATP-dependent RNA helicase 5 [Diplonema papillatum]	diamond	273	156	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
28109628	28109628	PRJNA1082072_P_NODE_2125_length_251_cov_0.865169_g2118_i0	PRJNA1082072	2125	251	0.865169	2.17157419	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	150	1.5599999999999999e-43	NR	XP_002671207.1	5762	g2118	i0	89.2	0.99203187250996006	83	9	99.2	0	1	249	41	123	XP_002671207.1 uncharacterized protein NAEGRDRAFT_73790 [Naegleria gruberi]	diamond	249	150	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29048576	29048576	PRJNA1082072_P_NODE_1768_length_271_cov_1.550505_g1761_i0	PRJNA1082072	1768	271	1.550505	4.20186855	root	1	Root_unresolved	Root_unresolved	54.7	3.01e-6	NR	XP_015654222.1	157538	g1761	i0	37	1.4169741697417	73	46	80.8	0	6	224	240	312	XP_015654222.1 putative 3'-nucleotidase/nuclease [Leptomonas pyrrhocoris]	diamond	384	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
29624853	29624853	PRJNA1082072_P_NODE_1650_length_278_cov_1.126829_g1643_i0	PRJNA1082072	1650	278	1.126829	3.13258462	Trypanosoma cruzi Dm28c	1416333	Euglenozoa	other_Eukaryota	42.4	0.0415	NR	ESS64046.1	1416333	g1643	i0	46.2	0.561151079136691	52	24	56.1	2	110	265	96	143	ESS64046.1 hypothetical protein TCDM_13764 [Trypanosoma cruzi Dm28c]	diamond	156	42.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
30058780	30058780	PRJNA1082072_P_NODE_2331_length_248_cov_0.880000_g2324_i0	PRJNA1082072	2331	248	0.88	2.1824	Trypanosoma	5690	Euglenozoa	other_Eukaryota	100	1.89e-22	NR	AAK95376.1	5691	g2324	i0	59.7	7.39112903225806	77	31	93.1	0	16	246	629	705	AAK95376.1 vacuolar-type proton translocating pyrophosphatase 1 [Trypanosoma brucei]	diamond	1833	100	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
31774167	31774167	PRJNA1082072_P_NODE_2237_length_249_cov_2.187500_g2230_i0	PRJNA1082072	2237	249	2.1875	5.446875	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	49.7	1.46e-4	NR	AAM90826.1	5762	g2230	i0	51.3	2.18072289156627	39	19	47	0	244	128	606	644	AAM90826.1 basal body protein NBP-1 [Naegleria gruberi]	diamond	543	49.7	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
32312430	32312430	PRJNA1082072_P_NODE_2799_length_243_cov_0.905882_g2792_i0	PRJNA1082072	2799	243	0.905882	2.20129326	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	145	3.82e-38	NR	XP_002680205.1	5762	g2792	i0	96.3	0.987654320987654	80	2	98.8	1	241	2	338	416	XP_002680205.1 protein kinase [Naegleria gruberi]	diamond	240	145	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
32565548	32565548	PRJNA1082072_P_NODE_2719_length_244_cov_0.900585_g2712_i0	PRJNA1082072	2719	244	0.900585	2.1974274	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	47.8	6.67e-4	NR	KAJ9456274.1	91374	g2712	i0	50	0.590163934426229	48	20	54.1	2	2	133	369	416	KAJ9456274.1 hypothetical protein DIPPA_12637 [Diplonema papillatum]	diamond	144	47.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32754176	32754176	PRJNA1082072_P_NODE_1960_length_257_cov_1.673913_g1953_i0	PRJNA1082072	1960	257	1.673913	4.30195641	Bodo saltans	75058	Euglenozoa	other_Eukaryota	145	5e-42	NR	CUG72467.1	75058	g1953	i0	76.5	0.992217898832685	85	20	99.2	0	256	2	90	174	CUG72467.1 ADP-ribosylation factor, putative [Bodo saltans]	diamond	255	145	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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);;