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

28 rows where bioproject = "PRJNA526367", 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
4323258	4323258	PRJNA526367_P_NODE_64464_length_152_cov_7.106796_g64254_i0	PRJNA526367	64464	152	7.106796	10.80232992	Campylobacter ureolyticus	827	Bacteria	Bacteria	241	2.47e-59	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g64254	i0	96.552	2.88157894736842	145	5	95	0	8	152	568752	568896	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	438	241	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
7491869	7491869	PRJNA526367_P_NODE_40886_length_181_cov_5.689394_g40676_i0	PRJNA526367	40886	181	5.689394	10.29780314	Campylobacter	194	Bacteria	Bacteria	316	4.939999999999999e-82	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g40676	i0	100	267.613259668508	171	0	94	0	8	178	28389	28559	Campylobacter showae genome assembly, plasmid: V	blastn	48438	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
8766709	8766709	PRJNA526367_P_NODE_37127_length_188_cov_2.935252_g36917_i0	PRJNA526367	37127	188	2.935252	5.51827376	root	1	Root_unresolved	Root_unresolved	329	6.65e-86	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g36917	i0	100	99.3617021276596	178	0	95	0	4	181	568503	568326	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	18680	329	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
11316714	11316714	PRJNA526367_P_NODE_26749_length_324_cov_1.847273_g26540_i0	PRJNA526367	26749	324	1.847273	5.98516452	Campylobacter	194	Bacteria	Bacteria	161	4.849999999999998e-35	NTclustered	gi\|1483583504\|emb\|LT631428.1\|	204	g26540	i0	97.849	3.07407407407407	93	2	59	0	8	100	26277	26369	Campylobacter showae genome assembly, plasmid: IV	blastn	996	161	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11974861	11974861	PRJNA526367_P_NODE_4890_length_332_cov_3.272085_g4681_i0	PRJNA526367	4890	332	3.272085	10.8633222	Campylobacter ureolyticus	827	Bacteria	Bacteria	239	2.24e-58	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g4681	i0	99.242	2.74698795180723	132	1	69	0	194	325	476882	477013	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	912	239	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
12592378	12592378	PRJNA526367_P_NODE_16570_length_324_cov_2.738182_g16361_i0	PRJNA526367	16570	324	2.738182	8.87170968	Campylobacter	194	Bacteria	Bacteria	183	1.03e-41	NTclustered	gi\|1483583501\|emb\|LT631425.1\|	204	g16361	i0	100	29.3734567901235	99	0	59	0	225	323	72844	72746	Campylobacter showae genome assembly, plasmid: I	blastn	9517	183	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
17691302	17691302	PRJNA526367_P_NODE_15774_length_324_cov_2.825455_g15565_i0	PRJNA526367	15774	324	2.825455	9.1544742	Campylobacter	194	Bacteria	Bacteria	180	1.34e-40	NTclustered	gi\|2093921460\|gb\|CP082871.1\|	76517	g15565	i0	100	2.73456790123457	97	0	59	0	4	100	79456	79360	Campylobacter hominis strain FDAARGOS_1467 chromosome, complete genome	blastn	886	180	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
22172806	22172806	PRJNA526367_P_NODE_4258_length_344_cov_2.210169_g4050_i0	PRJNA526367	4258	344	2.210169	7.60298136	Campylobacter fetus	196	Bacteria	Bacteria	172	2.39e-38	NTclustered	gi\|1043914323\|gb\|CP014570.1\|	32020	g4050	i0	98.969	0.552325581395349	97	0	55	1	4	100	20973	21068	Campylobacter fetus subsp. venerealis strain 01/165 plasmid mp2, complete sequence	blastn	190	172	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
22790866	22790866	PRJNA526367_P_NODE_3878_length_348_cov_4.588629_g3670_i0	PRJNA526367	3878	348	4.588629	15.96842892	Campylobacter	194	Bacteria	Bacteria	274	6.46e-69	NTclustered	gi\|2093923041\|gb\|CP082872.1\|	76517	g3670	i0	100	1.6551724137931	148	0	83	0	198	345	1771	1918	Campylobacter hominis strain FDAARGOS_1467 plasmid unnamed1, complete sequence	blastn	576	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hominis
26602336	26602336	PRJNA526367_P_NODE_63541_length_153_cov_7.692308_g63331_i0	PRJNA526367	63541	153	7.692308	11.76923124	Helicobacter pylori	210	Bacteria	Bacteria	39.3	0.0403	NR	GAA9019617.1	210	g63331	i0	66.7	0.470588235294118	24	8	47.1	0	18	89	46	69	GAA9019617.1 hypothetical protein Kyoto181A_7650 [Helicobacter pylori]	diamond	72	39.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27772583	27772583	PRJNA526367_P_NODE_64684_length_152_cov_5.388350_g64474_i0	PRJNA526367	64684	152	5.38835	8.190292	Helicobacter pylori	210	Bacteria	Bacteria	39.3	0.0403	NR	GAA6966648.1	210	g64474	i0	60.9	0.453947368421053	23	9	45.4	0	59	127	3	25	GAA6966648.1 hypothetical protein Kyoto211A_2720 [Helicobacter pylori]	diamond	69	39.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28056378	28056378	PRJNA526367_P_NODE_1325_length_515_cov_33.497854_g1184_i0	PRJNA526367	1325	515	33.497854	172.5139481	Helicobacter pylori	210	Bacteria	Bacteria	53.1	2.95e-6	NR	WP_316480680.1	210	g1184	i0	91.3	0.133980582524272	23	2	13.4	0	418	486	2	24	WP_316480680.1 hypothetical protein [Helicobacter pylori]	diamond	69	53.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28814006	28814006	PRJNA526367_P_NODE_47148_length_171_cov_4.483607_g46938_i0	PRJNA526367	47148	171	4.483607	7.66696797	Helicobacter pylori	210	Bacteria	Bacteria	40.4	0.0199	NR	GAA9090737.1	210	g46938	i0	56.4	0.684210526315789	39	15	64.9	1	168	58	39	77	GAA9090737.1 hypothetical protein Kyoto184A_08460 [Helicobacter pylori]	diamond	117	40.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28908704	28908704	PRJNA526367_P_NODE_37408_length_187_cov_6.210145_g37198_i0	PRJNA526367	37408	187	6.210145	11.61297115	Helicobacter pylori	210	Bacteria	Bacteria	48.1	1.24e-5	NR	GAA8760384.1	210	g37198	i0	48.8	3.9144385026738	41	21	65.8	0	128	6	9	49	GAA8760384.1 hypothetical protein Kyoto147A_3960 [Helicobacter pylori]	diamond	732	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28924080	28924080	PRJNA526367_P_NODE_55808_length_162_cov_7.265487_g55598_i0	PRJNA526367	55808	162	7.265487	11.77008894	Pseudomonadati	3379134	Bacteria	Bacteria	41.2	0.0311	NR	RJF56794.1	195	g55598	i0	43.2	1.57407407407407	44	25	81.5	0	151	20	27	70	RJF56794.1 hypothetical protein D4Z76_09165, partial [Campylobacter coli]	diamond	255	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29019273	29019273	PRJNA526367_P_NODE_5588_length_326_cov_3.007220_g5379_i0	PRJNA526367	5588	326	3.00722	9.8035372	root	1	Root_unresolved	Root_unresolved	49.3	1.62e-5	NR	GAA8871707.1	210	g5379	i0	64.5	1.08588957055215	31	11	28.5	0	6	98	1	31	GAA8871707.1 hypothetical protein Kyoto154A_3770 [Helicobacter pylori]	diamond	354	49.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29382686	29382686	PRJNA526367_P_NODE_35069_length_197_cov_4.101351_g34859_i0	PRJNA526367	35069	197	4.101351	8.07966147	Helicobacter pylori	210	Bacteria	Bacteria	45.8	1.73e-4	NR	GAA8685008.1	210	g34859	i0	43.6	0.83756345177665	55	31	83.8	0	196	32	4	58	GAA8685008.1 hypothetical protein Kyoto145A_1190 [Helicobacter pylori]	diamond	165	45.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29887972	29887972	PRJNA526367_P_NODE_30711_length_323_cov_2.441606_g30502_i0	PRJNA526367	30711	323	2.441606	7.88638738	Campylobacter fetus	196	Bacteria	Bacteria	48.1	2.06e-4	NR	WP_200451432.1	196	g30502	i0	86.2	0.269349845201238	29	4	26.9	0	94	8	56	84	WP_200451432.1 hypothetical protein [Campylobacter fetus]	diamond	87	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter fetus
30014290	30014290	PRJNA526367_P_NODE_36571_length_189_cov_3.664286_g36361_i0	PRJNA526367	36571	189	3.664286	6.92550054	Helicobacter pylori	210	Bacteria	Bacteria	42.7	0.00164	NR	GAA9176259.1	210	g36361	i0	83.3	1.52380952380952	18	3	28.6	0	104	51	33	50	GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori]	diamond	288	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30203500	30203500	PRJNA526367_P_NODE_43512_length_177_cov_2.367188_g43302_i0	PRJNA526367	43512	177	2.367188	4.18992276	Helicobacter pylori	210	Bacteria	Bacteria	41.2	0.00608	NR	GAA6907280.1	210	g43302	i0	76	0.932203389830508	25	6	42.4	0	2	76	19	43	GAA6907280.1 hypothetical protein Kyoto207A_2440 [Helicobacter pylori]	diamond	165	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30393802	30393802	PRJNA526367_P_NODE_6253_length_324_cov_7.480000_g6044_i0	PRJNA526367	6253	324	7.48	24.2352	Helicobacter pylori	210	Bacteria	Bacteria	52.4	1.2e-6	NR	WP_316480680.1	210	g6044	i0	88.9	0.472222222222222	27	3	25	0	227	307	2	28	WP_316480680.1 hypothetical protein [Helicobacter pylori]	diamond	153	52.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30692869	30692869	PRJNA526367_P_NODE_35813_length_190_cov_6.539007_g35603_i0	PRJNA526367	35813	190	6.539007	12.4241133	root	1	Root_unresolved	Root_unresolved	41.6	0.0466	NR	GAA6899356.1	210	g35603	i0	72	1.97368421052632	25	7	39.5	0	102	28	91	115	GAA6899356.1 hypothetical protein Kyoto207A_1070 [Helicobacter pylori]	diamond	375	41.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30772631	30772631	PRJNA526367_P_NODE_43734_length_176_cov_7.157480_g43524_i0	PRJNA526367	43734	176	7.15748	12.5971648	Helicobacter pylori	210	Bacteria	Bacteria	46.6	7.02e-5	NR	GAA6904105.1	210	g43524	i0	81	0.357954545454545	21	4	35.8	0	109	171	7	27	GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori]	diamond	63	46.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31246442	31246442	PRJNA526367_P_NODE_30215_length_323_cov_3.770073_g30006_i0	PRJNA526367	30215	323	3.770073	12.17733579	Helicobacter pylori	210	Bacteria	Bacteria	44.3	0.0107	NR	GAA8908272.1	210	g30006	i0	67.7	0.287925696594427	31	10	28.8	0	98	6	59	89	GAA8908272.1 hypothetical protein Kyoto166A_1320 [Helicobacter pylori]	diamond	93	44.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31246446	31246446	PRJNA526367_P_NODE_40955_length_181_cov_4.863636_g40745_i0	PRJNA526367	40955	181	4.863636	8.80318116	Campylobacter coli	195	Bacteria	Bacteria	58.2	1.54e-8	NR	RJF56794.1	195	g40745	i0	55.8	0.861878453038674	52	23	86.2	0	15	170	92	143	RJF56794.1 hypothetical protein D4Z76_09165, partial [Campylobacter coli]	diamond	156	58.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
31436153	31436153	PRJNA526367_P_NODE_27936_length_324_cov_1.763636_g27727_i0	PRJNA526367	27936	324	1.763636	5.71418064	Helicobacter pylori	210	Bacteria	Bacteria	52	2.88e-6	NR	GAA6884742.1	210	g27727	i0	75	0.296296296296296	32	8	29.6	0	3	98	19	50	GAA6884742.1 hypothetical protein Kyoto206A_4980 [Helicobacter pylori]	diamond	96	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31735980	31735980	PRJNA526367_P_NODE_3917_length_347_cov_4.100671_g3709_i0	PRJNA526367	3917	347	4.100671	14.22932837	root	1	Root_unresolved	Root_unresolved	44.3	0.023	NR	GAA6953203.1	210	g3709	i0	71	1.46974063400576	31	8	25.9	1	327	238	104	134	GAA6953203.1 hypothetical protein Kyoto211A_0270 [Helicobacter pylori]	diamond	510	44.7	0.991051454138702	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32290796	32290796	PRJNA526367_P_NODE_5219_length_328_cov_7.383513_g5010_i0	PRJNA526367	5219	328	7.383513	24.21792264	Helicobacter pylori	210	Bacteria	Bacteria	52.4	1.24e-6	NR	WP_316480680.1	210	g5010	i0	88.9	0.466463414634146	27	3	24.7	0	98	18	2	28	WP_316480680.1 hypothetical protein [Helicobacter pylori]	diamond	153	52.4	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);;