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

10 rows where bioproject = "PRJNA846110", 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
2108467	2108467	PRJNA846110_P_NODE_19982_length_263_cov_1.552632_g19737_i0	PRJNA846110	19982	263	1.552632	4.08342216	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	233	7.99e-57	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g19737	i0	82.9	2.86311787072243	269	37	100	7	1	263	2347693	2347958	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	753	233	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
12710934	12710934	PRJNA846110_P_NODE_22690_length_251_cov_0.865169_g22445_i0	PRJNA846110	22690	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	196	9.93e-46	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g22445	i0	87.952	65.5896414342629	166	20	66	0	55	220	30335	30170	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	16463	196	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23785373	23785373	PRJNA846110_P_NODE_24879_length_248_cov_0.880000_g24634_i0	PRJNA846110	24879	248	0.88	2.1824	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	265	2.6499999999999997e-66	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g24634	i0	85.887	93.4153225806452	248	35	100	0	1	248	1681179	1681426	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	23167	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
26651417	26651417	PRJNA846110_P_NODE_23361_length_250_cov_0.870056_g23116_i0	PRJNA846110	23361	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	63.5	1.91e-9	NR	HTW81267.1	1964191	g23116	i0	46.6	1.776	73	36	86.4	2	16	231	198	268	HTW81267.1 acyltransferase family protein [Terracidiphilus sp.]	diamond	444	63.9	0.993740219092332	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
26801483	26801483	PRJNA846110_P_NODE_16721_length_279_cov_1.388350_g16476_i0	PRJNA846110	16721	279	1.38835	3.8734965	Blastocatellia bacterium	2052146	Bacteria	Bacteria	90.9	6.9e-19	NR	MBX7223318.1	2052146	g16476	i0	58.7	0.989247311827957	92	38	98.9	0	278	3	823	914	MBX7223318.1 carboxypeptidase regulatory-like domain-containing protein [Blastocatellia bacterium]	diamond	276	90.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
27718573	27718573	PRJNA846110_P_NODE_14964_length_287_cov_2.453271_g14719_i0	PRJNA846110	14964	287	2.453271	7.04088777	Bryobacterales bacterium	2026791	Bacteria	Bacteria	194	6.520000000000001e-59	NR	MSV31675.1	2026791	g14719	i0	93.7	4.96515679442509	95	6	99.3	0	285	1	66	160	MSV31675.1 DUF1501 domain-containing protein [Bryobacterales bacterium]	diamond	1425	194	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
28191533	28191533	PRJNA846110_P_NODE_27766_length_244_cov_0.900585_g27521_i0	PRJNA846110	27766	244	0.900585	2.1974274	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	80.5	1.47e-15	NR	HWE00483.1	2212468	g27521	i0	60.3	1.72131147540984	58	23	71.3	0	242	69	154	211	HWE00483.1 glycosyltransferase [Bryobacteraceae bacterium]	diamond	420	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28326317	28326317	PRJNA846110_P_NODE_17486_length_275_cov_1.940594_g17241_i0	PRJNA846110	17486	275	1.940594	5.3366335	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	105	3.7799999999999996e-24	NR	HST24295.1	2052146	g17241	i0	93.9	11.2036363636364	49	3	53.5	0	127	273	1	49	HST24295.1 hypothetical protein [Blastocatellia bacterium]	diamond	3081	106	0.990566037735849	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
28854649	28854649	PRJNA846110_P_NODE_30808_length_231_cov_2.405063_g30563_i0	PRJNA846110	30808	231	2.405063	5.55569553	Edaphobacter sp.	1934404	Bacteria	Bacteria	143	2.45e-40	NR	WP_299371629.1	1934404	g30563	i0	91.3	0.896103896103896	69	6	89.6	0	212	6	2	70	WP_299371629.1 DUF692 domain-containing protein [Edaphobacter sp.]	diamond	207	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter sp.
29810337	29810337	PRJNA846110_P_NODE_17371_length_276_cov_1.354680_g17126_i0	PRJNA846110	17371	276	1.35468	3.7389168	Bacteria	2	Bacteria	Bacteria	119	4.6899999999999994e-30	NR	MBZ5646461.1	2081523	g17126	i0	80.6	3.90217391304348	72	14	78.3	0	3	218	304	375	MBZ5646461.1 SAM-dependent methyltransferase [Terriglobia bacterium]	diamond	1077	120	0.991666666666667	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia 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);;