metadata: contig_metadata: 11 rows where bioproject = "PRJNA917598", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA917598", 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
9824738	9824738	PRJNA917598_P_NODE_78588_length_253_cov_1.283333_g77644_i0	PRJNA917598	78588	253	1.283333	3.24683249	Pseudomonadati	3379134	Bacteria	Bacteria	125	1.56e-32	NR	NCN08299.1	178	g77644	i0	87.1	15.8181818181818	70	9	83	0	37	246	1	70	NCN08299.1 polysaccharide biosynthesis protein [Leptospira sp.]	diamond	4002	125	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
21298453	21298453	PRJNA917598_P_NODE_59397_length_293_cov_1.068182_g58453_i0	PRJNA917598	59397	293	1.068182	3.12977326	Spirochaetota bacterium	2202144	Bacteria	Bacteria	213	1.18e-50	NTclustered	gi\|2621703426\|emb\|OY760686.1\|	2202144	g58453	i0	81.343	179	268	45	91	5	1	267	1927	2190	MAG: Spirochaetota bacterium isolate b615e79e-4617-45ea-95f9-f7a736470f88 genome assembly, chromosome: 1	blastn	52447	213	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
25123048	25123048	PRJNA917598_P_NODE_81460_length_250_cov_0.870056_g80516_i0	PRJNA917598	81460	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	146	6.6499999999999986e-40	NR	HON89143.1	2026792	g80516	i0	81.3	9.78	80	15	96	0	9	248	184	263	HON89143.1 phosphopyruvate hydratase [Spirochaetales bacterium]	diamond	2445	147	0.993197278911565	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28389919	28389919	PRJNA917598_P_NODE_64526_length_282_cov_2.559809_g63582_i0	PRJNA917598	64526	282	2.559809	7.21866138	Pseudomonadati	3379134	Bacteria	Bacteria	134	3.97e-35	NR	WP_167879896.1	2023178	g63582	i0	71.4	5.65957446808511	91	26	96.8	0	9	281	254	344	WP_167879896.1 restriction endonuclease subunit S [Leptospira levettii]	diamond	1596	134	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira levettii
28831919	28831919	PRJNA917598_P_NODE_41888_length_355_cov_1.003546_g40944_i0	PRJNA917598	41888	355	1.003546	3.5625883	Pseudomonadati	3379134	Bacteria	Bacteria	101	2.49e-22	NR	MBP6740861.1	2026757	g40944	i0	57.1	1.57183098591549	91	36	74.4	1	353	90	446	536	MBP6740861.1 AAA family ATPase [Leptospiraceae bacterium]	diamond	558	101	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29961448	29961448	PRJNA917598_P_NODE_70591_length_271_cov_1.090909_g69647_i0	PRJNA917598	70591	271	1.090909	2.95636339	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	100	1.86e-22	NR	HNF15221.1	2026757	g69647	i0	59.1	0.974169741697417	88	35	96.3	1	6	266	177	264	HNF15221.1 N-6 DNA methylase [Leptospiraceae bacterium]	diamond	264	100	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31320142	31320142	PRJNA917598_P_NODE_95175_length_241_cov_0.916667_g94231_i0	PRJNA917598	95175	241	0.916667	2.20916747	Spirochaetia bacterium	2053615	Bacteria	Bacteria	85.1	2.18e-19	NR	MFO7729640.1	2053615	g94231	i0	93.3	0.560165975103734	45	1	56	1	135	1	8	50	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	135	85.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31707019	31707019	PRJNA917598_P_NODE_72017_length_268_cov_1.158974_g71073_i0	PRJNA917598	72017	268	1.158974	3.10605032	Bacteria	2	Bacteria	Bacteria	108	2.6e-25	NR	MCL2443097.1	166	g71073	i0	62	30.4925373134328	79	30	88.4	0	263	27	679	757	MCL2443097.1 ATP-binding protein [Treponema sp.]	diamond	8172	109	0.990825688073395	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31762941	31762941	PRJNA917598_P_NODE_45557_length_340_cov_1.153558_g44613_i0	PRJNA917598	45557	340	1.153558	3.9220972	Leptospira bandrabouensis	2484903	Bacteria	Bacteria	51.2	1.02e-4	NR	WP_135781439.1	2484903	g44613	i0	33.7	2.39117647058824	92	54	75.9	3	261	4	94	184	WP_135781439.1 hypothetical protein [Leptospira bandrabouensis]	diamond	813	51.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira bandrabouensis
32206018	32206018	PRJNA917598_P_NODE_90258_length_244_cov_1.783626_g89314_i0	PRJNA917598	90258	244	1.783626	4.35204744	Exilispira sp.	2699745	Bacteria	Bacteria	95.5	9.5e-21	NR	HPC38877.1	2699745	g89314	i0	53.8	5.37295081967213	78	36	95.9	0	238	5	4	81	HPC38877.1 L-glutamate gamma-semialdehyde dehydrogenase [Exilispira sp.]	diamond	1311	95.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales		Exilispira	Exilispira sp.
32395841	32395841	PRJNA917598_P_NODE_32979_length_400_cov_2.082569_g32035_i0	PRJNA917598	32979	400	2.082569	8.330276	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	165	2.36e-44	NR	MBP6740310.1	2026757	g32035	i0	64.7	0.9975	133	44	99.8	2	1	399	146	275	MBP6740310.1 DEAD/DEAH box helicase [Leptospiraceae bacterium]	diamond	399	165	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);;