metadata: contig_metadata: 8 rows where bioproject = "PRJNA608894" and tax

8 rows where bioproject = "PRJNA608894" 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
1861366	1861366	PRJNA608894_P_NODE_36562_length_297_cov_5.736607_g36063_i0	PRJNA608894	36562	297	5.736607	17.03772279	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	470	6.43e-128	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g36063	i0	95.27	177.962962962963	296	14	99	0	1	296	3252537	3252242	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	52855	470	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
4975268	4975268	PRJNA608894_P_NODE_52064_length_249_cov_0.875000_g51565_i0	PRJNA608894	52064	249	0.875	2.17875	Bacteriovorax	146784	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g51565	i0	99.598	238.666666666667	249	1	100	0	1	249	1661684	1661436	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	59428	455	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
11350497	11350497	PRJNA608894_P_NODE_26369_length_367_cov_3.448980_g25872_i0	PRJNA608894	26369	367	3.44898	12.6577566	Bdellovibrio	958	Bacteria	Bacteria	246	1.49e-60	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g25872	i0	86.878	116.942779291553	221	27	60	2	84	304	611717	611499	Bdellovibrio bacteriovorus W, complete genome	blastn	42918	248	0.991935483870968	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25373332	25373332	PRJNA608894_P_NODE_15600_length_554_cov_2.835759_g15108_i0	PRJNA608894	15600	554	2.835759	15.71010486	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	706	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g15108	i0	89.73	167.518050541516	555	53	99	4	3	554	621	1174	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	92805	713	0.990182328190743	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
28564465	28564465	PRJNA608894_P_NODE_22127_length_421_cov_1.370690_g21631_i0	PRJNA608894	22127	421	1.37069	5.7706049	Oligoflexus sp.	1971216	Bacteria	Bacteria	80.9	4.67e-16	NR	WP_324954760.1	1971216	g21631	i0	64.9	0.406175771971496	57	20	40.6	0	36	206	94	150	WP_324954760.1 hypothetical protein [Oligoflexus sp.]	diamond	171	80.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
28659276	28659276	PRJNA608894_P_NODE_55087_length_246_cov_0.890173_g54588_i0	PRJNA608894	55087	246	0.890173	2.18982558	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	56.2	5.78e-7	NR	MEC7274862.1	3034175	g54588	i0	37.5	1.76829268292683	72	44	86.6	1	12	224	222	293	MEC7274862.1 class I SAM-dependent methyltransferase [Bdellovibrionota bacterium]	diamond	435	56.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29922298	29922298	PRJNA608894_P_NODE_51891_length_249_cov_0.875000_g51392_i0	PRJNA608894	51891	249	0.875	2.17875	Peredibacter starrii	28202	Bacteria	Bacteria	143	1.0399999999999998e-37	NR	WP_321399788.1	28202	g51392	i0	92.8	1	83	6	100	0	249	1	258	340	WP_321399788.1 ABC-F family ATP-binding cassette domain-containing protein [Peredibacter starrii]	diamond	249	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
32861190	32861190	PRJNA608894_P_NODE_27780_length_354_cov_2.366548_g27281_i0	PRJNA608894	27780	354	2.366548	8.37757992	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	72.8	8.75e-13	NR	MEE3080293.1	3034175	g27281	i0	43.4	0.703389830508475	83	41	69.5	2	352	107	147	224	MEE3080293.1 peroxiredoxin-like family protein [Bdellovibrionota bacterium]	diamond	249	72.8	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota 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);;