metadata: contig_metadata: 7 rows where bioproject = "PRJEB673", tax_phylum = "Acidobacteriota" and tax

7 rows where bioproject = "PRJEB673", 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
4823365	4823365	PRJEB673_P_NODE_9964_length_183_cov_1.891892_g9615_i0	PRJEB673	9964	183	1.891892	3.46216236	Bacteria	2	Bacteria	Bacteria	322	1.08e-83	NTclustered	gi\|125901405\|gb\|EF417748.1\|	171953	g9615	i0	98.361	92.4699453551913	183	3	100	0	1	183	11	193	Uncultured Acidobacteria bacterium clone LF059 16S ribosomal RNA gene, partial sequence	blastn	16922	322	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21811710	21811710	PRJEB673_P_NODE_6558_length_339_cov_3.118421_g6209_i0	PRJEB673	6558	339	3.118421	10.57144719	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	521	2.0299999999999993e-143	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g6209	i0	94.643	106.563421828909	336	18	100	0	4	339	3558489	3558154	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	36125	521	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
21811718	21811718	PRJEB673_P_NODE_8458_length_273_cov_1.936975_g8109_i0	PRJEB673	8458	273	1.936975	5.28794175	uncultured Holophaga sp.	188475	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g8109	i0	100	0.102564102564103	28	0	10	0	34	61	2435238	2435265	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
23086676	23086676	PRJEB673_P_NODE_1799_length_721_cov_3.465015_g1551_i0	PRJEB673	1799	721	3.465015	24.98275815	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	771	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g1551	i0	86.283	85.0832177531207	729	76	100	18	1	721	3558135	3557423	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	61345	771	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
27223551	27223551	PRJEB673_P_NODE_1483_length_781_cov_5.962466_g1257_i0	PRJEB673	1483	781	5.962466	46.56685946	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	132	4.08e-35	NR	MDQ7008653.1	1978231	g1257	i0	78.9	0.345710627400768	90	19	34.6	0	668	399	22	111	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	270	132	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28076325	28076325	PRJEB673_P_NODE_8905_length_226_cov_1.418848_g8556_i0	PRJEB673	8905	226	1.418848	3.20659648	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	109	1.51e-26	NR	RMG01453.1	1978231	g8556	i0	65.3	2.98672566371681	75	23	99.6	2	1	225	41	112	RMG01453.1 MAG: phosphoenolpyruvate carboxykinase (GTP), partial [Acidobacteriota bacterium]	diamond	675	109	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30539613	30539613	PRJEB673_P_NODE_1793_length_722_cov_8.438137_g1546_i0	PRJEB673	1793	722	8.438137	60.92334914	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	135	1.46e-36	NR	MDQ7008653.1	1978231	g1546	i0	84.9	0.357340720221607	86	13	35.7	0	141	398	24	109	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	258	135	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;