metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA879067" 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
3407057	3407057	PRJNA879067_P_NODE_84443_length_320_cov_3.016194_g80957_i0	PRJNA879067	84443	320	3.016194	9.6518208	Fusobacterium	848	Bacteria	Bacteria	88.2	2.39e-18	NR	WP_316090402.1	68766	g80957	i0	72.4	1.63125	58	16	54.4	0	294	121	241	298	WP_316090402.1 ABC transporter substrate-binding protein [Fusobacterium sp.]	diamond	522	88.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
7232226	7232226	PRJNA879067_P_NODE_13666_length_1296_cov_3.291087_g11161_i0	PRJNA879067	13666	1296	3.291087	42.65248752	Fusobacterium	848	Bacteria	Bacteria	800	3.6499999999999993e-289	NR	WP_235244229.1	848	g11161	i0	97.4	0.997685185185185	431	11	99.8	0	4	1296	1	431	WP_235244229.1 MULTISPECIES: LytS/YhcK type 5TM receptor domain-containing protein [Fusobacterium]	diamond	1293	800	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium
16157192	16157192	PRJNA879067_P_NODE_25773_length_850_cov_6.415701_g22571_i0	PRJNA879067	25773	850	6.415701	54.5334585	Fusobacterium polymorphum	76857	Bacteria	Bacteria	341	1.65e-113	NR	WP_336015340.1	76857	g22571	i0	85.1	0.709411764705882	201	30	70.9	0	248	850	1	201	WP_336015340.1 hypothetical protein [Fusobacterium polymorphum]	diamond	603	341	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
18706804	18706804	PRJNA879067_P_NODE_53055_length_500_cov_2.320843_g49571_i0	PRJNA879067	53055	500	2.320843	11.604215	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	306	1.18e-100	NR	MBP6408967.1	2053555	g49571	i0	100	0.942	157	0	94.2	0	472	2	99	255	MBP6408967.1 TolC family protein [Fusobacteriaceae bacterium]	diamond	471	306	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
22531948	22531948	PRJNA879067_P_NODE_47118_length_550_cov_2.561845_g43645_i0	PRJNA879067	47118	550	2.561845	14.0901475	Cetobacterium somerae	188913	Bacteria	Bacteria	119	1.49e-28	NR	WP_330112627.1	188913	g43645	i0	44.4	0.981818181818182	180	94	96	3	10	537	127	304	WP_330112627.1 GIY-YIG nuclease family protein [Cetobacterium somerae]	diamond	540	119	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
26897226	26897226	PRJNA879067_P_NODE_110301_length_242_cov_0.911243_g106815_i0	PRJNA879067	110301	242	0.911243	2.20520806	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	124	5.419999999999999e-31	NR	WP_053393422.1	712357	g106815	i0	88.6	0.867768595041322	70	8	86.8	0	210	1	942	1011	WP_053393422.1 alpha-amylase family glycosyl hydrolase [Leptotrichia sp. oral taxon 212]	diamond	210	124	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
26928744	26928744	PRJNA879067_P_NODE_41042_length_611_cov_3.401487_g37590_i0	PRJNA879067	41042	611	3.401487	20.78308557	Fusobacterium sp.	68766	Bacteria	Bacteria	285	8.939999999999997e-94	NR	MFR3298607.1	68766	g37590	i0	64.8	2.93126022913257	199	68	97.2	2	602	9	69	266	MFR3298607.1 cobyrinate a,c-diamide synthase [Fusobacterium sp.]	diamond	1791	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
26999844	26999844	PRJNA879067_P_NODE_41322_length_607_cov_25.453184_g37870_i0	PRJNA879067	41322	607	25.453184	154.50082688	Fusobacterium	848	Bacteria	Bacteria	184	6.17e-50	NR	WP_291281889.1	68766	g37870	i0	54.3	3.87479406919275	199	91	98.4	0	598	2	656	854	WP_291281889.1 filamentous hemagglutinin N-terminal domain-containing protein, partial [Fusobacterium sp.]	diamond	2352	184	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
27655743	27655743	PRJNA879067_P_NODE_93404_length_286_cov_1.281690_g89918_i0	PRJNA879067	93404	286	1.28169	3.6656334	Fusobacterium perfoetens	852	Bacteria	Bacteria	86.7	1.38e-18	NR	WP_235235498.1	852	g89918	i0	92.9	0.440559440559441	42	3	44.1	0	2	127	169	210	WP_235235498.1 O-methyltransferase [Fusobacterium perfoetens]	diamond	126	86.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
28160890	28160890	PRJNA879067_P_NODE_32385_length_725_cov_1.369632_g29031_i0	PRJNA879067	32385	725	1.369632	9.929832	unclassified Cetobacterium	2630983	Bacteria	Bacteria	439	3.52e-154	NR	WP_197053374.1	2630983	g29031	i0	100	0.964137931034483	233	0	96.4	0	701	3	42	274	WP_197053374.1 MULTISPECIES: hydroxyethylthiazole kinase [unclassified Cetobacterium]	diamond	699	439	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium
28263290	28263290	PRJNA879067_P_NODE_81926_length_331_cov_1.193798_g78440_i0	PRJNA879067	81926	331	1.193798	3.95147138	Fusobacterium	848	Bacteria	Bacteria	202	9.55e-59	NR	WP_235235894.1	852	g78440	i0	90.9	3.98791540785498	110	10	99.7	0	330	1	29	138	WP_235235894.1 ferrous iron transport protein B [Fusobacterium perfoetens]	diamond	1320	203	0.995073891625616	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
29739123	29739123	PRJNA879067_P_NODE_30430_length_757_cov_5.505848_g27115_i0	PRJNA879067	30430	757	5.505848	41.67926936	Fusobacterium sp.	68766	Bacteria	Bacteria	508	1.0899999999999993e-168	NR	WP_294653854.1	68766	g27115	i0	100	1.87846763540291	237	0	93.9	0	726	16	922	1158	WP_294653854.1 autotransporter outer membrane beta-barrel domain-containing protein [Fusobacterium sp.]	diamond	1422	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
31359005	31359005	PRJNA879067_P_NODE_98796_length_267_cov_1.211340_g95310_i0	PRJNA879067	98796	267	1.21134	3.2342778	Fusobacterium	848	Bacteria	Bacteria	107	3.34e-27	NR	MCF2612674.1	852	g95310	i0	98.2	1.23595505617978	55	1	61.8	0	165	1	1	55	MCF2612674.1 transposase [Fusobacterium perfoetens]	diamond	330	107	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
32458244	32458244	PRJNA879067_P_NODE_60999_length_443_cov_1.664865_g57514_i0	PRJNA879067	60999	443	1.664865	7.37535195	Fusobacterium	848	Bacteria	Bacteria	266	5.59e-85	NR	WP_170186764.1	848	g57514	i0	89.1	0.99548532731377	147	16	99.5	0	3	443	306	452	WP_170186764.1 MULTISPECIES: YfcC family protein [Fusobacterium]	diamond	441	266	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium

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