metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA890871" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA890871" 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
11067951	11067951	PRJNA890871_P_NODE_40249_length_281_cov_3.663462_g40114_i0	PRJNA890871	40249	281	3.663462	10.29432822	Bacteria	2	Bacteria	Bacteria	67.8	8.96e-11	NR	WP_067139988.1	1769291	g40114	i0	46.7	3.75800711743772	90	39	96.1	1	276	7	362	442	WP_067139988.1 DNA repair protein RecN [Oceanivirga salmonicida]	diamond	1056	67.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Oceanivirga	Oceanivirga salmonicida
26746479	26746479	PRJNA890871_P_NODE_22021_length_351_cov_2.046763_g21886_i0	PRJNA890871	22021	351	2.046763	7.18413813	Sebaldella	32068	Bacteria	Bacteria	82	1.65e-15	NR	MBP9479416.1	2819260	g21886	i0	36.3	1.93162393162393	113	72	96.6	0	344	6	134	246	MBP9479416.1 HlyD family secretion protein [Sebaldella sp.]	diamond	678	82	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella sp.
28168814	28168814	PRJNA890871_P_NODE_3425_length_826_cov_5.350598_g3296_i0	PRJNA890871	3425	826	5.350598	44.19593948	Fusobacterium	848	Bacteria	Bacteria	131	2.9899999999999995e-31	NR	WP_300331907.1	68766	g3296	i0	41	4.25665859564165	166	98	60.3	0	1	498	303	468	WP_300331907.1 TolC family protein [Fusobacterium sp.]	diamond	3516	131	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
28192320	28192320	PRJNA890871_P_NODE_32266_length_302_cov_1.790393_g32131_i0	PRJNA890871	32266	302	1.790393	5.40698686	Sebaldella sp.	2819260	Bacteria	Bacteria	47	0.00229	NR	MBP9479416.1	2819260	g32131	i0	31.9	0.685430463576159	69	47	68.5	0	302	96	345	413	MBP9479416.1 HlyD family secretion protein [Sebaldella sp.]	diamond	207	47	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella sp.
28831747	28831747	PRJNA890871_P_NODE_42248_length_278_cov_1.668293_g42113_i0	PRJNA890871	42248	278	1.668293	4.63785454	Bacteria	2	Bacteria	Bacteria	65.1	7.65e-10	NR	WP_304079183.1	157687	g42113	i0	30.2	6.0863309352518	86	60	92.8	0	20	277	144	229	WP_304079183.1 S16 family serine protease [Leptotrichia wadei]	diamond	1692	65.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
29360842	29360842	PRJNA890871_P_NODE_2349_length_1065_cov_3.074597_g2233_i0	PRJNA890871	2349	1065	3.074597	32.74445805	Sebaldella sp. S	2819260	Bacteria	Bacteria	112	1.3e-23	NR	WP_253349086.1	2957809	g2233	i0	31.8	0.549295774647887	195	126	53	2	566	3	3	197	WP_253349086.1 TolC family protein [Sebaldella sp. S0638]	diamond	585	112	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella sp. S0638
32142001	32142001	PRJNA890871_P_NODE_18538_length_376_cov_2.445545_g18403_i0	PRJNA890871	18538	376	2.445545	9.1952492	Fusobacterium periodonticum	860	Bacteria	Bacteria	44.3	0.0436	NR	WP_008820496.1	860	g18403	i0	27.4	0.933510638297872	117	78	89.4	2	337	2	84	198	WP_008820496.1 formylglycine-generating enzyme family protein [Fusobacterium periodonticum]	diamond	351	44.3	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum

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