metadata: contig_metadata: 9 rows where bioproject = "PRJNA683669", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA683669", 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
10103568	10103568	PRJNA683669_P_NODE_31348_length_244_cov_1.795322_g31116_i0	PRJNA683669	31348	244	1.795322	4.38058568	Bdellovibrio	958	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g31116	i0	100	0.344262295081967	28	0	11	0	203	230	36044	36071	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
27555849	27555849	PRJNA683669_P_NODE_11064_length_388_cov_1.196825_g10833_i0	PRJNA683669	11064	388	1.196825	4.643681	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	63.2	1.28e-8	NR	WP_015468752.1	453816	g10833	i0	47.3	0.425257731958763	55	29	42.5	0	18	182	340	394	WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus]	diamond	165	63.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
28250602	28250602	PRJNA683669_P_NODE_9066_length_425_cov_1.264205_g8835_i0	PRJNA683669	9066	425	1.264205	5.37287125	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	52.8	7.73e-5	NR	MFN3697314.1	2862747	g8835	i0	30.9	0.663529411764706	94	57	64.2	3	276	4	294	382	MFN3697314.1 adenylate/guanylate cyclase domain-containing protein [Pseudobdellovibrio sp.]	diamond	282	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.
28483429	28483429	PRJNA683669_P_NODE_33546_length_241_cov_1.577381_g33314_i0	PRJNA683669	33546	241	1.577381	3.80148821	root	1	Root_unresolved	Root_unresolved	89	1.86e-18	NR	WP_015468752.1	453816	g33314	i0	50	1.99170124481328	82	36	95.9	2	239	9	323	404	WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus]	diamond	480	89	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
29493739	29493739	PRJNA683669_P_NODE_32410_length_243_cov_0.905882_g32178_i0	PRJNA683669	32410	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	125	9.62e-33	NR	MCB0416915.1	2053517	g32178	i0	71.6	4	81	23	100	0	243	1	199	279	MCB0416915.1 adenosine deaminase [Bdellovibrionales bacterium]	diamond	972	125	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30524453	30524453	PRJNA683669_P_NODE_15453_length_330_cov_1.198444_g15222_i0	PRJNA683669	15453	330	1.198444	3.9548652	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	76.6	1.24e-13	NR	WP_159455691.1	1513793	g15222	i0	37.7	0.963636363636364	106	63	95.5	2	3	317	410	513	WP_159455691.1 FAD-dependent oxidoreductase [Pseudobacteriovorax antillogorgiicola]	diamond	318	76.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
30777326	30777326	PRJNA683669_P_NODE_23234_length_268_cov_3.717949_g23002_i0	PRJNA683669	23234	268	3.717949	9.96410332	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	65.9	4e-11	NR	MBT3980100.1	2081706	g23002	i0	31.7	0.917910447761194	82	48	91.8	1	248	3	34	107	MBT3980100.1 Hsp20/alpha crystallin family protein [Bacteriovoracaceae bacterium]	diamond	246	65.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30935352	30935352	PRJNA683669_P_NODE_4754_length_595_cov_3.153257_g4529_i0	PRJNA683669	4754	595	3.153257	18.76187915	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	59.7	1.27e-6	NR	WP_015468758.1	453816	g4529	i0	31.5	0.463865546218487	92	57	46.4	2	348	73	351	436	WP_015468758.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus]	diamond	276	59.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
32073704	32073704	PRJNA683669_P_NODE_31918_length_244_cov_0.900585_g31686_i0	PRJNA683669	31918	244	0.900585	2.1974274	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	46.2	0.00216	NR	WP_159455691.1	1513793	g31686	i0	49.1	0.676229508196721	55	27	67.6	1	242	78	61	114	WP_159455691.1 FAD-dependent oxidoreductase [Pseudobacteriovorax antillogorgiicola]	diamond	165	46.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola

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