metadata: contig_metadata: 15 rows where bioproject = "PRJNA608894", tax_phylum = "Acidobacteriota" and tax

15 rows where bioproject = "PRJNA608894", 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
3136128	3136128	PRJNA608894_P_NODE_26263_length_368_cov_2.722034_g25766_i0	PRJNA608894	26263	368	2.722034	10.01708512	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	120	2.22e-32	NR	MDQ7008654.1	1978231	g25766	i0	80.5	0.668478260869565	82	15	66.8	1	7	252	31	111	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	246	120	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10789607	10789607	PRJNA608894_P_NODE_33029_length_314_cov_2.684647_g32530_i0	PRJNA608894	33029	314	2.684647	8.42979158	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	342	1.5599999999999997e-89	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g32530	i0	87.584	83.9713375796178	298	34	94	3	19	314	317557	317261	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	26367	342	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15888332	15888332	PRJNA608894_P_NODE_35473_length_303_cov_1.626087_g34974_i0	PRJNA608894	35473	303	1.626087	4.92704361	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	206	2.05e-48	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g34974	i0	80.97	178.376237623762	268	43	87	8	39	303	1699525	1699263	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	54048	206	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26668356	26668356	PRJNA608894_P_NODE_55801_length_245_cov_0.895349_g55302_i0	PRJNA608894	55801	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	70.5	1.71e-13	NR	MDQ7008653.1	1978231	g55302	i0	77.1	0.587755102040816	48	11	58.8	0	144	1	16	63	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	144	70.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27301462	27301462	PRJNA608894_P_NODE_60703_length_239_cov_2.728916_g60204_i0	PRJNA608894	60703	239	2.728916	6.52210924	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	60.8	9.45e-10	NR	MDQ7008653.1	1978231	g60204	i0	74.4	0.539748953974895	43	11	54	0	109	237	22	64	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	129	60.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27882898	27882898	PRJNA608894_P_NODE_22305_length_418_cov_2.295652_g21809_i0	PRJNA608894	22305	418	2.295652	9.59582536	Pseudomonadati	3379134	Bacteria	Bacteria	98.2	1.23e-22	NR	MBK8199413.1	1978231	g21809	i0	58.1	1.38516746411483	93	39	66.7	0	5	283	86	178	MBK8199413.1 carboxymuconolactone decarboxylase family protein [Acidobacteriota bacterium]	diamond	579	98.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27901171	27901171	PRJNA608894_P_NODE_53565_length_247_cov_1.672414_g53066_i0	PRJNA608894	53565	247	1.672414	4.13086258	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	52.8	1.03e-5	NR	MDR1989006.1	2052142	g53066	i0	39.7	0.88663967611336	73	42	86.2	1	215	3	2	74	MDR1989006.1 electron transfer flavoprotein subunit alpha/FixB family protein [Acidobacteriaceae bacterium]	diamond	219	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
28135659	28135659	PRJNA608894_P_NODE_8985_length_867_cov_4.017632_g8558_i0	PRJNA608894	8985	867	4.017632	34.83286944	PVC group	1783257	Bacteria	Bacteria	324	6.13e-108	NR	MDA1312794.1	1978231	g8558	i0	56.8	30.7750865051903	278	116	96.2	1	865	32	8	281	MDA1312794.1 aldolase/citrate lyase family protein [Acidobacteriota bacterium]	diamond	26682	325	0.996923076923077	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29777283	29777283	PRJNA608894_P_NODE_54031_length_247_cov_0.885057_g53532_i0	PRJNA608894	54031	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	2.99e-6	NR	WP_396127306.1	1615681	g53532	i0	43.3	4.7246963562753	60	34	72.9	0	48	227	82	141	WP_396127306.1 glycosyltransferase family 2 protein [Acidicapsa acidisoli]	diamond	1167	54.7	0.992687385740402	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidicapsa	Acidicapsa acidisoli
29953789	29953789	PRJNA608894_P_NODE_54211_length_247_cov_0.885057_g53712_i0	PRJNA608894	54211	247	0.885057	2.18609079	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	85.5	2.64e-17	NR	MCW5959990.1	2283092	g53712	i0	59.8	0.995951417004049	82	32	99.6	1	2	247	280	360	MCW5959990.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	246	85.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30806858	30806858	PRJNA608894_P_NODE_60154_length_241_cov_0.916667_g59655_i0	PRJNA608894	60154	241	0.916667	2.20916747	Terriglobia bacterium	2081523	Bacteria	Bacteria	107	6.76e-26	NR	MBZ5617099.1	2081523	g59655	i0	63.8	0.995850622406639	80	29	99.6	0	1	240	60	139	MBZ5617099.1 IS110 family transposase [Terriglobia bacterium]	diamond	240	107	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
31091182	31091182	PRJNA608894_P_NODE_14215_length_597_cov_2.904580_g13732_i0	PRJNA608894	14215	597	2.90458	17.3403426	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	59.3	1.41e-6	NR	MBS1873370.1	1978231	g13732	i0	33.6	1.33668341708543	125	61	61.3	5	169	534	112	217	MBS1873370.1 hypothetical protein [Acidobacteriota bacterium]	diamond	798	59.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31850090	31850090	PRJNA608894_P_NODE_49297_length_252_cov_2.022346_g48798_i0	PRJNA608894	49297	252	2.022346	5.09631192	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	53.5	6.51e-6	NR	MDR3737288.1	2052142	g48798	i0	42.4	0.702380952380952	59	34	70.2	0	1	177	209	267	MDR3737288.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	177	53.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
31976653	31976653	PRJNA608894_P_NODE_36198_length_299_cov_1.765487_g35699_i0	PRJNA608894	36198	299	1.765487	5.27880613	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	81.3	1.94e-17	NR	MDQ7008653.1	1978231	g35699	i0	81.1	0.531772575250836	53	10	53.2	0	141	299	24	76	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	159	81.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32103241	32103241	PRJNA608894_P_NODE_55898_length_245_cov_0.895349_g55399_i0	PRJNA608894	55898	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	142	2.32e-37	NR	MBL8136695.1	1978231	g55399	i0	86.4	0.991836734693878	81	11	99.2	0	245	3	172	252	MBL8136695.1 TonB-dependent siderophore receptor [Acidobacteriota bacterium]	diamond	243	142	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);;