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

30 rows where analysis = "blastn", bioproject = "PRJNA1255065" 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
359899	359899	PRJNA1255065_P_NODE_127241_length_166_cov_0.888889_g125013_i0	PRJNA1255065	127241	166	0.888889	1.47555574	Cetobacterium somerae	188913	Bacteria	Bacteria	300	4.5e-77	NTclustered	gi\|2666491349\|gb\|CP143325.1\|	188913	g125013	i0	99.394	1.98795180722892	165	1	99	0	1	165	24369	24205	Cetobacterium somerae strain ceto plasmid p6, complete sequence	blastn	330	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1053087	1053087	PRJNA1255065_P_NODE_120721_length_167_cov_0.881356_g118493_i0	PRJNA1255065	120721	167	0.881356	1.47186452	Fusobacterium	848	Bacteria	Bacteria	209	7.85e-50	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g118493	i0	89.222	70.6167664670659	167	18	100	0	1	167	1995529	1995695	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	11793	209	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
1634518	1634518	PRJNA1255065_P_NODE_101102_length_173_cov_1.258065_g98874_i0	PRJNA1255065	101102	173	1.258065	2.17645245	Cetobacterium somerae	188913	Bacteria	Bacteria	287	3.6600000000000005e-73	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g98874	i0	96.532	14.1098265895954	173	6	100	0	1	173	1626085	1626257	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2441	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2910630	2910630	PRJNA1255065_P_NODE_124203_length_166_cov_0.888889_g121975_i0	PRJNA1255065	124203	166	0.888889	1.47555574	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g121975	i0	96.988	1	166	5	100	0	1	166	2292079	2292244	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	166	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4187458	4187458	PRJNA1255065_P_NODE_48344_length_299_cov_1.204000_g46118_i0	PRJNA1255065	48344	299	1.204	3.59996	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	464	3.0099999999999996e-126	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g46118	i0	94.949	363.638795986622	297	14	100	1	1	296	52764	53060	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	108728	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4881343	4881343	PRJNA1255065_P_NODE_41004_length_347_cov_1.446309_g38782_i0	PRJNA1255065	41004	347	1.446309	5.01869223	Cetobacterium	180162	Bacteria	Bacteria	569	7.339999999999996e-158	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g38782	i0	96.254	31.7348703170029	347	13	100	0	1	347	1908687	1909033	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	11012	569	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4881405	4881405	PRJNA1255065_P_NODE_51664_length_281_cov_1.538793_g49438_i0	PRJNA1255065	51664	281	1.538793	4.32400833	Cetobacterium	180162	Bacteria	Bacteria	486	5.989999999999999e-133	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g49438	i0	97.865	17.779359430605	281	6	100	0	1	281	480567	480287	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4996	486	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6737811	6737811	PRJNA1255065_P_NODE_134066_length_165_cov_0.887931_g131838_i0	PRJNA1255065	134066	165	0.887931	1.46508615	Cetobacterium somerae	188913	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g131838	i0	96.97	5	165	5	100	0	1	165	151556	151720	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	825	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7431454	7431454	PRJNA1255065_P_NODE_79706_length_201_cov_1.361842_g77478_i0	PRJNA1255065	79706	201	1.361842	2.73730242	Cetobacterium	180162	Bacteria	Bacteria	361	2.5599999999999998e-95	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g77478	i0	99.005	5	201	2	100	0	1	201	1909586	1909386	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1005	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9288047	9288047	PRJNA1255065_P_NODE_113808_length_168_cov_0.873950_g111580_i0	PRJNA1255065	113808	168	0.87395	1.468236	Cetobacterium somerae	188913	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2850953754\|gb\|CP173062.1\|	1319815	g111580	i0	100	3	168	0	100	0	1	168	459427	459260	Cetobacterium somerae ATCC BAA-474 plasmid unnamed01	blastn	504	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9981279	9981279	PRJNA1255065_P_NODE_153568_length_162_cov_0.902655_g151340_i0	PRJNA1255065	153568	162	0.902655	1.4623011	Cetobacterium	180162	Bacteria	Bacteria	174	2.76e-39	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g151340	i0	87.097	4.78395061728395	155	18	95	2	1	154	171001	170848	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	775	174	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10564255	10564255	PRJNA1255065_P_NODE_145449_length_163_cov_0.912281_g143221_i0	PRJNA1255065	145449	163	0.912281	1.48701803	Fusobacterium mortiferum	850	Bacteria	Bacteria	158	2.8e-34	NTclustered	gi\|1370540179\|gb\|CP028102.1\|	469616	g143221	i0	84.242	5.59509202453988	165	22	100	3	1	163	113661	113823	Fusobacterium mortiferum ATCC 9817 chromosome, complete genome	blastn	912	158	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
11256403	11256403	PRJNA1255065_P_NODE_137469_length_164_cov_0.904348_g135241_i0	PRJNA1255065	137469	164	0.904348	1.48313072	Cetobacterium	180162	Bacteria	Bacteria	272	9.65e-69	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g135241	i0	96.951	170.115853658537	164	2	100	2	1	164	275627	275467	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	27899	272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13114441	13114441	PRJNA1255065_P_NODE_72871_length_213_cov_1.926829_g70643_i0	PRJNA1255065	72871	213	1.926829	4.10414577	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	394	2.7e-105	NTclustered	gi\|1276720946\|gb\|CP024705.1\|	2663009	g70643	i0	100	483.009389671361	213	0	100	0	1	213	1306171	1305959	Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome	blastn	102881	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
14389584	14389584	PRJNA1255065_P_NODE_58252_length_253_cov_1.514706_g56024_i0	PRJNA1255065	58252	253	1.514706	3.83220618	Cetobacterium somerae	188913	Bacteria	Bacteria	363	9.339999999999996e-96	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g56024	i0	92.49	5	253	19	100	0	1	253	1159128	1159380	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1265	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14389755	14389755	PRJNA1255065_P_NODE_80132_length_200_cov_1.960265_g77904_i0	PRJNA1255065	80132	200	1.960265	3.92053	Fusobacterium polymorphum	76857	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g77904	i0	100	471.22	200	0	100	0	1	200	2465114	2464915	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	94244	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
15080596	15080596	PRJNA1255065_P_NODE_106672_length_169_cov_0.866667_g104444_i0	PRJNA1255065	106672	169	0.866667	1.46466723	Leptotrichia	32067	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g104444	i0	98.817	15.9763313609467	169	2	100	0	1	169	1751750	1751918	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2700	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15080666	15080666	PRJNA1255065_P_NODE_122012_length_166_cov_1.871795_g119784_i0	PRJNA1255065	122012	166	1.871795	3.1071797	Cetobacterium	180162	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g119784	i0	100	9.75301204819277	166	0	100	0	1	166	481121	480956	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1619	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15080727	15080727	PRJNA1255065_P_NODE_134052_length_165_cov_0.887931_g131824_i0	PRJNA1255065	134052	165	0.887931	1.46508615	Cetobacterium	180162	Bacteria	Bacteria	235	1.28e-57	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g131824	i0	92.683	5.04242424242424	164	10	98	1	1	162	1148353	1148516	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	832	235	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15662670	15662670	PRJNA1255065_P_NODE_107693_length_169_cov_0.866667_g105465_i0	PRJNA1255065	107693	169	0.866667	1.46466723	Cetobacterium somerae	188913	Bacteria	Bacteria	206	1.02e-48	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g105465	i0	88.69	4.97041420118343	168	19	99	0	1	168	1523822	1523655	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	840	206	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15663609	15663609	PRJNA1255065_P_NODE_90673_length_185_cov_1.500000_g88445_i0	PRJNA1255065	90673	185	1.5	2.775	Cetobacterium somerae	188913	Bacteria	Bacteria	300	5.110000000000001e-77	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g88445	i0	96.196	5.63243243243243	184	6	99	1	2	185	1679335	1679153	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1042	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16355547	16355547	PRJNA1255065_P_NODE_142033_length_163_cov_0.912281_g139805_i0	PRJNA1255065	142033	163	0.912281	1.48701803	Fusobacterium	848	Bacteria	Bacteria	274	2.66e-69	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g139805	i0	96.933	83.4478527607362	163	5	100	0	1	163	922793	922955	Fusobacterium hwasookii ChDC F174, complete genome	blastn	13602	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
16937049	16937049	PRJNA1255065_P_NODE_107434_length_169_cov_0.866667_g105206_i0	PRJNA1255065	107434	169	0.866667	1.46466723	Fusobacterium varium	856	Bacteria	Bacteria	122	1.06e-23	NTclustered	gi\|1243298346\|dbj\|AP017968.1\|	856	g105206	i0	80.488	97.1656804733728	164	28	96	3	3	164	775680	775841	Fusobacterium varium Fv113-g1 DNA, complete genome	blastn	16421	122	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
17630852	17630852	PRJNA1255065_P_NODE_143234_length_163_cov_0.912281_g141006_i0	PRJNA1255065	143234	163	0.912281	1.48701803	Cetobacterium	180162	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g141006	i0	95.092	11.9018404907975	163	8	100	0	1	163	1907623	1907785	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1940	257	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19486227	19486227	PRJNA1255065_P_NODE_148816_length_162_cov_0.920354_g146588_i0	PRJNA1255065	148816	162	0.920354	1.49097348	Fusobacterium polymorphum	76857	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2706074160\|gb\|CP077112.1\|	76857	g146588	i0	100	61	162	0	100	0	1	162	413565	413726	Fusobacterium polymorphum strain KCOM1272 chromosome, complete genome	blastn	9882	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
19486358	19486358	PRJNA1255065_P_NODE_42756_length_334_cov_1.842105_g40531_i0	PRJNA1255065	42756	334	1.842105	6.1526307	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	470	7.34e-128	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g40531	i0	92.169	298.050898203593	332	26	99	0	1	332	52168	51837	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	99549	470	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19486694	19486694	PRJNA1255065_P_NODE_85276_length_192_cov_1.881119_g83048_i0	PRJNA1255065	85276	192	1.881119	3.61174848	Fusobacteria bacterium ZRK30	2970471	Bacteria	Bacteria	200	5.58e-47	NTclustered	gi\|2284595238\|gb\|CP102405.1\|	2970471	g83048	i0	86.243	31.0104166666667	189	21	98	3	1	188	368899	368715	Fusobacteria bacterium ZRK30 chromosome 2, complete sequence	blastn	5954	200	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteria bacterium ZRK30
21454911	21454911	PRJNA1255065_P_NODE_127617_length_166_cov_0.888889_g125389_i0	PRJNA1255065	127617	166	0.888889	1.47555574	Leptotrichia	32067	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g125389	i0	100	2	166	0	100	0	1	166	544167	544332	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	332	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
23312061	23312061	PRJNA1255065_P_NODE_116139_length_167_cov_1.567797_g113911_i0	PRJNA1255065	116139	167	1.567797	2.61822099	Cetobacterium somerae	188913	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g113911	i0	98.204	5	167	3	100	0	1	167	677018	677184	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	835	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24005258	24005258	PRJNA1255065_P_NODE_35119_length_399_cov_4.277143_g32899_i0	PRJNA1255065	35119	399	4.277143	17.06580057	Fusobacterium	848	Bacteria	Bacteria	562	1.43e-155	NTclustered	gi\|2706442435\|gb\|CP084063.1\|	76857	g32899	i0	98.738	275.651629072682	317	3	79	1	1	317	2335913	2336228	Fusobacterium polymorphum strain SB004 chromosome, complete genome	blastn	109985	562	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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