metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA408129" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA408129" 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
418269	418269	PRJNA408129_S_NODE_10161_length_220_cov_13.453552_g10143_i0	PRJNA408129	10161	220	13.453552	29.5978144	Sneathia sanguinegens	40543	Bacteria	Bacteria	285	1.7599999999999998e-72	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g10143	i0	93.299	495.745454545455	194	12	88	1	14	206	1969	1776	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	109064	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
2969159	2969159	PRJNA408129_S_NODE_24883_length_167_cov_2.938462_g24865_i0	PRJNA408129	24883	167	2.938462	4.90723154	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g24865	i0	98.78	281.119760479042	164	2	98	0	4	167	594226	594063	Leptotrichia sp. oral taxon 498, complete genome	blastn	46947	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
6796320	6796320	PRJNA408129_S_NODE_6826_length_246_cov_2.904306_g6808_i0	PRJNA408129	6826	246	2.904306	7.14459276	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	344	3.27e-90	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g6808	i0	97.059	365.406504065041	204	6	84	0	36	239	52137	51934	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	89890	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7460719	7460719	PRJNA408129_S_NODE_9526_length_224_cov_14.406417_g9508_i0	PRJNA408129	9526	224	14.406417	32.27037408	Fusobacterium	848	Bacteria	Bacteria	309	1.07e-79	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g9508	i0	95.361	410.508928571429	194	9	87	0	17	210	155797	155604	Fusobacterium varium strain SB069 chromosome	blastn	91954	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
11286013	11286013	PRJNA408129_S_NODE_14449_length_198_cov_2.037267_g14431_i0	PRJNA408129	14449	198	2.037267	4.03378866	Leptotrichia	32067	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g14431	i0	100	10.0454545454545	198	0	100	0	1	198	1525475	1525278	Leptotrichia sp. oral taxon 498, complete genome	blastn	1989	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
13836211	13836211	PRJNA408129_S_NODE_25811_length_165_cov_3.359375_g25793_i0	PRJNA408129	25811	165	3.359375	5.54296875	Fusobacterium	848	Bacteria	Bacteria	243	7.63e-60	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g25793	i0	100	17.3454545454545	131	0	98	0	4	134	2320896	2320766	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	2862	243	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
20208907	20208907	PRJNA408129_S_NODE_25836_length_165_cov_3.054688_g25818_i0	PRJNA408129	25836	165	3.054688	5.0402352	Fusobacterium	848	Bacteria	Bacteria	268	1.26e-67	NTclustered	gi\|2269773925\|gb\|CP100429.1\|	76857	g25818	i0	100	26.3636363636364	145	0	88	0	12	156	2137785	2137641	Fusobacterium polymorphum strain SSMR1 chromosome, complete genome	blastn	4350	268	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
21484428	21484428	PRJNA408129_S_NODE_21237_length_175_cov_5.137681_g21219_i0	PRJNA408129	21237	175	5.137681	8.99094175	Fusobacterium	848	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2445153921\|gb\|CP117797.1\|	851	g21219	i0	100	3.2	28	0	16	0	34	61	892102	892129	Fusobacterium nucleatum strain FNA chromosome, complete genome	blastn	560	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24644706	24644706	PRJNA408129_S_NODE_14640_length_197_cov_2.562500_g14622_i0	PRJNA408129	14640	197	2.5625	5.048125	Leptotrichia wadei	157687	Bacteria	Bacteria	359	8.98e-95	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g14622	i0	100	7.82741116751269	194	0	98	0	4	197	1853694	1853501	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	1542	359	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
24644790	24644790	PRJNA408129_S_NODE_23720_length_169_cov_10.568182_g23702_i0	PRJNA408129	23720	169	10.568182	17.86022758	Fusobacterium perfoetens	852	Bacteria	Bacteria	233	4.7e-57	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g23702	i0	93.168	415.970414201183	161	8	93	3	1	158	461	301	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	70299	233	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens

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