metadata: contig_metadata: 14 rows where bioproject = "PRJNA946307", tax_kingdom = "Bacillati" and tax

14 rows where bioproject = "PRJNA946307", 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
3478168	3478168	PRJNA946307_P_NODE_52263_length_210_cov_3.180124_g51389_i0	PRJNA946307	52263	210	3.180124	6.6782604	Vulcanimicrobium alpinum	3016050	Bacteria	Bacteria	63.9	8.51e-6	NTclustered	gi\|2416250577\|dbj\|AP025523.1\|	3016050	g51389	i0	97.297	0.176190476190476	37	1	18	0	19	55	1470921	1470885	Vulcanimicrobium alpinum WC8-2 DNA, complete genome	blastn	37	63.9	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Vulcanimicrobium	Vulcanimicrobium alpinum
7304137	7304137	PRJNA946307_P_NODE_133026_length_169_cov_3.041667_g132152_i0	PRJNA946307	133026	169	3.041667	5.14041723	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	226	7.859999999999997e-55	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g132152	i0	92.903	602.378698224852	155	11	92	0	1	155	5033796	5033642	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	101802	226	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
9853956	9853956	PRJNA946307_P_NODE_125408_length_173_cov_1.346774_g124534_i0	PRJNA946307	125408	173	1.346774	2.32991902	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	65.8	1.87e-6	NTclustered	gi\|2874253878\|emb\|OY969933.1\|	3107663	g124534	i0	93.182	11.121387283237	44	3	25	0	113	156	2555097	2555054	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD05502.bin.c.2 genome assembly, chromosome: 1	blastn	1924	65.8	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
9854548	9854548	PRJNA946307_P_NODE_160108_length_162_cov_2.495575_g159234_i0	PRJNA946307	160108	162	2.495575	4.0428315	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	207	2.72e-49	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g159234	i0	92.414	80.4876543209877	145	11	90	0	4	148	5032338	5032194	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	13039	207	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
17505348	17505348	PRJNA946307_P_NODE_32454_length_229_cov_5.838889_g31580_i0	PRJNA946307	32454	229	5.838889	13.37105581	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	250	6.75e-62	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g31580	i0	88.018	257.205240174672	217	19	94	5	15	229	5031270	5031481	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	58900	250	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
17505353	17505353	PRJNA946307_P_NODE_32754_length_229_cov_0.850000_g31880_i0	PRJNA946307	32754	229	0.85	1.9465	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	261	3.12e-65	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g31880	i0	88.785	82.1834061135371	214	22	93	2	15	227	5032755	5032967	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	18820	261	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
21329031	21329031	PRJNA946307_P_NODE_24797_length_258_cov_3.344498_g23923_i0	PRJNA946307	24797	258	3.344498	8.62880484	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	298	2.73e-76	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g23923	i0	89.831	4.2093023255814	236	18	93	6	14	245	5032606	5032839	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	1086	298	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
25151925	25151925	PRJNA946307_P_NODE_11580_length_390_cov_6.108504_g10718_i0	PRJNA946307	11580	390	6.108504	23.8231656	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	198	4.52e-46	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g10718	i0	99.091	288.871794871795	110	1	51	0	4	113	5033699	5033590	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	112660	198	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
27057149	27057149	PRJNA946307_P_NODE_69682_length_199_cov_3.140000_g68808_i0	PRJNA946307	69682	199	3.14	6.2486	Candidatus Aquilonibacter sp.	2952903	Bacteria	Bacteria	84.3	4.6e-17	NR	HTU40945.1	2952903	g68808	i0	49.5	3.22613065326633	107	8	92	1	17	199	172	278	HTU40945.1 thiamine pyrophosphate-dependent enzyme [Candidatus Aquilonibacter sp.]	diamond	642	84.3	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Aquilonibacter	Candidatus Aquilonibacter sp.
27183376	27183376	PRJNA946307_P_NODE_89422_length_189_cov_1.385714_g88548_i0	PRJNA946307	89422	189	1.385714	2.61899946	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	123	7.149999999999999e-31	NR	HXX15427.1	3069296	g88548	i0	90	1.87301587301587	60	6	95.2	0	9	188	269	328	HXX15427.1 glycoside hydrolase family 127 protein [Candidatus Eremiobacteraceae bacterium]	diamond	354	123	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae		Candidatus Eremiobacteraceae bacterium
27373416	27373416	PRJNA946307_P_NODE_58023_length_210_cov_2.602484_g57149_i0	PRJNA946307	58023	210	2.602484	5.4652164	Candidatus Eremiobacteraceae bacterium	3069296	Bacteria	Bacteria	63.2	1.48e-9	NR	HZW94322.1	3069296	g57149	i0	68.5	0.771428571428571	54	17	77.1	0	209	48	89	142	HZW94322.1 GGDEF domain-containing protein [Candidatus Eremiobacteraceae bacterium]	diamond	162	63.2	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Candidatus Eremiobacterales	Candidatus Eremiobacteraceae		Candidatus Eremiobacteraceae bacterium
28572947	28572947	PRJNA946307_P_NODE_79427_length_194_cov_3.710345_g78553_i0	PRJNA946307	79427	194	3.710345	7.1980693	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	42	0.0148	NR	HMD01634.1	2952909	g78553	i0	32.7	0.850515463917526	55	33	85.1	1	28	192	8	58	HMD01634.1 hypothetical protein [Candidatus Baltobacteraceae bacterium]	diamond	165	42	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
32080059	32080059	PRJNA946307_P_NODE_116458_length_177_cov_1.273438_g115584_i0	PRJNA946307	116458	177	1.273438	2.25398526	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	53.9	1.69e-6	NR	HUD46661.1	2952909	g115584	i0	51.9	2.74576271186441	54	18	91.5	1	176	15	150	195	HUD46661.1 hypothetical protein [Candidatus Baltobacteraceae bacterium]	diamond	486	53.9	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
32396648	32396648	PRJNA946307_P_NODE_122319_length_174_cov_1.656000_g121445_i0	PRJNA946307	122319	174	1.656	2.88144	Candidatus Aquilonibacter sp.	2952903	Bacteria	Bacteria	106	2.31e-25	NR	HTV08331.1	2952903	g121445	i0	79.3	2	58	12	100	0	174	1	220	277	HTV08331.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Candidatus Aquilonibacter sp.]	diamond	348	106	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Aquilonibacter	Candidatus Aquilonibacter 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);;