metadata: contig_metadata: 7 rows where bioproject = "PRJNA382357", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJNA382357", 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
402666	402666	PRJNA382357_P_NODE_125441_length_218_cov_2.038217_g124702_i0	PRJNA382357	125441	218	2.038217	4.44331306	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	150	6.64e-32	NTclustered	gi\|2874253953\|emb\|OY970278.1\|	3107663	g124702	i0	84.277	71.7477064220184	159	20	72	4	1	157	2017409	2017254	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.10 genome assembly, chromosome: 1	blastn	15641	150	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
26807294	26807294	PRJNA382357_P_NODE_54361_length_316_cov_3.407843_g53622_i0	PRJNA382357	54361	316	3.407843	10.76878388	Bacteria	2	Bacteria	Bacteria	135	1.93e-37	NR	HTA56945.1	2952909	g53622	i0	98.6	3.46518987341772	73	1	69.3	0	274	56	126	198	HTA56945.1 SDR family oxidoreductase [Candidatus Baltobacteraceae bacterium]	diamond	1095	135	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
27738799	27738799	PRJNA382357_P_NODE_169344_length_173_cov_19.625000_g168605_i0	PRJNA382357	169344	173	19.625	33.95125	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	47.4	8.32e-5	NR	MFA5508803.1	3107663	g168605	i0	63.6	0.572254335260116	33	12	57.2	0	15	113	84	116	MFA5508803.1 hypothetical protein [Vulcanimicrobiota bacterium]	diamond	99	47.4	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
28022773	28022773	PRJNA382357_P_NODE_160605_length_194_cov_2.819549_g159866_i0	PRJNA382357	160605	194	2.819549	5.46992506	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	60.8	7.85e-9	NR	HTA60608.1	2952909	g159866	i0	74.3	0.541237113402062	35	9	54.1	0	51	155	51	85	HTA60608.1 uroporphyrinogen-III C-methyltransferase [Candidatus Baltobacteraceae bacterium]	diamond	105	60.8	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
28923513	28923513	PRJNA382357_P_NODE_104988_length_237_cov_1.136364_g104249_i0	PRJNA382357	104988	237	1.136364	2.69318268	Bacillati	1783272	Bacteria	Bacteria	49.3	1.46e-4	NR	HVO02611.1	2952917	g104249	i0	70.4	1.0379746835443	27	8	34.2	0	112	192	232	258	HVO02611.1 methyltransferase domain-containing protein [Candidatus Cybelea sp.]	diamond	246	49.7	0.991951710261569	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
29096238	29096238	PRJNA382357_P_NODE_123088_length_220_cov_3.012579_g122349_i0	PRJNA382357	123088	220	3.012579	6.6276738	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	89.4	1.09e-18	NR	HTA57045.1	2952909	g122349	i0	87.8	0.668181818181818	49	6	66.8	0	147	1	592	640	HTA57045.1 hypothetical protein [Candidatus Baltobacteraceae bacterium]	diamond	147	89.4	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
30485877	30485877	PRJNA382357_P_NODE_41553_length_356_cov_4.054237_g40814_i0	PRJNA382357	41553	356	4.054237	14.43308372	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	110	5.0100000000000005e-27	NR	MFA5507260.1	3107663	g40814	i0	67.5	0.699438202247191	83	19	69.1	2	106	351	143	218	MFA5507260.1 hypothetical protein [Vulcanimicrobiota bacterium]	diamond	249	110	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);;