metadata: contig_metadata: 10 rows where bioproject = "PRJNA407087", tax_phylum = "Thermodesulfobacteriota" and tax

10 rows where bioproject = "PRJNA407087", 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_species
10618921	10618921	PRJNA407087_S_NODE_8389_length_165_cov_9.794118_g7926_i0	PRJNA407087	8389	165	9.794118	16.1602947	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	101	1.05e-24	NR	GJM17674.1	2202153	g7926	i0	87	0.981818181818182	54	7	98.2	0	163	2	17	70	GJM17674.1 MAG: hypothetical protein DHS20C13_30010 [Thermodesulfobacteriota bacterium]	diamond	162	101	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
19540767	19540767	PRJNA407087_S_NODE_8936_length_160_cov_2.068702_g8473_i0	PRJNA407087	8936	160	2.068702	3.3099232	Bacteria	2	Bacteria	Bacteria	89.4	4.62e-19	NR	OEU54602.1	1869305	g8473	i0	77.4	54.65625	53	12	99.4	0	160	2	51	103	OEU54602.1 MAG: aconitate hydratase 1 [Desulfobulbaceae bacterium S3730MH12]	diamond	8745	89.7	0.996655518394649	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbaceae bacterium S3730MH12
27770625	27770625	PRJNA407087_S_NODE_7224_length_182_cov_1.581699_g6761_i0	PRJNA407087	7224	182	1.581699	2.87869218	Syntrophales bacterium	2928017	Bacteria	Bacteria	62	2.6e-9	NR	MFA5183239.1	2928017	g6761	i0	45.8	0.972527472527473	59	32	97.3	0	6	182	453	511	MFA5183239.1 FAD-dependent oxidoreductase [Syntrophales bacterium]	diamond	177	62	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales		Syntrophales bacterium
28243827	28243827	PRJNA407087_S_NODE_186_length_2288_cov_14.627269_g112_i2	PRJNA407087	186	2288	14.627269	334.67191472	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	54.7	3.38e-4	NR	GJM17643.1	2202153	g112	i2	25.3	0.295017482517482	225	133	27.7	7	1202	570	10	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	675	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
28938746	28938746	PRJNA407087_S_NODE_128_length_3497_cov_13.183968_g112_i0	PRJNA407087	128	3497	13.183968	461.04336096	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	54.7	5.54e-4	NR	GJM17643.1	2202153	g112	i0	25.3	0.193022590792108	225	133	18.1	7	2197	2829	10	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	675	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
30297093	30297093	PRJNA407087_S_NODE_132_length_3458_cov_13.388451_g112_i1	PRJNA407087	132	3458	13.388451	462.97263558	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	54.7	5.47e-4	NR	GJM17643.1	2202153	g112	i1	25.3	0.1951995373048	225	133	18.3	7	1262	630	10	213	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	675	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
30644001	30644001	PRJNA407087_S_NODE_8053_length_170_cov_1.992908_g7590_i0	PRJNA407087	8053	170	1.992908	3.3879436	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	80.5	6.43e-17	NR	GJM17743.1	2202153	g7590	i0	64.3	0.988235294117647	56	20	98.8	0	1	168	146	201	GJM17743.1 MAG: hypothetical protein DHS20C13_30700 [Thermodesulfobacteriota bacterium]	diamond	168	80.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
30770705	30770705	PRJNA407087_S_NODE_7834_length_173_cov_2.569444_g7371_i0	PRJNA407087	7834	173	2.569444	4.44513812	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	41.6	0.038	NR	HSG31169.1	2202153	g7371	i0	47.7	0.763005780346821	44	23	76.3	0	133	2	409	452	HSG31169.1 aminomethyl-transferring glycine dehydrogenase [Thermodesulfobacteriota bacterium]	diamond	132	41.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
32510210	32510210	PRJNA407087_S_NODE_7719_length_175_cov_1.561644_g7256_i0	PRJNA407087	7719	175	1.561644	2.732877	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	48.9	6.97e-5	NR	GJM17643.1	2202153	g7256	i0	36.4	0.942857142857143	55	35	94.3	0	173	9	147	201	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	165	48.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota				Thermodesulfobacteriota bacterium
32730692	32730692	PRJNA407087_S_NODE_7040_length_185_cov_2.237179_g6577_i0	PRJNA407087	7040	185	2.237179	4.13878115	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	68.6	1.34e-11	NR	HAO22905.1	2049433	g6577	i0	54.2	0.956756756756757	59	27	95.7	0	2	178	160	218	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	177	68.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacteraceae 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);;