metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA737474" 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
25573523	25573523	PRJNA737474d_S_NODE_32737_length_267_cov_0.963918_g32143_i0	PRJNA737474	32737	267	0.963918	2.57366106	Helicobacter enhydrae	222136	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1046578886\|gb\|CP016503.1\|	222136	g32143	i0	100	0.108614232209738	29	0	11	0	102	130	1081654	1081626	Helicobacter enhydrae strain MIT 01-6242 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter enhydrae
25587934	25587934	PRJNA737474g_S_NODE_430737_length_241_cov_823.077381_g429443_i0	PRJNA737474	430737	241	823.077381	1983.61648821	Campylobacterota bacterium	2026809	Bacteria	Bacteria	86.1	2.14e-12	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g429443	i0	96.154	177.477178423237	52	2	22	0	151	202	89	38	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	42772	86.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25588409	25588409	PRJNA737474g_S_NODE_474273_length_233_cov_859.187500_g472979_i0	PRJNA737474	474273	233	859.1875	2001.906875	Campylobacterota bacterium	2026809	Bacteria	Bacteria	78.7	3.44e-10	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g472979	i0	92.727	174.763948497854	55	2	23	1	150	202	82	28	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	40720	78.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25589195	25589195	PRJNA737474g_S_NODE_601537_length_202_cov_2.217054_g600243_i0	PRJNA737474	601537	202	2.217054	4.47844908	Campylobacterota bacterium	2026809	Bacteria	Bacteria	78.7	2.9e-10	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g600243	i0	92.727	219.559405940594	55	2	26	2	135	187	89	35	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	44351	78.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25625718	25625718	PRJNA737474b_S_NODE_25097_length_320_cov_2.121457_g24058_i0	PRJNA737474	25097	320	2.121457	6.7886624	root	1	Root_unresolved	Root_unresolved	54.7	0.008	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g24058	i0	100	1.434375	29	0	9	0	292	320	685184	685156	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	459	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
25707886	25707886	PRJNA737474c_S_NODE_30218_length_232_cov_26.232704_g29387_i0	PRJNA737474	30218	232	26.232704	60.85987328	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g29387	i0	100	0.120689655172414	28	0	12	0	128	155	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
25713945	25713945	PRJNA737474f_S_NODE_169562_length_260_cov_0.877005_g168884_i0	PRJNA737474	169562	260	0.877005	2.280213	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	5.09e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g168884	i0	97.059	0.130769230769231	34	1	13	0	208	241	640627	640660	Campylobacter jejuni strain IF1100, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25719419	25719419	PRJNA737474g_S_NODE_152066_length_296_cov_0.793722_g150772_i0	PRJNA737474	152066	296	0.793722	2.34941712	Campylobacter jejuni	197	Bacteria	Bacteria	60.2	1.64e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g150772	i0	97.143	0.11824324324324299	35	1	12	0	24	58	640661	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	35	60.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25719828	25719828	PRJNA737474g_S_NODE_16914_length_763_cov_66.600000_g15765_i0	PRJNA737474	16914	763	66.6	508.158	Arcobacter sp. KX21116	2906515	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|2809047151\|gb\|CP090177.1\|	2906515	g15765	i0	100	0.0380078636959371	29	0	4	0	175	203	1017122	1017150	Arcobacter sp. KX21116 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter iocasae
25723773	25723773	PRJNA737474g_S_NODE_409130_length_243_cov_1.035294_g407836_i0	PRJNA737474	409130	243	1.035294	2.51576442	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	4.71e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g407836	i0	97.059	0.139917695473251	34	1	14	0	18	51	640660	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25761959	25761959	PRJNA737474b_S_NODE_21034_length_349_cov_6.807971_g19995_i0	PRJNA737474	21034	349	6.807971	23.75981879	root	1	Root_unresolved	Root_unresolved	71.3	9.1e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g19995	i0	100	36.8739255014327	38	0	32	0	296	333	1292617	1292580	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	12869	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
25763764	25763764	PRJNA737474d_S_NODE_21546_length_329_cov_1.007812_g20952_i0	PRJNA737474	21546	329	1.007812	3.31570148	Pseudomonadati	3379134	Bacteria	Bacteria	527	4.2199999999999984e-145	NTclustered	gi\|972494020\|gb\|CP010483.1\|	197	g20952	i0	98.98	65.7446808510638	294	3	89	0	36	329	1633531	1633238	Campylobacter jejuni strain CJ677CC535, complete genome	blastn	21630	527	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25841957	25841957	PRJNA737474b_S_NODE_44243_length_246_cov_21.416185_g43204_i0	PRJNA737474	44243	246	21.416185	52.6838151	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g43204	i0	100	0.113821138211382	28	0	11	0	133	160	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
25851185	25851185	PRJNA737474f_S_NODE_251971_length_245_cov_0.668605_g251293_i0	PRJNA737474	251971	245	0.668605	1.63808225	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g251293	i0	97.059	0.138775510204082	34	1	14	0	16	49	640660	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25859283	25859283	PRJNA737474g_S_NODE_371547_length_246_cov_1.075145_g370253_i0	PRJNA737474	371547	246	1.075145	2.6448567	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	4.78e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g370253	i0	97.059	0.138211382113821	34	1	14	0	31	64	640660	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25861174	25861174	PRJNA737474g_S_NODE_587691_length_206_cov_5976.751880_g586397_i0	PRJNA737474	587691	206	5976.75188	12312.1088728	Campylobacterota bacterium	2026809	Bacteria	Bacteria	78.7	2.97e-10	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g586397	i0	95.833	211.470873786408	48	2	23	0	37	84	34	81	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	43563	78.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25899080	25899080	PRJNA737474c_S_NODE_6067_length_437_cov_3.741758_g5237_i0	PRJNA737474	6067	437	3.741758	16.35148246	root	1	Root_unresolved	Root_unresolved	62.1	7.02e-5	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g5237	i0	100	7.79862700228833	33	0	8	0	1	33	685152	685184	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	3408	62.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
25899682	25899682	PRJNA737474d_S_NODE_27099_length_292_cov_16.068493_g26505_i0	PRJNA737474	27099	292	16.068493	46.91999956	root	1	Root_unresolved	Root_unresolved	71.3	7.47e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g26505	i0	100	15.2808219178082	38	0	13	0	166	203	1292617	1292580	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	4462	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26035162	26035162	PRJNA737474c_S_NODE_21804_length_265_cov_56.229167_g20973_i0	PRJNA737474	21804	265	56.229167	149.00729255	root	1	Root_unresolved	Root_unresolved	71.3	6.69e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g20973	i0	100	29.5924528301887	38	0	26	0	187	224	1292617	1292580	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	7842	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26036344	26036344	PRJNA737474d_S_NODE_39220_length_245_cov_16.441860_g38626_i0	PRJNA737474	39220	245	16.44186	40.282557	root	1	Root_unresolved	Root_unresolved	71.3	6.11e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g38626	i0	100	33.934693877551	38	0	29	0	124	161	1292617	1292580	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	8314	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26122963	26122963	PRJNA737474f_S_NODE_21485_length_444_cov_2.940701_g20808_i0	PRJNA737474	21485	444	2.940701	13.05671244	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g20808	i0	97.059	0.0765765765765766	34	1	8	0	39	72	640660	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
26134669	26134669	PRJNA737474g_S_NODE_90813_length_336_cov_42.342205_g89519_i0	PRJNA737474	90813	336	42.342205	142.2698088	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g89519	i0	100	0.0833333333333333	28	0	8	0	212	239	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
26172435	26172435	PRJNA737474d_S_NODE_36597_length_252_cov_12.558659_g36003_i0	PRJNA737474	36597	252	12.558659	31.64782068	root	1	Root_unresolved	Root_unresolved	71.3	6.31e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g36003	i0	100	17.2063492063492	38	0	15	0	61	98	1292580	1292617	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	4336	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26175709	26175709	PRJNA737474g_S_NODE_320357_length_251_cov_0.797753_g319063_i0	PRJNA737474	320357	251	0.797753	2.00236003	Pseudomonadati	3379134	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1483583526\|emb\|LT631450.1\|	204	g319063	i0	94.444	0.386454183266932	36	2	14	0	19	54	74165	74130	Campylobacter showae strain 129_VTPPs genome assembly, chromosome: I	blastn	97	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
26176188	26176188	PRJNA737474g_S_NODE_449005_length_239_cov_2.030120_g447711_i0	PRJNA737474	449005	239	2.03012	4.8519868	Pseudomonadati	3379134	Bacteria	Bacteria	73.1	1.65e-8	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g447711	i0	100	183.518828451883	39	0	16	0	175	213	73	35	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	43861	73.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
26256053	26256053	PRJNA737474e_S_NODE_26430_length_260_cov_82.160428_g25548_i0	PRJNA737474	26430	260	82.160428	213.6171128	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g25548	i0	100	0.107692307692308	28	0	11	0	99	126	1771318	1771291	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
26264716	26264716	PRJNA737474g_S_NODE_197030_length_279_cov_0.893204_g195736_i0	PRJNA737474	197030	279	0.893204	2.49203916	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	5.52e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g195736	i0	92.5	0.243727598566308	40	3	14	0	14	53	640660	640621	Campylobacter jejuni strain IF1100, complete genome	blastn	68	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
26398011	26398011	PRJNA737474f_S_NODE_8831_length_688_cov_26.117073_g8220_i0	PRJNA737474	8831	688	26.117073	179.68546224	Arcobacter sp. KX21116	2906515	Bacteria	Bacteria	54.7	0.019	NTclustered	gi\|2809047151\|gb\|CP090177.1\|	2906515	g8220	i0	100	0.0421511627906977	29	0	4	0	172	200	1017122	1017150	Arcobacter sp. KX21116 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter iocasae
26403888	26403888	PRJNA737474g_S_NODE_405415_length_243_cov_409.864706_g404121_i0	PRJNA737474	405415	243	409.864706	995.97123558	Campylobacterota bacterium	2026809	Bacteria	Bacteria	73.1	1.68e-8	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g404121	i0	100	180.716049382716	39	0	16	0	34	72	35	73	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	43914	73.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
26442823	26442823	PRJNA737474b_S_NODE_52095_length_201_cov_23.570312_g51056_i0	PRJNA737474	52095	201	23.570312	47.37632712	root	1	Root_unresolved	Root_unresolved	71.3	4.83e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g51056	i0	100	21.407960199005	38	0	19	0	16	53	1292617	1292580	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	4303	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26530928	26530928	PRJNA737474f_S_NODE_19960_length_458_cov_2.015584_g19283_i0	PRJNA737474	19960	458	2.015584	9.23137472	Aliarcobacter cryaerophilus ATCC 43158	1032070	Bacteria	Bacteria	52.8	0.044	NTclustered	gi\|1679706893\|gb\|CP021072.1\|	1032070	g19283	i0	100	0.122270742358079	28	0	6	0	181	208	1188940	1188967	Arcobacter cryaerophilus ATCC 43158 strain LMG 9904 genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
26537886	26537886	PRJNA737474g_S_NODE_255944_length_262_cov_730.074074_g254650_i0	PRJNA737474	255944	262	730.074074	1912.79407388	Campylobacterota bacterium	2026809	Bacteria	Bacteria	73.1	1.83e-8	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g254650	i0	97.619	168.698473282443	42	1	16	0	36	77	35	76	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	44199	73.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota 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);;