metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
3414038	3414038	PRJNA888821_P_NODE_83_length_1482_cov_36.599006_g61_i0	PRJNA888821	83	1482	36.599006	542.39726892	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	1181	0	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g61	i0	84.306	166.566126855601	1217	182	98	9	11	1224	468414	469624	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	246851	1181	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
4691053	4691053	PRJNA888821_P_NODE_19704_length_310_cov_2.776371_g19622_i0	PRJNA888821	19704	310	2.776371	8.6067501	Bdellovibrio sp. HCB290	3394356	Bacteria	Bacteria	233	9.64e-57	NTclustered	gi\|2895991164\|gb\|CP178620.1\|	3394356	g19622	i0	94.667	28.9290322580645	150	8	48	0	1	150	774029	774178	Bdellovibrio sp. HCB290 chromosome, complete genome	blastn	8968	233	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB290
7241057	7241057	PRJNA888821_P_NODE_38206_length_243_cov_8.870588_g38123_i0	PRJNA888821	38206	243	8.870588	21.55552884	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	261	3.34e-65	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g38123	i0	86.122	2.58847736625514	245	30	99	4	1	242	2185968	2185725	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	629	261	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
8895021	8895021	PRJNA888821_P_NODE_8807_length_310_cov_12.860759_g8725_i0	PRJNA888821	8807	310	12.860759	39.8683529	Bacteriovorax	146784	Bacteria	Bacteria	206	2.1e-48	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g8725	i0	93.525	1.38387096774194	139	8	45	1	5	142	672789	672927	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	429	206	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
9791198	9791198	PRJNA888821_P_NODE_888_length_566_cov_5.438134_g816_i0	PRJNA888821	888	566	5.438134	30.77983844	Bacteriovorax sp. HI3	2984118	Bacteria	Bacteria	231	6.6799999999999995e-56	NTclustered	gi\|2321225508\|dbj\|AP026946.1\|	2984118	g816	i0	83.951	1.7773851590106	243	37	69	2	163	404	656126	656367	Bacteriovorax sp. HI3 DNA, complete genome	blastn	1006	231	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp. HI3
10170663	10170663	PRJNA888821_P_NODE_53368_length_196_cov_18.983740_g53285_i0	PRJNA888821	53368	196	18.98374	37.2081304	Bdellovibrio	958	Bacteria	Bacteria	189	1.24e-43	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g53285	i0	95.763	33.2397959183673	118	4	60	1	76	193	3234382	3234498	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	6515	189	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
12342177	12342177	PRJNA888821_P_NODE_43050_length_228_cov_6.845161_g42967_i0	PRJNA888821	43050	228	6.845161	15.60696708	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	150	7.01e-32	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g42967	i0	80.729	0.842105263157895	192	37	84	0	33	224	1470573	1470382	Bdellovibrio bacteriovorus W, complete genome	blastn	192	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15269622	15269622	PRJNA888821_P_NODE_20732_length_309_cov_11.076271_g20650_i0	PRJNA888821	20732	309	11.076271	34.22567739	Bdellovibrio	958	Bacteria	Bacteria	226	1.6099999999999998e-54	NTclustered	gi\|2216477995\|gb\|CP093442.1\|	2835041	g20650	i0	93.96	22.6925566343042	149	9	48	0	161	309	2444491	2444343	Bdellovibrio reynosensis strain LBG001 chromosome, complete genome	blastn	7012	226	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio reynosensis
16165494	16165494	PRJNA888821_P_NODE_27153_length_282_cov_10.555024_g27071_i0	PRJNA888821	27153	282	10.555024	29.76516768	Bacteriovorax stolpii	960	Bacteria	Bacteria	488	1.6699999999999998e-133	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g27071	i0	97.872	6.50709219858156	282	6	100	0	1	282	2388531	2388250	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	1835	488	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
19093537	19093537	PRJNA888821_P_NODE_49115_length_208_cov_8.518519_g49032_i0	PRJNA888821	49115	208	8.518519	17.71851952	Bdellovibrio	958	Bacteria	Bacteria	374	3.4199999999999996e-99	NTclustered	gi\|2328635023\|gb\|CP106855.1\|	1732569	g49032	i0	99.038	201.495192307692	208	2	100	0	1	208	2944899	2944692	Bdellovibrio sp. SKB1291214 chromosome, complete genome	blastn	41911	374	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
19989681	19989681	PRJNA888821_P_NODE_44056_length_224_cov_19.218543_g43973_i0	PRJNA888821	44056	224	19.218543	43.04953632	Bdellovibrio sp. BIS2	3395379	Bacteria	Bacteria	392	1.0299999999999999e-104	NTclustered	gi\|2884284196\|dbj\|AP035879.1\|	3395379	g43973	i0	98.222	3.38839285714286	225	3	100	1	1	224	1674857	1675081	Bdellovibrio sp. BIS2 DNA, complete genome	blastn	759	392	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. BIS2
21644031	21644031	PRJNA888821_P_NODE_34077_length_253_cov_5.016667_g33994_i0	PRJNA888821	34077	253	5.016667	12.69216751	Bdellovibrio	958	Bacteria	Bacteria	159	1.31e-34	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g33994	i0	79.386	2.70355731225296	228	45	90	2	13	239	753172	753398	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	684	159	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22540085	22540085	PRJNA888821_P_NODE_9598_length_310_cov_11.632911_g9516_i0	PRJNA888821	9598	310	11.632911	36.0620241	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	424	5.3299999999999996e-114	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g9516	i0	91.586	87.5903225806452	309	18	99	1	1	309	3447315	3447015	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	27153	424	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
22919715	22919715	PRJNA888821_P_NODE_6558_length_311_cov_5.831933_g6476_i0	PRJNA888821	6558	311	5.831933	18.13731163	Bdellovibrio	958	Bacteria	Bacteria	145	4.66e-30	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g6476	i0	88.333	0.87459807073955	120	14	39	0	192	311	2256946	2257065	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	272	145	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24193251	24193251	PRJNA888821_P_NODE_2099_length_434_cov_72.598338_g2024_i0	PRJNA888821	2099	434	72.598338	315.07678692	Bdellovibrio	958	Bacteria	Bacteria	752	0	NTclustered	gi\|2313021230\|gb\|CP102930.1\|	959	g2024	i0	97.926	126.760368663594	434	9	100	0	1	434	2388059	2388492	Bdellovibrio bacteriovorus strain kdesi chromosome, complete genome	blastn	55014	752	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24193257	24193257	PRJNA888821_P_NODE_21339_length_309_cov_7.415254_g21257_i0	PRJNA888821	21339	309	7.415254	22.91313486	Bdellovibrio	958	Bacteria	Bacteria	167	9.88e-37	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g21257	i0	86.667	4.84142394822006	150	20	49	0	1	150	1371013	1370864	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1496	167	1	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);;