metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA917598" and tax_clade = "Bacteria candidate phyla"

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_class	tax_species
895553	895553	PRJNA917598_P_NODE_25861_length_454_cov_50.648294_g24917_i0	PRJNA917598	25861	454	50.648294	229.94325476	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	331	5.05e-86	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g24917	i0	83.155	6.24008810572687	374	51	81	11	10	375	308708	308339	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	2833	331	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
895558	895558	PRJNA917598_P_NODE_25961_length_453_cov_295.568421_g25017_i0	PRJNA917598	25961	453	295.568421	1338.92494713	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	113	1.99e-20	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g25017	i0	82.222	0.298013245033113	135	20	30	2	33	166	938528	938659	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	135	113	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
896637	896637	PRJNA917598_P_NODE_68081_length_276_cov_1.226601_g67137_i0	PRJNA917598	68081	276	1.226601	3.38541876	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	444	3.58e-120	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g67137	i0	95.668	203.5	277	11	100	1	1	276	964036	964312	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	56166	444	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
2171422	2171422	PRJNA917598_P_NODE_42162_length_353_cov_17.221429_g41218_i0	PRJNA917598	42162	353	17.221429	60.79164437	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	243	1.8500000000000002e-59	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g41218	i0	82.437	1.59773371104816	279	47	79	2	1	278	523016	522739	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	564	243	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
2171911	2171911	PRJNA917598_P_NODE_62_length_7680_cov_5.048639_g49_i0	PRJNA917598	62	7680	5.048639	387.7354752	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	1982	0	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g49	i0	76.228	8.23619791666667	3929	826	93	89	150	4024	883440	887314	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	63254	1982	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
3446361	3446361	PRJNA917598_P_NODE_2123_length_1728_cov_4.879758_g1741_i0	PRJNA917598	2123	1728	4.879758	84.32221824	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	660	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g1741	i0	76.955	20.0665509259259	1202	249	69	28	88	1275	46264	45077	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	34675	660	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
3447138	3447138	PRJNA917598_P_NODE_51783_length_318_cov_1.257143_g50839_i0	PRJNA917598	51783	318	1.257143	3.99771474	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	115	3.75e-21	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g50839	i0	81.752	0.430817610062893	137	25	43	0	172	308	921879	921743	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	137	115	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
7275292	7275292	PRJNA917598_P_NODE_86_length_6743_cov_9.504648_g65_i0	PRJNA917598	86	6743	9.504648	640.89841464	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1236	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g65	i0	81.433	14.4813881061842	1535	263	23	16	4059	5583	676385	677907	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	97648	1236	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
8548231	8548231	PRJNA917598_P_NODE_12867_length_659_cov_2.848123_g11940_i0	PRJNA917598	12867	659	2.848123	18.76913057	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	470	1.53e-127	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g11940	i0	79.784	0.983308042488619	648	129	98	2	12	658	1202326	1201680	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	648	470	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
8549186	8549186	PRJNA917598_P_NODE_51267_length_320_cov_0.935223_g50323_i0	PRJNA917598	51267	320	0.935223	2.9927136	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	137	8.05e-28	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g50323	i0	75.704	1.0625	284	63	88	6	16	296	706509	706789	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	340	137	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
9823272	9823272	PRJNA917598_P_NODE_1708_length_1927_cov_59.825782_g1382_i0	PRJNA917598	1708	1927	59.825782	1152.84281914	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1208	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g1382	i0	84.006	58.3352361183186	1288	174	66	23	651	1918	466044	464769	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	112412	1208	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
9823574	9823574	PRJNA917598_P_NODE_29988_length_420_cov_1.772334_g29044_i0	PRJNA917598	29988	420	1.772334	7.4438028	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	117	1.41e-21	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g29044	i0	90.909	5.35	88	6	20	2	254	339	443355	443268	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	2247	117	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
9823956	9823956	PRJNA917598_P_NODE_448_length_3621_cov_39.557779_g354_i0	PRJNA917598	448	3621	39.557779	1432.38717759	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	826	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g354	i0	80.052	4.27782380557857	1143	205	31	21	2223	3355	798804	797675	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	15490	826	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
9824023	9824023	PRJNA917598_P_NODE_4748_length_1132_cov_37.713881_g4081_i0	PRJNA917598	4748	1132	37.713881	426.92113292	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	316	3.7e-81	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g4081	i0	75.61	13.1757950530035	697	138	60	25	53	733	1294764	1294084	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	14915	316	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
11099233	11099233	PRJNA917598_P_NODE_3089_length_1426_cov_3.756098_g2558_i0	PRJNA917598	3089	1426	3.756098	53.56195748	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	857	0	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g2558	i0	80.363	13.4502103786816	1156	205	80	17	281	1425	1126809	1127953	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	19180	857	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
11100544	11100544	PRJNA917598_P_NODE_83869_length_248_cov_2.577143_g82925_i0	PRJNA917598	83869	248	2.577143	6.39131464	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	124	4.6899999999999996e-24	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g82925	i0	94.937	4.9758064516129	79	4	61	0	170	248	704055	703977	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	1234	124	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
12374785	12374785	PRJNA917598_P_NODE_26950_length_444_cov_24.897574_g26006_i0	PRJNA917598	26950	444	24.897574	110.54522856	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	219	4e-52	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g26006	i0	78.426	0.837837837837838	343	68	77	6	15	354	70367	70028	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	372	219	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
12375061	12375061	PRJNA917598_P_NODE_3830_length_1265_cov_2.104866_g3235_i0	PRJNA917598	3830	1265	2.104866	26.6265549	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	279	5.45e-70	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g3235	i0	71.452	0.980237154150198	1240	301	96	45	47	1264	183872	182664	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	1240	279	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
13650583	13650583	PRJNA917598_P_NODE_8031_length_846_cov_2.915912_g7202_i0	PRJNA917598	8031	846	2.915912	24.66861552	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	617	6.699999999999999e-172	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g7202	i0	80.665	55.2186761229314	812	143	95	11	18	822	126282	125478	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	46715	617	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium RAAC1_SR1_1
17473714	17473714	PRJNA917598_P_NODE_22594_length_488_cov_1.484337_g21652_i0	PRJNA917598	22594	488	1.484337	7.24356456	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	243	2.63e-59	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g21652	i0	75.967	1.30327868852459	491	106	99	9	3	487	759675	759191	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	636	243	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
20021977	20021977	PRJNA917598_P_NODE_136_length_5713_cov_56.568617_g107_i0	PRJNA917598	136	5713	56.568617	3231.76508921	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1616	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g107	i0	74.917	4.45072641344303	3895	800	67	127	1329	5181	615280	611521	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	25427	1616	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
20022512	20022512	PRJNA917598_P_NODE_34616_length_390_cov_1.943218_g33672_i0	PRJNA917598	34616	390	1.943218	7.5785502	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	145	5.98e-30	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g33672	i0	83.019	1.71538461538462	159	27	41	0	56	214	1256508	1256666	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	669	145	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
20022569	20022569	PRJNA917598_P_NODE_36_length_8899_cov_55.450600_g25_i0	PRJNA917598	36	8899	55.4506	4934.548894	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	1646	0	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g25	i0	76.242	1.5863580177548	3321	663	37	101	2075	5323	861545	858279	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	14117	1646	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
21297342	21297342	PRJNA917598_P_NODE_16017_length_586_cov_15.937622_g15083_i0	PRJNA917598	16017	586	15.937622	93.39446492	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	126	3.36e-24	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g15083	i0	94.048	7.06825938566553	84	4	14	1	20	102	306602	306685	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	4142	126	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
21297551	21297551	PRJNA917598_P_NODE_23737_length_475_cov_2.457711_g22795_i0	PRJNA917598	23737	475	2.457711	11.67412725	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	171	1.22e-37	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g22795	i0	80.408	39.4273684210526	245	31	50	15	121	359	125036	125269	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	18728	171	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium RAAC1_SR1_1
21297557	21297557	PRJNA917598_P_NODE_2397_length_1625_cov_4.304768_g1970_i0	PRJNA917598	2397	1625	4.304768	69.95248	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	658	0	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g1970	i0	78.827	0.619076923076923	1006	191	61	16	10	1007	1195827	1196818	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	1006	658	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
21299260	21299260	PRJNA917598_P_NODE_95017_length_241_cov_1.452381_g94073_i0	PRJNA917598	95017	241	1.452381	3.50023821	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	261	3.31e-65	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g94073	i0	89.1	88.9460580912863	211	21	87	2	32	241	626061	625852	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	21436	261	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
22572370	22572370	PRJNA917598_P_NODE_1338_length_2173_cov_26.462857_g1084_i0	PRJNA917598	1338	2173	26.462857	575.03788261	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	1363	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g1084	i0	78.624	37.2641509433962	2180	379	98	63	17	2148	531143	533283	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	80975	1363	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
22573163	22573163	PRJNA917598_P_NODE_46478_length_336_cov_2.893536_g45534_i0	PRJNA917598	46478	336	2.893536	9.72228096	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	233	1.0499999999999998e-56	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g45534	i0	83.088	104.482142857143	272	30	80	14	17	284	892916	893175	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	35106	233	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
22574038	22574038	PRJNA917598_P_NODE_8278_length_834_cov_4.453351_g7441_i0	PRJNA917598	8278	834	4.453351	37.14094734	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	346	3.44e-90	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g7441	i0	78.947	6.50959232613909	513	104	61	4	315	825	927605	927095	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	5429	346	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
23847794	23847794	PRJNA917598_P_NODE_2219_length_1689_cov_4.232054_g1820_i0	PRJNA917598	2219	1689	4.232054	71.47939206	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	819	0	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g1820	i0	77.587	3.70574304322084	1401	282	82	25	13	1397	437683	439067	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	6259	819	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
25121477	25121477	PRJNA917598_P_NODE_17720_length_556_cov_2.045549_g16785_i0	PRJNA917598	17720	556	2.045549	11.37325244	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	316	1.76e-81	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g16785	i0	85.526	62.8507194244604	304	42	54	2	255	556	126539	126842	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	34945	316	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium RAAC1_SR1_1

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);;