metadata: contig_metadata: 20 rows where bioproject = "PRJNA1166865" and tax

20 rows where bioproject = "PRJNA1166865" 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
2863939	2863939	PRJNA1166865_P_NODE_51543_length_307_cov_1.974359_g51302_i0	PRJNA1166865	51543	307	1.974359	6.06128213	Geomonas nitrogeniifigens	2843197	Bacteria	Bacteria	60.2	1.71e-4	NTclustered	gi\|2056222742\|gb\|CP076724.1\|	2847991	g51302	i0	81.013	39.5635179153094	79	11	25	4	1	77	667024	666948	Geomonas nitrogeniifigens strain RG29 chromosome, complete genome	blastn	12146	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas nitrogeniifigens
9240633	9240633	PRJNA1166865_P_NODE_35388_length_364_cov_1.625430_g35147_i0	PRJNA1166865	35388	364	1.62543	5.9165652	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	178	2.649999999999999e-55	NR	GJM17744.1	2202153	g35147	i0	73.5	0.964285714285714	117	31	96.4	0	5	355	11	127	GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium]	diamond	351	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
17617379	17617379	PRJNA1166865_P_NODE_75254_length_251_cov_0.865169_g75013_i0	PRJNA1166865	75254	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g75013	i0	100	0.334661354581673	28	0	11	0	221	248	1669271	1669298	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
19438503	19438503	PRJNA1166865_P_NODE_29816_length_394_cov_1.919003_g29575_i0	PRJNA1166865	29816	394	1.919003	7.56087182	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	58.4	8.1e-4	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g29575	i0	100	0.548223350253807	31	0	8	0	246	276	3214337	3214307	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	216	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
23991780	23991780	PRJNA1166865_P_NODE_45539_length_325_cov_1.789683_g45298_i0	PRJNA1166865	45539	325	1.789683	5.81646975	Desulfobulbaceae bacterium BRH_c16a	1629713	Bacteria	Bacteria	97.8	1.4e-21	NR	KJS02832.1	1629713	g45298	i0	64.3	1.33846153846154	70	25	64.6	0	109	318	5	74	KJS02832.1 MAG: hypothetical protein VR65_03850 [Desulfobulbaceae bacterium BRH_c16a]	diamond	435	97.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium BRH_c16a
24538743	24538743	PRJNA1166865_P_NODE_400_length_1977_cov_3.653361_g374_i0	PRJNA1166865	400	1977	3.653361	72.22694697	Citrifermentans bremense	60035	Bacteria	Bacteria	58.4	0.004	NTclustered	gi\|1886376207\|dbj\|AP023213.1\|	60035	g374	i0	92.683	0.020738492665655	41	1	2	2	251	290	4358509	4358548	Geobacter bremensis R4 DNA, complete genome	blastn	41	58.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
26819103	26819103	PRJNA1166865_P_NODE_88901_length_244_cov_0.900585_g88660_i0	PRJNA1166865	88901	244	0.900585	2.1974274	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	57.8	1.91e-7	NR	HAO22905.1	2049433	g88660	i0	30.9	0.995901639344262	81	54	99.6	2	244	2	411	489	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	243	57.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
27451531	27451531	PRJNA1166865_P_NODE_38603_length_350_cov_1.342960_g38362_i0	PRJNA1166865	38603	350	1.34296	4.70036	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	47	0.00265	NR	GJM17643.1	2202153	g38362	i0	32.9	0.677142857142857	79	52	66.9	1	299	66	135	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	237	47	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
27482902	27482902	PRJNA1166865_P_NODE_72183_length_257_cov_1.673913_g71942_i0	PRJNA1166865	72183	257	1.673913	4.30195641	Bilophila wadsworthia	35833	Bacteria	Bacteria	70.5	2.09e-12	NR	WP_347865643.1	35833	g71942	i0	46.1	0.88715953307393	76	37	88.7	1	2	229	65	136	WP_347865643.1 thrombospondin type-1 domain-containing protein [Bilophila wadsworthia]	diamond	228	70.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
27546045	27546045	PRJNA1166865_P_NODE_67164_length_269_cov_1.571429_g66923_i0	PRJNA1166865	67164	269	1.571429	4.22714401	Trichlorobacter sp.	2911007	Bacteria	Bacteria	72.4	1.28e-13	NR	WP_300740641.1	2911007	g66923	i0	39.3	1.98513011152416	89	54	99.3	0	1	267	49	137	WP_300740641.1 PaaI family thioesterase [Trichlorobacter sp.]	diamond	534	72.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Trichlorobacter	Trichlorobacter sp.
27735769	27735769	PRJNA1166865_P_NODE_11464_length_630_cov_2.104129_g11232_i0	PRJNA1166865	11464	630	2.104129	13.2560127	Desulfamplus sp.	2006184	Bacteria	Bacteria	171	2.05e-49	NR	MBF0303540.1	2006184	g11232	i0	63.6	6.5	132	47	62.9	1	530	135	104	234	MBF0303540.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Desulfamplus sp.]	diamond	4095	171	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfamplus	Desulfamplus sp.
27767273	27767273	PRJNA1166865_P_NODE_68564_length_266_cov_1.196891_g68323_i0	PRJNA1166865	68564	266	1.196891	3.18373006	Candidatus Magnetomorum sp. HK-1	1509431	Bacteria	Bacteria	43.5	0.0259	NR	KPA09161.1	1509431	g68323	i0	37.1	0.699248120300752	62	39	69.9	0	2	187	448	509	KPA09161.1 secreted protein containing Fibrinogen, alpha/beta/gamma chain [Candidatus Magnetomorum sp. HK-1]	diamond	186	43.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1
29851067	29851067	PRJNA1166865_P_NODE_87391_length_245_cov_0.895349_g87150_i0	PRJNA1166865	87391	245	0.895349	2.19360505	Syntrophus	43773	Bacteria	Bacteria	62	5.92e-9	NR	WP_367359683.1	43773	g87150	i0	45.6	0.697959183673469	57	31	69.8	0	191	21	14	70	WP_367359683.1 MULTISPECIES: glycosyltransferase family 4 protein [Syntrophus]	diamond	171	62	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus
30439095	30439095	PRJNA1166865_P_NODE_70373_length_262_cov_0.920635_g70132_i0	PRJNA1166865	70373	262	0.920635	2.4120637	Pseudomonadati	3379134	Bacteria	Bacteria	112	8.82e-27	NR	ETR68999.1	890399	g70132	i0	65.5	2.98854961832061	87	30	99.6	0	2	262	492	578	ETR68999.1 MAG: FAD-dependent pyridine nucleotide-disulfide oxidoreductase [Candidatus Magnetoglobus multicellularis str. Araruama]	diamond	783	113	0.991150442477876	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Candidatus Magnetoglobus	Candidatus Magnetoglobus multicellularis
31399488	31399488	PRJNA1166865_P_NODE_92276_length_242_cov_0.911243_g92035_i0	PRJNA1166865	92276	242	0.911243	2.20520806	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	45.8	0.00123	NR	MEN8190405.1	2202153	g92035	i0	62.1	0.359504132231405	29	11	36	0	155	241	33	61	MEN8190405.1 DUF1566 domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	87	45.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31620671	31620671	PRJNA1166865_P_NODE_84556_length_246_cov_0.890173_g84315_i0	PRJNA1166865	84556	246	0.890173	2.18982558	Geobacter sp. OR-1	1266765	Bacteria	Bacteria	47	0.00122	NR	WP_052440407.1	1266765	g84315	i0	41.3	1.53658536585366	63	30	76.8	1	245	57	523	578	WP_052440407.1 PAS domain S-box protein [Geobacter sp. OR-1]	diamond	378	47	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. OR-1
31778776	31778776	PRJNA1166865_P_NODE_78097_length_250_cov_0.870056_g77856_i0	PRJNA1166865	78097	250	0.870056	2.17514	Candidatus Adiutrix sp.	2872164	Bacteria	Bacteria	50.4	6.9e-5	NR	MDR2725185.1	2872164	g77856	i0	47.5	1.524	61	30	73.2	1	233	51	40	98	MDR2725185.1 ankyrin repeat domain-containing protein [Candidatus Adiutrix sp.]	diamond	381	50.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Candidatus Adiutricales	Candidatus Adiutricaceae	Candidatus Adiutrix	Candidatus Adiutrix sp.
32411768	32411768	PRJNA1166865_P_NODE_92459_length_242_cov_0.911243_g92218_i0	PRJNA1166865	92459	242	0.911243	2.20520806	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	63.5	1.23e-9	NR	MCP4747873.1	2049433	g92218	i0	46.8	0.979338842975207	79	31	97.9	2	4	240	87	154	MCP4747873.1 SAM-dependent methyltransferase [Desulfobacteraceae bacterium]	diamond	237	63.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
32570110	32570110	PRJNA1166865_P_NODE_68439_length_266_cov_1.544041_g68198_i0	PRJNA1166865	68439	266	1.544041	4.10714906	Candidatus Electronema aureum	2005002	Bacteria	Bacteria	75.1	5.75e-14	NR	TAA75345.1	2005002	g68198	i0	65	0.676691729323308	60	20	67.7	1	86	265	89	147	TAA75345.1 MAG: FKBP-type peptidyl-prolyl cis-trans isomerase FkpA/FKBP-type peptidyl-prolyl cis-trans isomerase FklB [Candidatus Electronema aureum]	diamond	180	75.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema aureum
32821707	32821707	PRJNA1166865_P_NODE_72640_length_256_cov_1.683060_g72399_i0	PRJNA1166865	72640	256	1.68306	4.3086336	Pelobacter propionicus	29543	Bacteria	Bacteria	87.8	7.51e-19	NR	WP_041532141.1	29543	g72399	i0	55.3	1.83984375	76	31	87.9	2	30	254	12	85	WP_041532141.1 alpha/beta fold hydrolase [Pelobacter propionicus]	diamond	471	87.8	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);;