metadata: contig_metadata: 9 rows where bioproject = "PRJNA1160211" and tax

9 rows where bioproject = "PRJNA1160211" 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_order	tax_family	tax_genus	tax_species
7963449	7963449	PRJNA1160211_S_NODE_274147_length_245_cov_4.424419_g272914_i0	PRJNA1160211	274147	245	4.424419	10.83982655	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g272914	i0	94.196	182.604081632653	224	9	91	4	23	245	5032351	5032571	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	44738	339	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
10513135	10513135	PRJNA1160211_S_NODE_158389_length_363_cov_2.962069_g157156_i0	PRJNA1160211	158389	363	2.962069	10.75231047	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	527	4.6899999999999984e-145	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g157156	i0	94.737	83.9834710743802	342	13	94	5	24	363	5031380	5031718	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	30486	527	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
15612738	15612738	PRJNA1160211_S_NODE_23593_length_686_cov_27.264274_g22553_i0	PRJNA1160211	23593	686	27.264274	187.03291964	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	210	2.48e-60	NR	HYM33218.1	2952917	g22553	i0	58.4	0.756559766763848	173	71	75.7	1	168	686	24	195	HYM33218.1 ABC transporter ATP-binding protein/permease [Candidatus Cybelea sp.]	diamond	519	210	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
15612979	15612979	PRJNA1160211_S_NODE_273_length_2023_cov_21.466667_g194_i0	PRJNA1160211	273	2023	21.466667	434.27067341	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1698	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g194	i0	82.283	701.39446366782	2032	294	99	60	1	2000	5033227	5031230	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	1418921	1698	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
16887366	16887366	PRJNA1160211_S_NODE_274_length_2023_cov_14.342051_g194_i1	PRJNA1160211	274	2023	14.342051	290.13969173	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1714	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g194	i1	82.448	675.260998517054	2034	287	99	64	1	2000	5033227	5031230	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	1366053	1714	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
19435232	19435232	PRJNA1160211_S_NODE_142756_length_385_cov_4.842949_g141523_i0	PRJNA1160211	142756	385	4.842949	18.64535365	Vulcanimicrobium alpinum	3016050	Bacteria	Bacteria	158	7.57e-34	NTclustered	gi\|2416250577\|dbj\|AP025523.1\|	3016050	g141523	i0	79.583	90.1038961038961	240	33	60	11	71	302	1949920	1950151	Vulcanimicrobium alpinum WC8-2 DNA, complete genome	blastn	34690	158	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Vulcanimicrobium	Vulcanimicrobium alpinum
23261642	23261642	PRJNA1160211_S_NODE_168939_length_348_cov_31.440000_g167706_i0	PRJNA1160211	168939	348	31.44	109.4112	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	285	2.99e-72	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g167706	i0	82.822	110.41091954023	326	48	93	7	26	347	5031453	5031774	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	38423	285	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
29914229	29914229	PRJNA1160211_S_NODE_17991_length_724_cov_23.887865_g17029_i0	PRJNA1160211	17991	724	23.887865	172.9481426	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	258	4.24e-84	NR	MFA5505376.1	3107663	g17029	i0	72	0.75414364640884	182	51	75.4	0	552	7	1	182	MFA5505376.1 50S ribosomal protein L10 [Vulcanimicrobiota bacterium]	diamond	546	258	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
32821639	32821639	PRJNA1160211_S_NODE_277380_length_244_cov_0.900585_g276147_i0	PRJNA1160211	277380	244	0.900585	2.1974274	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	59.7	1.41e-9	NR	HVA28692.1	2952909	g276147	i0	51.4	0.885245901639344	72	33	86.1	1	219	10	2	73	HVA28692.1 type II toxin-antitoxin system VapB family antitoxin [Candidatus Baltobacteraceae bacterium]	diamond	216	59.7	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae 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);;