metadata: contig_metadata: 18 rows where bioproject = "PRJNA492363", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA492363", tax_kingdom = "Pseudomonadati" 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
25839177	25839177	PRJNA492363_S_NODE_79851_length_214_cov_1.751634_g79030_i0	PRJNA492363	79851	214	1.751634	3.74849676	Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21	1797756	Bacteria	Bacteria	140	2.5e-37	NR	OGE24171.1	1797756	g79030	i0	94.3	0.981308411214953	70	4	98.1	0	210	1	82	151	OGE24171.1 MAG: citramalate synthase [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21]	diamond	210	140	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21
26033335	26033335	PRJNA492363_S_NODE_1732_length_766_cov_9.409929_g969_i0	PRJNA492363	1732	766	9.409929	72.08005614	Geobacter pickeringii	345632	Bacteria	Bacteria	139	1.14e-35	NR	WP_144400099.1	345632	g969	i0	44	1.06527415143603	141	78	55.2	1	312	734	5	144	WP_144400099.1 class I SAM-dependent methyltransferase [Geobacter pickeringii]	diamond	816	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
26382123	26382123	PRJNA492363_S_NODE_11399_length_287_cov_1.796460_g10578_i0	PRJNA492363	11399	287	1.79646	5.1558402	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	93.2	2.15e-20	NR	MBK5276973.1	2099678	g10578	i0	60.9	0.721254355400697	69	26	72.1	1	266	60	209	276	MBK5276973.1 radical SAM protein [Desulfuromonadales bacterium]	diamond	207	93.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
32952400	32952400	PRJNA492363_S_NODE_101042_length_201_cov_0.914286_g100221_i0	PRJNA492363	101042	201	0.914286	1.83771486	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	126	1.28e-32	NR	HET7289760.1	2202153	g100221	i0	97	0.985074626865672	66	2	98.5	0	200	3	118	183	HET7289760.1 sulfatase [Thermodesulfobacteriota bacterium]	diamond	198	126	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32952521	32952521	PRJNA492363_S_NODE_44202_length_235_cov_1.103448_g43381_i0	PRJNA492363	44202	235	1.103448	2.5931028	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	54.7	1.37e-6	NR	RJR32319.1	2049433	g43381	i0	49.1	1.48085106382979	55	28	70.2	0	2	166	172	226	RJR32319.1 MAG: hypothetical protein C4576_30665 [Desulfobacteraceae bacterium]	diamond	348	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
32952618	32952618	PRJNA492363_S_NODE_88106_length_208_cov_0.870748_g87285_i0	PRJNA492363	88106	208	0.870748	1.81115584	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	145	7.79e-39	NR	HET7289507.1	2202153	g87285	i0	98.5	1.96153846153846	68	1	98.1	0	206	3	307	374	HET7289507.1 excinuclease ABC subunit UvrA [Thermodesulfobacteriota bacterium]	diamond	408	145	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32969551	32969551	PRJNA492363_S_NODE_100930_length_201_cov_0.914286_g100109_i0	PRJNA492363	100930	201	0.914286	1.83771486	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	46.2	1.96e-4	NR	HET7289724.1	2202153	g100109	i0	87.5	0.358208955223881	24	3	35.8	0	3	74	67	90	HET7289724.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	72	46.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32969644	32969644	PRJNA492363_S_NODE_24938_length_244_cov_1.049180_g24117_i0	PRJNA492363	24938	244	1.04918	2.5599992	Pseudodesulfovibrio hydrargyri	2125990	Bacteria	Bacteria	42.4	0.0488	NR	WP_071544596.1	2125990	g24117	i0	34.4	0.75	61	33	75	1	36	218	76	129	WP_071544596.1 glycosyltransferase family 4 protein [Pseudodesulfovibrio hydrargyri]	diamond	183	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio hydrargyri
32986718	32986718	PRJNA492363_S_NODE_85995_length_209_cov_1.297297_g85174_i0	PRJNA492363	85995	209	1.297297	2.71135073	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	65.9	1.05e-10	NR	HET7290655.1	2202153	g85174	i0	96.9	0.45933014354067	32	1	45.9	0	209	114	252	283	HET7290655.1 metal ABC transporter permease [Thermodesulfobacteriota bacterium]	diamond	96	65.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
33060762	33060762	PRJNA492363_S_NODE_2613_length_552_cov_7.696538_g1806_i0	PRJNA492363	2613	552	7.696538	42.48488976	Pseudomonadati	3379134	Bacteria	Bacteria	154	1.77e-42	NR	WP_144400099.1	345632	g1806	i0	47.9	2.85869565217391	169	83	91.8	3	3	509	138	301	WP_144400099.1 class I SAM-dependent methyltransferase [Geobacter pickeringii]	diamond	1578	155	0.993548387096774	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
33071636	33071636	PRJNA492363_S_NODE_101021_length_201_cov_0.914286_g100200_i0	PRJNA492363	101021	201	0.914286	1.83771486	Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21	1797756	Bacteria	Bacteria	119	9.13e-31	NR	OGE23358.1	1797756	g100200	i0	95	1.7910447761194	60	3	89.6	0	200	21	111	170	OGE23358.1 MAG: isocitrate dehydrogenase [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21]	diamond	360	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21
33071887	33071887	PRJNA492363_S_NODE_95021_length_204_cov_1.342657_g94200_i0	PRJNA492363	95021	204	1.342657	2.73902028	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	139	4.94e-38	NR	HKQ31560.1	2202153	g94200	i0	98.5	1.97058823529412	67	1	98.5	0	2	202	224	290	HKQ31560.1 NAD-dependent DNA ligase LigA [Thermodesulfobacteriota bacterium]	diamond	402	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
33111955	33111955	PRJNA492363_S_NODE_63438_length_227_cov_1.451807_g62617_i0	PRJNA492363	63438	227	1.451807	3.29560189	Syntrophorhabdus	513557	Bacteria	Bacteria	71.2	4.38e-13	NR	OPY65060.1	1811702	g62617	i0	50	2.77533039647577	70	34	91.2	1	6	212	106	175	OPY65060.1 MAG: hypothetical protein A4E62_02755 [Syntrophorhabdus sp. PtaU1.Bin002]	diamond	630	71.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae	Syntrophorhabdus	Syntrophorhabdus sp. PtaU1.Bin002
33140096	33140096	PRJNA492363_S_NODE_68607_length_224_cov_2.355828_g67786_i0	PRJNA492363	68607	224	2.355828	5.27705472	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	53.5	2.15e-6	NR	HET7290084.1	2202153	g67786	i0	96.7	0.803571428571429	30	1	40.2	0	91	2	1	30	HET7290084.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	180	53.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
33157151	33157151	PRJNA492363_S_NODE_91352_length_206_cov_1.324138_g90531_i0	PRJNA492363	91352	206	1.324138	2.72772428	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	123	7.28e-32	NR	NTW87884.1	2053307	g90531	i0	86.4	3.84466019417476	66	9	96.1	0	205	8	296	361	NTW87884.1 AAA family ATPase [Desulfobulbaceae bacterium]	diamond	792	123	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
33163095	33163095	PRJNA492363_S_NODE_100816_length_201_cov_1.371429_g99995_i0	PRJNA492363	100816	201	1.371429	2.75657229	Bacteria	2	Bacteria	Bacteria	94.7	1.18e-22	NR	OGE19753.1	1797756	g99995	i0	92.4	1.97014925373134	66	5	98.5	0	3	200	57	122	OGE19753.1 MAG: hypothetical protein A3J42_01315 [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21]	diamond	396	94.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21
33174255	33174255	PRJNA492363_S_NODE_13784_length_267_cov_1.242718_g12963_i0	PRJNA492363	13784	267	1.242718	3.31805706	Desulfotalea sp.	2030813	Bacteria	Bacteria	124	1.09e-31	NR	PHR30074.1	2030813	g12963	i0	72.6	1.64044943820225	73	20	82	0	266	48	294	366	PHR30074.1 MAG: dTDP-4-amino-4,6-dideoxygalactose transaminase [Desulfotalea sp.]	diamond	438	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfotalea	Desulfotalea sp.
33180377	33180377	PRJNA492363_S_NODE_70224_length_223_cov_1.975309_g69403_i0	PRJNA492363	70224	223	1.975309	4.40493907	Desulfocapsa	53318	Bacteria	Bacteria	97.4	4e-22	NR	WP_041916428.1	65555	g69403	i0	59.5	5.91928251121076	74	30	99.6	0	223	2	182	255	WP_041916428.1 retron St85 family RNA-directed DNA polymerase [Desulfocapsa sulfexigens]	diamond	1320	97.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sulfexigens

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