metadata: contig_metadata: 30 rows where bioproject = "PRJNA564013" and tax

30 rows where bioproject = "PRJNA564013" 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
1132746	1132746	PRJNA564013_P_NODE_321321_length_213_cov_0.855263_g318469_i0	PRJNA564013	321321	213	0.855263	1.82171019	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	121	2.2599999999999996e-31	NR	MBS3906477.1	2052184	g318469	i0	95.6	2.87323943661972	68	3	95.8	0	206	3	164	231	MBS3906477.1 ABC transporter ATP-binding protein [Syntrophaceae bacterium]	diamond	612	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
1133065	1133065	PRJNA564013_P_NODE_50521_length_556_cov_24.058586_g47765_i0	PRJNA564013	50521	556	24.058586	133.76573816	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	240	1.82e-75	NR	MEF8822920.1	2683721	g47765	i0	91.6	0.901079136690647	167	14	90.1	0	535	35	186	352	MEF8822920.1 UDP-3-O-(3-hydroxymyristoyl)glucosamine N-acyltransferase [Desulfohalobiaceae bacterium]	diamond	501	240	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
2408049	2408049	PRJNA564013_P_NODE_31342_length_680_cov_17.754443_g28755_i0	PRJNA564013	31342	680	17.754443	120.7302124	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	248	8.06e-61	NTclustered	gi\|46451220\|gb\|AE017285.1\|	882	g28755	i0	85.892	2.23676470588235	241	24	35	5	433	672	2106396	2106165	Desulfovibrio vulgaris subsp. vulgaris str. Hildenborough, complete genome	blastn	1521	248	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
3101260	3101260	PRJNA564013_P_NODE_284743_length_235_cov_4.390805_g281891_i0	PRJNA564013	284743	235	4.390805	10.31839175	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	130	6.25e-33	NR	MEF8941519.1	2683721	g281891	i0	96.9	0.829787234042553	65	2	83	0	22	216	194	258	MEF8941519.1 DNA gyrase subunit A [Desulfohalobiaceae bacterium]	diamond	195	130	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
3682841	3682841	PRJNA564013_P_NODE_126003_length_375_cov_25.984076_g123157_i0	PRJNA564013	126003	375	25.984076	97.440285	root	1	Root_unresolved	Root_unresolved	52.8	0.036	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g123157	i0	100	0.149333333333333	28	0	7	0	324	351	4487328	4487355	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
12032380	12032380	PRJNA564013_P_NODE_98470_length_412_cov_24.749288_g95636_i0	PRJNA564013	98470	412	24.749288	101.96706656	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	178	6.26e-40	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g95636	i0	88	1.96359223300971	150	18	36	0	30	179	3200290	3200141	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	809	178	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
13306712	13306712	PRJNA564013_P_NODE_65691_length_496_cov_14.098851_g62888_i0	PRJNA564013	65691	496	14.098851	69.93030096	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	224	9.7e-54	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g62888	i0	92.903	0.637096774193548	155	10	31	1	127	281	1879034	1879187	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	316	224	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
18399191	18399191	PRJNA564013_P_NODE_138615_length_362_cov_9.205980_g135767_i0	PRJNA564013	138615	362	9.20598	33.3256476	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	233	1.14e-56	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g135767	i0	84.615	0.646408839779006	234	36	65	0	114	347	2742237	2742470	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	234	233	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
18403227	18403227	PRJNA564013_P_NODE_32835_length_667_cov_6.684818_g30215_i0	PRJNA564013	32835	667	6.684818	44.58773606	Desulfosoma sp.	2603217	Bacteria	Bacteria	280	7.119999999999999e-90	NR	MEJ5349812.1	2603217	g30215	i0	77.8	1.80809595202399	180	40	81	0	665	126	43	222	MEJ5349812.1 restriction endonuclease subunit S [Desulfosoma sp.]	diamond	1206	280	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulfosoma	Desulfosoma sp.
20258205	20258205	PRJNA564013_P_NODE_167436_length_336_cov_3.305455_g164586_i0	PRJNA564013	167436	336	3.305455	11.1063288	Bacteria	2	Bacteria	Bacteria	99.8	1.1500000000000002e-21	NR	WP_282002043.1	351604	g164586	i0	54.8	10.7410714285714	104	45	92.9	1	19	330	609	710	WP_282002043.1 PAS domain S-box protein [Geotalea uraniireducens]	diamond	3609	100	0.998	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
24774518	24774518	PRJNA564013_P_NODE_177120_length_327_cov_7.560150_g174270_i0	PRJNA564013	177120	327	7.56015	24.7216905	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	348	3.5e-91	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g174270	i0	88.85	0.877675840978593	287	26	86	1	22	302	2322196	2322482	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	287	348	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
27047679	27047679	PRJNA564013_P_NODE_299882_length_225_cov_5.317073_g297030_i0	PRJNA564013	299882	225	5.317073	11.96341425	Desulfobacter postgatei	2293	Bacteria	Bacteria	99.8	1.71e-22	NR	WP_277001283.1	2293	g297030	i0	70.3	2.56	64	19	85.3	0	219	28	238	301	WP_277001283.1 restriction endonuclease subunit S [Desulfobacter postgatei]	diamond	576	99.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter postgatei
27995292	27995292	PRJNA564013_P_NODE_199585_length_306_cov_11.497959_g196734_i0	PRJNA564013	199585	306	11.497959	35.18375454	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	162	1.68e-48	NR	MCF8085982.1	2683721	g196734	i0	88.5	0.941176470588235	96	11	94.1	0	288	1	1	96	MCF8085982.1 GAK system XXXCH domain-containing protein [Desulfohalobiaceae bacterium]	diamond	288	162	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
28247680	28247680	PRJNA564013_P_NODE_353506_length_196_cov_2.940741_g350654_i0	PRJNA564013	353506	196	2.940741	5.76385236	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	115	8.189999999999999e-31	NR	HXG31507.1	2202153	g350654	i0	96.7	0.933673469387755	61	2	93.4	0	12	194	60	120	HXG31507.1 SMC-Scp complex subunit ScpB [Thermodesulfobacteriota bacterium]	diamond	183	115	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28311069	28311069	PRJNA564013_P_NODE_356546_length_194_cov_2.669173_g353694_i0	PRJNA564013	356546	194	2.669173	5.17819562	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	124	2.64e-33	NR	HXG30064.1	2202153	g353694	i0	100	0.958762886597938	62	0	95.9	0	194	9	116	177	HXG30064.1 50S ribosomal protein L2 [Thermodesulfobacteriota bacterium]	diamond	186	124	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28500525	28500525	PRJNA564013_P_NODE_258507_length_254_cov_7.217617_g255655_i0	PRJNA564013	258507	254	7.217617	18.33274718	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	140	4.41e-41	NR	HXG31603.1	2202153	g255655	i0	100	0.732283464566929	62	0	73.2	0	26	211	64	125	HXG31603.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	186	140	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28942763	28942763	PRJNA564013_P_NODE_95208_length_418_cov_17.871148_g92375_i0	PRJNA564013	95208	418	17.871148	74.70139864	Solidesulfovibrio fructosivorans	878	Bacteria	Bacteria	47.8	0.00427	NR	WP_005990253.1	878	g92375	i0	30.5	0.681818181818182	95	62	68.2	1	20	304	669	759	WP_005990253.1 glycosyltransferase family 39 protein [Solidesulfovibrio fructosivorans]	diamond	285	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio fructosivorans
29871913	29871913	PRJNA564013_P_NODE_247271_length_263_cov_19.267327_g244419_i0	PRJNA564013	247271	263	19.267327	50.673070010000004	Pseudomonadati	3379134	Bacteria	Bacteria	48.5	4.13e-4	NR	MDR1686450.1	885	g244419	i0	71.4	3.8212927756654	28	8	31.9	0	110	27	14	41	MDR1686450.1 bifunctional riboflavin kinase/FAD synthetase [Desulfovibrio sp.]	diamond	1005	48.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
29889886	29889886	PRJNA564013_P_NODE_32911_length_666_cov_20.246281_g30289_i0	PRJNA564013	32911	666	20.246281	134.84023146	Desulfuromonas thiophila	57664	Bacteria	Bacteria	94.4	2.17e-21	NR	MDD3802161.1	57664	g30289	i0	73.1	0.301801801801802	67	17	29.7	1	18	215	1	67	MDD3802161.1 hypothetical protein [Desulfuromonas thiophila]	diamond	201	94.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
29984495	29984495	PRJNA564013_P_NODE_212111_length_295_cov_1.470085_g209260_i0	PRJNA564013	212111	295	1.470085	4.33675075	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	52.4	2.77e-5	NR	HXG31333.1	2202153	g209260	i0	96.3	0.661016949152542	27	1	27.5	0	293	213	697	723	HXG31333.1 FTR1 family protein [Thermodesulfobacteriota bacterium]	diamond	195	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30521556	30521556	PRJNA564013_P_NODE_175933_length_328_cov_9.191011_g173083_i0	PRJNA564013	175933	328	9.191011	30.14651608	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	156	1.1399999999999996e-43	NR	MCI0454620.1	2080303	g173083	i0	74.7	1.79268292682927	99	25	90.5	0	18	314	143	241	MCI0454620.1 ABC transporter permease [Candidatus Dadabacteria bacterium]	diamond	588	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium
30679362	30679362	PRJNA564013_P_NODE_19653_length_827_cov_6.374674_g17409_i0	PRJNA564013	19653	827	6.374674	52.71855398	Desulfohalobiaceae bacterium	2683721	Bacteria	Bacteria	160	9.54e-44	NR	MEF8943470.1	2683721	g17409	i0	87.2	0.3409915356711	94	12	34.1	0	536	817	1	94	MEF8943470.1 zinc ABC transporter substrate-binding protein [Desulfohalobiaceae bacterium]	diamond	282	160	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae		Desulfohalobiaceae bacterium
30900871	30900871	PRJNA564013_P_NODE_46874_length_573_cov_33.330078_g44128_i0	PRJNA564013	46874	573	33.330078	190.98134694	Desulfobacteraceae bacterium IS3	1934248	Bacteria	Bacteria	51.2	0.00103	NR	OQX28236.1	1934248	g44128	i0	67.6	0.356020942408377	34	11	17.8	0	548	447	824	857	OQX28236.1 MAG: hypothetical protein BWK80_01290 [Desulfobacteraceae bacterium IS3]	diamond	204	51.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium IS3
31311479	31311479	PRJNA564013_P_NODE_278315_length_240_cov_1.491620_g275463_i0	PRJNA564013	278315	240	1.49162	3.579888	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	98.2	7.77e-22	NR	HEX3035069.1	2202153	g275463	i0	67.2	3.3375	67	22	83.8	0	221	21	310	376	HEX3035069.1 PAS domain S-box protein [Thermodesulfobacteriota bacterium]	diamond	801	98.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31564885	31564885	PRJNA564013_P_NODE_356436_length_194_cov_2.932331_g353584_i0	PRJNA564013	356436	194	2.932331	5.68872214	Geobacter sp. SVR	2495594	Bacteria	Bacteria	98.6	2.45e-23	NR	WP_173199256.1	2495594	g353584	i0	70.5	0.943298969072165	61	18	94.3	0	183	1	65	125	WP_173199256.1 hypothetical protein [Geobacter sp. SVR]	diamond	183	98.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. SVR
31659320	31659320	PRJNA564013_P_NODE_231597_length_277_cov_3.685185_g228745_i0	PRJNA564013	231597	277	3.685185	10.20796245	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	79.7	2.44e-17	NR	HXG31121.1	2202153	g228745	i0	91.7	0.51985559566787	48	4	52	0	112	255	9	56	HXG31121.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	144	79.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31722688	31722688	PRJNA564013_P_NODE_333157_length_207_cov_2.027397_g330305_i0	PRJNA564013	333157	207	2.027397	4.19671179	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	52	1.28e-5	NR	MDD4950992.1	2049043	g330305	i0	55.1	0.710144927536232	49	20	69.6	2	207	64	433	480	MDD4950992.1 hypothetical protein [Desulfovibrionaceae bacterium]	diamond	147	52	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
31912562	31912562	PRJNA564013_P_NODE_266757_length_248_cov_3.139037_g263905_i0	PRJNA564013	266757	248	3.139037	7.78481176	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	151	2.7699999999999994e-42	NR	HXG30528.1	2202153	g263905	i0	97.4	0.919354838709677	76	2	91.9	0	229	2	132	207	HXG30528.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Thermodesulfobacteriota bacterium]	diamond	228	151	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32039174	32039174	PRJNA564013_P_NODE_285678_length_234_cov_16.236994_g282826_i0	PRJNA564013	285678	234	16.236994	37.99456596	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	118	4.769999999999999e-31	NR	HXG31097.1	2202153	g282826	i0	98.4	0.794871794871795	62	1	79.5	0	25	210	92	153	HXG31097.1 CDP-alcohol phosphatidyltransferase family protein [Thermodesulfobacteriota bacterium]	diamond	186	118	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32102430	32102430	PRJNA564013_P_NODE_65418_length_497_cov_13.571101_g62615_i0	PRJNA564013	65418	497	13.571101	67.44837197	Geoanaerobacter pelophilus	60036	Bacteria	Bacteria	112	5.31e-27	NR	WP_214173142.1	60036	g62615	i0	47.1	0.845070422535211	140	67	82.1	5	14	421	42	178	WP_214173142.1 hypothetical protein [Geoanaerobacter pelophilus]	diamond	420	112	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geoanaerobacter	Geoanaerobacter pelophilus

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