metadata: contig_metadata: 24 rows where bioproject = "PRJNA1148190", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Zambryskiibacteriota"

24 rows where bioproject = "PRJNA1148190", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Zambryskiibacteriota"

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_clade	tax_phylum	tax_species
7945802	7945802	PRJNA1148190_P_NODE_238627_length_350_cov_1.090253_g227457_i0	PRJNA1148190	238627	350	1.090253	3.8158855	Bacteria	2	Bacteria	Bacteria	90.1	3.22e-18	NR	OHB09766.1	1802772	g227457	i0	40	4.52571428571429	135	59	98.6	4	349	5	23	155	OHB09766.1 MAG: hypothetical protein A3H60_01650 [Candidatus Zambryskibacteria bacterium RIFCSPLOWO2_02_FULL_44_12b]	diamond	1584	90.9	0.991199119911991	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPLOWO2_02_FULL_44_12b
17613814	17613814	PRJNA1148190_P_NODE_685114_length_246_cov_0.890173_g673941_i0	PRJNA1148190	685114	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	132	1.58e-36	NR	MCX6703392.1	2053652	g673941	i0	80.2	1.97560975609756	81	16	98.8	0	245	3	10	90	MCX6703392.1 ABC transporter ATP-binding protein [Candidatus Zambryskiibacteriota bacterium]	diamond	486	132	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
27450536	27450536	PRJNA1148190_P_NODE_379083_length_290_cov_1.907834_g367910_i0	PRJNA1148190	379083	290	1.907834	5.5327186	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	67.8	1.01e-10	NR	OHA93056.1	1802742	g367910	i0	32.3	0.993103448275862	96	64	99.3	1	1	288	49	143	OHA93056.1 MAG: hypothetical protein A2W58_02080 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_38_10.5]	diamond	288	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_38_10.5
27608508	27608508	PRJNA1148190_P_NODE_481884_length_270_cov_1.431472_g470711_i0	PRJNA1148190	481884	270	1.431472	3.8649744	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	73.6	8.85e-14	NR	OHA89341.1	1802734	g470711	i0	66	0.555555555555556	50	17	55.6	0	1	150	142	191	OHA89341.1 MAG: hypothetical protein A2653_01465 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_43_25]	diamond	150	73.6	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_43_25
27765754	27765754	PRJNA1148190_P_NODE_100104_length_534_cov_2.201735_g88948_i0	PRJNA1148190	100104	534	2.201735	11.7572649	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	48.1	6.72e-4	NR	OHA90570.1	1802737	g88948	i0	41.2	0.47752808988764	85	34	45.5	4	259	17	3	75	OHA90570.1 MAG: hypothetical protein A2832_01075 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_44_22b]	diamond	255	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_44_22b
28165163	28165163	PRJNA1148190_P_NODE_727265_length_244_cov_0.900585_g716092_i0	PRJNA1148190	727265	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	137	1.44e-35	NR	MCX6703581.1	2053652	g716092	i0	82.5	2.95081967213115	80	14	98.4	0	1	240	788	867	MCX6703581.1 hypothetical protein [Candidatus Zambryskiibacteriota bacterium]	diamond	720	137	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
28228019	28228019	PRJNA1148190_P_NODE_793466_length_239_cov_2.144578_g782293_i0	PRJNA1148190	793466	239	2.144578	5.12554142	Bacteria	2	Bacteria	Bacteria	163	4.91e-46	NR	OHB14551.1	1802779	g782293	i0	94.9	23.7991631799163	79	4	99.2	0	237	1	188	266	OHB14551.1 MAG: lysine--tRNA ligase [Candidatus Zambryskibacteria bacterium RIFOXYC1_FULL_39_10]	diamond	5688	164	0.99390243902439	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFOXYC1_FULL_39_10
28386123	28386123	PRJNA1148190_P_NODE_795986_length_236_cov_2.656442_g784813_i0	PRJNA1148190	795986	236	2.656442	6.26920312	Bacteria	2	Bacteria	Bacteria	130	2.27e-34	NR	OHB15275.1	1802780	g784813	i0	74.4	4.95762711864407	78	20	99.2	0	234	1	94	171	OHB15275.1 MAG: hypothetical protein A2605_03090 [Candidatus Zambryskibacteria bacterium RIFOXYD1_FULL_39_35]	diamond	1170	131	0.99236641221374	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFOXYD1_FULL_39_35
28492979	28492979	PRJNA1148190_P_NODE_739367_length_243_cov_0.905882_g728194_i0	PRJNA1148190	739367	243	0.905882	2.20129326	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	47.4	8.03e-4	NR	MCX6703337.1	2053652	g728194	i0	65.6	0.395061728395062	32	11	39.5	0	113	18	1	32	MCX6703337.1 MYG1 family protein [Candidatus Zambryskiibacteriota bacterium]	diamond	96	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
28712869	28712869	PRJNA1148190_P_NODE_107107_length_514_cov_1.571429_g95949_i0	PRJNA1148190	107107	514	1.571429	8.07714506	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	178	1.86e-53	NR	OHA92582.1	1802739	g95949	i0	56.8	1.69844357976654	146	59	82.9	1	79	504	2	147	OHA92582.1 MAG: hypothetical protein A2665_02105 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30]	diamond	873	178	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_46_30
29017944	29017944	PRJNA1148190_P_NODE_726728_length_244_cov_0.900585_g715555_i0	PRJNA1148190	726728	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	135	1.93e-36	NR	OHA88706.1	1802734	g715555	i0	79	2.98770491803279	81	17	99.6	0	2	244	100	180	OHA88706.1 MAG: type IV pili twitching motility protein PilT [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_43_25]	diamond	729	136	0.992647058823529	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_43_25
29312741	29312741	PRJNA1148190_P_NODE_131269_length_460_cov_0.994832_g120106_i0	PRJNA1148190	131269	460	0.994832	4.5762272	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	246	2.81e-75	NR	MSR87597.1	2053652	g120106	i0	80.4	0.997826086956522	153	30	99.8	0	2	460	450	602	MSR87597.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Candidatus Zambryskiibacteriota bacterium]	diamond	459	246	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
29364984	29364984	PRJNA1148190_P_NODE_648989_length_248_cov_0.880000_g637816_i0	PRJNA1148190	648989	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	144	1.0499999999999998e-37	NR	OHA94697.1	1802744	g637816	i0	84.1	15.8346774193548	82	13	99.2	0	246	1	616	697	OHA94697.1 MAG: DNA polymerase III subunit alpha [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_FULL_38_22]	diamond	3927	144	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_02_FULL_38_22
29566016	29566016	PRJNA1148190_P_NODE_554750_length_256_cov_1.409836_g543577_i0	PRJNA1148190	554750	256	1.409836	3.60918016	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	58.5	2.65e-8	NR	MCX6703129.1	2053652	g543577	i0	50.9	0.66796875	57	28	66.8	0	86	256	1	57	MCX6703129.1 hypothetical protein [Candidatus Zambryskiibacteriota bacterium]	diamond	171	58.5	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
29818822	29818822	PRJNA1148190_P_NODE_743291_length_243_cov_0.905882_g732118_i0	PRJNA1148190	743291	243	0.905882	2.20129326	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	149	1.31e-43	NR	MSR87649.1	2053652	g732118	i0	85	1.97530864197531	80	12	98.8	0	2	241	13	92	MSR87649.1 site-2 protease family protein [Candidatus Zambryskiibacteriota bacterium]	diamond	480	149	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
29913779	29913779	PRJNA1148190_P_NODE_647551_length_248_cov_0.880000_g636378_i0	PRJNA1148190	647551	248	0.88	2.1824	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	51.6	7.89e-6	NR	MCX6701867.1	2053652	g636378	i0	41.1	2.74596774193548	56	33	67.7	0	248	81	40	95	MCX6701867.1 hypothetical protein [Candidatus Zambryskiibacteriota bacterium]	diamond	681	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
30356264	30356264	PRJNA1148190_P_NODE_558012_length_255_cov_1.807692_g546839_i0	PRJNA1148190	558012	255	1.807692	4.6096146	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_	2053652	Bacteria	Bacteria	49.7	1.33e-4	NR	OHA87687.1	1802733	g546839	i0	31.8	0.776470588235294	66	45	77.6	0	253	56	209	274	OHA87687.1 MAG: hypothetical protein A2644_02725 [Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_39_63]	diamond	198	49.7	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium RIFCSPHIGHO2_01_FULL_39_63
30798233	30798233	PRJNA1148190_P_NODE_682914_length_246_cov_0.890173_g671741_i0	PRJNA1148190	682914	246	0.890173	2.18982558	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	67	1.37e-12	NR	MSU45233.1	2053652	g671741	i0	66.7	0.585365853658537	48	16	58.5	0	158	15	22	69	MSU45233.1 hypothetical protein [Candidatus Zambryskiibacteriota bacterium]	diamond	144	67	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
31177250	31177250	PRJNA1148190_P_NODE_710275_length_245_cov_0.895349_g699102_i0	PRJNA1148190	710275	245	0.895349	2.19360505	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	105	1.96e-26	NR	MBI1974277.1	2053652	g699102	i0	57	0.96734693877551	79	34	96.7	0	6	242	40	118	MBI1974277.1 glycosyltransferase [Candidatus Zambryskiibacteriota bacterium]	diamond	237	105	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
31493758	31493758	PRJNA1148190_P_NODE_610776_length_250_cov_0.870056_g599603_i0	PRJNA1148190	610776	250	0.870056	2.17514	Candidatus Zambryskibacteria bacterium CG11_big_fil_rev_8_21_14_	2053652	Bacteria	Bacteria	94	3.32e-20	NR	PIQ66665.1	1975117	g599603	i0	52.4	3.936	82	39	98.4	0	3	248	85	166	PIQ66665.1 MAG: magnesium chelatase [Candidatus Zambryskibacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_18]	diamond	984	94	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium CG11_big_fil_rev_8_21_14_0_20_42_18
32114521	32114521	PRJNA1148190_P_NODE_602818_length_250_cov_0.870056_g591645_i0	PRJNA1148190	602818	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	108	9.1e-27	NR	PJA34149.1	1975111	g591645	i0	55.6	1.944	81	36	97.2	0	2	244	197	277	PJA34149.1 MAG: hypothetical protein CO184_00580, partial [Candidatus Zambryskibacteria bacterium CG_4_9_14_3_um_filter_40_16]	diamond	486	108	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium CG_4_9_14_3_um_filter_40_16
32220917	32220917	PRJNA1148190_P_NODE_416638_length_283_cov_1.285714_g405465_i0	PRJNA1148190	416638	283	1.285714	3.63857062	Candidatus Zambryskibacteria bacterium CG1	2053652	Bacteria	Bacteria	131	3.5999999999999997e-33	NR	PIR37940.1	1975115	g405465	i0	72.3	0.996466431095406	94	26	99.6	0	283	2	168	261	PIR37940.1 MAG: hypothetical protein COV34_02525 [Candidatus Zambryskibacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_12]	diamond	282	131	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskibacteria bacterium CG10_big_fil_rev_8_21_14_0_10_42_12
32820547	32820547	PRJNA1148190_P_NODE_269200_length_334_cov_0.885057_g258029_i0	PRJNA1148190	269200	334	0.885057	2.95609038	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	182	8.579999999999999e-57	NR	MBI1974685.1	2053652	g258029	i0	76.4	0.988023952095808	110	26	98.8	0	1	330	32	141	MBI1974685.1 HIT family protein [Candidatus Zambryskiibacteriota bacterium]	diamond	330	182	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota bacterium
32820867	32820867	PRJNA1148190_P_NODE_45060_length_921_cov_2.148585_g34432_i0	PRJNA1148190	45060	921	2.148585	19.78846785	Candidatus Zambryskiibacteriota bacterium	2053652	Bacteria	Bacteria	166	1.09e-46	NR	MBI4155668.1	2053652	g34432	i0	52.1	0.530944625407166	163	78	53.1	0	916	428	21	183	MBI4155668.1 NAD(P)H-dependent oxidoreductase [Candidatus Zambryskiibacteriota bacterium]	diamond	489	166	1	Bacteria	Bacteria candidate phyla	Candidatus Zambryskiibacteriota	Candidatus Zambryskiibacteriota 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);;