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

7 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax_phylum = "Heterolobosea"

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_family	tax_genus	tax_species
17502465	17502465	PRJNA944406_P_NODE_16814_length_316_cov_1.156379_g15855_i0	PRJNA944406	16814	316	1.156379	3.65415764	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	151	2.96e-44	NR	CAG4714041.1	5763	g15855	i0	71	12.8639240506329	107	29	99.7	1	1	315	1	107	CAG4714041.1 unnamed protein product, partial [Naegleria fowleri]	diamond	4065	152	0.993421052631579	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
27095260	27095260	PRJNA944406_P_NODE_11602_length_368_cov_1.305085_g10643_i0	PRJNA944406	11602	368	1.305085	4.8027128	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	105	1.7699999999999998e-23	NR	XP_002672763.1	5762	g10643	i0	54.9	2.66576086956522	82	37	66.8	0	365	120	465	546	XP_002672763.1 uncharacterized protein NAEGRDRAFT_72167 [Naegleria gruberi]	diamond	981	106	0.990566037735849	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
27151350	27151350	PRJNA944406_P_NODE_94882_length_244_cov_0.900585_g93923_i0	PRJNA944406	94882	244	0.900585	2.1974274	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	129	7.41e-35	NR	KAL0485674.1	1008807	g93923	i0	76.3	0.983606557377049	80	19	98.4	0	242	3	152	231	KAL0485674.1 kelch-like protein [Acrasis kona]	diamond	240	129	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
27594166	27594166	PRJNA944406_P_NODE_37584_length_275_cov_1.217822_g36625_i0	PRJNA944406	37584	275	1.217822	3.3490105	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	46.2	0.00315	NR	XP_044563266.1	5763	g36625	i0	47.3	0.6	55	29	60	0	2	166	193	247	XP_044563266.1 uncharacterized protein FDP41_002373 [Naegleria fowleri]	diamond	165	46.2	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
27720833	27720833	PRJNA944406_P_NODE_77224_length_248_cov_0.880000_g76265_i0	PRJNA944406	77224	248	0.88	2.1824	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	67.8	6.04e-11	NR	XP_002673976.1	5762	g76265	i0	69.1	0.82258064516129	68	14	76.2	4	60	248	463	528	XP_002673976.1 uncharacterized protein NAEGRDRAFT_70914 [Naegleria gruberi]	diamond	204	67.8	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
28674376	28674376	PRJNA944406_P_NODE_32847_length_279_cov_1.495146_g31888_i0	PRJNA944406	32847	279	1.495146	4.17145734	Naegleria	5761	Heterolobosea	other_Eukaryota	48.1	7.18e-4	NR	XP_002672825.1	5762	g31888	i0	44.1	1.90322580645161	59	33	63.4	0	278	102	657	715	XP_002672825.1 Band_7_stomatin_like domain-containing protein [Naegleria gruberi]	diamond	531	48.1	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
28856803	28856803	PRJNA944406_P_NODE_19728_length_297_cov_1.031250_g18769_i0	PRJNA944406	19728	297	1.03125	3.0628125	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	102	9.79e-25	NR	KAL0483597.1	1008807	g18769	i0	54.9	1.65656565656566	82	37	82.8	0	247	2	12	93	KAL0483597.1 actin-related protein 2/3 complex subunit 3 [Acrasis kona]	diamond	492	102	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona

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