metadata: contig_metadata: 20 rows where bioproject = "PRJEB64798" and tax

20 rows where bioproject = "PRJEB64798" and tax_phylum = "Candidatus Uhriibacteriota"

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
126722	126722	PRJEB64798_P_NODE_126441_length_200_cov_6.900662_g124675_i0	PRJEB64798	126441	200	6.900662	13.801324	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	113	7.860000000000001e-21	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g124675	i0	86.538	131.385	104	12	52	2	43	145	768077	767975	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	26277	113	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
1403840	1403840	PRJEB64798_P_NODE_61442_length_248_cov_5.562814_g59677_i0	PRJEB64798	61442	248	5.562814	13.79577872	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	292	1.21e-74	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g59677	i0	87.952	152.987903225806	249	28	100	2	1	248	1079470	1079223	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	37941	292	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
1404276	1404276	PRJEB64798_P_NODE_85882_length_213_cov_2.756098_g84116_i0	PRJEB64798	85882	213	2.756098	5.87048874	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	141	3.89e-29	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g84116	i0	88.889	4.46009389671362	117	9	54	4	99	213	1077078	1077192	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	950	141	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
5231753	5231753	PRJEB64798_P_NODE_56245_length_260_cov_4.753555_g54480_i0	PRJEB64798	56245	260	4.753555	12.359243	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	156	1.76e-33	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g54480	i0	87.591	2.18076923076923	137	14	52	3	38	173	1078029	1078163	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	567	156	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
9054264	9054264	PRJEB64798_P_NODE_142548_length_192_cov_3.629371_g140782_i0	PRJEB64798	142548	192	3.629371	6.96839232	Candidatus Uhrbacteria bacterium GW2011_GWC1_41_20	1618983	Bacteria	Bacteria	270	4.19e-68	NTclustered	gi\|1118703665\|gb\|KX123578.1\|	1618983	g140782	i0	94.798	94.0625	173	9	90	0	15	187	1199	1027	Candidatus Uhrbacteria bacterium GW2011_GWC1_41_20 16S ribosomal RNA gene, partial sequence	blastn	18060	270	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium GW2011_GWC1_41_20
9054903	9054903	PRJEB64798_P_NODE_185428_length_172_cov_3.422764_g183662_i0	PRJEB64798	185428	172	3.422764	5.88715408	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	141	2.99e-29	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g183662	i0	82.353	425.75	170	22	97	6	2	167	1078548	1078383	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	73229	141	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
9055958	9055958	PRJEB64798_P_NODE_30128_length_358_cov_584.071197_g28372_i0	PRJEB64798	30128	358	584.071197	2090.97488526	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	429	1.34e-115	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g28372	i0	88.366	259.564245810056	361	36	99	6	1	357	766685	766327	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	92924	429	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
10330033	10330033	PRJEB64798_P_NODE_140449_length_193_cov_4.409722_g138683_i0	PRJEB64798	140449	193	4.409722	8.51076346	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	243	9.2e-60	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g138683	i0	92.814	8.04145077720207	167	12	87	0	21	187	765646	765812	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	1552	243	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
10330350	10330350	PRJEB64798_P_NODE_159889_length_183_cov_7.350746_g158123_i0	PRJEB64798	159889	183	7.350746	13.45186518	Candidatus Uhrbacteria bacterium GW2011_GWA2_53_10	1618980	Bacteria	Bacteria	254	3.98e-63	NTclustered	gi\|1118703626\|gb\|KX123539.1\|	1618980	g158123	i0	94.048	91.8524590163934	168	9	91	1	10	176	1393	1226	Candidatus Uhrbacteria bacterium GW2011_GWA2_53_10 16S ribosomal RNA gene, partial sequence	blastn	16809	254	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium GW2011_GWA2_53_10
11608386	11608386	PRJEB64798_P_NODE_95430_length_212_cov_4.202454_g93664_i0	PRJEB64798	95430	212	4.202454	8.90920248	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	219	1.74e-52	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g93664	i0	86.634	90.0896226415094	202	22	94	5	6	204	1077476	1077277	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	19099	219	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
14157006	14157006	PRJEB64798_P_NODE_25372_length_390_cov_449.439883_g23623_i0	PRJEB64798	25372	390	449.439883	1752.8155437	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	296	1.56e-75	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g23623	i0	81.818	249.858974358974	374	49	93	16	1	361	766331	766698	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	97445	296	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
15021153	15021153	PRJEB64798_P_NODE_223092_length_161_cov_5.821429_g221326_i0	PRJEB64798	223092	161	5.821429	9.37250069	Bacteria	2	Bacteria	Bacteria	86.1	1.32e-12	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g221326	i0	93.103	27.1242236024845	58	4	36	0	4	61	766637	766694	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	4367	86.1	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
15429312	15429312	PRJEB64798_P_NODE_136873_length_195_cov_3.232877_g135107_i0	PRJEB64798	136873	195	3.232877	6.30411015	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	167	5.7699999999999995e-37	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g135107	i0	82.564	3.46153846153846	195	29	98	5	2	193	765893	765701	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	675	167	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
16704295	16704295	PRJEB64798_P_NODE_182614_length_173_cov_4.354839_g180848_i0	PRJEB64798	182614	173	4.354839	7.53387147	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	206	1.05e-48	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g180848	i0	94.074	2.73410404624277	135	8	98	0	1	135	767991	767857	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	473	206	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
20528319	20528319	PRJEB64798_P_NODE_168917_length_179_cov_3.938462_g167151_i0	PRJEB64798	168917	179	3.938462	7.04984698	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	165	1.87e-36	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g167151	i0	84	3.53631284916201	175	24	97	4	2	174	1079115	1078943	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	633	165	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
23079752	23079752	PRJEB64798_P_NODE_19419_length_452_cov_18.436725_g17692_i0	PRJEB64798	19419	452	18.436725	83.333997	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	374	8.229999999999997e-99	NTclustered	gi\|2874254032\|emb\|OY970357.1\|	2053634	g17692	i0	82.511	167.079646017699	446	59	96	17	1	435	1078132	1077695	MAG: Candidatus Uhrbacteria bacterium isolate MFD02416.bin.c.4 genome assembly, chromosome: 1	blastn	75520	374	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
24352564	24352564	PRJEB64798_P_NODE_126600_length_200_cov_4.874172_g124834_i0	PRJEB64798	126600	200	4.874172	9.748344	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	206	1.26e-48	NTclustered	gi\|1958012472\|gb\|CP064964.1\|	2053634	g124834	i0	85.294	248.425	204	24	100	5	1	200	767685	767484	MAG: Candidatus Uhrbacteria bacterium isolate Bjer_18-Q3-R1-45_BAT3C.201_fly chromosome, complete genome	blastn	49685	206	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
30437849	30437849	PRJEB64798_P_NODE_117213_length_208_cov_2.597484_g115447_i0	PRJEB64798	117213	208	2.597484	5.40276672	Bacteria	2	Bacteria	Bacteria	64.7	4.27e-10	NR	KKW28948.1	1618989	g115447	i0	87.5	3.69230769230769	32	4	46.2	0	113	208	42	73	KKW28948.1 MAG: alanyl-tRNA synthetase [Candidatus Uhrbacteria bacterium GW2011_GWD2_52_7]	diamond	768	65.1	0.993855606758833	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium GW2011_GWD2_52_7
30507660	30507660	PRJEB64798_P_NODE_127893_length_199_cov_5.320000_g126127_i0	PRJEB64798	127893	199	5.32	10.5868	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	48.1	9.76e-5	NR	MFH1252790.1	2053634	g126127	i0	50	1.04020100502513	34	17	51.3	0	1	102	78	111	MFH1252790.1 NUDIX domain-containing protein [Candidatus Uhrbacteria bacterium]	diamond	207	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria bacterium
32657270	32657270	PRJEB64798_P_NODE_227300_length_160_cov_2.036036_g225534_i0	PRJEB64798	227300	160	2.036036	3.2576576	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	52.4	4.37e-7	NR	MEI7512618.1	2053634	g225534	i0	48.8	1.5375	41	21	76.9	0	2	124	2	42	MEI7512618.1 RNA-binding protein [Candidatus Uhrbacteria bacterium]	diamond	246	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota	Candidatus Uhrbacteria 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);;