metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
794154	794154	PRJNA799842_P_NODE_179021_length_243_cov_0.905882_g177448_i0	PRJNA799842	179021	243	0.905882	2.20129326	Leptotrichia buccalis	40542	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g177448	i0	100	5.06584362139918	243	0	100	0	1	243	1502292	1502534	Leptotrichia buccalis DSM 1135, complete genome	blastn	1231	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
2069919	2069919	PRJNA799842_P_NODE_176942_length_243_cov_0.905882_g175369_i0	PRJNA799842	176942	243	0.905882	2.20129326	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g175369	i0	100	22.0740740740741	243	0	100	0	1	243	240996	241238	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	5364	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
2494554	2494554	PRJNA799842_P_NODE_190542_length_241_cov_0.880952_g188969_i0	PRJNA799842	190542	241	0.880952	2.12309432	Fusobacterium	848	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|2318938525\|gb\|CP107203.1\|	856	g188969	i0	99.585	9.16182572614108	241	1	100	0	1	241	2844850	2845090	MAG: Fusobacterium varium isolate KR001_HAM_0062 chromosome, complete genome	blastn	2208	440	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
2494556	2494556	PRJNA799842_P_NODE_190762_length_239_cov_2.024096_g189189_i0	PRJNA799842	190762	239	2.024096	4.83758944	Leptotrichia	32067	Bacteria	Bacteria	396	8.609999999999997e-106	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g189189	i0	96.653	234.648535564854	239	7	100	1	1	239	258	21	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	56081	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
3345615	3345615	PRJNA799842_P_NODE_28243_length_550_cov_2.188679_g26685_i0	PRJNA799842	28243	550	2.188679	12.0377345	Leptotrichia hofstadii	157688	Bacteria	Bacteria	983	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g26685	i0	98.909	485.34	550	6	100	0	1	550	2373144	2373693	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	266937	983	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
3770177	3770177	PRJNA799842_P_NODE_103543_length_286_cov_3.267606_g101970_i0	PRJNA799842	103543	286	3.267606	9.34535316	Fusobacterium	848	Bacteria	Bacteria	183	8.98e-42	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g101970	i0	88.312	17.2202797202797	154	16	53	2	134	286	189499	189347	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	4925	183	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
4621269	4621269	PRJNA799842_P_NODE_112084_length_277_cov_0.941176_g110511_i0	PRJNA799842	112084	277	0.941176	2.60705752	Fusobacterium varium	856	Bacteria	Bacteria	422	1.69e-113	NTclustered	gi\|1540073569\|emb\|LR134390.1\|	856	g110511	i0	94.265	492.241877256318	279	10	99	6	2	277	514428	514153	Fusobacterium varium strain NCTC10560 genome assembly, chromosome: 1	blastn	136351	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
4624289	4624289	PRJNA799842_P_NODE_86944_length_310_cov_2.776371_g85371_i0	PRJNA799842	86944	310	2.776371	8.6067501	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|1276714546\|gb\|CP024702.1\|	2663009	g85371	i0	100	34.7483870967742	150	0	97	0	1	150	1632848	1632699	Fusobacterium pseudoperiodonticum strain KCOM 1282 chromosome, complete genome	blastn	10772	278	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
5898775	5898775	PRJNA799842_P_NODE_57605_length_374_cov_2.129568_g56032_i0	PRJNA799842	57605	374	2.129568	7.96458432	Fusobacterium nucleatum	851	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|2704972056\|gb\|CP077127.1\|	851	g56032	i0	100	0.149732620320856	28	0	7	0	52	79	1472586	1472613	Fusobacterium nucleatum strain KCOM3503 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
7171937	7171937	PRJNA799842_P_NODE_150226_length_248_cov_0.880000_g148653_i0	PRJNA799842	150226	248	0.88	2.1824	Fusobacterium animalis	76859	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2078823552\|gb\|CP071098.1\|	76859	g148653	i0	100	2768.54435483871	248	0	100	0	1	248	600141	600388	Fusobacterium animalis strain THCT6B3 chromosome, complete genome	blastn	686599	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
12698433	12698433	PRJNA799842_P_NODE_158010_length_247_cov_0.885057_g156437_i0	PRJNA799842	158010	247	0.885057	2.18609079	Fusobacterium	848	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g156437	i0	100	100	247	0	100	0	1	247	956109	956355	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	24700	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
14823869	14823869	PRJNA799842_P_NODE_72092_length_337_cov_3.295455_g70519_i0	PRJNA799842	72092	337	3.295455	11.10568335	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	556	5.529999999999999e-154	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g70519	i0	96.439	297.204747774481	337	12	100	0	1	337	53151	52815	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	100158	556	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15247554	15247554	PRJNA799842_P_NODE_34252_length_492_cov_3.016706_g32682_i0	PRJNA799842	34252	492	3.016706	14.84219352	Leptotrichia	32067	Bacteria	Bacteria	898	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g32682	i0	99.593	462.477642276423	492	2	100	0	1	492	393	884	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	227539	904	0.993362831858407	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
16098138	16098138	PRJNA799842_P_NODE_76733_length_328_cov_1.368627_g75160_i0	PRJNA799842	76733	328	1.368627	4.48909656	Leptotrichia wadei	157687	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g75160	i0	100	0.0853658536585366	28	0	9	0	163	190	893595	893622	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19071547	19071547	PRJNA799842_P_NODE_93095_length_301_cov_1.004386_g91522_i0	PRJNA799842	93095	301	1.004386	3.02320186	Fusobacterium	848	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2705015041\|gb\|CP084068.1\|	856	g91522	i0	100	0.372093023255814	28	0	9	0	73	100	614237	614264	Fusobacterium varium strain SB064 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
21196563	21196563	PRJNA799842_P_NODE_178837_length_243_cov_0.905882_g177264_i0	PRJNA799842	178837	243	0.905882	2.20129326	Fusobacterium ulcerans	861	Bacteria	Bacteria	416	6.739999999999998e-112	NTclustered	gi\|1370545701\|gb\|CP028105.1\|	861	g177264	i0	97.531	10.0617283950617	243	6	100	0	1	243	3422462	3422704	Fusobacterium ulcerans strain ATCC 49185 chromosome, complete genome	blastn	2445	416	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium ulcerans
22470252	22470252	PRJNA799842_P_NODE_125158_length_261_cov_1.638298_g123585_i0	PRJNA799842	125158	261	1.638298	4.27595778	Leptotrichia buccalis	40542	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g123585	i0	100	4.97701149425287	261	0	100	0	1	261	338870	338610	Leptotrichia buccalis DSM 1135, complete genome	blastn	1299	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
23747446	23747446	PRJNA799842_P_NODE_34399_length_491_cov_1.758373_g32829_i0	PRJNA799842	34399	491	1.758373	8.63361143	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	691	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g32829	i0	92.261	104.193482688391	491	33	99	5	1	489	52036	51549	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	51159	691	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
25445950	25445950	PRJNA799842_P_NODE_36160_length_477_cov_2.551980_g34590_i0	PRJNA799842	36160	477	2.55198	12.1729446	Fusobacteriaceae	203492	Bacteria	Bacteria	752	0	NTclustered	gi\|2705015041\|gb\|CP084068.1\|	856	g34590	i0	95.359	511.316561844864	474	21	99	1	1	474	769917	770389	Fusobacterium varium strain SB064 chromosome, complete genome	blastn	243898	754	0.997347480106101	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium

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