metadata: contig_metadata: 27 rows where bioproject = "PRJNA1092581" and tax

27 rows where bioproject = "PRJNA1092581" 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
195543	195543	PRJNA1092581_P_NODE_100561_length_252_cov_2.357542_g100028_i0	PRJNA1092581	100561	252	2.357542	5.94100584	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	289	1.6e-73	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g100028	i0	87.218	16.6150793650794	266	19	100	3	1	252	52093	51829	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	4187	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
1018209	1018209	PRJNA1092581_P_NODE_42301_length_419_cov_1.777457_g41768_i0	PRJNA1092581	42301	419	1.777457	7.44754483	Cetobacterium	180162	Bacteria	Bacteria	448	4.3999999999999996e-121	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g41768	i0	87.597	18.3508353221957	387	46	92	2	1	386	430137	429752	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	7689	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1470865	1470865	PRJNA1092581_P_NODE_18822_length_641_cov_4.602113_g18305_i0	PRJNA1092581	18822	641	4.602113	29.49954433	Cetobacterium somerae	188913	Bacteria	Bacteria	708	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g18305	i0	86.583	46.6411856474259	641	86	100	0	1	641	1452863	1453503	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	29897	708	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1472313	1472313	PRJNA1092581_P_NODE_73282_length_304_cov_40.575758_g72749_i0	PRJNA1092581	73282	304	40.575758	123.35030432	Leptotrichia hofstadii	157688	Bacteria	Bacteria	503	6.51e-138	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g72749	i0	100	131.700657894737	272	0	89	0	14	285	577598	577327	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	40037	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2293749	2293749	PRJNA1092581_P_NODE_4822_length_1129_cov_65.271780_g4525_i1	PRJNA1092581	4822	1129	65.27178	736.9183962	Leptotrichia	32067	Bacteria	Bacteria	1943	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g4525	i1	98.808	506.687333923826	1091	13	97	0	22	1112	2374444	2373354	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	572050	1943	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2746274	2746274	PRJNA1092581_P_NODE_101763_length_250_cov_4.638418_g101230_i0	PRJNA1092581	101763	250	4.638418	11.596045	Leptotrichia trevisanii	109328	Bacteria	Bacteria	292	1.2299999999999999e-74	NTclustered	gi\|1708579770\|dbj\|AP019840.1\|	109328	g101230	i0	91.509	4.232	212	18	85	0	22	233	1934514	1934725	Leptotrichia trevisanii JMUB3935 DNA, complete genome	blastn	1058	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
2749032	2749032	PRJNA1092581_P_NODE_97503_length_256_cov_109.366120_g96970_i0	PRJNA1092581	97503	256	109.36612	279.97726719999997	Leptotrichia wadei	157687	Bacteria	Bacteria	429	9.2e-116	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g96970	i0	100	115.7734375	232	0	91	0	24	255	221630	221861	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	29638	429	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4022292	4022292	PRJNA1092581_P_NODE_107064_length_244_cov_0.900585_g106531_i0	PRJNA1092581	107064	244	0.900585	2.1974274	Leptotrichia mesophila	3239303	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g106531	i0	98.361	9.76229508196721	244	4	100	0	1	244	858880	859123	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	2382	429	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
4023381	4023381	PRJNA1092581_P_NODE_36424_length_455_cov_12.727749_g35892_i0	PRJNA1092581	36424	455	12.727749	57.91125795	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	534	3.59e-147	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g35892	i0	89.786	484.516483516484	421	38	92	5	23	442	3227	3643	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	220455	534	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
5300326	5300326	PRJNA1092581_P_NODE_64365_length_328_cov_17.200000_g63832_i0	PRJNA1092581	64365	328	17.2	56.416	Fusobacterium polymorphum	76857	Bacteria	Bacteria	532	9.04e-147	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g63832	i0	99.32	435.621951219512	294	2	90	0	22	315	700227	700520	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	142884	532	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6121097	6121097	PRJNA1092581_P_NODE_127985_length_197_cov_18.862903_g127452_i0	PRJNA1092581	127985	197	18.862903	37.15991891	Leptotrichia	32067	Bacteria	Bacteria	307	3.3e-79	NTclustered	gi\|1708584775\|dbj\|AP019845.1\|	109328	g127452	i0	98.295	7.26903553299492	176	2	89	1	1	175	1358418	1358243	Leptotrichia trevisanii JMUB4039 DNA, complete genome	blastn	1432	309	0.993527508090615	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
7395730	7395730	PRJNA1092581_P_NODE_125986_length_204_cov_4.099237_g125453_i0	PRJNA1092581	125986	204	4.099237	8.36244348	Fusobacterium	848	Bacteria	Bacteria	342	9.429999999999999e-90	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g125453	i0	100	90.2058823529412	185	0	91	0	1	185	1261018	1260834	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	18402	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7848656	7848656	PRJNA1092581_P_NODE_121787_length_216_cov_17.426573_g121254_i0	PRJNA1092581	121787	216	17.426573	37.64139768	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	270	4.829999999999999e-68	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g121254	i0	93.407	33.1111111111111	182	12	84	0	14	195	53229	53048	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	7152	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9946108	9946108	PRJNA1092581_P_NODE_120328_length_221_cov_4.763514_g119795_i0	PRJNA1092581	120328	221	4.763514	10.52736594	Fusobacterium	848	Bacteria	Bacteria	370	4.76e-98	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g119795	i0	100	88.1945701357466	200	0	90	0	1	200	1203909	1203710	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	19491	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
10400579	10400579	PRJNA1092581_P_NODE_55069_length_360_cov_1.919861_g54536_i0	PRJNA1092581	55069	360	1.919861	6.9114996	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	595	1.2599999999999995e-165	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g54536	i0	99.692	120.138888888889	325	1	90	0	13	337	398750	398426	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	43250	595	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
12949380	12949380	PRJNA1092581_P_NODE_108531_length_242_cov_2.295858_g107998_i0	PRJNA1092581	108531	242	2.295858	5.55597636	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	374	4.1e-99	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g107998	i0	96.861	9.56198347107438	223	7	92	0	1	223	351766	351988	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2314	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14225985	14225985	PRJNA1092581_P_NODE_56012_length_356_cov_4.204947_g55479_i0	PRJNA1092581	56012	356	4.204947	14.96961132	Cetobacterium sp. NK	2071632	Bacteria	Bacteria	193	2.62e-57	NR	WP_256690800.1	2993530	g55479	i0	78.4	0.97752808988764	116	25	97.8	0	354	7	322	437	WP_256690800.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Cetobacterium sp. NK01]	diamond	348	193	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. NK01
14226549	14226549	PRJNA1092581_P_NODE_77592_length_294_cov_5.515837_g77059_i0	PRJNA1092581	77592	294	5.515837	16.21656078	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	351	2.4e-92	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g77059	i0	88.356	0.993197278911565	292	34	99	0	3	294	2397743	2398034	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	292	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15499268	15499268	PRJNA1092581_P_NODE_31853_length_490_cov_4.357314_g31321_i0	PRJNA1092581	31853	490	4.357314	21.3508386	Leptotrichia sp. oral taxon 215	712359	Bacteria	Bacteria	215	4.71e-69	NR	WP_021766239.1	712359	g31321	i0	88.1	0.771428571428571	126	15	77.1	0	451	74	1	126	WP_021766239.1 MazG nucleotide pyrophosphohydrolase domain-containing protein [Leptotrichia sp. oral taxon 215]	diamond	378	215	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 215
15499723	15499723	PRJNA1092581_P_NODE_4893_length_1123_cov_43.650476_g4616_i0	PRJNA1092581	4893	1123	43.650476	490.19484548	Leptotrichia wadei	157687	Bacteria	Bacteria	1877	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g4616	i0	97.796	407.640249332146	1089	23	97	1	14	1102	1756341	1757428	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	457780	1877	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15500432	15500432	PRJNA1092581_P_NODE_75833_length_298_cov_5.880000_g75300_i0	PRJNA1092581	75833	298	5.88	17.5224	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	510	3.8e-140	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g75300	i0	100	288.647651006711	276	0	93	0	8	283	436765	437040	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	86017	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
15500667	15500667	PRJNA1092581_P_NODE_8513_length_912_cov_60.673421_g8110_i0	PRJNA1092581	8513	912	60.673421	553.34159952	Fusobacterium polymorphum	76857	Bacteria	Bacteria	1482	0	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g8110	i0	97.045	467.046052631579	880	26	96	0	14	893	453933	453054	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	425946	1482	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18049778	18049778	PRJNA1092581_P_NODE_89315_length_270_cov_52.857868_g88782_i0	PRJNA1092581	89315	270	52.857868	142.7162436	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	427	3.5199999999999993e-115	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g88782	i0	97.6	119.196296296296	250	4	92	2	14	262	53229	52981	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	32183	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20597155	20597155	PRJNA1092581_P_NODE_127437_length_199_cov_5.436508_g126904_i0	PRJNA1092581	127437	199	5.436508	10.81865092	Leptotrichia shahii	157691	Bacteria	Bacteria	296	7.23e-76	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g126904	i0	98.795	30.1005025125628	166	2	83	0	21	186	105370	105535	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	5990	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
22694626	22694626	PRJNA1092581_P_NODE_10278_length_845_cov_3.125648_g9842_i0	PRJNA1092581	10278	845	3.125648	26.4117256	Cetobacterium	180162	Bacteria	Bacteria	1018	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9842	i0	88.558	26.5041420118343	839	96	99	0	1	839	851119	851957	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	22396	1018	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22694807	22694807	PRJNA1092581_P_NODE_121098_length_218_cov_12.558621_g120565_i0	PRJNA1092581	121098	218	12.558621	27.37779378	Fusobacterium	848	Bacteria	Bacteria	364	2.18e-96	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g120565	i0	100	90.9036697247706	197	0	90	0	1	197	172207	172011	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	19817	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
31331474	31331474	PRJNA1092581_P_NODE_89816_length_270_cov_1.446701_g89283_i0	PRJNA1092581	89816	270	1.446701	3.9060927	Sebaldella termitidis	826	Bacteria	Bacteria	60.1	1.83e-8	NR	WP_041310000.1	826	g89283	i0	37.8	1	90	51	97.8	2	1	264	45	131	WP_041310000.1 glycerophosphodiester phosphodiesterase [Sebaldella termitidis]	diamond	270	60.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella termitidis

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