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

9 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
2230370	2230370	PRJNA980585_P_NODE_48062_length_247_cov_2.040230_g47808_i0	PRJNA980585	48062	247	2.04023	5.0393681	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	211	3.48e-50	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g47808	i0	85.047	16.4008097165992	214	25	85	7	38	247	3682361	3682571	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	4051	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
3505418	3505418	PRJNA980585_P_NODE_38283_length_257_cov_0.820652_g38029_i0	PRJNA980585	38283	257	0.820652	2.10907564	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	231	2.8e-56	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g38029	i0	83.012	33.5719844357977	259	40	100	3	1	257	3680995	3681251	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	8628	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
4783435	4783435	PRJNA980585_P_NODE_6684_length_500_cov_3.163934_g6430_i0	PRJNA980585	6684	500	3.163934	15.81967	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	614	4.969999999999998e-171	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g6430	i0	88.8	206.824	500	56	100	0	1	500	3680618	3680119	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	103412	614	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
7332652	7332652	PRJNA980585_P_NODE_386_length_1569_cov_3.491310_g305_i0	PRJNA980585	386	1569	3.49131	54.7786539	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1733	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g305	i0	86.662	107.954110898662	1582	189	99	21	1	1568	3680926	3682499	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	169380	1733	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14982676	14982676	PRJNA980585_P_NODE_35092_length_265_cov_1.901042_g34838_i0	PRJNA980585	35092	265	1.901042	5.0377613	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	246	1.0399999999999999e-60	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g34838	i0	83.521	37.8188679245283	267	41	100	3	1	265	3682643	3682378	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	10022	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
16257365	16257365	PRJNA980585_P_NODE_1653_length_905_cov_4.209135_g1440_i0	PRJNA980585	1653	905	4.209135	38.09267175	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	983	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1440	i0	86.448	223.641988950276	915	102	99	22	1	902	3681755	3682660	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	202396	983	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18807053	18807053	PRJNA980585_P_NODE_7815_length_467_cov_4.550761_g7561_i0	PRJNA980585	7815	467	4.550761	21.25205387	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	453	1.06e-122	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g7561	i0	84.355	70.7280513918629	473	62	100	10	1	467	3681392	3680926	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	33030	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22631941	22631941	PRJNA980585_P_NODE_40158_length_251_cov_1.724719_g39904_i0	PRJNA980585	40158	251	1.724719	4.32904469	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	124	4.7499999999999994e-24	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g39904	i0	96.104	0.306772908366534	77	1	31	2	175	251	3855717	3855791	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	77	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
23907597	23907597	PRJNA980585_P_NODE_5439_length_544_cov_8.685775_g5185_i0	PRJNA980585	5439	544	8.685775	47.250616	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	878	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5185	i0	95.772	162.261029411765	544	23	100	0	1	544	3682122	3682665	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	88270	878	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);;