metadata: contig_metadata: 14 rows where bioproject = "PRJNA734348" and tax

14 rows where bioproject = "PRJNA734348" 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
718899	718899	PRJNA734348_P_NODE_77941_length_262_cov_2.211640_g77243_i0	PRJNA734348	77941	262	2.21164	5.7944968	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	313	9.93e-81	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g77243	i0	89.37	248.423664122137	254	20	96	5	11	262	5031229	5031477	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	65087	313	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
7096783	7096783	PRJNA734348_P_NODE_36026_length_325_cov_1.595238_g35330_i0	PRJNA734348	36026	325	1.595238	5.1845235	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	145	4.9e-30	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g35330	i0	81.622	1.04923076923077	185	25	56	7	123	305	2483816	2483993	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	341	145	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
8371671	8371671	PRJNA734348_P_NODE_50387_length_289_cov_2.750000_g49690_i0	PRJNA734348	50387	289	2.75	7.9475	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	204	6.98e-48	NTclustered	gi\|2874253953\|emb\|OY970278.1\|	3107663	g49690	i0	80.287	93.8442906574394	279	47	95	8	3	277	1333877	1334151	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.10 genome assembly, chromosome: 1	blastn	27121	204	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
10922498	10922498	PRJNA734348_P_NODE_59969_length_279_cov_4.436893_g59272_i0	PRJNA734348	59969	279	4.436893	12.37893147	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	243	1.42e-59	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g59272	i0	82.562	137.928315412186	281	43	99	6	2	279	5032884	5033161	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	38482	243	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
11400534	11400534	PRJNA734348_P_NODE_110569_length_246_cov_1.774566_g109871_i0	PRJNA734348	110569	246	1.774566	4.36543236	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	119	5.98e-29	NR	MFA7482693.1	3107663	g109871	i0	77.8	0.98780487804878	81	18	98.8	0	3	245	592	672	MFA7482693.1 response regulator [Vulcanimicrobiota bacterium]	diamond	243	119	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
12197395	12197395	PRJNA734348_P_NODE_33830_length_335_cov_1.660305_g33134_i0	PRJNA734348	33830	335	1.660305	5.56202175	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	508	1.5599999999999999e-139	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g33134	i0	94.03	702.776119402985	335	20	100	0	1	335	5031990	5032324	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	235430	508	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
13470918	13470918	PRJNA734348_P_NODE_122671_length_243_cov_1.811765_g121973_i0	PRJNA734348	122671	243	1.811765	4.40258895	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	335	1.9399999999999993e-87	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g121973	i0	94.091	560.292181069959	220	13	91	0	24	243	5033534	5033753	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	136151	335	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
16021501	16021501	PRJNA734348_P_NODE_77633_length_262_cov_4.211640_g76935_i0	PRJNA734348	77633	262	4.21164	11.0344968	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	416	7.359999999999998e-112	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g76935	i0	95.753	215.667938931298	259	9	99	1	1	259	5032510	5032254	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	56505	416	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
21120416	21120416	PRJNA734348_P_NODE_25817_length_384_cov_3.028939_g25122_i0	PRJNA734348	25817	384	3.028939	11.63112576	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	580	3.7799999999999985e-161	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g25122	i0	94.01	189.75	384	21	99	2	1	383	5032428	5032810	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	72864	580	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
27368867	27368867	PRJNA734348_P_NODE_75103_length_265_cov_1.354167_g74405_i0	PRJNA734348	75103	265	1.354167	3.58854255	Candidatus Baltobacteraceae bacterium	3107660	Bacteria	Bacteria	129	2.31e-32	NR	HLI96883.1	2952909	g74405	i0	65.1	1.94716981132075	86	30	97.4	0	263	6	548	633	HLI96883.1 phosphoenolpyruvate synthase [Candidatus Baltobacteraceae bacterium]	diamond	516	129	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae		Candidatus Baltobacteraceae bacterium
28505173	28505173	PRJNA734348_P_NODE_79407_length_261_cov_1.627660_g78709_i0	PRJNA734348	79407	261	1.62766	4.2481926	Candidatus Cybelea sp.	2952917	Bacteria	Bacteria	50.1	3.31e-5	NR	HEV3091873.1	2952917	g78709	i0	36.8	1	87	47	95.4	3	2	250	54	136	HEV3091873.1 hypothetical protein [Candidatus Cybelea sp.]	diamond	261	50.1	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiia	Vulcanimicrobiales	Vulcanimicrobiaceae	Candidatus Cybelea	Candidatus Cybelea sp.
28537013	28537013	PRJNA734348_P_NODE_52307_length_287_cov_2.817757_g51610_i0	PRJNA734348	52307	287	2.817757	8.08696259	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	81.3	1.1e-15	NR	MFA7481575.1	3107663	g51610	i0	50	1.71428571428571	82	41	85.7	0	35	280	9	90	MFA7481575.1 3-dehydroquinate synthase [Vulcanimicrobiota bacterium]	diamond	492	81.3	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
30242079	30242079	PRJNA734348_P_NODE_110592_length_246_cov_1.774566_g109894_i0	PRJNA734348	110592	246	1.774566	4.36543236	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	94.7	2.95e-21	NR	MFA5503843.1	3107663	g109894	i0	57.3	1.96341463414634	82	34	98.8	1	244	2	139	220	MFA5503843.1 hypothetical protein [Vulcanimicrobiota bacterium]	diamond	483	94.7	1	Bacteria	Bacillati	Vulcanimicrobiota					Vulcanimicrobiota bacterium
30684191	30684191	PRJNA734348_P_NODE_113593_length_246_cov_0.890173_g112895_i0	PRJNA734348	113593	246	0.890173	2.18982558	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	73.9	2.9e-13	NR	MFA7482532.1	3107663	g112895	i0	75	0.536585365853659	44	11	53.7	0	242	111	312	355	MFA7482532.1 AmmeMemoRadiSam system protein B [Vulcanimicrobiota bacterium]	diamond	132	73.9	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);;