metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA976345" 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
2542616	2542616	PRJNA976345_P_NODE_11562_length_505_cov_8.512766_g10014_i0	PRJNA976345	11562	505	8.512766	42.9894683	Leptotrichia	32067	Bacteria	Bacteria	845	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g10014	i0	96.832	501.063366336634	505	16	100	0	1	505	2454604	2454100	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	253037	845	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
5095263	5095263	PRJNA976345_P_NODE_11784_length_500_cov_2.604301_g10233_i0	PRJNA976345	11784	500	2.604301	13.021505	Fusobacterium	848	Bacteria	Bacteria	675	0	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g10233	i0	91	11	500	45	100	0	1	500	223198	222699	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	5500	675	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
6051501	6051501	PRJNA976345_P_NODE_25705_length_332_cov_2.040404_g24102_i0	PRJNA976345	25705	332	2.040404	6.77414128	Fusobacterium animalis	76859	Bacteria	Bacteria	608	1.479999999999999e-169	NTclustered	gi\|2706054094\|gb\|CP077189.1\|	76859	g24102	i0	99.699	99.9006024096386	332	1	100	0	1	332	1544078	1543747	Fusobacterium animalis strain SB027 chromosome, complete genome	blastn	33167	608	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
6371121	6371121	PRJNA976345_P_NODE_141585_length_170_cov_1.533333_g139977_i0	PRJNA976345	141585	170	1.533333	2.6066661	Fusobacterium	848	Bacteria	Bacteria	298	1.65e-76	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g139977	i0	98.235	81	170	3	100	0	1	170	1758537	1758368	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	13770	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7644996	7644996	PRJNA976345_P_NODE_125226_length_178_cov_1.111888_g123618_i0	PRJNA976345	125226	178	1.111888	1.97916064	Leptotrichia	32067	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g123618	i0	100	1.25842696629213	28	0	16	0	5	32	2099901	2099928	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	224	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
8601887	8601887	PRJNA976345_P_NODE_94627_length_194_cov_0.987421_g93019_i0	PRJNA976345	94627	194	0.987421	1.91559674	Fusobacterium animalis	76859	Bacteria	Bacteria	359	8.809999999999999e-95	NTclustered	gi\|2706487646\|gb\|CP084150.1\|	76859	g93019	i0	100	99.8556701030928	194	0	100	0	1	194	2212660	2212467	Fusobacterium animalis strain KCOM2860 chromosome, complete genome	blastn	19372	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
10195899	10195899	PRJNA976345_P_NODE_27168_length_323_cov_2.937500_g25565_i0	PRJNA976345	27168	323	2.9375	9.488125	Fusobacterium	848	Bacteria	Bacteria	531	3.199999999999999e-146	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g25565	i0	96.285	99.9504643962848	323	12	100	0	1	323	2203425	2203747	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	32284	536	0.990671641791045	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
11152532	11152532	PRJNA976345_P_NODE_96969_length_192_cov_1.522293_g95361_i0	PRJNA976345	96969	192	1.522293	2.92280256	Fusobacterium polymorphum	76857	Bacteria	Bacteria	355	1.13e-93	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g95361	i0	100	99.34375	192	0	100	0	1	192	1645029	1644838	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	19074	355	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
11470818	11470818	PRJNA976345_P_NODE_136429_length_172_cov_2.211679_g134821_i0	PRJNA976345	136429	172	2.211679	3.80408788	root	1	Root_unresolved	Root_unresolved	52.8	0.014	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g134821	i0	100	1.84302325581395	28	0	16	0	119	146	2394991	2395018	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	317	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
11470926	11470926	PRJNA976345_P_NODE_169429_length_159_cov_1.564516_g167821_i0	PRJNA976345	169429	159	1.564516	2.48758044	Fusobacterium	848	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g167821	i0	100	99.1320754716981	159	0	100	0	1	159	2373377	2373219	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	15762	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
11471012	11471012	PRJNA976345_P_NODE_19489_length_382_cov_1.731988_g17893_i0	PRJNA976345	19489	382	1.731988	6.61619416	Fusobacterium	848	Bacteria	Bacteria	647	0	NTclustered	gi\|2704998788\|gb\|CP077147.1\|	851	g17893	i0	96.931	102.201570680628	391	3	100	1	1	382	1547009	1546619	Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome	blastn	39041	647	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
12746600	12746600	PRJNA976345_P_NODE_56270_length_235_cov_3.175000_g54662_i0	PRJNA976345	56270	235	3.175	7.46125	Fusobacterium	848	Bacteria	Bacteria	418	1.8e-112	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g54662	i0	98.723	220.68085106383	235	3	100	0	1	235	1454906	1455140	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	51860	420	0.995238095238095	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
12746622	12746622	PRJNA976345_P_NODE_6190_length_732_cov_2.014347_g4849_i0	PRJNA976345	6190	732	2.014347	14.74502004	Fusobacterium	848	Bacteria	Bacteria	1341	0	NTclustered	gi\|2704998788\|gb\|CP077147.1\|	851	g4849	i0	99.727	99.7609289617486	732	2	100	0	1	732	1300502	1299771	Fusobacterium nucleatum strain KCOM2373 chromosome, complete genome	blastn	73025	1352	0.991863905325444	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13701373	13701373	PRJNA976345_P_NODE_117491_length_179_cov_1.930556_g115883_i0	PRJNA976345	117491	179	1.930556	3.45569524	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g115883	i0	100	13.5865921787709	179	0	100	0	1	179	259633	259811	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2432	331	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14020968	14020968	PRJNA976345_P_NODE_170931_length_158_cov_2.674797_g169323_i0	PRJNA976345	170931	158	2.674797	4.22617926	Fusobacterium	848	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2704972056\|gb\|CP077127.1\|	851	g169323	i0	96.875	1.68987341772152	32	1	20	0	108	139	752674	752705	Fusobacterium nucleatum strain KCOM3503 chromosome, complete genome	blastn	267	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
14975659	14975659	PRJNA976345_P_NODE_128792_length_176_cov_1.645390_g127184_i0	PRJNA976345	128792	176	1.64539	2.8958864	Fusobacterium animalis	76859	Bacteria	Bacteria	309	7.98e-80	NTclustered	gi\|2706438296\|gb\|CP084062.1\|	76859	g127184	i0	98.295	99.7159090909091	176	3	100	0	1	176	1696218	1696043	Fusobacterium animalis strain SB008 chromosome, complete genome	blastn	17550	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
14976588	14976588	PRJNA976345_P_NODE_6172_length_733_cov_5.160458_g4832_i0	PRJNA976345	6172	733	5.160458	37.82615714	Leptotrichia wadei	157687	Bacteria	Bacteria	1293	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g4832	i0	98.499	460.140518417462	733	11	100	0	1	733	2368985	2369717	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	337283	1293	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16251483	16251483	PRJNA976345_P_NODE_52253_length_243_cov_1.778846_g50645_i0	PRJNA976345	52253	243	1.778846	4.32259578	Fusobacterium animalis	76859	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2706494444\|gb\|CP084153.1\|	76859	g50645	i0	100	0.576131687242798	28	0	12	0	185	212	1853556	1853529	Fusobacterium animalis strain KCOM2538 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
16251557	16251557	PRJNA976345_P_NODE_59453_length_230_cov_2.558974_g57845_i0	PRJNA976345	59453	230	2.558974	5.8856402	Fusobacterium animalis	76859	Bacteria	Bacteria	420	4.89e-113	NTclustered	gi\|2704938133\|gb\|CP056006.1\|	76859	g57845	i0	99.565	100	230	1	100	0	1	230	545451	545222	Fusobacterium animalis strain SB014 chromosome, complete genome	blastn	23000	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
16251605	16251605	PRJNA976345_P_NODE_65973_length_221_cov_2.301075_g64365_i0	PRJNA976345	65973	221	2.301075	5.08537575	Fusobacterium animalis	76859	Bacteria	Bacteria	387	4.729999999999998e-103	NTclustered	gi\|2706049627\|gb\|CP077180.1\|	76859	g64365	i0	98.19	99.9954751131222	221	4	100	0	1	221	1055534	1055314	Fusobacterium animalis strain SB034 chromosome, complete genome	blastn	22099	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
16251609	16251609	PRJNA976345_P_NODE_66353_length_221_cov_1.489247_g64745_i0	PRJNA976345	66353	221	1.489247	3.29123587	Fusobacterium animalis	76859	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|2706471657\|gb\|CP084079.1\|	76859	g64745	i0	100	217.733031674208	221	0	100	0	1	221	1398764	1398984	Fusobacterium animalis strain SB052 chromosome, complete genome	blastn	48119	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
17526768	17526768	PRJNA976345_P_NODE_62534_length_226_cov_1.581152_g60926_i0	PRJNA976345	62534	226	1.581152	3.57340352	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	405	1.34e-108	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g60926	i0	99.115	2.84070796460177	226	1	100	1	1	226	259984	260208	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	642	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17844814	17844814	PRJNA976345_P_NODE_30134_length_308_cov_1.505495_g28528_i0	PRJNA976345	30134	308	1.505495	4.6369246	Fusobacterium	848	Bacteria	Bacteria	564	2.99e-156	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g28528	i0	99.675	95.8831168831169	308	1	100	0	1	308	1719032	1719339	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	29532	564	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18799453	18799453	PRJNA976345_P_NODE_113875_length_181_cov_1.863014_g112267_i0	PRJNA976345	113875	181	1.863014	3.37205534	Fusobacterium ulcerans	861	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1370545701\|gb\|CP028105.1\|	861	g112267	i0	100	0.30939226519337	28	0	15	0	148	175	2535118	2535145	Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
19118750	19118750	PRJNA976345_P_NODE_39135_length_274_cov_5.497908_g37528_i0	PRJNA976345	39135	274	5.497908	15.06426792	Streptobacillus	34104	Bacteria	Bacteria	58.4	5.41e-4	NTclustered	gi\|1356701568\|gb\|CP027400.1\|	34105	g37528	i0	100	0.441605839416058	31	0	11	0	217	247	261426	261456	Streptobacillus moniliformis strain FDAARGOS_310 chromosome, complete genome	blastn	121	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Streptobacillus	Streptobacillus moniliformis
20393573	20393573	PRJNA976345_P_NODE_23476_length_347_cov_1.910256_g21875_i0	PRJNA976345	23476	347	1.910256	6.62858832	Fusobacterium	848	Bacteria	Bacteria	641	1.5299999999999996e-179	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g21875	i0	100	100	347	0	100	0	1	347	2372856	2373202	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	34700	641	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
20393612	20393612	PRJNA976345_P_NODE_31016_length_304_cov_1.423792_g29410_i0	PRJNA976345	31016	304	1.423792	4.32832768	Fusobacterium	848	Bacteria	Bacteria	545	1.07e-150	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g29410	i0	99.013	99.9736842105263	304	3	100	0	1	304	2002623	2002320	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	30392	545	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
21350486	21350486	PRJNA976345_P_NODE_36737_length_282_cov_2.125506_g35130_i0	PRJNA976345	36737	282	2.125506	5.99392692	Fusobacterium animalis	76859	Bacteria	Bacteria	521	1.6499999999999996e-143	NTclustered	gi\|2706444732\|gb\|CP084069.1\|	76859	g35130	i0	100	99.7446808510638	282	0	100	0	1	282	11071	10790	Fusobacterium animalis strain SB062 chromosome, complete genome	blastn	28128	521	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
23900141	23900141	PRJNA976345_P_NODE_107419_length_185_cov_1.560000_g105811_i0	PRJNA976345	107419	185	1.56	2.886	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	259	8.67e-65	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g105811	i0	91.979	384.167567567568	187	12	100	2	1	185	397670	397485	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	71071	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
24219016	24219016	PRJNA976345_P_NODE_40139_length_271_cov_5.283898_g38531_i0	PRJNA976345	40139	271	5.283898	14.31936358	Leptotrichia	32067	Bacteria	Bacteria	455	1.6200000000000002e-123	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g38531	i0	97.059	471.649446494465	272	5	100	2	1	271	2368985	2369254	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	127817	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
24219126	24219126	PRJNA976345_P_NODE_68499_length_218_cov_2.005464_g66891_i0	PRJNA976345	68499	218	2.005464	4.37191152	Fusobacterium	848	Bacteria	Bacteria	58.4	4.14e-4	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g66891	i0	89.362	0.63302752293578	47	3	21	2	149	194	491420	491375	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	138	58.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum

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