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

10 rows where analysis = "blastn" and tax_phylum = "Candidatus Berkelbacteria"

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
601693	601693	PRJNA630162_P_NODE_141561_length_166_cov_2.547009_g140038_i0	PRJNA630162	141561	166	2.547009	4.22803494	Berkelbacteria bacterium GW2011_GWE1_39_12	1618337	Bacteria	Bacteria	165	1.7100000000000002e-36	NTclustered	gi\|837351782\|gb\|CP011213.1\|	1618337	g140038	i0	92.308	122.102409638554	117	7	69	1	21	135	137327	137443	Berkelbacteria bacterium GW2011_GWE1_39_12, complete genome	blastn	20269	165	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWE1_39_12
6507000	6507000	PRJEB64798_P_NODE_3606_length_989_cov_25.764894_g79_i38	PRJEB64798	3606	989	25.764894	254.81480166	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	363	4.08e-95	NTclustered	gi\|1950822261\|gb\|CP066697.1\|	2053521	g79	i38	79.924	221.721941354904	528	78	51	24	329	834	518776	519297	Candidatus Berkelbacteria bacterium isolate NC_groundwater_1597_Pr3_B-0.1um_51_91 chromosome	blastn	219283	363	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
13295363	13295363	PRJNA558770_P_NODE_353751_length_232_cov_13.776650_g351746_i0	PRJNA558770	353751	232	13.77665	31.961828	Berkelbacteria bacterium GW2011_GWE1_39_12	1618337	Bacteria	Bacteria	135	2e-27	NTclustered	gi\|837351782\|gb\|CP011213.1\|	1618337	g351746	i0	100	68.4827586206897	73	0	63	0	4	76	136286	136214	Berkelbacteria bacterium GW2011_GWE1_39_12, complete genome	blastn	15888	135	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWE1_39_12
14307816	14307816	PRJNA1123436_P_NODE_111372_length_246_cov_0.890173_g110158_i0	PRJNA1123436	111372	246	0.890173	2.18982558	Berkelbacteria bacterium GW2011_GWE1_39_12	1618337	Bacteria	Bacteria	235	2.06e-57	NTclustered	gi\|837351782\|gb\|CP011213.1\|	1618337	g110158	i0	84.274	98.6585365853659	248	31	99	7	1	245	137154	137396	Berkelbacteria bacterium GW2011_GWE1_39_12, complete genome	blastn	24270	235	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWE1_39_12
14888069	14888069	PRJNA883229_P_NODE_8992_length_253_cov_0.866667_g8946_i0	PRJNA883229	8992	253	0.866667	2.19266751	uncultured Candidatus Berkelbacteria bacterium	1664347	Bacteria	Bacteria	58.4	4.93e-4	NTclustered	gi\|2874253682\|emb\|OY969116.1\|	1664347	g8946	i0	100	0.233201581027668	31	0	12	0	223	253	751589	751559	MAG: uncultured Candidatus Berkelbacteria bacterium isolate MFD04408.bin.c.6 genome assembly, chromosome: 1	blastn	59	58.4	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	uncultured Candidatus Berkelbacteria bacterium
15428822	15428822	PRJEB64798_P_NODE_105913_length_211_cov_7.462963_g104147_i0	PRJEB64798	105913	211	7.462963	15.74685193	Berkelbacteria bacterium GW2011_GWE1_39_12	1618337	Bacteria	Bacteria	91.6	3.93e-14	NTclustered	gi\|837351782\|gb\|CP011213.1\|	1618337	g104147	i0	94.828	23.2748815165877	58	3	27	0	112	169	137064	137121	Berkelbacteria bacterium GW2011_GWE1_39_12, complete genome	blastn	4911	91.6	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWE1_39_12
19255157	19255157	PRJEB64798_P_NODE_76576_length_220_cov_4.456140_g74810_i0	PRJEB64798	76576	220	4.45614	9.803508	uncultured Candidatus Berkelbacteria bacterium	1664347	Bacteria	Bacteria	135	1.88e-27	NTclustered	gi\|2874253682\|emb\|OY969116.1\|	1664347	g74810	i0	79.894	99.4318181818182	189	34	84	4	31	215	7699	7511	MAG: uncultured Candidatus Berkelbacteria bacterium isolate MFD04408.bin.c.6 genome assembly, chromosome: 1	blastn	21875	135	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	uncultured Candidatus Berkelbacteria bacterium
19286895	19286895	PRJNA1020854_S_NODE_42596_length_152_cov_2.000000_g39832_i0	PRJNA1020854	42596	152	2	3.04	Candidatus Berkelbacteria bacterium	2053521	Bacteria	Bacteria	62.1	2.06e-5	NTclustered	gi\|1950820483\|gb\|CP066695.1\|	2053521	g39832	i0	88.235	1.84210526315789	51	6	34	0	4	54	767954	768004	Candidatus Berkelbacteria bacterium isolate NC_groundwater_1922_Pr3_S-0.2um_51_5 chromosome	blastn	280	62.1	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Candidatus Berkelbacteria bacterium
19728191	19728191	PRJNA630162_P_NODE_130176_length_169_cov_2.116667_g128653_i0	PRJNA630162	130176	169	2.116667	3.57716723	uncultured Candidatus Berkelbacteria bacterium	1664347	Bacteria	Bacteria	97.1	6.43e-16	NTclustered	gi\|2874253682\|emb\|OY969116.1\|	1664347	g128653	i0	80.469	2.05917159763314	128	23	75	2	43	169	6229	6103	MAG: uncultured Candidatus Berkelbacteria bacterium isolate MFD04408.bin.c.6 genome assembly, chromosome: 1	blastn	348	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	uncultured Candidatus Berkelbacteria bacterium
23554171	23554171	PRJNA630162_P_NODE_130839_length_169_cov_1.525000_g129316_i0	PRJNA630162	130839	169	1.525	2.57725	Berkelbacteria bacterium GW2011_GWE1_39_12	1618337	Bacteria	Bacteria	73.1	1.08e-8	NTclustered	gi\|837351782\|gb\|CP011213.1\|	1618337	g129316	i0	82.353	1.33727810650888	85	13	50	2	77	160	136137	136220	Berkelbacteria bacterium GW2011_GWE1_39_12, complete genome	blastn	226	73.1	1	Bacteria	Bacteria candidate phyla	Candidatus Berkelbacteria	Berkelbacteria bacterium GW2011_GWE1_39_12

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