metadata: contig_metadata: 9 rows where bioproject = "PRJNA1199330", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA1199330", 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
1600693	1600693	PRJNA1199330_P_NODE_74022_length_278_cov_1.804878_g73323_i0	PRJNA1199330	74022	278	1.804878	5.01756084	Treponema socranskii	53419	Bacteria	Bacteria	486	5.919999999999998e-133	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g73323	i0	98.201	2.73381294964029	278	5	100	0	1	278	610081	609804	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	760	486	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
2877126	2877126	PRJNA1199330_P_NODE_89543_length_263_cov_3.236842_g88844_i0	PRJNA1199330	89543	263	3.236842	8.51289446	Treponema socranskii	53419	Bacteria	Bacteria	470	5.59e-128	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g88844	i0	98.859	3	263	3	100	0	1	263	160260	160522	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	789	470	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
13079486	13079486	PRJNA1199330_P_NODE_63451_length_287_cov_3.000000_g62752_i0	PRJNA1199330	63451	287	3	8.61	Treponema vincentii	69710	Bacteria	Bacteria	520	6.049999999999999e-143	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g62752	i0	99.303	3	287	2	100	0	1	287	2016594	2016308	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	861	520	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
26597413	26597413	PRJNA1199330_P_NODE_37721_length_337_cov_1.181818_g37022_i0	PRJNA1199330	37721	337	1.181818	3.98272666	Spirochaetota bacterium	2202144	Bacteria	Bacteria	73.9	3.56e-13	NR	TXG81208.1	2202144	g37022	i0	50	0.694362017804154	78	38	69.4	1	236	3	3	79	TXG81208.1 MAG: hypothetical protein E6R13_06675 [Spirochaetota bacterium]	diamond	234	73.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28020260	28020260	PRJNA1199330_P_NODE_23825_length_420_cov_3.161383_g23130_i0	PRJNA1199330	23825	420	3.161383	13.2778086	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	55.1	1.12e-5	NR	HMW07766.1	2026757	g23130	i0	54.5	0.957142857142857	44	20	31.4	0	4	135	73	116	HMW07766.1 NHL repeat-containing protein [Leptospiraceae bacterium]	diamond	402	55.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28240943	28240943	PRJNA1199330_P_NODE_60626_length_290_cov_1.437788_g59927_i0	PRJNA1199330	60626	290	1.437788	4.1695852	Leptospira semungkisensis	2484985	Bacteria	Bacteria	45.4	0.00688	NR	WP_167882131.1	2484985	g59927	i0	36.4	0.682758620689655	66	41	67.2	1	3	197	174	239	WP_167882131.1 NHL repeat-containing protein [Leptospira semungkisensis]	diamond	198	45.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira semungkisensis
30198705	30198705	PRJNA1199330_P_NODE_33172_length_359_cov_2.541958_g32475_i0	PRJNA1199330	33172	359	2.541958	9.12562922	Spirochaetota bacterium	2202144	Bacteria	Bacteria	61.2	4.26e-9	NR	UCB45765.1	2202144	g32475	i0	45.2	1.4958217270195	73	38	60.2	2	331	116	20	91	UCB45765.1 MAG: hypothetical protein JSV25_16440 [Spirochaetota bacterium]	diamond	537	61.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31810963	31810963	PRJNA1199330_P_NODE_110777_length_246_cov_0.901734_g110078_i0	PRJNA1199330	110777	246	0.901734	2.21826564	Spirochaetota bacterium	2202144	Bacteria	Bacteria	45.1	0.00604	NR	MCK4907454.1	2202144	g110078	i0	34	0.609756097560976	50	33	61	0	153	4	371	420	MCK4907454.1 hypothetical protein [Spirochaetota bacterium]	diamond	150	45.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32633032	32633032	PRJNA1199330_P_NODE_63140_length_288_cov_1.306977_g62441_i0	PRJNA1199330	63140	288	1.306977	3.76409376	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	76.3	1.01e-13	NR	MCB1176098.1	2026757	g62441	i0	50.5	0.96875	93	37	88.5	3	282	28	281	372	MCB1176098.1 NHL repeat-containing protein [Leptospiraceae bacterium]	diamond	279	76.3	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);;