metadata: contig_metadata: 25 rows where bioproject = "PRJNA940501", tax_kingdom = "Pseudomonadati" and tax

25 rows where bioproject = "PRJNA940501", 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
9848844	9848844	PRJNA940501_S_NODE_344748_length_158_cov_2.121739_g343930_i0	PRJNA940501	344748	158	2.121739	3.35234762	Bacteria	2	Bacteria	Bacteria	92	4.99e-20	NR	OEU71707.1	1869308	g343930	i0	80.8	51.3607594936709	52	10	98.7	0	156	1	607	658	OEU71707.1 MAG: sodium-translocating pyrophosphatase [Desulfuromonadales bacterium C00003093]	diamond	8115	92.4	0.995670995670996	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium C00003093
12397399	12397399	PRJNA940501_S_NODE_150710_length_211_cov_1.648810_g149892_i0	PRJNA940501	150710	211	1.64881	3.4789891	Thermodesulfobacterium geofontis	1295609	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|334901311\|gb\|CP002829.1\|	795359	g149892	i0	100	0.132701421800948	28	0	13	0	31	58	1126701	1126674	Thermodesulfobacterium geofontis OPF15, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermodesulfobacterium	Thermodesulfobacterium geofontis
12398984	12398984	PRJNA940501_S_NODE_257050_length_177_cov_1.402985_g256232_i0	PRJNA940501	257050	177	1.402985	2.48328345	Geopsychrobacteraceae bacterium	3065857	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2621701823\|emb\|OY759353.1\|	3065857	g256232	i0	100	0.15819209039548	28	0	16	0	108	135	2192845	2192872	MAG: Geopsychrobacteraceae bacterium isolate b20cad9c-d1d2-40c5-8f7b-178437520c26 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae		Geopsychrobacteraceae bacterium
26930338	26930338	PRJNA940501_S_NODE_92502_length_243_cov_1.880000_g91684_i0	PRJNA940501	92502	243	1.88	4.5684	Syntrophobacterales bacterium	2282155	Bacteria	Bacteria	42.4	0.0482	NR	MDR2862138.1	2282155	g91684	i0	38.2	0.679012345679012	55	27	60.5	2	149	3	216	269	MDR2862138.1 [FeFe] hydrogenase H-cluster radical SAM maturase HydE [Syntrophobacterales bacterium]	diamond	165	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales			Syntrophobacterales bacterium
27151178	27151178	PRJNA940501_S_NODE_192342_length_195_cov_2.203947_g191524_i0	PRJNA940501	192342	195	2.203947	4.29769665	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	42.4	0.0253	NR	HVN96171.1	2660714	g191524	i0	62.5	0.369230769230769	24	9	36.9	0	164	93	41	64	HVN96171.1 hypothetical protein [Syntrophorhabdaceae bacterium]	diamond	72	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
27569120	27569120	PRJNA940501_S_NODE_203944_length_192_cov_0.946309_g203126_i0	PRJNA940501	203944	192	0.946309	1.81691328	Thermodesulfobacteriota	200940	Bacteria	Bacteria	65.9	1.32e-10	NR	MCF6290709.1	2044940	g203126	i0	61.2	6.28125	49	19	76.6	0	147	1	366	414	MCF6290709.1 diaminopimelate decarboxylase [Desulfobacterales bacterium]	diamond	1206	66.2	0.995468277945619	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
27727455	27727455	PRJNA940501_S_NODE_237864_length_182_cov_1.194245_g237046_i0	PRJNA940501	237864	182	1.194245	2.1735259	Pseudomonadati	3379134	Bacteria	Bacteria	97.8	1.36e-23	NR	WP_118230432.1	571438	g237046	i0	73.3	9.90659340659341	60	16	98.9	0	181	2	141	200	WP_118230432.1 NAD(P)-dependent oxidoreductase [Desulfovibrio legallii]	diamond	1803	97.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio legallii
27846374	27846374	PRJNA940501_S_NODE_322644_length_163_cov_0.975000_g321826_i0	PRJNA940501	322644	163	0.975	1.58925	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	40.4	0.0467	NR	WP_404827041.1	2802975	g321826	i0	59.3	0.496932515337423	27	11	49.7	0	8	88	85	111	WP_404827041.1 (deoxy)nucleoside triphosphate pyrophosphohydrolase [Desulfuromonas versatilis]	diamond	81	40.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
28320081	28320081	PRJNA940501_S_NODE_344526_length_158_cov_2.452174_g343708_i0	PRJNA940501	344526	158	2.452174	3.87443492	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	42.7	0.0116	NR	HEX9024673.1	2282154	g343708	i0	46.9	0.930379746835443	49	26	93	0	1	147	121	169	HEX9024673.1 NADH-quinone oxidoreductase subunit N [Geobacteraceae bacterium]	diamond	147	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
28674344	28674344	PRJNA940501_S_NODE_199947_length_193_cov_1.373333_g199129_i0	PRJNA940501	199947	193	1.373333	2.65053269	root	1	Root_unresolved	Root_unresolved	55.5	6.34e-7	NR	HPX55317.1	2928017	g199129	i0	51	5.48704663212435	51	25	79.3	0	175	23	78	128	HPX55317.1 heavy metal translocating P-type ATPase [Syntrophales bacterium]	diamond	1059	55.8	0.99462365591397806	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
29021953	29021953	PRJNA940501_S_NODE_282968_length_171_cov_1.101562_g282150_i0	PRJNA940501	282968	171	1.101562	1.88367102	Pseudomonadati	3379134	Bacteria	Bacteria	50.1	3.65e-5	NR	ETR74044.1	890399	g282150	i0	48.1	4.71929824561404	52	27	91.2	0	8	163	1649	1700	ETR74044.1 MAG: PAS sensor protein [Candidatus Magnetoglobus multicellularis str. Araruama]	diamond	807	50.4	0.994047619047619	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Candidatus Magnetoglobus	Candidatus Magnetoglobus multicellularis
29078010	29078010	PRJNA940501_S_NODE_103988_length_235_cov_2.067708_g103170_i0	PRJNA940501	103988	235	2.067708	4.8591138	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	42.4	0.0478	NR	MCP4337402.1	2053307	g103170	i0	43.4	0.676595744680851	53	25	65.1	2	184	32	928	977	MCP4337402.1 DDE-type integrase/transposase/recombinase [Desulfobulbaceae bacterium]	diamond	159	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
29488145	29488145	PRJNA940501_S_NODE_268470_length_174_cov_1.610687_g267652_i0	PRJNA940501	268470	174	1.610687	2.80259538	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	42.7	0.0103	NR	UCF83528.1	2049433	g267652	i0	44.4	0.775862068965517	45	25	77.6	0	160	26	129	173	UCF83528.1 MAG: NADH-quinone oxidoreductase subunit NuoE [Desulfobacteraceae bacterium]	diamond	135	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
29930584	29930584	PRJNA940501_S_NODE_101911_length_237_cov_0.969072_g101093_i0	PRJNA940501	101911	237	0.969072	2.29670064	Desulfomonile sp.	2793219	Bacteria	Bacteria	42.7	0.0338	NR	MEI6133460.1	2793219	g101093	i0	36.2	0.734177215189873	58	37	73.4	0	42	215	236	293	MEI6133460.1 hypothetical protein [Desulfomonile sp.]	diamond	174	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile sp.
30310086	30310086	PRJNA940501_S_NODE_386312_length_151_cov_1.740741_g385494_i0	PRJNA940501	386312	151	1.740741	2.62851891	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	45.4	9.9e-4	NR	MCG8619221.1	2044940	g385494	i0	48.6	0.735099337748344	37	19	73.5	0	31	141	37	73	MCG8619221.1 PTS sugar transporter subunit IIA [Desulfobacterales bacterium]	diamond	111	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30373137	30373137	PRJNA940501_S_NODE_241332_length_181_cov_1.362319_g240514_i0	PRJNA940501	241332	181	1.362319	2.46579739	Desulfarculus sp.	2093367	Bacteria	Bacteria	41.6	0.0421	NR	MBI4799901.1	2093367	g240514	i0	45.7	0.580110497237569	35	19	58	0	129	25	257	291	MBI4799901.1 methyltransferase domain-containing protein [Desulfarculus sp.]	diamond	105	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus sp.
30436195	30436195	PRJNA940501_S_NODE_124713_length_223_cov_2.627778_g123895_i0	PRJNA940501	124713	223	2.627778	5.85994494	Desulfopila sp. IMCC35	2212462	Bacteria	Bacteria	42	0.0428	NR	WP_136813869.1	2569542	g123895	i0	35.6	0.79372197309417	59	25	61.9	2	26	163	3	61	WP_136813869.1 TetR/AcrR family transcriptional regulator [Desulfopila sp. IMCC35006]	diamond	177	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfopila	Desulfopila sp. IMCC35006
30467868	30467868	PRJNA940501_S_NODE_6153_length_601_cov_3.496416_g5479_i0	PRJNA940501	6153	601	3.496416	21.01346016	Desulfofustis sp. PB-SRB1	1385624	Bacteria	Bacteria	93.2	1.11e-18	NR	MBL0380581.1	1385624	g5479	i0	75.5	1.76705490848586	49	12	24.5	0	600	454	289	337	MBL0380581.1 UDP-glucose 4-epimerase GalE [Desulfofustis sp. PB-SRB1]	diamond	1062	93.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfofustis	Desulfofustis sp. PB-SRB1
30695499	30695499	PRJNA940501_S_NODE_50233_length_284_cov_5.518672_g49415_i0	PRJNA940501	50233	284	5.518672	15.67302848	Bacteria	2	Bacteria	Bacteria	81.3	1.65e-15	NR	PIP40745.1	1973983	g49415	i0	58.7	7.15140845070423	63	18	61.3	2	279	106	436	495	PIP40745.1 MAG: leucyl aminopeptidase [Desulfobacterales bacterium CG23_combo_of_CG06-09_8_20_14_all_51_8]	diamond	2031	81.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium CG23_combo_of_CG06-09_8_20_14_all_51_8
30815043	30815043	PRJNA940501_S_NODE_204674_length_191_cov_2.500000_g203856_i0	PRJNA940501	204674	191	2.5	4.775	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	42.7	0.0185	NR	MEN8244401.1	2202153	g203856	i0	32	3.53403141361257	75	39	99	1	1	189	37	111	MEN8244401.1 cysteine desulfurase NifS [Thermodesulfobacteriota bacterium]	diamond	675	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31232515	31232515	PRJNA940501_S_NODE_131235_length_220_cov_1.819209_g130417_i0	PRJNA940501	131235	220	1.819209	4.0022598	Pseudomonadati	3379134	Bacteria	Bacteria	68.9	2.4e-12	NR	HME42439.1	2819264	g130417	i0	47.8	6.45	67	33	91.4	1	4	204	115	179	HME42439.1 lipocalin family protein [Syntrophorhabdales bacterium]	diamond	1419	68.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales			Syntrophorhabdales bacterium
32491425	32491425	PRJNA940501_S_NODE_161579_length_206_cov_3.490798_g160761_i0	PRJNA940501	161579	206	3.490798	7.19104388	Halodesulfovibrio aestuarii	126333	Bacteria	Bacteria	42	0.0422	NR	WP_371151377.1	126333	g160761	i0	43.1	0.742718446601942	51	28	72.8	1	196	47	148	198	WP_371151377.1 hypothetical protein [Halodesulfovibrio aestuarii]	diamond	153	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Halodesulfovibrio	Halodesulfovibrio aestuarii
32491436	32491436	PRJNA940501_S_NODE_198699_length_193_cov_2.153333_g197881_i0	PRJNA940501	198699	193	2.153333	4.15593269	Syntrophobacteraceae bacterium	2052185	Bacteria	Bacteria	42	0.0359	NR	MCU0573455.1	2052185	g197881	i0	34	0.730569948186529	47	28	73.1	1	35	175	9	52	MCU0573455.1 NAD-dependent epimerase/dehydratase family protein [Syntrophobacteraceae bacterium]	diamond	141	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
32586317	32586317	PRJNA940501_S_NODE_58219_length_274_cov_2.177489_g57401_i0	PRJNA940501	58219	274	2.177489	5.96631986	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	42.7	0.0494	NR	MCA1792716.1	2049433	g57401	i0	41.4	0.635036496350365	58	30	63.5	1	187	14	62	115	MCA1792716.1 HDOD domain-containing protein [Desulfobacteraceae bacterium]	diamond	174	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
32648723	32648723	PRJNA940501_S_NODE_190580_length_196_cov_1.516340_g189762_i0	PRJNA940501	190580	196	1.51634	2.9720264	uncultured Desulfovibrio sp.	167968	Bacteria	Bacteria	42	0.0376	NR	WP_300807344.1	167968	g189762	i0	36.2	0.719387755102041	47	30	71.9	0	191	51	461	507	WP_300807344.1 alpha-2-macroglobulin family protein [uncultured Desulfovibrio sp.]	diamond	141	42	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	uncultured Desulfovibrio sp.

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