metadata: contig_metadata: 17 rows where bioproject = "PRJNA771359", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA771359", tax_kingdom = "Pseudomonadati" 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
3758510	3758510	PRJNA771359_S_NODE_3923_length_170_cov_2.052632_g3840_i0	PRJNA771359	3923	170	2.052632	3.4894744	Bdellovibrio	958	Bacteria	Bacteria	183	4.829999999999999e-42	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g3840	i0	86.207	466.052941176471	174	18	99	3	1	168	750465	750292	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	79229	183	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
5850537	5850537	PRJNA771359_S_NODE_105_length_881_cov_10.978673_g29_i1	PRJNA771359	105	881	10.978673	96.72210913	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	776	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g29	i1	83.855	192.797956867196	830	118	98	14	1	823	1677275	1678095	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	169855	776	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
5850553	5850553	PRJNA771359_S_NODE_1725_length_255_cov_2.183486_g1642_i0	PRJNA771359	1725	255	2.183486	5.5678893	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	198	2.81e-46	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g1642	i0	81.609	1.02352941176471	261	28	100	15	1	255	878462	878708	Bdellovibrio exovorus JSS, complete genome	blastn	261	198	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
7125772	7125772	PRJNA771359_S_NODE_3386_length_182_cov_4.903448_g3303_i0	PRJNA771359	3386	182	4.903448	8.92427536	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	270	3.93e-68	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g3303	i0	93.407	177.884615384615	182	12	100	0	1	182	816313	816132	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	32375	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8400293	8400293	PRJNA771359_S_NODE_4987_length_153_cov_1.327586_g4904_i0	PRJNA771359	4987	153	1.327586	2.03120658	Peredibacter starrii	28202	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4904	i0	98.693	6.7843137254902	153	2	100	0	1	153	511076	510924	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	1038	272	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8859932	8859932	PRJNA771359_S_NODE_2707_length_203_cov_20.096386_g2624_i0	PRJNA771359	2707	203	20.096386	40.79566358	Bdellovibrio	958	Bacteria	Bacteria	348	2.0100000000000006e-91	NTclustered	gi\|2524301767\|gb\|OR186335.1\|	28201	g2624	i0	98.477	97.4088669950739	197	3	97	0	7	203	242	438	Bdellovibrio sp. strain YBD-1 16S ribosomal RNA gene, partial sequence	blastn	19774	348	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
8859947	8859947	PRJNA771359_S_NODE_4167_length_165_cov_8.585938_g4084_i0	PRJNA771359	4167	165	8.585938	14.1667977	Pseudobdellovibrio	2862745	Bacteria	Bacteria	261	2.11e-65	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g4084	i0	95.181	35.3212121212121	166	6	100	2	1	165	498	334	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	5828	261	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
13960716	13960716	PRJNA771359_S_NODE_311_length_535_cov_9.228916_g234_i0	PRJNA771359	311	535	9.228916	49.3747006	Pseudobdellovibrio	2862745	Bacteria	Bacteria	732	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g234	i0	94.351	88.8841121495327	478	25	89	2	1	477	1258	1734	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	47553	732	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
16049671	16049671	PRJNA771359_S_NODE_493_length_441_cov_11.841584_g410_i0	PRJNA771359	493	441	11.841584	52.22138544	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	595	1.5699999999999995e-165	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g410	i0	90.971	230.138321995465	443	38	100	2	1	441	666800	666358	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	101491	595	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
22424326	22424326	PRJNA771359_S_NODE_2038_length_232_cov_2.369231_g1955_i0	PRJNA771359	2038	232	2.369231	5.49661592	Bdellovibrio sp. HCB288	3394355	Bacteria	Bacteria	174	4.24e-39	NTclustered	gi\|2895994964\|gb\|CP178619.1\|	3394355	g1955	i0	82.673	243.137931034483	202	29	87	5	24	221	574849	574650	Bdellovibrio sp. HCB288 chromosome, complete genome	blastn	56408	174	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB288
22884457	22884457	PRJNA771359_S_NODE_2058_length_231_cov_5.247423_g1975_i0	PRJNA771359	2058	231	5.247423	12.12154713	Pseudobdellovibrio	2862745	Bacteria	Bacteria	320	5.12e-83	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g1975	i0	91.775	154.978354978355	231	18	99	1	1	230	325	95	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	35800	320	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
22884482	22884482	PRJNA771359_S_NODE_4678_length_157_cov_4.008333_g4595_i0	PRJNA771359	4678	157	4.008333	6.29308281	Pseudobdellovibrio	2862745	Bacteria	Bacteria	255	9.2e-64	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g4595	i0	96.154	99.4968152866242	156	6	99	0	2	157	1872	1717	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	15621	255	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
24158392	24158392	PRJNA771359_S_NODE_1439_length_281_cov_6.118852_g1356_i0	PRJNA771359	1439	281	6.118852	17.19397412	Pseudobdellovibrio	2862745	Bacteria	Bacteria	381	2.909999999999999e-101	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g1356	i0	91.135	193.822064056939	282	23	100	2	1	281	325	45	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	54464	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
24158419	24158419	PRJNA771359_S_NODE_479_length_445_cov_11.311275_g396_i0	PRJNA771359	479	445	11.311275	50.33517375	Pseudobdellovibrio	2862745	Bacteria	Bacteria	656	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g396	i0	93.258	326.543820224719	445	30	100	0	1	445	1364	920	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	145312	656	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
24973666	24973666	PRJNA771359_S_NODE_3700_length_175_cov_1.239130_g3617_i0	PRJNA771359	3700	175	1.23913	2.1684775	Peredibacter starrii	28202	Bacteria	Bacteria	215	1.78e-51	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g3617	i0	89.017	208.662857142857	173	19	99	0	1	173	512410	512238	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	36516	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
24973678	24973678	PRJNA771359_S_NODE_420_length_467_cov_7.016279_g134_i1	PRJNA771359	420	467	7.016279	32.76602293	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	595	1.6699999999999995e-165	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g134	i1	92.927	98.2955032119914	410	28	96	1	1	409	3447207	3446798	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	45904	595	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
29484556	29484556	PRJNA771359_S_NODE_4150_length_166_cov_1.503876_g4067_i0	PRJNA771359	4150	166	1.503876	2.49643416	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	92	4.13e-20	NR	MCB0368368.1	2053517	g4067	i0	76.4	0.993975903614458	55	13	99.4	0	165	1	87	141	MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	165	92	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium

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