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

11 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Vulcanimicrobiota"

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_kingdom	tax_phylum	tax_species
601425	601425	PRJNA630162_P_NODE_111941_length_178_cov_5.317829_g110418_i0	PRJNA630162	111941	178	5.317829	9.46573562	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	274	2.95e-69	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g110418	i0	94.857	499.157303370787	175	9	98	0	2	176	5032190	5032016	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	88850	274	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
1878963	1878963	PRJNA630162_P_NODE_91822_length_190_cov_4.652482_g90299_i0	PRJNA630162	91822	190	4.652482	8.8397158	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	213	7.08e-51	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g90299	i0	87.568	84.9052631578947	185	22	97	1	1	184	5031762	5031578	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	16132	213	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
8256000	8256000	PRJNA630162_P_NODE_9567_length_621_cov_3.972028_g8180_i0	PRJNA630162	9567	621	3.972028	24.66629388	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	540	1.0799999999999999e-148	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g8180	i0	82.56	48.4090177133655	625	98	99	10	1	619	5033168	5032549	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	30062	540	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
12082284	12082284	PRJNA630162_P_NODE_97610_length_187_cov_1.463768_g96087_i0	PRJNA630162	97610	187	1.463768	2.73724616	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	84.2	5.68e-12	NTclustered	gi\|2874253878\|emb\|OY969933.1\|	3107663	g96087	i0	96.078	61.91443850267379	51	2	27	0	5	55	440756	440706	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD05502.bin.c.2 genome assembly, chromosome: 1	blastn	11578	84.2	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
13356824	13356824	PRJNA630162_P_NODE_75431_length_207_cov_1.803797_g73908_i0	PRJNA630162	75431	207	1.803797	3.73385979	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	241	3.6e-59	NTclustered	gi\|2874253636\|emb\|OY968762.1\|	3107663	g73908	i0	88.235	13.4541062801932	204	21	98	3	2	203	423721	423519	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1	blastn	2785	241	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
15905514	15905514	PRJNA630162_P_NODE_78093_length_203_cov_7.928571_g76570_i0	PRJNA630162	78093	203	7.928571	16.09499913	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	350	5.6e-92	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g76570	i0	98.01	645.261083743842	201	4	99	0	3	203	5033761	5033561	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	130988	350	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
18454737	18454737	PRJNA630162_P_NODE_80515_length_200_cov_7.304636_g78992_i0	PRJNA630162	80515	200	7.304636	14.609272	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	272	1.2299999999999998e-68	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g78992	i0	92.268	106.915	194	11	98	3	1	193	5032856	5033046	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	21383	272	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
19728452	19728452	PRJNA630162_P_NODE_157936_length_162_cov_5.283186_g156413_i0	PRJNA630162	157936	162	5.283186	8.55876132	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	213	5.84e-51	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g156413	i0	90.741	448.555555555556	162	12	99	3	2	162	5033277	5033436	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	72666	213	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
22278662	22278662	PRJNA630162_P_NODE_121438_length_173_cov_4.951613_g119915_i0	PRJNA630162	121438	173	4.951613	8.56629049	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	248	1.73e-61	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g119915	i0	93.452	938.167630057803	168	10	97	1	1	167	5032053	5031886	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	162303	248	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
22279637	22279637	PRJNA630162_P_NODE_63638_length_221_cov_13.127907_g62115_i0	PRJNA630162	63638	221	13.127907	29.01267447	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	329	8.08e-86	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g62115	i0	94.393	537.864253393665	214	12	97	0	6	219	5033548	5033761	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	118868	329	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
24828622	24828622	PRJNA630162_P_NODE_5040_length_849_cov_6.028750_g3986_i0	PRJNA630162	5040	849	6.02875	51.1840875	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	723	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g3986	i0	82.462	843.478209658422	861	118	99	31	1	843	5033248	5032403	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	716113	723	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota 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);;