metadata: contig_metadata: 13 rows where bioproject = "PRJNA529224", tax_phylum = "Bdellovibrionota" and tax

13 rows where bioproject = "PRJNA529224", 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
1773159	1773159	PRJNA529224_S_NODE_1182_length_191_cov_27.876543_g1175_i0	PRJNA529224	1182	191	27.876543	53.24419713	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	315	1.9e-81	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g1175	i0	96.335	218.005235602094	191	7	100	0	1	191	701124	701314	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	41639	315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
4324927	4324927	PRJNA529224_S_NODE_624_length_247_cov_8.188073_g617_i0	PRJNA529224	624	247	8.188073	20.22454031	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	424	4.1099999999999996e-114	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g617	i0	97.571	4.69635627530364	247	6	100	0	1	247	1293897	1293651	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	1160	424	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
7492557	7492557	PRJNA529224_S_NODE_1606_length_165_cov_10.205882_g1599_i0	PRJNA529224	1606	165	10.205882	16.8397053	Peredibacter	263370	Bacteria	Bacteria	263	5.86e-66	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1599	i0	95.706	52.6909090909091	163	7	99	0	3	165	513431	513593	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	8694	263	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
9426229	9426229	PRJNA529224_S_NODE_448_length_287_cov_244.775194_g441_i0	PRJNA529224	448	287	244.775194	702.50480678	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	425	1.36e-114	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g441	i0	93.426	261.306620209059	289	16	100	3	1	287	1292323	1292610	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	74995	425	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
10043009	10043009	PRJNA529224_S_NODE_1188_length_190_cov_17.161491_g1181_i0	PRJNA529224	1188	190	17.161491	32.6068329	Peredibacter	263370	Bacteria	Bacteria	335	1.4499999999999993e-87	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g1181	i0	98.429	252.042105263158	191	2	100	1	1	190	512376	512566	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	47888	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15800624	15800624	PRJNA529224_S_NODE_333_length_321_cov_131.527397_g326_i0	PRJNA529224	333	321	131.527397	422.20294437	Peredibacter starrii	28202	Bacteria	Bacteria	573	5.199999999999999e-159	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g326	i0	99.062	198.252336448598	320	1	99	1	1	318	511771	512090	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	63639	573	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
15800630	15800630	PRJNA529224_S_NODE_993_length_207_cov_13.078652_g986_i0	PRJNA529224	993	207	13.078652	27.07280964	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	302	1.63e-77	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g986	i0	93.564	251.951690821256	202	13	98	0	6	207	1293283	1293082	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	52154	302	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
16417235	16417235	PRJNA529224_S_NODE_1593_length_166_cov_8.605839_g1586_i0	PRJNA529224	1593	166	8.605839	14.28569274	Bacteriovorax	146784	Bacteria	Bacteria	281	1.63e-71	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1586	i0	97.561	11.6144578313253	164	4	99	0	2	165	1661696	1661859	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	1928	281	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
17692346	17692346	PRJNA529224_S_NODE_1674_length_162_cov_4.766917_g1667_i0	PRJNA529224	1674	162	4.766917	7.72240554	Bacteriovorax	146784	Bacteria	Bacteria	224	2.7e-54	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1667	i0	91.875	77.4320987654321	160	13	99	0	1	160	1660545	1660386	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	12544	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18349504	18349504	PRJNA529224_S_NODE_315_length_330_cov_26.897010_g308_i0	PRJNA529224	315	330	26.89701	88.760133	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	399	9.629999999999998e-107	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g308	i0	88.788	176.163636363636	330	32	99	4	3	330	3447718	3447392	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	58134	399	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20900144	20900144	PRJNA529224_S_NODE_657_length_242_cov_10.079812_g650_i0	PRJNA529224	657	242	10.079812	24.39314504	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g650	i0	94.215	79.2231404958678	242	14	100	0	1	242	3447065	3447306	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	19172	370	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
22791608	22791608	PRJNA529224_S_NODE_238_length_358_cov_12.376900_g231_i0	PRJNA529224	238	358	12.3769	44.309302	Peredibacter	263370	Bacteria	Bacteria	355	2.31e-93	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g231	i0	88.966	88.9553072625698	290	29	80	2	12	298	511006	511295	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	31846	355	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23450347	23450347	PRJNA529224_S_NODE_359_length_311_cov_70.443262_g352_i0	PRJNA529224	359	311	70.443262	219.07854482	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	484	2.4199999999999994e-132	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g352	i0	94.855	159.318327974277	311	14	99	2	1	309	3447408	3447718	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	49548	484	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337

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