metadata: contig_metadata: 12 rows where bioproject = "PRJNA674048", tax_phylum = "Bdellovibrionota" and tax

12 rows where bioproject = "PRJNA674048", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
2441320	2441320	PRJNA674048_P_NODE_23382_length_182_cov_1.496241_g23179_i0	PRJNA674048	23382	182	1.496241	2.72315862	Micavibrio	213485	Bacteria	Bacteria	209	8.68e-50	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g23179	i0	87.634	319.291208791209	186	16	100	6	1	182	463006	462824	Micavibrio aeruginosavorus EPB, complete genome	blastn	58111	209	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
3193978	3193978	PRJNA674048_P_NODE_23083_length_183_cov_1.552239_g22880_i0	PRJNA674048	23083	183	1.552239	2.84059737	Bdellovibrio reynosensis	2835041	Bacteria	Bacteria	150	5.37e-32	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g22880	i0	81.667	0.983606557377049	180	33	98	0	2	181	375524	375703	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	180	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
7021746	7021746	PRJNA674048_P_NODE_27006_length_169_cov_0.866667_g26803_i0	PRJNA674048	27006	169	0.866667	1.46466723	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	87.9	3.87e-13	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g26803	i0	94.737	1.06508875739645	57	2	34	1	113	169	730199	730144	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	180	87.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
13920062	13920062	PRJNA674048_P_NODE_32051_length_163_cov_0.912281_g31848_i0	PRJNA674048	32051	163	0.912281	1.48701803	Bdellovibrio	958	Bacteria	Bacteria	196	5.93e-46	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g31848	i0	88.75	8.29447852760736	160	18	98	0	1	160	2699265	2699424	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	1352	196	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
20292495	20292495	PRJNA674048_P_NODE_26976_length_169_cov_0.866667_g26773_i0	PRJNA674048	26976	169	0.866667	1.46466723	Bdellovibrio	958	Bacteria	Bacteria	169	1.34e-37	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g26773	i0	86.755	8.10650887573964	151	20	89	0	19	169	4059767	4059617	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1370	169	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21045651	21045651	PRJNA674048_P_NODE_22997_length_183_cov_2.201493_g22794_i0	PRJNA674048	22997	183	2.201493	4.02873219	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	307	3.0100000000000005e-79	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g22794	i0	97.753	282.497267759563	178	4	97	0	1	178	780737	780560	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	51697	307	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24869229	24869229	PRJNA674048_P_NODE_14200_length_239_cov_1.336842_g13997_i0	PRJNA674048	14200	239	1.336842	3.19505238	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	401	1.8499999999999992e-107	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g13997	i0	98.673	236.790794979079	226	3	95	0	14	239	778697	778922	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	56593	401	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26606725	26606725	PRJNA674048_P_NODE_32001_length_163_cov_0.912281_g31798_i0	PRJNA674048	32001	163	0.912281	1.48701803	Bdellovibrio sp.	28201	Bacteria	Bacteria	96.3	7.43e-22	NR	WP_415063513.1	28201	g31798	i0	85.2	1.98773006134969	54	8	99.4	0	2	163	165	218	WP_415063513.1 hypothetical protein [Bdellovibrio sp.]	diamond	324	96.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
27587395	27587395	PRJNA674048_P_NODE_30264_length_165_cov_0.896552_g30061_i0	PRJNA674048	30264	165	0.896552	1.4793108	Bdellovibrio sp.	28201	Bacteria	Bacteria	47	4.01e-4	NR	MFM6927017.1	28201	g30061	i0	41.5	0.963636363636364	53	31	96.4	0	164	6	190	242	MFM6927017.1 hypothetical protein [Bdellovibrio sp.]	diamond	159	47	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
28755512	28755512	PRJNA674048_P_NODE_32747_length_162_cov_0.920354_g32544_i0	PRJNA674048	32747	162	0.920354	1.49097348	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	115	1.09e-28	NR	WP_295905672.1	239744	g32544	i0	98.1	2	54	1	100	0	162	1	365	418	WP_295905672.1 NAD(P)/FAD-dependent oxidoreductase [uncultured Bdellovibrio sp.]	diamond	324	115	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.
28850058	28850058	PRJNA674048_P_NODE_32868_length_162_cov_0.920354_g32665_i0	PRJNA674048	32868	162	0.920354	1.49097348	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	60.8	3.15e-9	NR	WP_413940221.1	3394362	g32665	i0	87.9	1.24074074074074	33	4	61.1	0	61	159	4	36	WP_413940221.1 SDR family oxidoreductase [Bdellovibrio sp. HCB2-146]	diamond	201	60.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
28881729	28881729	PRJNA674048_P_NODE_25948_length_172_cov_1.691057_g25745_i0	PRJNA674048	25948	172	1.691057	2.90861804	Bdellovibrio sp.	28201	Bacteria	Bacteria	55.1	6.08e-7	NR	NUN07072.1	28201	g25745	i0	50	0.906976744186046	52	26	90.7	0	15	170	239	290	NUN07072.1 hypothetical protein [Bdellovibrio sp.]	diamond	156	55.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.

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