metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
588793	588793	PRJNA611476_P_NODE_10041_length_615_cov_2.306273_g9257_i0	PRJNA611476	10041	615	2.306273	14.18357895	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	56.5	0.005	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g9257	i0	100	0.0487804878048781	30	0	5	0	287	316	3579094	3579065	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
1865678	1865678	PRJNA611476_P_NODE_62062_length_281_cov_1.480769_g61271_i0	PRJNA611476	62062	281	1.480769	4.16096089	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	427	3.68e-115	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g61271	i0	93.993	230.081850533808	283	15	100	2	1	281	612904	613186	Bdellovibrio bacteriovorus W, complete genome	blastn	64653	427	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
3140078	3140078	PRJNA611476_P_NODE_20443_length_441_cov_1.255435_g19652_i0	PRJNA611476	20443	441	1.255435	5.53646835	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	749	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g19652	i0	97.279	139.097505668934	441	12	100	0	1	441	1292305	1292745	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	61342	749	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
4417445	4417445	PRJNA611476_P_NODE_71504_length_263_cov_2.210526_g70713_i0	PRJNA611476	71504	263	2.210526	5.81368338	Bacteriovorax stolpii	960	Bacteria	Bacteria	448	2.6199999999999995e-121	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g70713	i0	97.338	3	263	7	100	0	1	263	411183	411445	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	789	448	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
5693682	5693682	PRJNA611476_P_NODE_86545_length_249_cov_0.875000_g85754_i0	PRJNA611476	86545	249	0.875	2.17875	Halobacteriovorax sp. BALOs_7	2109558	Bacteria	Bacteria	87.9	6.18e-13	NTclustered	gi\|1486380477\|gb\|CP027772.1\|	2109558	g85754	i0	86.585	20.5301204819277	82	8	33	3	169	249	250327	250248	Halobacteriovorax sp. BALOs_7 chromosome, complete genome	blastn	5112	87.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp. BALOs_7
8801045	8801045	PRJNA611476_P_NODE_69627_length_267_cov_1.546392_g68836_i0	PRJNA611476	69627	267	1.546392	4.12886664	Bdellovibrio	958	Bacteria	Bacteria	353	5.98e-93	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g68836	i0	90.672	148.767790262172	268	21	99	3	1	266	783121	783386	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	39721	353	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11351836	11351836	PRJNA611476_P_NODE_97369_length_246_cov_0.890173_g96578_i0	PRJNA611476	97369	246	0.890173	2.18982558	Pseudobdellovibrio	2862745	Bacteria	Bacteria	350	7.04e-92	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g96578	i0	92.917	82.020325203252	240	17	98	0	7	246	1440	1679	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	20177	350	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15891881	15891881	PRJNA611476_P_NODE_109373_length_243_cov_0.905882_g108582_i0	PRJNA611476	109373	243	0.905882	2.20129326	Bacteriovorax stolpii	960	Bacteria	Bacteria	390	4.089999999999999e-104	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g108582	i0	95.51	2.97942386831276	245	9	100	1	1	243	449778	449534	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	724	390	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
19716656	19716656	PRJNA611476_P_NODE_90636_length_248_cov_0.880000_g89845_i0	PRJNA611476	90636	248	0.88	2.1824	Bdellovibrio sp. SKB1291214	1732569	Bacteria	Bacteria	171	5.94e-38	NTclustered	gi\|2328635023\|gb\|CP106855.1\|	1732569	g89845	i0	79.828	0.939516129032258	233	47	94	0	3	235	1744152	1744384	Bdellovibrio sp. SKB1291214 chromosome, complete genome	blastn	233	171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
24099859	24099859	PRJNA611476_P_NODE_51279_length_304_cov_3.770563_g50488_i0	PRJNA611476	51279	304	3.770563	11.46251152	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g50488	i0	97.059	4.83881578947368	34	0	11	1	3	35	406674	406707	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1471	56.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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