metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB11748" 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
3843952	3843952	PRJEB11748_P_NODE_300664_length_219_cov_2.829114_g298481_i0	PRJEB11748	300664	219	2.829114	6.19575966	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	187	5.089999999999998e-43	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g298481	i0	83.663	9.2283105022831	202	29	91	4	20	219	524034	524233	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	2021	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7360478	7360478	PRJEB11748_P_NODE_123786_length_372_cov_10.755627_g121610_i0	PRJEB11748	123786	372	10.755627	40.01093244	Bacteriovorax	146784	Bacteria	Bacteria	523	6.239999999999998e-144	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g121610	i0	93.696	232.66935483871	349	22	94	0	1	349	1660841	1660493	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	86553	523	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9913490	9913490	PRJEB11748_P_NODE_78028_length_476_cov_4.491566_g75869_i0	PRJEB11748	78028	476	4.491566	21.37985416	Pseudomonadati	3379134	Bacteria	Bacteria	268	4.23e-67	NTclustered	gi\|2531963191\|emb\|OY282434.1\|	2735263	g75869	i0	77.609	137.296218487395	460	92	95	10	1	453	956277	956732	MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1	blastn	65353	270	0.992592592592593	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			uncultured Oligoflexales bacterium
10220566	10220566	PRJEB11748_P_NODE_301249_length_219_cov_1.620253_g299066_i0	PRJEB11748	301249	219	1.620253	3.54835407	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	316	6.22e-82	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g299066	i0	94.608	0.931506849315068	204	11	93	0	1	204	2566681	2566884	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	204	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
11186157	11186157	PRJEB11748_P_NODE_124029_length_372_cov_3.884244_g121853_i0	PRJEB11748	124029	372	3.884244	14.44938768	Bdellovibrio	958	Bacteria	Bacteria	63.9	1.63e-5	NTclustered	gi\|2771112236\|gb\|CP160486.1\|	959	g121853	i0	97.297	6.78763440860215	37	1	10	0	317	353	761832	761796	Bdellovibrio bacteriovorus strain MHI39 chromosome	blastn	2525	63.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11186723	11186723	PRJEB11748_P_NODE_189389_length_293_cov_3.405172_g187206_i0	PRJEB11748	189389	293	3.405172	9.97715396	Bdellovibrio	958	Bacteria	Bacteria	285	2.4599999999999997e-72	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g187206	i0	86.194	188.491467576792	268	31	90	5	24	286	815223	815489	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	55228	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
12772463	12772463	PRJEB11748_P_NODE_368411_length_188_cov_6.047244_g366228_i0	PRJEB11748	368411	188	6.047244	11.36881872	Bacteriovorax stolpii	960	Bacteria	Bacteria	233	5.36e-57	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g366228	i0	92.121	2.63297872340426	165	13	88	0	24	188	156622	156786	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	495	233	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
16591361	16591361	PRJEB11748_P_NODE_133234_length_358_cov_2.670034_g131057_i0	PRJEB11748	133234	358	2.670034	9.55872172	uncultured Oligoflexales bacterium	2735263	Bacteria	Bacteria	307	6.55e-79	NTclustered	gi\|2531963191\|emb\|OY282434.1\|	2735263	g131057	i0	84.918	98.7262569832402	305	44	85	2	43	346	955253	955556	MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1	blastn	35344	307	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			uncultured Oligoflexales bacterium
17563045	17563045	PRJEB11748_P_NODE_70194_length_504_cov_3.083521_g68047_i0	PRJEB11748	70194	504	3.083521	15.54094584	Bacteriovorax	146784	Bacteria	Bacteria	143	2.84e-29	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g68047	i0	77.953	1.51190476190476	254	38	50	12	21	270	1646645	1646884	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	762	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
17868658	17868658	PRJEB11748_P_NODE_253955_length_244_cov_5.901639_g251772_i0	PRJEB11748	253955	244	5.901639	14.39999916	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	388	1.48e-103	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g251772	i0	98.198	16.7295081967213	222	4	91	0	23	244	2810649	2810870	Bdellovibrio sp. HM001 DNA, complete genome	blastn	4082	388	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
19144538	19144538	PRJEB11748_P_NODE_379856_length_179_cov_12.500000_g377673_i0	PRJEB11748	379856	179	12.5	22.375	Bacteriovorax stolpii	960	Bacteria	Bacteria	268	1.3799999999999999e-67	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g377673	i0	98.052	1.72067039106145	154	3	86	0	2	155	519861	520014	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	308	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20111268	20111268	PRJEB11748_P_NODE_370496_length_187_cov_5.666667_g368313_i0	PRJEB11748	370496	187	5.666667	10.59666729	Peredibacter	263370	Bacteria	Bacteria	259	8.79e-65	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g368313	i0	95.152	112.732620320856	165	7	88	1	24	187	512380	512544	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	21081	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
20112116	20112116	PRJEB11748_P_NODE_98496_length_421_cov_3.091667_g96326_i0	PRJEB11748	98496	421	3.091667	13.01591807	Pseudobdellovibrio	2862745	Bacteria	Bacteria	697	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g96326	i0	96.659	195.46080760095	419	14	99	0	3	421	753	1171	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	82289	697	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
21384881	21384881	PRJEB11748_P_NODE_119597_length_379_cov_13.663522_g117421_i0	PRJEB11748	119597	379	13.663522	51.78474838	Bacteriovorax	146784	Bacteria	Bacteria	375	1.8899999999999997e-99	NTclustered	gi\|1326041851\|gb\|CP025704.1\|	960	g117421	i0	86.51	11.6121372031662	341	46	90	0	9	349	3650833	3651173	Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome	blastn	4401	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
21386804	21386804	PRJEB11748_P_NODE_367277_length_189_cov_2.507812_g365094_i0	PRJEB11748	367277	189	2.507812	4.73976468	Bdellovibrio	958	Bacteria	Bacteria	102	1.59e-17	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g365094	i0	77.778	75.7089947089947	189	27	95	13	1	180	756310	756128	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	14309	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
21386942	21386942	PRJEB11748_P_NODE_396357_length_168_cov_4.280374_g394174_i0	PRJEB11748	396357	168	4.280374	7.19102832	Pseudobdellovibrio	2862745	Bacteria	Bacteria	187	3.71e-43	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g394174	i0	88.961	66.3452380952381	154	13	90	2	17	168	319	470	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	11146	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
22661597	22661597	PRJEB11748_P_NODE_357858_length_193_cov_27.272727_g355675_i0	PRJEB11748	357858	193	27.272727	52.63636311	Bdellovibrio	958	Bacteria	Bacteria	244	2.56e-60	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g355675	i0	92.442	24.3160621761658	172	11	88	2	24	193	841434	841605	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	4693	244	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22971742	22971742	PRJEB11748_P_NODE_62219_length_538_cov_3.171908_g60082_i0	PRJEB11748	62219	538	3.171908	17.06486504	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	725	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g60082	i0	92.203	127.635687732342	513	39	95	1	25	536	1292260	1292772	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	68668	725	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
24240385	24240385	PRJEB11748_P_NODE_130360_length_362_cov_5.282392_g128183_i0	PRJEB11748	130360	362	5.282392	19.12225904	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	531	3.62e-146	NTclustered	gi\|425858678\|gb\|CP002930.1\|	1069642	g128183	i0	97.444	14.5359116022099	313	5	86	3	22	332	699902	700213	Bdellovibrio bacteriovorus str. Tiberius, complete genome	blastn	5262	531	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24241415	24241415	PRJEB11748_P_NODE_181420_length_300_cov_11.543933_g179237_i0	PRJEB11748	181420	300	11.543933000000001	34.631799	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	442	1.4199999999999995e-119	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g179237	i0	94.158	3.88333333333333	291	15	96	2	1	289	2316934	2316644	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	1165	442	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
25209952	25209952	PRJEB11748_P_NODE_252480_length_245_cov_4.380435_g250297_i0	PRJEB11748	252480	245	4.380435	10.73206575	Bacteriovorax	146784	Bacteria	Bacteria	296	9.249999999999999e-76	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g250297	i0	91.943	2.93061224489796	211	17	86	0	34	244	811336	811126	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	718	296	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii

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