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

18 rows where bioproject = "PRJNA1035005" 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
2719252	2719252	PRJNA1035005_P_NODE_35383_length_275_cov_2.123762_g34977_i0	PRJNA1035005	35383	275	2.123762	5.8403455	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	143	9.409999999999999e-41	NR	MCM2349929.1	2081706	g34977	i0	70.3	0.992727272727273	91	27	99.3	0	3	275	2	92	MCM2349929.1 uracil-DNA glycosylase [Bacteriovoracaceae bacterium]	diamond	273	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
9096629	9096629	PRJNA1035005_P_NODE_6688_length_417_cov_1.247093_g6286_i0	PRJNA1035005	6688	417	1.247093	5.20037781	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	549	1.1699999999999996e-151	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g6286	i0	91.878	157.326139088729	394	31	94	1	1	394	666254	666646	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	65605	549	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
13761090	13761090	PRJNA1035005_P_NODE_10571_length_358_cov_1.515789_g10166_i0	PRJNA1035005	10571	358	1.515789	5.42652462	Peredibacter	263370	Bacteria	Bacteria	562	1.27e-155	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g10166	i0	94.972	98.6173184357542	358	18	100	0	1	358	508866	509223	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	35305	562	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
13761166	13761166	PRJNA1035005_P_NODE_2571_length_707_cov_1.416404_g2187_i0	PRJNA1035005	2571	707	1.416404	10.01397628	Peredibacter	263370	Bacteria	Bacteria	1236	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2187	i0	98.166	261.861386138614	709	11	100	1	1	707	511243	511951	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	185136	1242	0.995169082125604	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
16746022	16746022	PRJNA1035005_P_NODE_67054_length_248_cov_1.468571_g66648_i0	PRJNA1035005	67054	248	1.468571	3.64205608	Peredibacter starrii	28202	Bacteria	Bacteria	285	2.0299999999999997e-72	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g66648	i0	87.55	2.00806451612903	249	28	100	3	1	248	1230104	1230350	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	498	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
19294768	19294768	PRJNA1035005_P_NODE_5916_length_439_cov_1.669399_g5516_i0	PRJNA1035005	5916	439	1.669399	7.32866161	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	71.6	1.61e-13	NR	MBX9703359.1	2654442	g5516	i0	60.9	0.314350797266515	46	18	31.4	0	318	181	1	46	MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	138	71.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
24394981	24394981	PRJNA1035005_P_NODE_51920_length_254_cov_2.337017_g51514_i0	PRJNA1035005	51920	254	2.337017	5.93602318	Bacteria	2	Bacteria	Bacteria	159	8.05e-45	NR	MBL7555342.1	2026715	g51514	i0	91.7	18.8503937007874	84	7	99.2	0	252	1	143	226	MBL7555342.1 transcription termination/antitermination protein NusA [Pseudobdellovibrionaceae bacterium]	diamond	4788	159	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27003345	27003345	PRJNA1035005_P_NODE_65562_length_249_cov_0.886364_g65156_i0	PRJNA1035005	65562	249	0.886364	2.20704636	Bacteriovorax sp.	2608087	Bacteria	Bacteria	87.8	2.07e-19	NR	MBP9682050.1	2608087	g65156	i0	52.5	0.963855421686747	80	37	96.4	1	2	241	71	149	MBP9682050.1 polyphenol oxidase family protein [Bacteriovorax sp.]	diamond	240	87.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
27793433	27793433	PRJNA1035005_P_NODE_80304_length_244_cov_0.912281_g79898_i0	PRJNA1035005	80304	244	0.912281	2.22596564	Bacteriovorax stolpii	960	Bacteria	Bacteria	141	4.14e-40	NR	WP_102243826.1	960	g79898	i0	81.8	2.8155737704918	77	14	94.7	0	243	13	141	217	WP_102243826.1 M23 family metallopeptidase [Bacteriovorax stolpii]	diamond	687	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
28456510	28456510	PRJNA1035005_P_NODE_76546_length_245_cov_0.906977_g76140_i0	PRJNA1035005	76546	245	0.906977	2.22209365	Oligoflexia bacterium	2599941	Bacteria	Bacteria	85.1	8.49e-18	NR	MCM2279309.1	2599941	g76140	i0	45.7	0.857142857142857	70	38	85.7	0	4	213	175	244	MCM2279309.1 ABC transporter permease [Oligoflexia bacterium]	diamond	210	85.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
28709128	28709128	PRJNA1035005_P_NODE_74507_length_246_cov_0.901734_g74101_i0	PRJNA1035005	74507	246	0.901734	2.21826564	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	54.7	2.09e-6	NR	MDX9732221.1	2053517	g74101	i0	38	0.963414634146341	79	47	95.1	2	11	244	224	301	MDX9732221.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	237	54.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30698596	30698596	PRJNA1035005_P_NODE_29074_length_284_cov_1.146919_g28668_i0	PRJNA1035005	29074	284	1.146919	3.2572499600000002	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	147	1.6899999999999996e-41	NR	MBY0415439.1	2053517	g28668	i0	71.3	1.98591549295775	94	27	99.3	0	1	282	149	242	MBY0415439.1 tRNA threonylcarbamoyladenosine dehydratase [Bdellovibrionales bacterium]	diamond	564	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30730233	30730233	PRJNA1035005_P_NODE_1654_length_961_cov_1.851351_g1326_i0	PRJNA1035005	1654	961	1.851351	17.79148311	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	375	7.239999999999999e-129	NR	MBX9767865.1	2053517	g1326	i0	90.5	0.627471383975026	201	19	62.7	0	192	794	1	201	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	603	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31290966	31290966	PRJNA1035005_P_NODE_61275_length_250_cov_1.762712_g60869_i0	PRJNA1035005	61275	250	1.762712	4.40678	Bdellovibrio	958	Bacteria	Bacteria	80.5	9.26e-17	NR	WP_415061832.1	28201	g60869	i0	82.6	2.964	46	8	55.2	0	249	112	123	168	WP_415061832.1 hypothetical protein [Bdellovibrio sp.]	diamond	741	80.9	0.995055624227441	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
31354426	31354426	PRJNA1035005_P_NODE_60556_length_251_cov_0.876404_g60150_i0	PRJNA1035005	60556	251	0.876404	2.19977404	Bacteriovorax	146784	Bacteria	Bacteria	142	5.189999999999999e-37	NR	WP_142410191.1	960	g60150	i0	83.1	4.9601593625498	83	14	99.2	0	251	3	507	589	WP_142410191.1 DEAD/DEAH box helicase [Bacteriovorax stolpii]	diamond	1245	142	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
31520656	31520656	PRJNA1035005_P_NODE_73296_length_246_cov_0.901734_g72890_i0	PRJNA1035005	73296	246	0.901734	2.21826564	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	109	2.6e-28	NR	MCM2349334.1	2081706	g72890	i0	68.8	1.8780487804878	77	24	93.9	0	14	244	37	113	MCM2349334.1 chemotaxis protein CheW [Bacteriovoracaceae bacterium]	diamond	462	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32564803	32564803	PRJNA1035005_P_NODE_1899_length_871_cov_3.397243_g1546_i0	PRJNA1035005	1899	871	3.397243	29.58998653	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	62.4	9.82e-8	NR	MBA2403337.1	2053517	g1546	i0	27.4	0.716417910447761	208	82	70.6	8	20	634	11	152	MBA2403337.1 dCMP deaminase family protein [Bdellovibrionales bacterium]	diamond	624	62.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32627367	32627367	PRJNA1035005_P_NODE_81740_length_243_cov_0.917647_g81334_i0	PRJNA1035005	81740	243	0.917647	2.22988221	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	124	4.39e-31	NR	PZP55682.1	349221	g81334	i0	77.5	0.987654320987654	80	18	98.8	0	3	242	79	158	PZP55682.1 MAG: sensor histidine kinase [Micavibrio aeruginosavorus]	diamond	240	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus

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