metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
924250	924250	PRJNA944406_P_NODE_18321_length_307_cov_0.799145_g17362_i0	PRJNA944406	18321	307	0.799145	2.45337515	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	250	9.46e-62	NTclustered	gi\|2621703766\|emb\|OY762721.1\|	3024416	g17362	i0	81.699	352.596091205212	306	51	99	5	1	303	608353	608050	MAG: Desulfatiglandales bacterium isolate 7b555824-8626-4373-9f6d-e46e1e23d1ce genome assembly, chromosome: 1	blastn	108247	250	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
2535205	2535205	PRJNA944406_P_NODE_6042_length_522_cov_2.331849_g5089_i0	PRJNA944406	6042	522	2.331849	12.17225178	Maridesulfovibrio	2794998	Bacteria	Bacteria	641	2.3899999999999994e-179	NTclustered	gi\|485099166\|ref\|NR_102560.1\|	191026	g5089	i0	88.931	273.23754789272	524	52	99	6	1	521	1290	770	Desulfovibrio hydrothermalis strain AM13 23S ribosomal RNA gene, complete sequence	blastn	142630	641	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio hydrothermalis
3475461	3475461	PRJNA944406_P_NODE_57243_length_256_cov_1.683060_g56284_i0	PRJNA944406	57243	256	1.68306	4.3086336	Desulfobaculum bizertense	376490	Bacteria	Bacteria	224	4.659999999999999e-54	NTclustered	gi\|2174722533\|gb\|CP090009.1\|	376490	g56284	i0	83.268	134.99609375	257	29	98	13	2	252	2137576	2137824	Desulfobaculum bizertense strain SY-1 chromosome, complete genome	blastn	34559	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfobaculum	Desulfobaculum bizertense
3811550	3811550	PRJNA944406_P_NODE_61103_length_252_cov_3.972067_g60144_i0	PRJNA944406	61103	252	3.972067	10.00960884	Desulfocurvibacter	2582840	Bacteria	Bacteria	235	2.11e-57	NTclustered	gi\|470489697\|ref\|NR_076945.1\|	873	g60144	i0	83.665	467.444444444444	251	39	99	2	3	252	277	28	Desulfovibrio africanus strain Walvis Bay 23S ribosomal RNA gene, complete sequence	blastn	117796	235	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
4752660	4752660	PRJNA944406_P_NODE_19504_length_298_cov_1.368889_g18545_i0	PRJNA944406	19504	298	1.368889	4.07928922	Desulfolithobacter dissulfuricans	2795293	Bacteria	Bacteria	111	4.51e-20	NTclustered	gi\|2304357171\|dbj\|AP024233.1\|	2795293	g18545	i0	75.519	2.12080536912752	241	51	80	7	1	239	1925591	1925825	Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome	blastn	632	111	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfolithobacter	Desulfolithobacter dissulfuricans
4752885	4752885	PRJNA944406_P_NODE_37784_length_274_cov_2.661692_g36825_i0	PRJNA944406	37784	274	2.661692	7.29303608	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	307	4.86e-79	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g36825	i0	88.327	136.609489051095	257	28	93	2	2	257	1713061	1713316	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	37431	307	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
5087868	5087868	PRJNA944406_P_NODE_8044_length_441_cov_3.584239_g7087_i0	PRJNA944406	8044	441	3.584239	15.80649399	Pseudodesulfovibrio	2035811	Bacteria	Bacteria	265	5.03e-66	NTclustered	gi\|365906293\|gb\|CP003220.1\|	641491	g7087	i0	78.043	421.328798185941	460	74	99	18	2	441	275913	275461	Pseudodesulfovibrio mercurii strain ND132 chromosome, complete genome	blastn	185806	265	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio mercurii
7302335	7302335	PRJNA944406_P_NODE_18286_length_307_cov_1.222222_g17327_i0	PRJNA944406	18286	307	1.222222	3.75222154	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	233	9.53e-57	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g17327	i0	82.772	134.465798045603	267	40	86	5	44	307	886837	886574	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	41281	233	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
7303020	7303020	PRJNA944406_P_NODE_8086_length_440_cov_2.288828_g7129_i0	PRJNA944406	8086	440	2.288828	10.0708432	Citrifermentans bremense	60035	Bacteria	Bacteria	335	3.769999999999999e-87	NTclustered	gi\|1886376207\|dbj\|AP023213.1\|	60035	g7129	i0	80.866	201.702272727273	439	73	99	8	4	440	3608672	3608243	Geobacter bremensis R4 DNA, complete genome	blastn	88749	335	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
8577745	8577745	PRJNA944406_P_NODE_68987_length_250_cov_0.870056_g68028_i0	PRJNA944406	68987	250	0.870056	2.17514	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	224	4.53e-54	NTclustered	gi\|2621784475\|emb\|OY780933.1\|	2795000	g68028	i0	83.607	45.812	244	35	96	5	1	241	1290907	1291148	MAG: Maridesulfovibrio sp. isolate 689ab4ac-13ae-4e01-b39b-c4f5232e5781 genome assembly, chromosome: 1	blastn	11453	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.
8577809	8577809	PRJNA944406_P_NODE_7547_length_457_cov_2.096354_g6591_i0	PRJNA944406	7547	457	2.096354	9.58033778	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	547	4.639999999999999e-151	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g6591	i0	88.453	320.431072210066	459	46	99	7	2	457	222434	221980	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	146437	547	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
11128440	11128440	PRJNA944406_P_NODE_61289_length_252_cov_2.067039_g60330_i0	PRJNA944406	61289	252	2.067039	5.20893828	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	128	3.69e-25	NTclustered	gi\|2065532709\|dbj\|AP024355.1\|	2802975	g60330	i0	91.489	52.734126984127	94	7	37	1	49	142	1404521	1404429	Desulfuromonas versatilis NIT-T3 DNA, complete genome	blastn	13289	128	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
11463226	11463226	PRJNA944406_P_NODE_29369_length_282_cov_2.220096_g28410_i0	PRJNA944406	29369	282	2.220096	6.26067072	root	1	Root_unresolved	Root_unresolved	204	6.789999999999998e-48	NTclustered	gi\|470477500\|ref\|NR_076387.1\|	19	g28410	i0	80.479	226.549645390071	292	36	100	15	1	282	2033	2313	Pelobacter carbinolicus strain Gra Bd 1 23S ribosomal RNA gene, complete sequence	blastn	63887	204	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
13678239	13678239	PRJNA944406_P_NODE_43331_length_269_cov_1.653061_g42372_i0	PRJNA944406	43331	269	1.653061	4.44673409	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	182	3.01e-41	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g42372	i0	81.448	75.0446096654275	221	41	82	0	1	221	1446872	1447092	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	20187	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
16561907	16561907	PRJNA944406_P_NODE_16093_length_321_cov_2.737903_g15134_i0	PRJNA944406	16093	321	2.737903	8.78866863	Desulfomicrobium	898	Bacteria	Bacteria	287	7.580000000000001e-73	NTclustered	gi\|470484403\|ref\|NR_076646.1\|	899	g15134	i0	82.866	197.884735202492	321	53	99	2	1	320	710	1029	Desulfomicrobium baculatum strain INMI strain X 23S ribosomal RNA gene, complete sequence	blastn	63521	287	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
16562003	16562003	PRJNA944406_P_NODE_4313_length_637_cov_1.852837_g3400_i0	PRJNA944406	4313	637	1.852837	11.80257169	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	339	4.34e-88	NTclustered	gi\|470474459\|ref\|NR_076217.1\|	881	g3400	i0	79.513	111.700156985871	493	87	76	13	54	538	655	1141	Desulfovibrio vulgaris strain Hildenborough 23S ribosomal RNA gene, complete sequence	blastn	71153	339	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
17503161	17503161	PRJNA944406_P_NODE_79094_length_248_cov_0.880000_g78135_i0	PRJNA944406	79094	248	0.88	2.1824	Geomonas sp. RF6	2897342	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2159823836\|gb\|CP087999.1\|	2897342	g78135	i0	100	0.116935483870968	29	0	12	0	24	52	4943195	4943167	Geomonas sp. RF6 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas sp. RF6
19110864	19110864	PRJNA944406_P_NODE_54715_length_259_cov_1.274194_g53756_i0	PRJNA944406	54715	259	1.274194	3.30016246	Desulfuromonas	890	Bacteria	Bacteria	104	6.42e-18	NTclustered	gi\|2621701248\|emb\|OY759968.1\|	57664	g53756	i0	84.762	22.7722007722008	105	14	40	2	8	111	3553	3656	MAG: Desulfuromonas thiophila isolate 5d13b52e-9f0b-4035-9b75-2cca1ad4870f genome assembly, chromosome: 1	blastn	5898	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
19110914	19110914	PRJNA944406_P_NODE_7075_length_475_cov_1.656716_g6119_i0	PRJNA944406	7075	475	1.656716	7.869401	Desulfocurvibacter	2582840	Bacteria	Bacteria	300	1.5e-76	NTclustered	gi\|470489697\|ref\|NR_076945.1\|	873	g6119	i0	78.769	225.32	471	83	97	16	15	475	26	489	Desulfovibrio africanus strain Walvis Bay 23S ribosomal RNA gene, complete sequence	blastn	107027	300	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
20051190	20051190	PRJNA944406_P_NODE_43236_length_269_cov_2.015306_g42277_i0	PRJNA944406	43236	269	2.015306	5.42117314	uncultured Desulforegula sp.	543080	Bacteria	Bacteria	396	9.88e-106	NTclustered	gi\|330374391\|gb\|JF413374.1\|	543080	g42277	i0	94.208	96.5576208178439	259	15	96	0	10	268	348	606	Uncultured Desulforegula sp. clone Flu3_55 16S ribosomal RNA gene, partial sequence	blastn	25974	396	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulforegulaceae	Desulforegula	uncultured Desulforegula sp.
20051227	20051227	PRJNA944406_P_NODE_47596_length_265_cov_1.822917_g46637_i0	PRJNA944406	47596	265	1.822917	4.83073005	Thermosulfuriphilus ammonigenes	1936021	Bacteria	Bacteria	122	1.8199999999999994e-23	NTclustered	gi\|1820436950\|gb\|CP048877.1\|	1936021	g46637	i0	83.459	240.124528301887	133	20	50	2	134	265	1150910	1150779	Thermosulfuriphilus ammonigenes strain ST65 chromosome, complete genome	blastn	63633	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermosulfuriphilus	Thermosulfuriphilus ammonigenes
20051493	20051493	PRJNA944406_P_NODE_74316_length_249_cov_0.875000_g73357_i0	PRJNA944406	74316	249	0.875	2.17875	uncultured Desulfosarcina sp.	218289	Bacteria	Bacteria	128	3.64e-25	NTclustered	gi\|2621713517\|emb\|OY771548.1\|	218289	g73357	i0	83.803	105.196787148594	142	15	56	7	105	243	92428	92292	MAG: uncultured Desulfosarcina sp. isolate c75788b4-9dc9-432e-af07-dc879bdb42fc genome assembly, chromosome: 1	blastn	26194	128	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	uncultured Desulfosarcina sp.
20385623	20385623	PRJNA944406_P_NODE_113476_length_215_cov_4.788732_g112517_i0	PRJNA944406	113476	215	4.788732	10.2957738	Desulfarculus	453229	Bacteria	Bacteria	141	3.93e-29	NTclustered	gi\|470486527\|ref\|NR_076763.1\|	453230	g112517	i0	82.911	43.1767441860465	158	26	73	1	37	193	1339	1496	Desulfarculus baarsii strain 2st14 23S ribosomal RNA gene, complete sequence	blastn	9283	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus baarsii
21661593	21661593	PRJNA944406_P_NODE_12577_length_356_cov_2.024735_g11618_i0	PRJNA944406	12577	356	2.024735	7.2080566	Desulfurivibrio	427922	Bacteria	Bacteria	202	3.1599999999999996e-47	NTclustered	gi\|470485970\|ref\|NR_076727.1\|	427923	g11618	i0	79.322	539.061797752809	295	55	82	6	42	333	1759	1468	Desulfurivibrio alkaliphilus strain AHT 2 23S ribosomal RNA gene, complete sequence	blastn	191906	202	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
21661656	21661656	PRJNA944406_P_NODE_29437_length_282_cov_2.014354_g28478_i0	PRJNA944406	29437	282	2.014354	5.68047828	Pseudomonadati	3379134	Bacteria	Bacteria	281	3.05e-71	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g28478	i0	85.106	391.336879432624	282	34	98	6	6	282	2332855	2333133	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	110357	281	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii
22937128	22937128	PRJNA944406_P_NODE_20278_length_293_cov_5.009091_g19319_i0	PRJNA944406	20278	293	5.009091	14.67663663	Desulfurivibrio	427922	Bacteria	Bacteria	220	7.04e-53	NTclustered	gi\|470485970\|ref\|NR_076727.1\|	427923	g19319	i0	80.822	189.815699658703	292	46	98	7	3	290	224	509	Desulfurivibrio alkaliphilus strain AHT 2 23S ribosomal RNA gene, complete sequence	blastn	55616	220	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
23877329	23877329	PRJNA944406_P_NODE_58299_length_255_cov_1.692308_g57340_i0	PRJNA944406	58299	255	1.692308	4.3153854	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	302	2.08e-77	NTclustered	gi\|2575803239\|emb\|OY729416.1\|	2202153	g57340	i0	88.583	132.847058823529	254	22	99	5	1	254	75701	75947	MAG: Thermodesulfobacteriota bacterium isolate ba02c5ff-97d3-4768-ae28-618c4039653d genome assembly, chromosome: 1	blastn	33876	302	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
23877612	23877612	PRJNA944406_P_NODE_8419_length_430_cov_2.571429_g7462_i0	PRJNA944406	8419	430	2.571429	11.0571447	Geomonas sp. RF6	2897342	Bacteria	Bacteria	351	3.65e-92	NTclustered	gi\|2159823836\|gb\|CP087999.1\|	2897342	g7462	i0	81.881	235.579069767442	436	62	100	14	1	424	259253	259683	Geomonas sp. RF6 chromosome, complete genome	blastn	101299	351	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas sp. RF6
24210967	24210967	PRJNA944406_P_NODE_23919_length_288_cov_1.232558_g22960_i0	PRJNA944406	23919	288	1.232558	3.54976704	Pseudomonadati	3379134	Bacteria	Bacteria	287	6.710000000000001e-73	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g22960	i0	84.722	255.555555555556	288	42	100	2	1	288	1713101	1713386	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	73600	287	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
24211201	24211201	PRJNA944406_P_NODE_9479_length_404_cov_0.906344_g8520_i0	PRJNA944406	9479	404	0.906344	3.66162976	Geotalea	2910589	Bacteria	Bacteria	276	2.11e-69	NTclustered	gi\|221562406\|gb\|CP001390.1\|	316067	g8520	i0	79.899	365.804455445545	398	63	96	15	2	390	2114709	2114320	Geobacter daltonii FRC-32, complete genome	blastn	147785	276	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea daltonii

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