metadata: contig_metadata: 14 rows where bioproject = "PRJNA549880", tax_phylum = "Bdellovibrionota" and tax

14 rows where bioproject = "PRJNA549880", 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
1787267	1787267	PRJNA549880_P_NODE_12642_length_247_cov_0.885057_g12549_i0	PRJNA549880	12642	247	0.885057	2.18609079	Bdellovibrio	958	Bacteria	Bacteria	151	1.44e-43	NR	MBO9668818.1	28201	g12549	i0	85.2	4.91902834008097	81	12	98.4	0	2	244	118	198	MBO9668818.1 nicotinate (nicotinamide) nucleotide adenylyltransferase [Bdellovibrio sp.]	diamond	1215	152	0.993421052631579	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
8164714	8164714	PRJNA549880_P_NODE_15307_length_242_cov_0.911243_g15214_i0	PRJNA549880	15307	242	0.911243	2.20520806	Bdellovibrio	958	Bacteria	Bacteria	119	9.87e-30	NR	HWU44735.1	28201	g15214	i0	77.9	1.69834710743802	68	15	84.3	0	3	206	357	424	HWU44735.1 chloride channel protein [Bdellovibrio sp.]	diamond	411	119	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
8164773	8164773	PRJNA549880_P_NODE_4267_length_364_cov_2.192440_g4174_i0	PRJNA549880	4267	364	2.19244	7.9804816	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	407	6.399999999999999e-109	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g4174	i0	87.052	158.445054945055	363	43	99	4	5	364	1292345	1292706	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	57674	407	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
10715910	10715910	PRJNA549880_P_NODE_10489_length_251_cov_0.865169_g10396_i0	PRJNA549880	10489	251	0.865169	2.17157419	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	134	6.32e-36	NR	MES2856485.1	3034175	g10396	i0	83.1	6.95617529880478	83	13	98	1	3	248	63	145	MES2856485.1 aspartate-semialdehyde dehydrogenase [Bdellovibrionota bacterium]	diamond	1746	134	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
18363350	18363350	PRJNA549880_P_NODE_10895_length_250_cov_0.870056_g10802_i0	PRJNA549880	10895	250	0.870056	2.17514	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	187	5.949999999999998e-43	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g10802	i0	80.408	1.328	245	48	98	0	5	249	1520821	1520577	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	332	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
26602898	26602898	PRJNA549880_P_NODE_9501_length_263_cov_1.610526_g9408_i0	PRJNA549880	9501	263	1.610526	4.23568338	Bdellovibrio sp.	28201	Bacteria	Bacteria	85.5	3.31e-17	NR	WP_415061941.1	28201	g9408	i0	50.6	0.901140684410646	79	39	90.1	0	26	262	255	333	WP_415061941.1 hypothetical protein [Bdellovibrio sp.]	diamond	237	85.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
27046368	27046368	PRJNA549880_P_NODE_13042_length_246_cov_0.890173_g12949_i0	PRJNA549880	13042	246	0.890173	2.18982558	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	155	4.03e-44	NR	MAV92299.1	2026715	g12949	i0	86.6	1	82	9	100	1	1	246	219	298	MAV92299.1 zinc carboxypeptidase [Pseudobdellovibrionaceae bacterium]	diamond	246	155	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27250754	27250754	PRJNA549880_P_NODE_15923_length_226_cov_2.627451_g15830_i0	PRJNA549880	15923	226	2.627451	5.93803926	Bdellovibrio	958	Bacteria	Bacteria	103	5.46e-24	NR	BFD63541.1	3113894	g15830	i0	80.3	1.61946902654867	61	12	81	0	224	42	377	437	BFD63541.1 serine hydrolase [Bdellovibrio sp. HM001]	diamond	366	103	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
27930757	27930757	PRJNA549880_P_NODE_12485_length_247_cov_0.885057_g12392_i0	PRJNA549880	12485	247	0.885057	2.18609079	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	65.5	3.12e-10	NR	WP_408097510.1	3383025	g12392	i0	61	1.02024291497976	41	16	49.8	0	2	124	288	328	WP_408097510.1 S66 peptidase family protein [Peredibacter sp. HCB2-198]	diamond	252	65.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
30077778	30077778	PRJNA549880_P_NODE_12432_length_247_cov_0.885057_g12339_i0	PRJNA549880	12432	247	0.885057	2.18609079	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	84	1.09e-16	NR	MBS1971144.1	2053517	g12339	i0	88.6	1.61538461538462	44	5	53.4	0	2	133	231	274	MBS1971144.1 TldD/PmbA family protein [Bdellovibrionales bacterium]	diamond	399	84	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30425922	30425922	PRJNA549880_P_NODE_8593_length_277_cov_1.269608_g8500_i0	PRJNA549880	8593	277	1.269608	3.51681416	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	141	1.7e-37	NR	MBX3018986.1	2026715	g8500	i0	69.6	0.996389891696751	92	28	99.6	0	1	276	207	298	MBX3018986.1 DUF4340 domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	276	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
30899546	30899546	PRJNA549880_P_NODE_8614_length_277_cov_0.975490_g8521_i0	PRJNA549880	8614	277	0.97549	2.7021073	Micavibrio sp.	2024841	Bacteria	Bacteria	129	2.0499999999999998e-34	NR	HEY8190091.1	2024841	g8521	i0	71.7	0.996389891696751	92	26	99.6	0	276	1	96	187	HEY8190091.1 sulfite exporter TauE/SafE family protein [Micavibrio sp.]	diamond	276	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
32733262	32733262	PRJNA549880_P_NODE_8340_length_280_cov_1.285024_g8247_i0	PRJNA549880	8340	280	1.285024	3.5980672	Bdellovibrio sp. 22V	3044166	Bacteria	Bacteria	143	1.7899999999999998e-37	NR	WP_284607577.1	3044166	g8247	i0	69.9	2.96785714285714	93	28	99.6	0	280	2	483	575	WP_284607577.1 penicillin-binding transpeptidase domain-containing protein [Bdellovibrio sp. 22V]	diamond	831	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 22V
32890363	32890363	PRJNA549880_P_NODE_11940_length_248_cov_0.880000_g11847_i0	PRJNA549880	11940	248	0.88	2.1824	Bdellovibrio svalbardensis	2972972	Bacteria	Bacteria	99.4	4.16e-22	NR	WP_277576537.1	2972972	g11847	i0	61.3	0.967741935483871	80	31	96.8	0	8	247	74	153	WP_277576537.1 methyl-accepting chemotaxis protein [Bdellovibrio svalbardensis]	diamond	240	99.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio svalbardensis

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