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

9 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
1409340	1409340	PRJEB66218_P_NODE_96222_length_314_cov_1.284585_g93794_i0	PRJEB66218	96222	314	1.284585	4.0335969	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	316	9.44e-82	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g93794	i0	85.526	0.968152866242038	304	42	96	2	5	307	7968725	7968423	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	304	316	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
7785111	7785111	PRJEB66218_P_NODE_236907_length_203_cov_0.915493_g234476_i0	PRJEB66218	236907	203	0.915493	1.85845079	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	122	1.3299999999999995e-23	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g234476	i0	88.889	2.80295566502463	99	11	49	0	97	195	7415247	7415345	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	569	122	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
9061605	9061605	PRJEB66218_P_NODE_78788_length_356_cov_23.810169_g76362_i0	PRJEB66218	78788	356	23.810169	84.76420164	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	145	5.400000000000001e-30	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g76362	i0	81.622	1.04213483146067	185	25	51	7	32	214	2483993	2483816	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	371	145	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
12884270	12884270	PRJEB66218_P_NODE_116931_length_279_cov_1.490826_g114502_i0	PRJEB66218	116931	279	1.490826	4.15940454	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	255	1.82e-63	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g114502	i0	83.813	9.18637992831541	278	36	96	6	11	279	4092116	4092393	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	2563	255	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
16707845	16707845	PRJEB66218_P_NODE_138594_length_252_cov_2.183246_g136165_i0	PRJEB66218	138594	252	2.183246	5.50177992	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	239	1.6300000000000002e-58	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g136165	i0	86.364	22.7261904761905	220	28	87	2	12	230	818571	818789	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	5727	239	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
21809369	21809369	PRJEB66218_P_NODE_228338_length_204_cov_2.272727_g225908_i0	PRJEB66218	228338	204	2.272727	4.63636308	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	187	4.68e-43	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g225908	i0	88.272	138.328431372549	162	12	78	6	20	179	7413494	7413650	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	28219	187	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
23082962	23082962	PRJEB66218_P_NODE_132019_length_259_cov_3.676768_g129590_i0	PRJEB66218	132019	259	3.676768	9.52282912	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	337	5.82e-88	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g129590	i0	90.347	345.718146718147	259	21	99	4	1	257	5033265	5033521	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	89541	337	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
23083430	23083430	PRJEB66218_P_NODE_155479_length_237_cov_2.215909_g153050_i0	PRJEB66218	155479	237	2.215909	5.25170433	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	213	9.22e-51	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g153050	i0	84.834	1.18987341772152	211	32	89	0	10	220	8889908	8890118	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	282	213	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
24359615	24359615	PRJEB66218_P_NODE_56320_length_443_cov_1.798429_g53900_i0	PRJEB66218	56320	443	1.798429	7.96704047	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2874253636\|emb\|OY968762.1\|	3107663	g53900	i0	100	0.0677200902934537	30	0	7	0	106	135	1617578	1617549	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.1.72 genome assembly, chromosome: 1	blastn	30	56.5	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);;