metadata: contig_metadata: 5 rows where bioproject = "PRJEB29441", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJEB29441", tax_kingdom = "Bacillati" 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
1300731	1300731	PRJEB29441_P_NODE_25062_length_210_cov_1.981366_g24621_i0	PRJEB29441	25062	210	1.981366	4.1608686	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	176	1.05e-39	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g24621	i0	82.353	27.6809523809524	204	34	99	1	4	207	5032798	5032597	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	5813	176	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
10229633	10229633	PRJEB29441_P_NODE_48489_length_154_cov_2.114286_g48048_i0	PRJEB29441	48489	154	2.114286	3.25600044	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	274	2.48e-69	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g48048	i0	98.701	142.577922077922	154	2	100	0	1	154	5032171	5032324	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	21957	274	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
12779844	12779844	PRJEB29441_P_NODE_15551_length_276_cov_1.533040_g15110_i0	PRJEB29441	15551	276	1.53304	4.2311904	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	364	2.869999999999999e-96	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g15110	i0	90.58	2.89492753623188	276	24	99	2	1	275	5032850	5032576	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	799	364	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
17877900	17877900	PRJEB29441_P_NODE_13935_length_294_cov_1.816327_g13494_i0	PRJEB29441	13935	294	1.816327	5.34000138	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	281	3.2000000000000007e-71	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g13494	i0	84.122	727.442176870748	296	41	99	6	1	293	5033258	5033550	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	213868	281	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
19152057	19152057	PRJEB29441_P_NODE_30256_length_190_cov_1.808511_g29815_i0	PRJEB29441	30256	190	1.808511	3.4361709	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	283	5.319999999999999e-72	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g29815	i0	93.651	609.821052631579	189	12	99	0	1	189	5033599	5033787	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	115866	283	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);;