metadata: contig_metadata: 17 rows where bioproject = "PRJNA940501" and tax

17 rows where 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
3810262	3810262	PRJNA940501_S_NODE_376683_length_153_cov_1.281818_g375865_i0	PRJNA940501	376683	153	1.281818	1.96118154	Fusobacterium	848	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2704966168\|gb\|CP077123.1\|	851	g375865	i0	100	100	153	0	100	0	1	153	341187	341035	Fusobacterium nucleatum strain KCOM3764 chromosome, complete genome	blastn	15300	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
9847270	9847270	PRJNA940501_S_NODE_215008_length_188_cov_1.944828_g214190_i0	PRJNA940501	215008	188	1.944828	3.65627664	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	342	8.539999999999999e-90	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g214190	i0	99.468	12	188	1	100	0	1	188	566648	566461	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	2256	342	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
12400376	12400376	PRJNA940501_S_NODE_390430_length_151_cov_0.870370_g389612_i0	PRJNA940501	390430	151	0.87037	1.3142587	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g389612	i0	99.338	1	151	1	100	0	1	151	1920093	1920243	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	151	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15286363	15286363	PRJNA940501_S_NODE_64492_length_267_cov_1.933036_g63674_i0	PRJNA940501	64492	267	1.933036	5.16120612	Fusobacterium	848	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2705032171\|gb\|CP084140.1\|	851	g63674	i0	100	0.640449438202247	28	0	10	0	199	226	957346	957319	Fusobacterium nucleatum strain KCOM3187 chromosome, complete genome	blastn	171	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
17835609	17835609	PRJNA940501_S_NODE_358954_length_156_cov_1.247788_g358136_i0	PRJNA940501	358954	156	1.247788	1.94654928	Fusobacterium	848	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g358136	i0	100	99.9615384615385	156	0	100	0	1	156	401831	401676	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	15594	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18772718	18772718	PRJNA940501_S_NODE_367855_length_154_cov_1.693694_g367037_i0	PRJNA940501	367855	154	1.693694	2.60828876	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	268	1.15e-67	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g367037	i0	98.065	460.064935064935	155	2	100	1	1	154	1994796	1994642	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	70850	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
21659969	21659969	PRJNA940501_S_NODE_234197_length_183_cov_1.164286_g233379_i0	PRJNA940501	234197	183	1.164286	2.13064338	Leptotrichia	32067	Bacteria	Bacteria	62.1	2.59e-5	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g233379	i0	97.297	0.404371584699454	37	0	20	1	22	57	166991	166955	Leptotrichia sp. oral taxon 498, complete genome	blastn	74	62.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
22595047	22595047	PRJNA940501_S_NODE_142158_length_215_cov_1.377907_g141340_i0	PRJNA940501	142158	215	1.377907	2.96250005	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	296	7.93e-76	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g141340	i0	98.795	362.051162790698	166	2	77	0	1	166	2083520	2083355	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	77841	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
23871267	23871267	PRJNA940501_S_NODE_187699_length_197_cov_1.474026_g186881_i0	PRJNA940501	187699	197	1.474026	2.90383122	Leptotrichia wadei	157687	Bacteria	Bacteria	353	4.18e-93	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g186881	i0	98.985	135.517766497462	197	2	100	0	1	197	221528	221724	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	26697	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
25145557	25145557	PRJNA940501_S_NODE_224000_length_186_cov_0.986014_g223182_i0	PRJNA940501	224000	186	0.986014	1.83398604	Leptotrichia wadei	157687	Bacteria	Bacteria	298	1.85e-76	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g223182	i0	100	337.693548387097	161	0	87	0	26	186	222308	222468	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	62811	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
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);;