metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA642647" 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
1894208	1894208	PRJNA642647_P_NODE_3522_length_189_cov_1.453947_g3472_i0	PRJNA642647	3522	189	1.453947	2.74795983	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2225492643\|gb\|CP082927.1\|	2053688	g3472	i0	100	0.148148148148148	28	0	15	0	39	66	192431	192458	MAG: Candidatus Peribacteria bacterium isolate LakeFargette_0920_ALND_MAG_52_24 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
3168796	3168796	PRJNA642647_P_NODE_1803_length_258_cov_3.334842_g1753_i0	PRJNA642647	1803	258	3.334842	8.60389236	uncultured Poribacteria bacterium	265321	Bacteria	Bacteria	62.1	3.9e-5	NTclustered	gi\|2546137836\|emb\|OY282383.1\|	265321	g1753	i0	91.489	0.306201550387597	47	1	18	2	172	218	4101660	4101617	MAG: uncultured Poribacteria bacterium isolate 7c199f84-8048-4b63-b208-6e17c6421a0a genome assembly, chromosome: 1	blastn	79	62.1	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					uncultured Poribacteria bacterium
5721499	5721499	PRJNA642647_P_NODE_1545_length_280_cov_2.016461_g1495_i0	PRJNA642647	1545	280	2.016461	5.6460908	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	302	2.32e-77	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g1495	i0	86.525	63.3714285714286	282	28	99	10	3	279	126188	125912	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	17744	302	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
5721523	5721523	PRJNA642647_P_NODE_3725_length_185_cov_1.581081_g3675_i0	PRJNA642647	3725	185	1.581081	2.92499985	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	106	1.2e-18	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g3675	i0	89.286	37.1567567567568	84	9	45	0	52	135	444748	444665	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	6874	106	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
6996552	6996552	PRJNA642647_P_NODE_3486_length_189_cov_4.552632_g3436_i0	PRJNA642647	3486	189	4.552632	8.60447448	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	82.4	2.07e-11	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g3436	i0	94.444	3.86243386243386	54	2	29	1	26	79	397502	397554	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	730	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota					Candidatus Niyogibacteria bacterium
8811499	8811499	PRJNA642647_P_NODE_6627_length_150_cov_4.000000_g6577_i0	PRJNA642647	6627	150	4	6	Bacteria	2	Bacteria	Bacteria	147	5.45e-31	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g6577	i0	84.768	10.36	151	17	98	3	1	147	190677	190529	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	1554	148	0.993243243243243	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
9546597	9546597	PRJNA642647_P_NODE_5408_length_163_cov_2.769841_g5358_i0	PRJNA642647	5408	163	2.769841	4.51484083	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	141	2.82e-29	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g5358	i0	91.262	125.834355828221	103	9	63	0	60	162	813318	813216	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	20511	141	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
9546599	9546599	PRJNA642647_P_NODE_5688_length_160_cov_1.032520_g5638_i0	PRJNA642647	5688	160	1.03252	1.652032	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	122	9.97e-24	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g5638	i0	83.582	20.11875	134	18	83	3	2	133	127068	127199	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	3219	122	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
9546601	9546601	PRJNA642647_P_NODE_5788_length_158_cov_4.165289_g5738_i0	PRJNA642647	5788	158	4.165289	6.58115662	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	95.3	2.14e-15	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g5738	i0	79.72	24.4620253164557	143	20	91	5	4	146	126787	126654	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	3865	95.3	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
12097403	12097403	PRJNA642647_P_NODE_2490_length_219_cov_1.813187_g2440_i0	PRJNA642647	2490	219	1.813187	3.97087953	Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8	1619036	Bacteria	Bacteria	333	6.179999999999999e-87	NTclustered	gi\|1118703600\|gb\|KX123513.1\|	1619036	g2440	i0	94.444	98.0958904109589	216	12	99	0	4	219	581	366	Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8 16S ribosomal RNA gene, partial sequence	blastn	21483	333	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikbacteria bacterium GW2011_GWA2_37_8
12097431	12097431	PRJNA642647_P_NODE_4970_length_166_cov_2.961240_g4920_i0	PRJNA642647	4970	166	2.96124	4.9156584	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	75	2.97e-9	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g4920	i0	86.567	0.813253012048193	67	9	40	0	98	164	37454	37520	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	135	75	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
12097441	12097441	PRJNA642647_P_NODE_5810_length_158_cov_1.900826_g5760_i0	PRJNA642647	5810	158	1.900826	3.00330508	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	241	2.6e-59	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g5760	i0	94.304	259.96835443038	158	8	99	1	2	158	384208	384365	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	41075	241	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
14646896	14646896	PRJNA642647_P_NODE_2252_length_229_cov_1.255208_g2202_i0	PRJNA642647	2252	229	1.255208	2.87442632	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	224	4.09e-54	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g2202	i0	85.321	3.8296943231441	218	31	95	1	10	227	493623	493407	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	877	224	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
14646933	14646933	PRJNA642647_P_NODE_5952_length_156_cov_2.058824_g5902_i0	PRJNA642647	5952	156	2.058824	3.21176544	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	126	7.46e-25	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g5902	i0	90.625	469.807692307692	96	8	61	1	55	149	444527	444622	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	73290	126	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
17195915	17195915	PRJNA642647_P_NODE_1594_length_276_cov_3.108787_g1544_i0	PRJNA642647	1594	276	3.108787	8.58025212	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	233	8.439999999999999e-57	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g1544	i0	85.217	7.61231884057971	230	31	83	3	44	272	125828	126055	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	2101	233	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
17736483	17736483	PRJNA642647_P_NODE_5994_length_156_cov_1.151261_g5944_i0	PRJNA642647	5994	156	1.151261	1.79596716	Bacteria	2	Bacteria	Bacteria	176	7.31e-40	NTclustered	gi\|2874253993\|emb\|OY970318.1\|	179883	g5944	i0	92.683	46.2628205128205	123	8	79	1	31	153	472528	472649	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04716.bin.c.3 genome assembly, chromosome: 1	blastn	7217	176	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
18470235	18470235	PRJNA642647_P_NODE_3755_length_184_cov_2.931973_g3705_i0	PRJNA642647	3755	184	2.931973	5.39483032	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	196	6.849999999999999e-46	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g3705	i0	85.946	17.6739130434783	185	24	99	1	2	184	384179	384363	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	3252	196	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
21020372	21020372	PRJNA642647_P_NODE_2277_length_227_cov_3.021053_g2227_i0	PRJNA642647	2277	227	3.021053	6.85779031	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	252	1.86e-62	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g2227	i0	86.957	46.0352422907489	230	22	99	7	2	227	443792	443567	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	10450	252	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
21020393	21020393	PRJNA642647_P_NODE_3937_length_181_cov_1.819444_g3887_i0	PRJNA642647	3937	181	1.819444	3.29319364	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	270	3.899999999999999e-68	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g3887	i0	94.798	10.2209944751381	173	9	96	0	6	178	429563	429735	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	1850	270	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
23570708	23570708	PRJNA642647_P_NODE_3399_length_192_cov_1.380645_g3349_i0	PRJNA642647	3399	192	1.380645	2.6508384	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	176	9.4e-40	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g3349	i0	85.057	0.90625	174	24	90	2	12	184	326640	326812	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	174	176	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
23570723	23570723	PRJNA642647_P_NODE_4579_length_170_cov_1.586466_g4529_i0	PRJNA642647	4579	170	1.586466	2.6969922	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	141	2.95e-29	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g4529	i0	82.184	54.8647058823529	174	21	98	8	4	169	448907	448736	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	9327	141	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria 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);;