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

16 rows where analysis = "blastn", bioproject = "PRJEB41113" 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
59184	59184	PRJEB41113_S_NODE_9161_length_163_cov_1.888889_g9152_i0	PRJEB41113	9161	163	1.888889	3.07888907	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	244	2.09e-60	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g9152	i0	96.622	11.8098159509202	148	3	90	2	17	163	272815	272961	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	1925	244	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
59186	59186	PRJEB41113_S_NODE_9421_length_162_cov_1.824000_g9412_i0	PRJEB41113	9421	162	1.824	2.95488	Leptotrichia trevisanii	109328	Bacteria	Bacteria	254	3.44e-63	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g9412	i0	98.601	6.18518518518519	143	2	88	0	1	143	47298	47156	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	1002	254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
1333393	1333393	PRJEB41113_S_NODE_1002_length_262_cov_4.391111_g993_i0	PRJEB41113	1002	262	4.391111	11.50471082	Fusobacterium nucleatum	851	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g993	i0	100	100.057251908397	262	0	100	0	1	262	2007401	2007662	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	26215	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
2608981	2608981	PRJEB41113_S_NODE_11923_length_155_cov_0.974576_g11914_i0	PRJEB41113	11923	155	0.974576	1.5105928	Fusobacterium polymorphum	76857	Bacteria	Bacteria	276	6.95e-70	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g11914	i0	98.71	5.86451612903226	155	2	100	0	1	155	1890701	1890547	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	909	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
2608993	2608993	PRJEB41113_S_NODE_1483_length_241_cov_5.318627_g1474_i0	PRJEB41113	1483	241	5.318627	12.81789107	Leptotrichia buccalis	40542	Bacteria	Bacteria	374	4.079999999999998e-99	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g1474	i0	96.875	1.85892116182573	224	6	93	1	1	224	783317	783539	Leptotrichia buccalis DSM 1135, complete genome	blastn	448	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
5161394	5161394	PRJEB41113_S_NODE_14545_length_151_cov_3.166667_g14536_i0	PRJEB41113	14545	151	3.166667	4.78166717	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g14536	i0	99.338	1	151	1	100	0	1	151	2014873	2014723	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	151	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
8986238	8986238	PRJEB41113_S_NODE_2408_length_218_cov_1.441989_g2399_i0	PRJEB41113	2408	218	1.441989	3.14353602	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	381	2.1599999999999994e-101	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g2399	i0	99.522	13.4311926605505	209	1	96	0	1	209	1407850	1407642	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	2928	381	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
11537337	11537337	PRJEB41113_S_NODE_4190_length_193_cov_2.628205_g4181_i0	PRJEB41113	4190	193	2.628205	5.07243565	Leptotrichia wadei	157687	Bacteria	Bacteria	217	5.5799999999999996e-52	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g4181	i0	94.366	5.32124352331606	142	7	92	1	38	178	156083	156224	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	1027	217	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12812670	12812670	PRJEB41113_S_NODE_8451_length_166_cov_2.643411_g8442_i0	PRJEB41113	8451	166	2.643411	4.38806226	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	237	3.58e-58	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g8442	i0	96.503	307.518072289157	143	5	86	0	22	164	53934	53792	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	51048	237	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
13743327	13743327	PRJEB41113_S_NODE_14651_length_151_cov_1.938596_g14642_i0	PRJEB41113	14651	151	1.938596	2.92727996	Fusobacterium	848	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2704977725\|gb\|CP077125.1\|	851	g14642	i0	100	100	151	0	100	0	1	151	1110234	1110384	Fusobacterium nucleatum strain KCOM3714 chromosome, complete genome	blastn	15100	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
15017701	15017701	PRJEB41113_S_NODE_5532_length_184_cov_1.544218_g5523_i0	PRJEB41113	5532	184	1.544218	2.84136112	Fusobacterium	848	Bacteria	Bacteria	292	8.490000000000001e-75	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g5523	i0	99.379	87.5	161	1	88	0	24	184	416329	416169	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	16100	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
17567642	17567642	PRJEB41113_S_NODE_10734_length_158_cov_1.471074_g10725_i0	PRJEB41113	10734	158	1.471074	2.32429692	Leptotrichia	32067	Bacteria	Bacteria	255	9.27e-64	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g10725	i0	99.291	4.6772151898734204	141	1	89	0	1	141	696774	696634	Leptotrichia sp. oral taxon 498, complete genome	blastn	739	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
18841555	18841555	PRJEB41113_S_NODE_9175_length_163_cov_1.801587_g9166_i0	PRJEB41113	9175	163	1.801587	2.93658681	Fusobacterium	848	Bacteria	Bacteria	300	4.39e-77	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g9166	i0	100	8.94478527607362	162	0	99	0	1	162	353332	353493	Fusobacterium hwasookii ChDC F174, complete genome	blastn	1458	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
20116403	20116403	PRJEB41113_S_NODE_13716_length_152_cov_3.800000_g13707_i0	PRJEB41113	13716	152	3.8	5.776	Fusobacterium	848	Bacteria	Bacteria	76.8	7.37e-10	NTclustered	gi\|1948622963\|gb\|CP066022.1\|	285729	g13707	i0	82.558	5.13157894736842	86	15	57	0	1	86	109117	109032	Fusobacterium canifelinum strain FDAARGOS_999 chromosome, complete genome	blastn	780	76.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium canifelinum
23011131	23011131	PRJEB41113_S_NODE_7579_length_171_cov_1.701493_g7570_i0	PRJEB41113	7579	171	1.701493	2.90955303	Fusobacterium nucleatum	851	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g7570	i0	100	99.4736842105263	171	0	100	0	1	171	1513063	1513233	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	17010	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
23942196	23942196	PRJEB41113_S_NODE_8359_length_166_cov_12.317829_g8350_i0	PRJEB41113	8359	166	12.317829	20.44759614	Fusobacterium	848	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g8350	i0	99.398	452.765060240964	166	1	100	0	1	166	91814	91649	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	75159	302	1	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);;