metadata: contig_metadata: 9 rows where bioproject = "PRJNA1148190" and tax

9 rows where bioproject = "PRJNA1148190" and tax_phylum = "Deferribacterota"

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
296713	296713	PRJNA1148190_P_NODE_509221_length_265_cov_1.203125_g498048_i0	PRJNA1148190	509221	265	1.203125	3.18828125	Calditerrivibrio nitroreducens	477976	Bacteria	Bacteria	63.9	1.12e-5	NTclustered	gi\|312938725\|gb\|CP002347.1\|	768670	g498048	i0	95	0.150943396226415	40	2	15	0	122	161	271140	271101	Calditerrivibrio nitroreducens DSM 19672, complete genome	blastn	40	63.9	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Calditerrivibrionaceae	Calditerrivibrio	Calditerrivibrio nitroreducens
24522848	24522848	PRJNA1148190_P_NODE_526360_length_261_cov_2.047872_g515187_i0	PRJNA1148190	526360	261	2.047872	5.34494592	Seleniivibrio woodruffii	1078050	Bacteria	Bacteria	172	1.84e-49	NR	WP_132871214.1	1078050	g515187	i0	100	0.988505747126437	86	0	98.9	0	3	260	76	161	WP_132871214.1 3-isopropylmalate dehydratase large subunit [Seleniivibrio woodruffii]	diamond	258	172	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Seleniivibrio	Seleniivibrio woodruffii
28587894	28587894	PRJNA1148190_P_NODE_82687_length_599_cov_1.671103_g71561_i0	PRJNA1148190	82687	599	1.671103	10.00990697	Geovibrio ferrireducens	46201	Bacteria	Bacteria	79.7	2.07e-15	NR	WP_265822537.1	46201	g71561	i0	37.3	1.6677796327212	118	65	57.1	3	411	70	4	116	WP_265822537.1 DUF1937 family protein [Geovibrio ferrireducens]	diamond	999	79.7	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Geovibrio	Geovibrio ferrireducens
28682461	28682461	PRJNA1148190_P_NODE_68407_length_677_cov_1.619205_g57335_i0	PRJNA1148190	68407	677	1.619205	10.96201785	Denitrovibrio sp.	2053308	Bacteria	Bacteria	265	4.43e-83	NR	PLX71804.1	2053308	g57335	i0	69.3	0.779911373707533	176	54	78	0	147	674	17	192	PLX71804.1 MAG: terminase [Denitrovibrio sp.]	diamond	528	265	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Denitrovibrio	Denitrovibrio sp.
28807837	28807837	PRJNA1148190_P_NODE_447268_length_277_cov_1.225490_g436095_i0	PRJNA1148190	447268	277	1.22549	3.3946073	Mucispirillum sp.	1965235	Bacteria	Bacteria	57.8	1.18e-8	NR	MDE7315507.1	1965235	g436095	i0	39.7	0.682310469314079	63	38	68.2	0	3	191	3	65	MDE7315507.1 integration host factor subunit beta [Mucispirillum sp.]	diamond	189	57.8	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Mucispirillaceae	Mucispirillum	Mucispirillum sp.
29743544	29743544	PRJNA1148190_P_NODE_708210_length_245_cov_0.895349_g697037_i0	PRJNA1148190	708210	245	0.895349	2.19360505	Geovibrio	46200	Bacteria	Bacteria	104	8.07e-24	NR	WP_265823064.1	46201	g697037	i0	66.2	1.88571428571429	77	25	93.1	1	244	17	538	614	WP_265823064.1 HD domain-containing phosphohydrolase [Geovibrio ferrireducens]	diamond	462	104	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Geovibrio	Geovibrio ferrireducens
30134686	30134686	PRJNA1148190_P_NODE_792112_length_240_cov_2.389222_g780939_i0	PRJNA1148190	792112	240	2.389222	5.7341328	Geovibrio sp.	2898799	Bacteria	Bacteria	100	8.05e-26	NR	MCD8568237.1	2898799	g780939	i0	73.1	0.8375	67	18	83.8	0	240	40	6	72	MCD8568237.1 hypothetical protein [Geovibrio sp.]	diamond	201	100	1	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Geovibrionaceae	Geovibrio	Geovibrio sp.
30165932	30165932	PRJNA1148190_P_NODE_503892_length_266_cov_1.196891_g492719_i0	PRJNA1148190	503892	266	1.196891	3.18373006	Deferribacterota bacterium	3031947	Bacteria	Bacteria	77.8	2.11e-16	NR	MDY6821389.1	3031947	g492719	i0	60.4	1.19548872180451	53	21	59.8	0	265	107	46	98	MDY6821389.1 co-chaperone GroES [Deferribacterota bacterium]	diamond	318	77.8	1	Bacteria	Pseudomonadati	Deferribacterota					Deferribacterota bacterium
30849479	30849479	PRJNA1148190_P_NODE_631754_length_249_cov_0.875000_g620581_i0	PRJNA1148190	631754	249	0.875	2.17875	Pseudomonadati	3379134	Bacteria	Bacteria	82.4	2.92e-18	NR	MDR2884721.1	2053543	g620581	i0	56.9	1.60240963855422	65	28	78.3	0	10	204	33	97	MDR2884721.1 type II toxin-antitoxin system RelE/ParE family toxin [Deferribacteraceae bacterium]	diamond	399	82.8	0.995169082125604	Bacteria	Pseudomonadati	Deferribacterota	Deferribacteres	Deferribacterales	Deferribacteraceae		Deferribacteraceae 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);;