metadata: contig_metadata: 18 rows where bioproject = "PRJNA1059246", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA1059246", tax_kingdom = "Pseudomonadati" 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
177514	177514	PRJNA1059246_P_NODE_70881_length_242_cov_1.562130_g70255_i0	PRJNA1059246	70881	242	1.56213	3.7803546	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	159	1.2499999999999999e-34	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g70255	i0	80.617	82.4752066115702	227	27	87	8	1	211	861701	861476	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	19959	159	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
5279859	5279859	PRJNA1059246_P_NODE_41225_length_330_cov_1.669261_g40599_i0	PRJNA1059246	41225	330	1.669261	5.5085613	Pseudomonadati	3379134	Bacteria	Bacteria	187	7.73e-56	NR	OFZ68392.1	1797399	g40599	i0	88.8	20.4909090909091	98	11	89.1	0	6	299	29	126	OFZ68392.1 MAG: isocitrate dehydrogenase, partial [Bdellovibrionales bacterium RIFOXYC2_FULL_39_8]	diamond	6762	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYC2_FULL_39_8
6554967	6554967	PRJNA1059246_P_NODE_37326_length_351_cov_1.787770_g36700_i0	PRJNA1059246	37326	351	1.78777	6.2750727	root	1	Root_unresolved	Root_unresolved	60.5	7.79e-8	NR	MCB9062465.1	2026745	g36700	i0	37.1	4.66666666666667	89	31	76.1	1	271	5	658	721	MCB9062465.1 PAS domain S-box protein [Halobacteriovoraceae bacterium]	diamond	1638	60.8	0.995065789473684	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
7389165	7389165	PRJNA1059246_P_NODE_28266_length_415_cov_1.722222_g27641_i0	PRJNA1059246	28266	415	1.722222	7.1472213	Bacteria	2	Bacteria	Bacteria	215	4.9e-66	NR	MFL5812781.1	3034169	g27641	i0	77.9	4.90843373493976	136	30	98.3	0	413	6	248	383	MFL5812781.1 cystathionine gamma-synthase [Bdellovibrionia bacterium]	diamond	2037	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
11655741	11655741	PRJNA1059246_P_NODE_50330_length_288_cov_1.432558_g49704_i0	PRJNA1059246	50330	288	1.432558	4.12576704	Peredibacter starrii	28202	Bacteria	Bacteria	292	1.44e-74	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g49704	i0	85.017	11.3680555555556	287	43	99	0	1	287	470896	471182	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	3274	292	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17589327	17589327	PRJNA1059246_P_NODE_55334_length_272_cov_1.934673_g54708_i0	PRJNA1059246	55334	272	1.934673	5.26231056	Bdellovibrio	958	Bacteria	Bacteria	363	1.02e-95	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g54708	i0	91.078	163.216911764706	269	22	99	2	3	270	945228	944961	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	44395	363	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27003617	27003617	PRJNA1059246_P_NODE_62922_length_250_cov_0.870056_g62296_i0	PRJNA1059246	62922	250	0.870056	2.17514	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	52.4	1.59e-5	NR	HEY8280048.1	3034175	g62296	i0	49.1	0.684	57	27	68.4	1	248	78	644	698	HEY8280048.1 S8 family serine peptidase [Bdellovibrionota bacterium]	diamond	171	52.4	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27121711	27121711	PRJNA1059246_P_NODE_31082_length_391_cov_1.937107_g30456_i0	PRJNA1059246	31082	391	1.937107	7.57408837	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	57.4	9.43e-7	NR	MBX2833619.1	2024841	g30456	i0	51.9	2.56265984654731	54	25	40.7	1	230	72	212	265	MBX2833619.1 carbonic anhydrase family protein [Micavibrio sp.]	diamond	1002	57.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
27762239	27762239	PRJNA1059246_P_NODE_52904_length_280_cov_1.487923_g52278_i0	PRJNA1059246	52904	280	1.487923	4.1661844	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	67	7.02e-11	NR	MBQ49410.1	2026715	g52278	i0	64.2	0.567857142857143	53	17	56.8	1	159	1	52	102	MBQ49410.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	159	67	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27911423	27911423	PRJNA1059246_P_NODE_49185_length_292_cov_1.639269_g48559_i0	PRJNA1059246	49185	292	1.639269	4.78666548	Pseudomonadati	3379134	Bacteria	Bacteria	67.8	3.26e-11	NR	WP_088616872.1	1732569	g48559	i0	50.6	4.15068493150685	81	31	83.2	2	2	244	150	221	WP_088616872.1 NAD(P)H-binding protein [Bdellovibrio sp. SKB1291214]	diamond	1212	67.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
28100962	28100962	PRJNA1059246_P_NODE_30325_length_397_cov_2.456790_g29699_i0	PRJNA1059246	30325	397	2.45679	9.7534563	Bdellovibrionota	3018035	Bacteria	Bacteria	191	7.029999999999999e-57	NR	MBL7716798.1	2053517	g29699	i0	71.2	6.78589420654912	125	36	94.5	0	394	20	258	382	MBL7716798.1 cystathionine gamma-synthase [Bdellovibrionales bacterium]	diamond	2694	192	0.994791666666667	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29372308	29372308	PRJNA1059246_P_NODE_51749_length_284_cov_1.132701_g51123_i0	PRJNA1059246	51749	284	1.132701	3.21687084	Oligoflexales bacterium	2687297	Bacteria	Bacteria	52.8	1.78e-5	NR	MBP6216975.1	2687297	g51123	i0	57.1	0.443661971830986	42	18	44.4	0	274	149	265	306	MBP6216975.1 hypothetical protein [Oligoflexales bacterium]	diamond	126	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			Oligoflexales bacterium
29814211	29814211	PRJNA1059246_P_NODE_65131_length_248_cov_0.880000_g64505_i0	PRJNA1059246	65131	248	0.88	2.1824	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	55.5	1.23e-6	NR	MEW6778014.1	3034175	g64505	i0	60.5	0.907258064516129	43	15	49.6	1	20	142	296	338	MEW6778014.1 translational GTPase TypA [Bdellovibrionota bacterium]	diamond	225	55.5	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29877630	29877630	PRJNA1059246_P_NODE_72171_length_241_cov_0.916667_g71545_i0	PRJNA1059246	72171	241	0.916667	2.20916747	Halobacteriovorax marinus	97084	Bacteria	Bacteria	66.2	1.92e-10	NR	WP_157765722.1	97084	g71545	i0	44.3	0.983402489626556	79	35	92.1	2	19	240	633	707	WP_157765722.1 penicillin acylase family protein [Halobacteriovorax marinus]	diamond	237	66.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax marinus
30161552	30161552	PRJNA1059246_P_NODE_43312_length_320_cov_1.246964_g42686_i0	PRJNA1059246	43312	320	1.246964	3.9902848	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	75.1	3.13e-13	NR	MBN22861.1	2026715	g42686	i0	56.1	1.18125	66	28	60.9	1	319	125	299	364	MBN22861.1 saccharopine dehydrogenase [Pseudobdellovibrionaceae bacterium]	diamond	378	75.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31164362	31164362	PRJNA1059246_P_NODE_54275_length_276_cov_1.339901_g53649_i0	PRJNA1059246	54275	276	1.339901	3.69812676	Pseudomonadati	3379134	Bacteria	Bacteria	137	4.0899999999999995e-35	NR	OYZ20044.1	1970323	g53649	i0	69.2	18.7934782608696	91	28	98.9	0	275	3	524	614	OYZ20044.1 MAG: glycine dehydrogenase (aminomethyl-transferring) [Bdellovibrio sp. 28-41-41]	diamond	5187	138	0.992753623188406	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41
31678735	31678735	PRJNA1059246_P_NODE_36417_length_356_cov_1.950530_g35791_i0	PRJNA1059246	36417	356	1.95053	6.9438868	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.9	0.0489	NR	HEX4925810.1	2053517	g35791	i0	40.4	0.438202247191011	52	31	43.8	0	215	60	361	412	HEX4925810.1 cystathionine beta-synthase [Bdellovibrionales bacterium]	diamond	156	43.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31710571	31710571	PRJNA1059246_P_NODE_68557_length_245_cov_0.895349_g67931_i0	PRJNA1059246	68557	245	0.895349	2.19360505	Oligoflexus tunisiensis	708132	Bacteria	Bacteria	102	2.789999999999999e-23	NR	WP_141733868.1	708132	g67931	i0	59.3	0.991836734693878	81	33	99.2	0	3	245	616	696	WP_141733868.1 ATP-binding protein [Oligoflexus tunisiensis]	diamond	243	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus tunisiensis

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