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

11 rows where bioproject = "PRJNA395690", tax_kingdom = "Pseudomonadati" and tax_phylum = "Thermodesulfobacteriota"

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
411470	411470	PRJNA395690_P_NODE_14421_length_214_cov_1.781818_g14269_i0	PRJNA395690	14421	214	1.781818	3.81309052	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	209	1.06e-49	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g14269	i0	85.047	264.668224299065	214	23	99	8	4	214	1712020	1711813	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	56639	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
411710	411710	PRJNA395690_P_NODE_33641_length_163_cov_0.894737_g33489_i0	PRJNA395690	33641	163	0.894737	1.45842131	Desulfobulbus oralis	1986146	Bacteria	Bacteria	58.4	2.92e-4	NTclustered	gi\|1343450889\|gb\|CP021255.1\|	1986146	g33489	i0	80.22	1.14110429447853	91	6	91	7	1	85	1109050	1109134	Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome	blastn	186	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oralis
7456977	7456977	PRJNA395690_P_NODE_33606_length_163_cov_0.894737_g33454_i0	PRJNA395690	33606	163	0.894737	1.45842131	Desulfuromonadales	69541	Bacteria	Bacteria	189	9.92e-44	NTclustered	gi\|2304895958\|gb\|CP092109.1\|	2847045	g33454	i0	88.608	169.343558282209	158	14	96	4	8	163	1359638	1359793	Geoalkalibacter halelectricus strain SAP-1 chromosome	blastn	27603	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter halelectricus
20205281	20205281	PRJNA395690_P_NODE_6476_length_316_cov_2.411985_g6325_i0	PRJNA395690	6476	316	2.411985	7.6218726	Geobacter	28231	Bacteria	Bacteria	265	3.49e-66	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g6325	i0	89.524	125.351265822785	210	20	66	2	98	306	2783611	2783403	Geobacter sulfurreducens strain AM-1 genome	blastn	39611	265	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
27265079	27265079	PRJNA395690_P_NODE_32683_length_164_cov_0.886957_g32531_i0	PRJNA395690	32683	164	0.886957	1.45460948	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	97.4	5.72e-22	NR	MEN6472527.1	2052184	g32531	i0	83.3	1.97560975609756	54	9	98.8	0	162	1	108	161	MEN6472527.1 amidase [Syntrophaceae bacterium]	diamond	324	97.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
29081700	29081700	PRJNA395690_P_NODE_34008_length_162_cov_2.345133_g33856_i0	PRJNA395690	34008	162	2.345133	3.79911546	Pseudomonadati	3379134	Bacteria	Bacteria	78.6	2.86e-15	NR	MCB2226183.1	2528248	g33856	i0	69.8	11.6296296296296	53	16	98.1	0	161	3	742	794	MCB2226183.1 multidrug efflux RND transporter permease subunit [Desulfarculaceae bacterium]	diamond	1884	78.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
29176526	29176526	PRJNA395690_P_NODE_6669_length_312_cov_1.346008_g6517_i0	PRJNA395690	6669	312	1.346008	4.19954496	root	1	Root_unresolved	Root_unresolved	160	2.0199999999999998e-46	NR	WP_207690708.1	45656	g6517	i0	68	12.8269230769231	103	33	99	0	310	2	68	170	WP_207690708.1 DNA adenine methylase [Desulfonema limicola]	diamond	4002	161	0.993788819875776	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema limicola
30345406	30345406	PRJNA395690_P_NODE_12112_length_234_cov_1.405405_g11960_i0	PRJNA395690	12112	234	1.405405	3.2886477	Pseudomonadati	3379134	Bacteria	Bacteria	71.6	9.36e-14	NR	OGU10987.1	1798318	g11960	i0	73.9	3.55128205128205	46	12	59	0	91	228	1	46	OGU10987.1 MAG: GxxExxY protein [Geobacteraceae bacterium GWC2_58_44]	diamond	831	71.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium GWC2_58_44
30391775	30391775	PRJNA395690_P_NODE_29893_length_166_cov_0.871795_g29741_i0	PRJNA395690	29893	166	0.871795	1.4471797	Smithellaceae bacterium	2964540	Bacteria	Bacteria	59.7	4.29e-9	NR	HOX16423.1	2964540	g29741	i0	73	0.668674698795181	37	10	66.9	0	5	115	9	45	HOX16423.1 beta-propeller fold lactonase family protein [Smithellaceae bacterium]	diamond	111	59.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
30565713	30565713	PRJNA395690_P_NODE_35013_length_162_cov_0.902655_g34861_i0	PRJNA395690	35013	162	0.902655	1.4623011	Bacteria	2	Bacteria	Bacteria	65.1	1.59e-10	NR	WP_145023015.1	345631	g34861	i0	60.7	12.8518518518519	56	17	98.1	2	160	2	396	449	WP_145023015.1 exodeoxyribonuclease V subunit beta [Geobacter argillaceus]	diamond	2082	65.5	0.993893129770992	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter argillaceus
30801954	30801954	PRJNA395690_P_NODE_15514_length_206_cov_1.891720_g15362_i0	PRJNA395690	15514	206	1.89172	3.8969432	Geobacter sulfurreducens	35554	Bacteria	Bacteria	40.4	0.0441	NR	WP_235044949.1	35554	g15362	i0	35.6	0.859223300970874	59	36	83	1	182	12	4	62	WP_235044949.1 hypothetical protein [Geobacter sulfurreducens]	diamond	177	40.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens

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