metadata: contig_metadata: 10 rows where bioproject = "PRJNA801875", tax_phylum = "Bdellovibrionota" and tax

10 rows where bioproject = "PRJNA801875", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
801061	801061	PRJNA801875_P_NODE_3761_length_169_cov_1.179104_g3658_i0	PRJNA801875	3761	169	1.179104	1.99268576	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	113	6.3800000000000005e-21	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g3658	i0	80.982	0.964497041420118	163	13	88	9	8	156	878319	878477	Bdellovibrio exovorus JSS, complete genome	blastn	163	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
4629500	4629500	PRJNA801875_P_NODE_2824_length_200_cov_4.303030_g2721_i0	PRJNA801875	2824	200	4.30303	8.60606	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	65.8	2.23e-6	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g2721	i0	88.679	0.265	53	6	27	0	95	147	1088831	1088883	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	53	65.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
9729174	9729174	PRJNA801875_P_NODE_4008_length_164_cov_0.922481_g3905_i0	PRJNA801875	4008	164	0.922481	1.51286884	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	60.2	8.18e-5	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g3905	i0	97.143	19.3048780487805	35	1	21	0	10	44	35115	35081	Bdellovibrio bacteriovorus W, complete genome	blastn	3166	60.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13975652	13975652	PRJNA801875_P_NODE_2291_length_231_cov_21.596939_g2188_i0	PRJNA801875	2291	231	21.596939	49.88892909	root	1	Root_unresolved	Root_unresolved	294	3.11e-75	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g2188	i0	89.655	168.562770562771	232	22	100	2	1	231	1677507	1677277	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	38938	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21623837	21623837	PRJNA801875_P_NODE_737_length_496_cov_13.783080_g635_i0	PRJNA801875	737	496	13.78308	68.3640768	Bdellovibrio	958	Bacteria	Bacteria	368	4.23e-97	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g635	i0	80.439	199.010080645161	501	82	99	12	1	491	1676850	1676356	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	98709	368	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27054216	27054216	PRJNA801875_P_NODE_4362_length_156_cov_3.165289_g4259_i0	PRJNA801875	4362	156	3.165289	4.93785084	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	83.2	3.6e-17	NR	MFA7277246.1	2026715	g4259	i0	76	0.961538461538462	50	12	96.2	0	151	2	26	75	MFA7277246.1 alkene reductase [Pseudobdellovibrionaceae bacterium]	diamond	150	83.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
29936741	29936741	PRJNA801875_P_NODE_3091_length_189_cov_1.500000_g2988_i0	PRJNA801875	3091	189	1.5	2.835	Pseudomonadati	3379134	Bacteria	Bacteria	114	1.03e-27	NR	NUN04832.1	28201	g2988	i0	86.7	36.3174603174603	60	8	95.2	0	184	5	489	548	NUN04832.1 acetate--CoA ligase [Bdellovibrio sp.]	diamond	6864	115	0.991304347826087	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
30243862	30243862	PRJNA801875_P_NODE_1912_length_267_cov_1.943966_g1809_i0	PRJNA801875	1912	267	1.943966	5.19038922	Bacteriovorax stolpii	960	Bacteria	Bacteria	74.7	2.72e-13	NR	WP_102242354.1	960	g1809	i0	54.5	1.48314606741573	66	29	74.2	1	225	28	6	70	WP_102242354.1 NAD-dependent epimerase/dehydratase family protein [Bacteriovorax stolpii]	diamond	396	74.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
30622710	30622710	PRJNA801875_P_NODE_2473_length_219_cov_2.163043_g2370_i0	PRJNA801875	2473	219	2.163043	4.73706417	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	65.9	1.19e-11	NR	MFT6069331.1	2081706	g2370	i0	58.1	4.28767123287671	43	18	58.9	0	88	216	63	105	MFT6069331.1 putative membrane protein YedE/YeeE [Bacteriovoracaceae bacterium]	diamond	939	65.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31919117	31919117	PRJNA801875_P_NODE_877_length_447_cov_1.667476_g775_i0	PRJNA801875	877	447	1.667476	7.45361772	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	206	4.13e-63	NR	MEO5969990.1	3034169	g775	i0	67.4	0.966442953020134	144	47	96.6	0	440	9	85	228	MEO5969990.1 NAD(P)H-quinone oxidoreductase [Bdellovibrionia bacterium]	diamond	432	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia 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);;