metadata: contig_metadata: 33 rows where bioproject = "PRJNA980839" and tax

33 rows where bioproject = "PRJNA980839" 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
960677	960677	PRJNA980839_P_NODE_97241_length_369_cov_1.209459_g93457_i0	PRJNA980839	97241	369	1.209459	4.46290371	Desulfuromonas thiophila	57664	Bacteria	Bacteria	228	5.429999999999998e-55	NTclustered	gi\|2621701248\|emb\|OY759968.1\|	57664	g93457	i0	92.949	2.18157181571816	156	11	42	0	214	369	2352168	2352323	MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1	blastn	805	228	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
2232530	2232530	PRJNA980839_P_NODE_137402_length_300_cov_2.365639_g133618_i0	PRJNA980839	137402	300	2.365639	7.096917	Geopsychrobacteraceae bacterium	3065857	Bacteria	Bacteria	366	8.77e-97	NTclustered	gi\|2621701823\|emb\|OY759353.1\|	3065857	g133618	i0	88.889	4.95666666666667	297	33	99	0	1	297	4680476	4680772	MAG: Geopsychrobacteraceae bacterium isolate b20cad9c-d1d2-40c5-8f7b-178437520c26 genome assembly, chromosome: 1	blastn	1487	366	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae		Geopsychrobacteraceae bacterium
11160702	11160702	PRJNA980839_P_NODE_143429_length_293_cov_2.100000_g139645_i0	PRJNA980839	143429	293	2.1	6.153	Syntrophorhabdus sp.	2699756	Bacteria	Bacteria	69.3	2.01e-11	NR	HQO64876.1	2699756	g139645	i0	46	2.73378839590444	63	34	64.5	0	290	102	244	306	HQO64876.1 sugar phosphate nucleotidyltransferase [Syntrophorhabdus sp.]	diamond	801	69.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae	Syntrophorhabdus	Syntrophorhabdus sp.
11161653	11161653	PRJNA980839_P_NODE_191029_length_255_cov_1.390110_g187245_i0	PRJNA980839	191029	255	1.39011	3.5447805	Pseudomonadati	3379134	Bacteria	Bacteria	101	5.19e-25	NR	MBI1919587.1	46610	g187245	i0	75.8	3.94117647058824	66	16	77.6	0	3	200	105	170	MBI1919587.1 class IV adenylate cyclase [Geobacter sp.]	diamond	1005	102	0.990196078431373	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
13711577	13711577	PRJNA980839_P_NODE_175251_length_266_cov_1.663212_g171467_i0	PRJNA980839	175251	266	1.663212	4.42414392	Geobacter sulfurreducens	35554	Bacteria	Bacteria	464	2.64e-126	NTclustered	gi\|2045533567\|gb\|CP074693.1\|	35554	g171467	i0	98.12	52.2406015037594	266	5	100	0	1	266	81541	81276	Geobacter sulfurreducens strain YM35 chromosome, complete genome	blastn	13896	464	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
14024287	14024287	PRJNA980839_P_NODE_52011_length_587_cov_1.365759_g48263_i0	PRJNA980839	52011	587	1.365759	8.01700533	Syntrophobacteraceae bacterium	2052185	Bacteria	Bacteria	233	4.06e-70	NR	HYA41095.1	2052185	g48263	i0	61.5	3.00511073253833	195	73	99.7	1	1	585	237	429	HYA41095.1 ABC transporter permease subunit [Syntrophobacteraceae bacterium]	diamond	1764	233	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
18811932	18811932	PRJNA980839_P_NODE_69255_length_469_cov_1.527778_g65473_i0	PRJNA980839	69255	469	1.527778	7.16527882	Syntrophales bacterium	2928017	Bacteria	Bacteria	249	7.52e-80	NR	MDO8721542.1	2928017	g65473	i0	76.9	0.997867803837953	156	34	99.8	1	469	2	94	247	MDO8721542.1 copper resistance system multicopper oxidase [Syntrophales bacterium]	diamond	468	249	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
22635992	22635992	PRJNA980839_P_NODE_226118_length_244_cov_0.900585_g222334_i0	PRJNA980839	226118	244	0.900585	2.1974274	Geotalea uraniireducens	351604	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|146395585\|gb\|CP000698.1\|	351605	g222334	i0	88.636	0.180327868852459	44	5	18	0	189	232	5010308	5010351	Geobacter uraniireducens Rf4, complete genome	blastn	44	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
25182601	25182601	PRJNA980839_P_NODE_101980_length_358_cov_1.350877_g98196_i0	PRJNA980839	101980	358	1.350877	4.83613966	Desulfovibrio piger	901	Bacteria	Bacteria	246	1.45e-60	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g98196	i0	86.818	0.826815642458101	220	29	61	0	1	220	1791567	1791348	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	296	246	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
26709380	26709380	PRJNA980839_P_NODE_40321_length_728_cov_1.422901_g36720_i0	PRJNA980839	40321	728	1.422901	10.35871928	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	224	2.05e-64	NR	MDD4456645.1	29542	g36720	i0	49.6	1.98214285714286	240	113	97.7	2	17	727	325	559	MDD4456645.1 TraM recognition domain-containing protein [Syntrophotalea acetylenica]	diamond	1443	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
26810806	26810806	PRJNA980839_P_NODE_240421_length_239_cov_3.078313_g236637_i0	PRJNA980839	240421	239	3.078313	7.35716807	Pseudomonadati	3379134	Bacteria	Bacteria	92.8	4.84e-20	NR	MDD2900214.1	2099677	g236637	i0	58.7	3.82845188284519	75	31	94.1	0	5	229	141	215	MDD2900214.1 VanZ family protein [Desulfuromonadaceae bacterium]	diamond	915	92.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
26899777	26899777	PRJNA980839_P_NODE_167361_length_272_cov_2.105528_g163577_i0	PRJNA980839	167361	272	2.105528	5.72703616	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	92	3.93e-20	NR	MCA1785129.1	2049433	g163577	i0	50	0.926470588235294	84	42	92.6	0	269	18	189	272	MCA1785129.1 type IV secretion system DotC family protein [Desulfobacteraceae bacterium]	diamond	252	92	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
27026182	27026182	PRJNA980839_P_NODE_108562_length_344_cov_2.059041_g104778_i0	PRJNA980839	108562	344	2.059041	7.08310104	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	162	2.38e-45	NR	HNR15004.1	2202153	g104778	i0	69.9	5.91279069767442	113	34	98.5	0	340	2	73	185	HNR15004.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	2034	162	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
27152240	27152240	PRJNA980839_P_NODE_186862_length_258_cov_1.248649_g183078_i0	PRJNA980839	186862	258	1.248649	3.22151442	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	72.8	1.68e-13	NR	MEA5115963.1	2282154	g183078	i0	64.4	0.686046511627907	59	20	67.4	1	258	85	139	197	MEA5115963.1 phage baseplate assembly protein V [Geobacteraceae bacterium]	diamond	177	72.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
27215663	27215663	PRJNA980839_P_NODE_105242_length_351_cov_1.633094_g101458_i0	PRJNA980839	105242	351	1.633094	5.73215994	Desulfobacter hydrogenophilus	2291	Bacteria	Bacteria	94.7	4.59e-22	NR	WP_163354854.1	2291	g101458	i0	93.6	0.401709401709402	47	3	40.2	0	211	351	1	47	WP_163354854.1 hypothetical protein, partial [Desulfobacter hydrogenophilus]	diamond	141	94.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter hydrogenophilus
28068525	28068525	PRJNA980839_P_NODE_138745_length_299_cov_1.185841_g134961_i0	PRJNA980839	138745	299	1.185841	3.54566459	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	80.5	1.99e-15	NR	WP_207162566.1	2815309	g134961	i0	40	1.99665551839465	95	47	95.3	1	3	287	186	270	WP_207162566.1 DUF4365 domain-containing protein [Geobacter benzoatilyticus]	diamond	597	80.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
28226190	28226190	PRJNA980839_P_NODE_76466_length_436_cov_1.115702_g72682_i0	PRJNA980839	76466	436	1.115702	4.86446072	Pelovirga sp.	2913515	Bacteria	Bacteria	45.1	0.0385	NR	MFO7767261.1	2913515	g72682	i0	33.8	0.447247706422018	65	40	42.7	1	150	335	399	463	MFO7767261.1 asparagine--tRNA ligase [Pelovirga sp.]	diamond	195	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Pelovirga	Pelovirga sp.
28390346	28390346	PRJNA980839_P_NODE_134506_length_304_cov_1.411255_g130722_i0	PRJNA980839	134506	304	1.411255	4.2902152	Desulfuromonadales	69541	Bacteria	Bacteria	67.4	1.17e-10	NR	MDD4456163.1	29542	g130722	i0	34.8	4.17434210526316	89	56	85.9	1	276	16	225	313	MDD4456163.1 ParM/StbA family protein [Syntrophotalea acetylenica]	diamond	1269	67.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
29457528	29457528	PRJNA980839_P_NODE_43170_length_687_cov_1.596091_g39500_i0	PRJNA980839	43170	687	1.596091	10.96514517	Geobacterales bacterium	3069300	Bacteria	Bacteria	181	2.31e-50	NR	HWJ19318.1	3069300	g39500	i0	77.6	0.54585152838428	125	28	54.6	0	377	3	16	140	HWJ19318.1 cation diffusion facilitator family transporter [Geobacterales bacterium]	diamond	375	181	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales			Geobacterales bacterium
29495447	29495447	PRJNA980839_P_NODE_217310_length_246_cov_0.890173_g213526_i0	PRJNA980839	217310	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0177	NR	MCD6527495.1	892	g213526	i0	46.3	2.41463414634146	67	29	73.2	2	212	33	79	145	MCD6527495.1 response regulator transcription factor [Desulfuromonas sp.]	diamond	594	43.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp.
29589851	29589851	PRJNA980839_P_NODE_199070_length_251_cov_0.865169_g195286_i0	PRJNA980839	199070	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	64.3	7.69e-10	NR	KAB2833783.1	2080303	g195286	i0	81.1	1.31474103585657	37	7	44.2	0	139	249	2	38	KAB2833783.1 MAG: polyphosphate kinase 2 family protein [Candidatus Dadabacteria bacterium]	diamond	330	64.7	0.993817619783617	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
29747791	29747791	PRJNA980839_P_NODE_196950_length_251_cov_1.449438_g193166_i0	PRJNA980839	196950	251	1.449438	3.63808938	Pseudomonadati	3379134	Bacteria	Bacteria	122	8.03e-33	NR	HVP80271.1	2202153	g193166	i0	74.1	2.90438247011952	81	21	96.8	0	247	5	97	177	HVP80271.1 alpha/beta hydrolase [Thermodesulfobacteriota bacterium]	diamond	729	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29805068	29805068	PRJNA980839_P_NODE_161291_length_277_cov_2.009804_g157507_i0	PRJNA980839	161291	277	2.009804	5.56715708	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	160	3.4999999999999998e-46	NR	MEJ2660097.1	2049433	g157507	i0	82.6	2.98916967509025	92	16	99.6	0	276	1	93	184	MEJ2660097.1 ATP-binding protein [Desulfobacteraceae bacterium]	diamond	828	160	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
29836636	29836636	PRJNA980839_P_NODE_138091_length_299_cov_3.402655_g134307_i0	PRJNA980839	138091	299	3.402655	10.17393845	Desulfobacter hydrogenophilus	2291	Bacteria	Bacteria	103	7.77e-26	NR	WP_163354854.1	2291	g134307	i0	98.1	0.531772575250836	53	1	53.2	0	297	139	92	144	WP_163354854.1 hypothetical protein, partial [Desulfobacter hydrogenophilus]	diamond	159	103	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter hydrogenophilus
29836693	29836693	PRJNA980839_P_NODE_89211_length_390_cov_2.533123_g85427_i0	PRJNA980839	89211	390	2.533123	9.8791797	Geobacteraceae bacterium GWC2_53_11	1798316	Bacteria	Bacteria	44.7	0.0319	NR	OGU15553.1	1798316	g85427	i0	46.5	0.330769230769231	43	21	31.5	1	258	380	123	165	OGU15553.1 MAG: NADH pyrophosphatase [Geobacteraceae bacterium GWC2_53_11]	diamond	129	44.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium GWC2_53_11
30057748	30057748	PRJNA980839_P_NODE_235971_length_241_cov_2.160714_g232187_i0	PRJNA980839	235971	241	2.160714	5.20732074	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	57	3.04e-7	NR	MDD4456163.1	29542	g232187	i0	37.8	1.0207468879668	82	48	99.6	2	1	240	132	212	MDD4456163.1 ParM/StbA family protein [Syntrophotalea acetylenica]	diamond	246	57	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
30537827	30537827	PRJNA980839_P_NODE_126173_length_315_cov_1.727273_g122389_i0	PRJNA980839	126173	315	1.727273	5.44090995	Pseudomonadati	3379134	Bacteria	Bacteria	71.6	1.77e-12	NR	WP_271370375.1	881	g122389	i0	42	7.28571428571429	88	51	83.8	0	273	10	44	131	WP_271370375.1 DotI/IcmL/TraM family protein [Nitratidesulfovibrio vulgaris]	diamond	2295	72	0.994444444444444	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
30594822	30594822	PRJNA980839_P_NODE_140833_length_296_cov_2.071749_g137049_i0	PRJNA980839	140833	296	2.071749	6.13237704	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	68.9	1.71e-11	NR	MDD4456623.1	29542	g137049	i0	38.5	0.972972972972973	96	57	95.3	2	296	15	5	100	MDD4456623.1 hypothetical protein [Syntrophotalea acetylenica]	diamond	288	68.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
31163402	31163402	PRJNA980839_P_NODE_165675_length_274_cov_1.149254_g161891_i0	PRJNA980839	165675	274	1.149254	3.14895596	Pseudodesulfovibrio tunisiensis	463192	Bacteria	Bacteria	54.3	7.99e-7	NR	WP_243545453.1	463192	g161891	i0	37.6	1.7956204379562	85	52	93.1	1	2	256	14	97	WP_243545453.1 type IV pilus biogenesis protein PilM [Pseudodesulfovibrio tunisiensis]	diamond	492	54.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio tunisiensis
31416734	31416734	PRJNA980839_P_NODE_51936_length_587_cov_3.188716_g48188_i0	PRJNA980839	51936	587	3.188716	18.71776292	Syntrophales bacterium	2928017	Bacteria	Bacteria	180	3.3099999999999993e-52	NR	MDO8721541.1	2928017	g48188	i0	58	1.5076660988075	150	57	76.7	1	136	585	82	225	MDO8721541.1 copper resistance protein B [Syntrophales bacterium]	diamond	885	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
31833777	31833777	PRJNA980839_P_NODE_227497_length_243_cov_3.358824_g223713_i0	PRJNA980839	227497	243	3.358824	8.16194232	Pseudomonadati	3379134	Bacteria	Bacteria	97.4	1.9e-22	NR	MEA2115931.1	2202153	g223713	i0	60	2.96296296296296	80	32	98.8	0	2	241	167	246	MEA2115931.1 glycosyltransferase family 2 protein [Thermodesulfobacteriota bacterium]	diamond	720	98.2	0.991853360488798	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32681331	32681331	PRJNA980839_P_NODE_212360_length_247_cov_1.626437_g208576_i0	PRJNA980839	212360	247	1.626437	4.01729939	Syntrophotalea acetylenica	29542	Bacteria	Bacteria	53.9	2.16e-6	NR	MDD4457709.1	29542	g208576	i0	44.1	0.716599190283401	59	32	70.4	1	72	245	65	123	MDD4457709.1 hypothetical protein [Syntrophotalea acetylenica]	diamond	177	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea acetylenica
32813547	32813547	PRJNA980839_P_NODE_20360_length_1289_cov_1.819901_g17813_i0	PRJNA980839	20360	1289	1.819901	23.45852389	Desulfobulbus	893	Bacteria	Bacteria	101	2.41e-22	NR	WP_297952548.1	239745	g17813	i0	61.3	1.02172226532196	75	29	17.5	0	614	838	1	75	WP_297952548.1 helix-turn-helix transcriptional regulator [uncultured Desulfobulbus sp.]	diamond	1317	102	0.990196078431373	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	uncultured Desulfobulbus 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);;