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

7 rows where analysis = "diamond", bioproject = "PRJNA940501" 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
29393686	29393686	PRJNA940501_S_NODE_142669_length_215_cov_1.093023_g141851_i0	PRJNA940501	142669	215	1.093023	2.34999945	Psychrilyobacter	623282	Bacteria	Bacteria	126	1.59e-34	NR	WP_114641174.1	623282	g141851	i0	94.1	0.948837209302326	68	4	94.9	0	213	10	131	198	WP_114641174.1 MULTISPECIES: 3-oxoacid CoA-transferase subunit B [Psychrilyobacter]	diamond	204	126	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Psychrilyobacter
29526855	29526855	PRJNA940501_S_NODE_272550_length_173_cov_1.769231_g271732_i0	PRJNA940501	272550	173	1.769231	3.06076963	root	1	Root_unresolved	Root_unresolved	43.9	0.00154	NR	WP_187105689.1	859	g271732	i0	66.7	6.69364161849711	33	11	57.2	0	3	101	64	96	WP_187105689.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	1158	43.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
29779346	29779346	PRJNA940501_S_NODE_11571_length_440_cov_3.350126_g10765_i0	PRJNA940501	11571	440	3.350126	14.7405544	Bacteria	2	Bacteria	Bacteria	108	2e-24	NR	WP_314291413.1	1852388	g10765	i0	51.1	3.27272727272727	94	46	64.1	0	159	440	317	410	WP_314291413.1 DpnII family type II restriction endonuclease [Leptotrichia massiliensis]	diamond	1440	108	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia massiliensis
30088370	30088370	PRJNA940501_S_NODE_402252_length_150_cov_0.878505_g401434_i0	PRJNA940501	402252	150	0.878505	1.3177575	Fusobacterium necrophorum subsp. funduliforme	143387	Bacteria	Bacteria	59.7	3.68e-10	NR	KYM59904.1	143387	g401434	i0	65.8	0.76	38	13	76	0	150	37	4	41	KYM59904.1 hypothetical protein A2U09_11045 [Fusobacterium necrophorum subsp. funduliforme]	diamond	114	59.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
31162384	31162384	PRJNA940501_S_NODE_32715_length_317_cov_2.361314_g31897_i0	PRJNA940501	32715	317	2.361314	7.48536538	Ilyobacter sp.	3100343	Bacteria	Bacteria	43.9	0.033	NR	WP_372715093.1	3100343	g31897	i0	30.8	1.01261829652997	107	65	92.7	1	9	302	115	221	WP_372715093.1 AAA family ATPase, partial [Ilyobacter sp.]	diamond	321	43.9	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	Ilyobacter sp.
32781671	32781671	PRJNA940501_S_NODE_274120_length_173_cov_1.084615_g273302_i0	PRJNA940501	274120	173	1.084615	1.87638395	Fusobacterium	848	Bacteria	Bacteria	73.6	9.71e-14	NR	WP_204716624.1	850	g273302	i0	59.6	6.91907514450867	57	23	98.8	0	171	1	8	64	WP_204716624.1 hypothetical protein [Fusobacterium mortiferum]	diamond	1197	73.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium mortiferum
32837919	32837919	PRJNA940501_S_NODE_397380_length_150_cov_1.317757_g396562_i0	PRJNA940501	397380	150	1.317757	1.9766355	Fusobacterium necrophorum	859	Bacteria	Bacteria	51.6	7.6e-7	NR	WP_147369864.1	859	g396562	i0	54.3	2.8	35	16	70	0	2	106	7	41	WP_147369864.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	420	51.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum

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