metadata: contig_metadata: 15 rows where bioproject = "PRJNA695273" and tax

15 rows where bioproject = "PRJNA695273" 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
1182092	1182092	PRJNA695273_P_NODE_136521_length_248_cov_0.880000_g135763_i0	PRJNA695273	136521	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	387	5.409999999999998e-103	NTclustered	gi\|2265113193\|gb\|CP051148.1\|	69710	g135763	i0	95.102	5.92741935483871	245	12	99	0	2	246	990099	989855	Treponema vincentii strain OMZ 861 chromosome, complete genome	blastn	1470	387	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
2457476	2457476	PRJNA695273_P_NODE_153202_length_243_cov_0.905882_g152444_i0	PRJNA695273	153202	243	0.905882	2.20129326	Treponema	157	Bacteria	Bacteria	337	5.399999999999998e-88	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g152444	i0	91.736	9.95884773662551	242	20	99	0	2	243	2532902	2532661	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	2420	337	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
10110921	10110921	PRJNA695273_P_NODE_151748_length_243_cov_1.476471_g150990_i0	PRJNA695273	151748	243	1.476471	3.58782453	Leptospira	171	Bacteria	Bacteria	60.2	1.31e-4	NTclustered	gi\|167774246\|gb\|CP000777.1\|	355278	g150990	i0	100	0.263374485596708	32	0	13	0	133	164	3289532	3289563	Leptospira biflexa serovar Patoc strain 'Patoc 1 (Ames)' chromosome I, complete sequence	blastn	64	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira biflexa
11385667	11385667	PRJNA695273_P_NODE_140729_length_247_cov_0.885057_g139971_i0	PRJNA695273	140729	247	0.885057	2.18609079	Treponema	157	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g139971	i0	99.19	20.7894736842105	247	2	100	0	1	247	1114812	1114566	Treponema denticola strain CD-1 chromosome, complete genome	blastn	5135	446	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
13430600	13430600	PRJNA695273_P_NODE_127471_length_251_cov_0.865169_g126713_i0	PRJNA695273	127471	251	0.865169	2.17157419	Treponema denticola	158	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g126713	i0	99.203	193.382470119522	251	2	100	0	1	251	514267	514017	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	48539	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
19803404	19803404	PRJNA695273_P_NODE_115596_length_262_cov_1.328042_g114838_i0	PRJNA695273	115596	262	1.328042	3.47947004	Treponema socranskii	53419	Bacteria	Bacteria	484	1.99e-132	NTclustered	gi\|1868715119\|emb\|LR796240.1\|	69713	g114838	i0	100	3	262	0	100	0	1	262	820836	820575	Treponema socranskii subsp. buccale strain Marseille-CSURQ0203 genome assembly, chromosome: contig00001	blastn	786	484	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
24903469	24903469	PRJNA695273_P_NODE_144200_length_246_cov_0.890173_g143442_i0	PRJNA695273	144200	246	0.890173	2.18982558	Treponema denticola	158	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2265168914\|gb\|CP051304.1\|	158	g143442	i0	99.593	28.4024390243902	246	1	100	0	1	246	1823739	1823984	Treponema denticola strain CD-1 chromosome, complete genome	blastn	6987	449	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
27367430	27367430	PRJNA695273_P_NODE_159503_length_241_cov_0.916667_g158745_i0	PRJNA695273	159503	241	0.916667	2.20916747	Candidatus Thalassospirochaeta sargassi	3119039	Bacteria	Bacteria	71.6	2.61e-14	NR	MDC7226589.1	3119039	g158745	i0	76.2	1.59336099585062	42	10	52.3	0	5	130	35	76	MDC7226589.1 VF530 family protein [Candidiatus Thalassospirochaeta sargassi]	diamond	384	71.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Candidatus Thalassospirochaeta	Candidatus Thalassospirochaeta sargassi
27998807	27998807	PRJNA695273_P_NODE_104645_length_274_cov_1.950249_g103887_i0	PRJNA695273	104645	274	1.950249	5.34368226	Borrelia miyamotoi	47466	Bacteria	Bacteria	43.1	0.0393	NR	WP_020955019.1	47466	g103887	i0	32.9	0.897810218978102	82	48	86.5	3	273	37	170	247	WP_020955019.1 lysine--tRNA ligase [Borrelia miyamotoi]	diamond	246	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia miyamotoi
28187835	28187835	PRJNA695273_P_NODE_113486_length_264_cov_1.612565_g112728_i0	PRJNA695273	113486	264	1.612565	4.2571716	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	140	3.29e-38	NR	MBO5690896.1	1898206	g112728	i0	74.7	0.988636363636364	87	22	98.9	0	263	3	54	140	MBO5690896.1 hypothetical protein [Spirochaetaceae bacterium]	diamond	261	140	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29671779	29671779	PRJNA695273_P_NODE_74910_length_319_cov_1.252033_g74152_i0	PRJNA695273	74910	319	1.252033	3.99398527	Spirochaetae bacterium HGW-Spirochaetae-9	2013841	Bacteria	Bacteria	83.6	3.4e-16	NR	PKL03129.1	2013841	g74152	i0	33.6	3.67711598746082	131	59	96.9	1	317	9	92	222	PKL03129.1 MAG: serine/threonine protein kinase [Spirochaetae bacterium HGW-Spirochaetae-9]	diamond	1173	83.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetae bacterium HGW-Spirochaetae-9
29777929	29777929	PRJNA695273_P_NODE_141411_length_246_cov_1.780347_g140653_i0	PRJNA695273	141411	246	1.780347	4.37965362	root	1	Root_unresolved	Root_unresolved	54.7	2.4e-6	NR	MFO1471056.1	2717305	g140653	i0	33.3	3.80487804878049	84	54	100	1	1	246	151	234	MFO1471056.1 ELWxxDGT repeat protein [Turneriella sp.]	diamond	936	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella sp.
30725772	30725772	PRJNA695273_P_NODE_135834_length_248_cov_0.880000_g135076_i0	PRJNA695273	135834	248	0.88	2.1824	Treponema	157	Bacteria	Bacteria	102	4.25e-24	NR	WP_385982252.1	166	g135076	i0	64.6	2.9758064516129	82	26	99.2	1	247	2	161	239	WP_385982252.1 ATP-binding cassette domain-containing protein, partial [Treponema sp.]	diamond	738	103	0.990291262135922	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32169338	32169338	PRJNA695273_P_NODE_122318_length_254_cov_1.386740_g121560_i0	PRJNA695273	122318	254	1.38674	3.5223196	unclassified Treponema	2638727	Bacteria	Bacteria	107	9.96e-27	NR	WP_253715558.1	2638727	g121560	i0	65.1	2.03149606299213	86	24	94.5	1	13	252	67	152	WP_253715558.1 MULTISPECIES: ribonuclease HII [unclassified Treponema]	diamond	516	107	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
32390631	32390631	PRJNA695273_P_NODE_163359_length_200_cov_4.244094_g162601_i0	PRJNA695273	163359	200	4.244094	8.488188	Leptospira terpstrae	293075	Bacteria	Bacteria	82.4	2.22e-16	NR	WP_002973689.1	293075	g162601	i0	56.1	6.915	66	29	99	0	2	199	285	350	WP_002973689.1 MHYT domain-containing protein [Leptospira terpstrae]	diamond	1383	82.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira terpstrae

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