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

5 rows where bioproject = "PRJNA631796", 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
8256524	8256524	PRJNA631796_P_NODE_11647_length_206_cov_2.717241_g11369_i0	PRJNA631796	11647	206	2.717241	5.59751646	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	213	7.81e-51	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g11369	i0	87.568	117.718446601942	185	22	90	1	15	199	5031575	5031758	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	24250	213	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
8256559	8256559	PRJNA631796_P_NODE_4227_length_337_cov_4.518116_g3949_i0	PRJNA631796	4227	337	4.518116	15.22605092	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	529	1.2099999999999994e-145	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g3949	i0	94.955	632.59940652819	337	17	100	0	1	337	5032456	5032120	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	213186	529	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
9531903	9531903	PRJNA631796_P_NODE_4188_length_339_cov_3.129496_g3910_i0	PRJNA631796	4188	339	3.129496	10.60899144	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	473	5.769999999999999e-129	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g3910	i0	92.262	212.654867256637	336	22	99	3	1	335	5033176	5032844	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	72090	473	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
12082842	12082842	PRJNA631796_P_NODE_5670_length_289_cov_2.692982_g5392_i0	PRJNA631796	5670	289	2.692982	7.78271798	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	427	3.8e-115	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g5392	i0	93.426	57.9550173010381	289	17	99	2	1	288	5032502	5032789	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	16749	427	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
24829628	24829628	PRJNA631796_P_NODE_10900_length_209_cov_2.283784_g10622_i0	PRJNA631796	10900	209	2.283784	4.77310856	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	233	6.1e-57	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g10622	i0	87.204	154.382775119617	211	20	99	5	3	209	5031498	5031291	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	32266	233	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);;