metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
290191	290191	PRJNA1146029_P_NODE_4381_length_411_cov_2.449704_g4103_i0	PRJNA1146029	4381	411	2.449704	10.06828344	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	472	2.5599999999999997e-128	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g4103	i0	87.591	200.420924574209	411	46	100	3	1	411	666392	666797	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	82373	472	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
2840989	2840989	PRJNA1146029_P_NODE_2923_length_500_cov_3.608899_g2646_i0	PRJNA1146029	2923	500	3.608899	18.044495	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	896	0	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g2646	i0	99	176.804	500	5	100	0	1	500	784205	783706	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	88402	896	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2841081	2841081	PRJNA1146029_P_NODE_8423_length_312_cov_1.464435_g8142_i0	PRJNA1146029	8423	312	1.464435	4.5690372	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	377	4.24e-100	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g8142	i0	88.498	427.221153846154	313	35	100	1	1	312	3252068	3252380	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	133293	377	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
4117186	4117186	PRJNA1146029_P_NODE_2964_length_497_cov_1.250000_g2687_i0	PRJNA1146029	2964	497	1.25	6.2125	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	566	1.4e-156	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g2687	i0	87.302	160.971830985915	504	53	99	9	1	496	3250598	3251098	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	80003	566	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
5393290	5393290	PRJNA1146029_P_NODE_16305_length_251_cov_0.865169_g16024_i0	PRJNA1146029	16305	251	0.865169	2.17157419	uncultured Micavibrio sp.	362447	Bacteria	Bacteria	322	1.57e-83	NTclustered	gi\|2621703983\|emb\|OY762938.1\|	362447	g16024	i0	90.361	182.581673306773	249	19	98	4	2	247	961650	961896	MAG: uncultured Micavibrio sp. isolate 194a20bb-105a-45c9-9846-0688499aae06 genome assembly, chromosome: 1	blastn	45828	322	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	uncultured Micavibrio sp.
7411509	7411509	PRJNA1146029_P_NODE_166_length_1852_cov_6.381113_g112_i0	PRJNA1146029	166	1852	6.381113	118.17821276	Peredibacter	263370	Bacteria	Bacteria	3079	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g112	i0	96.656	146.563714902808	1854	60	100	1	1	1852	510709	512562	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	271436	3079	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9218175	9218175	PRJNA1146029_P_NODE_22368_length_239_cov_2.493976_g22087_i0	PRJNA1146029	22368	239	2.493976	5.96060264	Bdellovibrio sp. HCB274	3394361	Bacteria	Bacteria	228	3.329999999999999e-55	NTclustered	gi\|2895984058\|gb\|CP178623.1\|	3394361	g22087	i0	86.512	191.075313807531	215	20	89	6	1	213	1742346	1742553	Bdellovibrio sp. HCB274 chromosome, complete genome	blastn	45667	228	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB274
11768857	11768857	PRJNA1146029_P_NODE_3890_length_433_cov_2.988889_g3612_i0	PRJNA1146029	3890	433	2.988889	12.94188937	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	617	3.29e-172	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g3612	i0	92.379	131.699769053118	433	33	100	0	1	433	1292313	1292745	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	57026	617	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
13043822	13043822	PRJNA1146029_P_NODE_21591_length_242_cov_0.911243_g21310_i0	PRJNA1146029	21591	242	0.911243	2.20520806	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	244	3.3499999999999997e-60	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g21310	i0	85.95	164.297520661157	242	19	94	8	15	242	3251640	3251880	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	39760	244	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
14318995	14318995	PRJNA1146029_P_NODE_172_length_1820_cov_5.283343_g112_i1	PRJNA1146029	172	1820	5.283343	96.1568426	Peredibacter starrii	28202	Bacteria	Bacteria	3068	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g112	i1	97.091	146.895604395604	1822	50	100	2	1	1820	510709	512529	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	267350	3068	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15061389	15061389	PRJNA1146029_P_NODE_2292_length_569_cov_1.786290_g2017_i0	PRJNA1146029	2292	569	1.78629	10.1639901	Bdellovibrio	958	Bacteria	Bacteria	966	0	NTclustered	gi\|485099167\|ref\|NR_102561.1\|	959	g2017	i0	97.364	90.0017574692443	569	14	100	1	1	569	1699	1132	Bdellovibrio bacteriovorus strain Tiberius 23S ribosomal RNA gene, complete sequence	blastn	51211	972	0.993827160493827	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15592930	15592930	PRJNA1146029_P_NODE_14653_length_260_cov_1.395722_g14372_i0	PRJNA1146029	14653	260	1.395722	3.6288772	Bdellovibrio reynosensis	2835041	Bacteria	Bacteria	150	8.17e-32	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g14372	i0	77.395	1.00384615384615	261	53	99	6	3	260	2709317	2709574	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	261	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
15593155	15593155	PRJNA1146029_P_NODE_8513_length_311_cov_0.970588_g8232_i0	PRJNA1146029	8513	311	0.970588	3.01852868	Fluviispira sanaruensis	2493639	Bacteria	Bacteria	309	1.5600000000000002e-79	NTclustered	gi\|1566193515\|dbj\|AP019368.1\|	2493639	g8232	i0	84.762	143.659163987138	315	40	100	6	1	311	399337	399647	Silvanigrellales bacterium RF1110005 DNA, complete genome	blastn	44678	309	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira sanaruensis
16867155	16867155	PRJNA1146029_P_NODE_14554_length_261_cov_1.170213_g14273_i0	PRJNA1146029	14554	261	1.170213	3.05425593	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	427	3.38e-115	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g14273	i0	96.169	178.647509578544	261	10	100	0	1	261	3447625	3447365	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	46627	427	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
17611329	17611329	PRJNA1146029_P_NODE_4774_length_396_cov_1.043344_g4496_i0	PRJNA1146029	4774	396	1.043344	4.13164224	Bacteriovorax	146784	Bacteria	Bacteria	643	4.919999999999999e-180	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g4496	i0	95.96	225.924242424242	396	16	100	0	1	396	1661828	1661433	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	89466	643	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
21966951	21966951	PRJNA1146029_P_NODE_18638_length_247_cov_0.885057_g18357_i0	PRJNA1146029	18638	247	0.885057	2.18609079	Bdellovibrio sp. HCB288	3394355	Bacteria	Bacteria	257	4.41e-64	NTclustered	gi\|2895994964\|gb\|CP178619.1\|	3394355	g18357	i0	85.484	52.497975708502	248	34	100	2	1	247	2063257	2063011	Bdellovibrio sp. HCB288 chromosome, complete genome	blastn	12967	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB288
21967109	21967109	PRJNA1146029_P_NODE_8678_length_309_cov_1.076271_g8397_i0	PRJNA1146029	8678	309	1.076271	3.32567739	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	571	1.7899999999999995e-158	NTclustered	gi\|333034728\|gb\|JF703522.1\|	239744	g8397	i0	100	128.122977346278	309	0	100	0	1	309	313	5	Uncultured Bdellovibrio sp. clone L1-86 16S ribosomal RNA gene, partial sequence	blastn	39590	571	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.
23242519	23242519	PRJNA1146029_P_NODE_20959_length_243_cov_0.905882_g20678_i0	PRJNA1146029	20959	243	0.905882	2.20129326	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	60.2	1.31e-4	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g20678	i0	94.737	1.75720164609054	38	2	16	0	206	243	61868	61831	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	427	60.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154

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