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

11 rows where bioproject = "PRJNA640143", 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
3707039	3707039	PRJNA640143_S_NODE_16643_length_214_cov_2.124294_g16433_i0	PRJNA640143	16643	214	2.124294	4.54598916	Turneriella	338321	Bacteria	Bacteria	167	6.449999999999999e-37	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g16433	i0	82.234	51.7757009345794	197	31	91	4	7	201	199	5	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	11080	167	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
10814029	10814029	PRJNA640143_S_NODE_19249_length_200_cov_1.742331_g19039_i0	PRJNA640143	19249	200	1.742331	3.484662	Pseudomonadati	3379134	Bacteria	Bacteria	108	2.81e-29	NR	WP_220125596.1	173	g19039	i0	94.6	10.11	56	3	84	0	168	1	1	56	WP_220125596.1 uroporphyrinogen-III synthase, partial [Leptospira interrogans]	diamond	2022	109	0.990825688073395	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
14639056	14639056	PRJNA640143_S_NODE_4872_length_372_cov_2.411940_g4662_i0	PRJNA640143	4872	372	2.41194	8.9724168	Spirochaetales bacterium	2026792	Bacteria	Bacteria	88.2	1.02e-19	NR	HQK35167.1	2026792	g4662	i0	69	0.467741935483871	58	16	46.8	1	27	200	62	117	HQK35167.1 DUF488 family protein [Spirochaetales bacterium]	diamond	174	88.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
17187883	17187883	PRJNA640143_S_NODE_24514_length_178_cov_2.368794_g24304_i0	PRJNA640143	24514	178	2.368794	4.21645332	Treponema vincentii	69710	Bacteria	Bacteria	241	2.99e-59	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g24304	i0	91.061	191.955056179775	179	15	100	1	1	178	2079861	2079683	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	34168	241	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27807763	27807763	PRJNA640143_S_NODE_11664_length_253_cov_8.250000_g11454_i0	PRJNA640143	11664	253	8.25	20.8725	Brevinematales bacterium	2614249	Bacteria	Bacteria	63.2	2.63e-9	NR	NPV38388.1	2614249	g11454	i0	55.4	0.66403162055336	56	25	66.4	0	1	168	20	75	NPV38388.1 MATE family efflux transporter [Brevinematales bacterium]	diamond	168	63.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brevinematales			Brevinematales bacterium
28249433	28249433	PRJNA640143_S_NODE_30906_length_155_cov_1.915254_g30696_i0	PRJNA640143	30906	155	1.915254	2.9686437	Gracilinema caldarium	215591	Bacteria	Bacteria	84.7	5.24e-18	NR	WP_304241208.1	215591	g30696	i0	97.6	0.793548387096774	41	1	79.4	0	131	9	256	296	WP_304241208.1 ATP-binding protein [Gracilinema caldarium]	diamond	123	84.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
28420106	28420106	PRJNA640143_S_NODE_28506_length_163_cov_1.960317_g28296_i0	PRJNA640143	28506	163	1.960317	3.19531671	root	1	Root_unresolved	Root_unresolved	52	6.91e-6	NR	WP_074640749.1	163	g28296	i0	100	11.0061349693252	23	0	42.3	0	69	1	562	584	WP_074640749.1 type I restriction-modification system subunit M [Treponema bryantii]	diamond	1794	52	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
28660166	28660166	PRJNA640143_S_NODE_13027_length_240_cov_7.960591_g12817_i0	PRJNA640143	13027	240	7.960591	19.1054184	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	111	3.63e-29	NR	MFA7019187.1	2791017	g12817	i0	86.1	0.9	72	9	90	1	235	20	78	148	MFA7019187.1 hypothetical protein [Sphaerochaetaceae bacterium]	diamond	216	111	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
29228611	29228611	PRJNA640143_S_NODE_889_length_734_cov_82.760402_g806_i0	PRJNA640143	889	734	82.760402	607.46135068	Spirochaetota bacterium	2202144	Bacteria	Bacteria	139	3e-36	NR	TXG81208.1	2202144	g806	i0	51.6	0.523160762942779	128	62	52.3	0	393	10	3	130	TXG81208.1 MAG: hypothetical protein E6R13_06675 [Spirochaetota bacterium]	diamond	384	139	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30567073	30567073	PRJNA640143_S_NODE_28933_length_162_cov_1.248000_g28723_i0	PRJNA640143	28933	162	1.248	2.02176	root	1	Root_unresolved	Root_unresolved	73.9	9.9e-16	NR	NBU99435.1	2053615	g28723	i0	86.1	1.33333333333333	36	5	66.7	0	161	54	8	43	NBU99435.1 hypothetical protein [Spirochaetia bacterium]	diamond	216	73.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31281625	31281625	PRJNA640143_S_NODE_22155_length_187_cov_1.820000_g21945_i0	PRJNA640143	22155	187	1.82	3.4034	Spirochaetes bacterium GWB1_27_13	1802173	Bacteria	Bacteria	59.7	1.31e-8	NR	OHD12876.1	1802173	g21945	i0	56.8	0.705882352941177	44	19	70.6	0	147	16	3	46	OHD12876.1 MAG: hypothetical protein A2Z98_14660 [Spirochaetes bacterium GWB1_27_13]	diamond	132	59.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_27_13

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