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

9 rows where bioproject = "PRJNA728642", 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
712729	712729	PRJNA728642_P_NODE_13901_length_270_cov_1.172589_g13630_i0	PRJNA728642	13901	270	1.172589	3.1659903	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	316	7.95e-82	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g13630	i0	88.104	204.514814814815	269	28	99	4	1	268	3251129	3251394	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	55219	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
4541110	4541110	PRJNA728642_P_NODE_12044_length_290_cov_1.649770_g11773_i0	PRJNA728642	12044	290	1.64977	4.784333	Peredibacter starrii	28202	Bacteria	Bacteria	503	6.17e-138	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11773	i0	97.931	94.5	290	6	100	0	1	290	510901	511190	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	27405	503	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
7091430	7091430	PRJNA728642_P_NODE_10306_length_316_cov_2.279835_g10035_i0	PRJNA728642	10306	316	2.279835	7.2042786	Peredibacter starrii	28202	Bacteria	Bacteria	479	1.1499999999999999e-130	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g10035	i0	93.987	81.1740506329114	316	19	100	0	1	316	511192	510877	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	25651	479	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
8366265	8366265	PRJNA728642_P_NODE_7467_length_374_cov_2.003322_g7196_i0	PRJNA728642	7467	374	2.003322	7.49242428	Peredibacter starrii	28202	Bacteria	Bacteria	579	1.3199999999999996e-160	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g7196	i0	94.667	27.3582887700535	375	17	100	3	1	374	512479	512107	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	10232	579	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10123604	10123604	PRJNA728642_P_NODE_4628_length_480_cov_2.289926_g4357_i0	PRJNA728642	4628	480	2.289926	10.9916448	Bdellovibrio	958	Bacteria	Bacteria	843	0	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g4357	i0	98.337	89.5520833333333	481	7	100	1	1	480	784214	784694	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	42985	843	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13466637	13466637	PRJNA728642_P_NODE_3231_length_581_cov_2.525591_g2962_i0	PRJNA728642	3231	581	2.525591	14.67368371	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	1062	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g2962	i0	99.656	241.039586919105	581	2	100	0	1	581	1292769	1293349	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	140044	1062	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
16497980	16497980	PRJNA728642_P_NODE_3233_length_581_cov_1.814961_g2964_i0	PRJNA728642	3233	581	1.814961	10.544923410000001	Bdellovibrio	958	Bacteria	Bacteria	1000	0	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g2964	i0	97.759	201.480206540448	580	13	99	0	1	580	944668	945247	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	117060	1000	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
22390489	22390489	PRJNA728642_P_NODE_8938_length_340_cov_2.000000_g8667_i0	PRJNA728642	8938	340	2	6.8	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	527	4.3799999999999985e-145	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g8667	i0	94.706	123.429411764706	340	17	100	1	1	340	1293818	1293480	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	41966	527	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
30400316	30400316	PRJNA728642_P_NODE_19653_length_241_cov_0.916667_g19382_i0	PRJNA728642	19653	241	0.916667	2.20916747	Oligoflexia bacterium	2599941	Bacteria	Bacteria	85.5	3.22e-17	NR	MBK9295192.1	2599941	g19382	i0	49.4	1.9045643153527	77	39	95.9	0	240	10	146	222	MBK9295192.1 HAMP domain-containing protein [Oligoflexia bacterium]	diamond	459	85.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia 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);;