metadata: contig_metadata: 9 rows where bioproject = "PRJNA980587", tax_phylum = "Thermodesulfobacteriota" and tax

9 rows where bioproject = "PRJNA980587", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

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
2231588	2231588	PRJNA980587_P_NODE_84982_length_247_cov_0.885057_g84189_i0	PRJNA980587	84982	247	0.885057	2.18609079	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2108215174\|gb\|CP070700.1\|	2049433	g84189	i0	100	0.11336032388664	28	0	11	0	26	53	4404117	4404090	MAG: Desulfobacteraceae bacterium isolate bin575 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
7333376	7333376	PRJNA980587_P_NODE_40206_length_368_cov_1.023729_g39413_i0	PRJNA980587	40206	368	1.0237289999999999	3.76732272	Bacteria	2	Bacteria	Bacteria	174	1.99e-51	NR	NSW86292.1	2052185	g39413	i0	72.8	5.59239130434783	114	31	92.9	0	345	4	3	116	NSW86292.1 bifunctional 5,10-methylene-tetrahydrofolate dehydrogenase/5,10-methylene-tetrahydrofolate cyclohydrolase [Syntrophobacteraceae bacterium]	diamond	2058	174	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
17534207	17534207	PRJNA980587_P_NODE_85554_length_247_cov_0.885057_g84761_i0	PRJNA980587	85554	247	0.885057	2.18609079	Geobacter	28231	Bacteria	Bacteria	115	3.7199999999999995e-30	NR	WP_010942565.1	35554	g84761	i0	64.2	5.8663967611336	81	29	98.4	0	3	245	74	154	WP_010942565.1 translation elongation factor Ts [Geobacter sulfurreducens]	diamond	1449	115	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
27120730	27120730	PRJNA980587_P_NODE_84382_length_247_cov_1.614943_g83589_i0	PRJNA980587	84382	247	1.614943	3.98890921	Desulfosarcina widdelii	947919	Bacteria	Bacteria	54.7	1.63e-6	NR	WP_170302148.1	947919	g83589	i0	38.9	1.76113360323887	72	40	87.4	3	224	9	141	208	WP_170302148.1 glycosyltransferase family 8 protein [Desulfosarcina widdelii]	diamond	435	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina widdelii
28485129	28485129	PRJNA980587_P_NODE_81726_length_249_cov_0.875000_g80933_i0	PRJNA980587	81726	249	0.875	2.17875	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	99.4	1.11e-22	NR	HSR10191.1	2202153	g80933	i0	58.7	1.85542168674699	75	31	90.4	0	3	227	124	198	HSR10191.1 radical SAM protein [Thermodesulfobacteriota bacterium]	diamond	462	99.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30221816	30221816	PRJNA980587_P_NODE_60752_length_291_cov_1.944954_g59959_i0	PRJNA980587	60752	291	1.944954	5.65981614	Desulfobulbales	3024411	Bacteria	Bacteria	66.2	2.57e-10	NR	RZW19106.1	2053307	g59959	i0	35.4	1.97938144329897	96	39	99	1	290	3	227	299	RZW19106.1 MAG: carbon-nitrogen hydrolase family protein [Desulfobulbaceae bacterium]	diamond	576	66.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
30342696	30342696	PRJNA980587_P_NODE_74192_length_260_cov_1.529412_g73399_i0	PRJNA980587	74192	260	1.529412	3.9764712	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	49.3	1.28e-4	NR	MDX1707326.1	2044940	g73399	i0	38.7	0.715384615384615	62	37	70.4	1	255	73	41	102	MDX1707326.1 2-isopropylmalate synthase [Desulfobacterales bacterium]	diamond	186	49.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30563016	30563016	PRJNA980587_P_NODE_77193_length_253_cov_1.711111_g76400_i0	PRJNA980587	77193	253	1.711111	4.32911083	Syntrophobacterales bacterium	2282155	Bacteria	Bacteria	64.3	1.09e-9	NR	MCX7823504.1	2282155	g76400	i0	52.3	2.09881422924901	44	21	52.2	0	244	113	418	461	MCX7823504.1 DUF4214 domain-containing protein [Syntrophobacterales bacterium]	diamond	531	64.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales			Syntrophobacterales bacterium
31005669	31005669	PRJNA980587_P_NODE_26994_length_471_cov_3.291457_g26201_i0	PRJNA980587	26994	471	3.291457	15.50276247	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	75.9	1.07e-12	NR	MDP4979432.1	2044940	g26201	i0	46.5	0.452229299363057	71	37	45.2	1	471	259	353	422	MDP4979432.1 ATP-dependent protease ATPase subunit HslU [Desulfobacterales bacterium]	diamond	213	75.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales 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);;