metadata: contig_metadata: 10 rows where bioproject = "PRJNA613025", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA613025", 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
591931	591931	PRJNA613025_S_NODE_29061_length_170_cov_2.322314_g28907_i0	PRJNA613025	29061	170	2.322314	3.9479338	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	111	2.31e-20	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g28907	i0	79.394	5.45882352941176	165	29	95	5	1	162	609798	609636	Bdellovibrio bacteriovorus W, complete genome	blastn	928	111	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
6970073	6970073	PRJNA613025_S_NODE_19086_length_228_cov_1.642458_g18932_i0	PRJNA613025	19086	228	1.642458	3.74480424	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	136	2.42e-37	NR	MCB0369725.1	2053517	g18932	i0	89.3	1.97368421052632	75	8	98.7	0	3	227	22	96	MCB0369725.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	450	136	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
6970244	6970244	PRJNA613025_S_NODE_26306_length_182_cov_1.150376_g26152_i0	PRJNA613025	26306	182	1.150376	2.09368432	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	224	3.1e-54	NTclustered	gi\|2621706492\|emb\|OY764265.1\|	3034175	g26152	i0	88.95	169.203296703297	181	20	99	0	1	181	1697596	1697416	MAG: Bdellovibrionota bacterium isolate efddfb02-ff0c-4ac5-ae96-c61d995422a3 genome assembly, chromosome: 1	blastn	30795	224	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
17169349	17169349	PRJNA613025_S_NODE_11354_length_354_cov_2.954098_g11200_i0	PRJNA613025	11354	354	2.954098	10.45750692	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	195	3.58e-58	NR	MCB0368368.1	2053517	g11200	i0	81.9	0.983050847457627	116	21	98.3	0	354	7	117	232	MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	348	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
17726672	17726672	PRJNA613025_S_NODE_22714_length_201_cov_1.342105_g22560_i0	PRJNA613025	22714	201	1.342105	2.69763105	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	363	7.109999999999999e-96	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g22560	i0	99.497	169.388059701493	199	1	99	0	3	201	752	950	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	34047	363	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
19718279	19718279	PRJNA613025_S_NODE_21216_length_211_cov_0.938272_g21062_i0	PRJNA613025	21216	211	0.938272	1.97975392	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	107	2.06e-25	NR	MCB0370360.1	2053517	g21062	i0	78.6	0.995260663507109	70	15	99.5	0	210	1	424	493	MCB0370360.1 HAD-IC family P-type ATPase [Bdellovibrionales bacterium]	diamond	210	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
20275200	20275200	PRJNA613025_S_NODE_17476_length_244_cov_5.323077_g17322_i0	PRJNA613025	17476	244	5.323077	12.98830788	Micavibrio	213485	Bacteria	Bacteria	291	4.28e-74	NTclustered	gi\|470487404\|ref\|NR_076816.1\|	349221	g17322	i0	88.211	197.217213114754	246	26	100	2	1	244	2733	2489	Micavibrio aeruginosavorus strain ARL-13 23S ribosomal RNA gene, complete sequence	blastn	48121	291	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
28388097	28388097	PRJNA613025_S_NODE_18026_length_238_cov_4.037037_g17872_i0	PRJNA613025	18026	238	4.037037	9.60814806	Bacteria	2	Bacteria	Bacteria	108	2.95e-29	NR	MCB0370183.1	2053517	g17872	i0	89.1	2.36974789915966	55	6	69.3	0	54	218	1	55	MCB0370183.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	564	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30238253	30238253	PRJNA613025_S_NODE_15872_length_266_cov_0.935484_g15718_i0	PRJNA613025	15872	266	0.935484	2.48838744	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	163	3.19e-49	NR	MCB0369646.1	2053517	g15718	i0	90.9	0.992481203007519	88	8	99.2	0	1	264	47	134	MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium]	diamond	264	163	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32861353	32861353	PRJNA613025_S_NODE_15400_length_273_cov_1.089286_g15246_i0	PRJNA613025	15400	273	1.089286	2.97375078	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	88.6	6.69e-20	NR	MCB0371231.1	2053517	g15246	i0	67.3	0.604395604395604	55	18	60.4	0	108	272	1	55	MCB0371231.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	165	88.6	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);;