metadata: contig_metadata: 6 rows where bioproject = "PRJNA1123436" and tax

6 rows where bioproject = "PRJNA1123436" and tax_phylum = "Atribacterota"

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
23231148	23231148	PRJNA1123436_P_NODE_109439_length_247_cov_0.885057_g108225_i0	PRJNA1123436	109439	247	0.885057	2.18609079	Candidatus Infernicultor aquiphilus	1805029	Bacteria	Bacteria	166	4.55e-49	NR	WP_406607698.1	1805029	g108225	i0	98.8	0.995951417004049	82	1	99.6	0	2	247	52	133	WP_406607698.1 purine-nucleoside phosphorylase [Candidatus Infernicultor aquiphilus]	diamond	246	166	1	Bacteria	Pseudomonadati	Atribacterota	Candidatus Phoenicimicrobiia	Candidatus Pheonicimicrobiales	Candidatus Phoenicimicrobiaceae	Candidatus Infernicultor	Candidatus Infernicultor aquiphilus
26595179	26595179	PRJNA1123436_P_NODE_46401_length_368_cov_1.413559_g45187_i0	PRJNA1123436	46401	368	1.413559	5.20189712	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	119	1.57e-31	NR	MBE3118975.1	2053509	g45187	i0	54.2	0.782608695652174	96	44	78.3	0	288	1	1	96	MBE3118975.1 hypothetical protein [Candidatus Atribacteria bacterium]	diamond	288	119	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
27817721	27817721	PRJNA1123436_P_NODE_92804_length_254_cov_1.381215_g91590_i0	PRJNA1123436	92804	254	1.381215	3.5082861	Atribacterota	67818	Bacteria	Bacteria	130	3.47e-36	NR	WP_406606792.1	1805029	g91590	i0	90	1.65354330708661	70	7	82.7	0	212	3	88	157	WP_406606792.1 translation elongation factor Ts [Candidatus Infernicultor aquiphilus]	diamond	420	131	0.99236641221374	Bacteria	Pseudomonadati	Atribacterota	Candidatus Phoenicimicrobiia	Candidatus Pheonicimicrobiales	Candidatus Phoenicimicrobiaceae	Candidatus Infernicultor	Candidatus Infernicultor aquiphilus
29217809	29217809	PRJNA1123436_P_NODE_49629_length_355_cov_1.173759_g48415_i0	PRJNA1123436	49629	355	1.173759	4.16684445	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	47.4	0.00278	NR	MBE3118311.1	2053509	g48415	i0	34.1	0.692957746478873	82	50	65.9	1	341	108	64	145	MBE3118311.1 hypothetical protein [Candidatus Atribacteria bacterium]	diamond	246	47.4	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
30891870	30891870	PRJNA1123436_P_NODE_41274_length_392_cov_1.664577_g40060_i0	PRJNA1123436	41274	392	1.664577	6.52514184	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	81.3	1.02e-16	NR	MBE3118974.1	2053509	g40060	i0	39.6	0.73469387755102	96	57	73.5	1	70	357	3	97	MBE3118974.1 M15 family metallopeptidase [Candidatus Atribacteria bacterium]	diamond	288	81.3	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
32462325	32462325	PRJNA1123436_P_NODE_110639_length_246_cov_0.890173_g109425_i0	PRJNA1123436	110639	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	149	3.31e-42	NR	MBE3119590.1	2053509	g109425	i0	80.2	3.92682926829268	81	16	98.8	0	2	244	48	128	MBE3119590.1 site-specific DNA-methyltransferase [Candidatus Atribacteria bacterium]	diamond	966	149	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria 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);;