metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA588137" 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
14593606	14593606	PRJNA588137_S_NODE_8072_length_247_cov_0.919540_g8039_i0	PRJNA588137	8072	247	0.91954	2.2712638	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	166	1.08e-46	NR	XP_002672467.1	5762	g8039	i0	89	0.995951417004049	82	9	99.6	0	2	247	117	198	XP_002672467.1 aldehyde dehydrogenase 2 family [Naegleria gruberi]	diamond	246	166	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
27459071	27459071	PRJNA588137_S_NODE_8343_length_247_cov_0.885057_g8310_i0	PRJNA588137	8343	247	0.885057	2.18609079	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	155	3.42e-44	NR	XP_044568978.1	5763	g8310	i0	89.3	3.03643724696356	84	7	99.6	1	247	2	150	233	XP_044568978.1 uncharacterized protein FDP41_007442 [Naegleria fowleri]	diamond	750	155	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
27693682	27693682	PRJNA588137_S_NODE_8904_length_245_cov_2.238372_g8871_i0	PRJNA588137	8904	245	2.238372	5.4840114	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77.4	2.26e-15	NR	XP_002671268.1	5762	g8871	i0	55.7	1.81224489795918	79	32	93.1	2	15	242	11	89	XP_002671268.1 uncharacterized protein NAEGRDRAFT_73780 [Naegleria gruberi]	diamond	444	77.4	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28153737	28153737	PRJNA588137_S_NODE_10205_length_243_cov_0.905882_g10172_i0	PRJNA588137	10205	243	0.905882	2.20129326	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	99	8.48e-24	NR	XP_002681820.1	5762	g10172	i0	66.3	0.987654320987654	80	26	98.8	1	2	241	26	104	XP_002681820.1 uncharacterized protein NAEGRDRAFT_46187 [Naegleria gruberi]	diamond	240	99	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28911002	28911002	PRJNA588137_S_NODE_9228_length_245_cov_0.895349_g9195_i0	PRJNA588137	9228	245	0.895349	2.19360505	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	84	6.22e-18	NR	XP_002671057.1	5762	g9195	i0	67.7	0.795918367346939	65	16	73.5	3	244	65	23	87	XP_002671057.1 uncharacterized protein NAEGRDRAFT_81678 [Naegleria gruberi]	diamond	195	84	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
31533648	31533648	PRJNA588137_S_NODE_9436_length_244_cov_0.900585_g9403_i0	PRJNA588137	9436	244	0.900585	2.1974274	Bodo saltans	75058	Euglenozoa	other_Eukaryota	48.1	4.81e-4	NR	CUG07766.1	75058	g9403	i0	39.7	0.897540983606557	73	44	89.8	0	241	23	669	741	CUG07766.1 Hypothetical protein, putative [Bodo saltans]	diamond	219	48.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32293067	32293067	PRJNA588137_S_NODE_10619_length_242_cov_0.911243_g10586_i0	PRJNA588137	10619	242	0.911243	2.20520806	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	117	6.79e-29	NR	XP_002682540.1	5762	g10586	i0	65.5	1.04132231404959	84	24	97.9	1	241	5	45	128	XP_002682540.1 uncharacterized protein NAEGRDRAFT_78076 [Naegleria gruberi]	diamond	252	117	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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