metadata: contig_metadata: 18 rows where bioproject = "PRJNA1158727" and tax

18 rows where bioproject = "PRJNA1158727" 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
6684381	6684381	PRJNA1158727_P_NODE_81226_length_336_cov_1.171103_g73765_i0	PRJNA1158727	81226	336	1.171103	3.93490608	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	206	8.29e-63	NR	WP_015470630.1	453816	g73765	i0	91	114.982142857143	111	10	99.1	0	2	334	18	128	WP_015470630.1 elongation factor Tu [Pseudobdellovibrio exovorus]	diamond	38634	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
10508155	10508155	PRJNA1158727_P_NODE_162949_length_241_cov_0.916667_g155487_i0	PRJNA1158727	162949	241	0.916667	2.20916747	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	261	3.31e-65	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g155487	i0	86.555	9.40663900414938	238	30	98	2	5	241	1840023	1840259	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	2267	261	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
13060259	13060259	PRJNA1158727_P_NODE_84491_length_327_cov_1.452756_g77030_i0	PRJNA1158727	84491	327	1.452756	4.75051212	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	425	1.57e-114	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g77030	i0	90.214	177.562691131498	327	30	99	2	1	326	666173	666498	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	58063	425	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
21980769	21980769	PRJNA1158727_P_NODE_140898_length_249_cov_0.875000_g133436_i0	PRJNA1158727	140898	249	0.875	2.17875	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	368	1.97e-97	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g133436	i0	93.548	136.429718875502	248	15	99	1	3	249	3447954	3447707	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	33971	368	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
25263768	25263768	PRJNA1158727_P_NODE_130720_length_255_cov_1.692308_g123259_i0	PRJNA1158727	130720	255	1.692308	4.3153854	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	138	2.06e-36	NR	MBX3021147.1	2053517	g123259	i0	73.8	0.988235294117647	84	22	98.8	0	1	252	66	149	MBX3021147.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Bdellovibrionales bacterium]	diamond	252	138	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27134766	27134766	PRJNA1158727_P_NODE_139162_length_250_cov_0.870056_g131700_i0	PRJNA1158727	139162	250	0.870056	2.17514	Oligoflexia bacterium	2599941	Bacteria	Bacteria	142	1.87e-38	NR	MCO5142763.1	2599941	g131700	i0	75.9	0.996	83	20	99.6	0	249	1	187	269	MCO5142763.1 flagellar hook protein FlgE [Oligoflexia bacterium]	diamond	249	142	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
27672341	27672341	PRJNA1158727_P_NODE_112024_length_277_cov_1.245098_g104563_i0	PRJNA1158727	112024	277	1.245098	3.44892146	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	85.1	2.78e-17	NR	PZP56002.1	349221	g104563	i0	56.5	0.747292418772563	69	30	74.7	0	69	275	1	69	PZP56002.1 MAG: endolytic transglycosylase MltG [Micavibrio aeruginosavorus]	diamond	207	85.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
27735636	27735636	PRJNA1158727_P_NODE_158764_length_242_cov_1.822485_g151302_i0	PRJNA1158727	158764	242	1.822485	4.4104137	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	119	1.67e-30	NR	MBY0316991.1	2053517	g151302	i0	93	0.706611570247934	57	4	70.7	0	242	72	283	339	MBY0316991.1 site-specific integrase [Bdellovibrionales bacterium]	diamond	171	119	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27830018	27830018	PRJNA1158727_P_NODE_143784_length_248_cov_0.880000_g136322_i0	PRJNA1158727	143784	248	0.88	2.1824	Micavibrio sp.	2024841	Bacteria	Bacteria	124	1.7399999999999999e-31	NR	HEY8190593.1	2024841	g136322	i0	80.5	0.931451612903226	77	15	93.1	0	247	17	144	220	HEY8190593.1 type II and III secretion system protein family protein [Micavibrio sp.]	diamond	231	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
27849231	27849231	PRJNA1158727_P_NODE_154944_length_244_cov_0.900585_g147482_i0	PRJNA1158727	154944	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	6.66e-6	NR	QQG35199.1	349221	g147482	i0	43.9	2.05327868852459	57	32	70.1	0	70	240	15	71	QQG35199.1 MAG: PH domain-containing protein [Micavibrio aeruginosavorus]	diamond	501	52.8	0.992424242424242	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
27893073	27893073	PRJNA1158727_P_NODE_152445_length_245_cov_0.895349_g144983_i0	PRJNA1158727	152445	245	0.895349	2.19360505	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	139	7.99e-40	NR	HEY8278050.1	3034175	g144983	i0	79	0.991836734693878	81	17	99.2	0	244	2	15	95	HEY8278050.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	243	139	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28177122	28177122	PRJNA1158727_P_NODE_159606_length_242_cov_0.911243_g152144_i0	PRJNA1158727	159606	242	0.911243	2.20520806	Oligoflexus sp.	1971216	Bacteria	Bacteria	97.4	2.08e-22	NR	MBC7530104.1	1971216	g152144	i0	100	2.4297520661157	49	0	60.7	0	151	5	1	49	MBC7530104.1 ParA family protein [Oligoflexus sp.]	diamond	588	97.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
30028266	30028266	PRJNA1158727_P_NODE_160231_length_242_cov_0.911243_g152769_i0	PRJNA1158727	160231	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	0.00153	NR	MBT4792039.1	2026745	g152769	i0	31.3	1.90909090909091	80	53	99.2	2	240	1	57	134	MBT4792039.1 hypothetical protein [Halobacteriovoraceae bacterium]	diamond	462	47	0.991489361702128	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
30293526	30293526	PRJNA1158727_P_NODE_156672_length_243_cov_0.905882_g149210_i0	PRJNA1158727	156672	243	0.905882	2.20129326	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	85.9	2.44e-17	NR	HMN67242.1	2053517	g149210	i0	57	3.90123456790123	79	33	97.5	1	239	3	397	474	HMN67242.1 choice-of-anchor D domain-containing protein [Bdellovibrionales bacterium]	diamond	948	85.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30703778	30703778	PRJNA1158727_P_NODE_136294_length_251_cov_0.865169_g128832_i0	PRJNA1158727	136294	251	0.865169	2.17157419	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	113	1.88e-28	NR	MFN8791414.1	2053517	g128832	i0	65.1	1.9840637450199201	83	29	99.2	0	250	2	28	110	MFN8791414.1 1,4-dihydroxy-2-naphthoate octaprenyltransferase [Bdellovibrionales bacterium]	diamond	498	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30956789	30956789	PRJNA1158727_P_NODE_139094_length_250_cov_0.870056_g131632_i0	PRJNA1158727	139094	250	0.870056	2.17514	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	120	4.7699999999999996e-32	NR	HEY8280566.1	3034175	g131632	i0	70.7	1.896	82	24	98.4	0	248	3	103	184	HEY8280566.1 GGDEF domain-containing protein [Bdellovibrionota bacterium]	diamond	474	120	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31208931	31208931	PRJNA1158727_P_NODE_157655_length_243_cov_0.905882_g150193_i0	PRJNA1158727	157655	243	0.905882	2.20129326	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	75.9	3.99e-14	NR	MBI2234198.1	349221	g150193	i0	78.6	0.518518518518518	42	9	51.9	0	117	242	1	42	MBI2234198.1 UDP-3-O-acyl-N-acetylglucosamine deacetylase [Micavibrio aeruginosavorus]	diamond	126	75.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32177923	32177923	PRJNA1158727_P_NODE_153298_length_244_cov_1.748538_g145836_i0	PRJNA1158727	153298	244	1.748538	4.26643272	Pseudomonadati	3379134	Bacteria	Bacteria	160	1.1999999999999999e-43	NR	NUM58224.1	2026715	g145836	i0	92.5	1.9672131147541	80	6	98.4	0	242	3	138	217	NUM58224.1 acyl-CoA dehydrogenase [Pseudobdellovibrionaceae bacterium]	diamond	480	160	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae 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);;