metadata: contig_metadata: 25 rows where bioproject = "PRJNA1143173" and tax

25 rows where bioproject = "PRJNA1143173" 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
285842	285842	PRJNA1143173_P_NODE_10241_length_310_cov_4.126582_g10215_i0	PRJNA1143173	10241	310	4.126582	12.7924042	Geomonas paludis	2740185	Bacteria	Bacteria	122	2.1799999999999999e-23	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g10215	i0	85.47	0.37741935483871	117	17	38	0	194	310	916872	916756	Geomonas paludis strain RG22 chromosome, complete genome	blastn	117	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
8685865	8685865	PRJNA1143173_P_NODE_30827_length_255_cov_5.642857_g30801_i0	PRJNA1143173	30827	255	5.642857	14.38928535	Geotalea	2910589	Bacteria	Bacteria	231	2.7699999999999997e-56	NTclustered	gi\|470481994\|ref\|NR_076507.1\|	351604	g30801	i0	84.016	265.301960784314	244	35	95	4	10	250	2933	2691	Geobacter uraniireducens strain Rf4 23S ribosomal RNA gene, complete sequence	blastn	67652	231	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
14315217	14315217	PRJNA1143173_P_NODE_28632_length_261_cov_7.829787_g28606_i0	PRJNA1143173	28632	261	7.829787	20.43574407	Desulfuromonas soudanensis	1603606	Bacteria	Bacteria	165	2.93e-36	NTclustered	gi\|924528553\|gb\|CP010802.1\|	1603606	g28606	i0	78.295	21.9463601532567	258	54	98	2	3	259	1553412	1553668	Desulfuromonas soudanensis strain WTL chromosome, complete genome	blastn	5728	165	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis
21963091	21963091	PRJNA1143173_P_NODE_30278_length_257_cov_3.135870_g30252_i0	PRJNA1143173	30278	257	3.13587	8.0591859	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	85.5	8.12e-18	NR	NIQ15047.1	2080303	g30252	i0	47.1	0.992217898832685	85	45	99.2	0	2	256	133	217	NIQ15047.1 AAA family ATPase [Candidatus Dadabacteria bacterium]	diamond	255	85.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
23238503	23238503	PRJNA1143173_P_NODE_21419_length_283_cov_2.166667_g21393_i0	PRJNA1143173	21419	283	2.166667	6.13166761	Desulfomicrobium orale	132132	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|987456218\|gb\|CP014230.1\|	888061	g21393	i0	100	1	283	0	100	0	1	283	1386607	1386889	Desulfomicrobium orale DSM 12838 chromosome, complete genome	blastn	283	523	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium orale
26806251	26806251	PRJNA1143173_P_NODE_35521_length_242_cov_2.704142_g35495_i0	PRJNA1143173	35521	242	2.704142	6.54402364	Pseudomonadati	3379134	Bacteria	Bacteria	57	2.59e-7	NR	MCP4353702.1	2044940	g35495	i0	40	2.02066115702479	80	45	99.2	2	1	240	124	200	MCP4353702.1 hypothetical protein [Desulfobacterales bacterium]	diamond	489	57.4	0.993031358885017	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
26849082	26849082	PRJNA1143173_P_NODE_15841_length_298_cov_2.364444_g15815_i0	PRJNA1143173	15841	298	2.364444	7.04604312	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	54.7	2.46e-6	NR	MFI5323477.1	2202153	g15815	i0	62.9	0.704697986577181	35	13	35.2	0	2	106	182	216	MFI5323477.1 MBL fold metallo-hydrolase [Thermodesulfobacteriota bacterium]	diamond	210	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
27312539	27312539	PRJNA1143173_P_NODE_32903_length_249_cov_6.448864_g32877_i0	PRJNA1143173	32903	249	6.448864	16.05767136	Pseudomonadati	3379134	Bacteria	Bacteria	166	4.8200000000000004e-49	NR	MFA5719312.1	2053307	g32877	i0	100	1.97590361445783	82	0	98.8	0	3	248	92	173	MFA5719312.1 LysR family transcriptional regulator [Desulfobulbaceae bacterium]	diamond	492	166	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
27691621	27691621	PRJNA1143173_P_NODE_24444_length_274_cov_2.308458_g24418_i0	PRJNA1143173	24444	274	2.308458	6.32517492	Pseudomonadati	3379134	Bacteria	Bacteria	180	1.4499999999999995e-55	NR	WP_240191876.1	1506996	g24418	i0	100	1.99270072992701	91	0	99.6	0	274	2	103	193	WP_240191876.1 ATP-binding protein, partial [Desulfoprunum benzoelyticum]	diamond	546	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfoprunum	Desulfoprunum benzoelyticum
27923235	27923235	PRJNA1143173_P_NODE_7265_length_311_cov_6.537815_g7239_i0	PRJNA1143173	7265	311	6.537815	20.33260465	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	69.7	5.38e-13	NR	NIQ15603.1	2080303	g7239	i0	46.2	0.752411575562701	78	39	72.3	1	7	231	20	97	NIQ15603.1 hypothetical protein [Candidatus Dadabacteria bacterium]	diamond	234	69.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
28081015	28081015	PRJNA1143173_P_NODE_15365_length_298_cov_5.328889_g15339_i0	PRJNA1143173	15365	298	5.328889	15.88008922	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	53.9	7.33e-7	NR	NIQ16115.1	2080303	g15339	i0	48.1	0.523489932885906	52	24	49.3	1	3	149	49	100	NIQ16115.1 hypothetical protein [Candidatus Dadabacteria bacterium]	diamond	156	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
29060015	29060015	PRJNA1143173_P_NODE_22628_length_279_cov_3.815534_g22602_i0	PRJNA1143173	22628	279	3.815534	10.64533986	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	121	2.6999999999999997e-31	NR	MEZ4547296.1	2202153	g22602	i0	96.7	1.96774193548387	61	2	65.6	0	1	183	230	290	MEZ4547296.1 aldehyde dehydrogenase family protein [Thermodesulfobacteriota bacterium]	diamond	549	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29364793	29364793	PRJNA1143173_P_NODE_11649_length_310_cov_2.856540_g11623_i0	PRJNA1143173	11649	310	2.85654	8.855274	Pseudomonadati	3379134	Bacteria	Bacteria	68.6	2.6e-11	NR	OQX25691.1	1934248	g11623	i0	76.2	0.812903225806452	42	10	40.6	0	128	3	1	42	OQX25691.1 MAG: hypothetical protein BWK80_14295 [Desulfobacteraceae bacterium IS3]	diamond	252	68.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium IS3
30070322	30070322	PRJNA1143173_P_NODE_27972_length_263_cov_6.394737_g27946_i0	PRJNA1143173	27972	263	6.394737	16.81815831	Smithella sp.	2053614	Bacteria	Bacteria	124	9.65e-31	NR	MEN6623048.1	2053614	g27946	i0	63.2	3.96958174904943	87	32	99.2	0	263	3	402	488	MEN6623048.1 phage tail sheath subtilisin-like domain-containing protein [Smithella sp.]	diamond	1044	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
30670653	30670653	PRJNA1143173_P_NODE_38273_length_232_cov_7.094340_g38247_i0	PRJNA1143173	38273	232	7.09434	16.4588688	Nitratidesulfovibrio sp. 12	2802297	Bacteria	Bacteria	50.1	2.82e-5	NR	WP_333507551.1	3084053	g38247	i0	50	1.44827586206897	58	29	75	0	56	229	3	60	WP_333507551.1 response regulator [Nitratidesulfovibrio sp. 1201_IL3209]	diamond	336	50.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. 1201_IL3209
30733872	30733872	PRJNA1143173_P_NODE_17574_length_294_cov_2.963801_g17548_i0	PRJNA1143173	17574	294	2.963801	8.71357494	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	183	2.58e-51	NR	MCC6712194.1	2080303	g17548	i0	92.8	0.989795918367347	97	7	99	0	2	292	1256	1352	MCC6712194.1 DEAD/DEAH box helicase [Candidatus Dadabacteria bacterium]	diamond	291	183	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
30754603	30754603	PRJNA1143173_P_NODE_18674_length_291_cov_2.766055_g18648_i0	PRJNA1143173	18674	291	2.766055	8.04922005	Pseudomonadati	3379134	Bacteria	Bacteria	107	9.17e-25	NR	MBI4800194.1	2093367	g18648	i0	51.5	25	97	47	100	0	291	1	306	402	MBI4800194.1 EAL domain-containing protein [Desulfarculus sp.]	diamond	7275	107	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus sp.
31144236	31144236	PRJNA1143173_P_NODE_44035_length_201_cov_8.625000_g44009_i0	PRJNA1143173	44035	201	8.625	17.33625	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	69.7	6.32e-12	NR	NIQ13763.1	2080303	g44009	i0	48.5	1.01492537313433	68	34	100	1	201	1	165	232	NIQ13763.1 hypothetical protein [Candidatus Dadabacteria bacterium]	diamond	204	69.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
31207385	31207385	PRJNA1143173_P_NODE_11735_length_310_cov_2.772152_g11709_i0	PRJNA1143173	11735	310	2.772152	8.5936712	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	69.3	3.37e-11	NR	NIQ13497.1	2080303	g11709	i0	61.2	0.474193548387097	49	19	47.4	0	309	163	286	334	NIQ13497.1 hypothetical protein [Candidatus Dadabacteria bacterium]	diamond	147	69.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
31829261	31829261	PRJNA1143173_P_NODE_15717_length_298_cov_3.253333_g15691_i0	PRJNA1143173	15717	298	3.253333	9.69493234	Pseudomonadati	3379134	Bacteria	Bacteria	96.7	3.18e-21	NR	WP_031386686.1	159290	g15691	i0	89.6	9.70469798657718	48	5	48.3	0	6	149	155	202	WP_031386686.1 N-acetyl sugar amidotransferase [Desulfonatronum thiodismutans]	diamond	2892	96.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronaceae	Desulfonatronum	Desulfonatronum thiodismutans
32019288	32019288	PRJNA1143173_P_NODE_16818_length_296_cov_3.170404_g16792_i0	PRJNA1143173	16818	296	3.170404	9.38439584	Bacteria	2	Bacteria	Bacteria	90.5	1.22e-19	NR	MCC6712363.1	2080303	g16792	i0	84	1.52027027027027	50	8	50.7	0	294	145	163	212	MCC6712363.1 putative Ig domain-containing protein [Candidatus Dadabacteria bacterium]	diamond	450	90.9	0.995599559955996	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
32272631	32272631	PRJNA1143173_P_NODE_33738_length_247_cov_3.770115_g33712_i0	PRJNA1143173	33738	247	3.770115	9.31218405	Thermodesulfobacteriota	200940	Bacteria	Bacteria	103	7.02e-25	NR	MDH3868253.1	2099678	g33712	i0	70.1	2.4412955465587	67	20	81.4	0	242	42	174	240	MDH3868253.1 SDR family oxidoreductase [Desulfuromonadales bacterium]	diamond	603	103	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
32568419	32568419	PRJNA1143173_P_NODE_22219_length_280_cov_5.304348_g22193_i0	PRJNA1143173	22219	280	5.304348	14.852174400000001	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	52.8	1.31e-5	NR	NIQ15093.1	2080303	g22193	i0	44.8	0.621428571428571	58	32	62.1	0	1	174	190	247	NIQ15093.1 hypothetical protein [Candidatus Dadabacteria bacterium]	diamond	174	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
32662420	32662420	PRJNA1143173_P_NODE_18220_length_292_cov_4.716895_g18194_i0	PRJNA1143173	18220	292	4.716895	13.7733334	Desulfovibrio sp.	885	Bacteria	Bacteria	196	2.17e-61	NR	MEE0406479.1	885	g18194	i0	100	1.99315068493151	97	0	99.7	0	291	1	42	138	MEE0406479.1 DUF4037 domain-containing protein [Desulfovibrio sp.]	diamond	582	196	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
32683006	32683006	PRJNA1143173_P_NODE_23100_length_278_cov_1.712195_g23074_i0	PRJNA1143173	23100	278	1.712195	4.7599021	root	1	Root_unresolved	Root_unresolved	101	5.49e-25	NR	HQN19095.1	2052185	g23074	i0	51.7	2.90287769784173	89	42	95	1	2	265	47	135	HQN19095.1 hypothetical protein [Syntrophobacteraceae bacterium]	diamond	807	102	0.990196078431373	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium

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