metadata: contig_metadata: 14 rows where bioproject = "PRJNA760904" and tax

14 rows where bioproject = "PRJNA760904" 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
22882678	22882678	PRJNA760904_P_NODE_17318_length_247_cov_0.885057_g17261_i0	PRJNA760904	17318	247	0.885057	2.18609079	Desulfovibrionaceae	194924	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|367460290\|gb\|CP003221.1\|	690850	g17261	i0	96.97	1.06072874493927	33	1	13	0	21	53	1940474	1940506	Desulfocurvibacter africanus subsp. africanus str. Walvis Bay chromosome, complete genome	blastn	262	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
27242723	27242723	PRJNA760904_P_NODE_5063_length_379_cov_1.258170_g5006_i0	PRJNA760904	5063	379	1.25817	4.7684643	Desulfobacterales bacterium SG8_35_2	1703401	Bacteria	Bacteria	136	2.24e-34	NR	KPK29044.1	1703401	g5006	i0	52	1.93139841688654	123	59	97.4	0	6	374	134	256	KPK29044.1 MAG: protease 2 [Desulfobacterales bacterium SG8_35_2]	diamond	732	136	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium SG8_35_2
27274405	27274405	PRJNA760904_P_NODE_13443_length_260_cov_1.219251_g13386_i0	PRJNA760904	13443	260	1.219251	3.1700526	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	58.5	1.1e-7	NR	MEW5771948.1	2202153	g13386	i0	38.2	0.784615384615385	68	42	78.5	0	5	208	258	325	MEW5771948.1 ABC transporter substrate-binding protein [Thermodesulfobacteriota bacterium]	diamond	204	58.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28158778	28158778	PRJNA760904_P_NODE_12745_length_265_cov_1.604167_g12688_i0	PRJNA760904	12745	265	1.604167	4.25104255	Fundidesulfovibrio putealis	270496	Bacteria	Bacteria	51.2	1.05e-5	NR	WP_027192164.1	270496	g12688	i0	42	0.99622641509434	88	48	98.5	3	3	263	2	87	WP_027192164.1 response regulator [Fundidesulfovibrio putealis]	diamond	264	51.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Fundidesulfovibrio	Fundidesulfovibrio putealis
29800313	29800313	PRJNA760904_P_NODE_851_length_812_cov_1.995940_g801_i0	PRJNA760904	851	812	1.99594	16.2070328	Desulfovibrionales bacterium	2448050	Bacteria	Bacteria	47.8	0.00614	NR	NLV95849.1	2448050	g801	i0	27.8	0.491379310344828	133	65	49.1	3	412	14	28	129	NLV95849.1 Hsp20/alpha crystallin family protein [Desulfovibrionales bacterium]	diamond	399	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales			Desulfovibrionales bacterium
29989960	29989960	PRJNA760904_P_NODE_18671_length_244_cov_1.350877_g18614_i0	PRJNA760904	18671	244	1.350877	3.29613988	Desulfatitalea alkaliphila	2929485	Bacteria	Bacteria	68.6	7.07e-12	NR	WP_263657639.1	2929485	g18614	i0	40.5	1.88114754098361	79	46	97.1	1	239	3	64	141	WP_263657639.1 peroxiredoxin-like family protein [Desulfatitalea alkaliphila]	diamond	459	68.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfatitalea	Desulfatitalea alkaliphila
30843100	30843100	PRJNA760904_P_NODE_154_length_1525_cov_3.139118_g137_i0	PRJNA760904	154	1525	3.139118	47.8715495	Smithella sp.	2053614	Bacteria	Bacteria	123	2.07e-28	NR	HNQ64885.1	2053614	g137	i0	37.2	0.338360655737705	172	102	32.9	3	901	401	38	208	HNQ64885.1 peroxiredoxin-like family protein [Smithella sp.]	diamond	516	123	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
30843108	30843108	PRJNA760904_P_NODE_19914_length_242_cov_0.911243_g19857_i0	PRJNA760904	19914	242	0.911243	2.20520806	Syntrophobacterales bacterium	2282155	Bacteria	Bacteria	78.6	4.07e-15	NR	MCK9376985.1	2282155	g19857	i0	52.9	1.82231404958678	68	32	84.3	0	238	35	141	208	MCK9376985.1 2-dehydropantoate 2-reductase [Syntrophobacterales bacterium]	diamond	441	78.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales			Syntrophobacterales bacterium
31801011	31801011	PRJNA760904_P_NODE_12217_length_269_cov_1.571429_g12160_i0	PRJNA760904	12217	269	1.571429	4.22714401	Pseudomonadati	3379134	Bacteria	Bacteria	49.7	1.91e-4	NR	WP_119332938.1	35554	g12160	i0	50.8	2.93308550185874	63	30	70.3	1	247	59	834	895	WP_119332938.1 Ig domain-containing protein [Geobacter sulfurreducens]	diamond	789	49.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
32180981	32180981	PRJNA760904_P_NODE_18778_length_244_cov_0.900585_g18721_i0	PRJNA760904	18778	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	102	4.41e-25	NR	WP_014809560.1	2358	g18721	i0	62.5	6.88524590163934	80	30	98.4	0	2	241	13	92	WP_014809560.1 NADPH-dependent FMN reductase [Desulfomonile tiedjei]	diamond	1680	103	0.990291262135922	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
32298115	32298115	PRJNA760904_P_NODE_7679_length_320_cov_1.246964_g7622_i0	PRJNA760904	7679	320	1.246964	3.9902848	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	126	4.16e-34	NR	MEW6264895.1	2202153	g7622	i0	58.2	1.846875	98	41	91.9	0	312	19	85	182	MEW6264895.1 DJ-1 family glyoxalase III [Thermodesulfobacteriota bacterium]	diamond	591	126	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
32487742	32487742	PRJNA760904_P_NODE_11719_length_273_cov_1.420000_g11662_i0	PRJNA760904	11719	273	1.42	3.8766	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	51.2	5.58e-5	NR	KAF0218738.1	2282154	g11662	i0	47.4	0.626373626373626	57	29	62.6	1	93	263	1	56	KAF0218738.1 MAG: methyltransferase/glycosyl transferase fusion [Geobacteraceae bacterium]	diamond	171	51.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
32613930	32613930	PRJNA760904_P_NODE_7680_length_320_cov_1.246964_g7623_i0	PRJNA760904	7680	320	1.246964	3.9902848	Syntrophorhabdus sp.	2699756	Bacteria	Bacteria	65.1	1.35e-9	NR	HOD77050.1	2699756	g7623	i0	40.7	0.759375	81	47	75	1	254	15	132	212	HOD77050.1 DUF4062 domain-containing protein [Syntrophorhabdus sp.]	diamond	243	65.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae	Syntrophorhabdus	Syntrophorhabdus sp.
32708299	32708299	PRJNA760904_P_NODE_14260_length_253_cov_2.550000_g14203_i0	PRJNA760904	14260	253	2.55	6.4515	Desulfovibrio sp.	885	Bacteria	Bacteria	41.6	0.0142	NR	NMC49006.1	885	g14203	i0	37.3	0.604743083003953	51	31	60.5	1	26	178	4	53	NMC49006.1 hypothetical protein [Desulfovibrio sp.]	diamond	153	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio 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);;