metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax_phylum = "Bdellovibrionota"

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
1441354	1441354	PRJNA1031674_P_NODE_15282_length_276_cov_1.517241_g15071_i0	PRJNA1031674	15282	276	1.517241	4.18758516	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	505	1.62e-138	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g15071	i0	99.638	2.17028985507246	276	1	100	0	1	276	908836	908561	Bdellovibrio exovorus JSS, complete genome	blastn	599	505	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
4835028	4835028	PRJNA1031674_P_NODE_6764_length_336_cov_4.190114_g6553_i0	PRJNA1031674	6764	336	4.190114	14.07878304	Bacteriovorax	146784	Bacteria	Bacteria	593	4.199999999999999e-165	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g6553	i0	98.516	20.0029761904762	337	4	100	1	1	336	1661943	1661607	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	6721	593	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
7819390	7819390	PRJNA1031674_P_NODE_227_length_1583_cov_3.896689_g134_i0	PRJNA1031674	227	1583	3.896689	61.68458687	Peredibacter starrii	28202	Bacteria	Bacteria	2710	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g134	i0	97.541	160.540113708149	1586	36	100	2	1	1583	512533	510948	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	254135	2710	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9934935	9934935	PRJNA1031674_P_NODE_228_length_1583_cov_3.749007_g134_i1	PRJNA1031674	228	1583	3.749007	59.34678081	Peredibacter	263370	Bacteria	Bacteria	2660	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g134	i1	96.974	155.871762476311	1586	45	100	2	1	1583	510948	512533	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	246745	2660	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10369828	10369828	PRJNA1031674_P_NODE_14589_length_278_cov_2.239024_g14378_i0	PRJNA1031674	14589	278	2.239024	6.22448672	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	206	1.86e-48	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g14378	i0	84.615	0.748201438848921	208	31	75	1	51	258	1458692	1458486	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	208	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
12920570	12920570	PRJNA1031674_P_NODE_4111_length_403_cov_1.166667_g3901_i0	PRJNA1031674	4111	403	1.166667	4.70166801	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	745	0	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g3901	i0	100	114.980148883375	403	0	100	0	1	403	1954736	1954334	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	46337	745	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13760062	13760062	PRJNA1031674_P_NODE_10691_length_291_cov_1.912844_g10480_i0	PRJNA1031674	10691	291	1.912844	5.56637604	Peredibacter	263370	Bacteria	Bacteria	141	5.590000000000001e-29	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g10480	i0	96.471	9.73539518900344	85	3	29	0	111	195	3531935	3532019	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	2833	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17584657	17584657	PRJNA1031674_P_NODE_18774_length_263_cov_2.647368_g18563_i0	PRJNA1031674	18774	263	2.647368	6.96257784	Bacteriovorax	146784	Bacteria	Bacteria	475	1.2e-129	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g18563	i0	99.24	176.498098859316	263	2	100	0	1	263	1662779	1662517	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	46419	475	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18018550	18018550	PRJNA1031674_P_NODE_21295_length_253_cov_4.888889_g21084_i0	PRJNA1031674	21295	253	4.888889	12.36888917	Peredibacter starrii	28202	Bacteria	Bacteria	316	7.37e-82	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g21084	i0	89.412	151.201581027668	255	22	100	5	1	253	510698	510949	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	38254	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19292534	19292534	PRJNA1031674_P_NODE_22576_length_250_cov_0.870056_g22365_i0	PRJNA1031674	22576	250	0.870056	2.17514	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	76.8	1.34e-9	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g22365	i0	91.071	0.224	56	5	22	0	1	56	3541646	3541591	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	56	76.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20567959	20567959	PRJNA1031674_P_NODE_28817_length_230_cov_2.942675_g28606_i0	PRJNA1031674	28817	230	2.942675	6.7681525	uncultured Bacteriovorax sp.	346638	Bacteria	Bacteria	414	2.27e-111	NTclustered	gi\|1268419624\|gb\|MG232182.1\|	346638	g28606	i0	99.13	99.9304347826087	230	2	100	0	1	230	418	189	Uncultured Bacteriovorax sp. clone WL140 16S ribosomal RNA gene, partial sequence	blastn	22984	414	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	uncultured Bacteriovorax sp.
24392725	24392725	PRJNA1031674_P_NODE_19000_length_263_cov_1.247368_g18789_i0	PRJNA1031674	19000	263	1.247368	3.28057784	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	220	6.22e-53	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g18789	i0	82.09	2.02281368821293	268	38	100	9	1	263	900511	900773	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	532	220	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198

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