metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA631796" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA631796" 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
1879578	1879578	PRJNA631796_P_NODE_8862_length_230_cov_1.384615_g8584_i0	PRJNA631796	8862	230	1.384615	3.1846145	Fusobacterium canifelinum	285729	Bacteria	Bacteria	403	4.92e-108	NTclustered	gi\|1948622963\|gb\|CP066022.1\|	285729	g8584	i0	98.261	102	230	4	100	0	1	230	715445	715216	Fusobacterium canifelinum strain FDAARGOS_999 chromosome, complete genome	blastn	23460	403	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium canifelinum
3154284	3154284	PRJNA631796_P_NODE_6903_length_260_cov_1.351759_g6625_i0	PRJNA631796	6903	260	1.351759	3.5145734	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	470	5.519999999999998e-128	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g6625	i0	99.231	304.292307692308	260	2	100	0	1	260	25604	25863	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	79116	470	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
4431122	4431122	PRJNA631796_P_NODE_7244_length_253_cov_1.645833_g6966_i0	PRJNA631796	7244	253	1.645833	4.16395749	Leptotrichia wadei	157687	Bacteria	Bacteria	457	4.16e-124	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g6966	i0	99.209	76.7351778656126	253	2	100	0	1	253	2369894	2369642	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	19414	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
6255703	6255703	PRJNA631796_P_NODE_6545_length_267_cov_3.587379_g6267_i0	PRJNA631796	6545	267	3.587379	9.57830193	Fusobacterium	848	Bacteria	Bacteria	388	1.64e-103	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g6267	i0	93.208	521.850187265918	265	17	99	1	1	265	157060	156797	Fusobacterium varium strain SB069 chromosome	blastn	139334	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
7529877	7529877	PRJNA631796_P_NODE_11926_length_205_cov_1.847222_g11648_i0	PRJNA631796	11926	205	1.847222	3.7868051	Leptotrichia	32067	Bacteria	Bacteria	379	7.229999999999999e-101	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g11648	i0	100	308.214634146341	205	0	100	0	1	205	2067	2271	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	63184	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
8256566	8256566	PRJNA631796_P_NODE_5287_length_299_cov_4.571429_g5009_i0	PRJNA631796	5287	299	4.571429	13.66857271	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	553	6.25e-153	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g5009	i0	100	458.207357859532	299	0	100	0	1	299	309114	309412	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	137004	553	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
8256573	8256573	PRJNA631796_P_NODE_6287_length_273_cov_3.000000_g6009_i0	PRJNA631796	6287	273	3	8.19	Fusobacterium perfoetens	852	Bacteria	Bacteria	412	9.98e-111	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g6009	i0	93.818	452.413919413919	275	15	100	2	1	273	275	549	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	123509	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
9531874	9531874	PRJNA631796_P_NODE_12508_length_203_cov_1.352113_g12230_i0	PRJNA631796	12508	203	1.352113	2.74478939	Fusobacterium polymorphum	76857	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g12230	i0	100	99.8866995073892	203	0	100	0	1	203	949429	949227	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	20277	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
9531919	9531919	PRJNA631796_P_NODE_6168_length_276_cov_2.562791_g5890_i0	PRJNA631796	6168	276	2.562791	7.07330316	Leptotrichia wadei	157687	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g5890	i0	100	271.507246376812	276	0	100	0	1	276	2248812	2249087	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	74936	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
9531922	9531922	PRJNA631796_P_NODE_6568_length_267_cov_1.412621_g6290_i0	PRJNA631796	6568	267	1.412621	3.77169807	Fusobacterium gastrosuis	1755100	Bacteria	Bacteria	449	7.410000000000001e-122	NTclustered	gi\|1795735174\|emb\|LT607734.1\|	1755100	g6290	i0	97.004	500.101123595506	267	8	100	0	1	267	344517	344783	Fusobacterium sp. P6 Po strain Fusobacterium gastrosuis sp. nov. CDW1, P6 Po genome assembly, chromosome: chr	blastn	133527	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium gastrosuis
10080457	10080457	PRJNA631796_P_NODE_10668_length_211_cov_3.386667_g10390_i0	PRJNA631796	10668	211	3.386667	7.14586737	Fusobacterium	848	Bacteria	Bacteria	335	1.6399999999999994e-87	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g10390	i0	95.261	527.492890995261	211	10	100	0	1	211	337990	337780	Fusobacterium varium strain SB069 chromosome	blastn	111301	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
11355481	11355481	PRJNA631796_S_NODE_269_length_1027_cov_8.173913_g169_i0	PRJNA631796	269	1027	8.173913	83.94608651	Cetobacterium	180162	Bacteria	Bacteria	1853	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g169	i0	99.221	496.631937682571	1027	8	100	0	1	1027	278769	279795	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	510041	1853	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12082835	12082835	PRJNA631796_P_NODE_4250_length_336_cov_6.756364_g3972_i0	PRJNA631796	4250	336	6.756364	22.70138304	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	555	1.9799999999999998e-153	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g3972	i0	96.429	468.842261904762	336	12	100	0	1	336	53541	53876	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	157531	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
13357557	13357557	PRJNA631796_P_NODE_131_length_1837_cov_14.535473_g56_i1	PRJNA631796	131	1837	14.535473	267.01663901	Leptotrichia hofstadii	157688	Bacteria	Bacteria	3081	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g56	i1	96.906	473.170930865542	1842	51	100	5	1	1837	2257376	2255536	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	869215	3081	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
13357584	13357584	PRJNA631796_P_NODE_5791_length_286_cov_4.111111_g5513_i0	PRJNA631796	5791	286	4.111111	11.75777746	Leptotrichia hofstadii	157688	Bacteria	Bacteria	422	1.75e-113	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g5513	i0	98.333	172.454545454545	240	4	84	0	47	286	2374748	2374987	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	49322	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
14632397	14632397	PRJNA631796_S_NODE_64532_length_220_cov_5.886792_g64365_i0	PRJNA631796	64532	220	5.886792	12.9509424	Cetobacterium somerae	188913	Bacteria	Bacteria	390	3.629999999999999e-104	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g64365	i0	98.636	398.068181818182	220	3	100	0	1	220	49213	48994	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	87575	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15180398	15180398	PRJNA631796_P_NODE_13072_length_201_cov_1.657143_g12794_i0	PRJNA631796	13072	201	1.657143	3.33085743	Leptotrichia	32067	Bacteria	Bacteria	252	1.61e-62	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g12794	i0	96.129	5.2089552238806	155	5	77	1	1	154	1836504	1836658	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	1047	252	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
16454789	16454789	PRJNA631796_P_NODE_3453_length_376_cov_5.434921_g3176_i0	PRJNA631796	3453	376	5.434921	20.43530296	Cetobacterium	180162	Bacteria	Bacteria	544	4.84e-150	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g3176	i0	92.8	496.686170212766	375	27	99	0	1	375	278691	279065	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	186754	544	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16454834	16454834	PRJNA631796_S_NODE_2933_length_384_cov_2.708978_g2766_i0	PRJNA631796	2933	384	2.708978	10.40247552	Cetobacterium	180162	Bacteria	Bacteria	693	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g2766	i0	99.475	495.005208333333	381	2	99	0	4	384	1804687	1805067	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	190082	699	0.991416309012876	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17181354	17181354	PRJNA631796_P_NODE_12154_length_205_cov_0.888889_g11876_i0	PRJNA631796	12154	205	0.888889	1.82222245	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	363	7.279999999999998e-96	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g11876	i0	98.537	99.6341463414634	205	3	100	0	1	205	1923739	1923943	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	20425	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
17181362	17181362	PRJNA631796_P_NODE_12674_length_203_cov_0.901408_g12396_i0	PRJNA631796	12674	203	0.901408	1.82985824	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	348	2.0100000000000006e-91	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g12396	i0	97.537	8.97044334975369	203	5	100	0	1	203	106199	105997	Leptotrichia sp. SK-5 DNA, complete genome	blastn	1821	348	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
17181366	17181366	PRJNA631796_P_NODE_1314_length_629_cov_7.272887_g1053_i0	PRJNA631796	1314	629	7.272887	45.74645923	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1140	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g1053	i0	99.364	458.677265500795	629	4	100	0	1	629	52210	51582	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	288508	1140	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17729887	17729887	PRJNA631796_P_NODE_154_length_1691_cov_15.964417_g56_i2	PRJNA631796	154	1691	15.964417	269.95829147	Leptotrichia	32067	Bacteria	Bacteria	2880	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g56	i2	97.401	486.369012418687	1693	41	100	2	1	1691	196680	198371	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	822450	2880	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
17729950	17729950	PRJNA631796_S_NODE_32594_length_248_cov_2.294118_g32427_i0	PRJNA631796	32594	248	2.294118	5.68941264	Cetobacterium	180162	Bacteria	Bacteria	436	5.3e-118	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g32427	i0	98.387	494.383064516129	248	4	100	0	1	248	280751	280504	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	122607	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18455452	18455452	PRJNA631796_P_NODE_14235_length_176_cov_5.078261_g13957_i0	PRJNA631796	14235	176	5.078261	8.93773936	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g13957	i0	100	59.3125	176	0	100	0	1	176	25370	25545	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	10439	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
19003435	19003435	PRJNA631796_P_NODE_10335_length_215_cov_1.233766_g10057_i0	PRJNA631796	10335	215	1.233766	2.6525969	Cetobacterium	180162	Bacteria	Bacteria	381	2.1299999999999996e-101	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g10057	i0	98.605	495.53488372093	215	3	100	0	1	215	279353	279139	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	106540	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19003442	19003442	PRJNA631796_P_NODE_115_length_1923_cov_15.192803_g56_i0	PRJNA631796	115	1923	15.192803	292.15760169	Leptotrichia	32067	Bacteria	Bacteria	2889	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g56	i0	93.779	474.419656786271	1929	111	100	9	1	1923	497683	499608	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	912309	2889	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
19729990	19729990	PRJNA631796_P_NODE_13676_length_193_cov_4.227273_g13398_i0	PRJNA631796	13676	193	4.227273	8.15863689	Leptotrichia wadei	157687	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g13398	i0	100	433.678756476684	193	0	100	0	1	193	2247208	2247400	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	83700	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19729991	19729991	PRJNA631796_P_NODE_13816_length_191_cov_2.646154_g13538_i0	PRJNA631796	13816	191	2.646154	5.05415414	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	342	8.699999999999999e-90	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g13538	i0	98.953	7.17277486910995	191	2	100	0	1	191	2171502	2171312	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	1370	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
25378396	25378396	PRJNA631796_P_NODE_160_length_1674_cov_15.360198_g56_i3	PRJNA631796	160	1674	15.360198	257.12971452	Leptotrichia	32067	Bacteria	Bacteria	2728	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g56	i3	96.064	444.62962962963	1677	62	100	3	1	1674	2455679	2454004	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	744310	2728	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii

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