metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA694770" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
674312	674312	PRJNA694770_P_NODE_37401_length_335_cov_1.175573_g37107_i0	PRJNA694770	37401	335	1.175573	3.93816955	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	335	2.8e-87	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g37107	i0	85.893	10.5820895522388	319	39	94	6	1	316	2954428	2954743	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	3545	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
675927	675927	PRJNA694770_P_NODE_95121_length_243_cov_0.905882_g94827_i0	PRJNA694770	95121	243	0.905882	2.20129326	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g94827	i0	100	1	243	0	100	0	1	243	2557295	2557537	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	243	449	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
1951184	1951184	PRJNA694770_P_NODE_69402_length_265_cov_1.406250_g69108_i0	PRJNA694770	69402	265	1.40625	3.7265625	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	302	2.18e-77	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g69108	i0	87.218	28.9094339622641	266	32	100	2	1	265	1220543	1220807	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	7661	302	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
5008485	5008485	PRJNA694770_P_NODE_26344_length_381_cov_1.000000_g26050_i0	PRJNA694770	26344	381	1	3.81	Bdellovibrio	958	Bacteria	Bacteria	435	3.09e-117	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g26050	i0	87.5	10.1023622047244	376	47	99	0	6	381	3460764	3460389	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	3849	435	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7054339	7054339	PRJNA694770_P_NODE_87486_length_247_cov_0.885057_g87192_i0	PRJNA694770	87486	247	0.885057	2.18609079	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	235	2.07e-57	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g87192	i0	85.59	8.41295546558704	229	28	92	4	1	228	92164	92388	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	2078	235	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8833126	8833126	PRJNA694770_P_NODE_26327_length_381_cov_1.250000_g26033_i0	PRJNA694770	26327	381	1.25	4.7625	Bdellovibrio	958	Bacteria	Bacteria	213	1.57e-50	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g26033	i0	79.605	1.6246719160105	304	56	79	4	75	375	2478611	2478911	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	619	213	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
10878243	10878243	PRJNA694770_P_NODE_33249_length_350_cov_1.389892_g32955_i0	PRJNA694770	33249	350	1.389892	4.864622	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	647	0	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g32955	i0	100	1	350	0	100	0	1	350	2575464	2575115	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	350	647	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
17759103	17759103	PRJNA694770_P_NODE_85374_length_248_cov_0.880000_g85080_i0	PRJNA694770	85374	248	0.88	2.1824	Bdellovibrio	958	Bacteria	Bacteria	348	2.55e-91	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g85080	i0	91.935	82.0725806451613	248	20	100	0	1	248	750708	750461	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	20354	348	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18526427	18526427	PRJNA694770_P_NODE_42975_length_317_cov_1.520492_g42681_i0	PRJNA694770	42975	317	1.520492	4.81995964	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	580	3.0599999999999993e-161	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g42681	i0	99.685	1	317	1	100	0	1	317	2585855	2586171	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	317	580	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
18527050	18527050	PRJNA694770_P_NODE_66195_length_270_cov_1.477157_g65901_i0	PRJNA694770	66195	270	1.477157	3.9883239	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	497	2.6399999999999998e-136	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g65901	i0	100	0.996296296296296	269	0	99	0	2	270	2550201	2550469	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	269	497	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
18527131	18527131	PRJNA694770_P_NODE_69115_length_265_cov_1.921875_g68821_i0	PRJNA694770	69115	265	1.921875	5.09296875	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g68821	i0	100	1	265	0	100	0	1	265	2540619	2540355	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	265	490	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
19802222	19802222	PRJNA694770_P_NODE_74636_length_256_cov_1.683060_g74342_i0	PRJNA694770	74636	256	1.68306	4.3086336	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	147	1.04e-30	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g74342	i0	78.099	26.2109375	242	45	93	7	20	256	521255	521493	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	6710	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21076055	21076055	PRJNA694770_P_NODE_101777_length_213_cov_2.714286_g101483_i0	PRJNA694770	101777	213	2.714286	5.78142918	Bdellovibrio sp. HCB290	3394356	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2895991164\|gb\|CP178620.1\|	3394356	g101483	i0	100	0.131455399061033	28	0	13	0	71	98	1886036	1886063	Bdellovibrio sp. HCB290 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB290
23626888	23626888	PRJNA694770_P_NODE_30399_length_362_cov_1.065744_g30105_i0	PRJNA694770	30399	362	1.065744	3.85799328	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	163	1.52e-35	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g30105	i0	97.872	48.4364640883978	94	2	26	0	47	140	1756787	1756880	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	17534	163	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
23627714	23627714	PRJNA694770_P_NODE_60979_length_278_cov_1.502439_g60685_i0	PRJNA694770	60979	278	1.502439	4.17678042	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	263	1.09e-65	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g60685	i0	85.057	7.50719424460432	261	35	93	4	1	259	3641734	3641476	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	2087	263	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23628183	23628183	PRJNA694770_P_NODE_78839_length_251_cov_0.865169_g78545_i0	PRJNA694770	78839	251	0.865169	2.17157419	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	339	1.56e-88	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g78545	i0	91.2	1.9840637450199201	250	20	99	2	3	251	1887763	1888011	Bdellovibrio exovorus JSS, complete genome	blastn	498	339	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
24900961	24900961	PRJNA694770_P_NODE_49580_length_298_cov_1.368889_g49286_i0	PRJNA694770	49580	298	1.368889	4.07928922	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	551	2.239999999999999e-152	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g49286	i0	100	1.09395973154362	298	0	100	0	1	298	2594309	2594606	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	326	551	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
24901214	24901214	PRJNA694770_P_NODE_59200_length_281_cov_1.110577_g58906_i0	PRJNA694770	59200	281	1.110577	3.12072137	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	279	1.09e-70	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g58906	i0	84.643	2.8576512455516	280	43	99	0	2	281	1214405	1214126	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	803	279	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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