metadata: contig_metadata: 22 rows where analysis = "diamond", bioproject = "PRJNA758088" and tax

22 rows where analysis = "diamond", bioproject = "PRJNA758088" 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
10132285	10132285	PRJNA758088_P_NODE_282668_length_251_cov_0.865169_g275697_i0	PRJNA758088	282668	251	0.865169	2.17157419	uncultured Bilophila sp.	529385	Bacteria	Bacteria	170	5.41e-49	NR	WP_294515549.1	529385	g275697	i0	100	0.968127490039841	81	0	96.8	0	245	3	1	81	WP_294515549.1 dihydrolipoyl dehydrogenase family protein [uncultured Bilophila sp.]	diamond	243	170	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	uncultured Bilophila sp.
12215438	12215438	PRJNA758088_P_NODE_218970_length_288_cov_1.074419_g211999_i0	PRJNA758088	218970	288	1.074419	3.09432672	Bilophila wadsworthia	35833	Bacteria	Bacteria	214	4.78e-69	NR	MFR7889704.1	35833	g211999	i0	100	2.96875	95	0	99	0	286	2	42	136	MFR7889704.1 methionine-R-sulfoxide reductase [Bilophila wadsworthia]	diamond	855	214	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
26957889	26957889	PRJNA758088_P_NODE_314282_length_247_cov_0.885057_g307311_i0	PRJNA758088	314282	247	0.885057	2.18609079	Smithellaceae bacterium	2964540	Bacteria	Bacteria	109	1.52e-29	NR	HNS57204.1	2964540	g307311	i0	94.9	0.716599190283401	59	3	71.7	0	19	195	1	59	HNS57204.1 hypothetical protein [Smithellaceae bacterium]	diamond	177	109	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
27021382	27021382	PRJNA758088_P_NODE_322442_length_246_cov_0.890173_g315471_i0	PRJNA758088	322442	246	0.890173	2.18982558	Bilophila wadsworthia	35833	Bacteria	Bacteria	164	5.58e-48	NR	WP_415977404.1	35833	g315471	i0	100	0.98780487804878	81	0	98.8	0	245	3	6	86	WP_415977404.1 glycosyltransferase family 2 protein [Bilophila wadsworthia]	diamond	243	164	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
27147379	27147379	PRJNA758088_P_NODE_328742_length_245_cov_0.895349_g321771_i0	PRJNA758088	328742	245	0.895349	2.19360505	Bilophila wadsworthia	35833	Bacteria	Bacteria	113	4.85e-30	NR	WP_302979710.1	35833	g321771	i0	94.6	0.685714285714286	56	3	68.6	0	76	243	1	56	WP_302979710.1 hypothetical protein [Bilophila wadsworthia]	diamond	168	113	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
27274283	27274283	PRJNA758088_P_NODE_317303_length_247_cov_0.885057_g310332_i0	PRJNA758088	317303	247	0.885057	2.18609079	Bilophila wadsworthia	35833	Bacteria	Bacteria	157	9.449999999999999e-48	NR	WP_005026185.1	35833	g310332	i0	100	2.95141700404858	81	0	98.4	0	5	247	1	81	WP_005026185.1 hypothetical protein [Bilophila wadsworthia]	diamond	729	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
27536789	27536789	PRJNA758088_P_NODE_361563_length_241_cov_0.916667_g354592_i0	PRJNA758088	361563	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	59.7	2.69e-8	NR	MBO4296782.1	885	g354592	i0	41.3	2.57676348547718	75	40	93.4	1	226	2	52	122	MBO4296782.1 HNH endonuclease [Desulfovibrio sp.]	diamond	621	60.1	0.993344425956739	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
27590276	27590276	PRJNA758088_P_NODE_284024_length_251_cov_0.865169_g277053_i0	PRJNA758088	284024	251	0.865169	2.17157419	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	162	3.92e-50	NR	PWL64295.1	2049043	g277053	i0	98.6	0.872509960159363	73	1	87.3	0	2	220	4	76	PWL64295.1 MAG: hypothetical protein DBY37_02620 [Desulfovibrionaceae bacterium]	diamond	219	162	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
27685125	27685125	PRJNA758088_P_NODE_288764_length_250_cov_0.870056_g281793_i0	PRJNA758088	288764	250	0.870056	2.17514	Oryzomonas sagensis	2603857	Bacteria	Bacteria	139	3.49e-36	NR	WP_151156463.1	2603857	g281793	i0	75.6	0.984	82	20	98.4	0	248	3	263	344	WP_151156463.1 site-specific DNA-methyltransferase [Oryzomonas sagensis]	diamond	246	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Oryzomonas	Oryzomonas sagensis
27758067	27758067	PRJNA758088_P_NODE_359284_length_242_cov_0.893491_g352313_i0	PRJNA758088	359284	242	0.893491	2.16224822	Bilophila	35832	Bacteria	Bacteria	142	3.77e-39	NR	WP_302292539.1	35833	g352313	i0	100	6.24793388429752	72	0	89.3	0	27	242	1	72	WP_302292539.1 TRAP transporter substrate-binding protein [Bilophila wadsworthia]	diamond	1512	142	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
27915487	27915487	PRJNA758088_P_NODE_196865_length_303_cov_1.339130_g189894_i0	PRJNA758088	196865	303	1.33913	4.0575639	Bilophila	35832	Bacteria	Bacteria	181	4.92e-53	NR	WP_337939300.1	35833	g189894	i0	100	3.96039603960396	100	0	99	0	302	3	84	183	WP_337939300.1 SLC13 family permease, partial [Bilophila wadsworthia]	diamond	1200	181	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
28632268	28632268	PRJNA758088_P_NODE_359547_length_242_cov_0.863905_g352576_i0	PRJNA758088	359547	242	0.863905	2.0906501	Candidatus Mailhella excrementigallinarum	2838656	Bacteria	Bacteria	133	1.4100000000000001e-36	NR	HIV65476.1	2838656	g352576	i0	97.1	0.867768595041322	70	2	86.8	0	1	210	181	250	HIV65476.1 DNA alkylation repair protein [Candidatus Mailhella excrementigallinarum]	diamond	210	133	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	Candidatus Mailhella excrementigallinarum
28695381	28695381	PRJNA758088_P_NODE_316847_length_247_cov_0.885057_g309876_i0	PRJNA758088	316847	247	0.885057	2.18609079	Bilophila wadsworthia	35833	Bacteria	Bacteria	121	3.95e-33	NR	MFR1534497.1	35833	g309876	i0	98.4	1.48178137651822	61	1	74.1	0	185	3	1	61	MFR1534497.1 AraC family transcriptional regulator [Bilophila wadsworthia]	diamond	366	121	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
29358299	29358299	PRJNA758088_P_NODE_167929_length_327_cov_0.937008_g160958_i0	PRJNA758088	167929	327	0.937008	3.06401616	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	52.4	2.16e-6	NR	MFO7876311.1	2821143	g160958	i0	70	0.36697247706422	40	10	36.7	1	112	231	24	61	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	120	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
29358337	29358337	PRJNA758088_P_NODE_364129_length_241_cov_0.916667_g357158_i0	PRJNA758088	364129	241	0.916667	2.20916747	Bilophila wadsworthia	35833	Bacteria	Bacteria	111	8.98e-28	NR	WP_337748850.1	35833	g357158	i0	98.2	0.697095435684647	56	1	69.7	0	240	73	63	118	WP_337748850.1 hypothetical protein [Bilophila wadsworthia]	diamond	168	111	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
29863389	29863389	PRJNA758088_P_NODE_299651_length_249_cov_0.875000_g292680_i0	PRJNA758088	299651	249	0.875	2.17875	Smithellaceae bacterium	2964540	Bacteria	Bacteria	155	6.3299999999999985e-43	NR	MEQ8253585.1	2964540	g292680	i0	98.8	2.96385542168675	82	1	98.8	0	248	3	82	163	MEQ8253585.1 aspartate--tRNA ligase [Smithellaceae bacterium]	diamond	738	155	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
30716379	30716379	PRJNA758088_P_NODE_300014_length_249_cov_0.875000_g293043_i0	PRJNA758088	300014	249	0.875	2.17875	Candidatus Mailhella excrementigallinarum	2838656	Bacteria	Bacteria	185	4.6199999999999986e-55	NR	HIV65525.1	2838656	g293043	i0	98.8	0.987951807228916	82	1	98.8	0	247	2	265	346	HIV65525.1 outer membrane protein transport protein [Candidatus Mailhella excrementigallinarum]	diamond	246	185	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	Candidatus Mailhella excrementigallinarum
30748133	30748133	PRJNA758088_P_NODE_27294_length_929_cov_1.872664_g21936_i0	PRJNA758088	27294	929	1.872664	17.397048560000002	Desulfurivibrionaceae bacterium	3024425	Bacteria	Bacteria	220	7.37e-61	NR	MFA6899630.1	3024425	g21936	i0	50	1.0010764262648	310	130	96.6	8	910	14	546	841	MFA6899630.1 hypothetical protein [Desulfurivibrionaceae bacterium]	diamond	930	220	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfurivibrionaceae		Desulfurivibrionaceae bacterium
31475205	31475205	PRJNA758088_P_NODE_345356_length_243_cov_0.905882_g338385_i0	PRJNA758088	345356	243	0.905882	2.20129326	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	160	8.269999999999999e-48	NR	PWL56401.1	2049043	g338385	i0	100	1	81	0	100	0	1	243	84	164	PWL56401.1 MAG: nickel pincer cofactor biosynthesis protein LarB [Desulfovibrionaceae bacterium]	diamond	243	160	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
31642846	31642846	PRJNA758088_P_NODE_217576_length_289_cov_1.069444_g210605_i0	PRJNA758088	217576	289	1.069444	3.09069316	Bacteria	2	Bacteria	Bacteria	110	5.380000000000001e-27	NR	MBP3734779.1	885	g210605	i0	94.7	1.77508650519031	57	3	59.2	0	171	1	1	57	MBP3734779.1 transposase [Desulfovibrio sp.]	diamond	513	111	0.990990990990991	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.
31959287	31959287	PRJNA758088_P_NODE_361577_length_241_cov_0.916667_g354606_i0	PRJNA758088	361577	241	0.916667	2.20916747	Bilophila	35832	Bacteria	Bacteria	98.6	1.58e-22	NR	WP_303327373.1	35833	g354606	i0	94.1	4.44398340248963	51	3	63.5	0	155	3	1	51	WP_303327373.1 NADP-specific glutamate dehydrogenase, partial [Bilophila wadsworthia]	diamond	1071	98.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	Bilophila wadsworthia
32044483	32044483	PRJNA758088_P_NODE_284858_length_251_cov_0.865169_g277887_i0	PRJNA758088	284858	251	0.865169	2.17157419	uncultured Bilophila sp.	529385	Bacteria	Bacteria	145	3.49e-40	NR	WP_294509767.1	529385	g277887	i0	95.2	0.99203187250996006	83	4	99.2	0	3	251	100	182	WP_294509767.1 efflux RND transporter periplasmic adaptor subunit [uncultured Bilophila sp.]	diamond	249	145	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Bilophila	uncultured Bilophila 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);;