metadata: contig_metadata: 23 rows where bioproject = "PRJNA533623" and tax

23 rows where bioproject = "PRJNA533623" 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
3056728	3056728	PRJNA533623_P_NODE_10463_length_725_cov_11.579819_g8892_i0	PRJNA533623	10463	725	11.579819	83.95368775	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	499	2.16e-136	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g8892	i0	87.822	13.0634482758621	427	50	59	2	37	462	1580290	1579865	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	9471	499	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
3056765	3056765	PRJNA533623_P_NODE_12223_length_673_cov_15.846405_g10587_i0	PRJNA533623	12223	673	15.846405	106.64630565	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	165	8.26e-36	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g10587	i0	89.13	1.82020802377415	138	7	20	4	40	171	2033805	2033670	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	1225	165	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
4333257	4333257	PRJNA533623_P_NODE_32184_length_396_cov_15.301493_g30413_i0	PRJNA533623	32184	396	15.301493	60.59391228	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	122	2.85e-23	NTclustered	gi\|2108083302\|gb\|CP070746.1\|	2044940	g30413	i0	96	51.8106060606061	75	3	19	0	73	147	3291005	3290931	MAG: Desulfobacterales bacterium isolate bin36 chromosome	blastn	20517	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
4334243	4334243	PRJNA533623_P_NODE_78444_length_196_cov_5.348148_g76663_i0	PRJNA533623	78444	196	5.348148	10.48237008	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	121	4.579999999999999e-23	NTclustered	gi\|2621784475\|emb\|OY780933.1\|	2795000	g76663	i0	86.364	4.22959183673469	110	15	56	0	86	195	1291030	1290921	MAG: Maridesulfovibrio sp. isolate 689ab4ac-13ae-4e01-b39b-c4f5232e5781 genome assembly, chromosome: 1	blastn	829	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.
4946000	4946000	PRJNA533623_P_NODE_32704_length_392_cov_19.619335_g30933_i0	PRJNA533623	32704	392	19.619335	76.9077932	Pseudomonadati	3379134	Bacteria	Bacteria	422	2.48e-113	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g30933	i0	87.466	49.1020408163265	367	45	93	1	19	384	845899	846265	Geobacter sulfurreducens strain AM-1 genome	blastn	19248	422	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
15146038	15146038	PRJNA533623_P_NODE_4672_length_1044_cov_13.003052_g3513_i0	PRJNA533623	4672	1044	13.003052	135.75186288	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	303	3.73e-94	NR	WP_245560853.1	81425	g3513	i0	46.6	11.3045977011494	328	134	94.3	2	57	1040	58	344	WP_245560853.1 potassium transporter Kup [Desulfovibrio aminophilus]	diamond	11802	303	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
26634529	26634529	PRJNA533623_P_NODE_58121_length_261_cov_2.260000_g56341_i0	PRJNA533623	58121	261	2.26	5.8986	Syntrophorhabdus sp.	2699756	Bacteria	Bacteria	70.1	1.08e-11	NR	HQO64325.1	2699756	g56341	i0	59.6	0.597701149425287	52	21	59.8	0	157	2	1	52	HQO64325.1 hypothetical protein [Syntrophorhabdus sp.]	diamond	156	70.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae	Syntrophorhabdus	Syntrophorhabdus sp.
26856534	26856534	PRJNA533623_P_NODE_53061_length_281_cov_2.904545_g51282_i0	PRJNA533623	53061	281	2.904545	8.16177145	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	127	9.85e-33	NR	MEW6593826.1	2202153	g51282	i0	64.5	2.97864768683274	93	32	98.2	1	1	276	275	367	MEW6593826.1 glycosyltransferase [Thermodesulfobacteriota bacterium]	diamond	837	127	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
26856542	26856542	PRJNA533623_P_NODE_72821_length_211_cov_3.386667_g71040_i0	PRJNA533623	72821	211	3.386667	7.14586737	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	62.8	2.09e-9	NR	MDD2853091.1	2099677	g71040	i0	43.3	3.63981042654028	67	37	93.8	1	3	200	1170	1236	MDD2853091.1 Ig-like domain-containing protein [Desulfuromonadaceae bacterium]	diamond	768	62.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
27393985	27393985	PRJNA533623_P_NODE_12263_length_672_cov_16.680851_g10626_i0	PRJNA533623	12263	672	16.680851	112.09531872	Desulfovibrio sp.	885	Bacteria	Bacteria	49.3	0.00596	NR	MBR3664478.1	885	g10626	i0	31.9	0.419642857142857	94	57	38.8	1	177	437	154	247	MBR3664478.1 bifunctional folylpolyglutamate synthase/ dihydrofolate synthase [Desulfovibrio sp.]	diamond	282	49.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
27710055	27710055	PRJNA533623_P_NODE_76304_length_204_cov_1.363636_g74523_i0	PRJNA533623	76304	204	1.363636	2.78181744	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	115	5.230000000000001e-29	NR	KAB2822970.1	2080303	g74523	i0	83.9	0.911764705882353	62	10	91.2	0	204	19	31	92	KAB2822970.1 MAG: hypothetical protein F9K51_07775, partial [Candidatus Dadabacteria bacterium]	diamond	186	115	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
28151806	28151806	PRJNA533623_P_NODE_51725_length_286_cov_20.728889_g49946_i0	PRJNA533623	51725	286	20.728889	59.28462254	Geotalea toluenoxydans	421624	Bacteria	Bacteria	67.8	5.76e-12	NR	WP_243688755.1	421624	g49946	i0	51.6	0.65034965034965	62	28	65	1	10	195	74	133	WP_243688755.1 CAP domain-containing protein [Geotalea toluenoxydans]	diamond	186	67.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea toluenoxydans
28720026	28720026	PRJNA533623_P_NODE_14107_length_627_cov_13.220848_g12422_i0	PRJNA533623	14107	627	13.220848	82.89471696	Syntrophobacteraceae bacterium	2052185	Bacteria	Bacteria	47.4	0.0266	NR	HBZ55011.1	2052185	g12422	i0	29.8	0.674641148325359	141	84	62.2	4	4	393	110	246	HBZ55011.1 RND transporter [Syntrophobacteraceae bacterium]	diamond	423	47.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae		Syntrophobacteraceae bacterium
28972646	28972646	PRJNA533623_P_NODE_34728_length_377_cov_11.968354_g32956_i0	PRJNA533623	34728	377	11.968354	45.12069458	Desulfobacterales bacterium HSG2	3055596	Bacteria	Bacteria	57.8	9.53e-7	NR	MDM8549169.1	3055596	g32956	i0	37.8	2.06896551724138	90	50	66.8	2	356	105	1174	1263	MDM8549169.1 response regulator [Desulfobacterales bacterium HSG2]	diamond	780	57.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium HSG2
29288181	29288181	PRJNA533623_P_NODE_69569_length_221_cov_3.062500_g67788_i0	PRJNA533623	69569	221	3.0625	6.768125	Trichloromonas sp.	3069249	Bacteria	Bacteria	47.8	4.87e-4	NR	MDY0269059.1	3069249	g67788	i0	75	0.760180995475113	56	12	76	1	35	202	1144	1197	MDY0269059.1 hypothetical protein [Trichloromonas sp.]	diamond	168	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Trichloromonadaceae	Trichloromonas	Trichloromonas sp.
29681767	29681767	PRJNA533623_P_NODE_30790_length_407_cov_30.858382_g29019_i0	PRJNA533623	30790	407	30.858382	125.59361474	Pseudomonadati	3379134	Bacteria	Bacteria	57.8	3.81e-8	NR	MDD3802449.1	57664	g29019	i0	65.9	0.604422604422604	41	14	30.2	0	127	5	8	48	MDD3802449.1 hypothetical protein [Desulfuromonas thiophila]	diamond	246	57.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
30994107	30994107	PRJNA533623_P_NODE_42574_length_330_cov_8.490706_g40800_i0	PRJNA533623	42574	330	8.490706	28.0193298	Desulfuromonadaceae bacterium	2099677	Bacteria	Bacteria	151	6.819999999999999e-40	NR	MDD2365118.1	2099677	g40800	i0	76.3	1.69090909090909	93	22	84.5	0	306	28	1107	1199	MDD2365118.1 carboxypeptidase regulatory-like domain-containing protein [Desulfuromonadaceae bacterium]	diamond	558	151	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium
31103638	31103638	PRJNA533623_P_NODE_59115_length_257_cov_3.107143_g57335_i0	PRJNA533623	59115	257	3.107143	7.98535751	Pseudomonadati	3379134	Bacteria	Bacteria	104	1.39e-24	NR	WP_260747545.1	2847045	g57335	i0	62.5	1.72762645914397	72	27	84	0	18	233	223	294	WP_260747545.1 hypothetical protein [Geoalkalibacter halelectricus]	diamond	444	105	0.990476190476191	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter halelectricus
31214791	31214791	PRJNA533623_P_NODE_8615_length_796_cov_10.051701_g7139_i0	PRJNA533623	8615	796	10.051701	80.01153996	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	176	3.8999999999999986e-49	NR	MCY4046612.1	2080303	g7139	i0	58.6	2.02010050251256	133	52	49.7	2	499	104	219	349	MCY4046612.1 radical SAM protein [Candidatus Dadabacteria bacterium]	diamond	1608	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
31752824	31752824	PRJNA533623_P_NODE_45737_length_314_cov_7.747036_g43961_i0	PRJNA533623	45737	314	7.747036	24.32569304	Desulfuromonas thiophila	57664	Bacteria	Bacteria	92	4.43e-22	NR	MDD3802161.1	57664	g43961	i0	74.2	0.592356687898089	62	16	59.2	0	30	215	6	67	MDD3802161.1 hypothetical protein [Desulfuromonas thiophila]	diamond	186	92	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
32242780	32242780	PRJNA533623_P_NODE_50438_length_292_cov_4.103896_g48659_i0	PRJNA533623	50438	292	4.103896	11.98337632	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	101	1.21e-25	NR	HFC97381.1	999894	g48659	i0	57.6	4.23287671232877	85	35	86.3	1	292	41	4	88	HFC97381.1 type II toxin-antitoxin system mRNA interferase toxin, RelE/StbE family [Thermosulfurimonas dismutans]	diamond	1236	101	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermosulfurimonas	Thermosulfurimonas dismutans
32653067	32653067	PRJNA533623_P_NODE_14140_length_626_cov_22.240708_g12455_i0	PRJNA533623	14140	626	22.240708	139.22683208	Pseudomonadati	3379134	Bacteria	Bacteria	93.6	8.43e-19	NR	WP_013906783.1	171695	g12455	i0	63.6	9.80511182108626	77	27	36.9	1	525	295	3	78	WP_013906783.1 DnaJ C-terminal domain-containing protein [Thermodesulfatator indicus]	diamond	6138	94.4	0.991525423728813	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator indicus
32795647	32795647	PRJNA533623_P_NODE_32080_length_397_cov_9.949405_g30309_i0	PRJNA533623	32080	397	9.949405	39.49913785	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	43.9	0.0424	NR	MCP4340736.1	2053307	g30309	i0	48.8	0.324937027707809	43	21	32.5	1	356	228	107	148	MCP4340736.1 ankyrin repeat domain-containing protein [Desulfobulbaceae bacterium]	diamond	129	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae 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);;