metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA758770" 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
11408512	11408512	PRJNA758770_S_NODE_30109_length_245_cov_0.906977_g29983_i0	PRJNA758770	30109	245	0.906977	2.22209365	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	147	3.42e-42	NR	MDX9731524.1	2053517	g29983	i0	87.5	1.97142857142857	80	10	98	0	6	245	26	105	MDX9731524.1 glutamine-hydrolyzing GMP synthase [Bdellovibrionales bacterium]	diamond	483	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26736168	26736168	PRJNA758770_S_NODE_31681_length_243_cov_0.917647_g31555_i0	PRJNA758770	31681	243	0.917647	2.22988221	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	97.4	1.91e-22	NR	MDX9731017.1	2053517	g31555	i0	87	1.59259259259259	54	7	66.7	0	162	1	45	98	MDX9731017.1 outer membrane beta-barrel protein [Bdellovibrionales bacterium]	diamond	387	97.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27084744	27084744	PRJNA758770_S_NODE_16122_length_296_cov_0.946188_g15996_i0	PRJNA758770	16122	296	0.946188	2.80071648	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	139	8.62e-39	NR	MCB0379473.1	2053517	g15996	i0	82.5	1.62162162162162	80	14	81.1	0	242	3	87	166	MCB0379473.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	480	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27147489	27147489	PRJNA758770_S_NODE_23762_length_253_cov_0.866667_g23636_i0	PRJNA758770	23762	253	0.866667	2.19266751	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	137	1.69e-36	NR	MBK7889873.1	2053517	g23636	i0	80.2	4.80237154150198	81	16	96	0	11	253	281	361	MBK7889873.1 transposase [Bdellovibrionales bacterium]	diamond	1215	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27779774	27779774	PRJNA758770_S_NODE_24324_length_252_cov_0.871508_g24198_i0	PRJNA758770	24324	252	0.871508	2.19620016	Oligoflexia bacterium	2599941	Bacteria	Bacteria	126	6.36e-33	NR	MDZ4676294.1	2599941	g24198	i0	72.6	1	84	23	100	0	252	1	32	115	MDZ4676294.1 ATP-binding protein [Oligoflexia bacterium]	diamond	252	126	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
27811440	27811440	PRJNA758770_S_NODE_31684_length_243_cov_0.917647_g31558_i0	PRJNA758770	31684	243	0.917647	2.22988221	Oligoflexia bacterium	2599941	Bacteria	Bacteria	172	1.46e-49	NR	HRK02627.1	2599941	g31558	i0	100	1	81	0	100	0	1	243	323	403	HRK02627.1 IS1380 family transposase [Oligoflexia bacterium]	diamond	243	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
27842638	27842638	PRJNA758770_S_NODE_15164_length_303_cov_1.017391_g15038_i0	PRJNA758770	15164	303	1.017391	3.08269473	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	112	1.48e-27	NR	MCB0367795.1	2053517	g15038	i0	60	8.36633663366337	85	34	84.2	0	1	255	206	290	MCB0367795.1 UTP--glucose-1-phosphate uridylyltransferase GalU [Bdellovibrionales bacterium]	diamond	2535	112	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28253169	28253169	PRJNA758770_S_NODE_32426_length_242_cov_0.923077_g32300_i0	PRJNA758770	32426	242	0.923077	2.23384634	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	139	2.3299999999999997e-37	NR	MDZ4083043.1	2053517	g32300	i0	85	1.98347107438017	80	11	99.2	1	241	2	140	218	MDZ4083043.1 S8 family serine peptidase [Bdellovibrionales bacterium]	diamond	480	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29926873	29926873	PRJNA758770_S_NODE_26811_length_249_cov_0.886364_g26685_i0	PRJNA758770	26811	249	0.886364	2.20704636	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	77	8.79e-15	NR	HEY8280173.1	3034175	g26685	i0	52.4	1.01204819277108	84	37	97.6	2	248	6	72	155	HEY8280173.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	252	77	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29958279	29958279	PRJNA758770_S_NODE_27111_length_249_cov_0.886364_g26985_i0	PRJNA758770	27111	249	0.886364	2.20704636	Bdellovibrio sp.	28201	Bacteria	Bacteria	181	3.5799999999999995e-55	NR	WP_347359704.1	28201	g26985	i0	98.8	2	83	1	100	0	1	249	38	120	WP_347359704.1 peptide MFS transporter, partial [Bdellovibrio sp.]	diamond	498	181	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
29989952	29989952	PRJNA758770_S_NODE_31491_length_243_cov_1.129412_g31365_i0	PRJNA758770	31491	243	1.129412	2.74447116	Bdellovibrio sp. ZAP7	2231053	Bacteria	Bacteria	60.5	1.98e-8	NR	WP_142701551.1	2231053	g31365	i0	56	0.617283950617284	50	22	61.7	0	242	93	27	76	WP_142701551.1 KamA family radical SAM protein [Bdellovibrio sp. ZAP7]	diamond	150	60.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
30021642	30021642	PRJNA758770_S_NODE_30211_length_245_cov_0.906977_g30085_i0	PRJNA758770	30211	245	0.906977	2.22209365	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	77.8	1.72e-14	NR	MCB0349437.1	2053517	g30085	i0	52.1	0.869387755102041	71	31	83.3	1	40	243	376	446	MCB0349437.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	213	77.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30274524	30274524	PRJNA758770_S_NODE_24352_length_252_cov_0.871508_g24226_i0	PRJNA758770	24352	252	0.871508	2.19620016	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	173	2.01e-48	NR	MDY0029356.1	2026715	g24226	i0	100	0.988095238095238	83	0	98.8	0	3	251	482	564	MDY0029356.1 SLBB domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	249	173	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
30748238	30748238	PRJNA758770_S_NODE_25334_length_251_cov_0.876404_g25208_i0	PRJNA758770	25334	251	0.876404	2.19977404	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	117	2.75e-29	NR	MDZ4084828.1	2053517	g25208	i0	68.4	0.944223107569721	79	25	94.4	0	239	3	9	87	MDZ4084828.1 TIGR03545 family protein [Bdellovibrionales bacterium]	diamond	237	117	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31136753	31136753	PRJNA758770_S_NODE_24495_length_252_cov_0.871508_g24369_i0	PRJNA758770	24495	252	0.871508	2.19620016	Bdellovibrio	958	Bacteria	Bacteria	143	3.98e-41	NR	WP_226988008.1	959	g24369	i0	80.7	4.94047619047619	83	16	98.8	0	2	250	36	118	WP_226988008.1 5'-methylthioadenosine/S-adenosylhomocysteine nucleosidase [Bdellovibrio bacteriovorus]	diamond	1245	144	0.993055555555556	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
31475290	31475290	PRJNA758770_S_NODE_24656_length_252_cov_0.871508_g24530_i0	PRJNA758770	24656	252	0.871508	2.19620016	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	129	4.48e-34	NR	QQG36762.1	349221	g24530	i0	78.3	2.96428571428571	83	18	98.8	0	3	251	145	227	QQG36762.1 MAG: NAD(P)-dependent glycerol-3-phosphate dehydrogenase [Micavibrio aeruginosavorus]	diamond	747	129	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32392620	32392620	PRJNA758770_S_NODE_17139_length_289_cov_1.032407_g17013_i0	PRJNA758770	17139	289	1.032407	2.98365623	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	77.4	3.33e-14	NR	MCC6137581.1	2026715	g17013	i0	69.4	0.508650519031142	49	15	50.9	0	149	3	258	306	MCC6137581.1 site-specific integrase [Pseudobdellovibrionaceae bacterium]	diamond	147	77.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
32834228	32834228	PRJNA758770_S_NODE_18720_length_279_cov_1.135922_g18594_i0	PRJNA758770	18720	279	1.135922	3.16922238	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	124	1.5599999999999998e-31	NR	MDZ4082220.1	2053517	g18594	i0	61.4	0.946236559139785	88	34	94.6	0	16	279	12	99	MDZ4082220.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	264	124	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);;