metadata: contig_metadata: 13 rows where bioproject = "PRJNA890871" and tax

13 rows where 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
4693480	4693480	PRJNA890871_P_NODE_70284_length_248_cov_0.880000_g70149_i0	PRJNA890871	70284	248	0.88	2.1824	Leptotrichia sp. oral taxon 847	1785996	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|987458696\|gb\|CP014231.1\|	1785996	g70149	i0	98.79	7.85483870967742	248	3	100	0	1	248	933963	933716	Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome	blastn	1948	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 847
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
15270271	15270271	PRJNA890871_P_NODE_2572_length_1000_cov_4.993528_g2453_i0	PRJNA890871	2572	1000	4.993528	49.93528	Fusobacterium	848	Bacteria	Bacteria	54.7	0.028	NTclustered	gi\|2705015041\|gb\|CP084068.1\|	856	g2453	i0	100	0.087	29	0	3	0	362	390	1799294	1799322	Fusobacterium varium strain SB064 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
16167658	16167658	PRJNA890871_P_NODE_64433_length_250_cov_1.768362_g64298_i0	PRJNA890871	64433	250	1.768362	4.420905	Leptotrichia wadei	157687	Bacteria	Bacteria	387	5.459999999999998e-103	NTclustered	gi\|1791353085\|dbj\|AP019829.2\|	157687	g64298	i0	96.186	13.14	236	9	94	0	1	236	2015573	2015338	Leptotrichia wadei JCM16777 DNA, complete genome	blastn	3285	387	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
21266685	21266685	PRJNA890871_P_NODE_51897_length_264_cov_1.549738_g51762_i0	PRJNA890871	51897	264	1.549738	4.0913083200000004	Cetobacterium somerae	188913	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2666490969\|gb\|CP143322.1\|	188913	g51762	i0	100	0.106060606060606	28	0	11	0	169	196	4188	4215	Cetobacterium somerae strain ceto plasmid p3, complete sequence	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21267447	21267447	PRJNA890871_P_NODE_93737_length_205_cov_4.128788_g93602_i0	PRJNA890871	93737	205	4.128788	8.4640154	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	351	1.58e-92	NTclustered	gi\|1276712381\|gb\|CP024701.1\|	2663009	g93602	i0	97.561	1	205	5	100	0	1	205	160785	160581	Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome	blastn	205	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
21644814	21644814	PRJNA890871_P_NODE_65677_length_250_cov_0.870056_g65542_i0	PRJNA890871	65677	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	462	8.83e-126	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g65542	i0	100	50.384	250	0	100	0	1	250	2402229	2402478	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	12596	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
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);;