metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA509429" 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
3036372	3036372	PRJNA509429_P_NODE_46923_length_161_cov_1.269841_g46095_i0	PRJNA509429	46923	161	1.269841	2.04444401	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	152	1.28e-32	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g46095	i0	87.786	2.41614906832298	131	15	81	1	32	161	325628	325758	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	389	152	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium Aalborg_AAW-1
6862979	6862979	PRJNA509429_P_NODE_24666_length_260_cov_2.013333_g23838_i0	PRJNA509429	24666	260	2.013333	5.2346658	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	313	9.84e-81	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g23838	i0	91.928	82.9884615384615	223	18	86	0	38	260	127134	127356	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	21577	313	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium RAAC1_SR1_1
8138351	8138351	PRJNA509429_P_NODE_42647_length_173_cov_1.079710_g41819_i0	PRJNA509429	42647	173	1.07971	1.8678983	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	296	6.08e-76	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g41819	i0	97.674	12.6531791907514	172	4	99	0	2	173	494550	494379	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	2189	296	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
8138360	8138360	PRJNA509429_P_NODE_44947_length_166_cov_1.702290_g44119_i0	PRJNA509429	44947	166	1.70229	2.8258014	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	95.3	2.28e-15	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g44119	i0	78.71	19.6506024096386	155	23	91	10	2	152	8460	8608	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	3262	95.3	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
9413372	9413372	PRJNA509429_P_NODE_34288_length_203_cov_1.702381_g33460_i0	PRJNA509429	34288	203	1.702381	3.45583343	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	158	3.6399999999999997e-34	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g33460	i0	82.051	92.8029556650246	195	26	94	8	4	194	813272	813461	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	18839	158	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
10039285	10039285	PRJNA509429_P_NODE_17548_length_329_cov_1.836735_g16720_i0	PRJNA509429	17548	329	1.836735	6.04285815	Bacteria	2	Bacteria	Bacteria	442	1.5699999999999994e-119	NTclustered	gi\|1118703733\|gb\|KX123646.1\|	1618923	g16720	i0	91.131	97.2401215805471	327	27	99	2	1	326	234	559	Parcubacteria group bacterium GW2011_GWC2_40_10 16S ribosomal RNA gene, partial sequence	blastn	31992	442	1	Bacteria	Bacteria candidate phyla			Parcubacteria group bacterium GW2011_GWC2_40_10
11963927	11963927	PRJNA509429_P_NODE_15410_length_358_cov_2.195046_g14583_i0	PRJNA509429	15410	358	2.195046	7.85826468	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	302	3.05e-77	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g14583	i0	83.537	2.74022346368715	328	48	91	6	1	325	326568	326892	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	981	302	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium Aalborg_AAW-1
11964043	11964043	PRJNA509429_P_NODE_49170_length_156_cov_0.892562_g48342_i0	PRJNA509429	49170	156	0.892562	1.39239672	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	255	9.12e-64	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g48342	i0	96.154	65.6282051282051	156	6	100	0	1	156	906518	906673	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	10238	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		TM7 phylum sp. oral taxon 349
11964052	11964052	PRJNA509429_P_NODE_51370_length_151_cov_1.284483_g50542_i0	PRJNA509429	51370	151	1.284483	1.93956933	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	198	1.5e-46	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g50542	i0	92.199	31.7350993377483	141	9	93	2	12	151	441587	441726	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	4792	198	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
12589727	12589727	PRJNA509429_P_NODE_43230_length_171_cov_1.617647_g42402_i0	PRJNA509429	43230	171	1.617647	2.76617637	Bacteria	2	Bacteria	Bacteria	283	4.67e-72	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g42402	i0	96.491	21.0116959064327	171	6	100	0	1	171	1249993	1250163	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	3593	283	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
15787918	15787918	PRJNA509429_P_NODE_23133_length_272_cov_1.295359_g22305_i0	PRJNA509429	23133	272	1.295359	3.52337648	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	158	5.14e-34	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g22305	i0	77.941	24.8602941176471	272	46	99	10	1	270	1251010	1250751	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	6762	158	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
17062594	17062594	PRJNA509429_P_NODE_49554_length_155_cov_1.125000_g48726_i0	PRJNA509429	49554	155	1.125	1.74375	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	158	2.63e-34	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g48726	i0	89.516	9.27096774193548	124	13	80	0	1	124	248654	248531	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	1437	158	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
18336940	18336940	PRJNA509429_P_NODE_43535_length_170_cov_1.777778_g42707_i0	PRJNA509429	43535	170	1.777778	3.0222226	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	161	2.26e-35	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g42707	i0	85.621	3.18823529411765	153	22	90	0	18	170	125739	125891	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	542	161	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
19611266	19611266	PRJNA509429_P_NODE_35756_length_197_cov_0.987654_g34928_i0	PRJNA509429	35756	197	0.987654	1.94567838	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	158	3.5099999999999992e-34	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g34928	i0	84.568	0.964467005076142	162	21	81	4	1	160	886538	886379	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	190	158	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota		Candidatus Kaiserbacteria bacterium
19611284	19611284	PRJNA509429_P_NODE_39936_length_181_cov_1.828767_g39108_i0	PRJNA509429	39936	181	1.828767	3.31006827	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	189	1.1199999999999996e-43	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g39108	i0	90.345	40.3812154696133	145	12	80	2	36	179	136525	136668	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	7309	189	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
19611290	19611290	PRJNA509429_P_NODE_41496_length_176_cov_1.758865_g40668_i0	PRJNA509429	41496	176	1.758865	3.0956024	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	207	2.99e-49	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g40668	i0	89.571	52.8693181818182	163	17	93	0	14	176	443598	443760	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	9305	207	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
20887248	20887248	PRJNA509429_P_NODE_15897_length_351_cov_2.012658_g15069_i0	PRJNA509429	15897	351	2.012658	7.06442958	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	309	1.7800000000000002e-79	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g15069	i0	85.333	0.854700854700855	300	42	85	1	52	351	326953	327250	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	300	309	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium Aalborg_AAW-1
20887353	20887353	PRJNA509429_P_NODE_44377_length_168_cov_0.902256_g43549_i0	PRJNA509429	44377	168	0.902256	1.51579008	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	143	8.139999999999998e-30	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g43549	i0	83.436	2.5	163	18	94	9	11	168	449869	449711	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	420	143	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium
22161971	22161971	PRJNA509429_P_NODE_22898_length_274_cov_1.661088_g22070_i0	PRJNA509429	22898	274	1.661088	4.55138112	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	265	2.97e-66	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g22070	i0	86.831	5.05839416058394	243	24	87	7	37	274	7296	7535	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	1386	265	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
22161981	22161981	PRJNA509429_P_NODE_25938_length_250_cov_2.483721_g25110_i0	PRJNA509429	25938	250	2.483721	6.2093025	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g25110	i0	88.106	4.536	227	25	90	2	14	239	328083	328308	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	1134	268	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium Aalborg_AAW-1
22162066	22162066	PRJNA509429_P_NODE_48258_length_158_cov_1.113821_g47430_i0	PRJNA509429	48258	158	1.113821	1.75983718	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	193	7.38e-45	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g47430	i0	88.75	4.59493670886076	160	14	100	4	1	158	126046	125889	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	726	193	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
24711204	24711204	PRJNA509429_P_NODE_24800_length_259_cov_1.776786_g23972_i0	PRJNA509429	24800	259	1.776786	4.60187574	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	261	3.6000000000000002e-65	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g23972	i0	85.542	355.208494208494	249	36	96	0	1	249	441266	441514	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	91999	261	1	Bacteria	Bacteria candidate phyla	Minisyncoccota		Minisyncoccota bacterium
24711334	24711334	PRJNA509429_P_NODE_51820_length_150_cov_1.304348_g50992_i0	PRJNA509429	51820	150	1.304348	1.956522	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	119	1.19e-22	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g50992	i0	83.465	35.4533333333333	127	21	85	0	24	150	7749	7875	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	5318	119	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium GW2011_OD1_34_28

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