metadata: contig_metadata: 22 rows where bioproject = "PRJNA399711", tax_kingdom = "Pseudomonadati" and tax

22 rows where bioproject = "PRJNA399711", tax_kingdom = "Pseudomonadati" 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
6184053	6184053	PRJNA399711_P_NODE_15945_length_172_cov_4.088889_g15879_i0	PRJNA399711	15945	172	4.088889	7.03288908	Helicobacter	209	Bacteria	Bacteria	207	2.91e-49	NTclustered	gi\|50957138\|gb\|AY596223.1\|	35818	g15879	i0	90.741	74.546511627907	162	2	94	1	10	171	331	183	Helicobacter pullorum strain NCTC 12827 23S ribosomal RNA gene, partial sequence	blastn	12822	207	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pullorum
25562738	25562738	PRJNA399711_S_NODE_24977_length_255_cov_2.665138_g24835_i0	PRJNA399711	24977	255	2.665138	6.7961019	Campylobacter sp. CN_NE2	2984146	Bacteria	Bacteria	87.9	6.35e-13	NTclustered	gi\|2427059240\|gb\|CP115608.1\|	2984146	g24835	i0	80.342	1.54117647058824	117	21	45	2	41	156	1062063	1062178	Campylobacter sp. CN_NE2 strain Cn NE2 chromosome	blastn	393	87.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CN_NE2
25563065	25563065	PRJNA399711_S_NODE_32185_length_233_cov_2.015306_g32043_i0	PRJNA399711	32185	233	2.015306	4.69566298	Arcobacter ellisii	913109	Bacteria	Bacteria	368	1.82e-97	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g32043	i0	95.633	11.9613733905579	229	10	98	0	5	233	2185287	2185059	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	2787	368	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
25564804	25564804	PRJNA399711_S_NODE_78489_length_169_cov_2.643939_g78347_i0	PRJNA399711	78489	169	2.643939	4.46825691	Sulfurimonas aquatica	2672570	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2006624948\|gb\|CP046072.1\|	2672570	g78347	i0	100	0.165680473372781	28	0	17	0	130	157	1357853	1357880	Sulfurimonas aquatica strain H1576 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas aquatica
25698000	25698000	PRJNA399711_S_NODE_105994_length_152_cov_1.217391_g105852_i0	PRJNA399711	105994	152	1.217391	1.85043432	Arcobacter ellisii	913109	Bacteria	Bacteria	78.7	2.05e-10	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g105852	i0	95.833	1.09210526315789	48	2	32	0	105	152	1245141	1245094	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	166	78.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
25701485	25701485	PRJNA399711_S_NODE_95034_length_158_cov_1.644628_g94892_i0	PRJNA399711	95034	158	1.644628	2.59851224	Campylobacter sp. RM12651	1660079	Bacteria	Bacteria	154	3.48e-33	NTclustered	gi\|2198381838\|gb\|CP059600.1\|	1660079	g94892	i0	85.333	5.4873417721519004	150	20	94	2	10	158	1871883	1872031	Campylobacter sp. RM12651 chromosome, complete genome	blastn	867	154	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. RM12651
25835314	25835314	PRJNA399711_S_NODE_32691_length_231_cov_8.963918_g32549_i0	PRJNA399711	32691	231	8.963918	20.70665058	Arcobacter ellisii	913109	Bacteria	Bacteria	303	5.16e-78	NTclustered	gi\|1474793334\|gb\|CP032097.1\|	913109	g32549	i0	90.435	10.9350649350649	230	22	99	0	2	231	803655	803884	Arcobacter ellisii strain LMG 26155 chromosome, complete genome	blastn	2526	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter ellisii
25972899	25972899	PRJNA399711_S_NODE_67716_length_178_cov_4.212766_g67574_i0	PRJNA399711	67716	178	4.212766	7.49872348	Helicobacter pullorum	35818	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|1540242994\|emb\|LR134509.1\|	35818	g67574	i0	98.876	1	178	2	100	0	1	178	1702998	1703175	Helicobacter pullorum strain NCTC13154 genome assembly, chromosome: 1	blastn	178	318	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pullorum
26242534	26242534	PRJNA399711_S_NODE_108070_length_151_cov_1.008772_g107928_i0	PRJNA399711	108070	151	1.008772	1.52324572	Campylobacter ureolyticus RIGS 988	827	Bacteria	Bacteria	267	4.04e-67	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g107928	i0	98.667	4.98013245033113	150	2	99	0	2	151	1046994	1047143	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	752	267	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
26517978	26517978	PRJNA399711_S_NODE_92416_length_159_cov_4.450820_g92274_i0	PRJNA399711	92416	159	4.45082	7.0768038	Helicobacter cholecystus	45498	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1540259954\|emb\|LR134518.1\|	45498	g92274	i0	100	0.176100628930818	28	0	18	0	107	134	1360383	1360356	Helicobacter cholecystus strain NCTC13205 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cholecystus
27913197	27913197	PRJNA399711_P_NODE_13985_length_178_cov_3.312057_g13919_i0	PRJNA399711	13985	178	3.312057	5.89546146	Bacteria	2	Bacteria	Bacteria	39.7	0.0194	NR	GAA8912035.1	210	g13919	i0	76.2	0.691011235955056	21	5	35.4	0	124	62	16	36	GAA8912035.1 hypothetical protein Kyoto166A_2340 [Helicobacter pylori]	diamond	123	40	0.9925	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28938708	28938708	PRJNA399711_P_NODE_19148_length_164_cov_6.133858_g19082_i0	PRJNA399711	19148	164	6.133858	10.05952712	Helicobacter pylori	210	Bacteria	Bacteria	67	4.78e-13	NR	GAA8854446.1	210	g19082	i0	72.5	0.932926829268293	51	13	91.5	1	160	11	19	69	GAA8854446.1 hypothetical protein Kyoto154A_1380 [Helicobacter pylori]	diamond	153	67	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31750405	31750405	PRJNA399711_P_NODE_12137_length_185_cov_9.283784_g12071_i0	PRJNA399711	12137	185	9.283784	17.1750004	Helicobacter pylori	210	Bacteria	Bacteria	45.4	3.59e-4	NR	GAA9044369.1	210	g12071	i0	80	0.405405405405405	25	5	40.5	0	166	92	54	78	GAA9044369.1 hypothetical protein Kyoto184A_02810 [Helicobacter pylori]	diamond	75	45.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32825071	32825071	PRJNA399711_P_NODE_9480_length_199_cov_16.043210_g9414_i0	PRJNA399711	9480	199	16.04321	31.9259879	Helicobacter pylori	210	Bacteria	Bacteria	49.7	3.07e-6	NR	GAA6795642.1	210	g9414	i0	100	0.301507537688442	20	0	30.2	0	197	138	1	20	GAA6795642.1 hypothetical protein Kyoto200A_0470 [Helicobacter pylori]	diamond	60	49.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32917513	32917513	PRJNA399711_S_NODE_27945_length_245_cov_2.971154_g27803_i0	PRJNA399711	27945	245	2.971154	7.2793273	Desulfurellales bacterium	2482794	Bacteria	Bacteria	62.4	7.41e-10	NR	TXH57698.1	2482794	g27803	i0	49.2	0.746938775510204	61	30	74.7	1	242	60	97	156	TXH57698.1 MAG: HK97 gp10 family phage protein [Desulfurellales bacterium]	diamond	183	62.4	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
32958422	32958422	PRJNA399711_S_NODE_30218_length_238_cov_4.890547_g30076_i0	PRJNA399711	30218	238	4.890547	11.63950186	Pseudomonadati	3379134	Bacteria	Bacteria	57.4	8.79e-9	NR	GAA9038100.1	210	g30076	i0	47.1	1.18487394957983	68	11	85.7	1	32	235	6	48	GAA9038100.1 hypothetical protein Kyoto184A_01000 [Helicobacter pylori]	diamond	282	57.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33020328	33020328	PRJNA399711_S_NODE_67476_length_178_cov_7.978723_g67334_i0	PRJNA399711	67476	178	7.978723	14.20212694	Helicobacter pylori	210	Bacteria	Bacteria	40.8	0.00825	NR	GAA9056084.1	210	g67334	i0	75	0.337078651685393	20	5	33.7	0	96	37	1	20	GAA9056084.1 hypothetical protein Kyoto184A_04520 [Helicobacter pylori]	diamond	60	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33043774	33043774	PRJNA399711_S_NODE_98708_length_156_cov_0.941176_g98566_i0	PRJNA399711	98708	156	0.941176	1.46823456	Aliarcobacter	2321111	Bacteria	Bacteria	92.8	8.25e-21	NR	WP_237923586.1	28197	g98566	i0	86	4.80769230769231	50	7	96.2	0	2	151	251	300	WP_237923586.1 DNA (cytosine-5-)-methyltransferase [Aliarcobacter butzleri]	diamond	750	93.6	0.991452991452991	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
33054594	33054594	PRJNA399711_S_NODE_92205_length_159_cov_6.254098_g92063_i0	PRJNA399711	92205	159	6.254098	9.94401582	Helicobacter pylori	210	Bacteria	Bacteria	39.3	0.0387	NR	GAA6988816.1	210	g92063	i0	53.2	0.886792452830189	47	17	88.7	1	155	15	18	59	GAA6988816.1 hypothetical protein Kyoto211A_4340 [Helicobacter pylori]	diamond	141	39.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33122648	33122648	PRJNA399711_S_NODE_55911_length_191_cov_3.512987_g55769_i0	PRJNA399711	55911	191	3.512987	6.70980517	Campylobacter coli	195	Bacteria	Bacteria	115	1.38e-28	NR	WP_402370334.1	195	g55769	i0	88.9	0.989528795811518	63	7	99	0	3	191	17	79	WP_402370334.1 protein rep [Campylobacter coli]	diamond	189	115	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
33139685	33139685	PRJNA399711_S_NODE_53919_length_193_cov_18.461538_g53777_i0	PRJNA399711	53919	193	18.461538	35.63076834	Campylobacterota bacterium	2026809	Bacteria	Bacteria	43.5	0.00934	NR	MEA3512836.1	2026809	g53777	i0	50	0.652849740932642	42	21	65.3	0	13	138	8	49	MEA3512836.1 DUF3800 domain-containing protein [Campylobacterota bacterium]	diamond	126	43.5	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
33139754	33139754	PRJNA399711_S_NODE_64455_length_181_cov_7.451389_g64313_i0	PRJNA399711	64455	181	7.451389	13.48701409	Helicobacter pylori	210	Bacteria	Bacteria	44.7	4.55e-4	NR	GAA9243766.1	210	g64313	i0	78.3	0.38121546961326	23	5	38.1	0	2	70	3	25	GAA9243766.1 hypothetical protein Kyoto198A_5880 [Helicobacter pylori]	diamond	69	44.7	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);;