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

5 rows where bioproject = "PRJNA1120060", 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_order	tax_family	tax_genus	tax_species
9174184	9174184	PRJNA1120060_P_NODE_20468_length_1054_cov_26.610601_g13334_i0	PRJNA1120060	20468	1054	26.610601	280.47573454	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1040	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g13334	i0	84.843	336.823529411765	1049	141	99	18	1	1040	5031447	5032486	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	355012	1040	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
14292304	14292304	PRJNA1120060_P_NODE_3470312_length_209_cov_6.448529_g3452186_i0	PRJNA1120060	3470312	209	6.448529	13.47742561	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	65.8	2.35e-6	NTclustered	gi\|2874253737\|emb\|OY969579.1\|	3107663	g3452186	i0	95.238	0.363636363636364	42	1	20	1	136	177	2533218	2533258	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD01689.bin.c.2 genome assembly, chromosome: 1	blastn	76	65.8	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
28204916	28204916	PRJNA1120060_P_NODE_1037306_length_311_cov_6.205882_g1019371_i0	PRJNA1120060	1037306	311	6.205882	19.30029302	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	65.5	8.74e-10	NR	MFA5507638.1	3107663	g1019371	i0	54	0.482315112540193	50	23	48.2	0	1	150	133	182	MFA5507638.1 hypothetical protein [Vulcanimicrobiota bacterium]	diamond	150	65.5	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
31269537	31269537	PRJNA1120060_P_NODE_2123075_length_268_cov_1.338462_g2105031_i0	PRJNA1120060	2123075	268	1.338462	3.58707816	Candidatus Aquilonibacter sp.	2952903	Bacteria	Bacteria	43.1	0.0379	NR	HUA01760.1	2952903	g2105031	i0	37.8	0.828358208955224	74	45	82.8	1	234	13	14	86	HUA01760.1 AsmA family protein [Candidatus Aquilonibacter sp.]	diamond	222	43.1	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Aquilonibacter	Candidatus Aquilonibacter sp.
31713170	31713170	PRJNA1120060_P_NODE_3425057_length_213_cov_10.221429_g3406933_i0	PRJNA1120060	3425057	213	10.221429	21.77164377	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	42.7	0.022	NR	HTX52898.1	2952909	g3406933	i0	38.5	0.915492957746479	65	36	91.5	2	11	205	60	120	HTX52898.1 tetratricopeptide repeat protein [Candidatus Baltobacteraceae bacterium]	diamond	195	42.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);;