metadata: contig_metadata: 8 rows where analysis = "blastn" and tax

8 rows where analysis = "blastn" and tax_phylum = "Candidatus Niyogiibacteriota"

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
1877533	1877533	PRJNA630162_P_NODE_108562_length_180_cov_2.839695_g107039_i0	PRJNA630162	108562	180	2.839695	5.111451	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	182	1.87e-41	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g107039	i0	85.632	611.927777777778	174	24	97	1	4	177	393692	393864	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	110147	182	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota	Candidatus Niyogibacteria bacterium
3167601	3167601	PRJNA641707_P_NODE_53623_length_293_cov_4.401639_g50963_i0	PRJNA641707	53623	293	4.401639	12.89680227	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	119	2.64e-22	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g50963	i0	81.457	1.59044368600683	151	22	51	6	137	284	396600	396453	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	466	119	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota	Candidatus Niyogibacteria 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
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
11607047	11607047	PRJEB64798_P_NODE_251230_length_151_cov_7.058824_g249464_i0	PRJEB64798	251230	151	7.058824	10.65882424	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	134	4.28e-27	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g249464	i0	84.962	1.72847682119205	133	18	87	2	5	136	396480	396611	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	261	134	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota	Candidatus Niyogibacteria bacterium
11843197	11843197	PRJNA168635_P_NODE_29530_length_164_cov_2.226087_g29114_i0	PRJNA168635	29530	164	2.226087	3.65078268	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	121	3.7e-23	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g29114	i0	81.169	1.81707317073171	154	25	93	4	3	154	396412	396563	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	298	121	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota	Candidatus Niyogibacteria bacterium
18724672	18724672	PRJNA896973_P_NODE_23555_length_248_cov_0.880000_g23461_i0	PRJNA896973	23555	248	0.88	2.1824	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	63.9	1.04e-5	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g23461	i0	93.023	0.173387096774194	43	3	17	0	72	114	397195	397237	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	43	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota	Candidatus Niyogibacteria bacterium
21003855	21003855	PRJNA630162_P_NODE_113197_length_178_cov_1.418605_g111674_i0	PRJNA630162	113197	178	1.418605	2.5251169	Candidatus Niyogibacteria bacterium	2750078	Bacteria	Bacteria	139	1.1199999999999999e-28	NTclustered	gi\|1950817574\|gb\|CP066691.1\|	2750078	g111674	i0	83.333	1.59550561797753	156	21	87	5	19	172	396607	396455	MAG: Candidatus Niyogibacteria bacterium isolate NC_groundwater_707_Ag_S-0.2um_45_26 chromosome	blastn	284	139	1	Bacteria	Bacteria candidate phyla	Candidatus Niyogiibacteriota	Candidatus Niyogibacteria 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);;