metadata: contig_metadata: 7 rows where bioproject = "PRJNA575566", tax_phylum = "Thermodesulfobacteriota" and tax

7 rows where bioproject = "PRJNA575566", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

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
11339871	11339871	PRJNA575566_P_NODE_11129_length_314_cov_1.011858_g10932_i0	PRJNA575566	11129	314	1.011858	3.17723412	Pseudomonadati	3379134	Bacteria	Bacteria	135	2.2899999999999998e-38	NR	WP_053551153.1	1603606	g10932	i0	60.6	3.94585987261146	104	41	99.4	0	312	1	12	115	WP_053551153.1 hypothetical protein [Desulfuromonas soudanensis]	diamond	1239	136	0.992647058823529	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis
15862752	15862752	PRJNA575566_P_NODE_22773_length_217_cov_1.217949_g22576_i0	PRJNA575566	22773	217	1.217949	2.64294933	uncultured Desulfosarcina sp.	218289	Bacteria	Bacteria	169	1.82e-37	NTclustered	gi\|2621713517\|emb\|OY771548.1\|	218289	g22576	i0	81.395	137.018433179724	215	32	98	8	1	212	91060	90851	MAG: uncultured Desulfosarcina sp. isolate c75788b4-9dc9-432e-af07-dc879bdb42fc genome assembly, chromosome: 1	blastn	29733	169	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	uncultured Desulfosarcina sp.
27630366	27630366	PRJNA575566_P_NODE_19604_length_237_cov_1.454545_g19407_i0	PRJNA575566	19604	237	1.454545	3.44727165	root	1	Root_unresolved	Root_unresolved	43.1	0.0257	NR	WP_207687708.1	45656	g19407	i0	53.7	1.0379746835443	41	14	45.6	2	73	180	87	127	WP_207687708.1 AAA family ATPase [Desulfonema limicola]	diamond	246	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema limicola
29416207	29416207	PRJNA575566_P_NODE_25009_length_208_cov_0.870748_g24812_i0	PRJNA575566	25009	208	0.870748	1.81115584	Malonomonas rubra	57040	Bacteria	Bacteria	75.9	3.18e-14	NR	WP_072908240.1	57040	g24812	i0	58.8	2.94230769230769	68	28	98.1	0	208	5	104	171	WP_072908240.1 SDH family Clp fold serine proteinase [Malonomonas rubra]	diamond	612	75.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae	Malonomonas	Malonomonas rubra
30269371	30269371	PRJNA575566_P_NODE_28952_length_202_cov_0.907801_g28755_i0	PRJNA575566	28952	202	0.907801	1.83375802	Desulfatibacillaceae bacterium	3045165	Bacteria	Bacteria	42.7	0.0216	NR	MFP4474188.1	3045165	g28755	i0	42.3	0.772277227722772	52	29	77.2	1	24	179	1	51	MFP4474188.1 tetratricopeptide repeat protein [Desulfatibacillaceae bacterium]	diamond	156	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae		Desulfatibacillaceae bacterium
31691394	31691394	PRJNA575566_P_NODE_24097_length_209_cov_0.864865_g23900_i0	PRJNA575566	24097	209	0.864865	1.80756785	Desulfobulbus sp.	895	Bacteria	Bacteria	105	1.35e-24	NR	RUM35634.1	895	g23900	i0	61.8	5.78468899521531	68	26	97.6	0	208	5	32	99	RUM35634.1 MAG: propionyl-CoA synthetase [Desulfobulbus sp.]	diamond	1209	105	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp.
32179714	32179714	PRJNA575566_P_NODE_13498_length_286_cov_1.422222_g13301_i0	PRJNA575566	13498	286	1.422222	4.06755492	Pseudomonadati	3379134	Bacteria	Bacteria	157	1.54e-45	NR	WP_012175381.1	181663	g13301	i0	78.9	24.9125874125874	95	20	99.7	0	286	2	53	147	WP_012175381.1 cephalosporin hydroxylase family protein [Desulfosudis oleivorans]	diamond	7125	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosudaceae	Desulfosudis	Desulfosudis oleivorans

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