metadata: contig_metadata: 9 rows where bioproject = "PRJNA666695" and tax

9 rows where bioproject = "PRJNA666695" 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
1909416	1909416	PRJNA666695_S_NODE_78822_length_244_cov_3.625616_g77728_i0	PRJNA666695	78822	244	3.625616	8.84650304	Haliovirga abyssi	2996794	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2502752323\|dbj\|AP027059.1\|	2996794	g77728	i0	96.875	0.131147540983607	32	1	13	0	163	194	937381	937412	Fusobacteria bacterium IC12 DNA, complete genome	blastn	32	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Haliovirgaceae	Haliovirga	Haliovirga abyssi
3182989	3182989	PRJNA666695_S_NODE_28483_length_363_cov_5.736025_g27390_i0	PRJNA666695	28483	363	5.736025	20.82177075	Fusobacterium animalis	76859	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|2706431087\|gb\|CP077150.1\|	76859	g27390	i0	100	0.154269972451791	28	0	8	0	311	338	1681324	1681351	Fusobacterium animalis strain KCOM1280 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
3183753	3183753	PRJNA666695_S_NODE_59143_length_275_cov_1.713675_g58049_i0	PRJNA666695	59143	275	1.713675	4.71260625	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	100	5.52e-24	NR	MBP6408540.1	2053555	g58049	i0	55.4	1.00363636363636	92	39	99.3	2	1	273	61	151	MBP6408540.1 FAD-dependent oxidoreductase [Fusobacteriaceae bacterium]	diamond	276	100	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
5736387	5736387	PRJNA666695_S_NODE_65085_length_264_cov_4.125561_g63991_i0	PRJNA666695	65085	264	4.125561	10.89148104	Leptotrichia wadei	157687	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g63991	i0	100	291.94696969697	264	0	100	0	1	264	221664	221927	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	77074	488	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15191044	15191044	PRJNA666695_S_NODE_123132_length_198_cov_1.757962_g122038_i0	PRJNA666695	123132	198	1.757962	3.48076476	PVC group	1783257	Bacteria	Bacteria	81.3	5.4e-16	NR	MBN1469985.1	2053555	g122038	i0	61.2	7.04545454545455	67	21	93.9	2	196	11	659	725	MBN1469985.1 FAD-dependent oxidoreductase [Fusobacteriaceae bacterium]	diamond	1395	81.6	0.996323529411765	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
27176133	27176133	PRJNA666695_S_NODE_172322_length_163_cov_1.885246_g171228_i0	PRJNA666695	172322	163	1.885246	3.07295098	Psychrilyobacter atlanticus	271091	Bacteria	Bacteria	41.2	0.0454	NR	WP_028856124.1	271091	g171228	i0	48.6	0.680981595092024	37	19	68.1	0	43	153	3	39	WP_028856124.1 aminopeptidase P family protein [Psychrilyobacter atlanticus]	diamond	111	41.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Psychrilyobacter	Psychrilyobacter atlanticus
28344854	28344854	PRJNA666695_S_NODE_97766_length_222_cov_2.033149_g96672_i0	PRJNA666695	97766	222	2.033149	4.51359078	Leptotrichia sp. HSP-536	3239304	Bacteria	Bacteria	48.5	1.93e-4	NR	WP_369715184.1	3239304	g96672	i0	56.8	1.18918918918919	44	18	59.5	1	88	219	154	196	WP_369715184.1 ankyrin repeat domain-containing protein [Leptotrichia sp. HSP-536]	diamond	264	48.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
29828702	29828702	PRJNA666695_S_NODE_137651_length_186_cov_3.489655_g136557_i0	PRJNA666695	137651	186	3.489655	6.4907583	Fusobacteriia bacterium 4572_132	1971640	Bacteria	Bacteria	75.1	6.69e-14	NR	OQY09105.1	1971640	g136557	i0	60.3	4.82258064516129	58	23	93.5	0	11	184	586	643	OQY09105.1 MAG: hypothetical protein B6I28_03625 [Fusobacteriia bacterium 4572_132]	diamond	897	75.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia				Fusobacteriia bacterium 4572_132
30492343	30492343	PRJNA666695_S_NODE_3693_length_827_cov_8.005089_g2996_i0	PRJNA666695	3693	827	8.005089	66.20208603	Psychrilyobacter sp.	2586924	Bacteria	Bacteria	267	2.75e-80	NR	WP_336887880.1	2586924	g2996	i0	48.9	2.94558645707376	276	131	99.4	4	823	2	287	554	WP_336887880.1 nucleoside hydrolase [Psychrilyobacter sp.]	diamond	2436	267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Psychrilyobacter	Psychrilyobacter sp.

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