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

13 rows where bioproject = "PRJNA756891", 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
9660532	9660532	PRJNA756891_P_NODE_9448_length_283_cov_1.776190_g9379_i0	PRJNA756891	9448	283	1.77619	5.0266177	root	1	Root_unresolved	Root_unresolved	142	2.34e-39	NR	WP_319409060.1	218289	g9379	i0	68.5	20.4381625441696	92	27	97.5	1	6	281	113	202	WP_319409060.1 N-carbamoylputrescine amidase [uncultured Desulfosarcina sp.]	diamond	5784	143	0.993006993006993	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	uncultured Desulfosarcina sp.
26989424	26989424	PRJNA756891_P_NODE_5982_length_348_cov_2.054545_g5913_i0	PRJNA756891	5982	348	2.054545	7.1498166	Geomonas sp.	2651584	Bacteria	Bacteria	92	2.74e-20	NR	HEY5513348.1	2651584	g5913	i0	42.6	1.95689655172414	115	65	99.1	1	4	348	29	142	HEY5513348.1 CAP domain-containing protein [Geomonas sp.]	diamond	681	92	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas sp.
27685078	27685078	PRJNA756891_P_NODE_864_length_862_cov_1.646388_g809_i0	PRJNA756891	864	862	1.646388	14.19186456	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	73.2	6.26e-12	NR	NIP30510.1	2080303	g809	i0	38.8	0.3584686774942	103	62	35.8	1	526	834	42	143	NIP30510.1 Hsp20 family protein [Candidatus Dadabacteria bacterium]	diamond	309	73.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
27905508	27905508	PRJNA756891_P_NODE_4105_length_414_cov_2.706745_g4036_i0	PRJNA756891	4105	414	2.706745	11.2059243	Geobacter sp.	46610	Bacteria	Bacteria	76.3	4.61e-14	NR	HCE66851.1	46610	g4036	i0	47.4	1.11594202898551	78	41	56.5	0	407	174	120	197	HCE66851.1 CAP domain-containing protein [Geobacter sp.]	diamond	462	76.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
28411067	28411067	PRJNA756891_P_NODE_10666_length_268_cov_1.569231_g10597_i0	PRJNA756891	10666	268	1.569231	4.20553908	Desulfococcaceae bacterium HSG9	3055598	Bacteria	Bacteria	44.7	0.00923	NR	MDM8540287.1	3055598	g10597	i0	33.3	0.973880597014925	87	57	97.4	1	5	265	20	105	MDM8540287.1 hypothetical protein [Desulfococcaceae bacterium HSG9]	diamond	261	44.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae		Desulfococcaceae bacterium HSG9
28547332	28547332	PRJNA756891_P_NODE_6327_length_339_cov_3.473684_g6258_i0	PRJNA756891	6327	339	3.473684	11.77578876	root	1	Root_unresolved	Root_unresolved	100	7.65e-25	NR	KAF0220805.1	2282154	g6258	i0	49.5	4.21238938053097	95	47	84.1	1	53	337	2	95	KAF0220805.1 MAG: chaperonin [Geobacteraceae bacterium]	diamond	1428	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
29452592	29452592	PRJNA756891_P_NODE_15710_length_243_cov_0.905882_g15641_i0	PRJNA756891	15710	243	0.905882	2.20129326	Candidatus Electronema halotolerans	3036122	Bacteria	Bacteria	44.3	0.0104	NR	CAK8721456.1	3036122	g15641	i0	54.3	0.567901234567901	46	20	56.8	1	177	40	211	255	CAK8721456.1 Histone deacetylase domain-containing protein [Candidatus Electronema halotolerans]	diamond	138	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electronema	Candidatus Electronema halotolerans
30526801	30526801	PRJNA756891_P_NODE_6793_length_329_cov_1.203125_g6724_i0	PRJNA756891	6793	329	1.203125	3.95828125	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	53.9	1.16e-5	NR	HHD57392.1	2053307	g6724	i0	33.3	0.90273556231003	99	54	89.4	3	301	8	105	192	HHD57392.1 FAD/NAD(P)-binding oxidoreductase [Desulfobulbaceae bacterium]	diamond	297	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
30684727	30684727	PRJNA756891_P_NODE_7153_length_322_cov_1.445783_g7084_i0	PRJNA756891	7153	322	1.445783	4.65542126	Desulforegula conservatrix	153026	Bacteria	Bacteria	116	1.58e-28	NR	WP_027359097.1	153026	g7084	i0	46.7	0.996894409937888	107	55	97.8	1	315	1	159	265	WP_027359097.1 molecular chaperone DnaJ [Desulforegula conservatrix]	diamond	321	116	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulforegulaceae	Desulforegula	Desulforegula conservatrix
32076078	32076078	PRJNA756891_P_NODE_4018_length_419_cov_1.583815_g3949_i0	PRJNA756891	4018	419	1.583815	6.63618485	Desulfuromonadales bacterium	2099678	Bacteria	Bacteria	123	2.56e-33	NR	NOR49650.1	2099678	g3949	i0	53.9	1.63245823389021	115	47	78	1	15	341	4	118	NOR49650.1 DUF423 domain-containing protein [Desulfuromonadales bacterium]	diamond	684	123	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium
32297937	32297937	PRJNA756891_P_NODE_3259_length_463_cov_1.366667_g3191_i0	PRJNA756891	3259	463	1.366667	6.32766821	Desulfonema magnum	45655	Bacteria	Bacteria	167	7.8e-45	NR	WP_207683226.1	45655	g3191	i0	51.3	4.95680345572354	154	74	99.8	1	462	1	145	297	WP_207683226.1 S8 family serine peptidase [Desulfonema magnum]	diamond	2295	167	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema magnum
32297942	32297942	PRJNA756891_P_NODE_7539_length_315_cov_1.272727_g7470_i0	PRJNA756891	7539	315	1.272727	4.00909005	Desulfovibrio oxyclinae	63560	Bacteria	Bacteria	71.6	6.22e-12	NR	WP_018125246.1	63560	g7470	i0	45.5	4.72380952380952	88	44	80	1	259	8	495	582	WP_018125246.1 transporter substrate-binding domain-containing protein [Desulfovibrio oxyclinae]	diamond	1488	71.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio oxyclinae
32843837	32843837	PRJNA756891_P_NODE_6540_length_334_cov_2.578544_g6471_i0	PRJNA756891	6540	334	2.578544	8.61233696	Bacteria	2	Bacteria	Bacteria	116	3.23e-28	NR	WP_287703198.1	885	g6471	i0	54.1	48.1706586826347	109	41	97.9	1	6	332	129	228	WP_287703198.1 iron-containing alcohol dehydrogenase [Desulfovibrio sp.]	diamond	16089	116	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.

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