metadata: contig_metadata: 30 rows where bioproject = "PRJNA816047", tax_kingdom = "Pseudomonadati" and tax

30 rows where bioproject = "PRJNA816047", 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
25595958	25595958	PRJNA816047a_S_NODE_74113_length_248_cov_1.805714_g71453_i0	PRJNA816047	74113	248	1.805714	4.47817072	Campylobacter jejuni	197	Bacteria	Bacteria	134	2.3e-39	NR	MBP0443134.1	197	g71453	i0	98.6	0.870967741935484	72	1	87.1	0	227	12	1	72	MBP0443134.1 hypothetical protein [Campylobacter jejuni]	diamond	216	134	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25601768	25601768	PRJNA816047d_S_NODE_136361_length_225_cov_1313.994186_g134526_i0	PRJNA816047	136361	225	1313.994186	2956.4869185	Campylobacterota bacterium	2026809	Bacteria	Bacteria	75	4.27e-9	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g134526	i0	93.878	192.982222222222	49	3	22	0	169	217	76	28	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	43421	75	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25603323	25603323	PRJNA816047d_S_NODE_28521_length_399_cov_2.485549_g26689_i0	PRJNA816047	28521	399	2.485549	9.91734051	Campylobacter jejuni	197	Bacteria	Bacteria	320	9.49e-83	NTclustered	gi\|1246382771\|gb\|CP023446.1\|	197	g26689	i0	81.491	40.9949874686717	389	72	97	0	10	398	1713125	1713513	Campylobacter jejuni strain 100 chromosome	blastn	16357	320	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25604870	25604870	PRJNA816047d_S_NODE_54761_length_301_cov_466.471774_g52926_i0	PRJNA816047	54761	301	466.471774	1404.08003974	Campylobacterota bacterium	2026809	Bacteria	Bacteria	78.7	4.62e-10	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g52926	i0	97.826	141.405315614618	46	0	15	1	15	59	33	78	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	42563	78.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25728595	25728595	PRJNA816047a_S_NODE_31850_length_365_cov_20967.253425_g29190_i0	PRJNA816047	31850	365	20967.253425	76530.47500125	Desulfurellales bacterium	2482794	Bacteria	Bacteria	159	2.81e-47	NR	TXH58056.1	2482794	g29190	i0	71.9	1.69315068493151	114	30	92.1	1	21	356	1	114	TXH58056.1 MAG: hypothetical protein E6Q97_03180 [Desulfurellales bacterium]	diamond	618	159	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
25729908	25729908	PRJNA816047a_S_NODE_46874_length_305_cov_85.211207_g44214_i0	PRJNA816047	46874	305	85.211207	259.89418135	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g44214	i0	100	0.0918032786885246	28	0	9	0	179	206	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
25734756	25734756	PRJNA816047b_S_NODE_31946_length_295_cov_68.058559_g29634_i0	PRJNA816047	31946	295	68.058559	200.77274905	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g29634	i0	100	0.0949152542372881	28	0	9	0	160	187	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
25737861	25737861	PRJNA816047d_S_NODE_132386_length_228_cov_37161.691429_g130551_i0	PRJNA816047	132386	228	37161.691429	84728.65645812	Campylobacterota bacterium	2026809	Bacteria	Bacteria	78.7	3.35e-10	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g130551	i0	97.778	178.245614035088	45	1	20	0	164	208	81	37	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	40640	78.7	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
25738076	25738076	PRJNA816047d_S_NODE_141082_length_221_cov_128.113095_g139247_i0	PRJNA816047	141082	221	128.113095	283.12993995	Campylobacter jejuni	197	Bacteria	Bacteria	62.1	3.25e-5	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g139247	i0	97.222	0.16289592760181	36	1	16	0	30	65	640662	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	36	62.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25770050	25770050	PRJNA816047b_S_NODE_21354_length_350_cov_3.129964_g19042_i0	PRJNA816047	21354	350	3.129964	10.954874	root	1	Root_unresolved	Root_unresolved	54.7	0.009	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g19042	i0	100	0.408571428571429	29	0	8	0	15	43	685143	685171	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	143	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
25906896	25906896	PRJNA816047b_S_NODE_51171_length_245_cov_0.895349_g48859_i0	PRJNA816047	51171	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	67.6	7.9e-7	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g48859	i0	100	15.2857142857143	36	0	15	0	65	100	685148	685183	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	3745	67.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26004738	26004738	PRJNA816047a_S_NODE_82132_length_235_cov_2.549383_g79472_i0	PRJNA816047	82132	235	2.549383	5.99105005	Caminibacter pacificus	1424653	Bacteria	Bacteria	75	4.49e-9	NTclustered	gi\|1690432421\|gb\|CP027432.2\|	1424653	g79472	i0	90.909	1.49787234042553	55	5	23	0	76	130	129347	129293	Caminibacter pacificus strain TB6 chromosome, complete genome	blastn	352	75	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nautiliaceae	Caminibacter	Caminibacter pacificus
26012167	26012167	PRJNA816047d_S_NODE_36660_length_354_cov_11.714286_g34825_i0	PRJNA816047	36660	354	11.714286	41.46857244	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g34825	i0	100	0.0790960451977401	28	0	8	0	105	132	1771318	1771291	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
26044866	26044866	PRJNA816047d_S_NODE_94908_length_253_cov_1.575000_g93073_i0	PRJNA816047	94908	253	1.575	3.98475	Aliarcobacter	2321111	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1704610973\|gb\|CP041386.1\|	28197	g93073	i0	100	58.3320158102767	253	0	100	0	1	253	749196	748944	Aliarcobacter butzleri strain ED-1 chromosome, complete genome	blastn	14758	468	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
26150521	26150521	PRJNA816047d_S_NODE_76245_length_265_cov_2.358491_g74410_i0	PRJNA816047	76245	265	2.358491	6.25000115	Halarcobacter bivalviorum	663364	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1435902972\|gb\|CP031217.1\|	663364	g74410	i0	92.308	0.147169811320755	39	1	14	2	182	219	258091	258054	Halarcobacter bivalviorum strain LMG 26154 chromosome, complete genome	blastn	39	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter bivalviorum
26180897	26180897	PRJNA816047d_S_NODE_84077_length_260_cov_0.937198_g82242_i0	PRJNA816047	84077	260	0.937198	2.4367148	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	1.09e-5	NTclustered	gi\|2166246099\|dbj\|LC663122.1\|	2026809	g82242	i0	91.489	33.8538461538462	47	3	18	1	211	256	8274	8320	Epsilonproteobacteria bacterium ARSSAG-00002389 DNA, putative prophage region, clone: 00002389_pp1	blastn	8802	63.9	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
26280102	26280102	PRJNA816047b_S_NODE_46342_length_253_cov_1.511111_g44030_i0	PRJNA816047	46342	253	1.511111	3.82311083	Campylobacter jejuni	197	Bacteria	Bacteria	115	8.26e-28	NR	EOH1988368.1	197	g44030	i0	96.4	0.66403162055336	56	2	66.4	0	47	214	590	645	EOH1988368.1 phage tail protein [Campylobacter jejuni]	diamond	168	115	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
26282071	26282071	PRJNA816047d_S_NODE_130830_length_230_cov_100.192090_g128995_i0	PRJNA816047	130830	230	100.19209	230.441807	Campylobacter jejuni	197	Bacteria	Bacteria	58.4	4.41e-4	NTclustered	gi\|1098450108\|gb\|CP017863.1\|	197	g128995	i0	97.059	0.147826086956522	34	1	15	0	32	65	640660	640627	Campylobacter jejuni strain IF1100, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
26420280	26420280	PRJNA816047d_S_NODE_37711_length_350_cov_2.272727_g35876_i0	PRJNA816047	37711	350	2.272727	7.9545445	Pseudomonadati	3379134	Bacteria	Bacteria	133	2.8e-38	NR	MCH3765105.1	195	g35876	i0	97.1	1.16571428571429	68	2	58.3	0	145	348	1	68	MCH3765105.1 hypothetical protein [Campylobacter coli]	diamond	408	133	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
26451244	26451244	PRJNA816047b_S_NODE_55023_length_234_cov_4.726708_g52711_i0	PRJNA816047	55023	234	4.726708	11.06049672	root	1	Root_unresolved	Root_unresolved	71.3	5.79e-8	NTclustered	gi\|2222028449\|gb\|CP094103.1\|	210	g52711	i0	100	18.6794871794872	38	0	16	0	197	234	1292580	1292617	Helicobacter pylori strain Hpfe077 chromosome, complete genome	blastn	4371	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26555333	26555333	PRJNA816047d_S_NODE_22088_length_462_cov_2.540342_g20267_i0	PRJNA816047	22088	462	2.540342	11.73638004	Campylobacter jejuni	197	Bacteria	Bacteria	119	3.1599999999999997e-32	NR	MBP0443134.1	197	g20267	i0	100	0.409090909090909	63	0	40.9	0	189	1	1	63	MBP0443134.1 hypothetical protein [Campylobacter jejuni]	diamond	189	119	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
26584875	26584875	PRJNA816047a_S_NODE_15792_length_508_cov_19.432184_g13165_i0	PRJNA816047	15792	508	19.432184	98.71549472	root	1	Root_unresolved	Root_unresolved	73.1	3.81e-8	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g13165	i0	97.619	8.19291338582677	42	1	8	0	98	139	685143	685184	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	4162	73.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26585930	26585930	PRJNA816047a_S_NODE_83536_length_230_cov_2.057325_g80876_i0	PRJNA816047	83536	230	2.057325	4.7318475	root	1	Root_unresolved	Root_unresolved	71.3	5.67e-8	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g80876	i0	95.556	18.1304347826087	45	1	20	1	1	45	685143	685186	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	4170	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32973522	32973522	PRJNA816047d_S_NODE_44730_length_326_cov_3.769231_g42895_i0	PRJNA816047	44730	326	3.769231	12.28769306	Halarcobacter mediterraneus	2023153	Bacteria	Bacteria	72.8	1.74e-12	NR	WP_129061275.1	2023153	g42895	i0	59.6	0.975460122699387	52	21	47.9	0	244	89	4	55	WP_129061275.1 6-phosphofructokinase [Halarcobacter mediterraneus]	diamond	318	72.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter mediterraneus
33007614	33007614	PRJNA816047d_S_NODE_71347_length_272_cov_2.890411_g69512_i0	PRJNA816047	71347	272	2.890411	7.86191792	Sulfurovum sp.	1969726	Bacteria	Bacteria	60.8	2.24e-8	NR	MCB4782643.1	1969726	g69512	i0	34.3	6.72794117647059	67	44	73.9	0	204	4	135	201	MCB4782643.1 reverse transcriptase family protein [Sulfurovum sp.]	diamond	1830	60.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
33058274	33058274	PRJNA816047d_S_NODE_115741_length_243_cov_1.021053_g113906_i0	PRJNA816047	115741	243	1.021053	2.48115879	Helicobacter pylori	210	Bacteria	Bacteria	48.9	3.2e-5	NR	GAA8734158.1	210	g113906	i0	82.1	0.345679012345679	28	5	34.6	0	236	153	1	28	GAA8734158.1 hypothetical protein Kyoto147A_1520 [Helicobacter pylori]	diamond	84	48.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33075089	33075089	PRJNA816047b_S_NODE_14797_length_407_cov_1.437126_g12487_i0	PRJNA816047	14797	407	1.437126	5.84910282	Desulfurellales bacterium	2482794	Bacteria	Bacteria	160	1.2e-47	NR	TXH58056.1	2482794	g12487	i0	80.4	2.13759213759214	97	19	71.5	0	5	295	52	148	TXH58056.1 MAG: hypothetical protein E6Q97_03180 [Desulfurellales bacterium]	diamond	870	160	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
33075749	33075749	PRJNA816047d_S_NODE_60493_length_290_cov_3.696203_g58658_i0	PRJNA816047	60493	290	3.696203	10.7189887	Sulfurovum sp.	1969726	Bacteria	Bacteria	159	1.0199999999999999e-43	NR	MDD3500783.1	1969726	g58658	i0	89.2	0.858620689655172	83	9	85.9	0	269	21	387	469	MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.]	diamond	249	159	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
33075828	33075828	PRJNA816047d_S_NODE_72549_length_270_cov_151.391705_g70714_i0	PRJNA816047	72549	270	151.391705	408.7576035	Helicobacter pylori	210	Bacteria	Bacteria	80.1	6.68e-18	NR	GAA8838853.1	210	g70714	i0	92.5	0.444444444444444	40	3	44.4	0	269	150	4	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	120	80.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33143309	33143309	PRJNA816047a_S_NODE_74247_length_248_cov_1.337143_g71587_i0	PRJNA816047	74247	248	1.337143	3.31611464	Campylobacter jejuni	197	Bacteria	Bacteria	147	3.69e-44	NR	WP_240386170.1	197	g71587	i0	96.2	1.91129032258065	79	3	95.6	0	238	2	11	89	WP_240386170.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	474	147	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni

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