metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA826497" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA826497" 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
820656	820656	PRJNA826497_S_NODE_16021_length_162_cov_1.379845_g15981_i0	PRJNA826497	16021	162	1.379845	2.2353489	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	292	7.3e-75	NTclustered	gi\|2663432256\|dbj\|AP029176.1\|	3113895	g15981	i0	99.383	26	162	0	99	1	2	162	96451	96290	Bdellovibrio sp. HAGR004 DNA, complete genome	blastn	4212	292	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004
4648973	4648973	PRJNA826497_S_NODE_10584_length_184_cov_2.377483_g10544_i0	PRJNA826497	10584	184	2.377483	4.37456872	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	224	3.139999999999999e-54	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g10544	i0	88.587	4.06521739130435	184	21	100	0	1	184	176993	177176	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	748	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
4649045	4649045	PRJNA826497_S_NODE_5844_length_218_cov_2.502703_g5804_i0	PRJNA826497	5844	218	2.502703	5.45589254	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	276	1.05e-69	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g5804	i0	90.431	5.59174311926605	209	20	96	0	7	215	1237038	1237246	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	1219	276	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
5923838	5923838	PRJNA826497_S_NODE_14925_length_165_cov_5.159091_g14885_i0	PRJNA826497	14925	165	5.159091	8.51250015	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	134	4.7900000000000005e-27	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g14885	i0	81.657	7.27878787878788	169	23	100	7	1	165	2786877	2787041	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	1201	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9748666	9748666	PRJNA826497_S_NODE_2048_length_283_cov_6.696000_g2008_i0	PRJNA826497	2048	283	6.696	18.94968	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	128	4.22e-25	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g2008	i0	78.756	0.681978798586572	193	39	68	2	10	201	666093	666284	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	193	128	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
10156748	10156748	PRJNA826497_S_NODE_2888_length_260_cov_18.070485_g2848_i0	PRJNA826497	2888	260	18.070485	46.983261	Bdellovibrio	958	Bacteria	Bacteria	475	1.1899999999999999e-129	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g2848	i0	99.615	197.115384615385	260	1	100	0	1	260	862313	862054	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	51250	475	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
12299858	12299858	PRJNA826497_S_NODE_4190_length_237_cov_15.529412_g4150_i0	PRJNA826497	4190	237	15.529412	36.80470644	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	344	3.13e-90	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g4150	i0	92.827	11.3164556962025	237	17	100	0	1	237	176300	176064	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	2682	344	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
12707786	12707786	PRJNA826497_S_NODE_6450_length_212_cov_3.636872_g6410_i0	PRJNA826497	6450	212	3.636872	7.71016864	Bdellovibrio	958	Bacteria	Bacteria	147	8.309999999999999e-31	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g6410	i0	79.147	3.5	211	44	99	0	1	211	3455199	3454989	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	742	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13982054	13982054	PRJNA826497_S_NODE_9331_length_191_cov_4.164557_g9291_i0	PRJNA826497	9331	191	4.164557	7.95430387	Bdellovibrio	958	Bacteria	Bacteria	237	4.23e-58	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g9291	i0	89.005	21.1884816753927	191	21	100	0	1	191	1147480	1147670	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	4047	237	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
14848716	14848716	PRJNA826497_S_NODE_5072_length_226_cov_6.927461_g5032_i0	PRJNA826497	5072	226	6.927461	15.65606186	Bdellovibrio sp. HCB288	3394355	Bacteria	Bacteria	167	6.8799999999999995e-37	NTclustered	gi\|2895994964\|gb\|CP178619.1\|	3394355	g5032	i0	80.973	26.5929203539823	226	30	99	7	4	226	843261	843046	Bdellovibrio sp. HCB288 chromosome, complete genome	blastn	6010	167	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB288
15256262	15256262	PRJNA826497_S_NODE_3312_length_252_cov_2.182648_g3272_i0	PRJNA826497	3312	252	2.182648	5.50027296	Bdellovibrio	958	Bacteria	Bacteria	254	5.84e-63	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g3272	i0	85.141	10.9365079365079	249	35	98	2	4	251	509780	509533	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	2756	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20354596	20354596	PRJNA826497_S_NODE_8136_length_199_cov_1.674699_g8096_i0	PRJNA826497	8136	199	1.674699	3.33265101	Bdellovibrio	958	Bacteria	Bacteria	254	4.41e-63	NTclustered	gi\|2313021230\|gb\|CP102930.1\|	959	g8096	i0	90.206	28.3115577889447	194	19	97	0	6	199	3323344	3323537	Bdellovibrio bacteriovorus strain kdesi chromosome, complete genome	blastn	5634	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21222661	21222661	PRJNA826497_S_NODE_17997_length_156_cov_1.487805_g17957_i0	PRJNA826497	17997	156	1.487805	2.3209758	Bdellovibrio sp. HCB209	3394354	Bacteria	Bacteria	137	3.45e-28	NTclustered	gi\|2895998570\|gb\|CP178618.1\|	3394354	g17957	i0	85.075	3.43589743589744	134	20	86	0	23	156	1462429	1462296	Bdellovibrio sp. HCB209 chromosome, complete genome	blastn	536	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB209
21222725	21222725	PRJNA826497_S_NODE_8717_length_195_cov_2.944444_g8677_i0	PRJNA826497	8717	195	2.944444	5.7416658	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	135	1.6300000000000002e-27	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g8677	i0	80.682	0.902564102564103	176	32	90	2	17	191	1251512	1251686	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	176	135	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
23773054	23773054	PRJNA826497_S_NODE_16499_length_160_cov_3.692913_g16459_i0	PRJNA826497	16499	160	3.692913	5.9086608	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	171	3.51e-38	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g16459	i0	87.671	2.28125	146	18	91	0	12	157	2049495	2049640	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	365	171	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
23773094	23773094	PRJNA826497_S_NODE_7399_length_204_cov_3.654971_g7359_i0	PRJNA826497	7399	204	3.654971	7.45614084	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	156	1.32e-33	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g7359	i0	84.906	19.0441176470588	159	19	77	4	21	178	2715384	2715538	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	3885	156	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24179854	24179854	PRJNA826497_S_NODE_14139_length_168_cov_4.400000_g14099_i0	PRJNA826497	14139	168	4.4	7.392	Bdellovibrio	958	Bacteria	Bacteria	122	1.06e-23	NTclustered	gi\|2328635023\|gb\|CP106855.1\|	1732569	g14099	i0	80.117	8.05357142857143	171	28	100	5	1	168	1522076	1521909	Bdellovibrio sp. SKB1291214 chromosome, complete genome	blastn	1353	122	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
25046952	25046952	PRJNA826497_S_NODE_18660_length_154_cov_2.396694_g18620_i0	PRJNA826497	18660	154	2.396694	3.69090876	Bdellovibrio sp. HCB117	3394359	Bacteria	Bacteria	132	1.58e-26	NTclustered	gi\|2895987660\|gb\|CP178622.1\|	3394359	g18620	i0	82.877	0.948051948051948	146	25	95	0	2	147	844543	844688	Bdellovibrio sp. HCB117 chromosome, complete genome	blastn	146	132	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB117
25046979	25046979	PRJNA826497_S_NODE_4520_length_233_cov_6.320000_g4480_i0	PRJNA826497	4520	233	6.32	14.7256	Bdellovibrio sp. HM001	3113894	Bacteria	Bacteria	326	1.11e-84	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g4480	i0	92.174	0.987124463519313	230	18	99	0	1	230	3452403	3452174	Bdellovibrio sp. HM001 DNA, complete genome	blastn	230	326	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
25454826	25454826	PRJNA826497_S_NODE_20360_length_150_cov_1.581197_g20320_i0	PRJNA826497	20360	150	1.581197	2.3717955	Bdellovibrio	958	Bacteria	Bacteria	226	6.8e-55	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g20320	i0	94.521	32.16	146	8	97	0	1	146	2367963	2368108	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	4824	228	0.991228070175439	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);;