metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
507169	507169	PRJNA533623_P_NODE_68261_length_225_cov_6.658537_g66480_i0	PRJNA533623	68261	225	6.658537	14.98170825	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	207	4.04e-49	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g66480	i0	86.631	1.66222222222222	187	25	83	0	39	225	1793314	1793128	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	374	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
4334161	4334161	PRJNA533623_P_NODE_74424_length_208_cov_1.115646_g72643_i0	PRJNA533623	74424	208	1.115646	2.32054368	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	111	2.96e-20	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g72643	i0	83.471	0.581730769230769	121	18	58	2	18	137	1866798	1866917	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	121	111	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
5610881	5610881	PRJNA533623_P_NODE_67585_length_227_cov_20.439759_g65804_i0	PRJNA533623	67585	227	20.439759	46.39825293	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	340	3.8499999999999996e-89	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g65804	i0	100	0.81057268722467	184	0	81	0	35	218	757192	757009	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	184	340	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
5611135	5611135	PRJNA533623_P_NODE_80805_length_175_cov_5.570175_g79024_i0	PRJNA533623	80805	175	5.570175	9.74780625	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	191	2.99e-44	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g79024	i0	94.355	0.708571428571429	124	7	71	0	50	173	1629749	1629872	Micavibrio aeruginosavorus EPB, complete genome	blastn	124	191	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
8158947	8158947	PRJNA533623_P_NODE_23107_length_481_cov_41.316667_g21350_i0	PRJNA533623	23107	481	41.316667	198.73316827	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	691	0	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g21350	i0	93.644	0.981288981288981	472	15	95	6	7	463	2419151	2419622	Micavibrio aeruginosavorus EPB, complete genome	blastn	472	691	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
8160004	8160004	PRJNA533623_P_NODE_72747_length_211_cov_7.646667_g70966_i0	PRJNA533623	72747	211	7.646667	16.13446737	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	274	3.6299999999999997e-69	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g70966	i0	95.858	1.35545023696682	169	7	80	0	23	191	2061202	2061370	Micavibrio aeruginosavorus EPB, complete genome	blastn	286	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
8160098	8160098	PRJNA533623_P_NODE_7847_length_830_cov_23.456437_g6414_i0	PRJNA533623	7847	830	23.456437	194.6884271	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	392	4.33e-104	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g6414	i0	82.379	1.24096385542169	454	76	54	4	353	804	96648	97099	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	1030	392	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
13260119	13260119	PRJNA533623_P_NODE_31891_length_398_cov_86.302671_g30120_i0	PRJNA533623	31891	398	86.302671	343.48463058	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	520	8.689999999999997e-143	NTclustered	gi\|469926873\|gb\|CP003538.1\|	349215	g30120	i0	95.413	0.821608040201005	327	13	82	2	20	344	457837	457511	Micavibrio aeruginosavorus EPB, complete genome	blastn	327	520	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
13260444	13260444	PRJNA533623_P_NODE_45811_length_314_cov_2.545455_g44035_i0	PRJNA533623	45811	314	2.545455	7.9927287	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	243	1.6200000000000001e-59	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g44035	i0	83.026	1.02866242038217	271	42	86	4	22	290	3530477	3530209	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	323	243	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
17084406	17084406	PRJNA533623_P_NODE_61734_length_247_cov_77.865591_g59954_i0	PRJNA533623	61734	247	77.865591	192.32800977	Peredibacter starrii	28202	Bacteria	Bacteria	207	4.4999999999999994e-49	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g59954	i0	83.408	0.902834008097166	223	37	90	0	23	245	2668574	2668796	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	223	207	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18357323	18357323	PRJNA533623_P_NODE_13535_length_641_cov_2.341379_g11865_i0	PRJNA533623	13535	641	2.341379	15.00823939	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	298	7.41e-76	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g11865	i0	92.754	62.7051482059282	207	14	32	1	22	227	3447948	3447742	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	40194	298	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
19632562	19632562	PRJNA533623_P_NODE_38836_length_352_cov_1.786942_g37062_i0	PRJNA533623	38836	352	1.786942	6.29003584	Bdellovibrio sp. HCB117	3394359	Bacteria	Bacteria	459	1.6799999999999998e-124	NTclustered	gi\|2895987660\|gb\|CP178622.1\|	3394359	g37062	i0	91.369	12.0653409090909	336	28	95	1	17	352	336762	336428	Bdellovibrio sp. HCB117 chromosome, complete genome	blastn	4247	459	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB117
19632660	19632660	PRJNA533623_P_NODE_43176_length_327_cov_6.428571_g41402_i0	PRJNA533623	43176	327	6.428571	21.02142717	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	525	1.5099999999999994e-144	NTclustered	gi\|347589306\|gb\|CP002382.1\|	856793	g41402	i0	100	0.868501529051988	284	0	87	0	22	305	32496	32213	Micavibrio aeruginosavorus ARL-13, complete genome	blastn	284	525	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
22182616	22182616	PRJNA533623_P_NODE_15058_length_607_cov_28.412088_g13356_i0	PRJNA533623	15058	607	28.412088	172.46137416	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	845	0	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g13356	i0	93.628	42.9126853377265	565	36	93	0	20	584	2940499	2939935	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	26048	845	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24732116	24732116	PRJNA533623_P_NODE_26260_length_448_cov_37.294574_g24491_i0	PRJNA533623	26260	448	37.294574	167.07969152	Bdellovibrio sp. HAGR004	3113895	Bacteria	Bacteria	514	4.6e-141	NTclustered	gi\|2663436448\|dbj\|AP029180.1\|	3113895	g24491	i0	88.276	0.970982142857143	435	44	96	7	18	448	3257	3688	Bdellovibrio sp. HAGR004 plasmid pBdHAGR4 DNA, complete sequence	blastn	435	514	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HAGR004

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