metadata: contig_metadata: 12 rows where bioproject = "PRJNA667863", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA667863", 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
8816584	8816584	PRJNA667863_P_NODE_6987_length_278_cov_2.707317_g6953_i0	PRJNA667863	6987	278	2.707317	7.52634126	Bdellovibrio	958	Bacteria	Bacteria	268	2.3299999999999994e-67	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g6953	i0	88.688	57.2374100719424	221	23	79	2	26	246	816662	816444	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	15912	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9562541	9562541	PRJNA667863_P_NODE_7668_length_273_cov_1.460000_g7634_i0	PRJNA667863	7668	273	1.46	3.9858	Oligoflexus sp.	1971216	Bacteria	Bacteria	70.9	6.7e-13	NR	WP_324954760.1	1971216	g7634	i0	55.2	0.637362637362637	58	25	62.6	1	1	171	20	77	WP_324954760.1 hypothetical protein [Oligoflexus sp.]	diamond	174	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
12642741	12642741	PRJNA667863_P_NODE_18650_length_226_cov_2.751634_g18616_i0	PRJNA667863	18650	226	2.751634	6.21869284	Pseudobdellovibrio	2862745	Bacteria	Bacteria	257	3.97e-64	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g18616	i0	87.5	171.685840707965	232	18	100	11	1	226	1173	947	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	38801	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
13388035	13388035	PRJNA667863_P_NODE_17991_length_232_cov_3.534591_g17957_i0	PRJNA667863	17991	232	3.534591	8.20025112	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	398	2.3099999999999995e-106	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g17957	i0	97.826	166.336206896552	230	5	99	0	3	232	1293204	1293433	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	38590	398	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
20289938	20289938	PRJNA667863_P_NODE_2776_length_358_cov_1.929825_g2742_i0	PRJNA667863	2776	358	1.929825	6.9087735	Peredibacter	263370	Bacteria	Bacteria	610	4.46e-170	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2742	i0	97.486	27.7569832402235	358	8	100	1	1	358	512482	512126	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	9937	610	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22311223	22311223	PRJNA667863_P_NODE_10778_length_253_cov_1.950000_g10744_i0	PRJNA667863	10778	253	1.95	4.9335	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	217	7.689999999999999e-52	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g10744	i0	82.52	0.972332015810277	246	43	97	0	4	249	357232	356987	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	246	217	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
27144398	27144398	PRJNA667863_P_NODE_9522_length_260_cov_2.588235_g9488_i0	PRJNA667863	9522	260	2.588235	6.729411	Bdellovibrio sp.	28201	Bacteria	Bacteria	56.6	5.87e-7	NR	MBI2520471.1	28201	g9488	i0	35.9	0.9	78	47	87.7	3	33	260	22	98	MBI2520471.1 hypothetical protein [Bdellovibrio sp.]	diamond	234	56.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
28408086	28408086	PRJNA667863_P_NODE_6566_length_282_cov_3.315789_g6532_i0	PRJNA667863	6566	282	3.315789	9.35052498	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	107	4.14e-25	NR	MCB9092546.1	2026745	g6532	i0	48.9	1	94	48	100	0	282	1	281	374	MCB9092546.1 GNAT family N-acetyltransferase [Halobacteriovoraceae bacterium]	diamond	282	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
30429528	30429528	PRJNA667863_P_NODE_14013_length_246_cov_0.890173_g13979_i0	PRJNA667863	14013	246	0.890173	2.18982558	Bdellovibrio sp. KM	28201	Bacteria	Bacteria	90.1	3.76e-19	NR	WP_181606041.1	2748865	g13979	i0	64.5	3.8780487804878	62	22	75.6	0	48	233	1	62	WP_181606041.1 FHA domain-containing protein [Bdellovibrio sp. KM01]	diamond	954	90.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
30681676	30681676	PRJNA667863_P_NODE_11893_length_250_cov_0.870056_g11859_i0	PRJNA667863	11893	250	0.870056	2.17514	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	154	3.689999999999999e-42	NR	MCK6593889.1	2081706	g11859	i0	92.7	0.984	82	6	98.4	0	3	248	355	436	MCK6593889.1 murein biosynthesis integral membrane protein MurJ [Bacteriovoracaceae bacterium]	diamond	246	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31061298	31061298	PRJNA667863_P_NODE_155_length_1074_cov_7.158841_g136_i0	PRJNA667863	155	1074	7.158841	76.88595234	Oligoflexus sp.	1971216	Bacteria	Bacteria	79	1.88e-13	NR	WP_324954760.1	1971216	g136	i0	64.9	0.159217877094972	57	20	15.9	0	24	194	94	150	WP_324954760.1 hypothetical protein [Oligoflexus sp.]	diamond	171	79	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
31135944	31135944	PRJNA667863_P_NODE_12695_length_248_cov_1.777143_g12661_i0	PRJNA667863	12695	248	1.777143	4.40731464	Bdellovibrionota	3018035	Bacteria	Bacteria	150	1.94e-44	NR	WP_321396602.1	28202	g12661	i0	90.2	2.9758064516129	82	8	99.2	0	3	248	57	138	WP_321396602.1 hypothetical protein [Peredibacter starrii]	diamond	738	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii

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