metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA390533" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA390533" 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
409920	409920	PRJNA390533_P_NODE_7001_length_740_cov_21.009986_g6274_i0	PRJNA390533	7001	740	21.009986	155.4738964	Leptotrichia wadei	157687	Bacteria	Bacteria	1271	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g6274	i0	99.015	582.404054054054	711	3	96	1	13	719	2297681	2298391	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	430979	1271	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
2960213	2960213	PRJNA390533_P_NODE_12603_length_542_cov_3.087475_g11659_i0	PRJNA390533	12603	542	3.087475	16.7341145	Sneathia vaginalis	187101	Bacteria	Bacteria	869	0	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g11659	i0	95.446	4.12177121771218	549	17	100	4	1	542	792273	792820	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	2234	869	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
2960463	2960463	PRJNA390533_P_NODE_33443_length_219_cov_3.494444_g32416_i0	PRJNA390533	33443	219	3.494444	7.65283236	Fusobacterium polymorphum	76857	Bacteria	Bacteria	357	3.67e-94	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g32416	i0	99.492	36.8812785388128	197	0	90	1	2	198	2361729	2361534	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	8077	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
2960513	2960513	PRJNA390533_P_NODE_38363_length_188_cov_1.838926_g37336_i0	PRJNA390533	38363	188	1.838926	3.45718088	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	331	1.85e-86	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g37336	i0	100	363.303191489362	179	0	95	0	10	188	25324	25502	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	68301	331	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
4236803	4236803	PRJNA390533_P_NODE_31504_length_237_cov_1.227273_g30477_i0	PRJNA390533	31504	237	1.227273	2.90863701	Sneathia vaginalis	187101	Bacteria	Bacteria	392	1.0999999999999999e-104	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g30477	i0	99.083	7.08860759493671	218	2	92	0	20	237	970382	970599	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	1680	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
9337858	9337858	PRJNA390533_P_NODE_33788_length_217_cov_1.353933_g32761_i0	PRJNA390533	33788	217	1.353933	2.93803461	Sneathia vaginalis	187101	Bacteria	Bacteria	398	2.14e-106	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g32761	i0	100	0.990783410138249	215	0	99	0	1	215	973983	973769	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	215	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
13163537	13163537	PRJNA390533_P_NODE_36331_length_199_cov_3.312500_g35304_i0	PRJNA390533	36331	199	3.3125	6.591875	Leptotrichia wadei	157687	Bacteria	Bacteria	298	2.01e-76	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g35304	i0	97.159	72.3668341708543	176	5	88	0	1	176	220632	220457	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	14401	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
15712224	15712224	PRJNA390533_P_NODE_15973_length_459_cov_2.340476_g14967_i0	PRJNA390533	15973	459	2.340476	10.74278484	Sneathia vaginalis	187101	Bacteria	Bacteria	363	1.8099999999999994e-95	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g14967	i0	95.595	2.77777777777778	227	9	49	1	229	455	37883	38108	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	1275	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
17655691	17655691	PRJNA390533_P_NODE_19514_length_393_cov_2.064972_g18492_i0	PRJNA390533	19514	393	2.064972	8.11533996	Cetobacterium	180162	Bacteria	Bacteria	610	4.949999999999999e-170	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18492	i0	94.656	6.72773536895674	393	21	100	0	1	393	1869448	1869056	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2644	610	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19535492	19535492	PRJNA390533_P_NODE_28356_length_272_cov_2.472103_g27329_i0	PRJNA390533	28356	272	2.472103	6.72412016	Sneathia sanguinegens	40543	Bacteria	Bacteria	475	1.2499999999999999e-129	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g27329	i0	98.162	4	272	5	100	0	1	272	1148291	1148562	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	1088	475	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
20811236	20811236	PRJNA390533_P_NODE_20757_length_373_cov_2.425150_g19733_i0	PRJNA390533	20757	373	2.42515	9.0458095	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	363	1.4399999999999999e-95	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g19733	i0	100	53.5201072386059	196	0	69	0	178	373	630551	630746	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	19963	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
20811418	20811418	PRJNA390533_P_NODE_37137_length_195_cov_1.288462_g36110_i0	PRJNA390533	37137	195	1.288462	2.5125009	Sneathia sanguinegens	40543	Bacteria	Bacteria	340	3.21e-89	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g36110	i0	100	10.3794871794872	184	0	94	0	12	195	3419	3236	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	2024	340	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
20811522	20811522	PRJNA390533_P_NODE_48377_length_154_cov_2.095652_g47350_i0	PRJNA390533	48377	154	2.095652	3.22730408	uncultured Leptotrichia sp.	159271	Bacteria	Bacteria	274	2.48e-69	NTclustered	gi\|571048574\|gb\|KF422121.1\|	159271	g47350	i0	98.701	93.3051948051948	154	2	100	0	1	154	19	172	Uncultured Leptotrichia sp. clone VostokV6_rep_c139 genomic sequence	blastn	14369	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	uncultured Leptotrichia sp.
22086436	22086436	PRJNA390533_P_NODE_9518_length_637_cov_2.700669_g8667_i0	PRJNA390533	9518	637	2.700669	17.20326153	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	1005	0	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g8667	i0	95.149	507.835164835165	639	27	100	4	1	637	308459	309095	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	323491	1005	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
24636157	24636157	PRJNA390533_P_NODE_34240_length_214_cov_0.937143_g33213_i0	PRJNA390533	34240	214	0.937143	2.00548602	Sneathia vaginalis	187101	Bacteria	Bacteria	390	3.519999999999999e-104	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g33213	i0	99.533	1.14018691588785	214	1	100	0	1	214	973096	972883	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	244	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis

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