metadata: contig_metadata: 31 rows where bioproject = "PRJNA358049" and tax

31 rows where bioproject = "PRJNA358049" and tax_kingdom = "Fusobacteriati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1673561	1673561	PRJNA358049_S_NODE_9122_length_211_cov_0.962963_g9074_i0	PRJNA358049	9122	211	0.962963	2.03185193	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	246	7.919999999999999e-61	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g9074	i0	87.678	6.04739336492891	211	26	100	0	1	211	547870	547660	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	1276	246	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
2949040	2949040	PRJNA358049_S_NODE_12943_length_184_cov_2.429630_g12895_i0	PRJNA358049	12943	184	2.42963	4.4705192	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	316	5.04e-82	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g12895	i0	98.333	509.722826086957	180	3	98	0	1	180	52421	52242	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	93789	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
2949054	2949054	PRJNA358049_S_NODE_13363_length_182_cov_1.849624_g13315_i0	PRJNA358049	13363	182	1.849624	3.36631568	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	278	2.35e-70	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g13315	i0	100	1.93956043956044	150	0	82	0	1	150	791120	790971	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	353	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4225844	4225844	PRJNA358049_S_NODE_2504_length_373_cov_11.660494_g2456_i0	PRJNA358049	2504	373	11.660494	43.49364262	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	483	1.0599999999999998e-131	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g2456	i0	95.96	220.455764075067	297	12	80	0	52	348	593946	594242	Leptotrichia sp. oral taxon 498, complete genome	blastn	82230	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
4901102	4901102	PRJNA358049_S_NODE_524_length_733_cov_4.017544_g492_i0	PRJNA358049	524	733	4.017544	29.44859752	Fusobacterium	848	Bacteria	Bacteria	1301	0	NTclustered	gi\|2706496642\|gb\|CP084152.1\|	76857	g492	i0	99.718	462.162346521146	710	2	97	0	24	733	626319	627028	Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome	blastn	338765	1301	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9326603	9326603	PRJNA358049_S_NODE_1368_length_490_cov_6.523810_g1325_i0	PRJNA358049	1368	490	6.52381	31.966669	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	610	6.2899999999999996e-170	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g1325	i0	90.234	215.014285714286	471	40	96	5	1	468	397574	397107	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	105357	610	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
9326778	9326778	PRJNA358049_S_NODE_2628_length_365_cov_7.705696_g2580_i0	PRJNA358049	2628	365	7.705696	28.1257904	Leptotrichia wadei	157687	Bacteria	Bacteria	616	9.799999999999999e-172	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g2580	i0	99.123	144.67397260274	342	3	94	0	1	342	2369585	2369926	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	52806	616	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
13152146	13152146	PRJNA358049_S_NODE_1251_length_510_cov_21.748373_g1209_i0	PRJNA358049	1251	510	21.748373	110.9167023	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	680	0	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g1209	i0	91.959	150.18431372549	485	39	95	0	26	510	790286	790770	Leptotrichia sp. oral taxon 498, complete genome	blastn	76594	680	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
13152148	13152148	PRJNA358049_S_NODE_12571_length_187_cov_1.086957_g12523_i0	PRJNA358049	12571	187	1.086957	2.03260959	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	62.1	2.66e-5	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g12523	i0	86.441	0.315508021390374	59	5	32	1	129	187	541375	541320	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	59	62.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
15100933	15100933	PRJNA358049_S_NODE_6932_length_235_cov_16.069892_g6884_i0	PRJNA358049	6932	235	16.069892	37.7642462	Leptotrichia	32067	Bacteria	Bacteria	322	1.45e-83	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g6884	i0	94.286	301.774468085106	210	12	89	0	1	210	212	3	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	70917	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
15701110	15701110	PRJNA358049_S_NODE_12513_length_187_cov_1.485507_g12465_i0	PRJNA358049	12513	187	1.485507	2.77789809	Leptotrichia buccalis	40542	Bacteria	Bacteria	326	8.54e-85	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g12465	i0	98.378	8.96791443850267	185	3	99	0	3	187	702472	702656	Leptotrichia buccalis DSM 1135, complete genome	blastn	1677	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
15701329	15701329	PRJNA358049_S_NODE_2713_length_360_cov_10.610932_g2665_i0	PRJNA358049	2713	360	10.610932	38.1993552	Leptotrichia wadei	157687	Bacteria	Bacteria	621	2.0699999999999997e-173	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g2665	i0	97.778	218.136111111111	360	8	100	0	1	360	1757468	1757827	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	78529	621	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16375583	16375583	PRJNA358049_S_NODE_1153_length_530_cov_20.245322_g1112_i0	PRJNA358049	1153	530	20.245322	107.3002066	Leptotrichia	32067	Bacteria	Bacteria	926	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g1112	i0	99.22	192.490566037736	513	4	97	0	18	530	3	515	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	102020	926	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
16976052	16976052	PRJNA358049_S_NODE_2274_length_389_cov_2.664706_g2226_i0	PRJNA358049	2274	389	2.664706	10.36570634	Leptotrichia wadei	157687	Bacteria	Bacteria	688	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g2226	i0	99.471	277.105398457584	378	2	97	0	1	378	2247297	2247674	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	107794	688	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16976221	16976221	PRJNA358049_S_NODE_774_length_627_cov_40.899654_g737_i0	PRJNA358049	774	627	40.899654	256.44083058	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	950	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g737	i0	96.055	449.921850079745	583	23	93	0	33	615	51590	52172	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	282101	950	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19524490	19524490	PRJNA358049_S_NODE_3116_length_337_cov_6.062500_g3068_i0	PRJNA358049	3116	337	6.0625	20.430625	Leptotrichia wadei	157687	Bacteria	Bacteria	573	5.489999999999998e-159	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g3068	i0	97.329	172.661721068249	337	9	100	0	1	337	1757827	1757491	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	58187	573	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19524615	19524615	PRJNA358049_S_NODE_7356_length_230_cov_1.419890_g7308_i0	PRJNA358049	7356	230	1.41989	3.265747	Leptotrichia rugosa	3239302	Bacteria	Bacteria	403	4.92e-108	NTclustered	gi\|2785246835\|gb\|CP165644.1\|	3239302	g7308	i0	98.261	16.495652173913	230	4	100	0	1	230	252221	251992	Leptotrichia sp. HSP-334 chromosome, complete genome	blastn	3794	403	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia rugosa
20800210	20800210	PRJNA358049_S_NODE_4297_length_291_cov_1.272727_g4249_i0	PRJNA358049	4297	291	1.272727	3.70363557	Fusobacterium animalis	76859	Bacteria	Bacteria	499	8.01e-137	NTclustered	gi\|2706064790\|gb\|CP077192.1\|	76859	g4249	i0	98.582	420.766323024055	282	4	97	0	10	291	2634381	2634100	Fusobacterium animalis strain SB024 chromosome, complete genome	blastn	122443	499	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
21474786	21474786	PRJNA358049_S_NODE_11197_length_195_cov_0.965753_g11149_i0	PRJNA358049	11197	195	0.965753	1.88321835	Leptotrichia	32067	Bacteria	Bacteria	316	5.41e-82	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g11149	i0	96.354	24.9641025641026	192	7	98	0	4	195	123364	123173	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	4868	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
21474806	21474806	PRJNA358049_S_NODE_1617_length_455_cov_11.682266_g1572_i0	PRJNA358049	1617	455	11.682266	53.1543103	Leptotrichia	32067	Bacteria	Bacteria	761	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g1572	i0	99.057	569.017582417582	424	4	93	0	23	446	1001	1424	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	258903	767	0.992177314211212	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
21474836	21474836	PRJNA358049_S_NODE_7957_length_222_cov_25.236994_g7909_i0	PRJNA358049	7957	222	25.236994	56.02612668	Fusobacterium	848	Bacteria	Bacteria	366	6.19e-97	NTclustered	gi\|2705003210\|gb\|CP084117.1\|	851	g7909	i0	99.502	411.594594594595	201	1	91	0	22	222	1568479	1568279	Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome	blastn	91374	368	0.994565217391304	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
22074956	22074956	PRJNA358049_S_NODE_10658_length_199_cov_1.020000_g10610_i0	PRJNA358049	10658	199	1.02	2.0298	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	196	7.539999999999999e-46	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g10610	i0	84.5	2.85427135678392	200	29	100	2	1	199	252483	252681	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	568	196	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
22074976	22074976	PRJNA358049_S_NODE_11358_length_193_cov_5.888889_g11310_i0	PRJNA358049	11358	193	5.888889	11.36555577	Leptotrichia wadei	157687	Bacteria	Bacteria	346	6.82e-91	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g11310	i0	98.964	462.357512953368	193	2	100	0	1	193	2298011	2298203	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	89235	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
23350581	23350581	PRJNA358049_S_NODE_17359_length_165_cov_0.896552_g17311_i0	PRJNA358049	17359	165	0.896552	1.4793108	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	193	7.79e-45	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g17311	i0	87.805	0.993939393939394	164	20	99	0	1	164	1540950	1541113	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	164	193	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24024847	24024847	PRJNA358049_S_NODE_10739_length_198_cov_1.395973_g10691_i0	PRJNA358049	10739	198	1.395973	2.76402654	Streptobacillus	34104	Bacteria	Bacteria	259	9.42e-65	NTclustered	gi\|1356701568\|gb\|CP027400.1\|	34105	g10691	i0	90.769	86.6464646464647	195	17	98	1	2	196	694538	694345	Streptobacillus moniliformis strain FDAARGOS_310 chromosome, complete genome	blastn	17156	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
24624837	24624837	PRJNA358049_S_NODE_17780_length_164_cov_0.895652_g17732_i0	PRJNA358049	17780	164	0.895652	1.46886928	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	298	1.59e-76	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g17732	i0	99.39	60.4512195121951	164	1	100	0	1	164	703674	703837	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	9914	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
24624894	24624894	PRJNA358049_S_NODE_2520_length_372_cov_17.789474_g2472_i0	PRJNA358049	2520	372	17.789474	66.17684328	Leptotrichia wadei	157687	Bacteria	Bacteria	614	3.599999999999999e-171	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g2472	i0	98.559	301.798387096774	347	5	93	0	26	372	1757980	1757634	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	112269	614	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
24625063	24625063	PRJNA358049_S_NODE_8120_length_221_cov_1.180233_g8072_i0	PRJNA358049	8120	221	1.180233	2.60831493	Leptotrichia buccalis	40542	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g8072	i0	100	87.2579185520362	221	0	100	0	1	221	245854	245634	Leptotrichia buccalis DSM 1135, complete genome	blastn	19284	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
27074829	27074829	PRJNA358049_S_NODE_11302_length_194_cov_1.372414_g11254_i0	PRJNA358049	11302	194	1.372414	2.66248316	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	75.9	1.56e-15	NR	WP_036056043.1	157692	g11254	i0	84.3	0.788659793814433	51	7	78.9	1	166	14	1	50	WP_036056043.1 hypothetical protein [Pseudoleptotrichia goodfellowii]	diamond	153	75.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
28180065	28180065	PRJNA358049_S_NODE_16586_length_167_cov_0.881356_g16538_i0	PRJNA358049	16586	167	0.881356	1.47186452	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	48.5	1.22e-4	NR	WP_053393131.1	712357	g16538	i0	45.5	0.988023952095808	55	30	98.8	0	166	2	459	513	WP_053393131.1 autotransporter domain-containing protein [Leptotrichia sp. oral taxon 212]	diamond	165	48.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
29537880	29537880	PRJNA358049_S_NODE_13650_length_181_cov_1.007576_g13602_i0	PRJNA358049	13650	181	1.007576	1.82371256	Leptotrichia sp.	104608	Bacteria	Bacteria	119	1.22e-29	NR	MBF1332944.1	104608	g13602	i0	98.3	1.95580110497238	59	1	97.8	0	3	179	481	539	MBF1332944.1 alanine--tRNA ligase [Leptotrichia sp.]	diamond	354	119	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp.

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