metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA493244" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA493244" 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
19581394	19581394	PRJNA493244_P_NODE_1377596_length_274_cov_3.643192_g1354471_i0	PRJNA493244	1377596	274	3.643192	9.98234608	Fusobacteriota bacterium	2060921	Bacteria	Bacteria	127	9.259999999999999e-32	NR	NLK62546.1	2060921	g1354471	i0	72.1	0.941605839416058	86	24	94.2	0	15	272	191	276	NLK62546.1 preprotein translocase subunit SecA [Fusobacteriota bacterium]	diamond	258	127	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteriota bacterium
27487275	27487275	PRJNA493244_P_NODE_1651203_length_210_cov_1.268456_g1628078_i0	PRJNA493244	1651203	210	1.268456	2.6637576	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	124	3.2099999999999996e-31	NR	WP_372582653.1	554406	g1628078	i0	87	0.985714285714286	69	9	98.6	0	3	209	655	723	WP_372582653.1 glycosyltransferase [Leptotrichia hongkongensis]	diamond	207	124	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
27771593	27771593	PRJNA493244_P_NODE_1449164_length_255_cov_2.309278_g1426039_i0	PRJNA493244	1449164	255	2.309278	5.8886589	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	102	6.149999999999999e-23	NR	MDO4640009.1	554406	g1426039	i0	80.9	0.8	68	12	80	1	52	255	472	538	MDO4640009.1 hemagglutinin repeat-containing protein [Leptotrichia hongkongensis]	diamond	204	102	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
27897568	27897568	PRJNA493244_P_NODE_1364525_length_278_cov_1.769585_g1341400_i0	PRJNA493244	1364525	278	1.769585	4.9194463	Leptotrichia sp. oral taxon 417	712365	Bacteria	Bacteria	51.2	1.29e-5	NR	WP_255460338.1	712365	g1341400	i0	100	0.280575539568345	26	0	28.1	0	96	19	1	26	WP_255460338.1 methyltransferase [Leptotrichia sp. oral taxon 417]	diamond	78	51.2	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 417
27929359	27929359	PRJNA493244_P_NODE_866845_length_470_cov_7.083130_g843951_i0	PRJNA493244	866845	470	7.08313	33.290711	Fusobacterium periodonticum	860	Bacteria	Bacteria	219	1.99e-69	NR	MBF1197665.1	860	g843951	i0	100	0.714893617021277	112	0	71.5	0	337	2	1	112	MBF1197665.1 hypothetical protein [Fusobacterium periodonticum]	diamond	336	219	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
28387224	28387224	PRJNA493244_P_NODE_1549246_length_231_cov_12.023529_g1526121_i0	PRJNA493244	1549246	231	12.023529	27.77435199	Bacteria	2	Bacteria	Bacteria	104	1.42e-24	NR	WP_032884795.1	851	g1526121	i0	90.7	11.2337662337662	54	5	70.1	0	53	214	1	54	WP_032884795.1 dipeptide epimerase [Fusobacterium nucleatum]	diamond	2595	104	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
28450624	28450624	PRJNA493244_P_NODE_1744186_length_189_cov_2.460938_g1721061_i0	PRJNA493244	1744186	189	2.460938	4.65117282	Fusobacterium	848	Bacteria	Bacteria	100	5.229999999999999e-23	NR	WP_005951503.1	856	g1721061	i0	83.6	1.74603174603175	55	9	87.3	0	24	188	354	408	WP_005951503.1 histidine--tRNA ligase [Fusobacterium varium]	diamond	330	100	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
28718733	28718733	PRJNA493244_P_NODE_674607_length_586_cov_1.828571_g652492_i0	PRJNA493244	674607	586	1.828571	10.71542606	Leptotrichia sp. oral taxon 215	712359	Bacteria	Bacteria	265	9.43e-87	NR	WP_021766690.1	712359	g652492	i0	70.3	1.85324232081911	192	52	96.2	2	22	585	26	216	WP_021766690.1 cell division protein FtsQ/DivIB [Leptotrichia sp. oral taxon 215]	diamond	1086	265	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 215
29097665	29097665	PRJNA493244_P_NODE_268068_length_1035_cov_21.435318_g253736_i0	PRJNA493244	268068	1035	21.435318	221.8555413	Fusobacterium polymorphum	76857	Bacteria	Bacteria	547	1.27e-192	NR	WP_098703068.1	76857	g253736	i0	93.1	0.921739130434783	318	22	92.2	0	1031	78	111	428	WP_098703068.1 TRAP transporter large permease [Fusobacterium polymorphum]	diamond	954	547	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
29507931	29507931	PRJNA493244_P_NODE_469690_length_759_cov_3.297994_g450103_i0	PRJNA493244	469690	759	3.297994	25.03177446	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	262	3.21e-76	NR	WP_099958095.1	2663009	g450103	i0	60.7	1.05533596837945	267	90	99.6	3	3	758	696	962	WP_099958095.1 autotransporter-associated N-terminal domain-containing protein [Fusobacterium pseudoperiodonticum]	diamond	801	262	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
29760416	29760416	PRJNA493244_P_NODE_1221011_length_322_cov_1.226054_g1197887_i0	PRJNA493244	1221011	322	1.226054	3.94789388	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	211	5.6099999999999995e-62	NR	WP_372582653.1	554406	g1197887	i0	94.3	0.987577639751553	106	6	98.8	0	5	322	387	492	WP_372582653.1 glycosyltransferase [Leptotrichia hongkongensis]	diamond	318	211	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
29839673	29839673	PRJNA493244_P_NODE_1307271_length_294_cov_42.339056_g1284147_i0	PRJNA493244	1307271	294	42.339056	124.47682464	Leptotrichia	32067	Bacteria	Bacteria	111	6.17e-26	NR	WP_304179220.1	109328	g1284147	i0	88.5	1.78571428571429	87	10	88.8	0	25	285	1657	1743	WP_304179220.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia trevisanii]	diamond	525	112	0.991071428571429	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
29855400	29855400	PRJNA493244_P_NODE_250411_length_1069_cov_11.786706_g236728_i0	PRJNA493244	250411	1069	11.786706	125.99988714	Fusobacterium ulcerans	861	Bacteria	Bacteria	82	6.22e-13	NR	WP_227372885.1	861	g236728	i0	31.5	0.561272217025257	200	118	52.5	6	159	719	166	359	WP_227372885.1 zincin-like metallopeptidase domain-containing protein [Fusobacterium ulcerans]	diamond	600	82	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
30518792	30518792	PRJNA493244_P_NODE_1529753_length_236_cov_1.462857_g1506628_i0	PRJNA493244	1529753	236	1.462857	3.45234252	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	107	1.78e-27	NR	WP_295686267.1	159271	g1506628	i0	67.1	0.966101694915254	76	24	96.6	1	235	8	103	177	WP_295686267.1 TIR domain-containing protein [uncultured Leptotrichia sp.]	diamond	228	107	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
30597790	30597790	PRJNA493244_P_NODE_1332453_length_287_cov_2.176991_g1309329_i0	PRJNA493244	1332453	287	2.176991	6.24796417	root	1	Root_unresolved	Root_unresolved	43.1	0.00428	NR	WP_222702847.1	859	g1309329	i0	65.5	1.76655052264808	29	10	30.3	0	134	48	30	58	WP_222702847.1 hypothetical protein, partial [Fusobacterium necrophorum]	diamond	507	43.5	0.990804597701149	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium necrophorum
31894052	31894052	PRJNA493244_P_NODE_1688557_length_205_cov_1.333333_g1665432_i0	PRJNA493244	1688557	205	1.333333	2.73333265	Fusobacterium	848	Bacteria	Bacteria	128	2.01e-36	NR	MBF1213630.1	860	g1665432	i0	92.6	1.99024390243902	68	5	99.5	0	204	1	41	108	MBF1213630.1 protein phosphatase 2C domain-containing protein [Fusobacterium periodonticum]	diamond	408	128	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
31973026	31973026	PRJNA493244_P_NODE_1681698_length_206_cov_0.882759_g1658573_i0	PRJNA493244	1681698	206	0.882759	1.81848354	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	117	2.31e-29	NR	MBP6408967.1	2053555	g1658573	i0	98.4	2.75242718446602	63	1	91.7	0	7	195	318	380	MBP6408967.1 TolC family protein [Fusobacteriaceae bacterium]	diamond	567	117	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
32131451	32131451	PRJNA493244_P_NODE_1718718_length_201_cov_3.407143_g1695593_i0	PRJNA493244	1718718	201	3.407143	6.84835743	Leptotrichia wadei	157687	Bacteria	Bacteria	97.4	1.22e-21	NR	WP_147002844.1	157687	g1695593	i0	78	0.880597014925373	59	13	88.1	0	201	25	120	178	WP_147002844.1 DNA translocase FtsK [Leptotrichia wadei]	diamond	177	97.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
32416162	32416162	PRJNA493244_P_NODE_343099_length_913_cov_4.550469_g326320_i0	PRJNA493244	343099	913	4.550469	41.54578197	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	350	3.76e-117	NR	WP_211616811.1	712361	g326320	i0	66.8	0.821467688937568	250	82	81.8	1	817	71	53	302	WP_211616811.1 hypothetical protein [Leptotrichia sp. oral taxon 218]	diamond	750	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218

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