metadata: contig_metadata: 5 rows where bioproject = "PRJNA549880", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA549880", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

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
6223254	6223254	PRJNA549880_P_NODE_13085_length_246_cov_0.890173_g12992_i0	PRJNA549880	13085	246	0.890173	2.18982558	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	158	8.919999999999999e-45	NR	HEV7905460.1	2283092	g12992	i0	93.9	2	82	5	100	0	1	246	181	262	HEV7905460.1 HD domain-containing phosphohydrolase [Pyrinomonadaceae bacterium]	diamond	492	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29477584	29477584	PRJNA549880_P_NODE_12170_length_248_cov_0.880000_g12077_i0	PRJNA549880	12170	248	0.88	2.1824	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	101	7.74e-24	NR	HSU79063.1	2976921	g12077	i0	72.4	1.36693548387097	58	16	70.2	0	74	247	1	58	HSU79063.1 Ku protein [Candidatus Angelobacter sp.]	diamond	339	101	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Candidatus Angelobacter	Candidatus Angelobacter sp.
29587122	29587122	PRJNA549880_P_NODE_13210_length_246_cov_0.890173_g13117_i0	PRJNA549880	13210	246	0.890173	2.18982558	Terracidiphilus	1768185	Bacteria	Bacteria	119	3.33e-29	NR	KAA6462065.1	1230846	g13117	i0	67.5	3.90243902439024	80	26	97.6	0	4	243	210	289	KAA6462065.1 alpha-L-rhamnosidase [Acidobacteria bacterium AB60]	diamond	960	120	0.991666666666667	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium AB60
30741394	30741394	PRJNA549880_P_NODE_12934_length_246_cov_0.890173_g12841_i0	PRJNA549880	12934	246	0.890173	2.18982558	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	111	1.3600000000000002e-26	NR	HYL76602.1	2212468	g12841	i0	61.3	1.96341463414634	80	31	97.6	0	242	3	258	337	HYL76602.1 long-chain fatty acid--CoA ligase [Bryobacteraceae bacterium]	diamond	483	111	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31183492	31183492	PRJNA549880_P_NODE_10695_length_251_cov_0.865169_g10602_i0	PRJNA549880	10695	251	0.865169	2.17157419	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	79.3	1.98e-15	NR	HZQ55008.1	2212468	g10602	i0	46.6	1.05179282868526	88	40	98	2	4	249	69	155	HZQ55008.1 YfdX family protein [Bryobacteraceae bacterium]	diamond	264	79.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;