metadata: contig_metadata: 11 rows where bioproject = "PRJNA760904", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA760904", 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
10133578	10133578	PRJNA760904_P_NODE_10648_length_282_cov_1.325359_g10591_i0	PRJNA760904	10648	282	1.325359	3.73751238	Oligoflexia bacterium	2599941	Bacteria	Bacteria	107	8.05e-25	NR	MBC7691762.1	2599941	g10591	i0	57.7	1.03191489361702	97	37	98.9	2	281	3	354	450	MBC7691762.1 response regulator [Oligoflexia bacterium]	diamond	291	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
13496043	13496043	PRJNA760904_P_NODE_651_length_913_cov_1.727381_g606_i0	PRJNA760904	651	913	1.727381	15.77098853	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	257	1.4e-80	NR	MCK6593604.1	2081706	g606	i0	48.7	1.63636363636364	267	135	87.7	2	803	3	9	273	MCK6593604.1 fatty acid desaturase [Bacteriovoracaceae bacterium]	diamond	1494	257	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
27400898	27400898	PRJNA760904_P_NODE_11603_length_274_cov_1.402985_g11546_i0	PRJNA760904	11603	274	1.402985	3.8441789	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	84.7	3.21e-17	NR	MBT4791939.1	2026745	g11546	i0	47.5	4.25912408759124	80	42	87.6	0	248	9	205	284	MBT4791939.1 ribose-phosphate pyrophosphokinase [Halobacteriovoraceae bacterium]	diamond	1167	84.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
27852418	27852418	PRJNA760904_P_NODE_6864_length_335_cov_1.423664_g6807_i0	PRJNA760904	6864	335	1.423664	4.7692744	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	107	6.51e-27	NR	MCB0353192.1	2053517	g6807	i0	58	4.3701492537313404	81	30	72.5	1	2	244	83	159	MCB0353192.1 nucleoside 2-deoxyribosyltransferase domain-containing protein [Bdellovibrionales bacterium]	diamond	1464	108	0.990740740740741	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28189895	28189895	PRJNA760904_P_NODE_19366_length_243_cov_0.905882_g19309_i0	PRJNA760904	19366	243	0.905882	2.20129326	Oligoflexus sp.	1971216	Bacteria	Bacteria	49.3	1.79e-4	NR	WP_324949067.1	1971216	g19309	i0	41.4	0.716049382716049	58	34	71.6	0	209	36	481	538	WP_324949067.1 hypothetical protein [Oligoflexus sp.]	diamond	174	49.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
28189902	28189902	PRJNA760904_P_NODE_6186_length_349_cov_1.115942_g6129_i0	PRJNA760904	6186	349	1.115942	3.89463758	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	45.1	0.0159	NR	MFT6633249.1	2081706	g6129	i0	39.1	0.593123209169054	69	39	56.7	1	135	332	69	137	MFT6633249.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	207	45.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30306370	30306370	PRJNA760904_P_NODE_692_length_892_cov_2.102564_g646_i0	PRJNA760904	692	892	2.102564	18.75487088	unclassified Halobacteriovorax	2639665	Bacteria	Bacteria	93.2	5.87e-17	NR	WP_392992637.1	2639665	g646	i0	34.7	0.988789237668161	294	144	98.2	14	2	877	855	1102	WP_392992637.1 MULTISPECIES: tandem-95 repeat protein [unclassified Halobacteriovorax]	diamond	882	93.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax
31221927	31221927	PRJNA760904_P_NODE_16435_length_248_cov_0.880000_g16378_i0	PRJNA760904	16435	248	0.88	2.1824	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	56.2	2.72e-7	NR	MCB0369154.1	2053517	g16378	i0	74.2	1.25806451612903	31	8	37.5	0	94	2	14	44	MCB0369154.1 C39 family peptidase [Bdellovibrionales bacterium]	diamond	312	56.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31538646	31538646	PRJNA760904_P_NODE_19136_length_243_cov_1.794118_g19079_i0	PRJNA760904	19136	243	1.794118	4.35970674	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	64.3	9.59e-10	NR	HLT22153.1	2081706	g19079	i0	38	0.975308641975309	79	48	97.5	1	243	7	209	286	HLT22153.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	237	64.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
32307755	32307755	PRJNA760904_P_NODE_2259_length_534_cov_3.930586_g2203_i0	PRJNA760904	2259	534	3.930586	20.98932924	Pseudomonadati	3379134	Bacteria	Bacteria	111	1.0400000000000002e-27	NR	MFA4994930.1	2053517	g2203	i0	49.6	7.39325842696629	113	54	61.8	3	400	71	5	117	MFA4994930.1 single-stranded DNA-binding protein [Bdellovibrionales bacterium]	diamond	3948	112	0.991071428571429	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32834243	32834243	PRJNA760904_P_NODE_11620_length_274_cov_1.293532_g11563_i0	PRJNA760904	11620	274	1.293532	3.54427768	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	43.9	0.0191	NR	MBX3020021.1	2026715	g11563	i0	29.8	0.91970802919708	84	52	87.6	2	246	7	109	189	MBX3020021.1 KilA-N domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	252	43.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae 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);;