metadata: contig_metadata: 16 rows where bioproject = "PRJNA407368", tax_phylum = "Bdellovibrionota" and tax

16 rows where bioproject = "PRJNA407368", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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
1081776	1081776	PRJNA407368_S_NODE_6501_length_208_cov_90.810056_g6399_i0	PRJNA407368	6501	208	90.810056	188.88491648	Bdellovibrio	958	Bacteria	Bacteria	285	1.6499999999999998e-72	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g6399	i0	91.388	161.423076923077	209	16	100	2	1	208	816059	816266	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	33576	285	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2965918	2965918	PRJNA407368_S_NODE_8243_length_177_cov_1384.527027_g8141_i0	PRJNA407368	8243	177	1384.527027	2450.61283779	uncultured Bdellovibrio sp.	239744	Bacteria	Bacteria	224	2.99e-54	NTclustered	gi\|389546679\|gb\|JQ401607.1\|	239744	g8141	i0	91.463	104.423728813559	164	12	92	2	15	177	128	290	Uncultured Bdellovibrio sp. clone CNY_01758 16S ribosomal RNA gene, partial sequence	blastn	18483	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	uncultured Bdellovibrio sp.
10009760	10009760	PRJNA407368_S_NODE_2008_length_436_cov_87.294840_g1908_i0	PRJNA407368	2008	436	87.29484	380.6055024	Bdellovibrio	958	Bacteria	Bacteria	411	6.029999999999999e-110	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g1908	i0	87.123	114.988532110092	365	43	98	3	8	369	783584	783221	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	50135	411	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
10619082	10619082	PRJNA407368_S_NODE_7089_length_196_cov_142.455090_g6987_i0	PRJNA407368	7089	196	142.45509	279.2119764	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	296	7.089999999999998e-76	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g6987	i0	93.878	226.887755102041	196	12	100	0	1	196	3448050	3447855	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	44470	296	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
10619106	10619106	PRJNA407368_S_NODE_849_length_704_cov_612.428148_g781_i0	PRJNA407368	849	704	612.428148	4311.49416192	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	959	0	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g781	i0	91.465	190.663352272727	703	52	99	5	10	704	3446739	3447441	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	134227	959	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
13168904	13168904	PRJNA407368_S_NODE_6451_length_209_cov_688.033333_g6349_i0	PRJNA407368	6451	209	688.033333	1437.98966597	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	257	3.6200000000000005e-64	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g6349	i0	89.372	176.684210526316	207	18	98	4	5	209	659793	659589	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	36927	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
16384122	16384122	PRJNA407368_S_NODE_6633_length_205_cov_364.948864_g6531_i0	PRJNA407368	6633	205	364.948864	748.1451712	Bdellovibrio	958	Bacteria	Bacteria	318	1.6e-82	NTclustered	gi\|2524301767\|gb\|OR186335.1\|	28201	g6531	i0	95.477	97.9219512195122	199	9	97	0	7	205	242	440	Bdellovibrio sp. strain YBD-1 16S ribosomal RNA gene, partial sequence	blastn	20074	320	0.99375	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
16384131	16384131	PRJNA407368_S_NODE_7273_length_193_cov_83.329268_g7171_i0	PRJNA407368	7273	193	83.329268	160.82548724	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	302	1.5e-77	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g7171	i0	94.819	343.098445595855	193	10	100	0	1	193	817491	817683	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	66218	302	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
16992663	16992663	PRJNA407368_S_NODE_6454_length_209_cov_183.161111_g6352_i0	PRJNA407368	6454	209	183.161111	382.80672199	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	326	9.78e-85	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g6352	i0	95.567	175.162679425837	203	9	97	0	7	209	611135	610933	Bdellovibrio bacteriovorus W, complete genome	blastn	36609	326	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
16992675	16992675	PRJNA407368_S_NODE_7154_length_195_cov_130.162651_g7052_i0	PRJNA407368	7154	195	130.162651	253.81716945	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	331	1.93e-86	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g7052	i0	97.436	196.487179487179	195	4	100	1	1	195	3447692	3447885	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	38315	331	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
22758636	22758636	PRJNA407368_S_NODE_3038_length_340_cov_71.688103_g2936_i0	PRJNA407368	3038	340	71.688103	243.7395502	Bdellovibrio	958	Bacteria	Bacteria	411	4.5999999999999997e-110	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g2936	i0	88.922	148.479411764706	334	35	98	2	8	340	783584	783252	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	50483	411	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24641556	24641556	PRJNA407368_S_NODE_6500_length_208_cov_139.005587_g6398_i0	PRJNA407368	6500	208	139.005587	289.13162096	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	324	3.5e-84	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g6398	i0	94.737	187.346153846154	209	9	100	2	1	208	816266	816059	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	38968	324	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
25307835	25307835	PRJNA407368_S_NODE_3040_length_340_cov_54.437299_g2938_i0	PRJNA407368	3040	340	54.437299	185.0868166	Bdellovibrio	958	Bacteria	Bacteria	438	2.109999999999999e-118	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g2938	i0	90.419	146.7	334	30	98	2	8	340	783584	783252	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	49878	438	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27391692	27391692	PRJNA407368_S_NODE_5503_length_232_cov_13.270936_g5401_i0	PRJNA407368	5503	232	13.270936	30.78857152	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	124	4.929999999999999e-31	NR	MCB0392645.1	2053517	g5401	i0	79.7	0.956896551724138	74	15	95.7	0	224	3	476	549	MCB0392645.1 cytochrome c biogenesis protein CcsA [Bdellovibrionales bacterium]	diamond	222	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29285823	29285823	PRJNA407368_S_NODE_9169_length_166_cov_2.452555_g9067_i0	PRJNA407368	9169	166	2.452555	4.0712413	Bdellovibrio sp.	28201	Bacteria	Bacteria	59.3	4.78e-9	NR	MFM6930298.1	28201	g9067	i0	48.1	0.975903614457831	54	28	97.6	0	165	4	109	162	MFM6930298.1 MarR family winged helix-turn-helix transcriptional regulator [Bdellovibrio sp.]	diamond	162	59.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
32604666	32604666	PRJNA407368_S_NODE_1780_length_468_cov_4.457859_g1683_i0	PRJNA407368	1780	468	4.457859	20.86278012	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	70.9	6.84e-11	NR	MBK7960150.1	2053517	g1683	i0	38.2	0.83974358974359	131	73	79.5	4	82	453	813	942	MBK7960150.1 DUF2341 domain-containing protein [Bdellovibrionales bacterium]	diamond	393	70.9	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);;