metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA505329" 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
483152	483152	PRJNA505329_P_NODE_14141_length_233_cov_2.766304_g13670_i0	PRJNA505329	14141	233	2.766304	6.44548832	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	147	9.3e-31	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g13670	i0	93	4.24034334763949	100	7	43	0	134	233	339093	339192	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	988	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2385756	2385756	PRJNA505329_P_NODE_17782_length_217_cov_2.589286_g17311_i0	PRJNA505329	17782	217	2.589286	5.61875062	Bdellovibrio	958	Bacteria	Bacteria	359	1.01e-94	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g17311	i0	97.17	107.483870967742	212	6	98	0	4	215	2948767	2948556	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	23324	359	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6213926	6213926	PRJNA505329_P_NODE_5945_length_307_cov_4.286822_g5474_i0	PRJNA505329	5945	307	4.286822	13.16054354	Peredibacter	263370	Bacteria	Bacteria	268	2.61e-67	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g5474	i0	96.875	48.5667752442997	160	5	95	0	147	306	512032	512191	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	14910	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
7488332	7488332	PRJNA505329_P_NODE_18766_length_205_cov_3.416667_g18295_i0	PRJNA505329	18766	205	3.416667	7.00416735	Bdellovibrio	958	Bacteria	Bacteria	298	2.08e-76	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g18295	i0	92.925	164.682926829268	212	4	98	1	4	204	816241	816452	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	33760	298	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8136473	8136473	PRJNA505329_P_NODE_27367_length_191_cov_1.809859_g26896_i0	PRJNA505329	27367	191	1.809859	3.45683069	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	252	1.51e-62	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g26896	i0	90.576	145.057591623037	191	16	99	2	1	190	778316	778127	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	27706	252	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9411536	9411536	PRJNA505329_P_NODE_37068_length_176_cov_2.866142_g36597_i0	PRJNA505329	37068	176	2.866142	5.04440992	Peredibacter starrii	28202	Bacteria	Bacteria	183	5.05e-42	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g36597	i0	86.55	66.9318181818182	171	18	96	5	3	171	510742	510909	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	11780	183	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10038751	10038751	PRJNA505329_P_NODE_19188_length_202_cov_3.790850_g18717_i0	PRJNA505329	19188	202	3.79085	7.657517	Bacteria	2	Bacteria	Bacteria	148	2.18e-31	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g18717	i0	81.771	710.633663366337	192	22	92	9	13	197	319	504	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	143548	148	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
10038910	10038910	PRJNA505329_P_NODE_45608_length_166_cov_0.888889_g45137_i0	PRJNA505329	45608	166	0.888889	1.47555574	Peredibacter	263370	Bacteria	Bacteria	259	7.63e-65	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g45137	i0	95.679	147.849397590361	162	5	98	1	4	165	511817	511976	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	24543	259	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10687374	10687374	PRJNA505329_P_NODE_5289_length_333_cov_4.429577_g4819_i0	PRJNA505329	5289	333	4.429577	14.75049141	Peredibacter starrii	28202	Bacteria	Bacteria	544	4.25e-150	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4819	i0	96.108	225.630630630631	334	11	99	1	2	333	512191	511858	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	75135	544	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
11313531	11313531	PRJNA505329_P_NODE_36769_length_177_cov_1.601562_g36298_i0	PRJNA505329	36769	177	1.601562	2.83476474	Bdellovibrio	958	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g36298	i0	100	2.94915254237288	174	0	98	0	1	174	765432	765259	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	522	322	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
11961919	11961919	PRJNA505329_P_NODE_10170_length_233_cov_4.451087_g9699_i0	PRJNA505329	10170	233	4.451087	10.37103271	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	187	5.48e-43	NTclustered	gi\|2663436463\|dbj\|AP029181.1\|	3113895	g9699	i0	100	1.70815450643777	101	0	85	0	133	233	8975	8875	Bdellovibrio sp. HAGR004 plasmid pBdHAGR5 DNA, complete sequence	blastn	398	187	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
11961994	11961994	PRJNA505329_P_NODE_15990_length_233_cov_2.521739_g15519_i0	PRJNA505329	15990	233	2.521739	5.8756518700000004	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	174	4.27e-39	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g15519	i0	98.969	0.416309012875536	97	1	42	0	4	100	2288762	2288858	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	97	174	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
12589322	12589322	PRJNA505329_P_NODE_39130_length_173_cov_2.225806_g38659_i0	PRJNA505329	39130	173	2.225806	3.85064438	Bdellovibrio	958	Bacteria	Bacteria	279	6.12e-71	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g38659	i0	96.45	187.549132947977	169	6	98	0	2	170	611191	611023	Bdellovibrio bacteriovorus W, complete genome	blastn	32446	279	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13237442	13237442	PRJNA505329_P_NODE_44971_length_166_cov_1.794872_g44500_i0	PRJNA505329	44971	166	1.794872	2.97948752	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	231	1.6599999999999998e-56	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g44500	i0	92.593	200.680722891566	162	11	98	1	4	165	3250804	3250964	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	33313	231	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
13864128	13864128	PRJNA505329_P_NODE_3791_length_430_cov_4.847769_g3330_i0	PRJNA505329	3791	430	4.847769	20.8454067	Bdellovibrio	958	Bacteria	Bacteria	763	0	NTclustered	gi\|2771112236\|gb\|CP160486.1\|	959	g3330	i0	98.832	183.467441860465	428	5	99	0	1	428	823428	823855	Bdellovibrio bacteriovorus strain MHI39 chromosome	blastn	78891	763	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15138425	15138425	PRJNA505329_P_NODE_43352_length_168_cov_0.873950_g42881_i0	PRJNA505329	43352	168	0.87395	1.468236	Bacteriovorax	146784	Bacteria	Bacteria	248	1.68e-61	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g42881	i0	93.413	29.9642857142857	167	11	99	0	2	168	1660593	1660759	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	5034	248	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
15138496	15138496	PRJNA505329_P_NODE_7292_length_271_cov_2.288288_g6821_i0	PRJNA505329	7292	271	2.288288	6.20126048	Bdellovibrio	958	Bacteria	Bacteria	399	7.699999999999999e-107	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g6821	i0	97.046	77.7084870848709	237	7	87	0	29	265	755859	756095	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	21059	399	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
18335157	18335157	PRJNA505329_P_NODE_40535_length_171_cov_1.688525_g40064_i0	PRJNA505329	40535	171	1.688525	2.88737775	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	222	1.03e-53	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g40064	i0	90.476	3.92982456140351	168	16	98	0	4	171	3322685	3322852	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	672	222	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
19609589	19609589	PRJNA505329_P_NODE_48296_length_163_cov_2.157895_g47825_i0	PRJNA505329	48296	163	2.157895	3.51736885	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	158	2.8e-34	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g47825	i0	85.065	1.85889570552147	154	23	94	0	1	154	123572	123419	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	303	158	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
21512379	21512379	PRJNA505329_P_NODE_50337_length_161_cov_3.125000_g49866_i0	PRJNA505329	50337	161	3.125	5.03125	Bdellovibrio	958	Bacteria	Bacteria	213	5.8e-51	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g49866	i0	91.083	9.43478260869565	157	14	98	0	5	161	3042692	3042848	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1519	213	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22159872	22159872	PRJNA505329_P_NODE_15138_length_233_cov_2.668478_g14667_i0	PRJNA505329	15138	233	2.668478	6.21755374	Bdellovibrio sp. HCB-162	3394234	Bacteria	Bacteria	104	5.68e-18	NTclustered	gi\|2898207634\|gb\|CP178861.1\|	3394234	g14667	i0	86.316	0.407725321888412	95	13	41	0	137	231	3535816	3535910	Bdellovibrio sp. HCB-162 chromosome, complete genome	blastn	95	104	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB-162
22787418	22787418	PRJNA505329_P_NODE_40698_length_171_cov_1.565574_g40227_i0	PRJNA505329	40698	171	1.565574	2.67713154	Bdellovibrio	958	Bacteria	Bacteria	313	5.95e-81	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g40227	i0	100	16.8011695906433	169	0	99	0	1	169	61380	61212	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	2873	313	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
23435660	23435660	PRJNA505329_P_NODE_17999_length_214_cov_3.951515_g17528_i0	PRJNA505329	17999	214	3.951515	8.4562421	Peredibacter starrii	28202	Bacteria	Bacteria	335	1.6699999999999995e-87	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g17528	i0	95.261	165.85046728972	211	10	99	0	3	213	512294	512504	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	35492	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23435674	23435674	PRJNA505329_P_NODE_19499_length_201_cov_5.322368_g19028_i0	PRJNA505329	19499	201	5.322368	10.69795968	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	276	9.53e-70	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g19028	i0	90.868	8.71641791044776	219	0	99	1	3	201	159839	160057	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	1752	276	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
25336680	25336680	PRJNA505329_P_NODE_24240_length_196_cov_3.612245_g23769_i0	PRJNA505329	24240	196	3.612245	7.0800002	Bdellovibrio	958	Bacteria	Bacteria	189	1.24e-43	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g23769	i0	100	3.60714285714286	102	0	99	0	95	196	2407941	2407840	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	707	189	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001

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