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

12 rows where analysis = "blastn", bioproject = "PRJNA1182301" 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
318814	318814	PRJNA1182301_P_NODE_42921_length_258_cov_1.664865_g42796_i0	PRJNA1182301	42921	258	1.664865	4.2953517	Bacteriovorax stolpii	960	Bacteria	Bacteria	346	9.619999999999999e-91	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g42796	i0	91.016	2.96511627906977	256	23	99	0	3	258	3010722	3010467	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	765	346	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1593131	1593131	PRJNA1182301_P_NODE_31282_length_273_cov_2.140000_g31157_i0	PRJNA1182301	31282	273	2.14	5.8422	Bacteriovorax stolpii	960	Bacteria	Bacteria	348	2.85e-91	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g31157	i0	91.968	2.78021978021978	249	19	91	1	1	248	3733080	3732832	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	759	348	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1593392	1593392	PRJNA1182301_P_NODE_41602_length_260_cov_1.481283_g41477_i0	PRJNA1182301	41602	260	1.481283	3.8513358	Bacteriovorax stolpii	960	Bacteria	Bacteria	464	2.57e-126	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g41477	i0	98.846	770.953846153846	260	3	100	0	1	260	1661416	1661157	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	200448	464	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
1593474	1593474	PRJNA1182301_P_NODE_45222_length_255_cov_1.692308_g45097_i0	PRJNA1182301	45222	255	1.692308	4.3153854	Halobacteriovorax sp. BALOs_7	2109558	Bacteria	Bacteria	207	4.67e-49	NTclustered	gi\|1486380477\|gb\|CP027772.1\|	2109558	g45097	i0	84.112	0.83921568627451	214	34	84	0	12	225	2937959	2937746	Halobacteriovorax sp. BALOs_7 chromosome, complete genome	blastn	214	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp. BALOs_7
2869918	2869918	PRJNA1182301_P_NODE_59003_length_244_cov_0.900585_g58878_i0	PRJNA1182301	59003	244	0.900585	2.1974274	Bacteriovorax stolpii	960	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g58878	i0	92.623	3	244	18	100	0	1	244	1266802	1267045	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	732	351	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
4145367	4145367	PRJNA1182301_P_NODE_30464_length_274_cov_2.189055_g30339_i0	PRJNA1182301	30464	274	2.189055	5.9980107	Bacteriovorax stolpii	960	Bacteria	Bacteria	466	7.58e-127	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g30339	i0	97.445	3	274	5	100	2	1	274	3627202	3627473	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	822	466	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9246919	9246919	PRJNA1182301_P_NODE_54708_length_247_cov_0.885057_g54583_i0	PRJNA1182301	54708	247	0.885057	2.18609079	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	224	4.469999999999999e-54	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g54583	i0	83.065	1.00404858299595	248	40	100	2	1	247	2355275	2355521	Bacteriovorax sp. HI3 DNA, complete genome	blastn	248	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
16895709	16895709	PRJNA1182301_P_NODE_34734_length_269_cov_1.387755_g34609_i0	PRJNA1182301	34734	269	1.387755	3.73306095	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	492	1.23e-134	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g34609	i0	99.628	1	269	1	100	0	1	269	1881961	1881693	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	269	492	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18170521	18170521	PRJNA1182301_P_NODE_47595_length_252_cov_1.720670_g47470_i0	PRJNA1182301	47595	252	1.72067	4.3360884	Bacteriovorax stolpii	960	Bacteria	Bacteria	409	1.18e-109	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g47470	i0	96.016	1.99206349206349	251	10	99	0	2	252	2115309	2115559	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	502	409	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20168160	20168160	PRJNA1182301_P_NODE_64416_length_238_cov_2.909091_g64291_i0	PRJNA1182301	64416	238	2.909091	6.92363658	Bdellovibrionota	3018035	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2086745572\|gb\|MZ934718.1\|	959	g64291	i0	100	127.86974789916	238	0	100	0	1	238	122	359	Bdellovibrio bacteriovorus strain MK1 16S ribosomal RNA gene, partial sequence	blastn	30433	440	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21443290	21443290	PRJNA1182301_P_NODE_16537_length_300_cov_3.008811_g16412_i0	PRJNA1182301	16537	300	3.008811	9.026433	Peredibacter	263370	Bacteria	Bacteria	527	3.799999999999999e-145	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g16412	i0	98.333	178.813333333333	300	5	100	0	1	300	511508	511209	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	53644	527	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
21995040	21995040	PRJNA1182301_P_NODE_26078_length_280_cov_2.589372_g25953_i0	PRJNA1182301	26078	280	2.589372	7.2502416	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	289	1.81e-73	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g25953	i0	85.357	1	280	40	100	1	1	280	3823893	3824171	Bacteriovorax sp. HI3 DNA, complete genome	blastn	280	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3

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