metadata: contig_metadata: 17 rows where bioproject = "PRJNA1000943" and tax

17 rows where bioproject = "PRJNA1000943" 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
999280	999280	PRJNA1000943_P_NODE_9001_length_277_cov_1.911765_g8863_i0	PRJNA1000943	9001	277	1.911765	5.29558905	Pseudobdellovibrio	2862745	Bacteria	Bacteria	178	4.029999999999999e-40	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g8863	i0	78.767	20.2093862815884	292	43	100	10	1	277	1637	1350	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	5598	178	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
2695297	2695297	PRJNA1000943_P_NODE_12963_length_248_cov_0.891429_g12825_i0	PRJNA1000943	12963	248	0.891429	2.21074392	Pseudobacteriovorax	1769746	Bacteria	Bacteria	121	7.1e-30	NR	NRA68712.1	2020859	g12825	i0	73.8	6.7258064516129	80	21	96.8	0	247	8	148	227	NRA68712.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Pseudobacteriovorax sp.]	diamond	1668	122	0.991803278688525	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax sp.
6102402	6102402	PRJNA1000943_P_NODE_5565_length_340_cov_1.632959_g5427_i0	PRJNA1000943	5565	340	1.632959	5.5520606	Bdellovibrio	958	Bacteria	Bacteria	316	1.0299999999999999e-81	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g5427	i0	84.164	306.002941176471	341	39	98	12	1	333	783093	783426	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	104041	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7376733	7376733	PRJNA1000943_P_NODE_4066_length_389_cov_1.547468_g3929_i0	PRJNA1000943	4066	389	1.547468	6.01965052	Bdellovibrio	958	Bacteria	Bacteria	503	8.54e-138	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g3929	i0	89.899	194.52442159383	396	33	100	4	1	389	784587	784192	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	75670	508	0.990157480314961	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11623737	11623737	PRJNA1000943_P_NODE_350_length_1137_cov_5.222744_g288_i0	PRJNA1000943	350	1137	5.222744	59.38259928	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	1956	0	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g288	i0	97.715	178.018469656992	1138	24	100	2	1	1137	699588	700724	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	202407	1956	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
15027081	15027081	PRJNA1000943_P_NODE_12572_length_249_cov_0.886364_g12434_i0	PRJNA1000943	12572	249	0.886364	2.20704636	Pseudobdellovibrio	2862745	Bacteria	Bacteria	276	1.2299999999999999e-69	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g12434	i0	86.853	290.78313253012	251	28	99	5	1	248	426	178	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	72405	276	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
18850918	18850918	PRJNA1000943_P_NODE_10275_length_261_cov_1.851064_g10137_i0	PRJNA1000943	10275	261	1.851064	4.83127704	Bacteriovorax	146784	Bacteria	Bacteria	392	1.2299999999999999e-104	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g10137	i0	93.87	397.563218390805	261	14	99	2	1	260	1662088	1661829	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	103764	392	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18850944	18850944	PRJNA1000943_P_NODE_2275_length_506_cov_12.577367_g2138_i0	PRJNA1000943	2275	506	12.577367	63.64147702	Bdellovibrio	958	Bacteria	Bacteria	846	0	NTclustered	gi\|425858678\|gb\|CP002930.1\|	1069642	g2138	i0	96.838	127.025691699605	506	16	100	0	1	506	842408	842913	Bdellovibrio bacteriovorus str. Tiberius, complete genome	blastn	64275	852	0.992957746478873	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20125763	20125763	PRJNA1000943_P_NODE_1256_length_673_cov_2.016667_g1125_i0	PRJNA1000943	1256	673	2.016667	13.57216891	Bacteriovorax	146784	Bacteria	Bacteria	845	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1125	i0	89.365	148.364041604755	677	64	100	8	1	673	1661033	1660361	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	99849	845	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20125811	20125811	PRJNA1000943_P_NODE_956_length_760_cov_7.478894_g830_i0	PRJNA1000943	956	760	7.478894	56.8395944	Bdellovibrio	958	Bacteria	Bacteria	1315	0	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g830	i0	97.898	127.067105263158	761	15	100	1	1	760	749548	748788	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	96571	1315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20546245	20546245	PRJNA1000943_P_NODE_12317_length_250_cov_0.881356_g12179_i0	PRJNA1000943	12317	250	0.881356	2.20339	Bdellovibrio sp. 28-41-41	1970323	Bacteria	Bacteria	171	1.64e-53	NR	OYZ13569.1	1970323	g12179	i0	98.8	0.996	83	1	99.6	0	1	249	2	84	OYZ13569.1 MAG: thioredoxin [Bdellovibrio sp. 28-41-41]	diamond	249	171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41
24371070	24371070	PRJNA1000943_P_NODE_6620_length_316_cov_1.283951_g6482_i0	PRJNA1000943	6620	316	1.283951	4.05728516	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	254	7.560000000000001e-63	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g6482	i0	87.111	153.509493670886	225	27	71	2	81	304	730038	730261	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	48509	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29213576	29213576	PRJNA1000943_P_NODE_13869_length_246_cov_0.901734_g13731_i0	PRJNA1000943	13869	246	0.901734	2.21826564	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	107	4.63e-26	NR	WP_061834069.1	959	g13731	i0	67.1	2.89024390243902	79	26	96.3	0	10	246	1	79	WP_061834069.1 SDR family oxidoreductase [Bdellovibrio bacteriovorus]	diamond	711	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
30413790	30413790	PRJNA1000943_P_NODE_11793_length_251_cov_0.876404_g11655_i0	PRJNA1000943	11793	251	0.876404	2.19977404	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	70.9	2.12e-12	NR	MCC6137820.1	2026715	g11655	i0	97	0.394422310756972	33	1	39.4	0	250	152	230	262	MCC6137820.1 DUF1338 domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	99	70.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
31038343	31038343	PRJNA1000943_P_NODE_4095_length_388_cov_0.946032_g3958_i0	PRJNA1000943	4095	388	0.946032	3.67060416	Pseudomonadati	3379134	Bacteria	Bacteria	111	1.99e-28	NR	MFA4994930.1	2053517	g3958	i0	49.6	15.0927835051546	113	54	85.1	3	337	8	5	117	MFA4994930.1 single-stranded DNA-binding protein [Bdellovibrionales bacterium]	diamond	5856	112	0.991071428571429	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31298229	31298229	PRJNA1000943_P_NODE_12975_length_248_cov_0.891429_g12837_i0	PRJNA1000943	12975	248	0.891429	2.21074392	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	58.2	1.46e-7	NR	MBT7608812.1	2081706	g12837	i0	45.6	1.28225806451613	57	31	69	0	197	27	676	732	MBT7608812.1 penicillin acylase family protein [Bacteriovoracaceae bacterium]	diamond	318	58.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32847060	32847060	PRJNA1000943_P_NODE_6960_length_309_cov_2.644068_g6822_i0	PRJNA1000943	6960	309	2.644068	8.17017012	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	51.6	4.04e-5	NR	MCO4753379.1	2081706	g6822	i0	34.4	0.902912621359223	93	50	83.5	3	5	262	72	160	MCO4753379.1 glutathione S-transferase [Bacteriovoracaceae bacterium]	diamond	279	51.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae 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);;