metadata: contig_metadata: 30 rows where bioproject = "PRJNA488043" and tax

30 rows where bioproject = "PRJNA488043" 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
450070	450070	PRJNA488043_P_NODE_7621_length_434_cov_2.123457_g5459_i0	PRJNA488043	7621	434	2.123457	9.21580338	Campylobacterota bacterium	2026809	Bacteria	Bacteria	196	4.65e-60	NR	MDQ1245098.1	2026809	g5459	i0	100	0.67741935483871	98	0	67.7	0	294	1	1	98	MDQ1245098.1 3(or 17)beta-hydroxysteroid dehydrogenase [Campylobacterota bacterium]	diamond	294	196	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
3649059	3649059	PRJNA488043_P_NODE_22363_length_151_cov_3.852459_g20121_i0	PRJNA488043	22363	151	3.852459	5.81721309	Campylobacter	194	Bacteria	Bacteria	209	6.91e-50	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g20121	i0	91.358	269.788079470199	162	1	99	1	3	151	571	732	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	40738	209	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
4926190	4926190	PRJNA488043_S_NODE_384_length_296_cov_4.655431_g373_i0	PRJNA488043	384	296	4.655431	13.78007576	Sulfurimonadaceae	2771471	Bacteria	Bacteria	122	2.07e-23	NTclustered	gi\|2159817265\|gb\|CP087998.1\|	2894755	g373	i0	79.348	32.2331081081081	184	31	60	6	18	196	1884696	1884515	Sulfurimonas sp. HSL-3221 chromosome, complete genome	blastn	9541	122	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo sulfuroxydans
6200988	6200988	PRJNA488043_P_NODE_11965_length_283_cov_4.814961_g9724_i0	PRJNA488043	11965	283	4.814961	13.62633963	Campylobacter	194	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g9724	i0	100	235.265017667845	283	0	100	0	1	283	1113952	1113670	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	66580	523	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10653443	10653443	PRJNA488043_P_NODE_10909_length_311_cov_4.492908_g8668_i0	PRJNA488043	10909	311	4.492908	13.97294388	Campylobacter showae	204	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g8668	i0	100	235.263665594855	311	0	100	0	1	311	389474	389784	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	73167	575	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
11301165	11301165	PRJNA488043_P_NODE_19629_length_175_cov_3.602740_g17387_i0	PRJNA488043	19629	175	3.60274	6.304795	Campylobacter	194	Bacteria	Bacteria	315	1.7000000000000002e-81	NTclustered	gi\|1938730527\|gb\|CP049274.1\|	199	g17387	i0	99.422	245.011428571429	173	1	99	0	3	175	1135849	1135677	Campylobacter concisus strain P10CDO-S2 chromosome, complete genome	blastn	42877	315	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12576794	12576794	PRJNA488043_P_NODE_10910_length_311_cov_4.432624_g8669_i0	PRJNA488043	10910	311	4.432624	13.78546064	Campylobacter	194	Bacteria	Bacteria	569	6.489999999999998e-158	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g8669	i0	99.678	235.845659163987	311	1	100	0	1	311	1113670	1113980	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	73348	569	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12577025	12577025	PRJNA488043_P_NODE_8930_length_376_cov_4.092219_g6710_i0	PRJNA488043	8930	376	4.092219	15.38674344	Campylobacter	194	Bacteria	Bacteria	608	1.689999999999999e-169	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g6710	i0	94.778	226.311170212766	383	13	100	1	1	376	1113670	1114052	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	85093	608	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20851665	20851665	PRJNA488043_S_NODE_1357_length_165_cov_9.551471_g1346_i0	PRJNA488043	1357	165	9.551471	15.75992715	Campylobacter hepaticus	1813019	Bacteria	Bacteria	100	4.86e-17	NTclustered	gi\|1940031893\|gb\|CP065357.1\|	1813019	g1346	i0	85.714	152.048484848485	98	11	59	3	1	97	21396	21491	Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome	blastn	25088	100	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hepaticus
26855074	26855074	PRJNA488043_P_NODE_21101_length_161_cov_4.000000_g18859_i0	PRJNA488043	21101	161	4	6.44	Helicobacter pylori	210	Bacteria	Bacteria	42.4	0.0028	NR	GAA9243766.1	210	g18859	i0	72	0.46583850931677	25	7	46.6	0	81	155	2	26	GAA9243766.1 hypothetical protein Kyoto198A_5880 [Helicobacter pylori]	diamond	75	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26997310	26997310	PRJNA488043_P_NODE_19882_length_173_cov_1.715278_g17640_i0	PRJNA488043	19882	173	1.715278	2.96743094	Pseudomonadati	3379134	Bacteria	Bacteria	115	1.12e-31	NR	MCH3755945.1	195	g17640	i0	100	2.96531791907514	57	0	98.8	0	1	171	16	72	MCH3755945.1 CYTH domain-containing protein [Campylobacter coli]	diamond	513	115	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
27392543	27392543	PRJNA488043_P_NODE_16623_length_206_cov_181.581921_g14381_i0	PRJNA488043	16623	206	181.581921	374.05875726	Helicobacter pylori	210	Bacteria	Bacteria	40.8	0.0204	NR	GAA6820949.1	210	g14381	i0	56.4	0.567961165048544	39	12	49.5	1	68	169	2	40	GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori]	diamond	117	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27424214	27424214	PRJNA488043_P_NODE_19683_length_175_cov_1.931507_g17441_i0	PRJNA488043	19683	175	1.931507	3.38013725	Campylobacterota bacterium	2026809	Bacteria	Bacteria	118	4e-29	NR	MDQ1245100.1	2026809	g17441	i0	98.2	0.977142857142857	57	1	97.7	0	3	173	543	599	MDQ1245100.1 hypothetical protein [Campylobacterota bacterium]	diamond	171	118	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
27550157	27550157	PRJNA488043_P_NODE_15564_length_219_cov_213.936842_g13322_i0	PRJNA488043	15564	219	213.936842	468.52168398	Helicobacter pylori	210	Bacteria	Bacteria	70.5	2.7e-14	NR	GAA9176259.1	210	g13322	i0	68.2	0.602739726027397	44	13	58.9	1	219	91	6	49	GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori]	diamond	132	70.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28150335	28150335	PRJNA488043_P_NODE_16725_length_205_cov_75.028409_g14483_i0	PRJNA488043	16725	205	75.028409	153.80823845	Helicobacter pylori	210	Bacteria	Bacteria	46.2	1.9e-4	NR	GAA9030935.1	210	g14483	i0	100	0.278048780487805	19	0	27.8	0	186	130	1	19	GAA9030935.1 hypothetical protein Kyoto181A_8700 [Helicobacter pylori]	diamond	57	46.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28276342	28276342	PRJNA488043_P_NODE_3626_length_753_cov_2.671271_g1993_i1	PRJNA488043	3626	753	2.671271	20.11467063	Helicobacter pylori	210	Bacteria	Bacteria	156	2.62e-45	NR	WP_316479292.1	210	g1993	i1	97.4	0.310756972111554	78	2	31.1	0	700	467	1	78	WP_316479292.1 hypothetical protein, partial [Helicobacter pylori]	diamond	234	156	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28623990	28623990	PRJNA488043_P_NODE_13967_length_243_cov_369.757009_g11725_i0	PRJNA488043	13967	243	369.757009	898.50953187	Helicobacter pylori	210	Bacteria	Bacteria	88.6	3.34e-21	NR	GAA6899098.1	210	g11725	i0	93.5	0.765432098765432	62	4	76.5	0	242	57	1	62	GAA6899098.1 hypothetical protein Kyoto207A_0760 [Helicobacter pylori]	diamond	186	88.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28655443	28655443	PRJNA488043_P_NODE_10907_length_311_cov_5.053191_g8666_i0	PRJNA488043	10907	311	5.053191	15.71542401	Helicobacter pylori	210	Bacteria	Bacteria	48.1	4.63e-5	NR	GAA8766134.1	210	g8666	i0	95.2	0.202572347266881	21	1	20.3	0	168	106	1	21	GAA8766134.1 hypothetical protein Kyoto147A_4290 [Helicobacter pylori]	diamond	63	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28718587	28718587	PRJNA488043_P_NODE_12387_length_275_cov_1.430894_g10146_i0	PRJNA488043	12387	275	1.430894	3.9349585	Campylobacterota bacterium	2026809	Bacteria	Bacteria	104	5.09e-25	NR	MDQ1245098.1	2026809	g10146	i0	100	0.534545454545455	49	0	53.5	0	1	147	192	240	MDQ1245098.1 3(or 17)beta-hydroxysteroid dehydrogenase [Campylobacterota bacterium]	diamond	147	104	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
28750115	28750115	PRJNA488043_P_NODE_15387_length_222_cov_2.207254_g13145_i0	PRJNA488043	15387	222	2.207254	4.90010388	Desulfurellales bacterium	2482794	Bacteria	Bacteria	44.7	0.00312	NR	TXH42837.1	2482794	g13145	i0	51.3	0.527027027027027	39	18	52.7	1	99	215	1	38	TXH42837.1 MAG: hypothetical protein E6Q97_35100 [Desulfurellales bacterium]	diamond	117	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
29129216	29129216	PRJNA488043_P_NODE_7149_length_457_cov_2.343458_g5019_i0	PRJNA488043	7149	457	2.343458	10.70960306	Helicobacter pylori	210	Bacteria	Bacteria	70.5	5.4e-13	NR	WP_316458330.1	210	g5019	i0	77.6	0.38074398249453	58	1	38.1	1	407	234	1	46	WP_316458330.1 hypothetical protein, partial [Helicobacter pylori]	diamond	174	70.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29665373	29665373	PRJNA488043_P_NODE_9710_length_350_cov_1.897196_g7474_i0	PRJNA488043	9710	350	1.897196	6.640186	Desulfurellales bacterium	2482794	Bacteria	Bacteria	83.2	2e-16	NR	TXH55603.1	2482794	g7474	i0	64.1	0.548571428571429	64	22	54.9	1	2	193	136	198	TXH55603.1 MAG: hypothetical protein E6Q97_08520 [Desulfurellales bacterium]	diamond	192	83.2	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
29760302	29760302	PRJNA488043_P_NODE_1051_length_1724_cov_2.938053_g375_i0	PRJNA488043	1051	1724	2.938053	50.65203372	Helicobacter pylori	210	Bacteria	Bacteria	155	6.39e-42	NR	WP_316479312.1	210	g375	i0	97.3	0.12877030162413	74	2	12.9	0	989	1210	1	74	WP_316479312.1 hypothetical protein, partial [Helicobacter pylori]	diamond	222	155	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29949993	29949993	PRJNA488043_P_NODE_20731_length_164_cov_23.066667_g18489_i0	PRJNA488043	20731	164	23.066667	37.82933388	Helicobacter pylori	210	Bacteria	Bacteria	39.7	0.0245	NR	GAA8930966.1	210	g18489	i0	66.7	0.439024390243902	24	8	43.9	0	19	90	8	31	GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori]	diamond	72	39.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30044619	30044619	PRJNA488043_P_NODE_3611_length_756_cov_2.570839_g1993_i0	PRJNA488043	3611	756	2.570839	19.43554284	Helicobacter pylori	210	Bacteria	Bacteria	126	1.55e-33	NR	WP_316479292.1	210	g1993	i0	83.3	0.30952380952381	78	6	28.2	1	679	467	1	78	WP_316479292.1 hypothetical protein, partial [Helicobacter pylori]	diamond	234	126	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30202498	30202498	PRJNA488043_P_NODE_8772_length_382_cov_1.796034_g6554_i0	PRJNA488043	8772	382	1.796034	6.86084988	Campylobacterota bacterium	2026809	Bacteria	Bacteria	149	6.21e-39	NR	MDQ1245100.1	2026809	g6554	i0	100	0.596858638743455	76	0	59.7	0	382	155	230	305	MDQ1245100.1 hypothetical protein [Campylobacterota bacterium]	diamond	228	149	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
30392737	30392737	PRJNA488043_P_NODE_16053_length_213_cov_2.755435_g13811_i0	PRJNA488043	16053	213	2.755435	5.86907655	Desulfurellales bacterium	2482794	Bacteria	Bacteria	114	4.08e-31	NR	TXH46803.1	2482794	g13811	i0	91.7	0.845070422535211	60	5	84.5	0	34	213	1	60	TXH46803.1 MAG: hypothetical protein E6Q97_28645 [Desulfurellales bacterium]	diamond	180	114	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
31466973	31466973	PRJNA488043_P_NODE_11176_length_303_cov_5.124088_g8935_i0	PRJNA488043	11176	303	5.124088	15.52598664	Helicobacter pylori	210	Bacteria	Bacteria	47	1.2e-4	NR	GAA8766134.1	210	g8935	i0	95	0.198019801980198	20	1	19.8	0	161	220	1	20	GAA8766134.1 hypothetical protein Kyoto147A_4290 [Helicobacter pylori]	diamond	60	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31719833	31719833	PRJNA488043_P_NODE_13277_length_256_cov_1.506608_g11035_i0	PRJNA488043	13277	256	1.506608	3.85691648	Campylobacterota bacterium	2026809	Bacteria	Bacteria	100	1.5100000000000001e-22	NR	MDQ1245100.1	2026809	g11035	i0	100	0.59765625	51	0	59.8	0	102	254	1	51	MDQ1245100.1 hypothetical protein [Campylobacterota bacterium]	diamond	153	100	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
32321291	32321291	PRJNA488043_P_NODE_16759_length_205_cov_2.318182_g14517_i0	PRJNA488043	16759	205	2.318182	4.7522731	Desulfurellales bacterium	2482794	Bacteria	Bacteria	44.7	0.00259	NR	TXH42837.1	2482794	g14517	i0	51.3	0.570731707317073	39	18	57.1	1	82	198	1	38	TXH42837.1 MAG: hypothetical protein E6Q97_35100 [Desulfurellales bacterium]	diamond	117	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium

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