metadata: contig_metadata: 10 rows where bioproject = "PRJNA446034", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA446034", 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
8091242	8091242	PRJNA446034_S_NODE_15267_length_239_cov_4.232673_g15230_i0	PRJNA446034	15267	239	4.232673	10.11608847	Bacteriovorax antarcticus	3088717	Bacteria	Bacteria	150	2.98e-41	NR	WP_323578299.1	3088717	g15230	i0	88.6	0.99163179916318	79	9	99.2	0	2	238	31	109	WP_323578299.1 acetyl-CoA carboxylase biotin carboxylase subunit [Bacteriovorax antarcticus]	diamond	237	150	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax antarcticus
14466825	14466825	PRJNA446034_S_NODE_29392_length_207_cov_6.011765_g29355_i0	PRJNA446034	29392	207	6.011765	12.44435355	Bacteriovorax stolpii	960	Bacteria	Bacteria	134	2.37e-38	NR	WP_102245238.1	960	g29355	i0	95.6	0.985507246376812	68	3	98.6	0	206	3	77	144	WP_102245238.1 biotin/lipoyl-containing protein [Bacteriovorax stolpii]	diamond	204	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
27234094	27234094	PRJNA446034_S_NODE_66483_length_171_cov_6.753731_g66446_i0	PRJNA446034	66483	171	6.753731	11.54888001	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	45.8	0.0012	NR	MES2526193.1	3034175	g66446	i0	52.9	0.894736842105263	51	22	89.5	2	10	162	510	558	MES2526193.1 alpha-2-macroglobulin family protein [Bdellovibrionota bacterium]	diamond	153	45.8	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27377083	27377083	PRJNA446034_S_NODE_105463_length_153_cov_3.931034_g105426_i0	PRJNA446034	105463	153	3.931034	6.01448202	Bacteriovorax	146784	Bacteria	Bacteria	97.8	4.47e-22	NR	WP_102242491.1	960	g105426	i0	100	18.6274509803922	50	0	98	0	150	1	675	724	WP_102242491.1 DNA mismatch repair protein MutS [Bacteriovorax stolpii]	diamond	2850	97.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
27928910	27928910	PRJNA446034_S_NODE_81645_length_163_cov_2.928571_g81608_i0	PRJNA446034	81645	163	2.928571	4.77357073	Bacteriovorax stolpii	960	Bacteria	Bacteria	80.5	5.88e-16	NR	WP_102244582.1	960	g81608	i0	79.6	0.901840490797546	49	10	90.2	0	161	15	396	444	WP_102244582.1 sigma 54-interacting transcriptional regulator [Bacteriovorax stolpii]	diamond	147	80.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
29065627	29065627	PRJNA446034_S_NODE_114828_length_150_cov_3.141593_g114791_i0	PRJNA446034	114828	150	3.141593	4.7123895	Bacteriovorax antarcticus	3088717	Bacteria	Bacteria	58.2	3.73e-8	NR	WP_323575536.1	3088717	g114791	i0	66.7	0.84	42	13	82	1	132	10	57	98	WP_323575536.1 hypothetical protein [Bacteriovorax antarcticus]	diamond	126	58.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax antarcticus
29601965	29601965	PRJNA446034_S_NODE_91630_length_158_cov_13.528926_g91593_i0	PRJNA446034	91630	158	13.528926	21.37570308	Oligoflexia bacterium	2599941	Bacteria	Bacteria	68.2	9.25e-12	NR	MBC7395942.1	2599941	g91593	i0	56	0.949367088607595	50	22	94.9	0	6	155	205	254	MBC7395942.1 16S rRNA (cytidine(1402)-2'-O)-methyltransferase [Oligoflexia bacterium]	diamond	150	68.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
30865850	30865850	PRJNA446034_S_NODE_77174_length_165_cov_4.906250_g77137_i0	PRJNA446034	77174	165	4.90625	8.0953125	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	67.8	1.85e-11	NR	MBA2404324.1	2053517	g77137	i0	50	0.981818181818182	54	27	98.2	0	2	163	294	347	MBA2404324.1 (2Fe-2S)-binding protein [Bdellovibrionales bacterium]	diamond	162	67.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32178953	32178953	PRJNA446034_S_NODE_82318_length_163_cov_1.642857_g82281_i0	PRJNA446034	82318	163	1.642857	2.67785691	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	80.1	7.54e-16	NR	MBS1983304.1	2053517	g82281	i0	69.8	2.92638036809816	53	16	97.5	0	3	161	308	360	MBS1983304.1 MFS transporter [Bdellovibrionales bacterium]	diamond	477	80.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32352573	32352573	PRJNA446034_S_NODE_34339_length_200_cov_4.417178_g34302_i0	PRJNA446034	34339	200	4.417178	8.834356	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	52.8	4.26e-6	NR	MBA2403446.1	2053517	g34302	i0	50	0.69	46	23	69	0	139	2	3	48	MBA2403446.1 FHA domain-containing protein [Bdellovibrionales bacterium]	diamond	138	52.8	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);;