metadata: contig_metadata: 9 rows where bioproject = "PRJEB49404", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJEB49404", tax_kingdom = "Pseudomonadati" 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
6485300	6485300	PRJEB49404_P_NODE_426566_length_204_cov_1.490909_g412765_i0	PRJEB49404	426566	204	1.490909	3.04145436	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	361	2.6e-95	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g412765	i0	98.529	278.553921568627	204	3	100	0	1	204	665962	666165	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	56825	361	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
6490125	6490125	PRJEB49404_P_NODE_525586_length_175_cov_1.941176_g511785_i0	PRJEB49404	525586	175	1.941176	3.397058	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	263	6.26e-66	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g511785	i0	96.25	31.44	160	6	91	0	14	173	1292577	1292418	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	5502	263	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
8644028	8644028	PRJEB49404_P_NODE_203027_length_348_cov_2.491909_g189228_i0	PRJEB49404	203027	348	2.491909	8.67184332	Peredibacter	263370	Bacteria	Bacteria	538	2.0799999999999993e-148	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g189228	i0	94.54	194.545977011494	348	19	100	0	1	348	511426	511773	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	67702	540	0.996296296296296	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
12470070	12470070	PRJEB49404_P_NODE_470410_length_190_cov_1.596026_g456609_i0	PRJEB49404	470410	190	1.596026	3.0324494	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	296	6.83e-76	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g456609	i0	94.737	88.4315789473684	190	10	100	0	1	190	784502	784313	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	16802	296	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14144678	14144678	PRJEB49404_P_NODE_617292_length_156_cov_1.401709_g603491_i0	PRJEB49404	617292	156	1.401709	2.18666604	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	222	9.25e-54	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g603491	i0	92.308	182.666666666667	156	12	100	0	1	156	3447979	3447824	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	28496	222	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20117630	20117630	PRJEB49404_P_NODE_561156_length_167_cov_1.617188_g547355_i0	PRJEB49404	561156	167	1.617188	2.70070396	Pseudobdellovibrio	2862745	Bacteria	Bacteria	285	1.27e-72	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g547355	i0	97.59	170.48502994012	166	4	99	0	2	167	860	1025	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	28471	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
21786590	21786590	PRJEB49404_P_NODE_483258_length_186_cov_2.054422_g469457_i0	PRJEB49404	483258	186	2.054422	3.82122492	Peredibacter starrii	28202	Bacteria	Bacteria	327	2.36e-85	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g469457	i0	98.387	39.258064516129	186	3	100	0	1	186	512484	512299	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	7302	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22667984	22667984	PRJEB49404_P_NODE_500558_length_182_cov_1.027972_g486757_i0	PRJEB49404	500558	182	1.027972	1.87090904	Pseudobdellovibrio	2862745	Bacteria	Bacteria	152	1.4799999999999998e-32	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g486757	i0	81.868	86.7692307692308	182	31	100	2	1	182	1337	1158	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	15792	152	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
32846203	32846203	PRJEB49404_P_NODE_208500_length_342_cov_1.488449_g194701_i0	PRJEB49404	208500	342	1.488449	5.09049558	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	134	3.3699999999999996e-35	NR	MBS1959520.1	2053517	g194701	i0	64.2	0.929824561403509	106	38	93	0	20	337	109	214	MBS1959520.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	318	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;