metadata: contig_metadata: 27 rows where bioproject = "PRJNA473824", tax_kingdom = "Pseudomonadati" and tax

27 rows where bioproject = "PRJNA473824", 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
4274157	4274157	PRJNA473824_P_NODE_63604_length_173_cov_4.441176_g62966_i0	PRJNA473824	63604	173	4.441176	7.68323448	Campylobacter showae	204	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|1483583503\|emb\|LT631427.1\|	204	g62966	i0	100	4.5202312138728296	76	0	87	0	1	76	16905	16980	Campylobacter showae genome assembly, plasmid: III	blastn	782	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
8749601	8749601	PRJNA473824_P_NODE_70287_length_173_cov_3.904412_g69649_i0	PRJNA473824	70287	173	3.904412	6.75463276	Campylobacter	194	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g69649	i0	100	14.4393063583815	76	0	88	0	98	173	51890	51965	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	2498	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
9375175	9375175	PRJNA473824_P_NODE_93928_length_173_cov_2.889706_g93290_i0	PRJNA473824	93928	173	2.889706	4.99919138	Campylobacter concisus	199	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g93290	i0	100	4.65895953757225	76	0	44	0	1	76	1783145	1783070	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	806	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10024772	10024772	PRJNA473824_P_NODE_37308_length_198_cov_1.142857_g36670_i0	PRJNA473824	37308	198	1.142857	2.26285686	Campylobacter	194	Bacteria	Bacteria	366	5.4e-97	NTclustered	gi\|1122816700\|gb\|KX096290.1\|	204	g36670	i0	100	107.484848484848	198	0	100	0	1	198	254	57	Campylobacter showae culture KCOM:2587 16S ribosomal RNA gene, partial sequence	blastn	21282	366	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11925061	11925061	PRJNA473824_P_NODE_14670_length_313_cov_3.920290_g14033_i0	PRJNA473824	14670	313	3.92029	12.2705077	Pseudomonadati	3379134	Bacteria	Bacteria	103	8.980000000000001e-27	NR	MCH3700035.1	195	g14033	i0	100	0.996805111821086	52	0	49.8	0	1	156	9	60	MCH3700035.1 DUF86 domain-containing protein [Campylobacter coli]	diamond	312	103	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
13849945	13849945	PRJNA473824_P_NODE_165171_length_150_cov_4.530973_g164533_i0	PRJNA473824	165171	150	4.530973	6.7964595	root	1	Root_unresolved	Root_unresolved	143	7.049999999999998e-30	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g164533	i0	100	116.286666666667	77	0	100	0	1	77	315908	315832	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	17443	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
16399339	16399339	PRJNA473824_P_NODE_98273_length_173_cov_2.808824_g97635_i0	PRJNA473824	98273	173	2.808824	4.85926552	Campylobacter	194	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|1483583497\|emb\|LT631421.1\|	204	g97635	i0	100	2.19653179190751	76	0	44	0	98	173	54477	54552	Campylobacter showae genome assembly, chromosome: I	blastn	380	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
21498292	21498292	PRJNA473824_P_NODE_31877_length_212_cov_0.840000_g31239_i0	PRJNA473824	31877	212	0.84	1.7808	Campylobacter	194	Bacteria	Bacteria	390	3.48e-104	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g31239	i0	100	227.88679245283	211	0	99	0	1	211	1032358	1032148	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	48312	390	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
26918042	26918042	PRJNA473824_P_NODE_129162_length_159_cov_1.393443_g128524_i0	PRJNA473824	129162	159	1.393443	2.21557437	Helicobacter pylori	210	Bacteria	Bacteria	39.3	0.0271	NR	GAA9188032.1	210	g128524	i0	57.1	0.660377358490566	35	11	66	1	111	7	4	34	GAA9188032.1 hypothetical protein Kyoto193A_3310 [Helicobacter pylori]	diamond	105	39.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27629619	27629619	PRJNA473824_P_NODE_168804_length_150_cov_3.424779_g168166_i0	PRJNA473824	168804	150	3.424779	5.1371685	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	3.47e-4	NR	MDN2892833.1	197	g168166	i0	91.7	2.4	24	2	48	0	148	77	34	57	MDN2892833.1 STAS domain-containing protein [Campylobacter jejuni]	diamond	360	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
27676720	27676720	PRJNA473824_P_NODE_148224_length_151_cov_3.921053_g147586_i0	PRJNA473824	148224	151	3.921053	5.92079003	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	55.1	4.68e-7	NR	WP_297941180.1	218934	g147586	i0	100	0.496688741721854	25	0	49.7	0	151	77	71	95	WP_297941180.1 YcjF family protein [uncultured Campylobacter sp.]	diamond	75	55.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
27897354	27897354	PRJNA473824_P_NODE_26685_length_229_cov_8.708333_g26047_i0	PRJNA473824	26685	229	8.708333	19.94208257	Helicobacter pylori	210	Bacteria	Bacteria	82.8	6.97e-19	NR	GAA6953502.1	210	g26047	i0	60.9	1.87336244541485	69	27	90.4	0	23	229	4	72	GAA6953502.1 hypothetical protein Kyoto211A_0700 [Helicobacter pylori]	diamond	429	82.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27945240	27945240	PRJNA473824_P_NODE_160845_length_151_cov_2.578947_g160207_i0	PRJNA473824	160845	151	2.578947	3.89420997	Bacteria	2	Bacteria	Bacteria	52.8	9.07e-7	NR	TNO74780.1	195	g160207	i0	100	11.9205298013245	25	0	49.7	0	77	151	61	85	TNO74780.1 ubiquinone-dependent pyruvate dehydrogenase, partial [Campylobacter coli]	diamond	1800	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29050410	29050410	PRJNA473824_P_NODE_136508_length_152_cov_1.208696_g135870_i0	PRJNA473824	136508	152	1.208696	1.83721792	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	1.29e-7	NR	WP_024953733.1	57666	g135870	i0	60	3.84868421052632	45	18	88.8	0	135	1	288	332	WP_024953733.1 [citrate (pro-3S)-lyase] ligase [Sulfurospirillum arcachonense]	diamond	585	56.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum arcachonense
29081949	29081949	PRJNA473824_P_NODE_126888_length_162_cov_1.248000_g126250_i0	PRJNA473824	126888	162	1.248	2.02176	Bacteria	2	Bacteria	Bacteria	50.4	9.67e-7	NR	GAA8950290.1	210	g126250	i0	72.4	2.01851851851852	29	8	53.7	0	71	157	1	29	GAA8950290.1 hypothetical protein Kyoto181A_1480 [Helicobacter pylori]	diamond	327	50.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29129099	29129099	PRJNA473824_P_NODE_16769_length_290_cov_1.233202_g16131_i0	PRJNA473824	16769	290	1.233202	3.5762858	Campylobacter coli	195	Bacteria	Bacteria	59.7	6.83e-8	NR	EAJ4656385.1	195	g16131	i0	38.8	2.02758620689655	98	50	99.3	3	290	3	171	260	EAJ4656385.1 hypothetical protein [Campylobacter coli]	diamond	588	59.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29475913	29475913	PRJNA473824_P_NODE_40850_length_190_cov_4.588235_g40212_i0	PRJNA473824	40850	190	4.588235	8.7176465	Helicobacter pylori	210	Bacteria	Bacteria	45.4	1.24e-4	NR	GAA9104010.1	210	g40212	i0	75	1.61052631578947	28	7	44.2	0	2	85	9	36	GAA9104010.1 hypothetical protein Kyoto184A_09450 [Helicobacter pylori]	diamond	306	45.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29823252	29823252	PRJNA473824_P_NODE_10631_length_384_cov_1.587896_g10004_i0	PRJNA473824	10631	384	1.587896	6.09752064	Campylobacter coli	195	Bacteria	Bacteria	52.8	1.37e-5	NR	EAJ3379138.1	195	g10004	i0	45.1	1.0625	51	28	39.8	0	2	154	104	154	EAJ3379138.1 hypothetical protein [Campylobacter coli]	diamond	408	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
29981452	29981452	PRJNA473824_P_NODE_139191_length_151_cov_6.114035_g138553_i0	PRJNA473824	139191	151	6.114035	9.23219285	Helicobacter pylori	210	Bacteria	Bacteria	40.4	0.00715	NR	GAA9221888.1	210	g138553	i0	43.2	0.735099337748344	37	21	73.5	0	5	115	1	37	GAA9221888.1 hypothetical protein Kyoto198A_3790 [Helicobacter pylori]	diamond	111	40.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29981489	29981489	PRJNA473824_P_NODE_96111_length_173_cov_2.838235_g95473_i0	PRJNA473824	96111	173	2.838235	4.91014655	Helicobacter pylori	210	Bacteria	Bacteria	47	4.45e-5	NR	GAA6835236.1	210	g95473	i0	76	1.26589595375723	25	6	43.4	0	173	99	4	28	GAA6835236.1 hypothetical protein Kyoto200A_4550 [Helicobacter pylori]	diamond	219	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30076108	30076108	PRJNA473824_P_NODE_127712_length_161_cov_1.258065_g127074_i0	PRJNA473824	127712	161	1.258065	2.02548465	Campylobacter lari	201	Bacteria	Bacteria	65.9	2.53e-12	NR	WP_369127326.1	201	g127074	i0	65.1	1.60248447204969	43	15	80.1	0	148	20	38	80	WP_369127326.1 endonuclease/exonuclease/phosphatase family protein, partial [Campylobacter lari]	diamond	258	65.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari
30266101	30266101	PRJNA473824_P_NODE_47372_length_179_cov_2.197183_g46734_i0	PRJNA473824	47372	179	2.197183	3.93295757	Helicobacter pylori	210	Bacteria	Bacteria	41.2	0.00593	NR	GAA6958420.1	210	g46734	i0	57.1	0.46927374301676	28	12	46.9	0	3	86	14	41	GAA6958420.1 hypothetical protein Kyoto211A_1950 [Helicobacter pylori]	diamond	84	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30518575	30518575	PRJNA473824_P_NODE_74573_length_173_cov_3.661765_g73935_i0	PRJNA473824	74573	173	3.661765	6.33485345	Helicobacter pylori	210	Bacteria	Bacteria	44.3	0.0039	NR	GAA6795622.1	210	g73935	i0	71.4	0.485549132947977	28	5	43.4	1	98	172	162	189	GAA6795622.1 hypothetical protein Kyoto200A_0460 [Helicobacter pylori]	diamond	84	44.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30755945	30755945	PRJNA473824_P_NODE_59454_length_173_cov_4.933824_g58816_i0	PRJNA473824	59454	173	4.933824	8.53551552	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	4.6e-4	NR	MCH3833944.1	197	g58816	i0	87.5	2.09826589595376	24	3	41.6	0	3	74	52	75	MCH3833944.1 hypothetical protein [Campylobacter jejuni]	diamond	363	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
30802897	30802897	PRJNA473824_P_NODE_19634_length_266_cov_5.982533_g18996_i0	PRJNA473824	19634	266	5.982533	15.91353778	Helicobacter pylori	210	Bacteria	Bacteria	42.4	0.0062	NR	GAA8979103.1	210	g18996	i0	80	0.43984962406015	20	4	22.6	0	122	181	1	20	GAA8979103.1 hypothetical protein Kyoto181A_5090 [Helicobacter pylori]	diamond	117	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30834506	30834506	PRJNA473824_P_NODE_132554_length_155_cov_0.991525_g131916_i0	PRJNA473824	132554	155	0.991525	1.53686375	Helicobacter pylori	210	Bacteria	Bacteria	43.1	7.81e-4	NR	GAA6962098.1	210	g131916	i0	43.2	2.65161290322581	44	25	85.2	0	137	6	6	49	GAA6962098.1 hypothetical protein Kyoto211A_2340 [Helicobacter pylori]	diamond	411	43.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32352782	32352782	PRJNA473824_P_NODE_171179_length_150_cov_3.000000_g170541_i0	PRJNA473824	171179	150	3	4.5	Wolinella succinogenes	844	Bacteria	Bacteria	55.8	2.41e-7	NR	WP_011139909.1	844	g170541	i0	100	2	25	0	50	0	148	74	11	35	WP_011139909.1 2-oxoacid:ferredoxin oxidoreductase subunit alpha [Wolinella succinogenes]	diamond	300	55.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Wolinella	Wolinella succinogenes

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);;