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

5 rows where bioproject = "PRJNA437204", 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
18284593	18284593	PRJNA437204_P_NODE_61735_length_278_cov_1.390244_g61436_i0	PRJNA437204	61735	278	1.390244	3.86487832	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	370	6.219999999999999e-98	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g61436	i0	90.714	12.0431654676259	280	22	100	4	1	278	5032663	5032940	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	3348	370	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
24659333	24659333	PRJNA437204_P_NODE_65080_length_272_cov_2.020101_g64781_i0	PRJNA437204	65080	272	2.020101	5.49467472	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	351	2.1999999999999995e-92	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g64781	i0	90.602	429.0625	266	24	97	1	8	272	5033458	5033723	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	116705	351	1	Bacteria	Bacillati	Vulcanimicrobiota				Vulcanimicrobiota bacterium
27644759	27644759	PRJNA437204_P_NODE_100604_length_247_cov_0.885057_g100305_i0	PRJNA437204	100604	247	0.885057	2.18609079	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	53.9	4.34e-6	NR	HEY3997549.1	3036772	g100305	i0	36.5	1.68825910931174	74	46	88.7	1	219	1	239	312	HEY3997549.1 cyclic nucleotide-binding domain-containing protein [Candidatus Xenobia bacterium]	diamond	417	53.9	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia			Candidatus Xenobia bacterium
27802565	27802565	PRJNA437204_P_NODE_40724_length_322_cov_2.028112_g40425_i0	PRJNA437204	40724	322	2.028112	6.53052064	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	44.3	0.0269	NR	HZW93355.1	3069296	g40425	i0	26.9	0.968944099378882	104	70	93.2	2	17	316	160	261	HZW93355.1 discoidin domain-containing protein [Candidatus Eremiobacteraceae bacterium]	diamond	312	44.3	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae	Candidatus Eremiobacteraceae bacterium
31055645	31055645	PRJNA437204_P_NODE_12895_length_486_cov_1.491525_g12597_i0	PRJNA437204	12895	486	1.491525	7.2488115	Candidatus Xenobia bacterium	3036772	Bacteria	Bacteria	72	3.39e-11	NR	GMU56021.1	3036772	g12597	i0	38	1.62962962962963	142	73	87.7	5	4	429	741	867	GMU56021.1 MAG: hypothetical protein AMXMBFR33_51670 [Candidatus Xenobia bacterium]	diamond	792	72	1	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia			Candidatus Xenobia 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);;