metadata: contig_metadata: 9 rows where bioproject = "PRJNA195897", tax_phylum = "Bdellovibrionota" and tax

9 rows where bioproject = "PRJNA195897", 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
6743643	6743643	PRJNA195897_P_NODE_2586_length_310_cov_2.084291_g2553_i0	PRJNA195897	2586	310	2.084291	6.4613021	Peredibacter starrii	28202	Bacteria	Bacteria	412	1.1499999999999998e-110	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g2553	i0	90.645	555.01935483871	310	29	100	0	1	310	511701	511392	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	172056	412	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
7433191	7433191	PRJNA195897_P_NODE_6626_length_192_cov_1.307692_g6593_i0	PRJNA195897	6626	192	1.307692	2.51076864	Bdellovibrio	958	Bacteria	Bacteria	283	5.39e-72	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g6593	i0	93.333	127.697916666667	195	8	100	5	1	192	748393	748585	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	24518	283	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
9294027	9294027	PRJNA195897_P_NODE_11928_length_163_cov_0.912281_g11895_i0	PRJNA195897	11928	163	0.912281	1.48701803	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g11895	i0	96.319	4.57668711656442	163	6	100	0	1	163	1292285	1292447	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	746	268	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
15668819	15668819	PRJNA195897_P_NODE_7373_length_184_cov_1.155556_g7340_i0	PRJNA195897	7373	184	1.155556	2.12622304	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	252	1.44e-62	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g7340	i0	91.304	257.858695652174	184	16	100	0	1	184	612914	613097	Bdellovibrio bacteriovorus W, complete genome	blastn	47446	252	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17632940	17632940	PRJNA195897_P_NODE_8174_length_176_cov_1.220472_g8141_i0	PRJNA195897	8174	176	1.220472	2.14803072	Bdellovibrio	958	Bacteria	Bacteria	233	4.94e-57	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g8141	i0	91.765	85	170	11	95	3	9	176	1607850	1608018	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	14960	233	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18906750	18906750	PRJNA195897_P_NODE_8295_length_175_cov_0.984127_g8262_i0	PRJNA195897	8295	175	0.984127	1.72222225	Pseudobdellovibrio	2862745	Bacteria	Bacteria	263	6.26e-66	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g8262	i0	93.75	118.297142857143	176	9	100	2	1	175	328	502	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	20702	263	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
26820942	26820942	PRJNA195897_P_NODE_11941_length_163_cov_0.912281_g11908_i0	PRJNA195897	11941	163	0.912281	1.48701803	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	108	1.14e-25	NR	MBL7556853.1	2026715	g11908	i0	96.2	0.975460122699387	53	2	97.5	0	162	4	667	719	MBL7556853.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	159	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
27421822	27421822	PRJNA195897_P_NODE_603_length_695_cov_4.232198_g573_i0	PRJNA195897	603	695	4.232198	29.4137761	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	105	7.31e-24	NR	MBT6325281.1	2053517	g573	i0	32.5	2.60719424460432	200	128	83.3	4	45	623	10	209	MBT6325281.1 glutathione S-transferase [Bdellovibrionales bacterium]	diamond	1812	105	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27516308	27516308	PRJNA195897_P_NODE_6943_length_188_cov_1.870504_g6910_i0	PRJNA195897	6943	188	1.870504	3.51654752	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	79.3	1.21e-17	NR	MCB0369232.1	2053517	g6910	i0	80.5	0.654255319148936	41	8	65.4	0	65	187	21	61	MCB0369232.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	123	79.3	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);;