metadata: contig_metadata: 11 rows where bioproject = "PRJNA1218816", tax_phylum = "Acidobacteriota" and tax

11 rows where bioproject = "PRJNA1218816", 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_species
6711043	6711043	PRJNA1218816_P_NODE_22806_length_448_cov_0.992000_g22373_i0	PRJNA1218816	22806	448	0.992	4.44416	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	728	0	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g22373	i0	95.991	64.4977678571429	449	17	100	1	1	448	4650045	4649597	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	28895	728	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
19459560	19459560	PRJNA1218816_P_NODE_59256_length_245_cov_0.895349_g58823_i0	PRJNA1218816	59256	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g58823	i0	98.367	125.873469387755	245	4	100	0	1	245	4651436	4651680	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	30839	431	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
25272451	25272451	PRJNA1218816_P_NODE_48060_length_271_cov_1.277778_g47627_i0	PRJNA1218816	48060	271	1.277778	3.46277838	Bacteria	2	Bacteria	Bacteria	195	3.9e-45	NTclustered	gi\|217038898\|gb\|EU810988.1\|	171953	g47627	i0	79.927	126.424354243542	274	47	99	6	4	271	485	214	Uncultured Acidobacteria bacterium clone 01QD8 23S ribosomal RNA gene, partial sequence	blastn	34261	196	0.994897959183674	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
27830773	27830773	PRJNA1218816_P_NODE_20004_length_493_cov_1.590476_g19573_i0	PRJNA1218816	20004	493	1.590476	7.84104668	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	52.8	8.91e-5	NR	MBM3769367.1	1978231	g19573	i0	36.4	0.78498985801217	129	72	77.9	6	22	405	65	184	MBM3769367.1 PEP-CTERM sorting domain-containing protein [Acidobacteriota bacterium]	diamond	387	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28304389	28304389	PRJNA1218816_P_NODE_47326_length_274_cov_1.228856_g46893_i0	PRJNA1218816	47326	274	1.228856	3.36706544	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	110	3.13e-28	NR	MBY0503986.1	2212468	g46893	i0	94.7	0.624087591240876	57	3	62.4	0	273	103	141	197	MBY0503986.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	171	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
29680573	29680573	PRJNA1218816_P_NODE_38310_length_314_cov_0.958506_g37877_i0	PRJNA1218816	38310	314	0.958506	3.00970884	Pseudomonadati	3379134	Bacteria	Bacteria	125	1.3199999999999998e-32	NR	MFN0086399.1	2052146	g37877	i0	62.2	7.46178343949045	98	37	93.6	0	20	313	17	114	MFN0086399.1 glycoside hydrolase family 19 protein [Blastocatellia bacterium]	diamond	2343	125	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
29996868	29996868	PRJNA1218816_P_NODE_33851_length_340_cov_1.153558_g33418_i0	PRJNA1218816	33851	340	1.153558	3.9220972	Pseudomonadati	3379134	Bacteria	Bacteria	124	3.9199999999999995e-30	NR	MBS1768271.1	1978231	g33418	i0	56.9	1.92352941176471	109	47	96.2	0	2	328	1203	1311	MBS1768271.1 hypothetical protein [Acidobacteriota bacterium]	diamond	654	124	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30641272	30641272	PRJNA1218816_P_NODE_54653_length_250_cov_0.870056_g54220_i0	PRJNA1218816	54653	250	0.870056	2.17514	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	112	8.680000000000001e-29	NR	HQZ81606.1	2283092	g54220	i0	68.7	1.992	83	25	99.6	1	250	2	17	98	HQZ81606.1 DUF1834 family protein [Pyrinomonadaceae bacterium]	diamond	498	112	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
31336535	31336535	PRJNA1218816_P_NODE_61176_length_243_cov_0.905882_g60743_i0	PRJNA1218816	61176	243	0.905882	2.20129326	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	95.1	4.24e-22	NR	HEY7499194.1	2910147	g60743	i0	63.6	0.950617283950617	77	26	95.1	1	231	1	10	84	HEY7499194.1 class I SAM-dependent methyltransferase [Vicinamibacterales bacterium]	diamond	231	95.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
32557910	32557910	PRJNA1218816_P_NODE_53039_length_253_cov_1.544444_g52606_i0	PRJNA1218816	53039	253	1.544444	3.90744332	Bacteria	2	Bacteria	Bacteria	121	1.05e-29	NR	OFW40429.1	1797193	g52606	i0	84.7	20.00395256917	72	11	85.4	0	247	32	296	367	OFW40429.1 MAG: glycine dehydrogenase (aminomethyl-transferring) [Acidobacteria bacterium RIFCSPLOWO2_12_FULL_67_14b]	diamond	5061	122	0.991803278688525	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteria bacterium RIFCSPLOWO2_12_FULL_67_14b
32715105	32715105	PRJNA1218816_P_NODE_55620_length_249_cov_0.875000_g55187_i0	PRJNA1218816	55620	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	159	6.669999999999998e-47	NR	MCD9189576.1	2283092	g55187	i0	90.1	4.89156626506024	81	8	97.6	0	6	248	147	227	MCD9189576.1 inositol monophosphatase [Pyrinomonadaceae bacterium]	diamond	1218	160	0.99375	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae 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);;