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

7 rows where bioproject = "PRJNA1111448" 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
2768465	2768465	PRJNA1111448_S_NODE_30863_length_406_cov_1.783784_g30040_i0	PRJNA1111448	30863	406	1.783784	7.24216304	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	483	1.17e-131	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g30040	i0	88.177	186.059113300493	406	47	100	1	1	406	1293767	1294171	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	75540	483	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
13776305	13776305	PRJNA1111448_S_NODE_92791_length_280_cov_1.115942_g91968_i0	PRJNA1111448	92791	280	1.115942	3.1246376	Peredibacter	263370	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g91968	i0	99.643	245.514285714286	280	1	100	0	1	280	511539	511260	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	68744	512	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
14246875	14246875	PRJNA1111448_S_NODE_42132_length_368_cov_1.271186_g41309_i0	PRJNA1111448	42132	368	1.271186	4.67796448	Peredibacter starrii	28202	Bacteria	Bacteria	497	3.74e-136	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g41309	i0	91.899	161.372282608696	358	26	97	2	1	356	511832	512188	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	59385	497	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18069205	18069205	PRJNA1111448_S_NODE_132075_length_245_cov_0.895349_g131252_i0	PRJNA1111448	132075	245	0.895349	2.19360505	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	442	1.1199999999999994e-119	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g131252	i0	99.587	40.8775510204082	242	1	99	0	4	245	1292678	1292437	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	10015	442	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
25249391	25249391	PRJNA1111448_S_NODE_98300_length_273_cov_2.380000_g97477_i0	PRJNA1111448	98300	273	2.38	6.4974	Pseudobdellovibrio	2862745	Bacteria	Bacteria	496	9.63e-136	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g97477	i0	99.631	178.26739926739901	271	1	99	0	1	271	956	686	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	48667	496	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
31331720	31331720	PRJNA1111448_S_NODE_131836_length_245_cov_0.895349_g131013_i0	PRJNA1111448	131836	245	0.895349	2.19360505	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	126	1.0799999999999999e-32	NR	MFP5459138.1	3058048	g131013	i0	82.4	1.82448979591837	74	13	90.6	0	224	3	218	291	MFP5459138.1 molecular chaperone DnaJ [Bacteriovoracia bacterium]	diamond	447	126	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
31458452	31458452	PRJNA1111448_S_NODE_107056_length_264_cov_1.209424_g106233_i0	PRJNA1111448	107056	264	1.209424	3.19287936	Bdellovibrio sp.	28201	Bacteria	Bacteria	115	1.59e-28	NR	NUN06814.1	28201	g106233	i0	61.6	0.977272727272727	86	33	97.7	0	263	6	42	127	NUN06814.1 hypothetical protein [Bdellovibrio sp.]	diamond	258	115	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.

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