metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA682078" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA682078" 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
5767197	5767197	PRJNA682078_P_NODE_76945_length_395_cov_1.195652_g75170_i0	PRJNA682078	76945	395	1.195652	4.7228254	Helicobacter	209	Bacteria	Bacteria	246	3.46e-78	NR	WP_115550794.1	209	g75170	i0	100	0.911392405063291	120	0	91.1	0	394	35	271	390	WP_115550794.1 MULTISPECIES: pyridoxal phosphate-dependent aminotransferase [Helicobacter]	diamond	360	246	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
17238709	17238709	PRJNA682078_P_NODE_226314_length_251_cov_0.865169_g224537_i0	PRJNA682078	226314	251	0.865169	2.17157419	Helicobacter ganmani	60246	Bacteria	Bacteria	149	6.0999999999999996e-43	NR	WP_415576671.1	60246	g224537	i0	100	1.94820717131474	81	0	96.8	0	244	2	1	81	WP_415576671.1 methyl-accepting chemotaxis protein [Helicobacter ganmani]	diamond	489	149	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
23614443	23614443	PRJNA682078_P_NODE_261939_length_245_cov_0.895349_g260162_i0	PRJNA682078	261939	245	0.895349	2.19360505	Helicobacter	209	Bacteria	Bacteria	152	1.5499999999999998e-42	NR	WP_115551193.1	209	g260162	i0	100	1.98367346938776	81	0	99.2	0	245	3	209	289	WP_115551193.1 MULTISPECIES: phosphoglycerate kinase [Helicobacter]	diamond	486	152	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
25399925	25399925	PRJNA682078_P_NODE_284980_length_242_cov_0.911243_g283203_i0	PRJNA682078	284980	242	0.911243	2.20520806	Helicobacter ganmani	60246	Bacteria	Bacteria	154	1.32e-45	NR	WP_220271601.1	60246	g283203	i0	98.7	0.979338842975207	79	1	97.9	0	239	3	94	172	WP_220271601.1 purine-nucleoside phosphorylase [Helicobacter ganmani]	diamond	237	154	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
26745263	26745263	PRJNA682078_P_NODE_271001_length_244_cov_0.900585_g269224_i0	PRJNA682078	271001	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	146	5.22e-41	NR	WP_107687402.1	199	g269224	i0	78.8	15.7377049180328	80	17	98.4	0	3	242	37	116	WP_107687402.1 NAD-dependent epimerase/dehydratase family protein [Campylobacter concisus]	diamond	3840	146	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
26955313	26955313	PRJNA682078_P_NODE_111422_length_336_cov_1.171103_g109645_i0	PRJNA682078	111422	336	1.171103	3.93490608	Helicobacter ganmani	60246	Bacteria	Bacteria	215	9.54e-69	NR	WP_416862483.1	60246	g109645	i0	100	1	112	0	100	0	336	1	26	137	WP_416862483.1 putative sulfate exporter family transporter [Helicobacter ganmani]	diamond	336	215	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
27093716	27093716	PRJNA682078_P_NODE_268722_length_244_cov_0.900585_g266945_i0	PRJNA682078	268722	244	0.900585	2.1974274	Helicobacter	209	Bacteria	Bacteria	169	8.99e-50	NR	WP_115552169.1	209	g266945	i0	100	1.99180327868852	81	0	99.6	0	2	244	32	112	WP_115552169.1 MULTISPECIES: tRNA (adenosine(37)-N6)-dimethylallyltransferase MiaA [Helicobacter]	diamond	486	169	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
27410064	27410064	PRJNA682078_P_NODE_271143_length_244_cov_0.900585_g269366_i0	PRJNA682078	271143	244	0.900585	2.1974274	Helicobacter	209	Bacteria	Bacteria	164	1.0499999999999999e-47	NR	WP_181881635.1	209	g269366	i0	98.8	3.98360655737705	81	1	99.6	0	1	243	168	248	WP_181881635.1 MULTISPECIES: tRNA lysidine(34) synthetase TilS [Helicobacter]	diamond	972	164	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
27524439	27524439	PRJNA682078_P_NODE_229763_length_250_cov_0.870056_g227986_i0	PRJNA682078	229763	250	0.870056	2.17514	Helicobacter ganmani	60246	Bacteria	Bacteria	118	1.0799999999999999e-32	NR	WP_416826214.1	60246	g227986	i0	98.5	1.56	65	1	78	0	56	250	1	65	WP_416826214.1 hypothetical protein, partial [Helicobacter ganmani]	diamond	390	118	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
28345354	28345354	PRJNA682078_P_NODE_261966_length_245_cov_0.895349_g260189_i0	PRJNA682078	261966	245	0.895349	2.19360505	Helicobacter sp.	218	Bacteria	Bacteria	151	5.79e-42	NR	WP_297680074.1	218	g260189	i0	95.1	0.991836734693878	81	4	99.2	0	3	245	27	107	WP_297680074.1 histidinol dehydrogenase [Helicobacter sp.]	diamond	243	151	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
28388568	28388568	PRJNA682078_P_NODE_231066_length_250_cov_0.870056_g229289_i0	PRJNA682078	231066	250	0.870056	2.17514	Helicobacter	209	Bacteria	Bacteria	166	7.48e-47	NR	WP_245944176.1	209	g229289	i0	100	2.952	82	0	98.4	0	248	3	29	110	WP_245944176.1 MULTISPECIES: single-stranded-DNA-specific exonuclease RecJ [Helicobacter]	diamond	738	166	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
28661206	28661206	PRJNA682078_P_NODE_278527_length_243_cov_0.905882_g276750_i0	PRJNA682078	278527	243	0.905882	2.20129326	Desulfurellales bacterium	2482794	Bacteria	Bacteria	42.7	0.0361	NR	TXH49280.1	2482794	g276750	i0	53.4	0.716049382716049	58	22	71.6	3	188	15	25	77	TXH49280.1 MAG: DUF1996 domain-containing protein [Desulfurellales bacterium]	diamond	174	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
28798892	28798892	PRJNA682078_P_NODE_277147_length_243_cov_0.905882_g275370_i0	PRJNA682078	277147	243	0.905882	2.20129326	Helicobacter	209	Bacteria	Bacteria	85.1	6.15e-18	NR	WP_115551485.1	209	g275370	i0	100	1.82716049382716	37	0	45.7	0	111	1	1	37	WP_115551485.1 MULTISPECIES: tRNA1(Val) (adenine(37)-N6)-methyltransferase [Helicobacter]	diamond	444	85.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
28882026	28882026	PRJNA682078_P_NODE_238348_length_249_cov_0.875000_g236571_i0	PRJNA682078	238348	249	0.875	2.17875	Helicobacter sp. UBA34	218	Bacteria	Bacteria	158	1.4e-43	NR	WP_300842678.1	1946588	g236571	i0	100	1.97590361445783	82	0	98.8	0	2	247	358	439	WP_300842678.1 methyl-accepting chemotaxis protein, partial [Helicobacter sp. UBA3407]	diamond	492	158	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. UBA3407
29671115	29671115	PRJNA682078_P_NODE_230330_length_250_cov_0.870056_g228553_i0	PRJNA682078	230330	250	0.870056	2.17514	Helicobacter	209	Bacteria	Bacteria	89.7	9.1e-19	NR	WP_115551919.1	209	g228553	i0	100	0.528	44	0	52.8	0	119	250	1	44	WP_115551919.1 MULTISPECIES: glutamyl-tRNA reductase [Helicobacter]	diamond	132	89.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
29860922	29860922	PRJNA682078_P_NODE_229651_length_250_cov_0.870056_g227874_i0	PRJNA682078	229651	250	0.870056	2.17514	uncultured Helicobacter sp.	175537	Bacteria	Bacteria	157	8.349999999999999e-47	NR	WP_298495725.1	175537	g227874	i0	100	1.968	82	0	98.4	0	248	3	57	138	WP_298495725.1 MotA/TolQ/ExbB proton channel family protein [uncultured Helicobacter sp.]	diamond	492	157	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	uncultured Helicobacter sp.
30555790	30555790	PRJNA682078_P_NODE_176533_length_277_cov_1.093137_g174756_i0	PRJNA682078	176533	277	1.093137	3.02798949	Helicobacter ganmani	60246	Bacteria	Bacteria	47	0.00171	NR	WP_416827584.1	60246	g174756	i0	100	0.216606498194946	20	0	21.7	0	216	275	1	20	WP_416827584.1 4Fe-4S binding protein [Helicobacter ganmani]	diamond	60	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
30978611	30978611	PRJNA682078_P_NODE_240534_length_248_cov_1.657143_g238757_i0	PRJNA682078	240534	248	1.657143	4.10971464	Pseudomonadati	3379134	Bacteria	Bacteria	116	5.849999999999999e-32	NR	MCH3859669.1	197	g238757	i0	95	1.45161290322581	60	3	72.6	0	2	181	25	84	MCH3859669.1 IS66 family transposase [Campylobacter jejuni]	diamond	360	117	0.991452991452991	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
31737132	31737132	PRJNA682078_P_NODE_236577_length_249_cov_0.875000_g234800_i0	PRJNA682078	236577	249	0.875	2.17875	Helicobacter	209	Bacteria	Bacteria	167	5.17e-49	NR	WP_300792738.1	209	g234800	i0	100	4	83	0	100	0	249	1	125	207	WP_300792738.1 MULTISPECIES: SH3 domain-containing protein, partial [Helicobacter]	diamond	996	167	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
31958681	31958681	PRJNA682078_P_NODE_299317_length_197_cov_2.693548_g297540_i0	PRJNA682078	299317	197	2.693548	5.30628956	Bacteria	2	Bacteria	Bacteria	52.4	5.48e-7	NR	GAA6795273.1	210	g297540	i0	88	0.746192893401015	25	3	38.1	0	184	110	1	25	GAA6795273.1 hypothetical protein Kyoto200A_0230 [Helicobacter pylori]	diamond	147	52.8	0.992424242424242	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32073598	32073598	PRJNA682078_P_NODE_174818_length_278_cov_1.097561_g173041_i0	PRJNA682078	174818	278	1.097561	3.05121958	Sulfurimonas sp. ST-25	3400151	Bacteria	Bacteria	100	1.04e-22	NR	WP_416768484.1	3400151	g173041	i0	70.6	1.46762589928058	68	20	73.4	0	204	1	4	71	WP_416768484.1 DNA cytosine methyltransferase [Sulfurimonas sp. ST-25]	diamond	408	100	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp. ST-25
32232022	32232022	PRJNA682078_P_NODE_107698_length_341_cov_0.847015_g105921_i0	PRJNA682078	107698	341	0.847015	2.88832115	Helicobacter sp. UBA34	218	Bacteria	Bacteria	214	6.48e-70	NR	WP_300842680.1	1946588	g105921	i0	99.1	0.994134897360704	113	1	99.4	0	1	339	1	113	WP_300842680.1 acetate uptake transporter, partial [Helicobacter sp. UBA3407]	diamond	339	214	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. UBA3407
32560207	32560207	PRJNA682078_P_NODE_289799_length_241_cov_0.916667_g288022_i0	PRJNA682078	289799	241	0.916667	2.20916747	Helicobacter	209	Bacteria	Bacteria	156	1.98e-43	NR	WP_115550751.1	209	g288022	i0	100	5.97510373443983	80	0	99.6	0	1	240	238	317	WP_115550751.1 MULTISPECIES: hypothetical protein [Helicobacter]	diamond	1440	156	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
32611263	32611263	PRJNA682078_P_NODE_177800_length_276_cov_1.325123_g176023_i0	PRJNA682078	177800	276	1.325123	3.65733948	Helicobacter pylori	210	Bacteria	Bacteria	81.3	2.74e-17	NR	GAA8948581.1	210	g176023	i0	100	0.608695652173913	56	0	60.9	0	257	90	1	56	GAA8948581.1 hypothetical protein Kyoto181A_0320 [Helicobacter pylori]	diamond	168	81.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32642528	32642528	PRJNA682078_P_NODE_71440_length_409_cov_1.145833_g69665_i0	PRJNA682078	71440	409	1.145833	4.68645697	Helicobacter ganmani	60246	Bacteria	Bacteria	227	3.85e-72	NR	WP_416824910.1	60246	g69665	i0	99.1	2.53056234718826	115	1	84.4	0	347	3	1	115	WP_416824910.1 magnesium chelatase domain-containing protein, partial [Helicobacter ganmani]	diamond	1035	227	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
32843197	32843197	PRJNA682078_P_NODE_134420_length_310_cov_0.818565_g132643_i0	PRJNA682078	134420	310	0.818565	2.5375515	Helicobacter	209	Bacteria	Bacteria	122	9.66e-33	NR	WP_416830029.1	60246	g132643	i0	98.3	1.74193548387097	60	1	58.1	0	308	129	111	170	WP_416830029.1 M99 family metallo-carboxypeptidase C-terminal domain-containing protein, partial [Helicobacter ganmani]	diamond	540	122	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter ganmani
32894525	32894525	PRJNA682078_P_NODE_262620_length_245_cov_0.895349_g260843_i0	PRJNA682078	262620	245	0.895349	2.19360505	Helicobacter	209	Bacteria	Bacteria	126	1.45e-32	NR	WP_115550816.1	209	g260843	i0	100	0.991836734693878	81	0	99.2	0	1	243	286	366	WP_115550816.1 MULTISPECIES: ABC transporter permease [Helicobacter]	diamond	243	126	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter

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