metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA492280" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA492280" 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
452182	452182	PRJNA492280_P_NODE_4601_length_235_cov_14.590909_g4494_i0	PRJNA492280	4601	235	14.590909	34.28863615	uncultured Micavibrio sp.	362447	Bacteria	Bacteria	217	7.06e-52	NTclustered	gi\|2621703983\|emb\|OY762938.1\|	362447	g4494	i0	91.195	285.191489361702	159	14	68	0	74	232	960382	960540	MAG: uncultured Micavibrio sp. isolate 194a20bb-105a-45c9-9846-0688499aae06 genome assembly, chromosome: 1	blastn	67020	217	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	uncultured Micavibrio sp.
1099113	1099113	PRJNA492280_P_NODE_6761_length_200_cov_4.521472_g6654_i0	PRJNA492280	6761	200	4.521472	9.042944	Bacteriovorax	146784	Bacteria	Bacteria	339	1.19e-88	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g6654	i0	97.949	172.365	195	4	98	0	3	197	1660595	1660401	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	34473	339	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
3649984	3649984	PRJNA492280_P_NODE_19023_length_164_cov_3.496063_g18916_i0	PRJNA492280	19023	164	3.496063	5.73354332	Bacteriovorax	146784	Bacteria	Bacteria	134	4.75e-27	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g18916	i0	98.667	109.823170731707	75	1	91	0	2	76	1661321	1661247	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	18011	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
3650017	3650017	PRJNA492280_P_NODE_22563_length_164_cov_2.921260_g22456_i0	PRJNA492280	22563	164	2.92126	4.7908664	Bdellovibrio	958	Bacteria	Bacteria	215	1.65e-51	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g22456	i0	87.574	128.176829268293	169	15	99	1	1	163	817512	817344	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	21021	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
3650088	3650088	PRJNA492280_P_NODE_28283_length_156_cov_10.394958_g28176_i0	PRJNA492280	28283	156	10.394958	16.21613448	Bdellovibrio	958	Bacteria	Bacteria	252	1.18e-62	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g28176	i0	97.297	96.474358974359	148	4	95	0	4	151	816953	817100	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	15050	252	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
4927280	4927280	PRJNA492280_P_NODE_9944_length_170_cov_6.729323_g9837_i0	PRJNA492280	9944	170	6.729323	11.4398491	Peredibacter	263370	Bacteria	Bacteria	134	4.94e-27	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g9837	i0	97.436	48.4588235294118	78	2	46	0	93	170	513341	513264	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	8238	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
5555548	5555548	PRJNA492280_P_NODE_22005_length_164_cov_2.984252_g21898_i0	PRJNA492280	22005	164	2.984252	4.89417328	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	128	2.21e-25	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g21898	i0	100	2.67073170731707	69	0	88	0	8	76	2852705	2852637	Bacteriovorax sp. HI3 DNA, complete genome	blastn	438	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
6829428	6829428	PRJNA492280_P_NODE_1206_length_403_cov_13.524590_g1106_i0	PRJNA492280	1206	403	13.52459	54.5040977	Peredibacter starrii	28202	Bacteria	Bacteria	405	2.57e-108	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1106	i0	94.981	77.2506203473945	259	11	83	1	144	400	512110	511852	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	31132	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
6829724	6829724	PRJNA492280_P_NODE_9806_length_171_cov_6.985075_g9699_i0	PRJNA492280	9806	171	6.985075	11.94447825	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	268	1.31e-67	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g9699	i0	98.065	42.093567251462	155	2	91	1	14	168	1292576	1292423	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	7198	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
9379754	9379754	PRJNA492280_P_NODE_15728_length_164_cov_4.330709_g15621_i0	PRJNA492280	15728	164	4.330709	7.10236276	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	132	1.71e-26	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g15621	i0	98.649	52.7134146341463	74	1	45	0	3	76	3447154	3447227	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	8645	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
9379951	9379951	PRJNA492280_P_NODE_3328_length_266_cov_34.724891_g3221_i0	PRJNA492280	3328	266	34.724891	92.36821006	Peredibacter starrii	28202	Bacteria	Bacteria	357	4.6e-94	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g3221	i0	90.114	92.8421052631579	263	23	98	1	2	261	511741	511479	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	24696	357	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10027276	10027276	PRJNA492280_P_NODE_28308_length_156_cov_6.226891_g28201_i0	PRJNA492280	28308	156	6.226891	9.71394996	Peredibacter	263370	Bacteria	Bacteria	274	2.52e-69	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g28201	i0	99.338	256.955128205128	151	1	97	0	6	156	512682	512832	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	40085	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10027422	10027422	PRJNA492280_P_NODE_7728_length_189_cov_5.907895_g7621_i0	PRJNA492280	7728	189	5.907895	11.16592155	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	154	4.32e-33	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g7621	i0	94.059	77.6190476190476	101	6	92	0	2	102	901	801	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	14670	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
11930755	11930755	PRJNA492280_P_NODE_690_length_522_cov_11.018557_g604_i0	PRJNA492280	690	522	11.018557	57.51686754	Peredibacter starrii	28202	Bacteria	Bacteria	405	3.41e-108	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g604	i0	94.981	59.9367816091954	259	11	85	1	4	260	511852	512110	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	31287	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
12578040	12578040	PRJNA492280_P_NODE_5350_length_221_cov_7.027174_g5243_i0	PRJNA492280	5350	221	7.027174	15.53005454	Bdellovibrio	958	Bacteria	Bacteria	220	5.07e-53	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g5243	i0	98.4	91.2714932126697	125	2	57	0	89	213	748325	748449	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	20171	220	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13852747	13852747	PRJNA492280_P_NODE_9211_length_176_cov_5.151079_g9104_i0	PRJNA492280	9211	176	5.151079	9.06589904	Peredibacter	263370	Bacteria	Bacteria	294	2.23e-75	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g9104	i0	97.126	140.261363636364	174	5	99	0	1	174	512529	512356	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	24686	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15127051	15127051	PRJNA492280_P_NODE_3492_length_261_cov_2.696429_g3385_i0	PRJNA492280	3492	261	2.696429	7.03767969	Pseudobdellovibrio	2862745	Bacteria	Bacteria	309	1.28e-79	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g3385	i0	87.072	70.7356321839081	263	26	98	5	2	258	1673	1413	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	18462	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15127119	15127119	PRJNA492280_P_NODE_6832_length_199_cov_5.135802_g6725_i0	PRJNA492280	6832	199	5.135802	10.22024598	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	154	4.6e-33	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g6725	i0	94.059	116.924623115578	101	6	51	0	98	198	801	901	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	23268	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15754681	15754681	PRJNA492280_P_NODE_32253_length_150_cov_7.433628_g32146_i0	PRJNA492280	32253	150	7.433628	11.150442	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	159	7e-35	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g32146	i0	85.799	1.62666666666667	169	2	98	1	1	147	1534723	1534891	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	244	159	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
18303732	18303732	PRJNA492280_P_NODE_4695_length_233_cov_19.683673_g4588_i0	PRJNA492280	4695	233	19.683673	45.86295809	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	320	5.18e-83	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g4588	i0	92.14	115.785407725322	229	14	98	4	4	230	815473	815699	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	26978	320	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20225567	20225567	PRJNA492280_P_NODE_8156_length_185_cov_4.405405_g8049_i0	PRJNA492280	8156	185	4.405405	8.14999925	Bdellovibrio	958	Bacteria	Bacteria	327	2.34e-85	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g8049	i0	98.907	293.135135135135	183	2	99	0	3	185	815758	815940	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	54230	327	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22128275	22128275	PRJNA492280_P_NODE_1198_length_404_cov_13.771117_g1098_i0	PRJNA492280	1198	404	13.771117	55.63531268	Peredibacter starrii	28202	Bacteria	Bacteria	405	2.58e-108	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1098	i0	94.981	76.4950495049505	259	11	64	1	4	260	511852	512110	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	30904	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22776138	22776138	PRJNA492280_P_NODE_6698_length_201_cov_4.219512_g6591_i0	PRJNA492280	6698	201	4.219512	8.48121912	Bdellovibrio	958	Bacteria	Bacteria	143	1.01e-29	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g6591	i0	97.59	36.3333333333333	83	2	41	0	85	167	784746	784828	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	7303	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24050807	24050807	PRJNA492280_P_NODE_23419_length_164_cov_2.811024_g23312_i0	PRJNA492280	23419	164	2.811024	4.61007936	Bdellovibrio	958	Bacteria	Bacteria	161	2.1799999999999997e-35	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g23312	i0	82.456	85.8170731707317	171	18	98	3	1	160	750282	750451	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	14074	161	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24678067	24678067	PRJNA492280_P_NODE_2860_length_282_cov_4.416327_g2753_i0	PRJNA492280	2860	282	4.416327	12.45404214	Peredibacter starrii	28202	Bacteria	Bacteria	355	1.7699999999999997e-93	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2753	i0	89.716	74.3262411347518	282	24	99	5	3	282	510799	511077	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	20960	355	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25325204	25325204	PRJNA492280_P_NODE_32280_length_150_cov_7.212389_g32173_i0	PRJNA492280	32280	150	7.212389	10.8185835	Bacteriovorax	146784	Bacteria	Bacteria	226	6.8e-55	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g32173	i0	94.118	24.1333333333333	153	2	97	1	2	147	1663197	1663045	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	3620	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
25325304	25325304	PRJNA492280_P_NODE_7840_length_188_cov_5.642384_g7733_i0	PRJNA492280	7840	188	5.642384	10.60768192	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	154	4.29e-33	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g7733	i0	94.059	78.8617021276596	101	6	97	0	87	187	801	901	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	14826	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus

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