metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA670521" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA670521" 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	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
638539	638539	PRJNA670521_P_NODE_90741_length_242_cov_0.911243_g89996_i0	PRJNA670521	90741	242	0.911243	2.20520806	unclassified Cetobacterium	2630983	Bacteria	Bacteria	169	6.68e-48	NR	WP_047384129.1	2630983	g89996	i0	100	0.991735537190083	80	0	99.2	241	2	81	160	WP_047384129.1 MULTISPECIES: ribulokinase [unclassified Cetobacterium]	diamond	240	169	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
1164957	1164957	PRJNA670521_P_NODE_88121_length_243_cov_0.905882_g87376_i0	PRJNA670521	88121	243	0.905882	2.20129326	unclassified Cetobacterium	2630983	Bacteria	Bacteria	170	1.33e-47	NR	WP_047384178.1	2630983	g87376	i0	100	1	81	0	100	1	243	450	530	WP_047384178.1 MULTISPECIES: elongation factor G [unclassified Cetobacterium]	diamond	243	170	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
11368502	11368502	PRJNA670521_P_NODE_76369_length_248_cov_1.680000_g75624_i0	PRJNA670521	76369	248	1.68	4.1664	Cetobacterium sp. NK	2071632	Bacteria	Bacteria	142	2.2e-39	NR	WP_256689791.1	2993530	g75624	i0	95.9	1.79032258064516	74	3	89.5	26	247	73	146	WP_256689791.1 tetraacyldisaccharide 4'-kinase [Cetobacterium sp. NK01]	diamond	444	142	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. NK01
19764972	19764972	PRJNA670521_P_NODE_19316_length_428_cov_0.884507_g18574_i0	PRJNA670521	19316	428	0.884507	3.78568996	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	281	7.619999999999997e-94	NR	WP_047396337.1	1339239	g18574	i0	100	0.995327102803738	142	0	99.5	427	2	1	142	WP_047396337.1 family 1 encapsulin nanocompartment shell protein [Cetobacterium sp. ZOR0034]	diamond	426	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
26796877	26796877	PRJNA670521_P_NODE_29681_length_362_cov_0.961938_g28936_i0	PRJNA670521	29681	362	0.961938	3.48221556	unclassified Cetobacterium	2630983	Bacteria	Bacteria	243	4.26e-80	NR	WP_047381174.1	2630983	g28936	i0	100	0.994475138121547	120	0	99.4	361	2	13	132	WP_047381174.1 MULTISPECIES: recombination mediator RecR [unclassified Cetobacterium]	diamond	360	243	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
26954986	26954986	PRJNA670521_P_NODE_88382_length_243_cov_0.905882_g87637_i0	PRJNA670521	88382	243	0.905882	2.20129326	Cetobacterium sp. ZOR	2071632	Bacteria	Bacteria	160	2.21e-45	NR	WP_047393961.1	1339239	g87637	i0	100	1.97530864197531	80	0	98.8	2	241	63	142	WP_047393961.1 glutamate-1-semialdehyde 2,1-aminomutase [Cetobacterium sp. ZOR0034]	diamond	480	160	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZOR0034
28976603	28976603	PRJNA670521_P_NODE_43988_length_312_cov_0.857741_g43243_i0	PRJNA670521	43988	312	0.857741	2.67615192	unclassified Cetobacterium	2630983	Bacteria	Bacteria	197	2.82e-58	NR	WP_047381478.1	2630983	g43243	i0	99	0.990384615384615	103	1	99	2	310	232	334	WP_047381478.1 MULTISPECIES: ribonuclease Y [unclassified Cetobacterium]	diamond	309	197	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29229258	29229258	PRJNA670521_P_NODE_18609_length_434_cov_1.797784_g17867_i0	PRJNA670521	18609	434	1.797784	7.80238256	unclassified Cetobacterium	2630983	Bacteria	Bacteria	182	1.9899999999999994e-55	NR	WP_047382053.1	2630983	g17867	i0	100	0.594470046082949	86	0	59.4	177	434	38	123	WP_047382053.1 MULTISPECIES: flavodoxin family protein [unclassified Cetobacterium]	diamond	258	182	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29323704	29323704	PRJNA670521_P_NODE_6849_length_676_cov_1.388060_g6138_i0	PRJNA670521	6849	676	1.38806	9.3832856	unclassified Cetobacterium	2630983	Bacteria	Bacteria	227	5.69e-72	NR	WP_052191695.1	2630983	g6138	i0	100	0.501479289940828	113	0	50.1	340	2	1	113	WP_052191695.1 MULTISPECIES: YbhB/YbcL family Raf kinase inhibitor-like protein [unclassified Cetobacterium]	diamond	339	227	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
29986942	29986942	PRJNA670521_P_NODE_79971_length_247_cov_0.885057_g79226_i0	PRJNA670521	79971	247	0.885057	2.18609079	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	171	9.540000000000001e-51	NR	WP_047381330.1	1340502	g79226	i0	100	0.983805668016194	81	0	98.4	245	3	106	186	WP_047381330.1 DNA processing protein DprA [Cetobacterium sp. ZWU0022]	diamond	243	171	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
30587072	30587072	PRJNA670521_P_NODE_83833_length_245_cov_0.895349_g83088_i0	PRJNA670521	83833	245	0.895349	2.19360505	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	157	2.66e-42	NR	WP_047383329.1	1340502	g83088	i0	100	0.991836734693878	81	0	99.2	3	245	4016	4096	WP_047383329.1 DUF11 domain-containing protein [Cetobacterium sp. ZWU0022]	diamond	243	157	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
30903269	30903269	PRJNA670521_P_NODE_72214_length_250_cov_1.271186_g71469_i0	PRJNA670521	72214	250	1.271186	3.177965	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	160	2.97e-44	NR	WP_047381739.1	1340502	g71469	i0	100	0.996	83	0	99.6	249	1	421	503	WP_047381739.1 GTPase HflX [Cetobacterium sp. ZWU0022]	diamond	249	160	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
31029813	31029813	PRJNA670521_P_NODE_68655_length_254_cov_1.276243_g67910_i0	PRJNA670521	68655	254	1.276243	3.24165722	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	166	2.61e-49	NR	WP_294095125.1	527638	g67910	i0	97.6	0.992125984251969	84	2	99.2	254	3	53	136	WP_294095125.1 Rpn family recombination-promoting nuclease/putative transposase [uncultured Cetobacterium sp.]	diamond	252	166	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.
31061394	31061394	PRJNA670521_P_NODE_59035_length_275_cov_1.158416_g58290_i0	PRJNA670521	59035	275	1.158416	3.185644	unclassified Cetobacterium	2630983	Bacteria	Bacteria	179	9.52e-53	NR	WP_081982712.1	2630983	g58290	i0	100	0.992727272727273	91	0	99.3	274	2	20	110	WP_081982712.1 MULTISPECIES: DEAD/DEAH box helicase [unclassified Cetobacterium]	diamond	273	179	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
31325957	31325957	PRJNA670521_P_NODE_79175_length_247_cov_0.885057_g78430_i0	PRJNA670521	79175	247	0.885057	2.18609079	Cetobacterium	180162	Bacteria	Bacteria	149	2.86e-42	NR	WP_023051211.1	180162	g78430	i0	95.1	1.9919028340081	82	4	99.6	2	247	8	89	WP_023051211.1 MULTISPECIES: KpsF/GutQ family sugar-phosphate isomerase [Cetobacterium]	diamond	492	150	0.993333333333333	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
31345750	31345750	PRJNA670521_P_NODE_75076_length_249_cov_0.875000_g74331_i0	PRJNA670521	75076	249	0.875	2.17875	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	162	5.829999999999999e-48	NR	WP_047384186.1	1340502	g74331	i0	100	0.975903614457831	81	0	97.6	2	244	71	151	WP_047384186.1 TrmH family RNA methyltransferase [Cetobacterium sp. ZWU0022]	diamond	243	162	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
31978239	31978239	PRJNA670521_P_NODE_81438_length_246_cov_0.890173_g80693_i0	PRJNA670521	81438	246	0.890173	2.18982558	Cetobacterium sp. ZWU	2071632	Bacteria	Bacteria	152	3.42e-41	NR	WP_047384298.1	1340502	g80693	i0	100	1	82	0	100	246	1	195	276	WP_047384298.1 peptidylprolyl isomerase [Cetobacterium sp. ZWU0022]	diamond	246	152	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium sp. ZWU0022
32073216	32073216	PRJNA670521_P_NODE_13838_length_491_cov_1.899522_g13099_i0	PRJNA670521	13838	491	1.899522	9.32665302	unclassified Cetobacterium	2630983	Bacteria	Bacteria	249	7.2e-83	NR	WP_047383608.1	2630983	g13099	i0	100	0.745417515274949	122	0	74.5	379	14	1	122	WP_047383608.1 MULTISPECIES: desulfoferrodoxin family protein [unclassified Cetobacterium]	diamond	366	249	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);;