metadata: contig_metadata: 10 rows where bioproject = "PRJNA352610", tax_phylum = "Acidobacteriota" and tax

10 rows where bioproject = "PRJNA352610", tax_phylum = "Acidobacteriota" 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
25296746	25296746	PRJNA352610_P_NODE_28160_length_247_cov_0.885057_g28099_i0	PRJNA352610	28160	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	159	2.56e-46	NR	MDQ6787343.1	1978231	g28099	i0	90.2	5.97570850202429	82	8	99.6	0	1	246	33	114	MDQ6787343.1 tRNA 2-thiocytidine(32) synthetase TtcA [Acidobacteriota bacterium]	diamond	1476	160	0.99375	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26631654	26631654	PRJNA352610_P_NODE_30761_length_242_cov_2.301775_g30700_i0	PRJNA352610	30761	242	2.301775	5.5702955	Terriglobia bacterium	2081523	Bacteria	Bacteria	77	1.61e-14	NR	HMF03004.1	2081523	g30700	i0	55.1	1.78512396694215	78	35	96.7	0	6	239	234	311	HMF03004.1 fructose bisphosphate aldolase [Terriglobia bacterium]	diamond	432	77	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
27675288	27675288	PRJNA352610_P_NODE_8644_length_389_cov_1.772152_g8583_i0	PRJNA352610	8644	389	1.772152	6.89367128	Blastocatellia bacterium	2052146	Bacteria	Bacteria	56.6	1.53e-7	NR	MDX6709678.1	2052146	g8583	i0	39.5	2.20565552699229	86	52	66.3	0	36	293	1	86	MDX6709678.1 hypothetical protein [Blastocatellia bacterium]	diamond	858	56.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
28053803	28053803	PRJNA352610_P_NODE_29865_length_244_cov_0.900585_g29804_i0	PRJNA352610	29865	244	0.900585	2.1974274	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	43.1	0.0274	NR	HYN01254.1	2793154	g29804	i0	33.3	0.737704918032787	60	37	70.1	1	29	199	206	265	HYN01254.1 sulfatase [Vicinamibacteria bacterium]	diamond	180	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
28211593	28211593	PRJNA352610_P_NODE_9486_length_376_cov_1.521452_g9425_i0	PRJNA352610	9486	376	1.521452	5.72065952	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	48.5	0.00127	NR	MEA2691524.1	1978231	g9425	i0	45.8	1.53989361702128	48	19	38.3	2	376	233	215	255	MEA2691524.1 hypothetical protein [Acidobacteriota bacterium]	diamond	579	48.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28306527	28306527	PRJNA352610_P_NODE_29266_length_245_cov_0.895349_g29205_i0	PRJNA352610	29266	245	0.895349	2.19360505	Candidatus Acidiferrum typicum	1953112	Bacteria	Bacteria	47.4	8.5e-4	NR	MCU1343560.1	1953112	g29205	i0	30.1	2.53469387755102	73	51	89.4	0	232	14	155	227	MCU1343560.1 hypothetical protein [Candidatus Acidiferrum typicum]	diamond	621	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum typicum
30074621	30074621	PRJNA352610_P_NODE_20852_length_275_cov_1.861386_g20791_i0	PRJNA352610	20852	275	1.861386	5.1188115	Blastocatellia bacterium	2052146	Bacteria	Bacteria	50.8	6.61e-5	NR	HEY8458878.1	2052146	g20791	i0	39.1	0.949090909090909	87	49	93.8	2	6	263	177	260	HEY8458878.1 HEAT repeat domain-containing protein [Blastocatellia bacterium]	diamond	261	50.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
31022720	31022720	PRJNA352610_P_NODE_31035_length_242_cov_0.911243_g30974_i0	PRJNA352610	31035	242	0.911243	2.20520806	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.7	0.00755	NR	MDQ3348975.1	1978231	g30974	i0	36.4	0.818181818181818	66	39	81.8	1	41	238	108	170	MDQ3348975.1 hypothetical protein [Acidobacteriota bacterium]	diamond	198	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32336812	32336812	PRJNA352610_P_NODE_13379_length_330_cov_1.190661_g13318_i0	PRJNA352610	13379	330	1.190661	3.9291813	Pseudomonadati	3379134	Bacteria	Bacteria	103	3.0199999999999995e-23	NR	PYV22530.1	1978231	g13318	i0	47.6	14.1636363636364	103	54	93.6	0	329	21	90	192	PYV22530.1 MAG: hypothetical protein DMG24_16385, partial [Acidobacteriota bacterium]	diamond	4674	103	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32747060	32747060	PRJNA352610_P_NODE_9660_length_374_cov_0.946844_g9599_i0	PRJNA352610	9660	374	0.946844	3.54119656	Terriglobales	204433	Bacteria	Bacteria	79.3	6.38e-15	NR	HEY1257354.1	1964191	g9599	i0	37.5	2.6951871657754	112	60	82.6	3	64	372	21	131	HEY1257354.1 hypothetical protein [Terracidiphilus sp.]	diamond	1008	79.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus 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);;