metadata: contig_metadata: 12 rows where bioproject = "PRJNA414225", tax_phylum = "Bdellovibrionota" and tax

12 rows where bioproject = "PRJNA414225", 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
5522693	5522693	PRJNA414225_P_NODE_35765_length_174_cov_2.464000_g35678_i0	PRJNA414225	35765	174	2.464	4.28736	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	195	2.3e-45	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g35678	i0	91.489	87.051724137931	141	12	81	0	33	173	3251641	3251781	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	15147	195	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
19544690	19544690	PRJNA414225_P_NODE_1616_length_334_cov_1.729825_g1529_i0	PRJNA414225	1616	334	1.729825	5.7776155	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	300	1.02e-76	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g1529	i0	87.597	18.1377245508982	258	32	77	0	43	300	3251523	3251266	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	6058	300	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
20820585	20820585	PRJNA414225_P_NODE_23317_length_184_cov_2.422222_g23230_i0	PRJNA414225	23317	184	2.422222	4.45688848	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	215	1.89e-51	NTclustered	gi\|2893356067\|emb\|OZ220490.1\|	2053517	g23230	i0	89.881	35.8858695652174	168	15	91	2	2	169	718526	718691	MAG: Bdellovibrionales bacterium isolate a27d8a8e-867a-4b05-bccb-c0e2e07202d2 genome assembly, chromosome: 1	blastn	6603	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
22760049	22760049	PRJNA414225_P_NODE_15238_length_192_cov_1.251748_g15151_i0	PRJNA414225	15238	192	1.251748	2.40335616	Bdellovibrio	958	Bacteria	Bacteria	182	2.02e-41	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g15151	i0	94.167	272.427083333333	120	5	69	2	15	133	1676501	1676619	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	52306	183	0.994535519125683	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
27739294	27739294	PRJNA414225_P_NODE_32664_length_177_cov_1.562500_g32577_i0	PRJNA414225	32664	177	1.5625	2.765625	Oligoflexus sp.	1971216	Bacteria	Bacteria	75.5	3.07e-14	NR	MBC7662034.1	1971216	g32577	i0	92.3	1.32203389830508	39	3	66.1	0	3	119	299	337	MBC7662034.1 hypothetical protein [Oligoflexus sp.]	diamond	234	75.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
27818911	27818911	PRJNA414225_P_NODE_69884_length_164_cov_1.330435_g69797_i0	PRJNA414225	69884	164	1.330435	2.1819134	Bdellovibrio	958	Bacteria	Bacteria	105	7.39e-25	NR	WP_374076363.1	959	g69797	i0	90.7	1.97560975609756	54	5	98.8	0	2	163	596	649	WP_374076363.1 RHS repeat-associated core domain-containing protein [Bdellovibrio bacteriovorus]	diamond	324	105	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
29507002	29507002	PRJNA414225_P_NODE_87630_length_162_cov_0.902655_g87543_i0	PRJNA414225	87630	162	0.902655	1.4623011	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	68.2	7.97e-12	NR	MCB0403216.1	2053517	g87543	i0	58.5	1.96296296296296	53	22	98.1	0	4	162	212	264	MCB0403216.1 tetratricopeptide repeat protein [Bdellovibrionales bacterium]	diamond	318	68.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30960300	30960300	PRJNA414225_P_NODE_57994_length_166_cov_0.871795_g57907_i0	PRJNA414225	57994	166	0.871795	1.4471797	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	69.3	3.25e-12	NR	MES2854864.1	3034175	g57907	i0	63.5	0.939759036144578	52	19	94	0	158	3	1	52	MES2854864.1 16S rRNA (adenine(1518)-N(6)/adenine(1519)-N(6))-dimethyltransferase RsmA [Bdellovibrionota bacterium]	diamond	156	69.3	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31845470	31845470	PRJNA414225_P_NODE_20517_length_187_cov_1.478261_g20430_i0	PRJNA414225	20517	187	1.478261	2.76434807	Bdellovibrio	958	Bacteria	Bacteria	52.8	4.94e-6	NR	WP_284604157.1	958	g20430	i0	55.8	2.45454545454545	52	22	81.8	1	155	3	2	53	WP_284604157.1 MULTISPECIES: translocation protein TolB [Bdellovibrio]	diamond	459	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio
32193725	32193725	PRJNA414225_P_NODE_20118_length_187_cov_1.478261_g20031_i0	PRJNA414225	20118	187	1.478261	2.76434807	Bdellovibrio svalbardensis	2972972	Bacteria	Bacteria	95.9	1.9e-23	NR	WP_277576925.1	2972972	g20031	i0	70.5	0.978609625668449	61	18	97.9	0	185	3	42	102	WP_277576925.1 hypothetical protein [Bdellovibrio svalbardensis]	diamond	183	95.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio svalbardensis
32193727	32193727	PRJNA414225_P_NODE_52278_length_167_cov_0.864407_g52191_i0	PRJNA414225	52278	167	0.864407	1.44355969	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	95.5	4.43e-22	NR	WP_262553173.1	959	g52191	i0	92.6	2.91017964071856	54	4	97	0	2	163	50	103	WP_262553173.1 UbiA family prenyltransferase [Bdellovibrio bacteriovorus]	diamond	486	95.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
32636038	32636038	PRJNA414225_P_NODE_22140_length_185_cov_3.522059_g22053_i0	PRJNA414225	22140	185	3.522059	6.51580915	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	102	4.39e-24	NR	NQZ02179.1	2053517	g22053	i0	86.2	1.92972972972973	58	8	94.1	0	176	3	255	312	NQZ02179.1 Holliday junction branch migration DNA helicase RuvB [Bdellovibrionales bacterium]	diamond	357	102	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);;