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

17 rows where bioproject = "PRJEB75230" 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
3962198	3962198	PRJEB75230_P_NODE_126504_length_250_cov_0.870056_g126322_i0	PRJEB75230	126504	250	0.870056	2.17514	Fusobacterium ulcerans	861	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1370545701\|gb\|CP028105.1\|	861	g126322	i0	100	0.224	28	0	11	0	79	106	2943830	2943803	Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
9063496	9063496	PRJEB75230_P_NODE_138908_length_248_cov_0.880000_g138726_i0	PRJEB75230	138908	248	0.88	2.1824	Sneathia sanguinegens	40543	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g138726	i0	99.597	446.866935483871	248	1	100	0	1	248	72423	72670	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	110823	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
11199407	11199407	PRJEB75230_P_NODE_5669_length_584_cov_2.021526_g5488_i0	PRJEB75230	5669	584	2.021526	11.80571184	Fusobacterium	848	Bacteria	Bacteria	1062	0	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g5488	i0	99.486	481.244863013699	584	3	100	0	1	584	106310	106893	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	281047	1062	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
12474981	12474981	PRJEB75230_P_NODE_28790_length_352_cov_2.007168_g28608_i0	PRJEB75230	28790	352	2.007168	7.06523136	Fusobacterium	848	Bacteria	Bacteria	651	0	NTclustered	gi\|1721134154\|emb\|LR698955.1\|	851	g28608	i0	100	490.164772727273	352	0	100	0	1	352	84652	84301	Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1	blastn	172538	651	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
18847510	18847510	PRJEB75230_P_NODE_129875_length_249_cov_1.102273_g129693_i0	PRJEB75230	129875	249	1.102273	2.74465977	root	1	Root_unresolved	Root_unresolved	52.8	0.023	NTclustered	gi\|2704944210\|gb\|CP077182.1\|	851	g129693	i0	100	0.78714859437751	28	0	11	0	141	168	720536	720509	Fusobacterium nucleatum strain SB032 chromosome, complete genome	blastn	196	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
19262252	19262252	PRJEB75230_P_NODE_176196_length_242_cov_0.911243_g176014_i0	PRJEB75230	176196	242	0.911243	2.20520806	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1276712381\|gb\|CP024701.1\|	2663009	g176014	i0	99.587	99.7148760330578	242	1	100	0	1	242	1632865	1632624	Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome	blastn	24131	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20122774	20122774	PRJEB75230_P_NODE_81156_length_279_cov_1.121359_g80974_i0	PRJEB75230	81156	279	1.121359	3.12859161	Fusobacterium	848	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g80974	i0	100	0.824372759856631	29	0	10	0	187	215	1801890	1801918	Fusobacterium hwasookii ChDC F174, complete genome	blastn	230	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
20538789	20538789	PRJEB75230_P_NODE_84177_length_276_cov_1.418719_g83995_i0	PRJEB75230	84177	276	1.418719	3.91566444	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g83995	i0	100	384.039855072464	276	0	100	0	1	276	70587	70862	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	105995	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
25221921	25221921	PRJEB75230_P_NODE_123000_length_250_cov_1.395480_g122818_i0	PRJEB75230	123000	250	1.39548	3.4887	Leptotrichia	32067	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g122818	i0	98.008	485.52	251	3	100	2	1	250	1694903	1695152	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	121380	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
26654070	26654070	PRJEB75230_P_NODE_160621_length_244_cov_0.900585_g160439_i0	PRJEB75230	160621	244	0.900585	2.1974274	Fusobacterium sp.	68766	Bacteria	Bacteria	146	5.989999999999998e-41	NR	WP_320614961.1	68766	g160439	i0	93.8	0.983606557377049	80	5	98.4	0	3	242	7	86	WP_320614961.1 vWA domain-containing protein [Fusobacterium sp.]	diamond	240	146	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium sp.
26876284	26876284	PRJEB75230_P_NODE_171841_length_242_cov_1.911243_g171659_i0	PRJEB75230	171841	242	1.911243	4.62520806	Fusobacterium necrophorum	859	Bacteria	Bacteria	47.8	2.55e-4	NR	WP_394292706.1	859	g171659	i0	52.8	1.77272727272727	36	17	44.6	0	108	1	31	66	WP_394292706.1 endonuclease/exonuclease/phosphatase family protein [Fusobacterium necrophorum]	diamond	429	47.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
28044885	28044885	PRJEB75230_P_NODE_157845_length_245_cov_0.895349_g157663_i0	PRJEB75230	157845	245	0.895349	2.19360505	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	42.4	0.0497	NR	MBN1467473.1	2053555	g157663	i0	42.6	0.661224489795918	54	29	66.1	1	241	80	229	280	MBN1467473.1 acyltransferase [Fusobacteriaceae bacterium]	diamond	162	42.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
28258553	28258553	PRJEB75230_P_NODE_133686_length_249_cov_0.875000_g133504_i0	PRJEB75230	133686	249	0.875	2.17875	root	1	Root_unresolved	Root_unresolved	42.7	0.0113	NR	WP_222702918.1	859	g133504	i0	40	3.69879518072289	55	30	62.7	2	248	93	14	68	WP_222702918.1 hypothetical protein [Fusobacterium necrophorum]	diamond	921	43.1	0.990719257540603	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
29465398	29465398	PRJEB75230_P_NODE_26950_length_358_cov_1.382456_g26768_i0	PRJEB75230	26950	358	1.382456	4.94919248	Fusobacterium necrophorum	859	Bacteria	Bacteria	56.2	1.47e-7	NR	WP_187105728.1	859	g26768	i0	60.4	0.402234636871508	48	19	40.2	0	57	200	29	76	WP_187105728.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	144	56.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
30343430	30343430	PRJEB75230_P_NODE_154472_length_245_cov_0.895349_g154290_i0	PRJEB75230	154472	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	42.7	0.0104	NR	WP_187105689.1	859	g154290	i0	57.5	1.91020408163265	40	17	49	0	244	125	10	49	WP_187105689.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	468	43.1	0.990719257540603	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
31202789	31202789	PRJEB75230_P_NODE_41795_length_325_cov_0.916667_g41613_i0	PRJEB75230	41795	325	0.916667	2.97916775	Fusobacterium necrophorum subsp. funduliforme	143387	Bacteria	Bacteria	48.5	7.28e-5	NR	KYM59904.1	143387	g41613	i0	54.8	1.30153846153846	42	18	37.8	1	267	145	2	43	KYM59904.1 hypothetical protein A2U09_11045 [Fusobacterium necrophorum subsp. funduliforme]	diamond	423	48.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
31329716	31329716	PRJEB75230_P_NODE_153056_length_245_cov_1.790698_g152874_i0	PRJEB75230	153056	245	1.790698	4.3872101	Fusobacterium necrophorum	859	Bacteria	Bacteria	78.6	1.1e-16	NR	WP_222702918.1	859	g152874	i0	52.1	10.6897959183673	71	31	83.3	1	241	38	9	79	WP_222702918.1 hypothetical protein [Fusobacterium necrophorum]	diamond	2619	79.3	0.991172761664565	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);;