metadata: contig_metadata: 16 rows where bioproject = "PRJNA577580" and tax

16 rows where bioproject = "PRJNA577580" 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
26667887	26667887	PRJNA577580_P_NODE_6441_length_354_cov_1.629893_g6363_i0	PRJNA577580	6441	354	1.629893	5.76982122	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	122	5.32e-30	NR	MFC1834884.1	2202153	g6363	i0	47.4	0.966101694915254	114	58	96.6	1	3	344	10	121	MFC1834884.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	342	122	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
26731088	26731088	PRJNA577580_P_NODE_11381_length_273_cov_1.720000_g11303_i0	PRJNA577580	11381	273	1.72	4.6956	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	74.3	2.39e-13	NR	MCP4719137.1	2049433	g11303	i0	45.8	0.912087912087912	83	44	91.2	1	6	254	141	222	MCP4719137.1 DHH family phosphoesterase [Desulfobacteraceae bacterium]	diamond	249	74.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
26871989	26871989	PRJNA577580_P_NODE_1041_length_869_cov_2.415829_g975_i0	PRJNA577580	1041	869	2.415829	20.99355401	root	1	Root_unresolved	Root_unresolved	378	1.2799999999999998e-125	NR	WP_039646386.1	28231	g975	i0	61.6	11.9378596087457	289	108	99.8	1	867	1	59	344	WP_039646386.1 MULTISPECIES: acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Geobacter]	diamond	10374	380	0.994736842105263	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter
27048077	27048077	PRJNA577580_P_NODE_102_length_1892_cov_5.211105_g84_i0	PRJNA577580	102	1892	5.211105	98.5941066	Desulfobacula sp.	2593537	Bacteria	Bacteria	80.1	6.54e-12	NR	WP_413907423.1	2593537	g84	i0	33.9	0.756342494714588	171	105	26.8	6	1532	1026	202	366	WP_413907423.1 NF038122 family metalloprotease [Desulfobacula sp.]	diamond	1431	80.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacula	Desulfobacula sp.
27756781	27756781	PRJNA577580_P_NODE_564_length_1116_cov_4.539789_g521_i0	PRJNA577580	564	1116	4.539789	50.66404524	root	1	Root_unresolved	Root_unresolved	335	4.58e-103	NR	WP_207683226.1	45655	g521	i0	49.6	3.93817204301075	371	178	97.3	3	1116	31	195	565	WP_207683226.1 S8 family serine peptidase [Desulfonema magnum]	diamond	4395	335	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema magnum
28167080	28167080	PRJNA577580_P_NODE_14165_length_250_cov_2.067797_g14087_i0	PRJNA577580	14165	250	2.067797	5.1694925	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	110	1.22e-26	NR	MDJ0622338.1	2979184	g14087	i0	63	14.496	81	30	97.2	0	245	3	200	280	MDJ0622338.1 alkene reductase [Desulfocapsaceae bacterium]	diamond	3624	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae		Desulfocapsaceae bacterium
28342954	28342954	PRJNA577580_P_NODE_2646_length_555_cov_7.080913_g2568_i0	PRJNA577580	2646	555	7.080913	39.29906715	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	102	2.2700000000000004e-21	NR	MEA2014215.1	2202153	g2568	i0	41.6	0.740540540540541	137	67	74.1	3	124	534	529	652	MEA2014215.1 DUF1566 domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	411	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
29114311	29114311	PRJNA577580_P_NODE_11688_length_270_cov_1.583756_g11610_i0	PRJNA577580	11688	270	1.583756	4.2761412	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	1.22e-6	NR	WP_015723117.1	894	g11610	i0	36.5	5.65555555555556	85	47	91.1	2	20	265	430	510	WP_015723117.1 PKD domain-containing protein [Desulfobulbus propionicus]	diamond	1527	55.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
29303623	29303623	PRJNA577580_P_NODE_9489_length_296_cov_2.591928_g9411_i0	PRJNA577580	9489	296	2.591928	7.67210688	Geobacteraceae	213422	Bacteria	Bacteria	43.9	0.0224	NR	WP_185244963.1	60035	g9411	i0	43.6	1.18581081081081	39	22	39.5	0	2	118	165	203	WP_185244963.1 DUF2459 domain-containing protein [Citrifermentans bremense]	diamond	351	43.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
29447813	29447813	PRJNA577580_P_NODE_1470_length_748_cov_2.727407_g1397_i0	PRJNA577580	1470	748	2.727407	20.40100436	Desulfoluna sp.	2045199	Bacteria	Bacteria	192	4.98e-52	NR	WP_300668609.1	2045199	g1397	i0	50.5	2.56283422459893	202	90	78.6	5	135	722	144	341	WP_300668609.1 Ig-like domain-containing protein [Desulfoluna sp.]	diamond	1917	192	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfolunaceae	Desulfoluna	Desulfoluna sp.
30061370	30061370	PRJNA577580_P_NODE_2451_length_578_cov_3.865347_g2373_i0	PRJNA577580	2451	578	3.865347	22.34170566	Pseudomonadati	3379134	Bacteria	Bacteria	117	1.14e-29	NR	WP_321370467.1	219183	g2373	i0	50	6.06228373702422	112	53	58.1	2	243	578	38	146	WP_321370467.1 Hsp20/alpha crystallin family protein [uncultured Desulfuromusa sp.]	diamond	3504	118	0.991525423728814	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae	Desulfuromusa	uncultured Desulfuromusa sp.
30111234	30111234	PRJNA577580_P_NODE_5472_length_382_cov_2.469256_g5394_i0	PRJNA577580	5472	382	2.469256	9.43255792	Desulfobacteraceae bacterium IS3	1934248	Bacteria	Bacteria	85.5	1.02e-16	NR	OQX11095.1	1934248	g5394	i0	37.8	1.99476439790576	127	62	88	5	338	3	33	157	OQX11095.1 MAG: hypothetical protein BWK80_45090, partial [Desulfobacteraceae bacterium IS3]	diamond	762	85.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium IS3
30648128	30648128	PRJNA577580_P_NODE_2533_length_568_cov_8.408081_g2455_i0	PRJNA577580	2533	568	8.408081	47.75790008	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	97.4	1.01e-19	NR	MEA2014215.1	2202153	g2455	i0	41.9	1.84330985915493	117	58	61.8	2	216	566	530	636	MEA2014215.1 DUF1566 domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	1047	97.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30851402	30851402	PRJNA577580_P_NODE_2394_length_584_cov_4.154599_g2316_i0	PRJNA577580	2394	584	4.154599	24.26285816	Pseudomonadati	3379134	Bacteria	Bacteria	58.2	4.97e-6	NR	KPA18647.1	1509431	g2316	i0	25.8	3.47260273972603	186	102	95.5	6	25	582	4573	4722	KPA18647.1 hypothetical protein MHK_001135, partial [Candidatus Magnetomorum sp. HK-1]	diamond	2028	58.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Candidatus Magnetomoraceae	Candidatus Magnetomorum	Candidatus Magnetomorum sp. HK-1
32211314	32211314	PRJNA577580_P_NODE_9498_length_296_cov_2.251121_g9420_i0	PRJNA577580	9498	296	2.251121	6.66331816	Bacteria	2	Bacteria	Bacteria	101	1.95e-22	NR	OQY57789.1	1972444	g9420	i0	60.9	2.95945945945946	92	34	92.2	2	3	275	200	290	OQY57789.1 MAG: hypothetical protein B6245_15245 [Desulfobacteraceae bacterium 4572_88]	diamond	876	102	0.990196078431373	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium 4572_88
32229568	32229568	PRJNA577580_P_NODE_4858_length_406_cov_4.111111_g4780_i0	PRJNA577580	4858	406	4.111111	16.69111066	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	49.3	0.00111	NR	HWP93311.1	2202153	g4780	i0	31.7	0.931034482758621	126	70	89.4	6	27	389	484	598	HWP93311.1 choice-of-anchor I family protein [Thermodesulfobacteriota bacterium]	diamond	378	49.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota 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);;