metadata: contig_metadata: 29 rows where bioproject = "PRJNA188516" and tax

29 rows where bioproject = "PRJNA188516" and tax_phylum = "Fusobacteriota"

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
1640604	1640604	PRJNA188516_P_NODE_4922_length_166_cov_0.888889_g4872_i0	PRJNA188516	4922	166	0.888889	1.47555574	Fusobacterium ulcerans	861	Bacteria	Bacteria	75	2.97e-9	NTclustered	gi\|1370545701\|gb\|CP028105.1\|	861	g4872	i0	83.333	1.01204819277108	84	10	49	4	70	151	83377	83296	Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome	blastn	168	75	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
2330459	2330459	PRJNA188516_P_NODE_1482_length_298_cov_1.385542_g1432_i0	PRJNA188516	1482	298	1.385542	4.12891516	Fusobacterium	848	Bacteria	Bacteria	313	1.15e-80	NTclustered	gi\|2706069597\|gb\|CP077108.1\|	76857	g1432	i0	100	399.818791946309	169	0	100	0	1	169	1185184	1185016	Fusobacterium polymorphum strain KCOM1281 chromosome, complete genome	blastn	119146	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
2916446	2916446	PRJNA188516_P_NODE_2443_length_219_cov_1.694118_g2393_i0	PRJNA188516	2443	219	1.694118	3.71011842	Leptotrichia alba	3239304	Bacteria	Bacteria	396	7.769999999999997e-106	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g2393	i0	99.539	453.712328767123	217	1	99	0	3	219	488862	488646	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	99363	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
3605650	3605650	PRJNA188516_P_NODE_1483_length_298_cov_1.329317_g1433_i0	PRJNA188516	1483	298	1.329317	3.96136466	Cetobacterium	180162	Bacteria	Bacteria	545	1.04e-150	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1433	i0	99.664	106.127516778523	298	1	100	0	1	298	1561533	1561236	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	31626	545	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6743481	6743481	PRJNA188516_P_NODE_3726_length_175_cov_1.507937_g3676_i0	PRJNA188516	3726	175	1.507937	2.63888975	Cetobacterium somerae	188913	Bacteria	Bacteria	111	2.4e-20	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g3676	i0	84.685	3.06857142857143	111	17	63	0	63	173	1409481	1409591	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	537	111	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6743503	6743503	PRJNA188516_P_NODE_5126_length_165_cov_0.896552_g5076_i0	PRJNA188516	5126	165	0.896552	1.4793108	Leptotrichia alba	3239304	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g5076	i0	100	108.048484848485	165	0	100	0	1	165	124231	124395	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	17828	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
7433085	7433085	PRJNA188516_P_NODE_4706_length_167_cov_0.881356_g4656_i0	PRJNA188516	4706	167	0.881356	1.47186452	Cetobacterium	180162	Bacteria	Bacteria	254	3.58e-63	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g4656	i0	95.062	5.02395209580838	162	7	96	1	7	167	425440	425279	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	839	254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7433092	7433092	PRJNA188516_P_NODE_5906_length_162_cov_1.380531_g5856_i0	PRJNA188516	5906	162	1.380531	2.23646022	Cetobacterium	180162	Bacteria	Bacteria	231	1.6099999999999998e-56	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g5856	i0	100	52.6666666666667	125	0	77	0	27	151	280867	280991	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	8532	231	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12533838	12533838	PRJNA188516_P_NODE_3490_length_181_cov_2.446970_g3440_i0	PRJNA188516	3490	181	2.44697	4.4290157	Fusobacterium	848	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g3440	i0	100	481.82320441989	181	0	100	0	1	181	322058	322238	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	87210	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
13119549	13119549	PRJNA188516_P_NODE_1911_length_252_cov_1.320197_g1861_i0	PRJNA188516	1911	252	1.320197	3.32689644	Leptotrichia hofstadii	157688	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g1861	i0	97.619	101.797619047619	252	6	100	0	1	252	498180	497929	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	25653	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
14394915	14394915	PRJNA188516_P_NODE_4972_length_166_cov_0.888889_g4922_i0	PRJNA188516	4972	166	0.888889	1.47555574	Cetobacterium somerae	188913	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g4922	i0	96.988	14.9457831325301	166	5	100	0	1	166	1819099	1818934	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2481	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15082733	15082733	PRJNA188516_P_NODE_2872_length_202_cov_1.019608_g2822_i0	PRJNA188516	2872	202	1.019608	2.05960816	Cetobacterium	180162	Bacteria	Bacteria	346	7.2e-91	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g2822	i0	97.525	7.37623762376238	202	5	100	0	1	202	898950	899151	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1490	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16357614	16357614	PRJNA188516_P_NODE_3593_length_179_cov_1.007692_g3543_i0	PRJNA188516	3593	179	1.007692	1.80376868	Fusobacterium	848	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g3543	i0	100	486.033519553073	179	0	100	0	1	179	92858	93036	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	87000	331	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16943070	16943070	PRJNA188516_P_NODE_3714_length_175_cov_2.063492_g3664_i0	PRJNA188516	3714	175	2.063492	3.611111	Cetobacterium somerae	188913	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g3664	i0	100	5	175	0	100	0	1	175	667727	667553	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	875	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16943108	16943108	PRJNA188516_P_NODE_5794_length_163_cov_0.912281_g5744_i0	PRJNA188516	5794	163	0.912281	1.48701803	Cetobacterium somerae	188913	Bacteria	Bacteria	259	7.46e-65	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g5744	i0	95.652	5.71165644171779	161	7	99	0	3	163	534042	533882	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	931	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18217496	18217496	PRJNA188516_P_NODE_3075_length_195_cov_1.068493_g3025_i0	PRJNA188516	3075	195	1.068493	2.08356135	Cetobacterium somerae	188913	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g3025	i0	100	14.2564102564103	195	0	100	0	1	195	1948727	1948533	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2780	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20181259	20181259	PRJNA188516_P_NODE_6236_length_153_cov_3.000000_g6186_i0	PRJNA188516	6236	153	3	4.59	Leptotrichia	32067	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g6186	i0	100	397.091503267974	153	0	100	0	1	153	1994	2146	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	60755	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
20767297	20767297	PRJNA188516_P_NODE_1257_length_331_cov_1.074468_g1207_i0	PRJNA188516	1257	331	1.074468	3.55648908	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	534	2.539999999999999e-147	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g1207	i0	95.77	117.85498489426	331	14	100	0	1	331	51953	51623	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	39010	534	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21456967	21456967	PRJNA188516_P_NODE_5757_length_163_cov_0.912281_g5707_i0	PRJNA188516	5757	163	0.912281	1.48701803	Cetobacterium	180162	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5707	i0	95.092	5	163	8	100	0	1	163	1907399	1907561	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	815	257	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22731955	22731955	PRJNA188516_P_NODE_2678_length_209_cov_1.300000_g2628_i0	PRJNA188516	2678	209	1.3	2.717	Leptotrichia	32067	Bacteria	Bacteria	387	4.42e-103	NTclustered	gi\|631253196\|ref\|NR_114394.1\|	40542	g2628	i0	100	113.803827751196	209	0	100	0	1	209	219	11	Leptotrichia buccalis strain C-1013-b 16S ribosomal RNA, partial sequence	blastn	23785	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
22731964	22731964	PRJNA188516_P_NODE_4818_length_166_cov_0.888889_g4768_i0	PRJNA188516	4818	166	0.888889	1.47555574	Leptotrichia	32067	Bacteria	Bacteria	303	3.48e-78	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g4768	i0	100	19.8012048192771	164	0	99	0	3	166	1969520	1969683	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	3287	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
24592064	24592064	PRJNA188516_P_NODE_3700_length_176_cov_1.007874_g3650_i0	PRJNA188516	3700	176	1.007874	1.77385824	Oceanivirga miroungae	1130046	Bacteria	Bacteria	233	4.94e-57	NTclustered	gi\|1622996169\|gb\|MK828132.1\|	1130046	g3650	i0	90.556	296.806818181818	180	11	100	6	1	176	3465	3288	Oceanivirga miroungae strain ES3154-GLU 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52238	233	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Oceanivirga	Oceanivirga miroungae
24592073	24592073	PRJNA188516_P_NODE_4340_length_168_cov_0.873950_g4290_i0	PRJNA188516	4340	168	0.87395	1.468236	Leptotrichia wadei	157687	Bacteria	Bacteria	278	2.14e-70	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g4290	i0	97.531	551.386904761905	162	4	96	0	7	168	2288458	2288619	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	92633	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
24592077	24592077	PRJNA188516_P_NODE_4580_length_167_cov_0.881356_g4530_i0	PRJNA188516	4580	167	0.881356	1.47186452	Cetobacterium somerae	188913	Bacteria	Bacteria	265	1.65e-66	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4530	i0	95.21	1	167	8	100	0	1	167	1464025	1464191	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	167	265	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25281265	25281265	PRJNA188516_P_NODE_1400_length_309_cov_3.784615_g1350_i0	PRJNA188516	1400	309	3.784615	11.69446035	Cetobacterium	180162	Bacteria	Bacteria	540	5.05e-149	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1350	i0	98.071	5.03236245954693	311	4	100	2	1	309	1561535	1561845	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1555	545	0.990825688073395	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
27895093	27895093	PRJNA188516_P_NODE_5505_length_164_cov_0.904348_g5455_i0	PRJNA188516	5505	164	0.904348	1.48313072	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	105	1.07e-25	NR	WP_294096157.1	527638	g5455	i0	94.3	0.969512195121951	53	3	97	0	3	161	163	215	WP_294096157.1 hypothetical protein [uncultured Cetobacterium sp.]	diamond	159	105	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
28052995	28052995	PRJNA188516_P_NODE_5405_length_164_cov_0.904348_g5355_i0	PRJNA188516	5405	164	0.904348	1.48313072	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	106	1.74e-25	NR	WP_294093648.1	527638	g5355	i0	96.3	0.98780487804878	54	2	98.8	0	1	162	37	90	WP_294093648.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [uncultured Cetobacterium sp.]	diamond	162	106	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
32160552	32160552	PRJNA188516_P_NODE_5498_length_164_cov_0.904348_g5448_i0	PRJNA188516	5498	164	0.904348	1.48313072	Cetobacterium sp. NK	2071632	Bacteria	Bacteria	106	2.57e-28	NR	WP_256690022.1	2993530	g5448	i0	90.6	0.969512195121951	53	5	97	0	3	161	54	106	WP_256690022.1 cell division protein SepF [Cetobacterium sp. NK01]	diamond	159	106	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. NK01
32350411	32350411	PRJNA188516_P_NODE_3739_length_175_cov_0.992063_g3689_i0	PRJNA188516	3739	175	0.992063	1.73611025	unclassified Cetobacterium	2630983	Bacteria	Bacteria	56.6	2.84e-8	NR	WP_047384607.1	2630983	g3689	i0	71.8	0.668571428571429	39	11	66.9	0	157	41	70	108	WP_047384607.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	117	56.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium

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