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

5 rows where bioproject = "PRJNA560932", 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_class	tax_species
13298922	13298922	PRJNA560932_P_NODE_66411_length_241_cov_0.916667_g66055_i0	PRJNA560932	66411	241	0.916667	2.20916747	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	357	4.1099999999999997e-94	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g66055	i0	93.361	612.834024896266	241	16	100	0	1	241	5032048	5032288	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	147693	357	1	Bacteria	Bacillati	Vulcanimicrobiota		Vulcanimicrobiota bacterium
20946589	20946589	PRJNA560932_P_NODE_11697_length_510_cov_3.544622_g11343_i0	PRJNA560932	11697	510	3.544622	18.0775722	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	333	1.59e-86	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g11343	i0	78.967	110.094117647059	523	84	100	25	1	510	5033162	5032653	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	56148	333	1	Bacteria	Bacillati	Vulcanimicrobiota		Vulcanimicrobiota bacterium
27332047	27332047	PRJNA560932_P_NODE_22863_length_371_cov_1.020134_g22507_i0	PRJNA560932	22863	371	1.020134	3.78469714	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	56.6	2.14e-6	NR	HEY3999186.1	3036772	g22507	i0	36.8	0.768194070080862	95	59	76.8	1	30	314	551	644	HEY3999186.1 hypothetical protein [Candidatus Xenobia bacterium]	diamond	285	56.6	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia	Candidatus Xenobia bacterium
31184635	31184635	PRJNA560932_P_NODE_66215_length_241_cov_1.375000_g65859_i0	PRJNA560932	66215	241	1.375	3.31375	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	41.6	0.0459	NR	GMU57807.1	3036772	g65859	i0	39.1	0.796680497925311	64	36	75.9	1	197	15	79	142	GMU57807.1 MAG: hypothetical protein AMXMBFR33_69530 [Candidatus Xenobia bacterium]	diamond	192	41.6	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia	Candidatus Xenobia bacterium
32891500	32891500	PRJNA560932_P_NODE_59240_length_246_cov_0.890173_g58884_i0	PRJNA560932	59240	246	0.890173	2.18982558	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	134	1.13e-34	NR	MFA5507019.1	3107663	g58884	i0	71.6	2.91463414634146	81	22	98.8	1	244	2	270	349	MFA5507019.1 phosphoenolpyruvate carboxykinase (ATP) [Vulcanimicrobiota bacterium]	diamond	717	134	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);;