metadata: contig_metadata: 27 rows where bioproject = "PRJNA446034", tax_phylum = "Campylobacterota" and tax

27 rows where bioproject = "PRJNA446034", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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
4265116	4265116	PRJNA446034_S_NODE_28504_length_209_cov_1.837209_g28467_i0	PRJNA446034	28504	209	1.837209	3.83976681	Campylobacter concisus	199	Bacteria	Bacteria	339	1.26e-88	NTclustered	gi\|1938717787\|gb\|CP060705.1\|	199	g28467	i0	96.135	15.799043062201	207	8	99	0	3	209	983581	983375	Campylobacter concisus strain P13UCO-S1 chromosome, complete genome	blastn	3302	339	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6815953	6815953	PRJNA446034_S_NODE_48306_length_185_cov_2.621622_g48269_i0	PRJNA446034	48306	185	2.621622	4.8500007	Campylobacter avium	522485	Bacteria	Bacteria	307	3.05e-79	NTclustered	gi\|1226875038\|gb\|CP022347.1\|	522484	g48269	i0	96.774	3.14054054054054	186	2	99	3	1	184	1230445	1230262	Campylobacter avium LMG 24591 chromosome, complete genome	blastn	581	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter avium
7469963	7469963	PRJNA446034_S_NODE_55146_length_179_cov_4.436620_g55109_i0	PRJNA446034	55146	179	4.43662	7.9415498	Campylobacter	194	Bacteria	Bacteria	326	8.09e-85	NTclustered	gi\|1733425738\|gb\|CP043427.1\|	32024	g55109	i0	99.441	4.98324022346369	179	1	100	0	1	179	1693599	1693421	Campylobacter sputorum subsp. sputorum strain LMG 7795 chromosome, complete genome	blastn	892	326	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sputorum
8091372	8091372	PRJNA446034_S_NODE_4087_length_322_cov_1.950877_g4050_i0	PRJNA446034	4087	322	1.950877	6.28182394	Campylobacter concisus	199	Bacteria	Bacteria	427	4.299999999999999e-115	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g4050	i0	91.429	15.6086956521739	315	22	98	5	6	319	367488	367798	Campylobacter concisus strain RMIT-O23 chromosome	blastn	5026	427	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
8744938	8744938	PRJNA446034_S_NODE_30307_length_206_cov_2.207101_g30270_i0	PRJNA446034	30307	206	2.207101	4.54662806	Bacteria	2	Bacteria	Bacteria	381	2.0199999999999994e-101	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g30270	i0	100	379.946601941748	206	0	100	0	1	206	554361	554156	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	78269	381	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
13191650	13191650	PRJNA446034_S_NODE_113991_length_150_cov_5.637168_g113954_i0	PRJNA446034	113991	150	5.637168	8.455752	Campylobacter concisus	199	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g113954	i0	100	1	150	0	100	0	1	150	118086	117937	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	150	278	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
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
17015375	17015375	PRJNA446034_S_NODE_113954_length_150_cov_5.805310_g113917_i0	PRJNA446034	113954	150	5.80531	8.707965	Arcobacter suis	1278212	Bacteria	Bacteria	206	8.86e-49	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g113917	i0	91.333	3.78666666666667	150	13	100	0	1	150	761367	761218	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	568	206	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
19564261	19564261	PRJNA446034_S_NODE_96216_length_157_cov_1.275000_g96179_i0	PRJNA446034	96216	157	1.275	2.00175	Campylobacter concisus	199	Bacteria	Bacteria	211	2.02e-50	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g96179	i0	93.056	2.7515923566879	144	10	92	0	4	147	674703	674846	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	432	211	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20839694	20839694	PRJNA446034_S_NODE_15097_length_240_cov_2.187192_g15060_i0	PRJNA446034	15097	240	2.187192	5.2492608	Campylobacter rectus	203	Bacteria	Bacteria	111	3.51e-20	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g15060	i0	85.321	0.908333333333333	109	14	45	2	127	233	1753551	1753659	Campylobacter rectus strain ATCC 33238, complete genome	blastn	218	111	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
20839802	20839802	PRJNA446034_S_NODE_33037_length_202_cov_3.139394_g33000_i0	PRJNA446034	33037	202	3.139394	6.34157588	Aliarcobacter thereius	544718	Bacteria	Bacteria	291	3.42e-74	NTclustered	gi\|1576840368\|gb\|CP035926.1\|	1032240	g33000	i0	92.574	1	202	15	100	0	1	202	1195468	1195669	Aliarcobacter thereius LMG 24486 chromosome, complete genome	blastn	202	291	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter thereius
21493802	21493802	PRJNA446034_S_NODE_5077_length_306_cov_6.211896_g5040_i0	PRJNA446034	5077	306	6.211896	19.00840176	Campylobacter	194	Bacteria	Bacteria	459	1.4399999999999999e-124	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g5040	i0	94.04	3.94444444444444	302	18	99	0	1	302	1108054	1108355	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	1207	460	0.997826086956522	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
21493848	21493848	PRJNA446034_S_NODE_71417_length_168_cov_9.557252_g71380_i0	PRJNA446034	71417	168	9.557252	16.05618336	Arcobacter	28196	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g71380	i0	95.181	7.46428571428571	166	8	99	0	1	166	980998	981163	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	1254	265	0.992452830188679	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
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);;