metadata: contig_metadata: 12 rows where bioproject = "PRJNA694770", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA694770", tax_kingdom = "Pseudomonadati" 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
6285261	6285261	PRJNA694770_P_NODE_85085_length_248_cov_0.880000_g84791_i0	PRJNA694770	85085	248	0.88	2.1824	Treponema	157	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g84791	i0	99.194	18.0282258064516	248	2	100	0	1	248	2679387	2679634	Treponema denticola strain CD-1 chromosome, complete genome	blastn	4471	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
7054066	7054066	PRJNA694770_P_NODE_77306_length_252_cov_1.139665_g77012_i0	PRJNA694770	77306	252	1.139665	2.8719558	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	453	5.36e-123	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g77012	i0	99.206	12.9206349206349	252	0	100	2	1	252	2361026	2361275	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	3256	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
8326676	8326676	PRJNA694770_P_NODE_100627_length_240_cov_2.305389_g100333_i0	PRJNA694770	100627	240	2.305389	5.5329336	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	161	3.4399999999999996e-35	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g100333	i0	81.818	1.59583333333333	198	30	81	6	19	213	217649	217455	Leptospira sp. severe_002 chromosome 1	blastn	383	161	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
8834322	8834322	PRJNA694770_P_NODE_92727_length_244_cov_1.356725_g92433_i0	PRJNA694770	92727	244	1.356725	3.310409	Treponema	157	Bacteria	Bacteria	363	8.949999999999999e-96	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g92433	i0	93.776	9.93852459016393	241	15	99	0	1	241	1530932	1531172	Treponema sp. OMZ 838, complete genome	blastn	2425	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
9603249	9603249	PRJNA694770_P_NODE_54468_length_287_cov_2.990654_g54174_i0	PRJNA694770	54468	287	2.990654	8.58317698	Treponema sp. OMZ 305	1659192	Bacteria	Bacteria	296	1.11e-75	NTclustered	gi\|2265133351\|gb\|CP051300.1\|	1659192	g54174	i0	85.315	0.996515679442509	286	42	99	0	2	287	1497369	1497654	Treponema sp. OMZ 305 chromosome, complete genome	blastn	286	296	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 305
13429647	13429647	PRJNA694770_P_NODE_93991_length_244_cov_0.900585_g93697_i0	PRJNA694770	93991	244	0.900585	2.1974274	Treponema socranskii	53419	Bacteria	Bacteria	311	3.29e-80	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g93697	i0	89.712	1.99180327868852	243	25	99	0	1	243	1622896	1622654	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	486	311	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
15978199	15978199	PRJNA694770_P_NODE_79033_length_251_cov_0.865169_g78739_i0	PRJNA694770	79033	251	0.865169	2.17157419	Candidatus Gallitreponema excrementavium	2840840	Bacteria	Bacteria	162	1.73e-46	NR	MBO8457604.1	2840840	g78739	i0	100	0.99203187250996006	83	0	99.2	0	250	2	174	256	MBO8457604.1 cell division protein FtsZ [Candidatus Gallitreponema excrementavium]	diamond	249	162	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales		Candidatus Gallitreponema	Candidatus Gallitreponema excrementavium
17758913	17758913	PRJNA694770_P_NODE_73574_length_258_cov_1.416216_g73280_i0	PRJNA694770	73574	258	1.416216	3.65383728	Treponema	157	Bacteria	Bacteria	411	3.36e-110	NTclustered	gi\|719625061\|gb\|CP009227.1\|	1539298	g73280	i0	95.686	6.95348837209302	255	11	99	0	1	255	173275	173529	Treponema sp. OMZ 838, complete genome	blastn	1794	414	0.992753623188406	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
24132895	24132895	PRJNA694770_P_NODE_70879_length_262_cov_2.317460_g70585_i0	PRJNA694770	70879	262	2.31746	6.0717452	Treponema	157	Bacteria	Bacteria	368	2.09e-97	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g70585	i0	91.985	2	262	21	100	0	1	262	1012803	1012542	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	524	368	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27998776	27998776	PRJNA694770_P_NODE_65065_length_272_cov_1.170854_g64771_i0	PRJNA694770	65065	272	1.170854	3.18472288	Leptospira kmetyi	408139	Bacteria	Bacteria	114	2.87e-28	NR	WP_010572207.1	408139	g64771	i0	63.4	5.45955882352941	82	30	90.4	0	1	246	258	339	WP_010572207.1 uroporphyrinogen decarboxylase family protein [Leptospira kmetyi]	diamond	1485	114	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kmetyi
30777749	30777749	PRJNA694770_P_NODE_100094_length_241_cov_0.916667_g99800_i0	PRJNA694770	100094	241	0.916667	2.20916747	Candidatus Ornithospirochaeta stercorigallinarum	2840898	Bacteria	Bacteria	79.7	1.64e-15	NR	HIS13673.1	2840898	g99800	i0	100	7.65560165975104	41	0	51	0	123	1	1	41	HIS13673.1 WYL domain-containing transcriptional regulator [Candidatus Ornithospirochaeta stercorigallinarum]	diamond	1845	79.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Candidatus Ornithospirochaeta	Candidatus Ornithospirochaeta stercorigallinarum
32800591	32800591	PRJNA694770_P_NODE_90900_length_245_cov_0.895349_g90606_i0	PRJNA694770	90900	245	0.895349	2.19360505	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	60.8	1.62e-9	NR	MFA7188517.1	2791017	g90606	i0	59.2	2.4	49	20	60	0	2	148	80	128	MFA7188517.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	588	60.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae 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);;