metadata: contig_metadata: 8 rows where bioproject = "PRJNA1233465", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA1233465", 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
25825403	25825403	PRJNA1233465f_S_NODE_145291_length_203_cov_2.233766_g143011_i0	PRJNA1233465	145291	203	2.233766	4.53454498	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	132	2.21e-26	NTclustered	gi\|2874253821\|emb\|OY969805.1\|	3107663	g143011	i0	79.891	2.10344827586207	184	33	90	3	4	185	39355	39174	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.12 genome assembly, chromosome: 1	blastn	427	132	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
25969057	25969057	PRJNA1233465f_S_NODE_76012_length_268_cov_2.511416_g73732_i0	PRJNA1233465	76012	268	2.511416	6.73059488	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	144	1.19e-40	NR	HVO01641.1	2952917	g73732	i0	79.5	1.97014925373134	88	18	98.5	0	4	267	96	183	HVO01641.1 EcsC family protein [Candidatus Cybelea sp.]	diamond	528	144	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
26081049	26081049	PRJNA1233465b_S_NODE_142773_length_240_cov_2.937173_g141088_i0	PRJNA1233465	142773	240	2.937173	7.0492152	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	235	1.9999999999999996e-57	NTclustered	gi\|2874253918\|emb\|OY970243.1\|	3107663	g141088	i0	85.043	89.4958333333333	234	31	97	4	9	240	157687	157918	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1	blastn	21479	235	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
33035709	33035709	PRJNA1233465e_S_NODE_138668_length_169_cov_1.025000_g137358_i0	PRJNA1233465	138668	169	1.025	1.73225	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	51.2	1.4e-5	NR	HTX16018.1	2952909	g137358	i0	77.4	1.10059171597633	31	7	55	0	169	77	103	133	HTX16018.1 acyltransferase [Candidatus Baltobacteraceae bacterium]	diamond	186	51.2	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
33043257	33043257	PRJNA1233465d_S_NODE_52772_length_238_cov_0.973545_g51661_i0	PRJNA1233465	52772	238	0.973545	2.3170371	Bacillati	1783272	Bacteria	Bacteria	44.7	0.00757	NR	HEY4000542.1	3036772	g51661	i0	48.7	2.07983193277311	39	20	49.2	0	118	2	527	565	HEY4000542.1 ATP-binding protein [Candidatus Xenobia bacterium]	diamond	495	45.1	0.991130820399113	Bacteria	Bacillati	Vulcanimicrobiota	Candidatus Xenobia				Candidatus Xenobia bacterium
33069260	33069260	PRJNA1233465d_S_NODE_151093_length_152_cov_2.252427_g149982_i0	PRJNA1233465	151093	152	2.252427	3.42368904	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	79.7	2.97e-16	NR	HVO01641.1	2952917	g149982	i0	76	0.986842105263158	50	12	98.7	0	2	151	134	183	HVO01641.1 EcsC family protein [Candidatus Cybelea sp.]	diamond	150	79.7	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
33103758	33103758	PRJNA1233465d_S_NODE_70614_length_210_cov_2.217391_g69503_i0	PRJNA1233465	70614	210	2.217391	4.6565211	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	77	3.06e-15	NR	HVO02740.1	2952917	g69503	i0	81.3	0.685714285714286	48	9	68.6	0	209	66	172	219	HVO02740.1 response regulator [Candidatus Cybelea sp.]	diamond	144	77	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
33103957	33103957	PRJNA1233465e_S_NODE_123574_length_177_cov_1.187500_g122264_i0	PRJNA1233465	123574	177	1.1875	2.101875	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	87	7.05e-19	NR	HVO01641.1	2952917	g122264	i0	76.4	0.932203389830508	55	13	93.2	0	11	175	137	191	HVO01641.1 EcsC family protein [Candidatus Cybelea sp.]	diamond	165	87	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.

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);;