metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax

29 rows where analysis = "diamond", bioproject = "PRJNA928559" 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
8556768	8556768	PRJNA928559_P_NODE_33747_length_567_cov_5.872470_g32209_i0	PRJNA928559	33747	567	5.87247	33.2969049	Desulfatibacillum sp.	2794877	Bacteria	Bacteria	174	1.1699999999999999e-46	NR	MBI9077938.1	2794877	g32209	i0	45	2.98412698412698	189	100	98.9	2	566	6	1025	1211	MBI9077938.1 SDR family NAD(P)-dependent oxidoreductase [Desulfatibacillum sp.]	diamond	1692	174	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum sp.
18756019	18756019	PRJNA928559_P_NODE_80815_length_394_cov_3.507788_g79246_i0	PRJNA928559	80815	394	3.507788	13.82068472	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	187	1.24e-58	NR	GJM17744.1	2202153	g79246	i0	72.4	1.96446700507614	127	35	96.7	0	2	382	1	127	GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium]	diamond	774	187	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
25479516	25479516	PRJNA928559_P_NODE_205600_length_245_cov_2.813953_g204031_i0	PRJNA928559	205600	245	2.813953	6.89418485	Pseudomonadati	3379134	Bacteria	Bacteria	140	1.31e-40	NR	WP_054649926.1	221711	g204031	i0	75.3	12.8938775510204	81	20	99.2	0	1	243	45	125	WP_054649926.1 peptidylprolyl isomerase [Salidesulfovibrio brasiliensis]	diamond	3159	141	0.99290780141844	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Salidesulfovibrio	Salidesulfovibrio brasiliensis
27182650	27182650	PRJNA928559_P_NODE_211942_length_243_cov_0.917647_g210373_i0	PRJNA928559	211942	243	0.917647	2.22988221	Desulfobulbus oligotrophicus	1909699	Bacteria	Bacteria	144	1.4599999999999996e-40	NR	MDY0390967.1	1909699	g210373	i0	81.5	1	81	15	100	0	243	1	182	262	MDY0390967.1 hypothetical protein [Desulfobulbus oligotrophicus]	diamond	243	144	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oligotrophicus
27245984	27245984	PRJNA928559_P_NODE_104203_length_349_cov_3.536232_g102634_i0	PRJNA928559	104203	349	3.536232	12.34144968	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	127	4.69e-34	NR	GJM17626.1	2202153	g102634	i0	59.6	0.979942693409742	114	44	98	2	344	3	100	211	GJM17626.1 MAG: hypothetical protein DHS20C13_29530 [Thermodesulfobacteriota bacterium]	diamond	342	127	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
27309438	27309438	PRJNA928559_P_NODE_133243_length_307_cov_2.072650_g131674_i0	PRJNA928559	133243	307	2.07265	6.3630355	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	95.1	3.19e-20	NR	HAO22905.1	2049433	g131674	i0	43.6	1.14332247557003	117	51	99.7	3	1	306	181	297	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	351	95.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
27979586	27979586	PRJNA928559_P_NODE_58345_length_454_cov_4.527559_g56778_i0	PRJNA928559	58345	454	4.527559	20.55511786	root	1	Root_unresolved	Root_unresolved	109	1.47e-25	NR	CAK7026259.1	885	g56778	i0	42.7	12.9449339207048	150	53	99.1	4	451	2	33	149	CAK7026259.1 MAG: Glyceraldehyde-3-phosphate dehydrogenase A [Desulfovibrio sp.]	diamond	5877	110	0.990909090909091	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
28067041	28067041	PRJNA928559_P_NODE_121825_length_322_cov_4.176707_g120256_i0	PRJNA928559	121825	322	4.176707	13.44899654	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	47.8	0.00126	NR	NLZ17542.1	2053307	g120256	i0	51.2	0.773291925465838	41	20	38.2	0	49	171	186	226	NLZ17542.1 CAP domain-containing protein [Desulfobulbaceae bacterium]	diamond	249	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
28130425	28130425	PRJNA928559_P_NODE_222245_length_229_cov_21.621795_g220676_i0	PRJNA928559	222245	229	21.621795	49.51391055	Bilophila wadsworthia	35833	Bacteria	Bacteria	69.3	2.97e-13	NR	WP_029435158.1	35833	g220676	i0	76.7	2.75109170305677	43	10	56.3	0	2	130	57	99	WP_029435158.1 conjugal transfer protein TrbD [Bilophila wadsworthia]	diamond	630	69.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
28446149	28446149	PRJNA928559_P_NODE_186086_length_254_cov_1.602210_g184517_i0	PRJNA928559	186086	254	1.60221	4.0696134	Syntrophotalea carbinolica	19	Bacteria	Bacteria	58.9	2.11e-8	NR	WP_011341553.1	19	g184517	i0	40.8	1.7244094488189	76	44	89.8	1	229	2	95	169	WP_011341553.1 phage baseplate assembly protein V [Syntrophotalea carbinolica]	diamond	438	58.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
28572311	28572311	PRJNA928559_P_NODE_62167_length_442_cov_5.363144_g60598_i0	PRJNA928559	62167	442	5.363144	23.70509648	Desulfuromonas sp. TF	1232410	Bacteria	Bacteria	45.4	0.0276	NR	WP_027714875.1	1232410	g60598	i0	39.8	0.597285067873303	88	50	58.4	3	130	387	1	87	WP_027714875.1 methylmalonyl Co-A mutase-associated GTPase MeaB [Desulfuromonas sp. TF]	diamond	264	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp. TF
28698812	28698812	PRJNA928559_P_NODE_189667_length_252_cov_1.608939_g188098_i0	PRJNA928559	189667	252	1.608939	4.05452628	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	106	2.35e-27	NR	GJM17742.1	2202153	g188098	i0	67.1	0.976190476190476	82	26	97.6	1	251	6	8	88	GJM17742.1 MAG: hypothetical protein DHS20C13_30690 [Thermodesulfobacteriota bacterium]	diamond	246	106	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28737398	28737398	PRJNA928559_P_NODE_221287_length_231_cov_3.253165_g219718_i0	PRJNA928559	221287	231	3.253165	7.51481115	Pseudomonadati	3379134	Bacteria	Bacteria	101	5.91e-24	NR	WP_021758412.1	879	g219718	i0	80	3.36363636363636	65	13	84.4	0	230	36	217	281	WP_021758412.1 3-deoxy-8-phosphooctulonate synthase [Megalodesulfovibrio gigas]	diamond	777	101	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
28761694	28761694	PRJNA928559_P_NODE_69947_length_420_cov_6.296830_g68378_i0	PRJNA928559	69947	420	6.29683	26.446686	Geobacter sp. SVR	2495594	Bacteria	Bacteria	106	3.46e-25	NR	WP_173199256.1	2495594	g68378	i0	51.4	1.57857142857143	105	48	72.9	2	97	402	58	162	WP_173199256.1 hypothetical protein [Geobacter sp. SVR]	diamond	663	106	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. SVR
29014656	29014656	PRJNA928559_P_NODE_163648_length_274_cov_1.527363_g162079_i0	PRJNA928559	163648	274	1.527363	4.18497462	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	47.8	8.51e-4	NR	MDH3782573.1	2053307	g162079	i0	33.3	0.886861313868613	81	50	84.3	1	262	32	157	237	MDH3782573.1 AraC family transcriptional regulator ligand-binding domain-containing protein [Desulfobulbaceae bacterium]	diamond	243	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
29368872	29368872	PRJNA928559_P_NODE_224369_length_225_cov_4.328947_g222800_i0	PRJNA928559	224369	225	4.328947	9.74013075	Thermodesulfobacteriota	200940	Bacteria	Bacteria	47	9.51e-4	NR	WP_302548723.1	167968	g222800	i0	54	5.26666666666667	50	19	66.7	1	150	1	4	49	WP_302548723.1 DUF2201 family putative metallopeptidase [uncultured Desulfovibrio sp.]	diamond	1185	47.4	0.991561181434599	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	uncultured Desulfovibrio sp.
29424617	29424617	PRJNA928559_P_NODE_156269_length_281_cov_2.014423_g154700_i0	PRJNA928559	156269	281	2.014423	5.66052863	Desulfobacter sp.	2294	Bacteria	Bacteria	105	5.1899999999999996e-24	NR	MDD9301020.1	2294	g154700	i0	53.3	4.83629893238434	92	41	98.2	1	276	1	539	628	MDD9301020.1 DUF819 family protein [Desulfobacter sp.]	diamond	1359	105	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter sp.
29708577	29708577	PRJNA928559_P_NODE_179570_length_259_cov_2.526882_g178001_i0	PRJNA928559	179570	259	2.526882	6.54462438	Desulfocicer vacuolatum	2298	Bacteria	Bacteria	78.2	1.58e-14	NR	WP_084069024.1	2298	g178001	i0	56.3	1.00772200772201	87	32	93.8	2	1	243	448	534	WP_084069024.1 calcium-binding protein [Desulfocicer vacuolatum]	diamond	261	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfocicer	Desulfocicer vacuolatum
30087952	30087952	PRJNA928559_P_NODE_224032_length_227_cov_2.051948_g222463_i0	PRJNA928559	224032	227	2.051948	4.65792196	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	104	7.430000000000001e-26	NR	GJM17743.1	2202153	g222463	i0	67.6	0.977973568281938	74	24	97.8	0	226	5	133	206	GJM17743.1 MAG: hypothetical protein DHS20C13_30700 [Thermodesulfobacteriota bacterium]	diamond	222	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30600588	30600588	PRJNA928559_P_NODE_202473_length_247_cov_0.896552_g200904_i0	PRJNA928559	202473	247	0.896552	2.21448344	Pseudomonadati	3379134	Bacteria	Bacteria	105	1.8999999999999998e-24	NR	WP_151151701.1	1721087	g200904	i0	66.7	11.8056680161943	81	25	98.4	1	245	3	189	267	WP_151151701.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Pseudodesulfovibrio senegalensis]	diamond	2916	105	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio senegalensis
30941286	30941286	PRJNA928559_P_NODE_175254_length_263_cov_1.868421_g173685_i0	PRJNA928559	175254	263	1.868421	4.91394723	Candidatus Electrothrix sp. AUS1_2	2249218	Bacteria	Bacteria	76.3	4.07e-14	NR	MCI5157345.1	2249218	g173685	i0	45.6	0.901140684410646	79	42	90.1	1	2	238	76	153	MCI5157345.1 glycosyltransferase family 2 protein [Candidatus Electrothrix sp. AUS1_2]	diamond	237	76.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix sp. AUS1_2
31257133	31257133	PRJNA928559_P_NODE_87075_length_381_cov_1.928571_g85506_i0	PRJNA928559	87075	381	1.928571	7.34785551	Desulfurivibrio sp. C	2093369	Bacteria	Bacteria	235	5.47e-69	NR	WP_395493285.1	3374371	g85506	i0	90.5	2.97637795275591	126	12	99.2	0	379	2	472	597	WP_395493285.1 ATP-binding protein [Desulfurivibrio sp. C05AmB]	diamond	1134	235	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio sp. C05AmB
31731448	31731448	PRJNA928559_P_NODE_225997_length_211_cov_4.485507_g224428_i0	PRJNA928559	225997	211	4.485507	9.46441977	Desulfomicrobium escambiense	29503	Bacteria	Bacteria	60.8	7.48e-9	NR	WP_084435654.1	29503	g224428	i0	43.9	2.72985781990521	66	36	92.4	1	2	196	160	225	WP_084435654.1 glycosyltransferase family 2 protein [Desulfomicrobium escambiense]	diamond	576	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium escambiense
32048016	32048016	PRJNA928559_P_NODE_89938_length_375_cov_2.622517_g88369_i0	PRJNA928559	89938	375	2.622517	9.83443875	Desulfonatronovibrio magnus	698827	Bacteria	Bacteria	165	1.28e-46	NR	WP_084590935.1	698827	g88369	i0	63.4	1.952	123	45	98.4	0	373	5	160	282	WP_084590935.1 class I SAM-dependent methyltransferase [Desulfonatronovibrio magnus]	diamond	732	165	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronovibrionaceae	Desulfonatronovibrio	Desulfonatronovibrio magnus
32427630	32427630	PRJNA928559_P_NODE_103919_length_350_cov_1.718412_g102350_i0	PRJNA928559	103919	350	1.718412	6.014442	Desulfoluna limicola	2810562	Bacteria	Bacteria	107	1.72e-26	NR	WP_276574646.1	2810562	g102350	i0	47.8	0.788571428571429	92	48	78.9	0	348	73	103	194	WP_276574646.1 acyltransferase [Desulfoluna limicola]	diamond	276	107	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfolunaceae	Desulfoluna	Desulfoluna limicola
32427668	32427668	PRJNA928559_P_NODE_171919_length_266_cov_2.025907_g170350_i0	PRJNA928559	171919	266	2.025907	5.38891262	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	67.8	2.32e-11	NR	MFP4160344.1	2044940	g170350	i0	68.9	2.57142857142857	45	14	50.8	0	131	265	130	174	MFP4160344.1 DUF933 domain-containing protein [Desulfobacterales bacterium]	diamond	684	67.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32617217	32617217	PRJNA928559_P_NODE_203420_length_246_cov_2.473988_g201851_i0	PRJNA928559	203420	246	2.473988	6.08601048	Desulfonatronovibrio magnus	698827	Bacteria	Bacteria	63.9	1.2e-9	NR	WP_045212904.1	698827	g201851	i0	50	0.731707317073171	60	30	73.2	0	60	239	66	125	WP_045212904.1 Gfo/Idh/MocA family oxidoreductase [Desulfonatronovibrio magnus]	diamond	180	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronovibrionaceae	Desulfonatronovibrio	Desulfonatronovibrio magnus
32781576	32781576	PRJNA928559_P_NODE_127440_length_315_cov_1.107438_g125871_i0	PRJNA928559	127440	315	1.107438	3.4884297	Pseudomonadati	3379134	Bacteria	Bacteria	65.9	6.68e-10	NR	MDD2468030.1	895	g125871	i0	39.2	2.87619047619048	102	58	96.2	2	2	304	783	881	MDD2468030.1 hypothetical protein [Desulfobulbus sp.]	diamond	906	66.2	0.995468277945619	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp.
32907641	32907641	PRJNA928559_P_NODE_215560_length_242_cov_0.923077_g213991_i0	PRJNA928559	215560	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	114	3.0800000000000004e-27	NR	KUJ96075.1	1635258	g213991	i0	72.5	23.4669421487603	80	22	99.2	0	242	3	334	413	KUJ96075.1 MAG: Anti-sigma H sporulation factor, LonB [Desulfonauticus sp. 38_4375]	diamond	5679	114	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonauticaceae	Desulfonauticus	Desulfonauticus sp. 38_4375

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