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

11 rows where bioproject = "PRJNA929522", 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
27119427	27119427	PRJNA929522_S_NODE_3262_length_371_cov_0.902685_g3192_i0	PRJNA929522	3262	371	0.902685	3.34896135	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	150	3.14e-44	NR	MDQ7008654.1	1978231	g3192	i0	76.9	0.873315363881402	108	24	87.3	1	325	2	1	107	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	324	150	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27150864	27150864	PRJNA929522_S_NODE_3822_length_346_cov_1.102564_g3752_i0	PRJNA929522	3822	346	1.102564	3.81487144	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	142	1.27e-37	NR	MEE9227067.1	1978231	g3752	i0	57.8	1.86416184971098	102	41	88.4	1	307	2	10	109	MEE9227067.1 M20 family metallopeptidase [Acidobacteriota bacterium]	diamond	645	142	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28351326	28351326	PRJNA929522_S_NODE_9446_length_245_cov_0.895349_g9376_i0	PRJNA929522	9446	245	0.895349	2.19360505	Candidatus Solibacter sp.	2068625	Bacteria	Bacteria	44.7	0.00487	NR	HTQ86418.1	2068625	g9376	i0	35.2	0.661224489795918	54	35	66.1	0	48	209	66	119	HTQ86418.1 pyridoxamine 5'-phosphate oxidase family protein [Candidatus Solibacter sp.]	diamond	162	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
28446224	28446224	PRJNA929522_S_NODE_10086_length_241_cov_0.916667_g10016_i0	PRJNA929522	10086	241	0.916667	2.20916747	Terriglobia bacterium	2081523	Bacteria	Bacteria	43.9	0.0112	NR	HET9129506.1	2081523	g10016	i0	35.7	1.73029045643154	70	43	84.6	2	12	215	132	201	HET9129506.1 hypothetical protein [Terriglobia bacterium]	diamond	417	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
29361782	29361782	PRJNA929522_S_NODE_3429_length_362_cov_2.134948_g3359_i0	PRJNA929522	3429	362	2.134948	7.72851176	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	43.9	0.0467	NR	PYR07052.1	1978231	g3359	i0	42.2	0.530386740331492	64	29	46.4	1	135	302	2	65	PYR07052.1 MAG: hypothetical protein DMG00_17455 [Acidobacteriota bacterium]	diamond	192	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29400397	29400397	PRJNA929522_S_NODE_709_length_747_cov_2.271513_g652_i0	PRJNA929522	709	747	2.271513	16.96820211	Bacteria	2	Bacteria	Bacteria	224	3.91e-65	NR	MBK8315251.1	1978231	g652	i0	47.6	10.2048192771084	254	124	99.2	5	747	7	203	454	MBK8315251.1 S8 family serine peptidase [Acidobacteriota bacterium]	diamond	7623	226	0.991150442477876	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30498852	30498852	PRJNA929522_S_NODE_5933_length_290_cov_1.576037_g5863_i0	PRJNA929522	5933	290	1.576037	4.5705073	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	47	0.00215	NR	HEV8242281.1	2651171	g5863	i0	44.8	1.31379310344828	58	18	45.5	2	28	159	310	367	HEV8242281.1 serine/threonine-protein kinase [Thermoanaerobaculia bacterium]	diamond	381	47	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30656760	30656760	PRJNA929522_S_NODE_813_length_697_cov_3.887821_g752_i0	PRJNA929522	813	697	3.887821	27.09811237	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	53.1	4.86e-4	NR	HYB96876.1	2910147	g752	i0	28.6	0.54232424677188	126	84	53.4	3	501	130	1201	1322	HYB96876.1 Ig-like domain-containing protein [Vicinamibacterales bacterium]	diamond	378	53.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31517442	31517442	PRJNA929522_S_NODE_16_length_3626_cov_5.383901_g9_i0	PRJNA929522	16	3626	5.383901	195.22025026	root	1	Root_unresolved	Root_unresolved	50.8	6.23e-4	NR	MBW8878616.1	1978231	g9	i0	38.3	0.158852730281302	60	37	5	0	3589	3410	12	71	MBW8878616.1 hypothetical protein [Acidobacteriota bacterium]	diamond	576	50.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31865038	31865038	PRJNA929522_S_NODE_4877_length_313_cov_2.066667_g4807_i0	PRJNA929522	4877	313	2.066667	6.46866771	Bacteria	2	Bacteria	Bacteria	43.9	0.0293	NR	MEQ1646910.1	2283092	g4807	i0	33.3	2.60702875399361	84	52	79.6	3	286	38	63	143	MEQ1646910.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	816	44.3	0.99097065462754	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32498278	32498278	PRJNA929522_S_NODE_9559_length_244_cov_1.450292_g9489_i0	PRJNA929522	9559	244	1.450292	3.53871248	Candidatus Acidiferrum	2817524	Bacteria	Bacteria	62.8	3.24e-9	NR	MDE3159708.1	1978231	g9489	i0	36.5	1.81967213114754	74	47	91	0	13	234	116	189	MDE3159708.1 amino acid permease [Acidobacteriota bacterium]	diamond	444	62.8	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);;