metadata: contig_metadata: 29 rows where bioproject = "PRJNA681822", tax_kingdom = "Pseudomonadati" and tax

29 rows where bioproject = "PRJNA681822", 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
656149	656149	PRJNA681822_P_NODE_479181_length_241_cov_0.916667_g477691_i0	PRJNA681822	479181	241	0.916667	2.20916747	Campylobacter concisus	199	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g477691	i0	98.34	17.9377593360996	241	4	100	0	1	241	556465	556705	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	4323	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
1930595	1930595	PRJNA681822_P_NODE_340522_length_263_cov_1.610526_g339033_i0	PRJNA681822	340522	263	1.610526	4.23568338	Nitratiruptor sp. YY09-18	2724901	Bacteria	Bacteria	78.7	3.96e-10	NTclustered	gi\|1941658040\|dbj\|AP023065.1\|	2724901	g339033	i0	87.879	0.250950570342205	66	8	25	0	5	70	769971	769906	Nitratiruptor sp. YY09-18 DNA, complete genome	blastn	66	78.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nitratiruptoraceae	Nitratiruptor	Nitratiruptor sp. YY09-18
3205507	3205507	PRJNA681822_P_NODE_351663_length_260_cov_1.411765_g350174_i0	PRJNA681822	351663	260	1.411765	3.670589	Campylobacter concisus	199	Bacteria	Bacteria	451	1.9999999999999998e-122	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g350174	i0	98.077	12.3192307692308	260	3	100	1	1	260	748378	748121	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	3203	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
5759025	5759025	PRJNA681822_P_NODE_410465_length_248_cov_1.668571_g408976_i0	PRJNA681822	410465	248	1.668571	4.13805608	Campylobacter concisus	199	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g408976	i0	100	5	248	0	100	0	1	248	91683	91436	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	1240	459	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
5759191	5759191	PRJNA681822_P_NODE_423005_length_247_cov_0.885057_g421516_i0	PRJNA681822	423005	247	0.885057	2.18609079	Campylobacter concisus	199	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1938730527\|gb\|CP049274.1\|	199	g421516	i0	99.595	22.7570850202429	247	1	100	0	1	247	483741	483987	Campylobacter concisus strain P10CDO-S2 chromosome, complete genome	blastn	5621	451	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
8309358	8309358	PRJNA681822_P_NODE_469807_length_242_cov_0.911243_g468317_i0	PRJNA681822	469807	242	0.911243	2.20520806	Aliarcobacter lanthieri	1355374	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2922053193\|gb\|CP182894.1\|	1355374	g468317	i0	100	0.231404958677686	28	0	12	0	193	220	651913	651886	Aliarcobacter lanthieri strain BNI-4366 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter lanthieri
10099614	10099614	PRJNA681822_P_NODE_452628_length_244_cov_0.900585_g451138_i0	PRJNA681822	452628	244	0.900585	2.1974274	Campylobacter	194	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1935893765\|gb\|CP049234.1\|	199	g451138	i0	98.77	17.8729508196721	244	3	100	0	1	244	704329	704086	Campylobacter concisus strain P15UCO-S2 chromosome, complete genome	blastn	4361	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12135639	12135639	PRJNA681822_P_NODE_474050_length_242_cov_0.911243_g472560_i0	PRJNA681822	474050	242	0.911243	2.20520806	Campylobacter showae	204	Bacteria	Bacteria	355	1.48e-93	NTclustered	gi\|1483583494\|emb\|LT631418.1\|	204	g472560	i0	94.017	5.80165289256198	234	14	97	0	1	234	36405	36172	Campylobacter showae genome assembly, chromosome: I	blastn	1404	355	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
13407957	13407957	PRJNA681822_P_NODE_296371_length_275_cov_1.460396_g294882_i0	PRJNA681822	296371	275	1.460396	4.016089	Campylobacter concisus	199	Bacteria	Bacteria	497	2.7e-136	NTclustered	gi\|1063302220\|gb\|CP000792.2\|	360104	g294882	i0	99.273	15.6181818181818	275	2	100	0	1	275	802185	802459	Campylobacter concisus 13826 chromosome, complete genome	blastn	4295	497	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
13408874	13408874	PRJNA681822_P_NODE_373911_length_253_cov_1.711111_g372422_i0	PRJNA681822	373911	253	1.711111	4.32911083	Campylobacter rectus	203	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g372422	i0	98.024	13.2213438735178	253	5	100	0	1	253	976812	976560	Campylobacter rectus strain ATCC 33238, complete genome	blastn	3345	440	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
14682552	14682552	PRJNA681822_P_NODE_247412_length_287_cov_1.425234_g245923_i0	PRJNA681822	247412	287	1.425234	4.09042158	Helicobacter pylori	210	Bacteria	Bacteria	231	3.1799999999999997e-56	NTclustered	gi\|2814758776\|gb\|PQ423797.1\|	210	g245923	i0	90.805	72.1881533101045	174	15	60	1	111	283	18177	18004	Helicobacter pylori strain TER81 plasmid pTER81, complete sequence	blastn	20718	231	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
19780370	19780370	PRJNA681822_P_NODE_251916_length_286_cov_1.366197_g250427_i0	PRJNA681822	251916	286	1.366197	3.90732342	Campylobacter concisus	199	Bacteria	Bacteria	473	4.7599999999999997e-129	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g250427	i0	96.503	11.979020979021	286	10	100	0	1	286	194587	194872	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	3426	473	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22331498	22331498	PRJNA681822_P_NODE_301758_length_274_cov_1.039801_g300269_i0	PRJNA681822	301758	274	1.039801	2.84905474	Campylobacter concisus	199	Bacteria	Bacteria	424	4.63e-114	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g300269	i0	94.526	17.956204379562	274	15	100	0	1	274	1512881	1512608	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	4920	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22332027	22332027	PRJNA681822_P_NODE_348458_length_261_cov_1.313830_g346969_i0	PRJNA681822	348458	261	1.31383	3.4290963	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	444	3.36e-120	NTclustered	gi\|2620255116\|gb\|CP129949.1\|	2933791	g346969	i0	97.318	29.0229885057471	261	7	100	0	1	261	216887	217147	Arcobacter cryaerophilus gv. pseudocryaerophilus strain DSM 115956 chromosome, complete genome	blastn	7575	444	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
24881778	24881778	PRJNA681822_P_NODE_424860_length_247_cov_0.885057_g423371_i0	PRJNA681822	424860	247	0.885057	2.18609079	Campylobacter concisus	199	Bacteria	Bacteria	329	9.21e-86	NTclustered	gi\|1938728373\|gb\|CP049272.1\|	199	g423371	i0	90.688	10.080971659919	247	23	100	0	1	247	1505159	1504913	Campylobacter concisus strain P27CDO-S2 chromosome, complete genome	blastn	2490	329	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
27271670	27271670	PRJNA681822_P_NODE_47643_length_540_cov_1.781585_g46187_i0	PRJNA681822	47643	540	1.781585	9.620559	Helicobacter pylori	210	Bacteria	Bacteria	216	9.87e-70	NR	GAA7771988.1	210	g46187	i0	100	0.572222222222222	103	0	57.2	0	538	230	3	105	GAA7771988.1 hypothetical protein HpMS107_60470 [Helicobacter pylori]	diamond	309	216	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28408507	28408507	PRJNA681822_P_NODE_459086_length_243_cov_1.382353_g457596_i0	PRJNA681822	459086	243	1.382353	3.35911779	Campylobacter concisus	199	Bacteria	Bacteria	147	3.52e-39	NR	WP_103569199.1	199	g457596	i0	92.3	0.962962962962963	78	6	96.3	0	8	241	402	479	WP_103569199.1 asparagine synthase (glutamine-hydrolyzing) [Campylobacter concisus]	diamond	234	147	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
28503167	28503167	PRJNA681822_P_NODE_246427_length_287_cov_1.626168_g244938_i0	PRJNA681822	246427	287	1.626168	4.66710216	Helicobacter pylori	210	Bacteria	Bacteria	52.4	8.77e-7	NR	GAA9130373.1	210	g244938	i0	50	0.815331010452962	52	9	54.4	1	170	15	4	38	GAA9130373.1 hypothetical protein Kyoto190A_1990 [Helicobacter pylori]	diamond	234	52.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28661112	28661112	PRJNA681822_P_NODE_283227_length_278_cov_1.853659_g281738_i0	PRJNA681822	283227	278	1.853659	5.15317202	Helicobacter pylori	210	Bacteria	Bacteria	52	1.78e-6	NR	GAA6953496.1	210	g281738	i0	67.7	1.76978417266187	62	20	66.9	0	219	34	11	72	GAA6953496.1 hypothetical protein Kyoto211A_0670 [Helicobacter pylori]	diamond	492	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28850266	28850266	PRJNA681822_P_NODE_209088_length_303_cov_1.252174_g207600_i0	PRJNA681822	209088	303	1.252174	3.79408722	Helicobacter pylori	210	Bacteria	Bacteria	54.7	2.1e-7	NR	GAA9209002.1	210	g207600	i0	68.8	0.316831683168317	32	10	31.7	0	213	118	6	37	GAA9209002.1 hypothetical protein Kyoto198A_1420 [Helicobacter pylori]	diamond	96	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29987253	29987253	PRJNA681822_P_NODE_328331_length_266_cov_2.347150_g326842_i0	PRJNA681822	328331	266	2.34715	6.243419	Helicobacter pylori	210	Bacteria	Bacteria	61.6	1.51e-10	NR	GAA9176259.1	210	g326842	i0	57.4	1.06015037593985	47	20	53	0	165	25	4	50	GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori]	diamond	282	61.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30019013	30019013	PRJNA681822_P_NODE_480971_length_241_cov_0.916667_g479481_i0	PRJNA681822	480971	241	0.916667	2.20916747	Helicobacter pylori	210	Bacteria	Bacteria	40	0.0478	NR	GAA8957928.1	210	g479481	i0	59.3	0.336099585062241	27	11	33.6	0	81	1	20	46	GAA8957928.1 hypothetical protein Kyoto181A_3320 [Helicobacter pylori]	diamond	81	40	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30398419	30398419	PRJNA681822_P_NODE_111113_length_378_cov_1.009836_g109627_i0	PRJNA681822	111113	378	1.009836	3.81718008	Campylobacter coli	195	Bacteria	Bacteria	45.8	0.0125	NR	WP_342248546.1	195	g109627	i0	27.9	0.53968253968254	68	47	52.4	1	275	78	257	324	WP_342248546.1 hypothetical protein, partial [Campylobacter coli]	diamond	204	45.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
30492804	30492804	PRJNA681822_P_NODE_328633_length_266_cov_2.041451_g327144_i0	PRJNA681822	328633	266	2.041451	5.43025966	Helicobacter pylori	210	Bacteria	Bacteria	63.2	1.26e-10	NR	GAA8799372.1	210	g327144	i0	60.9	0.981203007518797	87	31	94.7	3	253	2	6	92	GAA8799372.1 hypothetical protein Kyoto149A_1730 [Helicobacter pylori]	diamond	261	63.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31167674	31167674	PRJNA681822_P_NODE_334335_length_265_cov_1.276042_g332846_i0	PRJNA681822	334335	265	1.276042	3.3815113	Pseudomonadati	3379134	Bacteria	Bacteria	64.3	1.04e-11	NR	GAA8757316.1	210	g332846	i0	86.7	1.69811320754717	30	4	34	0	259	170	1	30	GAA8757316.1 hypothetical protein Kyoto147A_3750 [Helicobacter pylori]	diamond	450	64.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31516148	31516148	PRJNA681822_P_NODE_412756_length_248_cov_0.880000_g411267_i0	PRJNA681822	412756	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	8.16e-7	NR	WP_390595206.1	210	g411267	i0	45.3	1.46370967741935	53	29	64.1	0	245	87	25	77	WP_390595206.1 tetratricopeptide repeat protein [Helicobacter pylori]	diamond	363	53.1	0.994350282485876	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31567641	31567641	PRJNA681822_P_NODE_426296_length_247_cov_0.885057_g424807_i0	PRJNA681822	426296	247	0.885057	2.18609079	Helicobacter pylori	210	Bacteria	Bacteria	59.7	1.5e-9	NR	GAA8948737.1	210	g424807	i0	42.1	4.66396761133603	76	18	91.1	2	234	10	6	56	GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori]	diamond	1152	59.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32358581	32358581	PRJNA681822_P_NODE_365939_length_256_cov_1.262295_g364450_i0	PRJNA681822	365939	256	1.262295	3.2314752	Helicobacter pylori	210	Bacteria	Bacteria	98.6	8.059999999999999e-23	NR	GAA7771998.1	210	g364450	i0	81.5	0.76171875	65	10	73.8	1	191	3	1	65	GAA7771998.1 hypothetical protein HpMS107_60550 [Helicobacter pylori]	diamond	195	98.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32863053	32863053	PRJNA681822_P_NODE_162580_length_332_cov_1.745174_g161092_i0	PRJNA681822	162580	332	1.745174	5.79397768	Helicobacter pylori	210	Bacteria	Bacteria	228	8.93e-75	NR	GAA7771007.1	210	g161092	i0	100	0.993975903614458	110	0	99.4	0	2	331	10	119	GAA7771007.1 hypothetical protein HpMS107_56900 [Helicobacter pylori]	diamond	330	228	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);;