metadata: contig_metadata: 11 rows where bioproject = "PRJNA876641", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA876641", 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
28823460	28823460	PRJNA876641_P_NODE_5648_length_337_cov_1.166667_g5574_i0	PRJNA876641	5648	337	1.166667	3.93166779	Geomonas ferrireducens	2570227	Bacteria	Bacteria	104	5.359999999999999e-24	NR	WP_246044532.1	2570227	g5574	i0	44.1	10.7181008902077	111	62	98.8	0	335	3	191	301	WP_246044532.1 sensor histidine kinase [Geomonas ferrireducens]	diamond	3612	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas ferrireducens
28981842	28981842	PRJNA876641_P_NODE_8588_length_290_cov_1.368664_g8514_i0	PRJNA876641	8588	290	1.368664	3.9691256	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	117	4.77e-29	NR	RMF12857.1	2080303	g8514	i0	58.3	1.98620689655172	96	40	99.3	0	289	2	81	176	RMF12857.1 MAG: methyltransferase domain-containing protein [Candidatus Dadabacteria bacterium]	diamond	576	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
29265590	29265590	PRJNA876641_P_NODE_24169_length_226_cov_2.013072_g24095_i0	PRJNA876641	24169	226	2.013072	4.54954272	Desulfonema limicola	45656	Bacteria	Bacteria	96.3	1.14e-21	NR	WP_207689579.1	45656	g24095	i0	80.4	0.743362831858407	56	11	74.3	0	170	3	1	56	WP_207689579.1 GMP reductase [Desulfonema limicola]	diamond	168	96.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema limicola
29518273	29518273	PRJNA876641_P_NODE_16110_length_251_cov_0.865169_g16036_i0	PRJNA876641	16110	251	0.865169	2.17157419	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	141	7.42e-41	NR	GJM17675.1	2202153	g16036	i0	80.7	4.9601593625498	83	16	99.2	0	2	250	8	90	GJM17675.1 MAG: hypothetical protein DHS20C13_30020 [Thermodesulfobacteriota bacterium]	diamond	1245	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29644240	29644240	PRJNA876641_P_NODE_16190_length_251_cov_0.865169_g16116_i0	PRJNA876641	16190	251	0.865169	2.17157419	Desulforhabdus sp. TSK	2925014	Bacteria	Bacteria	70.1	6.22e-13	NR	WP_244085865.1	2925014	g16116	i0	77.5	1.91235059760956	40	9	47.8	0	250	131	108	147	WP_244085865.1 hypothetical protein [Desulforhabdus sp. TSK]	diamond	480	70.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulforhabdus	Desulforhabdus sp. TSK
29770807	29770807	PRJNA876641_P_NODE_22791_length_242_cov_0.911243_g22717_i0	PRJNA876641	22791	242	0.911243	2.20520806	Desulfocurvibacter africanus	873	Bacteria	Bacteria	92	5.3700000000000006e-21	NR	WP_027368314.1	873	g22717	i0	62.2	3.68181818181818	74	27	90.5	1	224	6	4	77	WP_027368314.1 NAD(P)H:quinone oxidoreductase [Desulfocurvibacter africanus]	diamond	891	92	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
30181536	30181536	PRJNA876641_P_NODE_11232_length_275_cov_1.519802_g11158_i0	PRJNA876641	11232	275	1.519802	4.1794555	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	82.8	4.64e-16	NR	KAF0221782.1	2282154	g11158	i0	45.6	3.89454545454545	90	49	98.2	0	272	3	1017	1106	KAF0221782.1 MAG: hypothetical protein FD174_113 [Geobacteraceae bacterium]	diamond	1071	82.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
30497660	30497660	PRJNA876641_P_NODE_20293_length_245_cov_0.895349_g20219_i0	PRJNA876641	20293	245	0.895349	2.19360505	Desulfonema magnum	45655	Bacteria	Bacteria	84.7	6.38e-17	NR	WP_207683226.1	45655	g20219	i0	51.2	1.02857142857143	84	34	94.3	1	231	1	115	198	WP_207683226.1 S8 family serine peptidase [Desulfonema magnum]	diamond	252	84.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema magnum
31066554	31066554	PRJNA876641_P_NODE_16115_length_251_cov_0.865169_g16041_i0	PRJNA876641	16115	251	0.865169	2.17157419	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	68.9	2.42e-11	NR	MEW6300529.1	2202153	g16041	i0	44.6	0.99203187250996006	83	45	99.2	1	250	2	444	525	MEW6300529.1 multicopper oxidase family protein [Thermodesulfobacteriota bacterium]	diamond	249	68.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32434783	32434783	PRJNA876641_P_NODE_8459_length_291_cov_2.041284_g8385_i0	PRJNA876641	8459	291	2.041284	5.94013644	root	1	Root_unresolved	Root_unresolved	99	3.52e-22	NR	WP_014809794.1	2358	g8385	i0	56.8	6.61855670103093	81	29	83.5	2	6	248	293	367	WP_014809794.1 alkene reductase [Desulfomonile tiedjei]	diamond	1926	99.8	0.991983967935872	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
32686885	32686885	PRJNA876641_P_NODE_21580_length_243_cov_0.905882_g21506_i0	PRJNA876641	21580	243	0.905882	2.20129326	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	1.23e-4	NR	WP_320353948.1	1940337	g21506	i0	51.3	1.09876543209877	39	19	48.1	0	225	109	168	206	WP_320353948.1 DUF599 domain-containing protein [Desulfobotulus sp.]	diamond	267	49.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobotulus	Desulfobotulus 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);;