metadata: contig_metadata: 30 rows where bioproject = "PRJNA473201" and tax

30 rows where bioproject = "PRJNA473201" 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
444209	444209	PRJNA473201_P_NODE_62041_length_261_cov_0.984043_g61299_i0	PRJNA473201	62041	261	0.984043	2.56835223	Cetobacterium somerae	188913	Bacteria	Bacteria	204	6.209999999999999e-48	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g61299	i0	87.293	0.693486590038314	181	20	68	3	84	261	346925	346745	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	181	204	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1095265	1095265	PRJNA473201_P_NODE_73081_length_247_cov_1.327586_g72339_i0	PRJNA473201	73081	247	1.327586	3.27913742	Cetobacterium	180162	Bacteria	Bacteria	351	1.97e-92	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g72339	i0	92.339	19.5263157894737	248	17	100	2	1	247	1903187	1902941	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4823	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2994400	2994400	PRJNA473201_P_NODE_35183_length_335_cov_1.469466_g34441_i0	PRJNA473201	35183	335	1.469466	4.9227111	Cetobacterium somerae	188913	Bacteria	Bacteria	481	3.399999999999999e-131	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g34441	i0	92.537	96.4358208955224	335	25	100	0	1	335	383971	384305	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	32306	481	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3645252	3645252	PRJNA473201_P_NODE_11183_length_604_cov_19.273070_g10448_i0	PRJNA473201	11183	604	19.27307	116.4093428	Cetobacterium	180162	Bacteria	Bacteria	837	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10448	i0	91.626	71.7566225165563	609	45	100	6	1	604	67070	67677	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	43341	837	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4271610	4271610	PRJNA473201_P_NODE_82004_length_243_cov_0.905882_g81262_i0	PRJNA473201	82004	243	0.905882	2.20129326	Cetobacterium somerae	188913	Bacteria	Bacteria	283	7.14e-72	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g81262	i0	87.654	4	243	30	100	0	1	243	996760	996518	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	972	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6198484	6198484	PRJNA473201_P_NODE_79665_length_244_cov_0.900585_g78923_i0	PRJNA473201	79665	244	0.900585	2.1974274	Cetobacterium	180162	Bacteria	Bacteria	302	1.98e-77	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g78923	i0	88.98	4.97131147540984	245	25	100	2	1	244	167827	167584	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1213	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10648244	10648244	PRJNA473201_P_NODE_73609_length_247_cov_0.885057_g72867_i0	PRJNA473201	73609	247	0.885057	2.18609079	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	165	2.4899999999999996e-47	NR	WP_047381888.1	1340502	g72867	i0	98.8	0.983805668016194	81	1	98.4	0	245	3	81	161	WP_047381888.1 ABC transporter substrate-binding protein [Cetobacterium sp. ZWU0022]	diamond	243	165	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
15123195	15123195	PRJNA473201_P_NODE_78372_length_245_cov_0.889535_g77630_i0	PRJNA473201	78372	245	0.889535	2.17936075	Cetobacterium	180162	Bacteria	Bacteria	379	8.929999999999999e-101	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g77630	i0	95.122	150.722448979592	246	2	100	3	1	245	1815192	1814956	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	36927	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16397671	16397671	PRJNA473201_P_NODE_59633_length_267_cov_1.577320_g58891_i0	PRJNA473201	59633	267	1.57732	4.2114444	Cetobacterium	180162	Bacteria	Bacteria	333	7.789999999999999e-87	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g58891	i0	89.179	5.31835205992509	268	27	100	2	1	267	670709	670443	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1420	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17672993	17672993	PRJNA473201_P_NODE_81814_length_243_cov_0.905882_g81072_i0	PRJNA473201	81814	243	0.905882	2.20129326	Cetobacterium	180162	Bacteria	Bacteria	228	3.389999999999999e-55	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g81072	i0	96.377	2.25514403292181	138	5	57	0	106	243	36747	36884	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	548	228	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18294972	18294972	PRJNA473201_P_NODE_15315_length_509_cov_10.816514_g14574_i0	PRJNA473201	15315	509	10.816514	55.05605626	Cetobacterium somerae	188913	Bacteria	Bacteria	894	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g14574	i0	98.428	521.803536345776	509	7	100	1	1	509	1318462	1318969	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	265598	894	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18946456	18946456	PRJNA473201_P_NODE_49875_length_292_cov_1.406393_g49133_i0	PRJNA473201	49875	292	1.406393	4.10666756	Cetobacterium	180162	Bacteria	Bacteria	357	5.12e-94	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g49133	i0	89.437	9.40068493150685	284	28	97	2	9	292	1368853	1369134	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2745	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19569763	19569763	PRJNA473201_P_NODE_53256_length_284_cov_1.094787_g52514_i0	PRJNA473201	53256	284	1.094787	3.10919508	Cetobacterium somerae	188913	Bacteria	Bacteria	459	1.3199999999999998e-124	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g52514	i0	95.789	14.7535211267606	285	11	100	1	1	284	384721	385005	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	4190	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20845068	20845068	PRJNA473201_P_NODE_18257_length_465_cov_0.982143_g17515_i0	PRJNA473201	18257	465	0.982143	4.56696495	unclassified Cetobacterium	2630983	Bacteria	Bacteria	308	7.519999999999998e-103	NR	WP_047382551.1	2630983	g17515	i0	100	0.993548387096774	154	0	99.4	0	2	463	91	244	WP_047382551.1 MULTISPECIES: 3-deoxy-7-phosphoheptulonate synthase [unclassified Cetobacterium]	diamond	462	308	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
20845505	20845505	PRJNA473201_P_NODE_43277_length_309_cov_1.305085_g42535_i0	PRJNA473201	43277	309	1.305085	4.03271265	Cetobacterium somerae	188913	Bacteria	Bacteria	230	1.2399999999999998e-55	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g42535	i0	80.519	4.98381877022654	308	52	99	3	3	309	1161291	1161591	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1540	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21496455	21496455	PRJNA473201_P_NODE_31697_length_351_cov_4.665468_g30955_i0	PRJNA473201	31697	351	4.665468	16.37579268	Cetobacterium	180162	Bacteria	Bacteria	532	9.719999999999999e-147	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g30955	i0	94.286	91.8404558404558	350	17	99	3	1	349	479374	479027	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	32236	532	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22771161	22771161	PRJNA473201_P_NODE_11218_length_603_cov_16.322642_g10483_i0	PRJNA473201	11218	603	16.322642	98.42553126	Cetobacterium	180162	Bacteria	Bacteria	765	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g10483	i0	90.783	79.0762852404643	575	50	95	3	1	575	1561234	1561805	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	47683	765	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22772052	22772052	PRJNA473201_P_NODE_55598_length_278_cov_1.126829_g54856_i0	PRJNA473201	55598	278	1.126829	3.13258462	Cetobacterium	180162	Bacteria	Bacteria	464	2.77e-126	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g54856	i0	96.774	19.0179856115108	279	8	100	1	1	278	480649	480371	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5287	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24046912	24046912	PRJNA473201_P_NODE_52499_length_286_cov_1.079812_g51757_i0	PRJNA473201	52499	286	1.079812	3.08826232	Cetobacterium	180162	Bacteria	Bacteria	390	4.929999999999999e-104	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g51757	i0	91.259	99.8006993006993	286	25	100	0	1	286	346087	346372	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	28543	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24670036	24670036	PRJNA473201_P_NODE_45020_length_304_cov_1.333333_g44278_i0	PRJNA473201	45020	304	1.333333	4.05333232	Cetobacterium somerae	188913	Bacteria	Bacteria	368	2.48e-97	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g44278	i0	88.525	70.8717105263158	305	33	100	2	1	304	1086662	1086965	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	21545	368	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25320990	25320990	PRJNA473201_P_NODE_37540_length_326_cov_0.992095_g36798_i0	PRJNA473201	37540	326	0.992095	3.2342297	Cetobacterium	180162	Bacteria	Bacteria	536	6.939999999999997e-148	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g36798	i0	96.341	10.1748466257669	328	8	100	3	1	326	1523311	1523636	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3317	536	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26823144	26823144	PRJNA473201_P_NODE_71301_length_248_cov_1.257143_g70559_i0	PRJNA473201	71301	248	1.257143	3.11771464	unclassified Cetobacterium	2630983	Bacteria	Bacteria	159	1.26e-43	NR	WP_047384178.1	2630983	g70559	i0	97.6	0.991935483870968	82	2	99.2	0	248	3	409	490	WP_047384178.1 MULTISPECIES: elongation factor G [unclassified Cetobacterium]	diamond	246	159	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
27107587	27107587	PRJNA473201_P_NODE_55882_length_277_cov_1.509804_g55140_i0	PRJNA473201	55882	277	1.509804	4.18215708	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	180	3.7e-53	NR	WP_294095619.1	527638	g55140	i0	100	0.985559566787004	91	0	98.6	0	3	275	102	192	WP_294095619.1 ROK family protein [uncultured Cetobacterium sp.]	diamond	273	180	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
27138995	27138995	PRJNA473201_P_NODE_58462_length_270_cov_1.563452_g57720_i0	PRJNA473201	58462	270	1.563452	4.2213204	unclassified Cetobacterium	2630983	Bacteria	Bacteria	134	1.35e-38	NR	WP_047383608.1	2630983	g57720	i0	100	0.788888888888889	71	0	78.9	0	215	3	1	71	WP_047383608.1 MULTISPECIES: desulfoferrodoxin family protein [unclassified Cetobacterium]	diamond	213	134	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29507625	29507625	PRJNA473201_P_NODE_40710_length_314_cov_1.261411_g39968_i0	PRJNA473201	40710	314	1.261411	3.96083054	Cetobacterium sp. 8H	2759681	Bacteria	Bacteria	120	5.7e-29	NR	WP_304488674.1	2759681	g39968	i0	73.9	0.878980891719745	92	24	87.9	0	312	37	629	720	WP_304488674.1 ATP-dependent zinc metalloprotease FtsH [Cetobacterium sp. 8H]	diamond	276	120	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. 8H
30250565	30250565	PRJNA473201_P_NODE_84312_length_241_cov_1.773810_g83570_i0	PRJNA473201	84312	241	1.77381	4.2748821	Fusobacterium	848	Bacteria	Bacteria	50.8	5.03e-5	NR	WP_032834147.1	848	g83570	i0	52.9	1.9045643153527	51	20	58.5	2	239	99	1083	1133	WP_032834147.1 MULTISPECIES: hypothetical protein [Fusobacterium]	diamond	459	50.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium
30865987	30865987	PRJNA473201_P_NODE_74834_length_246_cov_2.115607_g74092_i0	PRJNA473201	74834	246	2.115607	5.20439322	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	170	6.94e-50	NR	WP_294093214.1	527638	g74092	i0	98.8	0.98780487804878	81	1	98.8	0	244	2	205	285	WP_294093214.1 alanine racemase [uncultured Cetobacterium sp.]	diamond	243	170	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
31292996	31292996	PRJNA473201_P_NODE_86075_length_241_cov_0.892857_g85333_i0	PRJNA473201	86075	241	0.892857	2.15178537	Cetobacterium	180162	Bacteria	Bacteria	156	3.71e-45	NR	MEG0514211.1	2071632	g85333	i0	95	1.99170124481328	80	4	99.6	0	240	1	100	179	MEG0514211.1 signal recognition particle receptor subunit alpha [Cetobacterium sp.]	diamond	480	157	0.993630573248408	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp.
32495359	32495359	PRJNA473201_P_NODE_70439_length_249_cov_0.875000_g69697_i0	PRJNA473201	70439	249	0.875	2.17875	Cetobacterium	180162	Bacteria	Bacteria	48.9	1.47e-4	NR	WP_294096023.1	527638	g69697	i0	95.5	0.530120481927711	22	1	26.5	0	2	67	167	188	WP_294096023.1 RNA-guided endonuclease InsQ/TnpB family protein, partial [uncultured Cetobacterium sp.]	diamond	132	48.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
32794075	32794075	PRJNA473201_P_NODE_30000_length_361_cov_1.034722_g29258_i0	PRJNA473201	30000	361	1.034722	3.73534642	Cetobacterium somerae	188913	Bacteria	Bacteria	142	1.82e-36	NR	WP_281700265.1	188913	g29258	i0	74.2	0.997229916897507	120	31	99.7	0	361	2	4	123	WP_281700265.1 ATP-dependent zinc metalloprotease FtsH [Cetobacterium somerae]	diamond	360	142	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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