metadata: contig_metadata: 7 rows where bioproject = "PRJEB30004" and tax

7 rows where bioproject = "PRJEB30004" 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
988667	988667	PRJEB30004_P_NODE_535881_length_182_cov_1.027972_g520254_i0	PRJEB30004	535881	182	1.027972	1.87090904	Pseudobdellovibrio	2862745	Bacteria	Bacteria	152	1.4799999999999998e-32	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g520254	i0	81.868	86.7692307692308	182	31	100	2	1	182	1337	1158	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	15792	152	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
3871445	3871445	PRJEB30004_P_NODE_497084_length_192_cov_2.143791_g481457_i0	PRJEB30004	497084	192	2.143791	4.11607872	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	272	1.1699999999999999e-68	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g481457	i0	92.188	257.677083333333	192	15	100	0	1	192	3448015	3447824	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	49474	272	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
6417400	6417400	PRJEB30004_P_NODE_369826_length_241_cov_1.698020_g354199_i0	PRJEB30004	369826	241	1.69802	4.0922282	Peredibacter starrii	28202	Bacteria	Bacteria	420	5.16e-113	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g354199	i0	98.326	135.228215767635	239	4	99	0	3	241	512537	512299	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	32590	420	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
12787093	12787093	PRJEB30004_P_NODE_250311_length_322_cov_1.208481_g234684_i0	PRJEB30004	250311	322	1.208481	3.89130882	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	363	1.23e-95	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g234684	i0	87.156	137.422360248447	327	32	100	10	1	322	3446858	3447179	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	44250	363	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
15016495	15016495	PRJEB30004_P_NODE_505072_length_190_cov_1.596026_g489445_i0	PRJEB30004	505072	190	1.596026	3.0324494	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	296	6.83e-76	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g489445	i0	94.737	88.4315789473684	190	10	100	0	1	190	784502	784313	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	16802	296	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
18840372	18840372	PRJEB30004_P_NODE_607235_length_165_cov_1.928571_g591608_i0	PRJEB30004	607235	165	1.928571	3.18214215	Peredibacter	263370	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g591608	i0	98.182	62.4484848484848	165	3	100	0	1	165	513572	513408	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	10304	289	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
24274408	24274408	PRJEB30004_P_NODE_566400_length_174_cov_1.666667_g550773_i0	PRJEB30004	566400	174	1.666667	2.90000058	Peredibacter starrii	28202	Bacteria	Bacteria	276	7.980000000000001e-70	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g550773	i0	95.402	4.90804597701149	174	7	100	1	1	174	512271	512099	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	854	276	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii

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);;