metadata: contig_metadata: 19 rows where bioproject = "PRJNA591127", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJNA591127", 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
4392577	4392577	PRJNA591127_P_NODE_2604_length_438_cov_3.715711_g2438_i0	PRJNA591127	2604	438	3.715711	16.27481418	Treponema phagedenis	162	Bacteria	Bacteria	363	1.72e-95	NTclustered	gi\|1732601887\|gb\|CP042818.1\|	162	g2438	i0	82.816	90.9360730593607	419	58	95	13	2	416	2502276	2502684	Treponema phagedenis strain B43.1 chromosome, complete genome	blastn	39830	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
4392647	4392647	PRJNA591127_P_NODE_3844_length_368_cov_4.586103_g3676_i0	PRJNA591127	3844	368	4.586103	16.87685904	Treponema denticola	158	Bacteria	Bacteria	339	2.3999999999999997e-88	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g3676	i0	90.076	162.1875	262	24	71	1	107	368	1664073	1664332	Treponema denticola strain OKA3 chromosome, complete genome	blastn	59685	339	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4967002	4967002	PRJNA591127_P_NODE_3524_length_383_cov_5.456647_g3356_i0	PRJNA591127	3524	383	5.456647	20.89895801	Treponema	157	Bacteria	Bacteria	697	0	NTclustered	gi\|14537945\|gb\|AF385536.1\|	163521	g3356	i0	99.478	102.819843342037	383	2	100	0	1	383	890	508	Treponema sp. oral clone BZ013 16S ribosomal RNA gene, partial sequence	blastn	39380	697	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. oral clone BZ013
5668924	5668924	PRJNA591127_P_NODE_6945_length_279_cov_3.925620_g6777_i0	PRJNA591127	6945	279	3.92562	10.9524798	Treponema medium	58231	Bacteria	Bacteria	470	5.99e-128	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g6777	i0	97.133	192.853046594982	279	6	100	1	1	279	1013061	1013337	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	53806	470	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
6242583	6242583	PRJNA591127_P_NODE_9285_length_241_cov_3.906863_g9117_i0	PRJNA591127	9285	241	3.906863	9.41553983	Treponema	157	Bacteria	Bacteria	213	9.4e-51	NTclustered	gi\|2023449428\|gb\|CP058315.1\|	138851	g9117	i0	82.645	89.4522821576764	242	40	100	2	1	241	1097702	1097462	Treponema parvum strain OMZ 843 chromosome, complete genome	blastn	21558	213	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
6943340	6943340	PRJNA591127_P_NODE_6626_length_286_cov_2.373494_g6458_i0	PRJNA591127	6626	286	2.373494	6.78819284	Treponema sp. oral taxon 264	712743	Bacteria	Bacteria	518	2.17e-142	NTclustered	gi\|285798864\|gb\|GU408846.1\|	712743	g6458	i0	99.301	100.244755244755	286	2	100	0	1	286	10	295	Treponema sp. oral taxon 264 clone JV018 16S ribosomal RNA gene, partial sequence	blastn	28670	518	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. oral taxon 264
8218346	8218346	PRJNA591127_P_NODE_3807_length_370_cov_7.732733_g3639_i0	PRJNA591127	3807	370	7.732733	28.6111121	Treponema sp. OMZ 803	120682	Bacteria	Bacteria	475	1.76e-129	NTclustered	gi\|2265127813\|gb\|CP051195.1\|	120682	g3639	i0	99.24	138.878378378378	263	2	71	0	1	263	2565571	2565309	Treponema sp. OMZ 803 strain BF2M chromosome, complete genome	blastn	51385	475	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 803
8791454	8791454	PRJNA591127_P_NODE_11227_length_219_cov_7.631868_g11058_i0	PRJNA591127	11227	219	7.631868	16.71379092	Treponema	157	Bacteria	Bacteria	403	4.64e-108	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g11058	i0	100	192.420091324201	218	0	99	0	1	218	326912	327129	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	42140	403	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
10067313	10067313	PRJNA591127_P_NODE_2028_length_487_cov_2.517778_g182_i1	PRJNA591127	2028	487	2.517778	12.26157886	Treponema	157	Bacteria	Bacteria	641	2.2199999999999993e-179	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g182	i1	90.447	203.505133470226	492	39	99	7	1	486	1475815	1476304	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	99107	641	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
12044225	12044225	PRJNA591127_P_NODE_27370_length_157_cov_0.900000_g27201_i0	PRJNA591127	27370	157	0.9	1.413	Treponema sp.	166	Bacteria	Bacteria	147	5.78e-31	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g27201	i0	83.439	3	157	26	100	0	1	157	1476317	1476161	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	471	147	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
12617915	12617915	PRJNA591127_P_NODE_28150_length_153_cov_2.051724_g27981_i0	PRJNA591127	28150	153	2.051724	3.13913772	Treponema	157	Bacteria	Bacteria	209	7.03e-50	NTclustered	gi\|2265154017\|gb\|CP051203.1\|	2563667	g27981	i0	91.503	188.575163398693	153	12	100	1	1	153	2352413	2352564	Treponema sp. OMZ 792 chromosome, complete genome	blastn	28852	209	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 792
13319117	13319117	PRJNA591127_P_NODE_5411_length_314_cov_13.386282_g5243_i0	PRJNA591127	5411	314	13.386282	42.03292548	Treponema sp. I:Q:AT20	76133	Bacteria	Bacteria	507	5.22e-139	NTclustered	gi\|3132611\|gb\|AF061347.1\|AF061347	76133	g5243	i0	97.01	104.433121019108	301	9	96	0	1	301	1	301	Treponema sp. I:Q:AT20 16S ribosomal RNA gene, complete sequence	blastn	32792	507	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. I:Q:AT20
13892782	13892782	PRJNA591127_P_NODE_2111_length_478_cov_5.907029_g1951_i0	PRJNA591127	2111	478	5.907029	28.23559862	Treponema	157	Bacteria	Bacteria	678	0	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g1951	i0	92.292	195.47280334728	480	34	100	3	1	478	1662308	1661830	Treponema denticola strain OKA3 chromosome, complete genome	blastn	93436	678	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
15867757	15867757	PRJNA591127_P_NODE_233_length_1103_cov_3.635084_g182_i0	PRJNA591127	233	1103	3.635084	40.09497652	Treponema parvum	138851	Bacteria	Bacteria	1277	0	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g182	i0	87.635	206.740707162285	1108	126	99	11	1	1102	454255	453153	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	228035	1277	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
17716845	17716845	PRJNA591127_P_NODE_9674_length_236_cov_5.447236_g9506_i0	PRJNA591127	9674	236	5.447236	12.85547696	Treponema	157	Bacteria	Bacteria	359	1.1099999999999999e-94	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g9506	i0	94.068	199.177966101695	236	14	100	0	1	236	704892	705127	Treponema bryantii JCM 32280 DNA, complete genome	blastn	47006	359	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
18416948	18416948	PRJNA591127_P_NODE_27115_length_158_cov_1.082645_g26946_i0	PRJNA591127	27115	158	1.082645	1.7105791	Treponema parvum	138851	Bacteria	Bacteria	217	4.38e-52	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g26946	i0	91.667	141.405063291139	156	13	99	0	3	158	1517574	1517419	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	22342	217	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
24090561	24090561	PRJNA591127_P_NODE_12059_length_212_cov_2.142857_g11890_i0	PRJNA591127	12059	212	2.142857	4.54285684	Treponema	157	Bacteria	Bacteria	370	4.53e-98	NTclustered	gi\|2215064718\|gb\|ON136463.1\|	59892	g11890	i0	98.113	102.646226415094	212	4	100	0	1	212	39	250	Treponema amylovorum isolate Otu62 16S ribosomal RNA gene, partial sequence	blastn	21761	370	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema amylovorum
32401262	32401262	PRJNA591127_P_NODE_639_length_779_cov_51.258760_g541_i0	PRJNA591127	639	779	51.25876	399.3057404	Pseudomonadati	3379134	Bacteria	Bacteria	133	1.63e-33	NR	MBP9887882.1	2026757	g541	i0	46.7	5.06033376123235	165	73	61.6	5	766	287	142	296	MBP9887882.1 STAS domain-containing protein [Leptospiraceae bacterium]	diamond	3942	134	0.992537313432836	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32514488	32514488	PRJNA591127_P_NODE_7159_length_274_cov_12.860759_g6991_i0	PRJNA591127	7159	274	12.860759	35.23847966	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	63.5	1.85e-9	NR	MBP9887882.1	2026757	g6991	i0	41.5	1.86131386861314	82	48	89.8	0	2	247	48	129	MBP9887882.1 STAS domain-containing protein [Leptospiraceae bacterium]	diamond	510	63.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae 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);;