metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA193544" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA193544" 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_order	tax_family	tax_genus	tax_species
365908	365908	PRJNA193544_S_NODE_741_length_281_cov_302.996032_g726_i0	PRJNA193544	741	281	302.996032	851.41884992	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	316	8.319999999999998e-82	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g726	i0	94.203	54.153024911032	207	12	74	0	52	258	137538	137744	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	15217	316	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
1640641	1640641	PRJNA193544_S_NODE_1062_length_246_cov_7.009217_g1047_i0	PRJNA193544	1062	246	7.009217	17.24267382	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	267	7.289999999999999e-67	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g1047	i0	87.179	0.951219512195122	234	30	95	0	2	235	326906	326673	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	234	267	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
5469258	5469258	PRJNA193544_S_NODE_965_length_254_cov_21.026667_g950_i0	PRJNA193544	965	254	21.026667	53.40773418	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	285	2.09e-72	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g950	i0	88.608	59.3858267716535	237	24	93	3	18	252	195433	195198	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	15084	285	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
6743540	6743540	PRJNA193544_S_NODE_1246_length_229_cov_7.290000_g1231_i0	PRJNA193544	1246	229	7.29	16.6941	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	329	8.43e-86	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g1231	i0	93.274	66.3144104803494	223	15	97	0	1	223	195100	194878	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	15186	329	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
6743560	6743560	PRJNA193544_S_NODE_1966_length_193_cov_21.932927_g1951_i0	PRJNA193544	1966	193	21.932927	42.33054911	uncultured Parcubacteria group bacterium	221218	Bacteria	Bacteria	244	2.56e-60	NTclustered	gi\|381283287\|gb\|JQ291120.1\|	221218	g1951	i0	97.241	80.8290155440415	145	2	74	2	51	193	120	264	Uncultured candidate division OD1 bacterium clone MJ-W1-096 16S ribosomal RNA gene, partial sequence	blastn	15600	244	1	Bacteria	Bacteria candidate phyla						uncultured Parcubacteria group bacterium
8019281	8019281	PRJNA193544_S_NODE_507_length_315_cov_13459.835664_g492_i0	PRJNA193544	507	315	13459.835664	42398.4823416	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	219	2.7499999999999993e-52	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g492	i0	82.642	152.663492063492	265	28	81	14	34	289	192749	192494	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	48089	219	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
9293961	9293961	PRJNA193544_S_NODE_1508_length_213_cov_10.168478_g1493_i0	PRJNA193544	1508	213	10.168478	21.65885814	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	185	1.77e-42	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g1493	i0	89.262	443.394366197183	149	14	69	2	66	213	217812	217959	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	94443	185	1	Bacteria	Bacteria candidate phyla						Candidatus Dependentiae bacterium Noda2021
9293979	9293979	PRJNA193544_S_NODE_2288_length_181_cov_3.467105_g2273_i0	PRJNA193544	2288	181	3.467105	6.27546005	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g2273	i0	100	0.160220994475138	29	0	16	0	132	160	396709	396737	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	29	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota					Candidatus Niyogibacteria bacterium
10569991	10569991	PRJNA193544_S_NODE_789_length_273_cov_16427.938525_g774_i0	PRJNA193544	789	273	16427.938525	44848.27217325	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	241	4.98e-59	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g774	i0	86.697	442.747252747253	218	27	80	2	6	223	5550	5335	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	120870	241	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
13119649	13119649	PRJNA193544_S_NODE_1351_length_222_cov_4.150259_g1336_i0	PRJNA193544	1351	222	4.150259	9.21357498	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	278	2.98e-70	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g1336	i0	89.189	4.18468468468468	222	24	100	0	1	222	193276	193055	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	929	278	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
13119655	13119655	PRJNA193544_S_NODE_1511_length_213_cov_4.527174_g1496_i0	PRJNA193544	1511	213	4.527174	9.64288062	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	159	1.0699999999999999e-34	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g1496	i0	81.633	36.81220657277	196	33	92	3	14	208	136835	137028	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	7841	159	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
14394988	14394988	PRJNA193544_S_NODE_3092_length_158_cov_8.961240_g3077_i0	PRJNA193544	3092	158	8.96124	14.1587592	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	115	1.6400000000000002e-21	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g3077	i0	81.119	1.46835443037975	143	27	91	0	1	143	191086	191228	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	232	115	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
16943176	16943176	PRJNA193544_S_NODE_3494_length_150_cov_4.132231_g3479_i0	PRJNA193544	3494	150	4.132231	6.1983465	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	172	8.99e-39	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g3479	i0	88.652	0.94	141	16	94	0	2	142	135624	135484	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	141	172	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18217618	18217618	PRJNA193544_S_NODE_855_length_265_cov_2913.110169_g840_i0	PRJNA193544	855	265	2913.110169	7719.74194785	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	211	3.78e-50	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g840	i0	88.953	451.969811320755	172	17	64	2	91	260	447166	447337	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	119772	211	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium
19491857	19491857	PRJNA193544_S_NODE_1296_length_225_cov_2.617347_g1281_i0	PRJNA193544	1296	225	2.617347	5.88903075	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	267	6.559999999999999e-67	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g1281	i0	88.053	4.01333333333333	226	25	100	2	1	225	328052	328276	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	903	267	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
19491899	19491899	PRJNA193544_S_NODE_396_length_336_cov_12092.820847_g381_i0	PRJNA193544	396	336	12092.820847	40631.87804592	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	272	2.24e-68	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g381	i0	83.062	107.910714285714	307	45	90	7	1	303	126188	125885	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	36258	272	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
23318023	23318023	PRJNA193544_S_NODE_539_length_310_cov_18.661922_g524_i0	PRJNA193544	539	310	18.661922	57.8519582	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	381	3.249999999999999e-101	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g524	i0	92.776	337.306451612903	263	19	85	0	1	263	124756	124494	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	104565	381	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
24592117	24592117	PRJNA193544_S_NODE_1380_length_220_cov_6.460733_g1365_i0	PRJNA193544	1380	220	6.460733	14.2136126	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	219	1.82e-52	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g1365	i0	84.753	126.354545454545	223	28	100	6	1	220	123803	124022	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	27798	219	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria 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);;