metadata: contig_metadata: 27 rows where bioproject = "PRJNA515078", tax_phylum = "Bdellovibrionota" and tax

27 rows where bioproject = "PRJNA515078", 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
6214480	6214480	PRJNA515078_P_NODE_825_length_1043_cov_4.155070_g712_i0	PRJNA515078	825	1043	4.15507	43.3373801	Bdellovibrio	958	Bacteria	Bacteria	231	1.2699999999999995e-55	NTclustered	gi\|2800927921\|gb\|CP168969.1\|	959	g712	i0	76.238	40.5474592521572	505	80	45	20	1	471	828992	829490	Bdellovibrio bacteriovorus strain Bd10 chromosome, complete genome	blastn	42291	231	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10039474	10039474	PRJNA515078_P_NODE_17948_length_205_cov_2.392857_g17715_i0	PRJNA515078	17948	205	2.392857	4.90535685	Pseudobdellovibrio	2862745	Bacteria	Bacteria	209	1e-49	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g17715	i0	85.644	29.5609756097561	202	25	98	4	1	200	1307	1506	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	6060	209	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15139053	15139053	PRJNA515078_P_NODE_5752_length_394_cov_1.879552_g5519_i0	PRJNA515078	5752	394	1.879552	7.40543488	Bdellovibrio	958	Bacteria	Bacteria	231	4.509999999999999e-56	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g5519	i0	80.495	69.7208121827411	323	45	96	9	27	332	1607696	1608017	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	27470	233	0.991416309012876	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18338496	18338496	PRJNA515078_P_NODE_21335_length_188_cov_1.072848_g21102_i0	PRJNA515078	21335	188	1.072848	2.01695424	Pigmentibacter sp. JX	2838411	Bacteria	Bacteria	102	1.03e-25	NR	WGL60097.1	2976982	g21102	i0	82.8	9.36702127659574	58	10	92.6	0	186	13	100	157	WGL60097.1 zinc-binding dehydrogenase [Pigmentibacter sp. JX0631]	diamond	1761	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter sp. JX0631
22163684	22163684	PRJNA515078_P_NODE_29698_length_160_cov_1.577236_g29465_i0	PRJNA515078	29698	160	1.577236	2.5235776	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	100	2.06e-25	NR	MCB0368224.1	2053517	g29465	i0	94.2	1.95	52	3	97.5	0	158	3	6	57	MCB0368224.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium]	diamond	312	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
24712831	24712831	PRJNA515078_P_NODE_11720_length_260_cov_2.798206_g11487_i0	PRJNA515078	11720	260	2.798206	7.2753356	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	364	2.679999999999999e-96	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g11487	i0	91.954	213.573076923077	261	20	100	1	1	260	3447430	3447690	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	55529	364	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
26665403	26665403	PRJNA515078_P_NODE_13381_length_242_cov_1.136585_g13148_i0	PRJNA515078	13381	242	1.136585	2.7505357	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	80.5	5.88e-18	NR	MCB0370563.1	2053517	g13148	i0	60.3	0.71900826446281	58	23	71.9	0	20	193	3	60	MCB0370563.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	174	80.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27266841	27266841	PRJNA515078_P_NODE_11503_length_263_cov_2.845133_g11270_i0	PRJNA515078	11503	263	2.845133	7.48269979	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	82	8.63e-18	NR	MCB0368029.1	2053517	g11270	i0	58.5	1.49429657794677	65	27	74.1	0	254	60	60	124	MCB0368029.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	393	82	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27298468	27298468	PRJNA515078_P_NODE_17203_length_210_cov_1.867052_g16970_i0	PRJNA515078	17203	210	1.867052	3.9208092	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.1	0.00286	NR	MCB0368830.1	2053517	g16970	i0	35.7	1	70	42	98.6	2	209	3	11	78	MCB0368830.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	210	43.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27361864	27361864	PRJNA515078_P_NODE_1503_length_796_cov_12.848485_g1340_i0	PRJNA515078	1503	796	12.848485	102.2739406	Oligoflexus sp.	1971216	Bacteria	Bacteria	138	1.57e-36	NR	WP_324955651.1	1971216	g1340	i0	49.6	1.64321608040201	141	67	51.6	1	149	559	24	164	WP_324955651.1 lipocalin family protein [Oligoflexus sp.]	diamond	1308	138	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
27646068	27646068	PRJNA515078_P_NODE_33424_length_152_cov_1.356522_g33191_i0	PRJNA515078	33424	152	1.356522	2.06191344	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	68.2	1.15e-13	NR	MCK6598877.1	2026715	g33191	i0	69.4	0.967105263157895	49	15	96.7	0	148	2	2	50	MCK6598877.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	147	68.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28435243	28435243	PRJNA515078_P_NODE_27866_length_165_cov_1.218750_g27633_i0	PRJNA515078	27866	165	1.21875	2.0109375	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	62.8	4.79e-10	NR	MCK6597283.1	2026715	g27633	i0	58.2	1	55	23	100	0	1	165	82	136	MCK6597283.1 TetR/AcrR family transcriptional regulator [Pseudobdellovibrionaceae bacterium]	diamond	165	62.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28466929	28466929	PRJNA515078_P_NODE_9186_length_301_cov_1.329545_g8953_i0	PRJNA515078	9186	301	1.329545	4.00193045	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	121	6.849999999999998e-30	NR	MCB0368268.1	2053517	g8953	i0	54.6	0.966777408637874	97	44	96.7	0	8	298	186	282	MCB0368268.1 DUF4215 domain-containing protein [Bdellovibrionales bacterium]	diamond	291	121	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29445354	29445354	PRJNA515078_P_NODE_2030_length_683_cov_15.956656_g1837_i0	PRJNA515078	2030	683	15.956656	108.98396048	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	70.9	4.35e-11	NR	MCB0369154.1	2053517	g1837	i0	30.7	0.601756954612006	137	89	60.2	2	44	454	3	133	MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium]	diamond	411	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29508624	29508624	PRJNA515078_P_NODE_19050_length_199_cov_1.203704_g18817_i0	PRJNA515078	19050	199	1.203704	2.39537096	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	94	5.17e-22	NR	MBX9767865.1	2053517	g18817	i0	56.1	0.994974874371859	66	29	99.5	0	1	198	107	172	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	198	94	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29919371	29919371	PRJNA515078_P_NODE_32091_length_155_cov_1.313559_g31858_i0	PRJNA515078	32091	155	1.313559	2.03601645	Bdellovibrio sp.	28201	Bacteria	Bacteria	80.1	5.64e-16	NR	RME17908.1	28201	g31858	i0	64.7	4.91612903225806	51	18	98.7	0	2	154	53	103	RME17908.1 MAG: cystathionine gamma-synthase [Bdellovibrio sp.]	diamond	762	80.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
30803876	30803876	PRJNA515078_P_NODE_5454_length_406_cov_2.314363_g5221_i0	PRJNA515078	5454	406	2.314363	9.39631378	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	107	5.810000000000001e-26	NR	MBX9767865.1	2053517	g5221	i0	47.7	1.74384236453202	111	49	75.4	1	95	400	1	111	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	708	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30898803	30898803	PRJNA515078_P_NODE_29754_length_160_cov_1.268293_g29521_i0	PRJNA515078	29754	160	1.268293	2.0292688	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	74.7	4.02e-14	NR	MBX9702590.1	2654442	g29521	i0	64.7	0.95625	51	18	95.6	0	2	154	191	241	MBX9702590.1 serine/threonine-protein kinase [Silvanigrellaceae bacterium]	diamond	153	74.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
30898805	30898805	PRJNA515078_P_NODE_31714_length_156_cov_0.983193_g31481_i0	PRJNA515078	31714	156	0.983193	1.53378108	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	84.3	1.32e-19	NR	MBX9704131.1	2654442	g31481	i0	73.1	1	52	14	100	0	1	156	41	92	MBX9704131.1 DUF4442 domain-containing protein [Silvanigrellaceae bacterium]	diamond	156	84.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
31025135	31025135	PRJNA515078_P_NODE_26115_length_170_cov_1.458647_g25882_i0	PRJNA515078	26115	170	1.458647	2.4796999	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	83.2	4.28e-18	NR	MCB0369154.1	2053517	g25882	i0	69.6	0.988235294117647	56	17	98.8	0	169	2	77	132	MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium]	diamond	168	83.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31246228	31246228	PRJNA515078_P_NODE_11355_length_266_cov_1.183406_g11122_i0	PRJNA515078	11355	266	1.183406	3.14785996	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.6	2.92e-14	NR	MCB0368769.1	2053517	g11122	i0	46.9	0.913533834586466	81	43	91.4	0	245	3	58	138	MCB0368769.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	243	73.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31404549	31404549	PRJNA515078_P_NODE_7056_length_351_cov_2.550955_g6823_i0	PRJNA515078	7056	351	2.550955	8.95385205	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	125	1.21e-33	NR	MBX9767865.1	2053517	g6823	i0	60.9	0.786324786324786	92	36	78.6	0	2	277	110	201	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	276	125	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31435963	31435963	PRJNA515078_P_NODE_696_length_1139_cov_6.500000_g599_i0	PRJNA515078	696	1139	6.5	74.035	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	351	1.63e-115	NR	MCB0386755.1	2053517	g599	i0	50.8	0.93766461808604	356	158	90.1	9	1039	14	27	379	MCB0386755.1 C1 family peptidase [Bdellovibrionales bacterium]	diamond	1068	351	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31657259	31657259	PRJNA515078_P_NODE_6917_length_355_cov_2.515723_g6684_i0	PRJNA515078	6917	355	2.515723	8.93081665	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	71.6	1.09e-12	NR	MCB0371038.1	2053517	g6684	i0	41.9	0.523943661971831	62	36	52.4	0	12	197	122	183	MCB0371038.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium]	diamond	186	71.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31752219	31752219	PRJNA515078_P_NODE_5937_length_388_cov_1.333333_g5704_i0	PRJNA515078	5937	388	1.333333	5.17333204	Bacteriovorax sp.	2608087	Bacteria	Bacteria	88.2	7.01e-20	NR	MBC7712185.1	2608087	g5704	i0	53.1	0.742268041237113	96	44	73.5	1	42	326	2	97	MBC7712185.1 hypothetical protein [Bacteriovorax sp.]	diamond	288	88.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
31910506	31910506	PRJNA515078_P_NODE_33117_length_153_cov_1.008621_g32884_i0	PRJNA515078	33117	153	1.008621	1.54319013	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	44.7	0.00226	NR	WP_374033313.1	959	g32884	i0	50	0.784313725490196	40	20	78.4	0	2	121	352	391	WP_374033313.1 RCC1 domain-containing protein [Bdellovibrio bacteriovorus]	diamond	120	44.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
32227070	32227070	PRJNA515078_P_NODE_1858_length_715_cov_4.864307_g1677_i0	PRJNA515078	1858	715	4.864307	34.77979505	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	73.6	5.37e-12	NR	MCB0369154.1	2053517	g1677	i0	30.2	2.0013986013986	139	89	57.5	3	672	262	1	133	MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium]	diamond	1431	73.6	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);;