metadata: contig_metadata: 13 rows where bioproject = "PRJNA169559" and tax

13 rows where bioproject = "PRJNA169559" 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_order	tax_species
364991	364991	PRJNA169559_P_NODE_28921_length_270_cov_6.601660_g26845_i0	PRJNA169559	28921	270	6.60166	17.824482	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	414	2.74e-111	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g26845	i0	94.424	65.1185185185185	269	15	99	0	1	269	799859	799591	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	17582	414	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
2915614	2915614	PRJNA169559_P_NODE_23383_length_322_cov_18.109215_g21310_i0	PRJNA169559	23383	322	18.109215	58.3116723	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	516	8.92e-142	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g21310	i0	95.679	127.093167701863	324	9	100	5	1	322	800192	799872	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	40924	516	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
3605264	3605264	PRJNA169559_P_NODE_3143_length_933_cov_97.185841_g2110_i0	PRJNA169559	3143	933	97.185841	906.74389653	Bacteria	2	Bacteria	Bacteria	1105	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g2110	i0	91.719	167.926045016077	797	64	85	2	138	933	851947	852742	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	156675	1105	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6742578	6742578	PRJNA169559_P_NODE_17906_length_402_cov_4.455764_g15907_i0	PRJNA169559	17906	402	4.455764	17.91217128	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	279	1.62e-70	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g15907	i0	86.434	30.2338308457711	258	32	64	3	139	395	385068	385323	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	12154	279	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
6742793	6742793	PRJNA169559_P_NODE_45366_length_210_cov_7.254144_g43289_i0	PRJNA169559	45366	210	7.254144	15.2337024	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	180	8.099999999999998e-41	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g43289	i0	82.843	40.4952380952381	204	32	97	3	8	210	447121	447322	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	8504	180	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium
8018563	8018563	PRJNA169559_P_NODE_7587_length_616_cov_53.890971_g2110_i1	PRJNA169559	7587	616	53.890971	331.96838136	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	680	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g2110	i1	92.308	167.957792207792	481	33	78	4	1	479	852425	851947	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	103462	680	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11843678	11843678	PRJNA169559_P_NODE_42470_length_228_cov_4.452261_g40393_i0	PRJNA169559	42470	228	4.452261	10.15115508	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	159	1.1599999999999999e-34	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g40393	i0	82.353	46.4298245614035	187	29	81	3	44	228	386234	386050	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	10586	159	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
16942268	16942268	PRJNA169559_P_NODE_27094_length_282_cov_4.035573_g25018_i0	PRJNA169559	27094	282	4.035573	11.38031586	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	339	1.78e-88	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g25018	i0	88.339	75.3014184397163	283	31	100	2	1	282	137331	137612	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	21235	339	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
20766501	20766501	PRJNA169559_P_NODE_25237_length_299_cov_5.970370_g23161_i0	PRJNA169559	25237	299	5.97037	17.8514063	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	501	2.3e-137	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g23161	i0	96.98	64.0836120401338	298	9	99	0	2	299	799591	799888	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	19161	501	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
27295184	27295184	PRJNA169559_P_NODE_24683_length_306_cov_2.389892_g22607_i0	PRJNA169559	24683	306	2.389892	7.31306952	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	47	0.00246	NR	RTL06914.1	2030827	g22607	i0	39.7	0.666666666666667	68	35	60.8	1	16	201	306	373	RTL06914.1 MAG: hypothetical protein EKK58_03720 [Candidatus Dependentiae bacterium]	diamond	204	47	1	Bacteria	Bacteria candidate phyla			Candidatus Babelota bacterium
28179091	28179091	PRJNA169559_P_NODE_47766_length_171_cov_3.394366_g45689_i0	PRJNA169559	47766	171	3.394366	5.80436586	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	41.2	0.0481	NR	GIX08090.1	2026781	g45689	i0	72.7	0.385964912280702	22	5	38.6	1	101	36	207	227	GIX08090.1 MAG: sugar phosphate isomerase [Candidatus Poribacteria bacterium]	diamond	66	41.2	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria		Candidatus Poribacteria bacterium
28526863	28526863	PRJNA169559_P_NODE_32447_length_255_cov_1.969027_g30371_i0	PRJNA169559	32447	255	1.969027	5.02101885	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	50.8	1.73e-5	NR	MBP9798164.1	2026804	g30371	i0	36.5	0.741176470588235	63	40	74.1	0	10	198	82	144	MBP9798164.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	189	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota		Candidatus Woesebacteria bacterium
31843831	31843831	PRJNA169559_P_NODE_30617_length_262_cov_1.858369_g28541_i0	PRJNA169559	30617	262	1.858369	4.86892678	Candidatus Absconditabacterales bacterium	2927939	Bacteria	Bacteria	100	6.27e-23	NR	HNG96902.1	2927939	g28541	i0	63.3	0.904580152671756	79	27	90.5	1	237	1	8	84	HNG96902.1 hypothetical protein [Candidatus Absconditabacterales bacterium]	diamond	237	100	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	Candidatus Absconditabacterales	Candidatus Absconditabacterales 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);;