metadata: contig_metadata: 12 rows where bioproject = "PRJNA1118794" and tax

12 rows where bioproject = "PRJNA1118794" 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
1024885	1024885	PRJNA1118794_P_NODE_31761_length_287_cov_2.855140_g31011_i0	PRJNA1118794	31761	287	2.85514	8.1942518	Leptotrichia	32067	Bacteria	Bacteria	510	3.64e-140	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g31011	i0	98.616	428.191637630662	289	2	100	2	1	287	499162	498874	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	122891	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
4057474	4057474	PRJNA1118794_P_NODE_3524_length_771_cov_5.044413_g2830_i0	PRJNA1118794	3524	771	5.044413	38.89242423	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1288	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2830	i0	96.879	486.618677042802	769	24	99	0	3	771	53524	52756	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	375183	1288	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4057793	4057793	PRJNA1118794_P_NODE_63284_length_245_cov_0.895349_g62534_i0	PRJNA1118794	63284	245	0.895349	2.19360505	Fusobacterium polymorphum	76857	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2706426664\|gb\|CP077146.1\|	76857	g62534	i0	99.592	69.7142857142857	245	1	100	0	1	245	200542	200298	Fusobacterium polymorphum strain KCOM2500 chromosome, complete genome	blastn	17080	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
4853044	4853044	PRJNA1118794_P_NODE_58344_length_247_cov_0.885057_g57594_i0	PRJNA1118794	58344	247	0.885057	2.18609079	Fusobacterium	848	Bacteria	Bacteria	364	2.519999999999999e-96	NTclustered	gi\|2705003210\|gb\|CP084117.1\|	851	g57594	i0	93.802	97.3724696356275	242	15	98	0	1	242	1685913	1686154	Fusobacterium nucleatum strain KCOM3486 chromosome, complete genome	blastn	24051	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
4853073	4853073	PRJNA1118794_P_NODE_71364_length_242_cov_0.911243_g70614_i0	PRJNA1118794	71364	242	0.911243	2.20520806	Fusobacterium	848	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g70614	i0	99.587	99.9876033057851	242	1	100	0	1	242	1565558	1565317	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	24197	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
6608896	6608896	PRJNA1118794_P_NODE_52826_length_249_cov_1.664773_g52076_i0	PRJNA1118794	52826	249	1.664773	4.14528477	Leptotrichia wadei	157687	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g52076	i0	100	23.2730923694779	249	0	100	0	1	249	1389775	1389527	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	5795	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
9158097	9158097	PRJNA1118794_P_NODE_10668_length_433_cov_2.938889_g9920_i0	PRJNA1118794	10668	433	2.938889	12.72538937	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	667	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g9920	i0	94.457	397	433	24	100	0	1	433	53522	53090	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	171901	667	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11709039	11709039	PRJNA1118794_P_NODE_1370_length_1254_cov_5.876376_g931_i0	PRJNA1118794	1370	1254	5.876376	73.68975504	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	2015	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g931	i0	96.263	451.47687400319	1231	42	98	4	1	1228	51560	52789	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	566152	2015	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14259353	14259353	PRJNA1118794_P_NODE_14772_length_378_cov_2.419672_g14022_i0	PRJNA1118794	14772	378	2.419672	9.14636016	Leptotrichia hofstadii	157688	Bacteria	Bacteria	693	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g14022	i0	99.735	441.830687830688	378	1	100	0	1	378	2455308	2454931	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	167012	693	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
20631949	20631949	PRJNA1118794_P_NODE_52617_length_249_cov_2.397727_g51867_i0	PRJNA1118794	52617	249	2.397727	5.97034023	Fusobacterium hominis	2764326	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1897733338\|gb\|CP060637.1\|	2764326	g51867	i0	100	517.052208835341	249	0	100	0	1	249	782806	782558	Fusobacterium hominis strain NSJ-57 chromosome, complete genome	blastn	128746	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hominis
24457184	24457184	PRJNA1118794_P_NODE_61700_length_246_cov_0.890173_g60950_i0	PRJNA1118794	61700	246	0.890173	2.18982558	Leptotrichia hofstadii	157688	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g60950	i0	97.49	2.05691056910569	239	6	97	0	8	246	1344157	1343919	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	506	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
31458672	31458672	PRJNA1118794_P_NODE_12916_length_400_cov_1.318043_g12166_i0	PRJNA1118794	12916	400	1.318043	5.272172	Fusobacterium perfoetens	852	Bacteria	Bacteria	45.4	0.00701	NR	WP_027129129.1	852	g12166	i0	33.3	0.45	60	39	44.3	1	78	254	36	95	WP_027129129.1 DMP19 family protein [Fusobacterium perfoetens]	diamond	180	45.4	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens

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