metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1092581" 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
20598074	20598074	PRJNA1092581_P_NODE_45837_length_400_cov_2.327217_g45304_i0	PRJNA1092581	45837	400	2.327217	9.308868	Naegleria	5761	Heterolobosea	other_Eukaryota	216	1.3499999999999999e-68	NR	XP_002676748.1	5762	g45304	i0	75.9	1.995	133	32	99.8	0	1	399	15	147	XP_002676748.1 uncharacterized protein NAEGRDRAFT_68050 [Naegleria gruberi]	diamond	798	216	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
28741325	28741325	PRJNA1092581_P_NODE_47867_length_390_cov_3.211356_g47334_i0	PRJNA1092581	47867	390	3.211356	12.5242884	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	116	3.69e-29	NR	KAL0477504.1	1008807	g47334	i0	45.9	0.938461538461538	122	64	93.8	1	20	385	33	152	KAL0477504.1 vwkA-like alpha-protein kinase [Acrasis kona]	diamond	366	116	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
29846477	29846477	PRJNA1092581_P_NODE_7971_length_940_cov_3.205306_g7581_i0	PRJNA1092581	7971	940	3.205306	30.1298764	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	53.5	8.22e-4	NR	XP_002671616.1	5762	g7581	i0	29.1	0.351063829787234	110	67	31.6	2	940	644	494	603	XP_002671616.1 uncharacterized protein NAEGRDRAFT_73326 [Naegleria gruberi]	diamond	330	53.5	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
29964240	29964240	PRJNA1092581_P_NODE_34891_length_466_cov_4.167939_g34359_i0	PRJNA1092581	34891	466	4.167939	19.42259574	Naegleria	5761	Heterolobosea	other_Eukaryota	132	9.48e-33	NR	CAG4717154.1	5763	g34359	i0	52.6	2.28540772532189	116	52	73.4	2	64	405	462	576	CAG4717154.1 unnamed protein product [Naegleria fowleri]	diamond	1065	132	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
30099001	30099001	PRJNA1092581_P_NODE_128212_length_197_cov_4.451613_g127679_i0	PRJNA1092581	128212	197	4.451613	8.76967761	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	108	9.93e-26	NR	XP_002674997.1	5762	g127679	i0	87.1	0.944162436548223	62	8	94.4	0	7	192	1117	1178	XP_002674997.1 uncharacterized protein NAEGRDRAFT_80506 [Naegleria gruberi]	diamond	186	108	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
30920847	30920847	PRJNA1092581_P_NODE_66714_length_322_cov_1.718876_g66181_i0	PRJNA1092581	66714	322	1.718876	5.53478072	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	122	1.37e-32	NR	KAL0489093.1	1008807	g66181	i0	63.9	1.00621118012422	108	30	99.7	3	322	2	93	192	KAL0489093.1 ribosomal protein S8 [Acrasis kona]	diamond	324	122	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
31204573	31204573	PRJNA1092581_P_NODE_44555_length_406_cov_8.492492_g44022_i0	PRJNA1092581	44555	406	8.492492	34.47951752	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	115	8.150000000000001e-27	NR	XP_044562206.1	5763	g44022	i0	56.6	1.56650246305419	106	46	78.3	0	21	338	1274	1379	XP_044562206.1 uncharacterized protein FDP41_003485 [Naegleria fowleri]	diamond	636	115	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
31489909	31489909	PRJNA1092581_P_NODE_24116_length_566_cov_6.231237_g23590_i0	PRJNA1092581	24116	566	6.231237	35.26880142	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	157	5.53e-41	NR	KAL0491758.1	1008807	g23590	i0	50	5.51766784452297	184	81	92.8	5	553	29	564	745	KAL0491758.1 enoyl-CoA hydratase/3 hydroxyacyl-CoA dehydrogenase [Acrasis kona]	diamond	3123	157	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
32596955	32596955	PRJNA1092581_P_NODE_63420_length_331_cov_7.631783_g62887_i0	PRJNA1092581	63420	331	7.631783	25.26120173	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	133	4.819999999999999e-34	NR	KAL0483610.1	1008807	g62887	i0	63.7	0.924471299093656	102	37	92.4	0	21	326	355	456	KAL0483610.1 metal ion transporter [Acrasis kona]	diamond	306	133	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
32722837	32722837	PRJNA1092581_P_NODE_79640_length_290_cov_2.387097_g79107_i0	PRJNA1092581	79640	290	2.387097	6.9225813	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	78.2	8.22e-15	NR	XP_044566592.1	5763	g79107	i0	53.4	2.94827586206897	73	34	75.5	0	27	245	183	255	XP_044566592.1 uncharacterized protein FDP41_011740 [Naegleria fowleri]	diamond	855	78.2	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri

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