metadata: contig_metadata: 30 rows where bioproject = "PRJNA743294", tax_kingdom = "Pseudomonadati" and tax

30 rows where bioproject = "PRJNA743294", 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
5825614	5825614	PRJNA743294_P_NODE_31045_length_299_cov_2.061947_g30589_i0	PRJNA743294	31045	299	2.061947	6.16522153	root	1	Root_unresolved	Root_unresolved	190	5.3399999999999985e-56	NR	WP_005991508.1	878	g30589	i0	84.8	25.8260869565217	99	15	99.3	0	298	2	124	222	WP_005991508.1 catalase [Solidesulfovibrio fructosivorans]	diamond	7722	190	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio fructosivorans
8375212	8375212	PRJNA743294_P_NODE_13227_length_439_cov_2.062842_g12771_i0	PRJNA743294	13227	439	2.062842	9.05587638	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	249	2.2199999999999995e-82	NR	GJM17675.1	2202153	g12771	i0	83.6	2.99316628701595	146	24	99.8	0	439	2	9	154	GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium]	diamond	1314	249	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
13952313	13952313	PRJNA743294_P_NODE_57551_length_237_cov_3.914634_g57095_i0	PRJNA743294	57551	237	3.914634	9.27768258	Thermodesulfobacteriota	200940	Bacteria	Bacteria	231	2.55e-56	NTclustered	gi\|662020026\|ref\|NR_121913.1\|	891	g57095	i0	84.583	245.291139240506	240	29	100	8	1	237	1095	861	Desulfuromonas acetoxidans strain DSM 684 23S ribosomal RNA gene, complete sequence	blastn	58134	233	0.991416309012876	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas acetoxidans
14751012	14751012	PRJNA743294_P_NODE_41472_length_264_cov_4.931937_g41016_i0	PRJNA743294	41472	264	4.931937	13.02031368	uncultured Syntrophobacter sp.	281272	Bacteria	Bacteria	372	1.63e-98	NTclustered	gi\|2621703986\|emb\|OY762941.1\|	281272	g41016	i0	92.045	256.757575757576	264	21	100	0	1	264	1625588	1625325	MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1	blastn	67784	372	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	uncultured Syntrophobacter sp.
16024686	16024686	PRJNA743294_P_NODE_40753_length_266_cov_4.082902_g40297_i0	PRJNA743294	40753	266	4.082902	10.86051932	uncultured Syntrophobacter sp.	281272	Bacteria	Bacteria	435	2.07e-117	NTclustered	gi\|2621703986\|emb\|OY762941.1\|	281272	g40297	i0	96.226	171.492481203008	265	10	99	0	1	265	1624586	1624322	MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1	blastn	45617	435	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	uncultured Syntrophobacter sp.
19050099	19050099	PRJNA743294_P_NODE_4715_length_701_cov_3.995223_g4292_i0	PRJNA743294	4715	701	3.995223	28.00651323	Syntrophobacter	29526	Bacteria	Bacteria	935	0	NTclustered	gi\|470481149\|ref\|NR_076457.1\|	119484	g4292	i0	90.483	191.603423680457	725	45	100	11	1	701	556	1280	Syntrophobacter fumaroxidans strain MPOB 23S ribosomal RNA gene, complete sequence	blastn	134314	935	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
22399407	22399407	PRJNA743294_P_NODE_18838_length_373_cov_1.420000_g18382_i0	PRJNA743294	18838	373	1.42	5.2966	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	186	7.14e-52	NR	WP_027714997.1	1232410	g18382	i0	69.1	32.4209115281501	123	38	98.9	0	371	3	519	641	WP_027714997.1 pyruvate, phosphate dikinase [Desulfuromonas sp. TF]	diamond	12093	187	0.994652406417112	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp. TF
26989112	26989112	PRJNA743294_P_NODE_46802_length_252_cov_2.368715_g46346_i0	PRJNA743294	46802	252	2.368715	5.9691618	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	63.9	1.34e-9	NR	HVN96031.1	2660714	g46346	i0	38.3	4.84523809523809	81	49	95.2	1	6	245	7	87	HVN96031.1 pitrilysin family protein [Syntrophorhabdaceae bacterium]	diamond	1221	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
27084295	27084295	PRJNA743294_P_NODE_36362_length_280_cov_1.483092_g35906_i0	PRJNA743294	36362	280	1.483092	4.1526576	Desulfatirhabdium butyrativorans	340467	Bacteria	Bacteria	68.2	5.43e-11	NR	WP_245589143.1	340467	g35906	i0	44.4	6.83571428571429	90	47	96.4	1	8	277	176	262	WP_245589143.1 TIGR00266 family protein [Desulfatirhabdium butyrativorans]	diamond	1914	68.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatirhabdiaceae	Desulfatirhabdium	Desulfatirhabdium butyrativorans
27210431	27210431	PRJNA743294_P_NODE_18882_length_372_cov_4.177258_g18426_i0	PRJNA743294	18882	372	4.177258	15.53939976	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	60.8	2.27e-8	NR	MDD2899183.1	2099677	g18426	i0	72.7	0.709677419354839	44	12	35.5	0	370	239	160	203	MDD2899183.1 NAD(P)H:quinone oxidoreductase [Desulfuromonadaceae bacterium]	diamond	264	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
27252270	27252270	PRJNA743294_P_NODE_46303_length_253_cov_0.866667_g45847_i0	PRJNA743294	46303	253	0.866667	2.19266751	Pseudomonadati	3379134	Bacteria	Bacteria	50.1	1.07e-4	NR	HBB16386.1	48412	g45847	i0	36.8	4.79051383399209	57	36	67.6	0	252	82	325	381	HBB16386.1 cyclic nucleotide-binding protein [Syntrophus sp. (in: bacteria)]	diamond	1212	50.4	0.994047619047619	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus sp. (in: bacteria)
27684796	27684796	PRJNA743294_P_NODE_46284_length_253_cov_0.866667_g45828_i0	PRJNA743294	46284	253	0.866667	2.19266751	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	108	9.67e-27	NR	MBF0120026.1	2044940	g45828	i0	56	0.99604743083004	84	37	99.6	0	1	252	9	92	MBF0120026.1 SDR family oxidoreductase [Desulfobacterales bacterium]	diamond	252	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
28158337	28158337	PRJNA743294_P_NODE_9765_length_505_cov_6.659722_g9309_i0	PRJNA743294	9765	505	6.659722	33.6315961	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	125	1.15e-31	NR	MCA1786913.1	2049433	g9309	i0	48.1	2.34653465346535	131	66	77.8	1	111	503	16	144	MCA1786913.1 arginine kinase [Desulfobacteraceae bacterium]	diamond	1185	125	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
28505340	28505340	PRJNA743294_P_NODE_44467_length_257_cov_1.576087_g44011_i0	PRJNA743294	44467	257	1.576087	4.05054359	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	134	2.86e-38	NR	GJM17744.1	2202153	g44011	i0	78.6	0.980544747081712	84	18	98.1	0	253	2	11	94	GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium]	diamond	252	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28505356	28505356	PRJNA743294_P_NODE_5467_length_654_cov_4.478485_g5020_i0	PRJNA743294	5467	654	4.478485	29.2892919	Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21	1797756	Bacteria	Bacteria	117	2.87e-26	NR	OGE24405.1	1797756	g5020	i0	36.1	2.10091743119266	241	128	100	7	654	1	547	784	OGE24405.1 MAG: hypothetical protein A3J42_06930 [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21]	diamond	1374	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21
28600218	28600218	PRJNA743294_P_NODE_34407_length_286_cov_2.938967_g33951_i0	PRJNA743294	34407	286	2.938967	8.40544562	Desulfuromonas sp.	892	Bacteria	Bacteria	74.3	4.25e-14	NR	MCD6527229.1	892	g33951	i0	45.6	0.828671328671329	79	42	81.8	1	285	52	80	158	MCD6527229.1 hypothetical protein [Desulfuromonas sp.]	diamond	237	74.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp.
29326168	29326168	PRJNA743294_P_NODE_1969_length_1029_cov_8.467573_g1692_i0	PRJNA743294	1969	1029	8.467573	87.13132617	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	180	4.719999999999999e-47	NR	NVN90848.1	2099678	g1692	i0	38.9	1.55685131195335	285	156	78.1	5	36	839	336	619	NVN90848.1 5-histidylcysteine sulfoxide synthase [Desulfuromonadales bacterium]	diamond	1602	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
29494229	29494229	PRJNA743294_P_NODE_26810_length_319_cov_2.178862_g26354_i0	PRJNA743294	26810	319	2.178862	6.95056978	Bacteria	2	Bacteria	Bacteria	43.9	0.0314	NR	MCF8052891.1	2044940	g26354	i0	42.6	1.25078369905956	54	29	48.9	1	4	159	75	128	MCF8052891.1 DMT family transporter [Desulfobacterales bacterium]	diamond	399	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
30147118	30147118	PRJNA743294_P_NODE_3972_length_758_cov_6.604380_g3576_i0	PRJNA743294	3972	758	6.60438	50.0612004	Caldimicrobium sp.	2024963	Bacteria	Bacteria	53.9	2.85e-4	NR	MFN3568491.1	2024963	g3576	i0	34.5	0.33245382585752	84	52	32.1	1	142	384	407	490	MFN3568491.1 YcaO-like family protein [Caldimicrobium sp.]	diamond	252	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Caldimicrobium	Caldimicrobium sp.
30400634	30400634	PRJNA743294_P_NODE_29973_length_304_cov_1.350649_g29517_i0	PRJNA743294	29973	304	1.350649	4.10597296	Desulfobaccales bacterium	3064668	Bacteria	Bacteria	60.8	2.91e-8	NR	MFA4904166.1	3064668	g29517	i0	40	0.888157894736842	90	48	84.9	2	3	260	179	266	MFA4904166.1 hypothetical protein [Desulfobaccales bacterium]	diamond	270	60.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales			Desulfobaccales bacterium
30589681	30589681	PRJNA743294_P_NODE_56873_length_241_cov_2.547619_g56417_i0	PRJNA743294	56873	241	2.547619	6.13976179	Syntrophales bacterium	2928017	Bacteria	Bacteria	65.1	3.65e-10	NR	HSD94778.1	2928017	g56417	i0	55.6	2.27800829875519	63	28	78.4	0	191	3	2	64	HSD94778.1 DnaJ C-terminal domain-containing protein [Syntrophales bacterium]	diamond	549	65.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
30969071	30969071	PRJNA743294_P_NODE_45074_length_255_cov_2.901099_g44618_i0	PRJNA743294	45074	255	2.901099	7.39780245	Desulfobaccales bacterium	3064668	Bacteria	Bacteria	63.5	2.25e-10	NR	MFA4904561.1	3064668	g44618	i0	47.1	0.8	68	33	78.8	2	28	228	76	141	MFA4904561.1 DUF1772 domain-containing protein [Desulfobaccales bacterium]	diamond	204	63.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales			Desulfobaccales bacterium
31253278	31253278	PRJNA743294_P_NODE_27595_length_315_cov_1.842975_g27139_i0	PRJNA743294	27595	315	1.842975	5.80537125	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	44.3	0.024	NR	MBT4365001.1	2049433	g27139	i0	37.9	0.628571428571429	66	34	62.9	2	206	9	207	265	MBT4365001.1 protein kinase [Desulfobacteraceae bacterium]	diamond	198	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
31379925	31379925	PRJNA743294_P_NODE_26496_length_321_cov_1.258065_g26040_i0	PRJNA743294	26496	321	1.258065	4.03838865	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	53.9	4.59e-7	NR	MCK4469881.1	2044940	g26040	i0	63.9	0.336448598130841	36	13	33.6	0	209	102	19	54	MCK4469881.1 hypothetical protein [Desulfobacterales bacterium]	diamond	108	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
31601431	31601431	PRJNA743294_P_NODE_9596_length_509_cov_3.389908_g9140_i0	PRJNA743294	9596	509	3.389908	17.25463172	Desulfocapsa sp.	2066021	Bacteria	Bacteria	132	3.66e-33	NR	RUM47190.1	2066021	g9140	i0	41.9	3.8664047151277	167	97	98.4	0	502	2	104	270	RUM47190.1 MAG: hypothetical protein DSY80_01130, partial [Desulfocapsa sp.]	diamond	1968	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sp.
31664321	31664321	PRJNA743294_P_NODE_16537_length_396_cov_2.061920_g16081_i0	PRJNA743294	16537	396	2.06192	8.1652032	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	45.8	0.00782	NR	NIQ15116.1	2080303	g16081	i0	51.3	0.295454545454545	39	17	29.5	1	395	279	98	134	NIQ15116.1 hypothetical protein [Candidatus Dadabacteria bacterium]	diamond	117	45.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
31696109	31696109	PRJNA743294_P_NODE_59477_length_227_cov_3.805195_g59021_i0	PRJNA743294	59477	227	3.805195	8.63779265	Desulfatiglandaceae bacterium	3080547	Bacteria	Bacteria	55.5	7.05e-7	NR	MFO7739423.1	3080547	g59021	i0	34.2	0.964757709251101	73	48	96.5	0	226	8	51	123	MFO7739423.1 tetratricopeptide repeat protein [Desulfatiglandaceae bacterium]	diamond	219	55.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales	Desulfatiglandaceae		Desulfatiglandaceae bacterium
32202339	32202339	PRJNA743294_P_NODE_27578_length_315_cov_2.028926_g27122_i0	PRJNA743294	27578	315	2.028926	6.3911169	Desulfosalsimonadaceae bacterium	3060584	Bacteria	Bacteria	94	6.57e-22	NR	HMA66672.1	3060584	g27122	i0	49.5	2.6	93	45	87.6	2	40	315	37	128	HMA66672.1 Hsp20/alpha crystallin family protein [Desulfosalsimonadaceae bacterium]	diamond	819	94	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosalsimonadaceae		Desulfosalsimonadaceae bacterium
32550671	32550671	PRJNA743294_P_NODE_41099_length_266_cov_1.046632_g40643_i0	PRJNA743294	41099	266	1.046632	2.78404112	Desulfovibrio sp.	885	Bacteria	Bacteria	75.5	1.48e-13	NR	WP_324349424.1	885	g40643	i0	41	2.67293233082707	83	49	93.6	0	14	262	531	613	WP_324349424.1 DUF5906 domain-containing protein [Desulfovibrio sp.]	diamond	711	75.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
32749361	32749361	PRJNA743294_P_NODE_60980_length_198_cov_4.488000_g60524_i0	PRJNA743294	60980	198	4.488	8.88624	Bacteria	2	Bacteria	Bacteria	110	1.3800000000000002e-27	NR	MDP3284149.1	2044940	g60524	i0	75.4	7.87878787878788	65	16	98.5	0	2	196	194	258	MDP3284149.1 aminotransferase class V-fold PLP-dependent enzyme [Desulfobacterales bacterium]	diamond	1560	111	0.990990990990991	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales 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);;