metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1126661" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1126661" 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
282619	282619	PRJNA1126661_P_NODE_55621_length_287_cov_4.364486_g55092_i0	PRJNA1126661	55621	287	4.364486	12.52607482	Fusobacterium polymorphum	76857	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g55092	i0	100	100	287	0	100	0	1	287	1220849	1220563	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	28700	531	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
282897	282897	PRJNA1126661_P_NODE_9481_length_326_cov_7.695652_g8952_i0	PRJNA1126661	9481	326	7.695652	25.08782552	Leptotrichia trevisanii	109328	Bacteria	Bacteria	268	2.7999999999999998e-67	NTclustered	gi\|1708579770\|dbj\|AP019840.1\|	109328	g8952	i0	98.675	3.20245398773006	151	2	91	0	176	326	1625168	1625018	Leptotrichia trevisanii JMUB3935 DNA, complete genome	blastn	1044	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
2833068	2833068	PRJNA1126661_P_NODE_36343_length_301_cov_5.166667_g35814_i0	PRJNA1126661	36343	301	5.166667	15.55166767	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	270	7.0999999999999986e-68	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g35814	i0	98.684	5.72425249169435	152	2	100	0	150	301	993235	993084	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	1723	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
3581634	3581634	PRJNA1126661_P_NODE_59643_length_278_cov_6.034146_g59113_i0	PRJNA1126661	59643	278	6.034146	16.77492588	Fusobacterium	848	Bacteria	Bacteria	209	1.43e-49	NTclustered	gi\|2704970001\|gb\|CP077124.1\|	851	g59113	i0	93.571	85.3093525179856	140	9	98	0	7	146	1309101	1309240	Fusobacterium nucleatum strain KCOM3756 chromosome, complete genome	blastn	23716	209	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
4109535	4109535	PRJNA1126661_P_NODE_46984_length_298_cov_6.551111_g46455_i0	PRJNA1126661	46984	298	6.551111	19.52231078	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	257	5.47e-64	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g46455	i0	96.774	1.43624161073825	155	4	100	1	1	154	1646406	1646560	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	428	257	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4109858	4109858	PRJNA1126661_P_NODE_82044_length_217_cov_5.951389_g81514_i0	PRJNA1126661	82044	217	5.951389	12.91451413	Fusobacterium polymorphum	76857	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|2645859777\|gb\|CP141277.1\|	76857	g81514	i0	100	99.9677419354839	217	0	100	0	1	217	544552	544768	Fusobacterium polymorphum strain C48P chromosome, complete genome	blastn	21693	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
4858873	4858873	PRJNA1126661_P_NODE_22924_length_326_cov_3.466403_g22395_i0	PRJNA1126661	22924	326	3.466403	11.30047378	Leptotrichia	32067	Bacteria	Bacteria	263	1.3e-65	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g22395	i0	98.013	7.40490797546012	151	3	93	0	176	326	235868	236018	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2414	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
5385415	5385415	PRJNA1126661_P_NODE_22805_length_326_cov_3.482213_g22276_i0	PRJNA1126661	22805	326	3.482213	11.35201438	Fusobacterium polymorphum	76857	Bacteria	Bacteria	279	1.29e-70	NTclustered	gi\|2706506546\|gb\|CP084156.1\|	76857	g22276	i0	100	90.5245398773006	151	0	93	0	1	151	1117227	1117377	Fusobacterium polymorphum strain KCOM2510 chromosome	blastn	29511	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
5385425	5385425	PRJNA1126661_P_NODE_23685_length_326_cov_3.379447_g23156_i0	PRJNA1126661	23685	326	3.379447	11.01699722	Leptotrichia mesophila	3239303	Bacteria	Bacteria	278	4.64e-70	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g23156	i0	100	13.8159509202454	150	0	92	0	177	326	402070	402219	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	4504	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
6660103	6660103	PRJNA1126661_P_NODE_24506_length_326_cov_3.276680_g23977_i0	PRJNA1126661	24506	326	3.27668	10.6819768	Fusobacterium polymorphum	76857	Bacteria	Bacteria	278	4.64e-70	NTclustered	gi\|2707713825\|gb\|CP077160.1\|	76857	g23977	i0	100	83.7638036809816	150	0	92	0	177	326	257292	257143	Fusobacterium polymorphum strain SB051 chromosome, complete genome	blastn	27307	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
7408688	7408688	PRJNA1126661_P_NODE_25726_length_326_cov_3.079051_g25197_i0	PRJNA1126661	25726	326	3.079051	10.03770626	Fusobacterium	848	Bacteria	Bacteria	279	1.29e-70	NTclustered	gi\|2704985630\|gb\|CP077134.1\|	851	g25197	i0	100	91.2546012269939	151	0	93	0	176	326	1231911	1232061	Fusobacterium nucleatum strain KCOM3164 chromosome, complete genome	blastn	29749	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7935087	7935087	PRJNA1126661_P_NODE_11787_length_326_cov_6.249012_g11258_i0	PRJNA1126661	11787	326	6.249012	20.37177912	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	257	6.0500000000000006e-64	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g11258	i0	97.351	3.06748466257669	151	4	46	0	176	326	166777	166627	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	1000	257	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7935883	7935883	PRJNA1126661_P_NODE_85967_length_204_cov_6.847328_g85437_i0	PRJNA1126661	85967	204	6.847328	13.96854912	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	377	2.59e-100	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g85437	i0	100	1	204	0	100	0	1	204	943254	943457	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	204	377	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
9210572	9210572	PRJNA1126661_P_NODE_54008_length_290_cov_7.018433_g53479_i0	PRJNA1126661	54008	290	7.018433	20.3534557	Leptotrichia trevisanii	109328	Bacteria	Bacteria	431	2.95e-116	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g53479	i0	93.471	9.2	291	18	100	1	1	290	559135	559425	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	2668	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
10485984	10485984	PRJNA1126661_P_NODE_39969_length_301_cov_3.412281_g39440_i0	PRJNA1126661	39969	301	3.412281	10.27096581	Leptotrichia mesophila	3239303	Bacteria	Bacteria	505	1.79e-138	NTclustered	gi\|2785242249\|gb\|CP165646.1\|	3239303	g39440	i0	96.732	3.04318936877076	306	5	100	1	1	301	344786	345091	Leptotrichia sp. HSP-342 chromosome, complete genome	blastn	916	505	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia mesophila
13036186	13036186	PRJNA1126661_P_NODE_42191_length_300_cov_8.735683_g41662_i0	PRJNA1126661	42191	300	8.735683	26.207049	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	263	1.18e-65	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g41662	i0	97.419	10.12	155	3	100	1	1	155	965357	965204	Leptotrichia sp. SK-5 DNA, complete genome	blastn	3036	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
13036467	13036467	PRJNA1126661_P_NODE_71071_length_250_cov_7.118644_g70541_i0	PRJNA1126661	71071	250	7.118644	17.79661	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g70541	i0	99.6	9	250	1	100	0	1	250	1927938	1927689	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2250	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
14311006	14311006	PRJNA1126661_P_NODE_14152_length_326_cov_5.343874_g13623_i0	PRJNA1126661	14152	326	5.343874	17.42102924	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	217	1.03e-51	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g13623	i0	92.667	0.460122699386503	150	11	46	0	177	326	1020816	1020667	Leptotrichia sp. oral taxon 498, complete genome	blastn	150	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
16333513	16333513	PRJNA1126661_P_NODE_59393_length_279_cov_3.441748_g58864_i0	PRJNA1126661	59393	279	3.441748	9.60247692	Fusobacterium	848	Bacteria	Bacteria	483	7.689999999999998e-132	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g58864	i0	97.849	99.8817204301075	279	6	100	0	1	279	818260	818538	Fusobacterium hwasookii ChDC F206, complete genome	blastn	27867	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
16859372	16859372	PRJNA1126661_P_NODE_17594_length_326_cov_4.395257_g17065_i0	PRJNA1126661	17594	326	4.395257	14.32853782	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	268	2.7999999999999998e-67	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g17065	i0	98.675	7.0920245398773	151	2	93	0	1	151	186215	186365	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2312	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
16859693	16859693	PRJNA1126661_P_NODE_42434_length_300_cov_7.365639_g41905_i0	PRJNA1126661	42434	300	7.365639	22.096917	Leptotrichia wadei	157687	Bacteria	Bacteria	270	7.08e-68	NTclustered	gi\|1708579735\|dbj\|AP019837.1\|	157687	g41905	i0	97.484	13.47	159	3	100	1	142	300	14779	14622	Leptotrichia wadei JMUB3934 plasmid pJMUB3934p2 DNA, complete genome	blastn	4041	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
17608386	17608386	PRJNA1126661_P_NODE_11994_length_326_cov_6.150198_g11465_i0	PRJNA1126661	11994	326	6.150198	20.04964548	Fusobacterium	848	Bacteria	Bacteria	483	9.169999999999999e-132	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g11465	i0	90.881	51.8067484662577	329	26	100	2	1	326	2211094	2211421	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	16889	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
18134402	18134402	PRJNA1126661_P_NODE_60135_length_277_cov_4.651961_g59605_i0	PRJNA1126661	60135	277	4.651961	12.88593197	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	462	9.929999999999999e-126	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g59605	i0	96.751	2.13357400722022	277	9	100	0	1	277	196640	196364	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	591	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19408122	19408122	PRJNA1126661_P_NODE_24056_length_326_cov_3.335968_g23527_i0	PRJNA1126661	24056	326	3.335968	10.87525568	Leptotrichia trevisanii	109328	Bacteria	Bacteria	268	2.7999999999999998e-67	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g23527	i0	98.675	0.93558282208589	151	2	93	0	1	151	902979	902829	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	305	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
20683963	20683963	PRJNA1126661_P_NODE_46717_length_298_cov_8.493333_g46188_i0	PRJNA1126661	46717	298	8.493333	25.31013234	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	523	4.879999999999998e-144	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g46188	i0	98.322	14.9395973154362	298	5	100	0	1	298	332814	332517	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	4452	523	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
21959572	21959572	PRJNA1126661_P_NODE_76978_length_234_cov_11.465839_g76448_i0	PRJNA1126661	76978	234	11.465839	26.83006326	Leptotrichia buccalis	40542	Bacteria	Bacteria	422	1.39e-113	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g76448	i0	99.145	9.98290598290598	234	2	100	0	1	234	1054728	1054495	Leptotrichia buccalis DSM 1135, complete genome	blastn	2336	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
23234832	23234832	PRJNA1126661_P_NODE_44419_length_300_cov_3.625551_g43890_i0	PRJNA1126661	44419	300	3.625551	10.876653	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	263	1.18e-65	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g43890	i0	98.013	1.97	151	3	99	0	150	300	1390914	1390764	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	591	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis

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