metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA826497" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA826497" 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
820686	820686	PRJNA826497_S_NODE_20241_length_150_cov_2.820513_g20201_i0	PRJNA826497	20241	150	2.820513	4.2307695	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	100	4.3e-17	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g20201	i0	78.667	1	150	32	100	0	1	150	360976	360827	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	150	100	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
7198730	7198730	PRJNA826497_S_NODE_11766_length_178_cov_5.062069_g11726_i0	PRJNA826497	11766	178	5.062069	9.01048282	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	316	4.8399999999999983e-82	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g11726	i0	99.425	3.93820224719101	174	1	98	0	1	174	429458	429285	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	701	316	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
7198754	7198754	PRJNA826497_S_NODE_16126_length_161_cov_4.789062_g16086_i0	PRJNA826497	16126	161	4.789062	7.71038982	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	291	2.6e-74	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g16086	i0	99.375	108.590062111801	160	1	99	0	2	161	503081	502922	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	17483	291	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
7198804	7198804	PRJNA826497_S_NODE_6126_length_215_cov_5.269231_g6086_i0	PRJNA826497	6126	215	5.2692310000000004	11.32884665	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	99	2.4e-16	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g6086	i0	79.856	0.646511627906977	139	25	64	3	1	137	502604	502741	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	139	99	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
8473528	8473528	PRJNA826497_S_NODE_18047_length_155_cov_12.122951_g18007_i0	PRJNA826497	18047	155	12.122951	18.79057405	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	104	3.47e-18	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g18007	i0	89.157	0.535483870967742	83	9	54	0	15	97	924554	924636	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	83	104	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
8473534	8473534	PRJNA826497_S_NODE_18907_length_153_cov_4.083333_g18867_i0	PRJNA826497	18907	153	4.083333	6.24749949	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	243	6.93e-60	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g18867	i0	95.395	165.346405228758	152	7	99	0	1	152	431174	431325	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	25298	243	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
8473564	8473564	PRJNA826497_S_NODE_6747_length_209_cov_21.278409_g6707_i0	PRJNA826497	6747	209	21.278409	44.47187481	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	302	1.6500000000000001e-77	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g6707	i0	93.171	2.96650717703349	205	14	98	0	5	209	429642	429438	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	620	302	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
12299797	12299797	PRJNA826497_S_NODE_10870_length_182_cov_5.731544_g10830_i0	PRJNA826497	10870	182	5.731544	10.43141008	uncultured Candidatus Babeliaceae bacterium	2501594	Bacteria	Bacteria	165	1.91e-36	NTclustered	gi\|2874253872\|emb\|OY969927.1\|	2501594	g10830	i0	83.333	133.384615384615	186	23	100	7	1	182	75522	75341	MAG: uncultured Candidatus Babeliaceae bacterium isolate MFD01476.bin.c.8 genome assembly, chromosome: 1	blastn	24276	165	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		uncultured Candidatus Babeliaceae bacterium
12299799	12299799	PRJNA826497_S_NODE_1130_length_326_cov_9.320819_g1090_i0	PRJNA826497	1130	326	9.320819	30.38586994	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	429	1.2099999999999999e-115	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g1090	i0	90.712	5.9478527607362	323	28	99	2	1	323	430259	430579	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	1939	429	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
12299854	12299854	PRJNA826497_S_NODE_3270_length_252_cov_10.036530_g3230_i0	PRJNA826497	3270	252	10.03653	25.2920556	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	272	1.6099999999999999e-68	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g3230	i0	86.747	3.1984126984127	249	28	98	5	3	249	952671	952916	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	806	272	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
14848728	14848728	PRJNA826497_S_NODE_6752_length_209_cov_15.818182_g6712_i0	PRJNA826497	6752	209	15.818182	33.06000038	Candidatus Falkowbacteria bacterium	2053554	Bacteria	Bacteria	143	1.06e-29	NTclustered	gi\|2801818892\|emb\|OZ173682.1\|	2053554	g6712	i0	88	5.44976076555024	125	9	58	5	7	128	765030	765151	Candidatus Falkowbacteria bacterium isolate Fred.cMAG.1 genome assembly, chromosome: 1	blastn	1139	143	1	Bacteria	Bacteria candidate phyla	Candidatus Falkowiibacteriota					Candidatus Falkowbacteria bacterium
19947227	19947227	PRJNA826497_S_NODE_6596_length_211_cov_2.747191_g6556_i0	PRJNA826497	6596	211	2.747191	5.79657301	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	150	6.389999999999998e-32	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g6556	i0	80.193	0.981042654028436	207	36	97	5	1	205	37069	36866	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	207	150	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
19947230	19947230	PRJNA826497_S_NODE_7656_length_202_cov_2.952663_g7616_i0	PRJNA826497	7656	202	2.952663	5.96437926	Candidatus Phycocordibacter aenigmaticus	1948796	Bacteria	Bacteria	226	9.789999999999996e-55	NTclustered	gi\|2862534145\|gb\|CP174359.1\|	1948796	g7616	i0	87.562	38.509900990099	201	17	98	8	2	199	75386	75191	MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome	blastn	7779	226	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Phycocordibacter	Candidatus Phycocordibacter aenigmaticus
21222635	21222635	PRJNA826497_S_NODE_13517_length_171_cov_1.775362_g13477_i0	PRJNA826497	13517	171	1.775362	3.03586902	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	185	1.3499999999999997e-42	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g13477	i0	90.21	9.29239766081871	143	12	82	2	1	141	887468	887326	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	1589	185	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
21222700	21222700	PRJNA826497_S_NODE_5837_length_218_cov_2.929730_g5797_i0	PRJNA826497	5837	218	2.92973	6.3868114	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	150	6.64e-32	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g5797	i0	94.792	0.440366972477064	96	5	44	0	119	214	936598	936693	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	96	150	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
22497359	22497359	PRJNA826497_S_NODE_15078_length_165_cov_2.015152_g15038_i0	PRJNA826497	15078	165	2.015152	3.3250008	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	126	8.02e-25	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g15038	i0	81.699	0.927272727272727	153	27	93	1	12	164	735317	735468	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	153	126	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
22497394	22497394	PRJNA826497_S_NODE_4938_length_228_cov_2.533333_g4898_i0	PRJNA826497	4938	228	2.533333	5.77599924	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	65.8	2.61e-6	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g4898	i0	100	0.995614035087719	35	0	29	0	170	204	611432	611398	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	227	65.8	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria 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);;