metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA704949" 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_species
691415	691415	PRJNA704949_P_NODE_1682141_length_186_cov_1.605839_g1666802_i0	PRJNA704949	1682141	186	1.605839	2.98686054	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	196	6.94e-46	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1666802	i0	86.517	0.956989247311828	178	24	96	0	9	186	6221957	6221780	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	178	196	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
1968474	1968474	PRJNA704949_P_NODE_18082_length_2104_cov_34.877372_g10864_i0	PRJNA704949	18082	2104	34.877372	733.81990688	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	1725	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g10864	i0	82.636	662.975285171103	2033	273	95	70	110	2104	5031228	5033218	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	1394900	1725	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
4518138	4518138	PRJNA704949_P_NODE_149124_length_663_cov_1.970684_g135685_i0	PRJNA704949	149124	663	1.970684	13.06563492	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	411	9.450000000000001e-110	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g135685	i0	78.281	0.965309200603318	640	137	96	2	22	660	9177965	9178603	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	640	411	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
5796833	5796833	PRJNA704949_P_NODE_1912565_length_170_cov_1.247934_g1897226_i0	PRJNA704949	1912565	170	1.247934	2.1214878	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	58.4	3.06e-4	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1897226	i0	90.909	0.258823529411765	44	3	25	1	102	144	8595825	8595782	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	44	58.4	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
7080909	7080909	PRJNA704949_P_NODE_962026_length_266_cov_2.875576_g946691_i0	PRJNA704949	962026	266	2.875576	7.64903216	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	147	1.08e-30	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g946691	i0	79.167	0.81203007518797	216	42	80	3	45	258	6018100	6017886	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	216	147	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
8340850	8340850	PRJNA704949_P_NODE_1212107_length_231_cov_0.967033_g1196770_i0	PRJNA704949	1212107	231	0.967033	2.23384623	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	178	3.26e-40	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1196770	i0	80.603	3.59307359307359	232	43	100	2	1	231	5303726	5303496	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	830	178	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
9624873	9624873	PRJNA704949_P_NODE_295248_length_494_cov_3.022472_g280466_i0	PRJNA704949	295248	494	3.022472	14.93101168	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	348	5.49e-91	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g280466	i0	79.678	58.4615384615385	497	89	99	10	4	494	363834	363344	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	28880	348	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
10892154	10892154	PRJNA704949_P_NODE_1256369_length_225_cov_2.545455_g1241032_i0	PRJNA704949	1256369	225	2.545455	5.72727375	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	174	4.09e-39	NTclustered	gi\|2874253821\|emb\|OY969805.1\|	3107663	g1241032	i0	83.957	47.0755555555556	187	25	82	5	2	185	2411506	2411322	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.12 genome assembly, chromosome: 1	blastn	10592	174	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
10898272	10898272	PRJNA704949_P_NODE_2021909_length_166_cov_1.333333_g2006570_i0	PRJNA704949	2021909	166	1.333333	2.21333278	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2874253986\|emb\|OY970311.1\|	3107663	g2006570	i0	100	0.168674698795181	28	0	17	0	26	53	755936	755909	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD04463.bin.c.13 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
12175576	12175576	PRJNA704949_P_NODE_283930_length_503_cov_2.129956_g269208_i0	PRJNA704949	283930	503	2.129956	10.71367868	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	233	1.6399999999999998e-56	NTclustered	gi\|2874253918\|emb\|OY970243.1\|	3107663	g269208	i0	82.836	0.532803180914513	268	38	52	6	3	263	229673	229407	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD09603.bin.1.33 genome assembly, chromosome: 1	blastn	268	233	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
14730877	14730877	PRJNA704949_P_NODE_920592_length_274_cov_1.173333_g905258_i0	PRJNA704949	920592	274	1.173333	3.21493242	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	189	1.84e-43	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g905258	i0	82.629	1.67153284671533	213	37	78	0	62	274	7673447	7673235	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	458	189	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
18540150	18540150	PRJNA704949_P_NODE_129935_length_702_cov_2.966309_g116828_i0	PRJNA704949	129935	702	2.966309	20.82348918	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	654	0	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g116828	i0	85.008	85.8789173789174	647	93	92	4	40	684	362962	363606	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	60287	654	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
18547751	18547751	PRJNA704949_P_NODE_269735_length_515_cov_1.450644_g255082_i0	PRJNA704949	269735	515	1.450644	7.4708166	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	316	1.6199999999999996e-81	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g255082	i0	78.763	48.8601941747573	485	93	93	7	32	511	818829	818350	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	25163	316	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
19814094	19814094	PRJNA704949_P_NODE_1148196_length_239_cov_1.094737_g1132860_i0	PRJNA704949	1148196	239	1.094737	2.61642143	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	189	1.5699999999999996e-43	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1132860	i0	85.246	62.7280334728033	183	27	77	0	27	209	3278398	3278580	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	14992	189	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
19814592	19814592	PRJNA704949_P_NODE_1209776_length_231_cov_1.329670_g1194439_i0	PRJNA704949	1209776	231	1.32967	3.0715377	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	148	2.5599999999999997e-31	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1194439	i0	81.967	0.792207792207792	183	25	77	7	3	181	2034146	2033968	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	183	148	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
21091745	21091745	PRJNA704949_P_NODE_140957_length_679_cov_1.722222_g127650_i0	PRJNA704949	140957	679	1.722222	11.69388738	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	446	2.66e-120	NTclustered	gi\|2874254010\|emb\|OY970335.1\|	3107663	g127650	i0	79.336	61.0544918998527	663	115	96	20	9	660	47885	47234	MAG: Candidatus Eremiobacteraeota bacterium isolate MFD10064.bin.c.2 genome assembly, chromosome: 1	blastn	41456	446	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
21101142	21101142	PRJNA704949_P_NODE_549437_length_367_cov_1.808176_g534131_i0	PRJNA704949	549437	367	1.808176	6.63600592	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	326	1.86e-84	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g534131	i0	84.226	71.3079019073569	336	52	92	1	3	338	9164566	9164232	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	26170	326	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
21101796	21101796	PRJNA704949_P_NODE_624357_length_343_cov_1.591837_g609032_i0	PRJNA704949	624357	343	1.591837	5.46000091	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	150	1.12e-31	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g609032	i0	80.093	37.5072886297376	216	31	61	11	9	217	965820	966030	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	12865	150	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
22369458	22369458	PRJNA704949_P_NODE_1770798_length_180_cov_0.877863_g1755459_i0	PRJNA704949	1770798	180	0.877863	1.5801534	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	165	1.88e-36	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g1755459	i0	85.443	0.877777777777778	158	23	88	0	23	180	2033718	2033561	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	158	165	1	Bacteria	Bacillati	Vulcanimicrobiota	Vulcanimicrobiota bacterium
22379690	22379690	PRJNA704949_P_NODE_949098_length_269_cov_1.163636_g933763_i0	PRJNA704949	949098	269	1.163636	3.13018084	Vulcanimicrobiota bacterium	3107663	Bacteria	Bacteria	239	1.7600000000000003e-58	NTclustered	gi\|2202949261\|emb\|OV972893.1\|	3107663	g933763	i0	83.333	66.3754646840149	258	43	96	0	1	258	8111873	8111616	MAG: Candidatus Eremiobacteraeota bacterium isolate E.malaspinii_MAG_MP1648_PBLIHF genome assembly, chromosome: 1	blastn	17855	239	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);;