metadata: contig_metadata: 29 rows where bioproject = "PRJNA758088" and tax

29 rows where bioproject = "PRJNA758088" 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
1203716	1203716	PRJNA758088_P_NODE_318581_length_247_cov_0.885057_g311610_i0	PRJNA758088	318581	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	457	4.05e-124	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g311610	i0	100	100	247	0	100	0	1	247	552852	553098	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	24700	457	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
5031962	5031962	PRJNA758088_P_NODE_302444_length_249_cov_0.869318_g295473_i0	PRJNA758088	302444	249	0.869318	2.16460182	FCB group	1783270	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|2252991476\|dbj\|AP025982.1\|	197	g295473	i0	97.189	98.9518072289157	249	7	100	0	1	249	21229	20981	Campylobacter jejuni THJ056 plasmid pTHJ056_1 DNA, complete sequence	blastn	24639	422	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
5032490	5032490	PRJNA758088_P_NODE_96864_length_427_cov_1.087571_g89894_i0	PRJNA758088	96864	427	1.087571	4.64392817	root	1	Root_unresolved	Root_unresolved	789	0	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g89894	i0	100	101.002341920375	427	0	100	0	1	427	1303388	1302962	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	43128	789	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
7114343	7114343	PRJNA758088_P_NODE_200226_length_301_cov_0.938596_g193255_i0	PRJNA758088	200226	301	0.938596	2.82517396	Campylobacter coli	195	Bacteria	Bacteria	551	2.2699999999999992e-152	NTclustered	gi\|2806513751\|gb\|CP169436.1\|	195	g193255	i0	99.668	80.0863787375415	301	1	100	0	1	301	6850	6550	Campylobacter coli strain CVM N63020 plasmid pN63020-1, complete sequence	blastn	24106	551	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
7581435	7581435	PRJNA758088_P_NODE_246026_length_271_cov_1.217172_g239055_i0	PRJNA758088	246026	271	1.217172	3.29853612	Helicobacter	209	Bacteria	Bacteria	484	2.07e-132	NTclustered	gi\|2157108461\|dbj\|AP025204.1\|	213	g239055	i0	98.893	135.546125461255	271	3	100	0	1	271	128191	128461	Helicobacter cinaedi 94105 DNA, complete genome	blastn	36733	484	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter cinaedi
10941886	10941886	PRJNA758088_P_NODE_351229_length_243_cov_0.894118_g344258_i0	PRJNA758088	351229	243	0.894118	2.17270674	Campylobacter coli	195	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|2523954314\|dbj\|AP028341.1\|	195	g344258	i0	98.765	119.691358024691	243	3	100	0	1	243	152631	152873	Campylobacter coli BCH-10328 DNA, complete genome	blastn	29085	433	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
12683335	12683335	PRJNA758088_P_NODE_289050_length_250_cov_0.870056_g282079_i0	PRJNA758088	289050	250	0.870056	2.17514	Campylobacter	194	Bacteria	Bacteria	403	5.43e-108	NTclustered	gi\|2844290135\|gb\|CP172381.1\|	197	g282079	i0	95.968	13.92	248	10	99	0	1	248	1638775	1639022	Campylobacter jejuni strain YH007 chromosome, complete genome	blastn	3480	403	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
13957012	13957012	PRJNA758088_P_NODE_146711_length_348_cov_0.992727_g139740_i0	PRJNA758088	146711	348	0.992727	3.45468996	root	1	Root_unresolved	Root_unresolved	638	1.99e-178	NTclustered	gi\|2794627034\|gb\|CP126368.1\|	195	g139740	i0	99.713	103	348	1	100	0	1	348	40014	39667	Campylobacter coli strain BfR-CA-15687 plasmid pBfR-CA-15687, complete sequence	blastn	35844	638	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
15231425	15231425	PRJNA758088_P_NODE_105852_length_407_cov_2.272455_g98882_i0	PRJNA758088	105852	407	2.272455	9.24889185	Helicobacter	209	Bacteria	Bacteria	752	0	NTclustered	gi\|50957163\|gb\|AY596248.1\|	50960	g98882	i0	100	129.835380835381	407	0	100	0	1	407	994	588	Helicobacter trogontum strain ATCC 49310 23S ribosomal RNA gene, partial sequence	blastn	52843	752	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter trogontum
16040260	16040260	PRJNA758088_P_NODE_335133_length_245_cov_0.860465_g328162_i0	PRJNA758088	335133	245	0.860465	2.10813925	Halarcobacter ebronensis	1462615	Bacteria	Bacteria	67.6	7.9e-7	NTclustered	gi\|1847334501\|gb\|CP053836.1\|	1462615	g328162	i0	97.436	6.63265306122449	39	1	16	0	70	108	2831054	2831092	Halarcobacter ebronensis strain LMG 27922 chromosome, complete genome	blastn	1625	67.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter ebronensis
16040706	16040706	PRJNA758088_P_NODE_365613_length_241_cov_0.916667_g358642_i0	PRJNA758088	365613	241	0.916667	2.20916747	Campylobacter showae	204	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|1483583565\|emb\|LT631545.1\|	204	g358642	i0	97.925	12.3734439834025	241	5	100	0	1	241	1097916	1098156	Campylobacter showae strain B32_SW genome assembly, chromosome: I	blastn	2982	418	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
16506179	16506179	PRJNA758088_P_NODE_199473_length_301_cov_1.350877_g192502_i0	PRJNA758088	199473	301	1.350877	4.06613977	root	1	Root_unresolved	Root_unresolved	453	6.57e-123	NTclustered	gi\|2523961402\|dbj\|AP028347.1\|	197	g192502	i0	100	81.6611295681063	245	0	81	0	57	301	3296	3052	Campylobacter jejuni BCH-10335 plasmid pTet_BCH-10335 DNA, complete sequence	blastn	24580	453	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
17781474	17781474	PRJNA758088_P_NODE_333114_length_245_cov_0.895349_g326143_i0	PRJNA758088	333114	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	453	5.1900000000000006e-123	NTclustered	gi\|1752751059\|gb\|CP044175.1\|	195	g326143	i0	100	28.1714285714286	245	0	100	0	1	245	1631158	1630914	Campylobacter coli strain AR-0411 chromosome, complete genome	blastn	6902	453	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
17781723	17781723	PRJNA758088_P_NODE_64814_length_536_cov_2.071274_g57885_i0	PRJNA758088	64814	536	2.071274	11.10202864	PVC group	1783257	Bacteria	Bacteria	953	0	NTclustered	gi\|1829619220\|gb\|CP048763.1\|	197	g57885	i0	99.618	130.09328358209	523	1	98	1	1	522	707725	708247	Campylobacter jejuni strain ZH006 chromosome, complete genome	blastn	69730	955	0.997905759162304	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
19862028	19862028	PRJNA758088_P_NODE_163976_length_330_cov_1.571984_g157005_i0	PRJNA758088	163976	330	1.571984	5.1875472	Campylobacter coli	195	Bacteria	Bacteria	599	8.849999999999995e-167	NTclustered	gi\|2805374337\|gb\|CP169431.1\|	195	g157005	i0	99.394	33.3818181818182	330	2	100	0	1	330	137774	138103	Campylobacter coli strain CVM N17C336 plasmid pN17C336-1, complete sequence	blastn	11016	599	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
20330394	20330394	PRJNA758088_P_NODE_44196_length_682_cov_1.520525_g37643_i0	PRJNA758088	44196	682	1.520525	10.3699805	root	1	Root_unresolved	Root_unresolved	1260	0	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g37643	i0	100	115.121700879765	682	0	100	0	1	682	314979	315660	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	78513	1260	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
20330585	20330585	PRJNA758088_P_NODE_80256_length_473_cov_2.412500_g73291_i0	PRJNA758088	80256	473	2.4125	11.411125	root	1	Root_unresolved	Root_unresolved	869	0	NTclustered	gi\|1752751059\|gb\|CP044175.1\|	195	g73291	i0	99.789	31.8837209302326	473	1	100	0	1	473	1631831	1631359	Campylobacter coli strain AR-0411 chromosome, complete genome	blastn	15081	869	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
21606029	21606029	PRJNA758088_P_NODE_344317_length_243_cov_1.358824_g337346_i0	PRJNA758088	344317	243	1.358824	3.30194232	root	1	Root_unresolved	Root_unresolved	449	6.65e-122	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g337346	i0	100	103.633744855967	243	0	100	0	1	243	314710	314468	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	25183	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
24154897	24154897	PRJNA758088_P_NODE_183299_length_314_cov_0.879668_g176328_i0	PRJNA758088	183299	314	0.879668	2.76215752	root	1	Root_unresolved	Root_unresolved	575	1.4099999999999994e-159	NTclustered	gi\|2523961402\|dbj\|AP028347.1\|	197	g176328	i0	99.682	42.8757961783439	314	1	100	0	1	314	3872	3559	Campylobacter jejuni BCH-10335 plasmid pTet_BCH-10335 DNA, complete sequence	blastn	13463	575	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
24963547	24963547	PRJNA758088_P_NODE_297980_length_249_cov_0.875000_g291009_i0	PRJNA758088	297980	249	0.875	2.17875	uncultured Aliarcobacter sp.	2321118	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2621785459\|emb\|OY781917.1\|	2321118	g291009	i0	100	367.534136546185	249	0	100	0	1	249	1466005	1466253	MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2	blastn	91516	460	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	uncultured Aliarcobacter sp.
26682804	26682804	PRJNA758088_P_NODE_244261_length_272_cov_1.361809_g237290_i0	PRJNA758088	244261	272	1.361809	3.70412048	Pseudomonadati	3379134	Bacteria	Bacteria	50.8	3.34e-5	NR	WP_148129205.1	197	g237290	i0	65.5	0.970588235294118	29	10	32	0	3	89	1	29	WP_148129205.1 BspA family leucine-rich repeat surface protein, partial [Campylobacter jejuni]	diamond	264	51.2	0.9921875	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
27716765	27716765	PRJNA758088_P_NODE_212584_length_292_cov_1.301370_g205613_i0	PRJNA758088	212584	292	1.30137	3.8000004	Helicobacter pylori	210	Bacteria	Bacteria	40.4	0.0348	NR	GAA8932380.1	210	g205613	i0	90.2	0.421232876712329	41	4	42.1	0	3	125	2	42	GAA8932380.1 hypothetical protein Kyoto166A_4400 [Helicobacter pylori]	diamond	123	40.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28158639	28158639	PRJNA758088_P_NODE_122225_length_379_cov_2.320261_g115254_i0	PRJNA758088	122225	379	2.320261	8.79378919	Campylobacterales bacterium	2268180	Bacteria	Bacteria	93.6	2.67e-19	NR	MBY0539904.1	2268180	g115254	i0	57.9	0.601583113456464	76	32	60.2	0	372	145	357	432	MBY0539904.1 hypothetical protein [Campylobacterales bacterium]	diamond	228	93.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
28600559	28600559	PRJNA758088_P_NODE_139547_length_356_cov_1.346290_g132576_i0	PRJNA758088	139547	356	1.34629	4.7927924	Helicobacter pylori	210	Bacteria	Bacteria	53.9	4.15e-7	NR	GAA8683167.1	210	g132576	i0	73.3	0.252808988764045	30	8	25.3	0	356	267	1	30	GAA8683167.1 hypothetical protein Kyoto145A_0420 [Helicobacter pylori]	diamond	90	53.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28610312	28610312	PRJNA758088_P_NODE_180327_length_316_cov_1.267490_g173356_i0	PRJNA758088	180327	316	1.26749	4.0052684	Pseudomonadati	3379134	Bacteria	Bacteria	202	3.9e-65	NR	MCH3755768.1	195	g173356	i0	99	1.99367088607595	105	1	99.7	0	315	1	9	113	MCH3755768.1 ATP-binding cassette domain-containing protein [Campylobacter coli]	diamond	630	204	0.990196078431373	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
28726780	28726780	PRJNA758088_P_NODE_344387_length_243_cov_1.358824_g337416_i0	PRJNA758088	344387	243	1.358824	3.30194232	Helicobacter pylori	210	Bacteria	Bacteria	52	6.03e-7	NR	GAA9104010.1	210	g337416	i0	87.5	0.296296296296296	24	3	29.6	0	158	87	4	27	GAA9104010.1 hypothetical protein Kyoto184A_09450 [Helicobacter pylori]	diamond	72	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29042675	29042675	PRJNA758088_P_NODE_340388_length_244_cov_0.900585_g333417_i0	PRJNA758088	340388	244	0.900585	2.1974274	Helicobacter pylori	210	Bacteria	Bacteria	52	7.07e-7	NR	GAA8812112.1	210	g333417	i0	90.9	0.590163934426229	22	2	27	0	118	183	26	47	GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori]	diamond	144	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31285188	31285188	PRJNA758088_P_NODE_248395_length_270_cov_0.893401_g241424_i0	PRJNA758088	248395	270	0.893401	2.4121827	uncultured Helicobacter sp.	175537	Bacteria	Bacteria	75.1	5.87e-14	NR	WP_300948534.1	175537	g241424	i0	51.7	3.04444444444444	60	29	66.7	0	255	76	91	150	WP_300948534.1 carbonic anhydrase [uncultured Helicobacter sp.]	diamond	822	75.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	uncultured Helicobacter sp.
32519366	32519366	PRJNA758088_P_NODE_69539_length_515_cov_1.002262_g62587_i0	PRJNA758088	69539	515	1.002262	5.1616493	Campylobacterales bacterium	2268180	Bacteria	Bacteria	121	1.47e-28	NR	MBY0539904.1	2268180	g62587	i0	41.9	0.972815533980583	167	93	97.3	2	501	1	258	420	MBY0539904.1 hypothetical protein [Campylobacterales bacterium]	diamond	501	121	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales 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);;