metadata: contig_metadata: 9 rows where bioproject = "PRJNA934472", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA934472", 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
2186210	2186210	PRJNA934472_P_NODE_19402_length_330_cov_1.704280_g19025_i0	PRJNA934472	19402	330	1.70428	5.624124	Peredibacter starrii	28202	Bacteria	Bacteria	497	3.32e-136	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g19025	i0	93.939	55.7757575757576	330	18	100	1	1	330	512375	512048	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	18406	497	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
2186295	2186295	PRJNA934472_P_NODE_23502_length_302_cov_2.096070_g23124_i0	PRJNA934472	23502	302	2.09607	6.3301314	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	335	2.49e-87	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g23124	i0	86.755	142.708609271523	302	39	100	1	1	302	1294054	1293754	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	43098	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
2531212	2531212	PRJNA934472_P_NODE_25242_length_292_cov_8.520548_g24864_i0	PRJNA934472	25242	292	8.520548	24.88000016	Pseudobdellovibrio	2862745	Bacteria	Bacteria	451	2.28e-122	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g24864	i0	94.521	38.1541095890411	292	16	100	0	1	292	1607	1316	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	11141	451	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
7633700	7633700	PRJNA934472_P_NODE_30926_length_267_cov_1.824742_g30548_i0	PRJNA934472	30926	267	1.824742	4.87206114	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	466	7.36e-127	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g30548	i0	98.127	177.520599250936	267	5	100	0	1	267	666020	666286	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	47398	466	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
15283485	15283485	PRJNA934472_P_NODE_34592_length_253_cov_1.438889_g34214_i0	PRJNA934472	34592	253	1.438889	3.64038917	Bdellovibrio	958	Bacteria	Bacteria	161	3.6599999999999995e-35	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g34214	i0	78.846	87.703557312253	260	40	99	14	2	253	784549	784801	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	22189	161	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17833130	17833130	PRJNA934472_P_NODE_39914_length_229_cov_2.628205_g39536_i0	PRJNA934472	39914	229	2.628205	6.01858945	Bdellovibrio	958	Bacteria	Bacteria	335	1.8099999999999993e-87	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g39536	i0	94.86	164.100436681223	214	11	93	0	1	214	784314	784527	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	37579	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20037334	20037334	PRJNA934472_P_NODE_11136_length_426_cov_3.229462_g10759_i0	PRJNA934472	11136	426	3.229462	13.75750812	Peredibacter starrii	28202	Bacteria	Bacteria	595	1.5099999999999994e-165	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g10759	i0	94.359	170.985915492958	390	19	91	2	1	388	511768	512156	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	72840	595	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
21313348	21313348	PRJNA934472_P_NODE_40357_length_212_cov_5.028777_g39979_i0	PRJNA934472	40357	212	5.028777	10.66100724	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	248	2.2099999999999997e-61	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g39979	i0	88.406	144.400943396226	207	23	97	1	4	209	3448017	3448223	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	30613	248	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
22933440	22933440	PRJNA934472_P_NODE_39178_length_238_cov_2.818182_g38800_i0	PRJNA934472	39178	238	2.818182	6.70727316	Bdellovibrio	958	Bacteria	Bacteria	257	4.22e-64	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g38800	i0	86.364	382.760504201681	242	26	100	7	1	238	2950426	2950188	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	91097	257	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);;