metadata: contig_metadata: 29 rows where bioproject = "PRJNA358009", tax_phylum = "Thermodesulfobacteriota" and tax

29 rows where bioproject = "PRJNA358009", 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
398213	398213	PRJNA358009_P_NODE_12801_length_167_cov_5.991525_g12732_i0	PRJNA358009	12801	167	5.991525	10.00584675	uncultured Syntrophobacter sp.	281272	Bacteria	Bacteria	171	3.7099999999999997e-38	NTclustered	gi\|2621703986\|emb\|OY762941.1\|	281272	g12732	i0	85.89	150.311377245509	163	19	95	2	1	159	1625681	1625843	MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1	blastn	25102	171	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	uncultured Syntrophobacter sp.
1072963	1072963	PRJNA358009_P_NODE_13761_length_165_cov_7.724138_g13692_i0	PRJNA358009	13761	165	7.724138	12.7448277	Megalodesulfovibrio	2910978	Bacteria	Bacteria	279	5.81e-71	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g13692	i0	98.125	275.448484848485	160	3	97	0	6	165	2307	2466	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	45449	279	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
2948779	2948779	PRJNA358009_P_NODE_13283_length_166_cov_7.111111_g13214_i0	PRJNA358009	13283	166	7.111111	11.80444426	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	283	4.53e-72	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g13214	i0	99.359	7.7289156626506	156	1	94	0	8	163	2917	2762	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	1283	283	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
2948874	2948874	PRJNA358009_P_NODE_16843_length_159_cov_3.054545_g16774_i0	PRJNA358009	16843	159	3.054545	4.85672655	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	178	2.08e-40	NTclustered	gi\|2621704724\|emb\|OY762071.1\|	2044940	g16774	i0	93.333	392.88050314465403	120	8	75	0	32	151	490954	491073	MAG: Desulfobacterales bacterium isolate 06740738-a7bd-4baa-85b3-74b223bbbbd0 genome assembly, chromosome: 1	blastn	62468	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
4900844	4900844	PRJNA358009_P_NODE_1124_length_362_cov_4.827476_g1063_i0	PRJNA358009	1124	362	4.827476	17.47546312	Megalodesulfovibrio	2910978	Bacteria	Bacteria	272	2.42e-68	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g1063	i0	97.484	161.709944751381	159	4	69	0	7	165	2121	2279	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	58539	272	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
7450909	7450909	PRJNA358009_P_NODE_18606_length_150_cov_8.900990_g18537_i0	PRJNA358009	18606	150	8.90099	13.351485	Trichlorobacter	115782	Bacteria	Bacteria	220	3.16e-53	NTclustered	gi\|470483286\|ref\|NR_076583.1\|	313985	g18537	i0	95.62	210.526666666667	137	6	91	0	7	143	1188	1052	Geobacter lovleyi strain SZ 23S ribosomal RNA gene, complete sequence	blastn	31579	220	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Trichlorobacter	Trichlorobacter lovleyi
9326438	9326438	PRJNA358009_P_NODE_628_length_447_cov_33.110553_g296_i1	PRJNA358009	628	447	33.110553	148.00417191	Desulfovibrio sp. L3	411454	Bacteria	Bacteria	553	9.729999999999999e-153	NTclustered	gi\|117582491\|gb\|EF055876.1\|	411454	g296	i1	90.736	66.0111856823266	421	29	93	9	8	423	61	476	Desulfovibrio sp. L3 16S ribosomal RNA gene, partial sequence	blastn	29507	553	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. L3
10001085	10001085	PRJNA358009_P_NODE_10288_length_180_cov_11.145038_g10219_i0	PRJNA358009	10288	180	11.145038	20.0610684	Megalodesulfovibrio	2910978	Bacteria	Bacteria	322	1.05e-83	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g10219	i0	98.889	216.2	180	2	100	0	1	180	2685	2864	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	38916	322	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
10602026	10602026	PRJNA358009_P_NODE_18269_length_152_cov_4.475728_g18200_i0	PRJNA358009	18269	152	4.475728	6.80310656	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	87	1.93e-19	NR	HKL27281.1	2099678	g18200	i0	79.2	1.91447368421053	48	10	94.7	0	8	151	8	55	HKL27281.1 DUF4214 domain-containing protein [Desulfuromonadales bacterium]	diamond	291	87	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
11276224	11276224	PRJNA358009_P_NODE_1689_length_340_cov_25.542955_g1627_i0	PRJNA358009	1689	340	25.542955	86.846047	Megalodesulfovibrio	2910978	Bacteria	Bacteria	344	4.73e-90	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g1627	i0	97.059	86.8558823529412	204	6	86	0	130	333	208	5	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	29531	344	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
13826483	13826483	PRJNA358009_P_NODE_9011_length_188_cov_6.287770_g8942_i0	PRJNA358009	9011	188	6.28777	11.8210076	Trichlorobacter	115782	Bacteria	Bacteria	337	3.97e-88	NTclustered	gi\|470483286\|ref\|NR_076583.1\|	313985	g8942	i0	100	227.739361702128	182	0	97	0	1	182	1073	892	Geobacter lovleyi strain SZ 23S ribosomal RNA gene, complete sequence	blastn	42815	337	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Trichlorobacter	Trichlorobacter lovleyi
15700784	15700784	PRJNA358009_P_NODE_11073_length_176_cov_2.897638_g11004_i0	PRJNA358009	11073	176	2.897638	5.09984288	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	285	1.3399999999999998e-72	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g11004	i0	100	286.244318181818	154	0	88	0	16	169	2467	2620	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	50379	285	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
15700943	15700943	PRJNA358009_P_NODE_253_length_606_cov_10.348294_g214_i0	PRJNA358009	253	606	10.348294	62.71066164	Geobacter sulfurreducens	35554	Bacteria	Bacteria	268	5.469999999999999e-67	NTclustered	gi\|2045533567\|gb\|CP074693.1\|	35554	g214	i0	81.065	5.78712871287129	338	62	56	2	248	584	1196163	1196499	Geobacter sulfurreducens strain YM35 chromosome, complete genome	blastn	3507	268	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
16975747	16975747	PRJNA358009_P_NODE_8074_length_208_cov_10.610063_g8005_i0	PRJNA358009	8074	208	10.610063	22.06893104	uncultured Syntrophobacter sp.	281272	Bacteria	Bacteria	274	3.5699999999999996e-69	NTclustered	gi\|2621703986\|emb\|OY762941.1\|	281272	g8005	i0	90.385	5.81730769230769	208	20	100	0	1	208	1624220	1624427	MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1	blastn	1210	274	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	uncultured Syntrophobacter sp.
17650650	17650650	PRJNA358009_P_NODE_634_length_446_cov_13.947103_g577_i0	PRJNA358009	634	446	13.947103	62.20407938	Megalodesulfovibrio	2910978	Bacteria	Bacteria	643	5.599999999999998e-180	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g577	i0	92.986	110.531390134529	442	29	99	2	1	441	1435	1875	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	49297	643	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
18249767	18249767	PRJNA358009_P_NODE_10135_length_181_cov_8.893939_g10066_i0	PRJNA358009	10135	181	8.893939	16.09802959	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	322	1.06e-83	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g10066	i0	100	188.530386740331	174	0	96	0	8	181	2233	2060	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	34124	322	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
18249925	18249925	PRJNA358009_P_NODE_18635_length_150_cov_6.465347_g18566_i0	PRJNA358009	18635	150	6.465347	9.6980205	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	87.8	1.27e-18	NR	MCF8030190.1	2683721	g18566	i0	93.5	0.92	46	3	92	0	6	143	404	449	MCF8030190.1 sigma 54-interacting transcriptional regulator [Desulfohalobiaceae bacterium]	diamond	138	87.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
18924412	18924412	PRJNA358009_P_NODE_15455_length_162_cov_4.831858_g15386_i0	PRJNA358009	15455	162	4.831858	7.82760996	Syntrophobacter	29526	Bacteria	Bacteria	207	2.72e-49	NTclustered	gi\|470481149\|ref\|NR_076457.1\|	119484	g15386	i0	90.446	73.6234567901235	157	15	97	0	6	162	2181	2337	Syntrophobacter fumaroxidans strain MPOB 23S ribosomal RNA gene, complete sequence	blastn	11927	207	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
20799760	20799760	PRJNA358009_P_NODE_17197_length_157_cov_4.546296_g17128_i0	PRJNA358009	17197	157	4.546296	7.13768472	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	278	1.96e-70	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g17128	i0	99.351	2.94267515923567	154	0	97	1	1	153	1536	1689	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	462	278	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
22074870	22074870	PRJNA358009_P_NODE_4638_length_327_cov_2.046763_g4575_i0	PRJNA358009	4638	327	2.046763	6.69291501	Desulfovibrio piger	901	Bacteria	Bacteria	124	6.419999999999999e-24	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g4575	i0	91.209	3.15596330275229	91	8	28	0	230	320	990	1080	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	1032	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
22074932	22074932	PRJNA358009_P_NODE_9818_length_183_cov_6.238806_g9749_i0	PRJNA358009	9818	183	6.238806	11.41701498	Megalodesulfovibrio gigas	879	Bacteria	Bacteria	270	3.949999999999999e-68	NTclustered	gi\|544197442\|gb\|CP006585.1\|	1121448	g9749	i0	94.798	85.6229508196721	173	9	95	0	4	176	2939457	2939285	Desulfovibrio gigas DSM 1382 = ATCC 19364 genome	blastn	15669	270	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
22749891	22749891	PRJNA358009_P_NODE_7018_length_293_cov_49.225410_g6951_i0	PRJNA358009	7018	293	49.22541	144.2304513	Megalodesulfovibrio	2910978	Bacteria	Bacteria	479	1.0499999999999996e-130	NTclustered	gi\|662020060\|ref\|NR_121947.1\|	879	g6951	i0	96.246	486.273037542662	293	10	100	1	1	293	209	500	Desulfovibrio gigas strain DSM 1382 23S ribosomal RNA gene, complete sequence	blastn	142478	479	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
22749928	22749928	PRJNA358009_P_NODE_9678_length_184_cov_5.970370_g9609_i0	PRJNA358009	9678	184	5.97037	10.9854808	Desulfuromonas	890	Bacteria	Bacteria	113	7.1e-21	NTclustered	gi\|662020026\|ref\|NR_121913.1\|	891	g9609	i0	84.746	96.6847826086957	118	12	63	4	68	182	368	482	Desulfuromonas acetoxidans strain DSM 684 23S ribosomal RNA gene, complete sequence	blastn	17790	113	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas acetoxidans
24624347	24624347	PRJNA358009_P_NODE_11540_length_173_cov_5.879032_g11471_i0	PRJNA358009	11540	173	5.879032	10.17072536	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	302	1.31e-77	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g11471	i0	99.398	159.919075144509	166	1	96	0	8	173	2037019	2036854	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	27666	302	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
25299200	25299200	PRJNA358009_P_NODE_2820_length_327_cov_3.205036_g2757_i0	PRJNA358009	2820	327	3.205036	10.48046772	Desulfomonile	2357	Bacteria	Bacteria	180	1.35e-40	NTclustered	gi\|470490011\|ref\|NR_076962.1\|	2358	g2757	i0	99	70.3211009174312	100	1	60	0	228	327	1798	1699	Desulfomonile tiedjei strain DCB-1 23S ribosomal RNA gene, complete sequence	blastn	22995	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
28117011	28117011	PRJNA358009_P_NODE_13385_length_166_cov_3.076923_g13316_i0	PRJNA358009	13385	166	3.076923	5.10769218	Desulfonatronovibrionaceae bacterium	3107345	Bacteria	Bacteria	92	5.7e-20	NR	MFP4657789.1	3107345	g13316	i0	85.7	0.885542168674699	49	7	88.6	0	153	7	270	318	MFP4657789.1 insulinase family protein [Desulfonatronovibrionaceae bacterium]	diamond	147	92	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronovibrionaceae		Desulfonatronovibrionaceae bacterium
31686634	31686634	PRJNA358009_P_NODE_9597_length_185_cov_2.426471_g9528_i0	PRJNA358009	9597	185	2.426471	4.48897135	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	119	9.5e-31	NR	MEF8822701.1	2683721	g9528	i0	98.3	0.940540540540541	58	1	94.1	0	179	6	5	62	MEF8822701.1 ribonuclease Z [Desulfohalobiaceae bacterium]	diamond	174	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
32129836	32129836	PRJNA358009_P_NODE_11078_length_176_cov_2.795276_g11009_i0	PRJNA358009	11078	176	2.795276	4.91968576	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	48.5	1.38e-4	NR	MBQ4133630.1	2049043	g11009	i0	43.2	0.75	44	25	75	0	18	149	384	427	MBQ4133630.1 HDIG domain-containing protein [Desulfovibrionaceae bacterium]	diamond	132	48.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
32193015	32193015	PRJNA358009_P_NODE_15038_length_163_cov_2.350877_g14969_i0	PRJNA358009	15038	163	2.350877	3.83192951	Pelobacter propionicus	29543	Bacteria	Bacteria	42.4	0.0174	NR	WP_011735193.1	29543	g14969	i0	41.5	0.975460122699387	53	28	92	1	11	160	287	339	WP_011735193.1 radical SAM/SPASM domain-containing protein [Pelobacter propionicus]	diamond	159	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus

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