metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA446034" and tax_phylum = "Campylobacterota"

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
13191660	13191660	PRJNA446034_S_NODE_116411_length_150_cov_1.230088_g116374_i0	PRJNA446034	116411	150	1.230088	1.845132	Campylobacterales	213849	Bacteria	Bacteria	82	1.26e-17	NR	WP_034556634.1	216	g116374	i0	81.6	31.3	49	9	98	0	3	149	49	97	WP_034556634.1 FAD-dependent thymidylate synthase [Helicobacter muridarum]	diamond	4695	82	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter muridarum
27044422	27044422	PRJNA446034_S_NODE_15702_length_237_cov_26.735000_g15665_i0	PRJNA446034	15702	237	26.735	63.36195	Helicobacter pylori	210	Bacteria	Bacteria	55.5	3.57e-8	NR	GAA8930966.1	210	g15665	i0	68.4	0.481012658227848	38	12	48.1	0	136	23	8	45	GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori]	diamond	114	55.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27644924	27644924	PRJNA446034_S_NODE_99144_length_155_cov_11.279661_g99107_i0	PRJNA446034	99144	155	11.279661	17.48347455	Helicobacter pylori	210	Bacteria	Bacteria	46.2	7.35e-5	NR	GAA8761346.1	210	g99107	i0	90	0.387096774193548	20	2	38.7	0	11	70	2	21	GAA8761346.1 hypothetical protein Kyoto147A_4040 [Helicobacter pylori]	diamond	60	46.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27865562	27865562	PRJNA446034_S_NODE_113665_length_150_cov_8.132743_g113628_i0	PRJNA446034	113665	150	8.132743	12.1991145	Helicobacter pylori	210	Bacteria	Bacteria	47.8	2.18e-5	NR	GAA6805833.1	210	g113628	i0	55.6	0.9	45	20	90	0	11	145	34	78	GAA6805833.1 hypothetical protein Kyoto200A_2750 [Helicobacter pylori]	diamond	135	47.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28608216	28608216	PRJNA446034_S_NODE_7867_length_277_cov_2.137500_g7830_i0	PRJNA446034	7867	277	2.1375	5.920875	root	1	Root_unresolved	Root_unresolved	62.4	1.7e-10	NR	WP_260935996.1	28197	g7830	i0	43.5	2.55595667870036	62	35	67.1	0	1	186	15	76	WP_260935996.1 DUF7220 family protein [Aliarcobacter butzleri]	diamond	708	62.8	0.993630573248408	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
29160518	29160518	PRJNA446034_S_NODE_59329_length_176_cov_3.899281_g59292_i0	PRJNA446034	59329	176	3.899281	6.86273456	Sulfurimonas sp.	2022749	Bacteria	Bacteria	49.3	8.7e-6	NR	MCD4667511.1	2022749	g59292	i0	52.5	1.00568181818182	59	24	98.9	2	175	2	5	60	MCD4667511.1 SH3 beta-barrel fold-containing protein [Sulfurimonas sp.]	diamond	177	49.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
29381274	29381274	PRJNA446034_S_NODE_27149_length_211_cov_2.913793_g27112_i0	PRJNA446034	27149	211	2.913793	6.14810323	Campylobacter jejuni	197	Bacteria	Bacteria	94	1.13e-22	NR	WP_257056769.1	197	g27112	i0	63.8	1.96208530805687	69	24	98.1	1	209	3	22	89	WP_257056769.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	414	94	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
29460382	29460382	PRJNA446034_S_NODE_38470_length_195_cov_2.594937_g38433_i0	PRJNA446034	38470	195	2.594937	5.06012715	root	1	Root_unresolved	Root_unresolved	57	1.33e-8	NR	GAA6912895.1	210	g38433	i0	73.2	2.58461538461538	41	11	63.1	0	189	67	1	41	GAA6912895.1 hypothetical protein Kyoto207A_3080 [Helicobacter pylori]	diamond	504	57	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30265891	30265891	PRJNA446034_S_NODE_26172_length_212_cov_33.920000_g26135_i0	PRJNA446034	26172	212	33.92	71.9104	Helicobacter pylori	210	Bacteria	Bacteria	63.9	1.8e-11	NR	GAA9246723.1	210	g26135	i0	59.2	0.693396226415094	49	20	69.3	0	11	157	3	51	GAA9246723.1 hypothetical protein Kyoto199A_0690 [Helicobacter pylori]	diamond	147	63.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30897669	30897669	PRJNA446034_S_NODE_60654_length_175_cov_4.152174_g60617_i0	PRJNA446034	60654	175	4.152174	7.2663045	Campylobacter jejuni	197	Bacteria	Bacteria	126	7.63e-35	NR	EOH1988380.1	197	g60617	i0	98.3	0.994285714285714	58	1	99.4	0	175	2	130	187	EOH1988380.1 YqaJ viral recombinase family protein [Campylobacter jejuni]	diamond	174	126	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
31371810	31371810	PRJNA446034_S_NODE_92856_length_158_cov_2.842975_g92819_i0	PRJNA446034	92856	158	2.842975	4.4919005	Campylobacter concisus	199	Bacteria	Bacteria	74.7	6.2e-14	NR	WP_021088947.1	199	g92819	i0	74.5	2.90506329113924	51	13	96.8	0	6	158	815	865	WP_021088947.1 retention module-containing protein [Campylobacter concisus]	diamond	459	74.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
31624599	31624599	PRJNA446034_S_NODE_3456_length_333_cov_32.851351_g3419_i0	PRJNA446034	3456	333	32.851351	109.39499883	Helicobacter pylori	210	Bacteria	Bacteria	78.2	8.29e-17	NR	GAA8838853.1	210	g3419	i0	88.1	0.378378378378378	42	5	37.8	0	328	203	2	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	126	78.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31767405	31767405	PRJNA446034_S_NODE_65737_length_172_cov_2.533333_g65700_i0	PRJNA446034	65737	172	2.533333	4.35733276	Pseudomonadati	3379134	Bacteria	Bacteria	59.7	8.99e-10	NR	WP_219812104.1	199	g65700	i0	71.8	5.94767441860465	39	11	68	0	53	169	28	66	WP_219812104.1 S4 domain-containing protein, partial [Campylobacter concisus]	diamond	1023	60.1	0.993344425956739	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
32257768	32257768	PRJNA446034_S_NODE_6718_length_287_cov_4.348000_g6681_i0	PRJNA446034	6718	287	4.348	12.47876	Campylobacter sp. CS_ED1	2984140	Bacteria	Bacteria	141	2.19e-39	NR	WP_270871688.1	2984140	g6681	i0	71.6	1.98606271777003	95	27	99.3	0	287	3	2	96	WP_270871688.1 major capsid protein, partial [Campylobacter sp. CS_ED1]	diamond	570	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CS_ED1
32857094	32857094	PRJNA446034_S_NODE_113400_length_150_cov_19.176991_g113363_i0	PRJNA446034	113400	150	19.176991	28.7654865	Helicobacter pylori	210	Bacteria	Bacteria	41.2	0.00623	NR	GAA9192772.1	210	g113363	i0	73.9	0.46	23	6	46	0	76	8	1	23	GAA9192772.1 hypothetical protein Kyoto193A_3750 [Helicobacter pylori]	diamond	69	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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