metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA812715" 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
2500536	2500536	PRJNA812715_P_NODE_52942_length_367_cov_4.646259_g51144_i0	PRJNA812715	52942	367	4.646259	17.05177053	Cetobacterium	180162	Bacteria	Bacteria	555	2.1799999999999994e-153	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g51144	i0	95.677	85.5640326975477	347	12	94	3	1	346	479019	479363	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	31402	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3362644	3362644	PRJNA812715_P_NODE_105183_length_249_cov_1.647727_g103382_i0	PRJNA812715	105183	249	1.647727	4.10284023	Cetobacterium somerae	188913	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g103382	i0	99.598	1	249	1	100	0	1	249	102885	103133	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	249	455	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3364435	3364435	PRJNA812715_P_NODE_49703_length_384_cov_1.366559_g47906_i0	PRJNA812715	49703	384	1.366559	5.24758656	Cetobacterium somerae	188913	Bacteria	Bacteria	324	7.03e-84	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g47906	i0	82.124	1.00520833333333	386	61	99	5	3	384	1680928	1680547	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	386	324	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3776761	3776761	PRJNA812715_P_NODE_33183_length_513_cov_1.977273_g31404_i0	PRJNA812715	33183	513	1.977273	10.14341049	Cetobacterium	180162	Bacteria	Bacteria	907	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g31404	i0	99.798	79.6179337231969	494	1	96	0	20	513	1561229	1561722	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	40844	907	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4643474	4643474	PRJNA812715_P_NODE_97044_length_258_cov_1.016216_g95243_i0	PRJNA812715	97044	258	1.016216	2.62183728	Cetobacterium somerae	188913	Bacteria	Bacteria	422	1.55e-113	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g95243	i0	96.124	48.3643410852713	258	10	100	0	1	258	435604	435347	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	12478	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7190015	7190015	PRJNA812715_P_NODE_106746_length_248_cov_2.662857_g104945_i0	PRJNA812715	106746	248	2.662857	6.60388536	Fusobacterium perfoetens	852	Bacteria	Bacteria	366	7.05e-97	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g104945	i0	93.2	395.713709677419	250	15	100	2	1	248	301	550	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	98137	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
7602918	7602918	PRJNA812715_P_NODE_17966_length_827_cov_2.183024_g16419_i0	PRJNA812715	17966	827	2.183024	18.05360848	Cetobacterium	180162	Bacteria	Bacteria	1506	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g16419	i0	99.516	524.227327690447	827	4	100	0	1	827	279487	278661	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	433536	1506	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7603065	7603065	PRJNA812715_P_NODE_49006_length_388_cov_1.222222_g47209_i0	PRJNA812715	49006	388	1.222222	4.74222136	Cetobacterium	180162	Bacteria	Bacteria	667	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g47209	i0	97.68	15.5644329896907	388	9	100	0	1	388	1999199	1999586	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	6039	667	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8467873	8467873	PRJNA812715_P_NODE_95087_length_260_cov_2.737968_g93286_i0	PRJNA812715	95087	260	2.737968	7.1187168	Cetobacterium somerae	188913	Bacteria	Bacteria	209	1.33e-49	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g93286	i0	82.329	4.78846153846154	249	36	95	7	13	259	937568	937326	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1245	209	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10153639	10153639	PRJNA812715_P_NODE_54708_length_360_cov_0.905923_g52909_i0	PRJNA812715	54708	360	0.905923	3.2613228	Fusobacterium	848	Bacteria	Bacteria	508	1.68e-139	NTclustered	gi\|2705042081\|gb\|CP085192.1\|	856	g52909	i0	92.201	510.641666666667	359	28	99	0	1	359	3422214	3422572	Fusobacterium varium strain SB069 chromosome	blastn	183831	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
10153762	10153762	PRJNA812715_P_NODE_70188_length_306_cov_1.321888_g68388_i0	PRJNA812715	70188	306	1.321888	4.04497728	Cetobacterium	180162	Bacteria	Bacteria	385	2.48e-102	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g68388	i0	89.735	43.7581699346405	302	30	98	1	4	304	1485314	1485013	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	13390	385	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11017578	11017578	PRJNA812715_P_NODE_55249_length_357_cov_1.989437_g53450_i0	PRJNA812715	55249	357	1.989437	7.10229009	Cetobacterium somerae	188913	Bacteria	Bacteria	383	1.0599999999999996e-101	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g53450	i0	86.325	4.92436974789916	351	48	98	0	7	357	535182	534832	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1758	383	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12291257	12291257	PRJNA812715_P_NODE_113870_length_245_cov_0.895349_g112069_i0	PRJNA812715	113870	245	0.895349	2.19360505	Cetobacterium somerae	188913	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g112069	i0	99.592	2.80408163265306	245	1	100	0	1	245	1658808	1659052	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	687	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12704794	12704794	PRJNA812715_P_NODE_80230_length_284_cov_1.450237_g78430_i0	PRJNA812715	80230	284	1.450237	4.11867308	Cetobacterium	180162	Bacteria	Bacteria	392	1.3599999999999997e-104	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g78430	i0	91.549	5	284	24	100	0	1	284	1777470	1777753	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1420	392	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13565619	13565619	PRJNA812715_P_NODE_113731_length_245_cov_0.895349_g111930_i0	PRJNA812715	113731	245	0.895349	2.19360505	Cetobacterium somerae	188913	Bacteria	Bacteria	292	1.2e-74	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g111930	i0	88.43	3.95102040816327	242	28	99	0	2	243	1998074	1997833	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	968	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13978737	13978737	PRJNA812715_P_NODE_29251_length_564_cov_5.195519_g27491_i0	PRJNA812715	29251	564	5.195519	29.30272716	Cetobacterium	180162	Bacteria	Bacteria	782	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g27491	i0	92.101	46.1205673758865	557	40	98	4	10	564	1485420	1484866	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	26012	782	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14841128	14841128	PRJNA812715_P_NODE_33292_length_512_cov_1.608200_g31513_i0	PRJNA812715	33292	512	1.6082	8.233984	Cetobacterium somerae	188913	Bacteria	Bacteria	911	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g31513	i0	98.828	332.919921875	512	4	100	2	1	512	1621656	1622165	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	170455	911	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15253267	15253267	PRJNA812715_P_NODE_76132_length_290_cov_4.543779_g74332_i0	PRJNA812715	76132	290	4.543779	13.1769591	Cetobacterium	180162	Bacteria	Bacteria	274	5.26e-69	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g74332	i0	83.959	5.05172413793103	293	39	99	7	2	290	1996929	1996641	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1465	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16114523	16114523	PRJNA812715_P_NODE_115833_length_244_cov_0.900585_g114032_i0	PRJNA812715	115833	244	0.900585	2.1974274	Cetobacterium somerae	188913	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|2201062202\|gb\|CP092524.1\|	188913	g114032	i0	99.539	0.889344262295082	217	1	89	0	28	244	9413	9197	Cetobacterium somerae strain CS2105-BJ plasmid unnamed5, complete sequence	blastn	217	396	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16527415	16527415	PRJNA812715_P_NODE_100733_length_252_cov_1.664804_g98932_i0	PRJNA812715	100733	252	1.664804	4.19530608	Cetobacterium	180162	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g98932	i0	98.81	17.8055555555556	252	3	100	0	1	252	1902446	1902697	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4487	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16527718	16527718	PRJNA812715_P_NODE_44033_length_417_cov_2.188953_g42238_i0	PRJNA812715	44033	417	2.188953	9.12793401	Cetobacterium	180162	Bacteria	Bacteria	667	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g42238	i0	95.683	7.01678657074341	417	15	99	3	1	416	899220	898806	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2926	667	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16527771	16527771	PRJNA812715_P_NODE_52413_length_370_cov_1.582492_g50615_i0	PRJNA812715	52413	370	1.582492	5.8552204	Cetobacterium	180162	Bacteria	Bacteria	684	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g50615	i0	100	19.0972972972973	370	0	100	0	1	370	1903167	1903536	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	7066	684	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17390293	17390293	PRJNA812715_P_NODE_110634_length_246_cov_2.387283_g108833_i0	PRJNA812715	110634	246	2.387283	5.87271618	Fusobacterium animalis	76859	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|2921506950\|gb\|CP159326.1\|	76859	g108833	i0	98.734	113.955284552846	237	3	96	0	1	237	747711	747947	Fusobacterium animalis strain CTI-3 chromosome, complete genome	blastn	28033	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
19076629	19076629	PRJNA812715_P_NODE_49435_length_385_cov_2.451923_g47638_i0	PRJNA812715	49435	385	2.451923	9.43990355	Cetobacterium	180162	Bacteria	Bacteria	651	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g47638	i0	97.143	6.01298701298701	385	11	100	0	1	385	1901166	1901550	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2315	651	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19940426	19940426	PRJNA812715_P_NODE_56616_length_352_cov_0.892473_g54817_i0	PRJNA812715	56616	352	0.892473	3.14150496	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g54817	i0	100	0.0823863636363636	29	0	8	0	164	192	1605961	1605989	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	29	54.7	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
20351229	20351229	PRJNA812715_P_NODE_27516_length_592_cov_1.483622_g25768_i0	PRJNA812715	27516	592	1.483622	8.78304224	Cetobacterium	180162	Bacteria	Bacteria	861	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g25768	i0	92.905	7.39864864864865	592	42	100	0	1	592	1776319	1776910	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4380	861	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20351390	20351390	PRJNA812715_P_NODE_52536_length_369_cov_3.084459_g50738_i0	PRJNA812715	52536	369	3.084459	11.38165371	Cetobacterium	180162	Bacteria	Bacteria	597	3.589999999999999e-166	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g50738	i0	95.924	66.8970189701897	368	15	99	0	2	369	1582814	1583181	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	24685	597	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22488766	22488766	PRJNA812715_P_NODE_111658_length_246_cov_0.890173_g109857_i0	PRJNA812715	111658	246	0.890173	2.18982558	Fusobacterium polymorphum	76857	Bacteria	Bacteria	453	5.2100000000000006e-123	NTclustered	gi\|2706478279\|gb\|CP084139.1\|	76857	g109857	i0	100	416.560975609756	245	0	99	0	2	246	2285767	2286011	Fusobacterium polymorphum strain KCOM3210 chromosome, complete genome	blastn	102474	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
22902600	22902600	PRJNA812715_P_NODE_47758_length_394_cov_3.809969_g45961_i0	PRJNA812715	47758	394	3.809969	15.01127786	Fusobacterium	848	Bacteria	Bacteria	566	1.09e-156	NTclustered	gi\|2446175567\|gb\|CP117964.1\|	851	g45961	i0	92.893	498.002538071066	394	21	100	3	1	394	1534170	1534556	Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome	blastn	196213	571	0.991243432574431	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
24176923	24176923	PRJNA812715_P_NODE_77879_length_288_cov_1.181395_g76079_i0	PRJNA812715	77879	288	1.181395	3.4024176	Cetobacterium	180162	Bacteria	Bacteria	438	1.7499999999999995e-118	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g76079	i0	94.406	4.96527777777778	286	15	99	1	1	286	1858306	1858590	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1430	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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