metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA438687" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA438687" 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
1710231	1710231	PRJNA438687_S_NODE_6722_length_168_cov_3.917293_g6632_i0	PRJNA438687	6722	168	3.917293	6.58105224	Fusobacteria bacterium ZRK30	2970471	Bacteria	Bacteria	233	4.7e-57	NTclustered	gi\|2284594148\|gb\|CP102404.1\|	2970471	g6632	i0	91.667	233.904761904762	168	14	100	0	1	168	205720	205553	Fusobacteria bacterium ZRK30 chromosome 1, complete sequence	blastn	39296	233	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteria bacterium ZRK30
2366617	2366617	PRJNA438687_S_NODE_3762_length_229_cov_22.283505_g3672_i0	PRJNA438687	3762	229	22.283505	51.02922645	Fusobacterium	848	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g3672	i0	100	481.786026200873	229	0	100	0	1	229	322039	322267	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	110329	424	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
4919385	4919385	PRJNA438687_S_NODE_6904_length_165_cov_419.776923_g6814_i0	PRJNA438687	6904	165	419.776923	692.63192295	Fusobacterium	848	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g6814	i0	100	496	165	0	100	0	1	165	93737	93573	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	81840	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
5538969	5538969	PRJNA438687_S_NODE_265_length_558_cov_24.688337_g193_i0	PRJNA438687	265	558	24.688337	137.76092046	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	1031	0	NTclustered	gi\|1276720946\|gb\|CP024705.1\|	2663009	g193	i0	100	477.530465949821	558	0	100	0	1	558	1620664	1620107	Fusobacterium pseudoperiodonticum strain KCOM 2653 chromosome, complete genome	blastn	266462	1031	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
5539086	5539086	PRJNA438687_S_NODE_8065_length_152_cov_1.333333_g7975_i0	PRJNA438687	8065	152	1.333333	2.02666616	Fusobacterium polymorphum	76857	Bacteria	Bacteria	191	2.52e-44	NTclustered	gi\|2706424020\|gb\|CP077136.1\|	76857	g7975	i0	90.845	29.1907894736842	142	13	93	0	11	152	286031	285890	Fusobacterium polymorphum strain KCOM3036 chromosome, complete genome	blastn	4437	191	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
7469238	7469238	PRJNA438687_S_NODE_86_length_692_cov_23.754947_g6_i2	PRJNA438687	86	692	23.754947	164.38423324	Fusobacterium	848	Bacteria	Bacteria	1262	0	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g6	i2	99.566	481.420520231214	692	3	100	0	1	692	84132	84823	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	333143	1267	0.996053670086819	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
8744233	8744233	PRJNA438687_S_NODE_7487_length_158_cov_2.552846_g7397_i0	PRJNA438687	7487	158	2.552846	4.03349668	Cetobacterium	180162	Bacteria	Bacteria	231	1.5599999999999998e-56	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g7397	i0	93.038	221.73417721519	158	11	100	0	1	158	277934	278091	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	35034	231	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9363367	9363367	PRJNA438687_S_NODE_6128_length_177_cov_3.000000_g6038_i0	PRJNA438687	6128	177	3	5.31	Cetobacterium somerae	188913	Bacteria	Bacteria	292	8.09e-75	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g6038	i0	96.61	57	177	5	100	1	1	177	420197	420372	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	10089	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11294296	11294296	PRJNA438687_S_NODE_29_length_989_cov_20.906709_g6_i1	PRJNA438687	29	989	20.906709	206.76735201	Cetobacterium	180162	Bacteria	Bacteria	1570	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g6	i1	95.267	489.517694641052	993	43	100	4	1	989	1577052	1578044	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	484133	1570	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11294405	11294405	PRJNA438687_S_NODE_89_length_689_cov_18.637615_g6_i3	PRJNA438687	89	689	18.637615	128.41316735	Fusobacterium	848	Bacteria	Bacteria	1118	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g6	i3	96.087	480.660377358491	690	19	100	4	1	689	462233	462915	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	331175	1118	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
14463974	14463974	PRJNA438687_S_NODE_3412_length_241_cov_3.854369_g3322_i0	PRJNA438687	3412	241	3.854369	9.28902929	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	390	4.05e-104	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g3322	i0	95.868	415.398340248963	242	9	100	1	1	241	53078	52837	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	100111	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19561280	19561280	PRJNA438687_S_NODE_7256_length_161_cov_2.500000_g7166_i0	PRJNA438687	7256	161	2.5	4.025	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	171	3.54e-38	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g7166	i0	86.25	337.490683229814	160	19	99	3	2	161	3549	3705	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	54336	171	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
19561293	19561293	PRJNA438687_S_NODE_8116_length_151_cov_2.318966_g8026_i0	PRJNA438687	8116	151	2.318966	3.50163866	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g8026	i0	98.013	305.019867549669	151	3	100	0	1	151	52426	52276	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	46058	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20217415	20217415	PRJNA438687_S_NODE_5136_length_195_cov_17.112500_g5046_i0	PRJNA438687	5136	195	17.1125	33.369375	Fusobacteriaceae	203492	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g5046	i0	94.872	520	195	10	100	0	1	195	157853	158047	Fusobacterium varium strain SB069 chromosome	blastn	101400	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
20836924	20836924	PRJNA438687_S_NODE_5997_length_179_cov_7.298611_g5907_i0	PRJNA438687	5997	179	7.298611	13.06451369	Cetobacterium somerae	188913	Bacteria	Bacteria	318	1.35e-82	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g5907	i0	99.429	492.921787709497	175	1	99	0	1	175	941118	941292	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	88233	318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22768192	22768192	PRJNA438687_S_NODE_98_length_677_cov_23.654206_g6_i4	PRJNA438687	98	677	23.654206	160.13897462	Fusobacterium	848	Bacteria	Bacteria	1044	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g6	i4	94.69	478.46528803545	678	26	100	6	1	677	528	1196	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	323921	1048	0.99618320610687	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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