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

5 rows where bioproject = "PRJNA741997", 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_species
12200909	12200909	PRJNA741997_P_NODE_51110_length_301_cov_1.583333_g49990_i0	PRJNA741997	51110	301	1.583333	4.76583233	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	217	9.39e-52	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g49990	i0	86.275	3.29235880398671	204	22	67	5	97	299	5032821	5032623	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	991	217	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
12200935	12200935	PRJNA741997_P_NODE_57090_length_284_cov_1.483412_g55970_i0	PRJNA741997	57090	284	1.483412	4.21289008	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	91.3	2.32e-19	NR	HYK38750.1	3069296	g55970	i0	44.2	11.1971830985915	95	48	95.1	1	15	284	112	206	HYK38750.1 NAD(P)-dependent alcohol dehydrogenase [Candidatus Eremiobacteraceae bacterium]	diamond	3180	91.3	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae	Candidatus Eremiobacteraceae bacterium
26894597	26894597	PRJNA741997_P_NODE_73841_length_250_cov_0.870056_g72721_i0	PRJNA741997	73841	250	0.870056	2.17514	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	73.6	5.78e-13	NR	HEY3999646.1	3036772	g72721	i0	50.6	1.98	83	36	93.6	1	1	234	299	381	HEY3999646.1 VIT domain-containing protein [Candidatus Xenobia bacterium]	diamond	495	73.6	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia			Candidatus Xenobia bacterium
27337160	27337160	PRJNA741997_P_NODE_69303_length_256_cov_1.683060_g68183_i0	PRJNA741997	69303	256	1.68306	4.3086336	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	43.5	0.0236	NR	MFA5507321.1	3107663	g68183	i0	30.3	1.78125	76	49	84.4	1	34	249	372	447	MFA5507321.1 hypothetical protein [Vulcanimicrobiota bacterium]	diamond	456	43.5	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
32833733	32833733	PRJNA741997_P_NODE_72600_length_251_cov_0.865169_g71480_i0	PRJNA741997	72600	251	0.865169	2.17157419	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	73.6	1.02e-13	NR	HZW94491.1	3069296	g71480	i0	53.1	1.9840637450199201	81	30	87.3	1	249	31	133	213	HZW94491.1 hypothetical protein [Candidatus Eremiobacteraceae bacterium]	diamond	498	73.6	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae	Candidatus Eremiobacteraceae 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);;