metadata: contig_metadata: 13 rows where bioproject = "PRJNA795983" and tax

13 rows where bioproject = "PRJNA795983" 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
3331402	3331402	PRJNA795983_S_NODE_8023_length_421_cov_1.477011_g7898_i0	PRJNA795983	8023	421	1.477011	6.21821631	Desulfococcaceae bacterium HSG8	3055603	Bacteria	Bacteria	125	2.2000000000000002e-30	NR	MDM8524962.1	3055603	g7898	i0	51.2	0.862232779097387	121	59	86.2	0	3	365	322	442	MDM8524962.1 S8 family serine peptidase [Desulfococcaceae bacterium HSG8]	diamond	363	125	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae		Desulfococcaceae bacterium HSG8
8869700	8869700	PRJNA795983_S_NODE_31867_length_262_cov_1.227513_g31742_i0	PRJNA795983	31867	262	1.227513	3.21608406	Pseudomonadati	3379134	Bacteria	Bacteria	147	8.57e-40	NR	WP_034608627.1	81425	g31742	i0	79.1	26.816793893129802	86	18	98.5	0	5	262	62	147	WP_034608627.1 adenosylhomocysteinase [Desulfovibrio aminophilus]	diamond	7026	148	0.993243243243243	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
13533741	13533741	PRJNA795983_S_NODE_28771_length_272_cov_1.140704_g28646_i0	PRJNA795983	28771	272	1.140704	3.10271488	root	1	Root_unresolved	Root_unresolved	131	4.05e-34	NR	PLX89983.1	892	g28646	i0	72.7	23.4154411764706	88	23	97.1	1	272	9	327	413	PLX89983.1 MAG: adenosylhomocysteinase, partial [Desulfuromonas sp.]	diamond	6369	132	0.992424242424242	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas sp.
27370199	27370199	PRJNA795983_S_NODE_17823_length_319_cov_1.577236_g17698_i0	PRJNA795983	17823	319	1.577236	5.03138284	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	43.1	0.049	NR	GJM17643.1	2202153	g17698	i0	25.9	0.761755485893417	81	59	75.2	1	298	59	133	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	243	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
27568381	27568381	PRJNA795983_S_NODE_17084_length_323_cov_1.848000_g16959_i0	PRJNA795983	17084	323	1.848	5.96904	Pseudomonadati	3379134	Bacteria	Bacteria	76.6	1.21e-13	NR	OGE24405.1	1797756	g16959	i0	73.3	1.38390092879257	45	12	41.8	0	159	293	528	572	OGE24405.1 MAG: hypothetical protein A3J42_06930 [Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21]	diamond	447	76.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria bacterium RIFCSPHIGHO2_12_FULL_53_21
28506588	28506588	PRJNA795983_S_NODE_16527_length_327_cov_1.389764_g16402_i0	PRJNA795983	16527	327	1.389764	4.54452828	Candidatus Magnetoglobus multicellularis str. Araruama	890399	Bacteria	Bacteria	44.7	0.0168	NR	ETR65097.1	890399	g16402	i0	32.5	0.73394495412844	80	50	69.7	2	292	65	83	162	ETR65097.1 MAG: hypothetical protein OMM_14826, partial [Candidatus Magnetoglobus multicellularis str. Araruama]	diamond	240	44.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Candidatus Magnetoglobus	Candidatus Magnetoglobus multicellularis
28696187	28696187	PRJNA795983_S_NODE_14347_length_342_cov_3.684015_g14222_i0	PRJNA795983	14347	342	3.684015	12.5993313	Desulfobulbaceae bacterium	2053307	Bacteria	Bacteria	63.5	6.02e-9	NR	MBS4000095.1	2053307	g14222	i0	64.6	0.421052631578947	48	15	40.4	1	205	342	131	178	MBS4000095.1 glutamine synthetase III [Desulfobulbaceae bacterium]	diamond	144	63.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae		Desulfobulbaceae bacterium
28822006	28822006	PRJNA795983_S_NODE_37508_length_248_cov_1.845714_g37383_i0	PRJNA795983	37508	248	1.845714	4.57737072	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	55.8	9.44e-7	NR	RJQ83914.1	2049433	g37383	i0	39.7	1.69354838709677	78	44	94.4	3	5	238	129	203	RJQ83914.1 MAG: hypothetical protein C4519_05855 [Desulfobacteraceae bacterium]	diamond	420	55.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
29390788	29390788	PRJNA795983_S_NODE_19789_length_308_cov_2.697872_g19664_i0	PRJNA795983	19789	308	2.697872	8.30944576	Smithella sp. SDB	1735324	Bacteria	Bacteria	73.9	8.73e-13	NR	KQC11342.1	1735324	g19664	i0	42.6	0.915584415584416	94	51	88.6	1	308	36	559	652	KQC11342.1 MAG: hypothetical protein APR62_10075 [Smithella sp. SDB]	diamond	282	73.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp. SDB
30843831	30843831	PRJNA795983_S_NODE_434_length_1263_cov_3.517647_g397_i0	PRJNA795983	434	1263	3.517647	44.42788161	Smithella sp.	2053614	Bacteria	Bacteria	97.1	1.83e-17	NR	MBP9014409.1	2053614	g397	i0	28.6	0.781472684085511	329	188	77.9	14	1244	261	544	826	MBP9014409.1 carboxypeptidase regulatory-like domain-containing protein [Smithella sp.]	diamond	987	97.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae	Smithella	Smithella sp.
30947842	30947842	PRJNA795983_S_NODE_13414_length_350_cov_1.895307_g13289_i0	PRJNA795983	13414	350	1.895307	6.6335745	Pseudomonadati	3379134	Bacteria	Bacteria	162	9e-46	NR	MEW6350612.1	2202153	g13289	i0	56.9	7.94571428571429	116	50	99.4	0	3	350	131	246	MEW6350612.1 alanine--glyoxylate aminotransferase family protein [Thermodesulfobacteriota bacterium]	diamond	2781	163	0.993865030674847	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
31065131	31065131	PRJNA795983_S_NODE_25175_length_284_cov_2.497630_g25050_i0	PRJNA795983	25175	284	2.49763	7.0932692	Syntrophus sp. SKADARSKE-3	3029837	Bacteria	Bacteria	63.5	2.77e-9	NR	MDQ5987783.1	3029837	g25050	i0	44.2	0.813380281690141	77	40	78.2	1	267	46	280	356	MDQ5987783.1 hypothetical protein [Syntrophus sp. SKADARSKE-3]	diamond	231	63.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus sp. SKADARSKE-3
32393404	32393404	PRJNA795983_S_NODE_37679_length_248_cov_1.320000_g37554_i0	PRJNA795983	37679	248	1.32	3.2736	Desulfonatronum thioautotrophicum	617001	Bacteria	Bacteria	45.4	0.00445	NR	WP_244148816.1	617001	g37554	i0	51.2	0.495967741935484	41	20	49.6	0	63	185	42	82	WP_244148816.1 molybdopterin-dependent oxidoreductase [Desulfonatronum thioautotrophicum]	diamond	123	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfonatronaceae	Desulfonatronum	Desulfonatronum thioautotrophicum

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