metadata: contig_metadata: 13 rows where bioproject = "PRJNA270367" and tax

13 rows where bioproject = "PRJNA270367" 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
6747950	6747950	PRJNA270367_P_NODE_8566_length_458_cov_2.308068_g8367_i0	PRJNA270367	8566	458	2.308068	10.57095144	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	189	4.900000000000001e-59	NR	GJM17744.1	2202153	g8367	i0	73.2	1.69650655021834	127	34	83.2	0	4	384	1	127	GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium]	diamond	777	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
10574132	10574132	PRJNA270367_P_NODE_39349_length_169_cov_1.300000_g39144_i0	PRJNA270367	39349	169	1.3	2.197	Desulfocapsa sulfexigens	65555	Bacteria	Bacteria	99	1.62e-22	NR	WP_015403596.1	65555	g39144	i0	76.8	0.994082840236686	56	13	99.4	0	169	2	315	370	WP_015403596.1 decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Desulfocapsa sulfexigens]	diamond	168	99	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sulfexigens
27168664	27168664	PRJNA270367_P_NODE_41762_length_167_cov_0.881356_g41557_i0	PRJNA270367	41762	167	0.881356	1.47186452	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	57	1.22e-7	NR	MCP4347156.1	2044940	g41557	i0	55.1	3.70059880239521	49	20	88	1	20	166	306	352	MCP4347156.1 serpin family protein [Desulfobacterales bacterium]	diamond	618	57	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
28242433	28242433	PRJNA270367_P_NODE_21926_length_252_cov_1.640394_g21721_i0	PRJNA270367	21926	252	1.640394	4.13379288	Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21	1797756	Bacteria	Bacteria	80.1	3.01e-15	NR	OGE24405.1	1797756	g21721	i0	50	0.928571428571429	78	37	90.5	1	252	25	496	573	OGE24405.1 MAG: hypothetical protein A3J42_06930 [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21]	diamond	234	80.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21
28842359	28842359	PRJNA270367_P_NODE_2048_length_976_cov_2.211435_g1886_i0	PRJNA270367	2048	976	2.211435	21.5836056	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	47	0.0413	NR	GJM17643.1	2202153	g1886	i0	32.9	0.242827868852459	79	52	24	1	913	680	135	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	237	47	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29144745	29144745	PRJNA270367_P_NODE_43729_length_165_cov_0.896552_g43524_i0	PRJNA270367	43729	165	0.896552	1.4793108	Pseudomonadati	3379134	Bacteria	Bacteria	80.9	2.98e-16	NR	MEN8140688.1	2202153	g43524	i0	75	7.67272727272727	52	13	94.5	0	2	157	17	68	MEN8140688.1 alkene reductase [Thermodesulfobacteriota bacterium]	diamond	1266	81.6	0.991421568627451	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29537117	29537117	PRJNA270367_P_NODE_41870_length_167_cov_0.881356_g41665_i0	PRJNA270367	41870	167	0.881356	1.47186452	Desulfomonile tiedjei	2358	Bacteria	Bacteria	74.3	8.43e-14	NR	MBI5570063.1	2358	g41665	i0	66.7	5.58682634730539	51	17	91.6	0	14	166	45	95	MBI5570063.1 cysteine desulfurase [Desulfomonile tiedjei]	diamond	933	74.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
29680838	29680838	PRJNA270367_P_NODE_34470_length_186_cov_0.832117_g34265_i0	PRJNA270367	34470	186	0.832117	1.54773762	root	1	Root_unresolved	Root_unresolved	45.1	0.0027	NR	HAK22548.1	885	g34265	i0	61.8	2.35483870967742	34	13	54.8	0	31	132	319	352	HAK22548.1 molecular chaperone DnaJ [Desulfovibrio sp.]	diamond	438	45.4	0.993392070484582	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
30800609	30800609	PRJNA270367_P_NODE_15054_length_330_cov_1.291815_g14849_i0	PRJNA270367	15054	330	1.291815	4.2629895	Desulfobotulus pelophilus	2823377	Bacteria	Bacteria	60.1	3.04e-8	NR	WP_272502270.1	2823377	g14849	i0	32.1	2.97272727272727	109	61	99.1	2	329	3	77	172	WP_272502270.1 peroxiredoxin-like family protein [Desulfobotulus pelophilus]	diamond	981	60.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobotulus	Desulfobotulus pelophilus
32318999	32318999	PRJNA270367_P_NODE_37379_length_175_cov_1.650794_g37174_i0	PRJNA270367	37379	175	1.650794	2.8888895	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	71.6	9.27e-13	NR	MCJ7541722.1	2044940	g37174	i0	61.4	1.95428571428571	57	22	97.7	0	173	3	438	494	MCJ7541722.1 NAD-dependent malic enzyme [Desulfobacterales bacterium]	diamond	342	71.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
32431439	32431439	PRJNA270367_P_NODE_39059_length_170_cov_1.272727_g38854_i0	PRJNA270367	39059	170	1.272727	2.1636359	Pseudomonadati	3379134	Bacteria	Bacteria	51.2	1.42e-5	NR	KPA16408.1	1509431	g38854	i0	42.9	1.97647058823529	56	29	93.5	1	169	11	188	243	KPA16408.1 hypothetical protein MHK_003370, partial [Candidatus Magnetomorum sp. HK-1]	diamond	336	51.6	0.992248062015504	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1
32778218	32778218	PRJNA270367_P_NODE_45540_length_163_cov_0.912281_g45335_i0	PRJNA270367	45540	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	41.6	0.0328	NR	WP_078685054.1	376490	g45335	i0	43.8	5.7239263803681	48	26	86.5	1	145	5	13	60	WP_078685054.1 molecular chaperone DnaJ [Desulfobaculum bizertense]	diamond	933	42	0.990476190476191	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfobaculum	Desulfobaculum bizertense
32841219	32841219	PRJNA270367_P_NODE_44920_length_164_cov_0.860870_g44715_i0	PRJNA270367	44920	164	0.86087	1.4118268	Pseudomonadati	3379134	Bacteria	Bacteria	47.8	1.57e-4	NR	WP_039740584.1	345632	g44715	i0	41.2	2.67073170731707	51	30	93.3	0	153	1	23	73	WP_039740584.1 CAP domain-containing protein [Geobacter pickeringii]	diamond	438	48.1	0.993762993762994	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii

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