metadata: contig_metadata: 13 rows where bioproject = "PRJNA431371", tax_kingdom = "Pseudomonadati" and tax

13 rows where bioproject = "PRJNA431371", 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
427982	427982	PRJNA431371_P_NODE_13281_length_347_cov_2.218978_g13208_i0	PRJNA431371	13281	347	2.218978	7.69985366	Desulfobacula sp.	2593537	Bacteria	Bacteria	212	1.33e-66	NR	MBT4876013.1	2593537	g13208	i0	80	1.98847262247839	115	23	99.4	0	3	347	115	229	MBT4876013.1 N-carbamoylputrescine amidase [Desulfobacula sp.]	diamond	690	212	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacula	Desulfobacula sp.
7466046	7466046	PRJNA431371_P_NODE_22546_length_267_cov_1.484536_g22473_i0	PRJNA431371	22546	267	1.484536	3.96371112	Lawsonia	41707	Bacteria	Bacteria	394	3.52e-105	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g22473	i0	93.258	245.756554307116	267	18	100	0	1	267	655405	655139	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	65617	394	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
22764952	22764952	PRJNA431371_P_NODE_2818_length_660_cov_1.385009_g2745_i0	PRJNA431371	2818	660	1.385009	9.1410594	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	192	1.97e-56	NR	MDJ0875097.1	2044940	g2745	i0	47.5	20.2136363636364	221	110	99.5	3	1	657	102	318	MDJ0875097.1 NAD(P)-dependent alcohol dehydrogenase [Desulfobacterales bacterium]	diamond	13341	192	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
24654871	24654871	PRJNA431371_P_NODE_8060_length_435_cov_3.104972_g7987_i0	PRJNA431371	8060	435	3.104972	13.5066282	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	122	3.1599999999999996e-23	NTclustered	gi\|1863426051\|gb\|CP045506.1\|	2773299	g7987	i0	88.889	1.15632183908046	99	11	26	0	337	435	2505395	2505297	Desulfolutivibrio sulfoxidireducens strain DSM 106783 chromosome, complete genome	blastn	503	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
27644651	27644651	PRJNA431371_P_NODE_11004_length_378_cov_1.009836_g10931_i0	PRJNA431371	11004	378	1.009836	3.81718008	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	74.3	4.22e-14	NR	MDD2899562.1	2099677	g10931	i0	40.9	0.698412698412698	88	52	69.8	0	368	105	35	122	MDD2899562.1 hypothetical protein [Desulfuromonadaceae bacterium]	diamond	264	74.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
27865307	27865307	PRJNA431371_P_NODE_4565_length_553_cov_2.031250_g4492_i0	PRJNA431371	4565	553	2.03125	11.2328125	Syntrophales bacterium	2928017	Bacteria	Bacteria	153	2.26e-42	NR	HOJ51767.1	2928017	g4492	i0	40.1	2.08318264014467	192	100	99.3	6	1	549	53	238	HOJ51767.1 alpha/beta hydrolase [Syntrophales bacterium]	diamond	1152	153	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
27976609	27976609	PRJNA431371_P_NODE_26005_length_250_cov_0.870056_g25932_i0	PRJNA431371	26005	250	0.870056	2.17514	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	100	3.569999999999999e-23	NR	WP_069858001.1	1592317	g25932	i0	62	8.532	79	30	94.8	0	248	12	37	115	WP_069858001.1 NAD-dependent epimerase [Desulfoplanes formicivorans]	diamond	2133	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfoplanaceae	Desulfoplanes	Desulfoplanes formicivorans
28197531	28197531	PRJNA431371_P_NODE_16346_length_317_cov_3.471311_g16273_i0	PRJNA431371	16346	317	3.471311	11.00405587	Desulfomonile	2357	Bacteria	Bacteria	73.9	3.39e-13	NR	MBI4964289.1	2358	g16273	i0	50	2.10094637223975	74	36	70	1	316	95	148	220	MBI4964289.1 TVP38/TMEM64 family protein [Desulfomonile tiedjei]	diamond	666	73.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
28275804	28275804	PRJNA431371_P_NODE_7366_length_452_cov_1.625330_g7293_i0	PRJNA431371	7366	452	1.62533	7.3464916	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	95.9	1.67e-21	NR	MFO7558277.1	2044940	g7293	i0	46.4	0.643805309734513	97	52	64.4	0	291	1	14	110	MFO7558277.1 peroxiredoxin-like family protein [Desulfobacterales bacterium]	diamond	291	95.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
28465480	28465480	PRJNA431371_P_NODE_1546_length_814_cov_1.662618_g1480_i0	PRJNA431371	1546	814	1.662618	13.53371052	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	225	1.11e-68	NR	MDE0158901.1	2080303	g1480	i0	42.1	1.92014742014742	261	142	95.5	4	779	3	10	263	MDE0158901.1 Rieske 2Fe-2S domain-containing protein [Candidatus Dadabacteria bacterium]	diamond	1563	225	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
28654862	28654862	PRJNA431371_P_NODE_34027_length_243_cov_0.905882_g33954_i0	PRJNA431371	34027	243	0.905882	2.20129326	Syntrophales bacterium	2928017	Bacteria	Bacteria	43.9	0.0136	NR	MDD5170111.1	2928017	g33954	i0	39	0.728395061728395	59	29	64.2	1	236	81	150	208	MDD5170111.1 hypothetical protein [Syntrophales bacterium]	diamond	177	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
29871142	29871142	PRJNA431371_P_NODE_5071_length_530_cov_1.336980_g4998_i0	PRJNA431371	5071	530	1.33698	7.085994	Pseudomonadati	3379134	Bacteria	Bacteria	138	9.01e-37	NR	MBF0103308.1	2044940	g4998	i0	46.5	4.09245283018868	142	76	80.4	0	6	431	117	258	MBF0103308.1 hypothetical protein [Desulfobacterales bacterium]	diamond	2169	138	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32762383	32762383	PRJNA431371_P_NODE_10960_length_378_cov_1.954098_g10887_i0	PRJNA431371	10960	378	1.954098	7.38649044	Desulforhopalus sp. IMCC35	2099376	Bacteria	Bacteria	118	9.86e-31	NR	WP_136874545.1	2569543	g10887	i0	52.1	0.928571428571429	117	50	92.9	2	351	1	13	123	WP_136874545.1 HPP family protein [Desulforhopalus sp. IMCC35007]	diamond	351	118	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulforhopalus	Desulforhopalus sp. IMCC35007

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