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

16 rows where analysis = "blastn", bioproject = "PRJNA758088" and tax_phylum = "Spirochaetota"

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
1203779	1203779	PRJNA758088_P_NODE_33421_length_817_cov_1.189516_g27487_i0	PRJNA758088	33421	817	1.189516	9.71834572	Bacteria	2	Bacteria	Bacteria	1504	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g27487	i0	99.878	114.914320685435	817	1	100	0	1	817	316484	317300	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	93885	1504	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
2478995	2478995	PRJNA758088_P_NODE_273022_length_255_cov_1.269231_g266051_i0	PRJNA758088	273022	255	1.269231	3.23653905	root	1	Root_unresolved	Root_unresolved	472	1.5e-128	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g266051	i0	100	121.941176470588	255	0	100	0	1	255	312355	312101	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	31095	472	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
5031558	5031558	PRJNA758088_P_NODE_202764_length_299_cov_1.022124_g195793_i0	PRJNA758088	202764	299	1.022124	3.05615076	Bacteria	2	Bacteria	Bacteria	553	6.25e-153	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g195793	i0	100	93.6254180602007	299	0	100	0	1	299	314682	314980	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	27994	553	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
5841165	5841165	PRJNA758088_P_NODE_339125_length_244_cov_0.900585_g332154_i0	PRJNA758088	339125	244	0.900585	2.1974274	Brachyspira pilosicoli	52584	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2514077256\|gb\|CP098750.1\|	52584	g332154	i0	99.18	9.90983606557377	244	2	100	0	1	244	1683484	1683241	Brachyspira pilosicoli strain ZH1243 chromosome, complete genome	blastn	2418	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
7581577	7581577	PRJNA758088_P_NODE_28266_length_909_cov_1.729665_g22821_i0	PRJNA758088	28266	909	1.729665	15.72265485	Bacteria	2	Bacteria	Bacteria	1631	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g22821	i0	99.334	92.2222222222222	901	6	99	0	1	901	322075	322975	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	83830	1642	0.993300852618758	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
9664653	9664653	PRJNA758088_P_NODE_241428_length_274_cov_1.149254_g234457_i0	PRJNA758088	241428	274	1.149254	3.14895596	Treponema rectale	744512	Bacteria	Bacteria	195	3.95e-45	NTclustered	gi\|1919550644\|gb\|CP031517.1\|	744512	g234457	i0	79.487	0.996350364963504	273	56	99	0	1	273	240005	240277	Treponema rectale strain CHPA chromosome, complete genome	blastn	273	195	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema rectale
9665539	9665539	PRJNA758088_P_NODE_301648_length_249_cov_0.875000_g294677_i0	PRJNA758088	301648	249	0.875	2.17875	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	167	7.709999999999999e-37	NTclustered	gi\|2621786047\|emb\|OY782505.1\|	2791017	g294677	i0	82.888	0.751004016064257	187	30	75	2	41	226	2151850	2151665	MAG: Sphaerochaetaceae bacterium isolate dbdf49c1-f841-4570-9102-cd3a9ce64f89 genome assembly, chromosome: 1	blastn	187	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
16037041	16037041	PRJNA758088_P_NODE_12513_length_1477_cov_9.440883_g9473_i0	PRJNA758088	12513	1477	9.440883	139.44184191	Spirochaetota bacterium	2202144	Bacteria	Bacteria	171	4.01e-37	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g9473	i0	84.27	26.451591062965495	178	25	12	3	688	863	74549	74373	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	39069	171	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
16040062	16040062	PRJNA758088_P_NODE_322193_length_246_cov_0.890173_g315222_i0	PRJNA758088	322193	246	0.890173	2.18982558	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	198	2.7e-46	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g315222	i0	82.805	11.1991869918699	221	38	90	0	1	221	164233	164453	Treponema sp. OMZ 838, complete genome	blastn	2755	198	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
16506992	16506992	PRJNA758088_P_NODE_79593_length_476_cov_1.084367_g72628_i0	PRJNA758088	79593	476	1.084367	5.16158692	Bacteria	2	Bacteria	Bacteria	880	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g72628	i0	100	95.1008403361345	476	0	100	0	1	476	320476	320951	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	45268	880	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20330454	20330454	PRJNA758088_P_NODE_55036_length_593_cov_1.401923_g48226_i0	PRJNA758088	55036	593	1.401923	8.31340339	Bacteria	2	Bacteria	Bacteria	1090	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g48226	i0	99.831	110.414839797639	593	1	100	0	1	593	314051	314643	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	65476	1090	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20330498	20330498	PRJNA758088_P_NODE_64496_length_538_cov_1.402151_g57567_i0	PRJNA758088	64496	538	1.402151	7.54357238	Bacteria	2	Bacteria	Bacteria	989	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g57567	i0	99.814	118.998141263941	538	1	100	0	1	538	317981	317444	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	64021	989	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
21606303	21606303	PRJNA758088_P_NODE_7797_length_1846_cov_1.530175_g5806_i0	PRJNA758088	7797	1846	1.530175	28.2470305	Bacteria	2	Bacteria	Bacteria	3404	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g5806	i0	99.946	81.395991332611	1846	1	100	0	1	1846	318390	320235	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	150257	3404	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
22881115	22881115	PRJNA758088_P_NODE_25118_length_979_cov_2.200883_g20016_i0	PRJNA758088	25118	979	2.200883	21.54664457	root	1	Root_unresolved	Root_unresolved	1808	0	NTclustered	gi\|1318779104\|gb\|CP019600.1\|	159	g20016	i0	100	128.73544433095	979	0	100	0	1	979	2036504	2037482	Brachyspira hyodysenteriae strain BH718 chromosome, complete genome	blastn	126032	1808	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira hyodysenteriae
22881898	22881898	PRJNA758088_P_NODE_99678_length_420_cov_1.726225_g92708_i0	PRJNA758088	99678	420	1.726225	7.250145	Bacteria	2	Bacteria	Bacteria	776	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g92708	i0	100	75.0619047619048	420	0	100	0	1	420	316082	316501	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	31526	776	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
24155329	24155329	PRJNA758088_P_NODE_28779_length_899_cov_1.667070_g23276_i0	PRJNA758088	28779	899	1.66707	14.9869593	Bacteria	2	Bacteria	Bacteria	1661	0	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g23276	i0	100	115.202447163515	899	0	100	0	1	899	316081	315183	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	103567	1661	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola

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