metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax

9 rows where analysis = "blastn", 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_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

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