metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1240805" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1240805" 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
349328	349328	PRJNA1240805_P_NODE_5121_length_202_cov_2.986928_g5072_i0	PRJNA1240805	5121	202	2.986928	6.03359456	Candidatus Peribacter riflensis	1735162	Bacteria	Bacteria	182	2.15e-41	NTclustered	gi\|946529367\|gb\|CP013062.1\|	1735162	g5072	i0	86.391	6.76732673267327	169	19	83	3	1	167	1196204	1196038	MAG: Candidatus Peribacter riflensis, complete genome	blastn	1367	182	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacter	Candidatus Peribacter riflensis
349355	349355	PRJNA1240805_P_NODE_8141_length_162_cov_11.566372_g8092_i0	PRJNA1240805	8141	162	11.566372	18.73752264	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	207	2.72e-49	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g8092	i0	90.968	138.814814814815	155	12	95	2	9	162	813306	813153	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	22488	207	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
1624071	1624071	PRJNA1240805_P_NODE_1022_length_493_cov_4.495495_g975_i0	PRJNA1240805	1022	493	4.495495	22.16279035	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	869	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g975	i0	100	0.953346855983773	470	0	95	0	24	493	158104	158573	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	470	869	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
1624118	1624118	PRJNA1240805_P_NODE_4942_length_205_cov_7.846154_g4893_i0	PRJNA1240805	4942	205	7.846154	16.0846157	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	145	2.8699999999999997e-30	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g4893	i0	81.667	172.351219512195	180	27	87	6	24	201	127299	127124	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	35332	145	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
2900297	2900297	PRJNA1240805_P_NODE_5703_length_191_cov_4.443662_g5654_i0	PRJNA1240805	5703	191	4.443662	8.48739442	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	274	3.2199999999999997e-69	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g5654	i0	95.882	420.680628272251	170	6	88	1	1	169	327772	327941	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	80350	274	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
5452934	5452934	PRJNA1240805_P_NODE_4605_length_213_cov_7.512195_g4556_i0	PRJNA1240805	4605	213	7.512195	16.00097535	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	364	2.119999999999999e-96	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g4556	i0	99.502	0.943661971830986	201	0	94	1	13	213	170237	170436	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	201	364	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
8002764	8002764	PRJNA1240805_P_NODE_5367_length_197_cov_3.601351_g5318_i0	PRJNA1240805	5367	197	3.601351	7.09466147	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	226	9.499999999999999e-55	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g5318	i0	90.23	1.76649746192893	174	16	88	1	24	197	952375	952547	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	348	226	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
10553493	10553493	PRJNA1240805_P_NODE_3429_length_250_cov_11.059701_g3380_i0	PRJNA1240805	3429	250	11.059701	27.6492525	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	189	1.6499999999999999e-43	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g3380	i0	82.143	0.896	224	36	89	3	5	226	6448	6669	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	224	189	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
15652437	15652437	PRJNA1240805_P_NODE_4753_length_210_cov_1.919255_g4704_i0	PRJNA1240805	4753	210	1.919255	4.0304355	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	315	2.13e-81	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g4704	i0	96.809	0.895238095238095	188	6	90	0	1	188	261957	261770	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	188	315	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
16352945	16352945	PRJNA1240805_P_NODE_3413_length_251_cov_7.178218_g3364_i0	PRJNA1240805	3413	251	7.178218	18.01732718	Bacteria	2	Bacteria	Bacteria	239	1.6300000000000002e-58	NTclustered	gi\|2874253872\|emb\|OY969927.1\|	2501594	g3364	i0	85.837	497.438247011952	233	24	91	9	24	251	74767	74995	MAG: uncultured Candidatus Babeliaceae bacterium isolate MFD01476.bin.c.8 genome assembly, chromosome: 1	blastn	124857	239	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae		uncultured Candidatus Babeliaceae bacterium
20750939	20750939	PRJNA1240805_P_NODE_2357_length_310_cov_2.636015_g2308_i0	PRJNA1240805	2357	310	2.636015	8.1716465	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	545	1.0899999999999999e-150	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g2308	i0	98.387	1	310	5	100	0	1	310	112917	113226	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	310	545	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
23301832	23301832	PRJNA1240805_P_NODE_2019_length_341_cov_1.705479_g1970_i0	PRJNA1240805	2019	341	1.705479	5.81568339	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	603	7.089999999999999e-168	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g1970	i0	98.534	1	341	5	100	0	1	341	39116	39456	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	341	603	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis

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