metadata: contig_metadata: 14 rows where bioproject = "PRJNA407368", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJNA407368", 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
4242217	4242217	PRJNA407368_S_NODE_5764_length_225_cov_180.714286_g5662_i0	PRJNA407368	5764	225	180.714286	406.6071435	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	195	3.14e-45	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g5662	i0	84.314	470.493333333333	204	27	90	4	1	202	317764	317564	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	105861	195	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
16992529	16992529	PRJNA407368_S_NODE_10454_length_152_cov_2.040650_g10352_i0	PRJNA407368	10454	152	2.04065	3.101788	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	97.1	5.66e-16	NTclustered	gi\|2874254056\|emb\|OY970380.1\|	2651171	g10352	i0	88.608	23.3815789473684	79	9	52	0	1	79	3682076	3682154	MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1	blastn	3554	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
16992606	16992606	PRJNA407368_S_NODE_3674_length_305_cov_5.923913_g3572_i0	PRJNA407368	3674	305	5.923913	18.06793465	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	224	5.69e-54	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g3572	i0	83.265	110.84918032786901	245	39	80	2	29	273	4232471	4232229	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	33809	224	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
26854199	26854199	PRJNA407368_S_NODE_4561_length_266_cov_2.502110_g4459_i0	PRJNA407368	4561	266	2.50211	6.6556126	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	66.6	1.97e-11	NR	HZL93589.1	2910147	g4459	i0	55.6	0.609022556390977	54	22	58.6	1	91	246	69	122	HZL93589.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	162	66.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
27597843	27597843	PRJNA407368_S_NODE_6664_length_205_cov_2.681818_g6562_i0	PRJNA407368	6664	205	2.681818	5.4977269	Pseudomonadati	3379134	Bacteria	Bacteria	50.4	2.73e-5	NR	MBK8467834.1	2099375	g6562	i0	47.1	2.4	51	27	74.6	0	155	3	82	132	MBK8467834.1 hypothetical protein [Chloracidobacterium sp.]	diamond	492	50.8	0.992125984251969	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp.
28149418	28149418	PRJNA407368_S_NODE_2185_length_415_cov_6.020725_g2084_i0	PRJNA407368	2185	415	6.020725	24.98600875	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	135	2.85e-38	NR	MEO5926476.1	2212468	g2084	i0	89	0.527710843373494	73	7	52	1	200	415	1	73	MEO5926476.1 DUF6152 family protein [Bryobacteraceae bacterium]	diamond	219	135	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29538471	29538471	PRJNA407368_S_NODE_6970_length_199_cov_2.511765_g6868_i0	PRJNA407368	6970	199	2.511765	4.99841235	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	66.6	7.86e-11	NR	HEX8636432.1	2283092	g6868	i0	48.4	0.964824120603015	64	33	96.5	0	192	1	181	244	HEX8636432.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	192	66.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29632888	29632888	PRJNA407368_S_NODE_4850_length_254_cov_4.128889_g4748_i0	PRJNA407368	4850	254	4.128889	10.48737806	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	65.9	4.95e-11	NR	HZS57567.1	2212468	g4748	i0	59.2	0.578740157480315	49	17	54.3	1	149	12	101	149	HZS57567.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	147	65.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29980714	29980714	PRJNA407368_S_NODE_10191_length_154_cov_2.856000_g10089_i0	PRJNA407368	10191	154	2.856	4.39824	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	66.2	5.69e-11	NR	NBO65198.1	1978231	g10089	i0	64	0.974025974025974	50	14	89.6	1	17	154	331	380	NBO65198.1 hypothetical protein [Acidobacteriota bacterium]	diamond	150	66.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30423354	30423354	PRJNA407368_S_NODE_6273_length_214_cov_2.318919_g6171_i0	PRJNA407368	6273	214	2.318919	4.96248666	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	81.6	4.19e-16	NR	NBO66810.1	1978231	g6171	i0	52.1	0.995327102803738	71	34	99.5	0	2	214	263	333	NBO66810.1 hypothetical protein [Acidobacteriota bacterium]	diamond	213	81.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30833738	30833738	PRJNA407368_S_NODE_10234_length_154_cov_2.016000_g10132_i0	PRJNA407368	10234	154	2.016	3.10464	Holophagaceae bacterium	2052165	Bacteria	Bacteria	69.3	3.91e-13	NR	MBK8726054.1	2052165	g10132	i0	62	0.974025974025974	50	19	97.4	0	153	4	46	95	MBK8726054.1 DUF4304 domain-containing protein [Holophagaceae bacterium]	diamond	150	69.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae		Holophagaceae bacterium
31655527	31655527	PRJNA407368_S_NODE_297_length_1172_cov_11.095363_g270_i0	PRJNA407368	297	1172	11.095363	130.03765436	Terriglobia bacterium	2081523	Bacteria	Bacteria	53.1	2.13e-5	NR	MBZ5616208.1	2081523	g270	i0	66.7	0.166382252559727	33	11	8.4	0	517	615	1	33	MBZ5616208.1 hypothetical protein [Terriglobia bacterium]	diamond	195	53.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
32478522	32478522	PRJNA407368_S_NODE_4379_length_273_cov_3.889344_g4277_i0	PRJNA407368	4379	273	3.889344	10.61790912	Chloracidobacterium sp.	2099375	Bacteria	Bacteria	45.4	0.00622	NR	MBK9215518.1	2099375	g4277	i0	33.7	2.16483516483516	98	53	98.9	4	271	2	791	884	MBK9215518.1 choice-of-anchor J domain-containing protein [Chloracidobacterium sp.]	diamond	591	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp.
32715765	32715765	PRJNA407368_S_NODE_8260_length_177_cov_10.054054_g8158_i0	PRJNA407368	8260	177	10.054054	17.79567558	Pseudomonadati	3379134	Bacteria	Bacteria	87.4	1.05e-19	NR	HEX8813297.1	1964191	g8158	i0	82	10.9661016949153	50	9	84.7	0	175	26	35	84	HEX8813297.1 AAA family ATPase [Terracidiphilus sp.]	diamond	1941	87.4	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);;