metadata: contig_metadata: 24 rows where bioproject = "PRJNA773778", tax_phylum = "Spirochaetota" and tax

24 rows where bioproject = "PRJNA773778", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

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
751214	751214	PRJNA773778_S_NODE_34941_length_266_cov_1.595855_g34791_i0	PRJNA773778	34941	266	1.595855	4.2449743	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	385	2.11e-102	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g34791	i0	92.83	1.97368421052632	265	19	99	0	2	266	1841957	1842221	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	525	385	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
2027442	2027442	PRJNA773778_S_NODE_46342_length_243_cov_1.564706_g46192_i0	PRJNA773778	46342	243	1.564706	3.80223558	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	350	6.94e-92	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g46192	i0	92.593	1	243	18	100	0	1	243	170088	169846	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	243	350	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
4579209	4579209	PRJNA773778_S_NODE_26204_length_298_cov_1.471111_g26054_i0	PRJNA773778	26204	298	1.471111	4.38391078	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	507	4.92e-139	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g26054	i0	97.315	66.3791946308725	298	8	100	0	1	298	1429934	1430231	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	19781	507	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
5854636	5854636	PRJNA773778_S_NODE_28285_length_289_cov_2.680556_g28135_i0	PRJNA773778	28285	289	2.680556	7.74680684	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	346	1.1e-90	NTclustered	gi\|2621703508\|emb\|OY762555.1\|	886478	g28135	i0	88.276	12.0934256055363	290	33	100	1	1	289	392579	392290	MAG: uncultured Sphaerochaeta sp. isolate 0f2998e5-db78-43d4-b7f9-7484b9789d07 genome assembly, chromosome: 1	blastn	3495	346	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
5855032	5855032	PRJNA773778_S_NODE_44325_length_246_cov_0.890173_g44175_i0	PRJNA773778	44325	246	0.890173	2.18982558	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g44175	i0	97.154	1	246	7	100	0	1	246	2638227	2637982	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	246	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
7130314	7130314	PRJNA773778_S_NODE_6766_length_497_cov_1.247642_g6616_i0	PRJNA773778	6766	497	1.247642	6.20078074	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	662	0	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g6616	i0	90.744	1	497	45	100	1	1	497	1533442	1532947	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	497	662	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
10955772	10955772	PRJNA773778_S_NODE_8929_length_450_cov_1.748011_g8779_i0	PRJNA773778	8929	450	1.748011	7.8660495	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	676	0	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g8779	i0	93.778	1	450	28	100	0	1	450	519384	518935	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	450	676	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
13505116	13505116	PRJNA773778_S_NODE_41031_length_250_cov_1.265537_g40881_i0	PRJNA773778	41031	250	1.265537	3.1638425	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g40881	i0	98	2.944	250	5	100	0	1	250	2135729	2135480	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	736	435	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
14779756	14779756	PRJNA773778_S_NODE_24272_length_306_cov_2.600858_g24122_i0	PRJNA773778	24272	306	2.600858	7.95862548	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	255	2.03e-63	NTclustered	gi\|2621785465\|emb\|OY781923.1\|	2791017	g24122	i0	84.47	9.89542483660131	264	35	85	6	1	261	1662816	1663076	MAG: Sphaerochaetaceae bacterium isolate 77f26d43-b2b0-4d0d-8c29-067165085957 genome assembly, chromosome: 1	blastn	3028	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
15235775	15235775	PRJNA773778_S_NODE_37112_length_260_cov_1.037433_g36962_i0	PRJNA773778	37112	260	1.037433	2.6973258	Bacteria	2	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g36962	i0	100	117.738461538462	260	0	100	0	1	260	317371	317630	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	30612	481	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
17329266	17329266	PRJNA773778_S_NODE_23434_length_310_cov_4.413502_g23284_i0	PRJNA773778	23434	310	4.413502	13.6818562	Sphaerochaeta associata	1129264	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|2221097576\|gb\|CP094929.1\|	1129264	g23284	i0	100	13.058064516129	310	0	100	0	1	310	1703963	1704272	Sphaerochaeta associata strain GLS2T chromosome, complete genome	blastn	4048	573	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta associata
18602462	18602462	PRJNA773778_S_NODE_10195_length_427_cov_1.737288_g10045_i0	PRJNA773778	10195	427	1.737288	7.41821976	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	542	2e-149	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g10045	i0	89.81	0.988290398126464	422	43	99	0	6	427	3164292	3164713	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	422	542	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
18603081	18603081	PRJNA773778_S_NODE_38735_length_255_cov_1.269231_g38585_i0	PRJNA773778	38735	255	1.269231	3.23653905	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	363	9.419999999999998e-96	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g38585	i0	92.49	0.992156862745098	253	19	99	0	3	255	565794	565542	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	253	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
22428478	22428478	PRJNA773778_S_NODE_32238_length_275_cov_1.500000_g32088_i0	PRJNA773778	32238	275	1.5	4.125	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	425	1.29e-114	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g32088	i0	94.545	12.3563636363636	275	15	100	0	1	275	3187352	3187626	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	3398	425	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
23703734	23703734	PRJNA773778_S_NODE_16079_length_357_cov_9.968310_g15929_i0	PRJNA773778	16079	357	9.96831	35.5868667	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	538	2.1299999999999992e-148	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g15929	i0	93.838	13.3725490196078	357	22	100	0	1	357	1368227	1368583	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	4774	538	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
23704440	23704440	PRJNA773778_S_NODE_46859_length_243_cov_0.905882_g46709_i0	PRJNA773778	46859	243	0.905882	2.20129326	uncultured Sphaerochaeta sp.	886478	Bacteria	Bacteria	370	5.32e-98	NTclustered	gi\|2621705266\|emb\|OY763408.1\|	886478	g46709	i0	94.215	0.995884773662551	242	14	99	0	2	243	2847027	2847268	MAG: uncultured Sphaerochaeta sp. isolate a535b126-96cf-44a5-a161-074881f659df genome assembly, chromosome: 1	blastn	242	370	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
25434058	25434058	PRJNA773778_S_NODE_7560_length_477_cov_2.658416_g7410_i0	PRJNA773778	7560	477	2.658416	12.68064432	Treponema	157	Bacteria	Bacteria	835	0	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g7410	i0	99.563	187.333333333333	458	2	96	0	20	477	2079374	2079831	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	89358	835	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28547424	28547424	PRJNA773778_S_NODE_8107_length_465_cov_8.806122_g7957_i0	PRJNA773778	8107	465	8.806122	40.9484673	Treponema	157	Bacteria	Bacteria	160	6.93e-46	NR	WP_016523092.1	58231	g7957	i0	53.1	3.59354838709677	143	67	92.3	0	3	431	103	245	WP_016523092.1 endo alpha-1,4 polygalactosaminidase [Treponema medium]	diamond	1671	160	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
29200902	29200902	PRJNA773778_S_NODE_18169_length_341_cov_1.522388_g18019_i0	PRJNA773778	18169	341	1.522388	5.19134308	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	193	1.52e-58	NR	HAP56821.1	1972642	g18019	i0	81.4	0.994134897360704	113	21	99.4	0	3	341	75	187	HAP56821.1 hypothetical protein [Sphaerochaeta sp.]	diamond	339	193	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
29610886	29610886	PRJNA773778_S_NODE_34430_length_268_cov_1.184615_g34280_i0	PRJNA773778	34430	268	1.184615	3.1747682	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	71.2	5.8e-13	NR	MEA4859442.1	1972642	g34280	i0	55.6	0.805970149253731	72	31	79.5	1	215	3	112	183	MEA4859442.1 hypothetical protein [Sphaerochaeta sp.]	diamond	216	71.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
29841748	29841748	PRJNA773778_S_NODE_12711_length_392_cov_3.884013_g12561_i0	PRJNA773778	12711	392	3.884013	15.22533096	Bacteria candidate phyla	1783234	Bacteria	Bacteria	139	1.08e-39	NR	MCR4821470.1	166	g12561	i0	59.3	8.41836734693878	123	47	92.6	2	383	21	3	124	MCR4821470.1 desulfoferrodoxin [Treponema sp.]	diamond	3300	140	0.992857142857143	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30179583	30179583	PRJNA773778_S_NODE_38712_length_255_cov_1.269231_g38562_i0	PRJNA773778	38712	255	1.269231	3.23653905	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	151	5.4e-46	NR	MEA5030908.1	1972642	g38562	i0	97.3	1.77647058823529	75	2	88.2	0	17	241	1	75	MEA5030908.1 glutaredoxin family protein [Sphaerochaeta sp.]	diamond	453	151	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
30274787	30274787	PRJNA773778_S_NODE_48712_length_241_cov_0.875000_g48562_i0	PRJNA773778	48712	241	0.875	2.10875	Borreliella bavariensis	664662	Bacteria	Bacteria	57.4	1.71e-8	NR	WP_223147374.1	664662	g48562	i0	43.8	0.796680497925311	64	36	79.7	0	209	18	2	65	WP_223147374.1 hypothetical protein, partial [Borreliella bavariensis]	diamond	192	57.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella bavariensis
30653500	30653500	PRJNA773778_S_NODE_35713_length_264_cov_1.209424_g35563_i0	PRJNA773778	35713	264	1.209424	3.19287936	Spirochaetia bacterium	2053615	Bacteria	Bacteria	144	1.67e-40	NR	NCC12423.1	2053615	g35563	i0	95.1	0.920454545454545	81	4	92	0	263	21	212	292	NCC12423.1 RNA polymerase sigma factor RpoD/SigA [Spirochaetia bacterium]	diamond	243	144	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium

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