metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA534016" 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
1782820	1782820	PRJNA534016_P_NODE_14602_length_249_cov_0.875000_g14512_i0	PRJNA534016	14602	249	0.875	2.17875	Cetobacterium	180162	Bacteria	Bacteria	158	1.47e-47	NR	WP_294094361.1	527638	g14512	i0	100	1.97590361445783	82	0	98.8	0	248	3	26	107	WP_294094361.1 peptide deformylase [uncultured Cetobacterium sp.]	diamond	492	158	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
11986214	11986214	PRJNA534016_P_NODE_16090_length_246_cov_0.890173_g16000_i0	PRJNA534016	16090	246	0.890173	2.18982558	unclassified Cetobacterium	2630983	Bacteria	Bacteria	164	4.789999999999999e-48	NR	WP_047381440.1	2630983	g16000	i0	97.6	1	82	2	100	0	246	1	162	243	WP_047381440.1 MULTISPECIES: ribosome biogenesis GTPase YlqF [unclassified Cetobacterium]	diamond	246	164	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
24070277	24070277	PRJNA534016_P_NODE_8879_length_288_cov_1.372093_g8789_i0	PRJNA534016	8879	288	1.372093	3.95162784	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	169	5.35e-49	NR	WP_294095466.1	527638	g8789	i0	100	1	96	0	100	0	288	1	10	105	WP_294095466.1 M23 family metallopeptidase [uncultured Cetobacterium sp.]	diamond	288	169	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
24733549	24733549	PRJNA534016_P_NODE_8680_length_290_cov_1.023041_g8590_i0	PRJNA534016	8680	290	1.023041	2.9668189	unclassified Cetobacterium	2630983	Bacteria	Bacteria	182	8.51e-51	NR	WP_047384483.1	2630983	g8590	i0	93.7	1.96551724137931	95	6	98.3	0	2	286	1058	1152	WP_047384483.1 MULTISPECIES: phosphoribosylformylglycinamidine synthase [unclassified Cetobacterium]	diamond	570	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
26729193	26729193	PRJNA534016_P_NODE_5241_length_362_cov_1.726644_g5151_i0	PRJNA534016	5241	362	1.726644	6.25045128	unclassified Cetobacterium	2630983	Bacteria	Bacteria	234	4.889999999999999e-73	NR	WP_047382405.1	2630983	g5151	i0	99.2	1.98895027624309	120	1	99.4	0	361	2	55	174	WP_047382405.1 MULTISPECIES: signal recognition particle protein [unclassified Cetobacterium]	diamond	720	234	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
26824786	26824786	PRJNA534016_P_NODE_16301_length_245_cov_1.558140_g16211_i0	PRJNA534016	16301	245	1.55814	3.817443	unclassified Cetobacterium	2630983	Bacteria	Bacteria	157	4.650000000000001e-44	NR	WP_047380648.1	2630983	g16211	i0	97.5	1.98367346938776	81	2	99.2	0	244	2	227	307	WP_047380648.1 MULTISPECIES: hemolysin family protein [unclassified Cetobacterium]	diamond	486	157	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
26919663	26919663	PRJNA534016_P_NODE_8082_length_298_cov_2.706667_g7992_i0	PRJNA534016	8082	298	2.706667	8.06586766	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	174	3.36e-52	NR	WP_047383522.1	1340502	g7992	i0	86	1.00671140939597	100	12	98.7	1	3	296	38	137	WP_047383522.1 hypothetical protein [Cetobacterium sp. ZWU0022]	diamond	300	174	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
27014469	27014469	PRJNA534016_P_NODE_8762_length_289_cov_1.277778_g8672_i0	PRJNA534016	8762	289	1.277778	3.69277842	Cetobacterium sp. NK	2071632	Bacteria	Bacteria	92.4	2.5200000000000004e-21	NR	WP_256692265.1	2993530	g8672	i0	59.8	1.71280276816609	82	31	83	1	3	242	80	161	WP_256692265.1 hypothetical protein [Cetobacterium sp. NK01]	diamond	495	92.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. NK01
27409048	27409048	PRJNA534016_P_NODE_19103_length_227_cov_3.266234_g19013_i0	PRJNA534016	19103	227	3.266234	7.41435118	Cetobacterium	180162	Bacteria	Bacteria	103	1.1699999999999997e-23	NR	WP_240220714.1	188913	g19013	i0	66.7	5.94713656387665	75	22	99.1	1	2	226	495	566	WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae]	diamond	1350	104	0.990384615384615	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
27488651	27488651	PRJNA534016_P_NODE_8363_length_293_cov_2.104545_g8273_i0	PRJNA534016	8363	293	2.104545	6.16631685	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	159	1.95e-45	NR	WP_052193996.1	1339239	g8273	i0	95.1	1.65870307167235	81	4	82.9	0	292	50	268	348	WP_052193996.1 ParA family protein, partial [Cetobacterium sp. ZOR0034]	diamond	486	159	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
27583209	27583209	PRJNA534016_P_NODE_11244_length_269_cov_1.571429_g11154_i0	PRJNA534016	11244	269	1.571429	4.22714401	Cetobacterium	180162	Bacteria	Bacteria	154	1.1e-43	NR	WP_185891031.1	180162	g11154	i0	89.9	0.992565055762082	89	9	99.3	0	3	269	193	281	WP_185891031.1 MULTISPECIES: tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Cetobacterium]	diamond	267	154	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
27930633	27930633	PRJNA534016_P_NODE_14525_length_249_cov_1.397727_g14435_i0	PRJNA534016	14525	249	1.397727	3.48034023	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	162	7.39e-48	NR	WP_047396337.1	1339239	g14435	i0	94	1	83	5	100	0	1	249	53	135	WP_047396337.1 family 1 encapsulin nanocompartment shell protein [Cetobacterium sp. ZOR0034]	diamond	249	162	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
28151841	28151841	PRJNA534016_P_NODE_19045_length_229_cov_2.301282_g18955_i0	PRJNA534016	19045	229	2.301282	5.26993578	Cetobacterium	180162	Bacteria	Bacteria	85.5	2.91e-18	NR	WP_023049644.1	180162	g18955	i0	93.2	1.74235807860262	44	3	57.6	0	1	132	190	233	WP_023049644.1 MULTISPECIES: ParA family protein [Cetobacterium]	diamond	399	85.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
28246157	28246157	PRJNA534016_P_NODE_15046_length_248_cov_0.880000_g14956_i0	PRJNA534016	15046	248	0.88	2.1824	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	154	2.34e-44	NR	WP_294092899.1	527638	g14956	i0	100	0.991935483870968	82	0	99.2	0	2	247	129	210	WP_294092899.1 sigma-70 family RNA polymerase sigma factor [uncultured Cetobacterium sp.]	diamond	246	154	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
28593800	28593800	PRJNA534016_P_NODE_6907_length_321_cov_2.338710_g6817_i0	PRJNA534016	6907	321	2.33871	7.5072591	Propionigenium maris	45622	Bacteria	Bacteria	88.6	7.57e-18	NR	WP_281833196.1	45622	g6817	i0	60.3	1.27102803738318	68	23	63.6	1	114	317	532	595	WP_281833196.1 glycosyl hydrolase family 18 protein [Propionigenium maris]	diamond	408	88.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Propionigenium	Propionigenium maris
29113879	29113879	PRJNA534016_P_NODE_508_length_1134_cov_3.500471_g452_i0	PRJNA534016	508	1134	3.500471	39.69534114	Cetobacterium	180162	Bacteria	Bacteria	423	1.06e-138	NR	WP_240220714.1	188913	g452	i0	64.5	4.12962962962963	313	106	82.8	3	19	957	449	756	WP_240220714.1 glycosyl hydrolase family 18 protein [Cetobacterium somerae]	diamond	4683	423	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
29130601	29130601	PRJNA534016_P_NODE_15309_length_248_cov_0.862857_g15219_i0	PRJNA534016	15309	248	0.862857	2.13988536	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	157	2.59e-45	NR	WP_294094075.1	527638	g15219	i0	98.8	0.991935483870968	82	1	99.2	0	248	3	2	83	WP_294094075.1 cobalt-precorrin 5A hydrolase [uncultured Cetobacterium sp.]	diamond	246	157	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
29288206	29288206	PRJNA534016_P_NODE_7049_length_318_cov_2.114286_g6959_i0	PRJNA534016	7049	318	2.114286	6.72342948	Candidatus Cetobacterium colombiensis	3073100	Bacteria	Bacteria	84.3	2.3e-16	NR	WP_320312577.1	3073100	g6959	i0	41.3	5.80188679245283	104	57	98.1	2	312	1	536	635	WP_320312577.1 glycosyl hydrolase family 18 protein [Candidatus Cetobacterium colombiensis]	diamond	1845	84.3	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Candidatus Cetobacterium colombiensis
29383102	29383102	PRJNA534016_P_NODE_17029_length_244_cov_0.900585_g16939_i0	PRJNA534016	17029	244	0.900585	2.1974274	unclassified Cetobacterium	2630983	Bacteria	Bacteria	152	6.12e-44	NR	WP_231549787.1	2630983	g16939	i0	93.8	0.983606557377049	80	5	98.4	0	242	3	159	238	WP_231549787.1 MULTISPECIES: Gfo/Idh/MocA family protein [unclassified Cetobacterium]	diamond	240	152	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29572330	29572330	PRJNA534016_P_NODE_10650_length_274_cov_1.303483_g10560_i0	PRJNA534016	10650	274	1.303483	3.57154342	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	83.2	3.28e-16	NR	WP_297599059.1	527638	g10560	i0	54.7	0.700729927007299	64	29	70.1	0	274	83	692	755	WP_297599059.1 glycosyl hydrolase family 18 protein [uncultured Cetobacterium sp.]	diamond	192	83.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
29572335	29572335	PRJNA534016_P_NODE_13630_length_251_cov_0.865169_g13540_i0	PRJNA534016	13630	251	0.865169	2.17157419	Cetobacterium	180162	Bacteria	Bacteria	138	4.34e-38	NR	WP_240219512.1	180162	g13540	i0	83.1	0.99203187250996006	83	14	99.2	0	1	249	92	174	WP_240219512.1 MULTISPECIES: D-alanine--D-alanine ligase [Cetobacterium]	diamond	249	138	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29635248	29635248	PRJNA534016_P_NODE_11790_length_265_cov_1.343750_g11700_i0	PRJNA534016	11790	265	1.34375	3.5609375	unclassified Cetobacterium	2630983	Bacteria	Bacteria	132	1.4099999999999998e-37	NR	WP_047381377.1	2630983	g11700	i0	91.7	0.815094339622642	72	6	81.5	0	265	50	59	130	WP_047381377.1 MULTISPECIES: hypothetical protein [unclassified Cetobacterium]	diamond	216	132	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29635254	29635254	PRJNA534016_P_NODE_16790_length_244_cov_1.350877_g16700_i0	PRJNA534016	16790	244	1.350877	3.29613988	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	148	5.33e-40	NR	WP_047393897.1	1339239	g16700	i0	88.8	0.983606557377049	80	9	98.4	0	3	242	258	337	WP_047393897.1 S1 RNA-binding domain-containing protein [Cetobacterium sp. ZOR0034]	diamond	240	148	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
30773044	30773044	PRJNA534016_P_NODE_5514_length_355_cov_1.085106_g5424_i0	PRJNA534016	5514	355	1.085106	3.8521263	unclassified Cetobacterium	2630983	Bacteria	Bacteria	212	2.51e-67	NR	WP_047384858.1	2630983	g5424	i0	95.8	0.997183098591549	118	2	99.7	1	2	355	14	128	WP_047384858.1 MULTISPECIES: GntR family transcriptional regulator [unclassified Cetobacterium]	diamond	354	212	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
31246825	31246825	PRJNA534016_P_NODE_11355_length_268_cov_1.733333_g11265_i0	PRJNA534016	11355	268	1.733333	4.64533244	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	185	2.1499999999999997e-55	NR	WP_293723785.1	527638	g11265	i0	96.6	0.996268656716418	89	3	99.6	0	268	2	4	92	WP_293723785.1 MalY/PatB family protein [uncultured Cetobacterium sp.]	diamond	267	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
31657834	31657834	PRJNA534016_P_NODE_16897_length_244_cov_0.900585_g16807_i0	PRJNA534016	16897	244	0.900585	2.1974274	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	144	2.1099999999999998e-38	NR	WP_047393897.1	1339239	g16807	i0	93.8	1.99180327868852	81	5	99.6	0	244	2	451	531	WP_047393897.1 S1 RNA-binding domain-containing protein [Cetobacterium sp. ZOR0034]	diamond	486	144	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
32795666	32795666	PRJNA534016_P_NODE_11900_length_264_cov_1.612565_g11810_i0	PRJNA534016	11900	264	1.612565	4.2571716	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	127	2.3e-35	NR	WP_047380419.1	1340502	g11810	i0	75.9	0.988636363636364	87	21	98.9	0	3	263	55	141	WP_047380419.1 hypothetical protein [Cetobacterium sp. ZWU0022]	diamond	261	127	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022

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