metadata: contig_metadata: 28 rows where bioproject = "PRJNA1035005", tax_kingdom = "Pseudomonadati" and tax

28 rows where bioproject = "PRJNA1035005", 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
168903	168903	PRJNA1035005_P_NODE_50301_length_256_cov_2.453552_g49895_i0	PRJNA1035005	50301	256	2.453552	6.28109312	Campylobacter gracilis	824	Bacteria	Bacteria	368	2.03e-97	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g49895	i0	92.578	3	256	19	100	0	1	256	9200	8945	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	768	368	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
2719602	2719602	PRJNA1035005_P_NODE_85243_length_242_cov_0.923077_g84837_i0	PRJNA1035005	85243	242	0.923077	2.23384634	Wolinella succinogenes	844	Bacteria	Bacteria	409	1.12e-109	NTclustered	gi\|34482172\|emb\|BX571657.1\|	844	g84837	i0	97.107	2	242	7	100	0	1	242	198207	198448	Wolinella succinogenes, complete genome; segment 1/7	blastn	484	409	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
3995559	3995559	PRJNA1035005_P_NODE_65384_length_249_cov_0.886364_g64978_i0	PRJNA1035005	65384	249	0.886364	2.20704636	Wolinella succinogenes	844	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|34483186\|emb\|BX571660.1\|	844	g64978	i0	96.787	2	249	8	100	0	1	249	101661	101909	Wolinella succinogenes, complete genome; segment 4/7	blastn	498	416	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
6547296	6547296	PRJNA1035005_P_NODE_90506_length_203_cov_4.369231_g90099_i0	PRJNA1035005	90506	203	4.369231	8.86953893	Campylobacter concisus	199	Bacteria	Bacteria	309	9.51e-80	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g90099	i0	94.089	10.9704433497537	203	12	100	0	1	203	1323912	1324114	Campylobacter concisus strain RMIT-O23 chromosome	blastn	2227	309	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
7821571	7821571	PRJNA1035005_P_NODE_58147_length_251_cov_2.415730_g57741_i0	PRJNA1035005	58147	251	2.41573	6.0634823	Wolinella succinogenes	844	Bacteria	Bacteria	414	2.52e-111	NTclustered	gi\|34482852\|emb\|BX571659.1\|	844	g57741	i0	96.774	1.97609561752988	248	8	99	0	1	248	281710	281957	Wolinella succinogenes, complete genome; segment 3/7	blastn	496	414	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes
7821800	7821800	PRJNA1035005_P_NODE_85167_length_242_cov_0.923077_g84761_i0	PRJNA1035005	85167	242	0.923077	2.23384634	Campylobacter concisus	199	Bacteria	Bacteria	375	1.14e-99	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g84761	i0	94.628	11	242	13	100	0	1	242	1217823	1217582	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	2662	375	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
9096766	9096766	PRJNA1035005_P_NODE_85008_length_242_cov_0.923077_g84602_i0	PRJNA1035005	85008	242	0.923077	2.23384634	Sulfurospirillum sp. 'SP'	3023479	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|2591884127\|gb\|CP118373.1\|	3023479	g84602	i0	93.802	2	242	15	100	0	1	242	2561610	2561851	Sulfurospirillum sp. 'SP' chromosome, complete genome	blastn	484	364	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp. 'SP'
11647693	11647693	PRJNA1035005_P_NODE_81950_length_243_cov_0.917647_g81544_i0	PRJNA1035005	81950	243	0.917647	2.22988221	Campylobacter showae	204	Bacteria	Bacteria	383	6.84e-102	NTclustered	gi\|1483583555\|emb\|LT631479.1\|	204	g81544	i0	95.417	23.3497942386831	240	11	99	0	1	240	1626008	1626247	Campylobacter showae strain B91_TPP genome assembly, chromosome: I	blastn	5674	383	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
12922916	12922916	PRJNA1035005_P_NODE_87351_length_237_cov_3.695122_g86945_i0	PRJNA1035005	87351	237	3.695122	8.75743914	Campylobacter concisus	199	Bacteria	Bacteria	196	9.29e-46	NTclustered	gi\|1938721615\|gb\|CP049265.1\|	199	g86945	i0	97.391	1.89029535864979	115	3	49	0	1	115	287	401	Campylobacter concisus strain P11CDO-S1 plasmid pSA2, complete sequence	blastn	448	196	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16745844	16745844	PRJNA1035005_P_NODE_42594_length_266_cov_1.616580_g42188_i0	PRJNA1035005	42594	266	1.61658	4.3001028	Campylobacter concisus	199	Bacteria	Bacteria	481	2.62e-131	NTclustered	gi\|1935893765\|gb\|CP049234.1\|	199	g42188	i0	99.248	11	266	2	100	0	1	266	267640	267905	Campylobacter concisus strain P15UCO-S2 chromosome, complete genome	blastn	2926	481	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16746105	16746105	PRJNA1035005_P_NODE_78894_length_244_cov_0.912281_g78488_i0	PRJNA1035005	78894	244	0.912281	2.22596564	Campylobacter ureolyticus	827	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g78488	i0	99.18	4	244	2	100	0	1	244	224391	224634	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	976	440	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
17585571	17585571	PRJNA1035005_P_NODE_12874_length_337_cov_2.193182_g12469_i0	PRJNA1035005	12874	337	2.193182	7.39102334	Campylobacter	194	Bacteria	Bacteria	621	1.9299999999999997e-173	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g12469	i0	100	248.611275964392	336	0	99	0	1	336	393	728	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	83782	621	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19294748	19294748	PRJNA1035005_P_NODE_55796_length_252_cov_1.648045_g55390_i0	PRJNA1035005	55796	252	1.648045	4.1530734	Arcobacter sp. 15-2	3374109	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2862971141\|dbj\|AP038804.1\|	3374109	g55390	i0	100	351.956349206349	252	0	100	0	1	252	339890	340141	Arcobacter sp. 15-2 DNA, complete genome	blastn	88693	466	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. 15-2
20569937	20569937	PRJNA1035005_P_NODE_31057_length_281_cov_1.500000_g30651_i0	PRJNA1035005	31057	281	1.5	4.215	Campylobacter concisus	199	Bacteria	Bacteria	503	5.95e-138	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g30651	i0	98.932	23.3629893238434	281	3	100	0	1	281	1353502	1353782	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	6565	503	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22684709	22684709	PRJNA1035005_P_NODE_51878_length_254_cov_2.530387_g51472_i0	PRJNA1035005	51878	254	2.530387	6.42718298	Campylobacter	194	Bacteria	Bacteria	398	2.5699999999999995e-106	NTclustered	gi\|1938719709\|gb\|CP049264.1\|	199	g51472	i0	94.882	17.6496062992126	254	13	100	0	1	254	545801	546054	Campylobacter concisus strain P11CDO-S1 chromosome, complete genome	blastn	4483	398	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
23121319	23121319	PRJNA1035005_P_NODE_71079_length_247_cov_0.896552_g70673_i0	PRJNA1035005	71079	247	0.896552	2.21448344	Helicobacter canis	29419	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|1721134163\|emb\|LR698964.1\|	29419	g70673	i0	98.381	1	247	4	100	0	1	247	1849477	1849231	Helicobacter canis isolate MGYG-HGUT-01463 genome assembly, chromosome: 1	blastn	247	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
23121378	23121378	PRJNA1035005_P_NODE_77399_length_245_cov_0.906977_g76993_i0	PRJNA1035005	77399	245	0.906977	2.22209365	Campylobacter concisus	199	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|1063302220\|gb\|CP000792.2\|	360104	g76993	i0	96.327	16.9918367346939	245	9	100	0	1	245	1042997	1043241	Campylobacter concisus 13826 chromosome, complete genome	blastn	4163	403	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
23960121	23960121	PRJNA1035005_P_NODE_23219_length_291_cov_1.839450_g22813_i0	PRJNA1035005	23219	291	1.83945	5.3527995	Campylobacter	194	Bacteria	Bacteria	252	2.48e-62	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g22813	i0	96.104	26.7216494845361	154	6	95	0	138	291	384785	384632	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	7776	252	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
23960323	23960323	PRJNA1035005_P_NODE_88459_length_232_cov_2.974843_g88053_i0	PRJNA1035005	88459	232	2.974843	6.90163576	Campylobacter	194	Bacteria	Bacteria	424	3.82e-114	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g88053	i0	99.569	248.331896551724	232	1	100	0	1	232	390969	390738	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	57613	424	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
25233951	25233951	PRJNA1035005_P_NODE_10920_length_354_cov_5.672598_g10515_i0	PRJNA1035005	10920	354	5.672598	20.08099692	Campylobacter	194	Bacteria	Bacteria	649	0	NTclustered	gi\|1207769201\|gb\|MF351714.1\|	199	g10515	i0	99.718	221.186440677966	354	1	100	0	1	354	1501	1148	Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence	blastn	78300	649	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
28298433	28298433	PRJNA1035005_P_NODE_88946_length_230_cov_2.745223_g88539_i0	PRJNA1035005	88946	230	2.745223	6.3140129	Helicobacter pylori	210	Bacteria	Bacteria	57.8	7.23e-9	NR	GAA8683376.1	210	g88539	i0	86.2	0.730434782608696	29	4	37.8	0	168	82	5	33	GAA8683376.1 hypothetical protein Kyoto145A_0600 [Helicobacter pylori]	diamond	168	57.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30256689	30256689	PRJNA1035005_P_NODE_3292_length_603_cov_1.986792_g2902_i0	PRJNA1035005	3292	603	1.986792	11.98035576	Campylobacterota bacterium	2026809	Bacteria	Bacteria	73.9	8.52e-12	NR	MCL4431196.1	2026809	g2902	i0	30.8	0.646766169154229	130	75	58.2	3	417	67	4	131	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	390	73.9	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
30635306	30635306	PRJNA1035005_P_NODE_46553_length_261_cov_1.659574_g46147_i0	PRJNA1035005	46553	261	1.659574	4.33148814	Campylobacter hominis ATCC BAA-381	360107	Bacteria	Bacteria	47	9.77e-5	NR	ABS50882.1	360107	g46147	i0	62.1	0.333333333333333	29	11	33.3	0	106	20	30	58	ABS50882.1 hypothetical protein CHAB381_A0001 [Campylobacter hominis ATCC BAA-381]	diamond	87	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
31394151	31394151	PRJNA1035005_P_NODE_79476_length_244_cov_0.912281_g79070_i0	PRJNA1035005	79476	244	0.912281	2.22596564	Sulfurospirillum sp.	2053622	Bacteria	Bacteria	160	2.55e-47	NR	MBP6325389.1	2053622	g79070	i0	97.5	0.983606557377049	80	2	98.4	0	3	242	144	223	MBP6325389.1 magnesium transporter [Sulfurospirillum sp.]	diamond	240	160	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum sp.
31836593	31836593	PRJNA1035005_P_NODE_55177_length_253_cov_0.866667_g54771_i0	PRJNA1035005	55177	253	0.866667	2.19266751	Helicobacter pylori	210	Bacteria	Bacteria	61.2	1.85e-10	NR	GAA9176259.1	210	g54771	i0	66.7	0.462450592885375	39	13	46.2	0	252	136	10	48	GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori]	diamond	117	61.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32018623	32018623	PRJNA1035005_P_NODE_29958_length_282_cov_2.497608_g29552_i0	PRJNA1035005	29958	282	2.497608	7.04325456	Campylobacter	194	Bacteria	Bacteria	99.4	2.2299999999999998e-23	NR	WP_065844591.1	196	g29552	i0	52.7	6.93617021276596	93	34	98.9	1	1	279	62	144	WP_065844591.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Campylobacter fetus]	diamond	1956	100	0.994	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
32753468	32753468	PRJNA1035005_P_NODE_79740_length_244_cov_0.912281_g79334_i0	PRJNA1035005	79740	244	0.912281	2.22596564	Malaciobacter mytili	603050	Bacteria	Bacteria	81.3	1e-15	NR	WP_129096761.1	603050	g79334	i0	49.4	0.971311475409836	79	39	97.1	1	3	239	522	599	WP_129096761.1 5-histidylcysteine sulfoxide synthase [Malaciobacter mytili]	diamond	237	81.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter mytili
32776877	32776877	PRJNA1035005_P_NODE_35840_length_275_cov_1.316832_g35434_i0	PRJNA1035005	35840	275	1.316832	3.621288	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	2.05e-12	NR	GAA9176272.1	210	g35434	i0	96.8	1.58181818181818	31	1	33.8	0	274	182	1	31	GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori]	diamond	435	68.6	0.994169096209913	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);;