metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1248424" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1248424" 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
1051923	1051923	PRJNA1248424_P_NODE_78001_length_243_cov_0.905882_g71932_i0	PRJNA1248424	78001	243	0.905882	2.20129326	Fusobacterium	848	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|2706060613\|gb\|CP077190.1\|	76859	g71932	i0	82.833	50.6625514403292	233	33	95	7	10	239	2095023	2094795	Fusobacterium animalis strain SB026 chromosome, complete genome	blastn	12311	202	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
5456535	5456535	PRJNA1248424_P_NODE_67505_length_255_cov_1.340659_g61436_i0	PRJNA1248424	67505	255	1.340659	3.41868045	Fusobacterium varium	856	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2318938525\|gb\|CP107203.1\|	856	g61436	i0	100	0.109803921568627	28	0	11	0	180	207	2783195	2783168	MAG: Fusobacterium varium isolate KR001_HAM_0062 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
6154655	6154655	PRJNA1248424_P_NODE_63805_length_265_cov_1.500000_g57736_i0	PRJNA1248424	63805	265	1.5	3.975	Fusobacterium	848	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g57736	i0	99.623	488.007547169811	265	1	100	0	1	265	462880	462616	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	129322	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
6730982	6730982	PRJNA1248424_P_NODE_72026_length_248_cov_1.760000_g65957_i0	PRJNA1248424	72026	248	1.76	4.3648	Leptotrichia buccalis	40542	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g65957	i0	100	462.911290322581	248	0	100	0	1	248	120510	120263	Leptotrichia buccalis DSM 1135, complete genome	blastn	114802	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
7429786	7429786	PRJNA1248424_P_NODE_44546_length_340_cov_1.153558_g38482_i0	PRJNA1248424	44546	340	1.153558	3.9220972	Leptotrichia	32067	Bacteria	Bacteria	612	1.17e-170	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g38482	i0	99.118	402.379411764706	340	3	100	0	1	340	197897	198236	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	136809	612	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
14382528	14382528	PRJNA1248424_P_NODE_79032_length_242_cov_0.911243_g72963_i0	PRJNA1248424	79032	242	0.911243	2.20520806	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g72963	i0	97.934	32.400826446281	242	5	100	0	1	242	924755	924514	Leptotrichia sp. oral taxon 498, complete genome	blastn	7841	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
18205053	18205053	PRJNA1248424_P_NODE_77435_length_243_cov_1.664706_g71366_i0	PRJNA1248424	77435	243	1.664706	4.04523558	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|1890961934\|gb\|CP060115.1\|	1583098	g71366	i0	99.177	100.028806584362	243	2	100	0	1	243	859039	859281	Fusobacterium hwasookii strain KCOM 1253 chromosome, complete genome	blastn	24307	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
22029745	22029745	PRJNA1248424_P_NODE_59098_length_278_cov_1.248780_g53030_i0	PRJNA1248424	59098	278	1.24878	3.4716084	Fusobacterium polymorphum	76857	Bacteria	Bacteria	503	5.88e-138	NTclustered	gi\|2704963975\|gb\|CP056021.1\|	76857	g53030	i0	99.281	1428.61870503597	278	2	100	0	1	278	2148654	2148377	Fusobacterium polymorphum strain SB005 chromosome, complete genome	blastn	397156	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24579295	24579295	PRJNA1248424_P_NODE_57840_length_281_cov_1.427885_g51772_i0	PRJNA1248424	57840	281	1.427885	4.01235685	Sebaldella termitidis	826	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|268612520\|gb\|CP001739.1\|	526218	g51772	i0	100	0.103202846975089	29	0	10	0	79	107	3910755	3910783	Sebaldella termitidis ATCC 33386, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella termitidis

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