metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA358009" 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
1072967	1072967	PRJNA358009_P_NODE_141_length_747_cov_5.661891_g108_i0	PRJNA358009	141	747	5.661891	42.29432577	Fusobacterium	848	Bacteria	Bacteria	809	0	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g108	i0	99.329	440.934404283802	447	3	92	0	118	564	1603143	1602697	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	329378	809	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
1073096	1073096	PRJNA358009_P_NODE_8241_length_203_cov_5.603896_g8172_i0	PRJNA358009	8241	203	5.603896	11.37590888	Cetobacterium	180162	Bacteria	Bacteria	353	4.33e-93	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g8172	i0	98.99	487.852216748768	198	1	97	1	1	197	1804964	1804767	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	99034	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1672827	1672827	PRJNA358009_P_NODE_1202_length_355_cov_2.029412_g1141_i0	PRJNA358009	1202	355	2.029412	7.2044126	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	226	1.87e-54	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g1141	i0	100	176.247887323944	122	0	62	0	227	348	27214	27093	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	62568	226	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
3623586	3623586	PRJNA358009_P_NODE_11183_length_175_cov_6.722222_g11114_i0	PRJNA358009	11183	175	6.722222	11.7638885	Fusobacterium	848	Bacteria	Bacteria	244	2.2699999999999998e-60	NTclustered	gi\|1243298346\|dbj\|AP017968.1\|	856	g11114	i0	96.622	439.611428571429	148	3	84	2	8	154	1620766	1620912	Fusobacterium varium Fv113-g1 DNA, complete genome	blastn	76932	246	0.991869918699187	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
3623725	3623725	PRJNA358009_P_NODE_5823_length_327_cov_1.629496_g5760_i0	PRJNA358009	5823	327	1.629496	5.32845192	Fusobacterium	848	Bacteria	Bacteria	178	4.86e-40	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g5760	i0	98.99	8.86238532110092	99	1	59	0	228	326	2317792	2317890	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	2898	178	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
4225567	4225567	PRJNA358009_P_NODE_9044_length_188_cov_4.438849_g8975_i0	PRJNA358009	9044	188	4.438849	8.34503612	Leptotrichia wadei	157687	Bacteria	Bacteria	279	6.79e-71	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g8975	i0	94.475	447.787234042553	181	10	96	0	5	185	223606	223786	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	84184	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
5501889	5501889	PRJNA358009_P_NODE_17945_length_154_cov_2.466667_g17876_i0	PRJNA358009	17945	154	2.466667	3.79866718	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	278	1.92e-70	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g17876	i0	99.346	472.318181818182	153	1	99	0	2	154	28147	27995	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	72737	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
6176080	6176080	PRJNA358009_P_NODE_8525_length_194_cov_8.262069_g8456_i0	PRJNA358009	8525	194	8.262069	16.02841386	Fusobacterium	848	Bacteria	Bacteria	337	4.13e-88	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g8456	i0	99.459	453.886597938144	185	1	95	0	8	192	106442	106626	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	88054	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
6775948	6775948	PRJNA358009_P_NODE_6026_length_327_cov_1.568345_g5963_i0	PRJNA358009	6026	327	1.568345	5.12848815	Leptotrichia wadei	157687	Bacteria	Bacteria	185	2.91e-42	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g5963	i0	100	5.0519877675841	100	0	59	0	228	327	2181105	2181006	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1652	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
6775961	6775961	PRJNA358009_P_NODE_7066_length_286_cov_8.586498_g6999_i0	PRJNA358009	7066	286	8.586498	24.55738428	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	394	3.81e-105	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g6999	i0	92.701	31.9335664335664	274	18	95	2	8	280	52086	51814	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	9133	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7450841	7450841	PRJNA358009_P_NODE_12766_length_167_cov_9.389831_g12697_i0	PRJNA358009	12766	167	9.389831	15.68101777	Fusobacterium	848	Bacteria	Bacteria	296	5.86e-76	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g12697	i0	100	470.40119760479	160	0	96	0	1	160	106348	106189	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	78557	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7450916	7450916	PRJNA358009_P_NODE_2206_length_328_cov_1.566308_g2143_i0	PRJNA358009	2206	328	1.566308	5.13749024	Fusobacterium	848	Bacteria	Bacteria	182	3.77e-41	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g2143	i0	99.01	112.390243902439	101	1	31	0	9	109	187727	187827	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	36864	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
8051545	8051545	PRJNA358009_P_NODE_1907_length_332_cov_3.166078_g1844_i0	PRJNA358009	1907	332	3.166078	10.51137896	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	217	1.05e-51	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g1844	i0	100	46.3885542168675	117	0	59	0	210	326	26792	26676	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	15401	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
9326353	9326353	PRJNA358009_P_NODE_17028_length_158_cov_3.871560_g16959_i0	PRJNA358009	17028	158	3.87156	6.1170648	Fusobacterium hominis	2764326	Bacteria	Bacteria	148	1.6199999999999998e-31	NTclustered	gi\|1897733338\|gb\|CP060637.1\|	2764326	g16959	i0	84.768	455.474683544304	151	19	94	4	8	156	783081	782933	Fusobacterium hominis strain NSJ-57 chromosome, complete genome	blastn	71965	148	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hominis
9326454	9326454	PRJNA358009_P_NODE_7668_length_228_cov_4.837989_g7599_i0	PRJNA358009	7668	228	4.837989	11.03061492	Leptotrichia wadei	157687	Bacteria	Bacteria	361	2.97e-95	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g7599	i0	95.946	332.55701754386	222	9	97	0	7	228	2288443	2288664	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	75823	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
10601911	10601911	PRJNA358009_P_NODE_12229_length_170_cov_3.677686_g12160_i0	PRJNA358009	12229	170	3.677686	6.2520662	Leptotrichia wadei	157687	Bacteria	Bacteria	267	4.659999999999999e-67	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g12160	i0	100	145.858823529412	144	0	85	0	20	163	222362	222219	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	24796	267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
10601975	10601975	PRJNA358009_P_NODE_1509_length_343_cov_2.721088_g1448_i0	PRJNA358009	1509	343	2.721088	9.33333184	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	111	5.28e-20	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g1448	i0	86.869	0.288629737609329	99	13	29	0	226	324	1317800	1317898	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	99	111	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
10602125	10602125	PRJNA358009_P_NODE_989_length_378_cov_17.036474_g928_i0	PRJNA358009	989	378	17.036474	64.39787172	Leptotrichia wadei	157687	Bacteria	Bacteria	658	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g928	i0	98.652	830.801587301587	371	5	98	0	1	371	1756545	1756915	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	314043	658	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
16375533	16375533	PRJNA358009_P_NODE_6993_length_297_cov_8.661290_g6927_i0	PRJNA358009	6993	297	8.66129	25.7240313	Cetobacterium	180162	Bacteria	Bacteria	457	5e-124	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g6927	i0	95.172	504.077441077441	290	12	97	2	4	291	9205	8916	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	149711	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17650595	17650595	PRJNA358009_P_NODE_234_length_618_cov_7.613357_g196_i0	PRJNA358009	234	618	7.613357	47.05054626	Fusobacteriaceae	203492	Bacteria	Bacteria	536	1.39e-147	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g196	i0	100	468.153721682848	290	0	96	0	329	618	465285	464996	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	289319	538	0.996282527881041	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
17650609	17650609	PRJNA358009_P_NODE_3314_length_327_cov_2.733813_g3251_i0	PRJNA358009	3314	327	2.733813	8.93956851	Fusobacterium	848	Bacteria	Bacteria	209	1.72e-49	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g3251	i0	100	304.749235474006	113	0	65	0	8	120	106597	106709	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	99653	209	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18249934	18249934	PRJNA358009_P_NODE_255_length_605_cov_4.969424_g216_i0	PRJNA358009	255	605	4.969424	30.0650152	Cetobacterium somerae	188913	Bacteria	Bacteria	651	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g216	i0	97.632	295.414876033058	380	8	83	1	219	598	1318593	1318971	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	178726	651	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20799724	20799724	PRJNA358009_P_NODE_15597_length_162_cov_1.805310_g15528_i0	PRJNA358009	15597	162	1.80531	2.9246022	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	259	7.400000000000001e-65	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g15528	i0	97.368	10.5185185185185	152	4	94	0	4	155	51734	51583	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	1704	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
22074711	22074711	PRJNA358009_P_NODE_1218_length_354_cov_2.488525_g1157_i0	PRJNA358009	1218	354	2.488525	8.8093785	Leptotrichia wadei	157687	Bacteria	Bacteria	228	5.1799999999999985e-55	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g1157	i0	100	210.751412429379	123	0	63	0	5	127	2248179	2248301	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	74606	228	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
22074755	22074755	PRJNA358009_P_NODE_14318_length_164_cov_7.208696_g14249_i0	PRJNA358009	14318	164	7.208696	11.82226144	Cetobacterium somerae	188913	Bacteria	Bacteria	267	4.49e-67	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g14249	i0	97.452	54.5609756097561	157	3	96	1	1	157	420312	420157	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	8948	267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24624532	24624532	PRJNA358009_P_NODE_480_length_496_cov_5.163311_g433_i0	PRJNA358009	480	496	5.163311	25.61002256	Leptotrichia wadei	157687	Bacteria	Bacteria	863	0	NTclustered	gi\|1791353085\|dbj\|AP019829.2\|	157687	g433	i0	98.371	188.715725806452	491	8	99	0	1	491	213194	212704	Leptotrichia wadei JCM16777 DNA, complete genome	blastn	93603	863	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
24624547	24624547	PRJNA358009_P_NODE_600_length_455_cov_8.352217_g544_i0	PRJNA358009	600	455	8.352217	38.00258735	Fusobacterium polymorphum	76857	Bacteria	Bacteria	387	1.06e-102	NTclustered	gi\|2706501641\|gb\|CP084157.1\|	76857	g544	i0	99.528	434.21978021978	212	1	89	0	1	212	57848	58059	Fusobacterium polymorphum strain KCOM2446 chromosome, complete genome	blastn	197570	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
25299261	25299261	PRJNA358009_P_NODE_7360_length_250_cov_5.034826_g7292_i0	PRJNA358009	7360	250	5.034826	12.587065	Fusobacterium	848	Bacteria	Bacteria	359	1.19e-94	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g7292	i0	93.281	521.82	253	2	96	4	4	242	156775	156524	Fusobacterium varium strain SB069 chromosome	blastn	130455	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium

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