metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_species
937714	937714	PRJNA951810_P_NODE_63681_length_310_cov_3.016878_g63338_i0	PRJNA951810	63681	310	3.016878	9.3523218	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	78.7	4.78e-10	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g63338	i0	82.979	0.574193548387097	94	9	29	7	220	310	3504837	3504748	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	178	78.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
3488678	3488678	PRJNA951810_P_NODE_80983_length_299_cov_3.756637_g80639_i0	PRJNA951810	80983	299	3.756637	11.23234463	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	128	4.49e-25	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g80639	i0	91.489	32.0702341137124	94	6	31	1	33	124	886353	886260	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9589	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
4764098	4764098	PRJNA951810_P_NODE_124964_length_276_cov_7.669951_g124619_i0	PRJNA951810	124964	276	7.669951	21.16906476	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	213	1.1e-50	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g124619	i0	92.617	17.804347826087	149	9	54	2	1	148	4709710	4709857	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	4914	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
4764551	4764551	PRJNA951810_P_NODE_151564_length_256_cov_11.065574_g151219_i0	PRJNA951810	151564	256	11.065574	28.32786944	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	279	9.81e-71	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g151219	i0	90.187	0.8359375	214	21	84	0	43	256	384374	384587	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	214	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
4766112	4766112	PRJNA951810_P_NODE_65524_length_310_cov_2.780591_g65181_i0	PRJNA951810	65524	310	2.780591	8.6198321	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	76.8	1.72e-9	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g65181	i0	92.453	0.280645161290323	53	4	17	0	258	310	1772296	1772348	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	87	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
7316230	7316230	PRJNA951810_P_NODE_92446_length_296_cov_5.843049_g92102_i0	PRJNA951810	92446	296	5.843049	17.29542504	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	113	1.24e-20	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g92102	i0	89.888	0.300675675675676	89	7	29	2	138	224	4668874	4668962	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	89	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
9865752	9865752	PRJNA951810_P_NODE_59368_length_310_cov_3.666667_g59025_i0	PRJNA951810	59368	310	3.666667	11.3666677	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	163	1.2799999999999998e-35	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g59025	i0	75.585	0.964516129032258	299	69	95	3	1	295	4120084	4120382	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	299	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
16240441	16240441	PRJNA951810_P_NODE_58253_length_310_cov_3.856540_g57910_i0	PRJNA951810	58253	310	3.85654	11.955274	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	110	1.69e-19	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g57910	i0	92.308	0.251612903225806	78	5	25	1	62	138	3929399	3929476	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	78	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18790049	18790049	PRJNA951810_P_NODE_9355_length_614_cov_7.395564_g9056_i0	PRJNA951810	9355	614	7.395564	45.40876296	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	148	7.549999999999999e-31	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9056	i0	82.927	0.267100977198697	164	28	27	0	1	164	3711612	3711775	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	164	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
20064197	20064197	PRJNA951810_P_NODE_46876_length_310_cov_6.531646_g46533_i0	PRJNA951810	46876	310	6.531646	20.2481026	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	75	6.18e-9	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g46533	i0	100	0.22258064516129	40	0	13	0	271	310	665969	665930	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	69	75	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25163656	25163656	PRJNA951810_P_NODE_49100_length_310_cov_5.789030_g48757_i0	PRJNA951810	49100	310	5.78903	17.945993	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	97.1	1.32e-15	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g48757	i0	100	7.59354838709677	52	0	17	0	7	58	2358593	2358644	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	2354	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria 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);;