metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA841653" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA841653" 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
14858164	14858164	PRJNA841653_P_NODE_22072_length_347_cov_1.069343_g21398_i0	PRJNA841653	22072	347	1.069343	3.71062021	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	57.8	3.88e-7	NR	MDW8190275.1	2026715	g21398	i0	45.9	0.734870317002882	85	36	72.6	3	342	91	4	79	MDW8190275.1 delta-60 repeat domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	255	57.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
16133637	16133637	PRJNA841653_P_NODE_59053_length_242_cov_1.775148_g58379_i0	PRJNA841653	59053	242	1.775148	4.29585816	Pseudomonadati	3379134	Bacteria	Bacteria	102	6.92e-24	NR	OFY98961.1	1797385	g58379	i0	61.5	6.60743801652893	78	30	96.7	0	237	4	194	271	OFY98961.1 MAG: hypothetical protein A2Z97_14410 [Bdellovibrionales bacterium GWB1_52_6]	diamond	1599	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium GWB1_52_6
26611337	26611337	PRJNA841653_P_NODE_49301_length_248_cov_0.880000_g48627_i0	PRJNA841653	49301	248	0.88	2.1824	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	110	1.7500000000000002e-26	NR	MCB0369454.1	2053517	g48627	i0	69.6	0.955645161290323	79	24	95.6	0	5	241	109	187	MCB0369454.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	237	110	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28759965	28759965	PRJNA841653_P_NODE_50927_length_247_cov_0.885057_g50253_i0	PRJNA841653	50927	247	0.885057	2.18609079	Oligoflexia bacterium	2599941	Bacteria	Bacteria	100	1.4000000000000002e-22	NR	MDR3606531.1	2599941	g50253	i0	73.8	1.40890688259109	61	16	74.1	0	11	193	50	110	MDR3606531.1 DEAD/DEAH box helicase [Oligoflexia bacterium]	diamond	348	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
29075958	29075958	PRJNA841653_P_NODE_51188_length_247_cov_0.885057_g50514_i0	PRJNA841653	51188	247	0.885057	2.18609079	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	135	8.26e-38	NR	MCK6594478.1	2081706	g50514	i0	83.5	0.959514170040486	79	13	96	0	2	238	46	124	MCK6594478.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	237	135	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
29296825	29296825	PRJNA841653_P_NODE_52569_length_246_cov_0.890173_g51895_i0	PRJNA841653	52569	246	0.890173	2.18982558	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	139	1.86e-39	NR	MBL7544873.1	2026715	g51895	i0	97.5	0.975609756097561	80	2	97.6	0	242	3	5	84	MBL7544873.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	240	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
29391646	29391646	PRJNA841653_P_NODE_56169_length_244_cov_0.900585_g55495_i0	PRJNA841653	56169	244	0.900585	2.1974274	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	90.9	6.28e-20	NR	MBS1984201.1	2053517	g55495	i0	55	0.983606557377049	80	33	94.7	1	14	244	137	216	MBS1984201.1 GNAT family N-acetyltransferase [Bdellovibrionales bacterium]	diamond	240	90.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29580650	29580650	PRJNA841653_P_NODE_46030_length_250_cov_0.870056_g45356_i0	PRJNA841653	46030	250	0.870056	2.17514	Oligoflexus sp.	1971216	Bacteria	Bacteria	105	9.96e-25	NR	WP_325145540.1	1971216	g45356	i0	72	0.984	82	23	98.4	0	248	3	209	290	WP_325145540.1 flagellar hook assembly protein FlgD [Oligoflexus sp.]	diamond	246	105	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
30528554	30528554	PRJNA841653_P_NODE_23793_length_334_cov_1.145594_g23119_i0	PRJNA841653	23793	334	1.145594	3.82628396	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	148	2.849999999999999e-43	NR	MCB0368309.1	2053517	g23119	i0	73.3	0.94311377245509	105	28	94.3	0	315	1	1	105	MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	315	148	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31792848	31792848	PRJNA841653_P_NODE_50657_length_247_cov_0.885057_g49983_i0	PRJNA841653	50657	247	0.885057	2.18609079	Bdellovibrio svalbardensis	2972972	Bacteria	Bacteria	57	3.51e-7	NR	WP_277578531.1	2972972	g49983	i0	46.3	0.995951417004049	82	39	98.4	2	3	245	6	83	WP_277578531.1 CFI-box-CTERM domain-containing protein [Bdellovibrio svalbardensis]	diamond	246	57	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio svalbardensis

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