metadata: contig_metadata: 21 rows where bioproject = "PRJNA1144090" and tax

21 rows where bioproject = "PRJNA1144090" 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
1561700	1561700	PRJNA1144090_P_NODE_19382_length_618_cov_394.095413_g18858_i0	PRJNA1144090	19382	618	394.095413	2435.50965234	Arcobacter iocasae	2906515	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2809047151\|gb\|CP090177.1\|	2906515	g18858	i0	100	0.0469255663430421	29	0	5	0	96	124	1017122	1017150	Arcobacter sp. KX21116 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter iocasae
1562425	1562425	PRJNA1144090_P_NODE_85242_length_272_cov_3.773869_g84707_i0	PRJNA1144090	85242	272	3.773869	10.26492368	Malaciobacter canalis	1912871	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2851193446\|gb\|CP085223.1\|	1912871	g84707	i0	100	0.341911764705882	29	0	11	0	173	201	2090370	2090398	Malaciobacter canalis strain ADH2-947 chromosome, complete genome	blastn	93	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter canalis
5390030	5390030	PRJNA1144090_P_NODE_104165_length_248_cov_0.880000_g103630_i0	PRJNA1144090	104165	248	0.88	2.1824	Campylobacter concisus	199	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|1938728373\|gb\|CP049272.1\|	199	g103630	i0	98.79	7.01209677419355	248	3	100	0	1	248	633959	633712	Campylobacter concisus strain P27CDO-S2 chromosome, complete genome	blastn	1739	442	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6135885	6135885	PRJNA1144090_P_NODE_68825_length_305_cov_1.818966_g68290_i0	PRJNA1144090	68825	305	1.818966	5.5478463	Campylobacter	194	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1940031893\|gb\|CP065357.1\|	1813019	g68290	i0	100	0.852459016393443	29	0	10	0	272	300	233094	233066	Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome	blastn	260	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter hepaticus
8686079	8686079	PRJNA1144090_P_NODE_117587_length_238_cov_2.333333_g117052_i0	PRJNA1144090	117587	238	2.333333	5.55333254	Aliarcobacter	2321111	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g117052	i0	100	423.218487394958	237	0	99	0	1	237	852321	852557	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	100726	438	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
12511742	12511742	PRJNA1144090_P_NODE_82570_length_277_cov_1.509804_g82035_i0	PRJNA1144090	82570	277	1.509804	4.18215708	Arcobacteraceae	2808963	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g82035	i0	100	384.361010830325	277	0	100	0	1	277	851949	851673	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	106468	512	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
15060710	15060710	PRJNA1144090_P_NODE_40052_length_408_cov_1.367164_g39517_i0	PRJNA1144090	40052	408	1.367164	5.57802912	Aliarcobacter	2321111	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g39517	i0	100	0.142156862745098	29	0	7	0	5	33	1821349	1821377	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	58	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
22709894	22709894	PRJNA1144090_P_NODE_33638_length_450_cov_1.599469_g33103_i0	PRJNA1144090	33638	450	1.599469	7.1976105	Aliarcobacter	2321111	Bacteria	Bacteria	832	0	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g33103	i0	100	379.686666666667	450	0	100	0	1	450	851573	851124	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	170859	832	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
23240065	23240065	PRJNA1144090_P_NODE_79019_length_283_cov_3.233333_g78484_i0	PRJNA1144090	79019	283	3.233333	9.15033239	Arcobacter peruensis	2320140	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1509188976\|gb\|CP032363.1\|	2320140	g78484	i0	100	0.0989399293286219	28	0	10	0	188	215	1851250	1851277	Arcobacter peruensis strain PSE-93 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter peruensis
23985332	23985332	PRJNA1144090_P_NODE_83439_length_275_cov_3.811881_g82904_i0	PRJNA1144090	83439	275	3.811881	10.48267275	Aliarcobacter	2321111	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g82904	i0	100	400.472727272727	272	0	100	0	1	272	849691	849962	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	110130	503	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
26901415	26901415	PRJNA1144090_P_NODE_92621_length_260_cov_2.614973_g92086_i0	PRJNA1144090	92621	260	2.614973	6.7989298	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	1.26e-5	NR	WP_300827129.1	209	g92086	i0	53.8	6.04615384615385	65	22	72.7	2	6	194	155	213	WP_300827129.1 MULTISPECIES: hypothetical protein [Helicobacter]	diamond	1572	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter
27070460	27070460	PRJNA1144090_P_NODE_5022_length_1272_cov_2.276063_g4738_i0	PRJNA1144090	5022	1272	2.276063	28.95152136	Campylobacterota bacterium	2026809	Bacteria	Bacteria	52	0.00215	NR	MEA2027678.1	2026809	g4738	i0	31.5	0.474056603773585	111	68	24.5	3	959	1270	18	127	MEA2027678.1 caspase family protein [Campylobacterota bacterium]	diamond	603	52	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
28144605	28144605	PRJNA1144090_P_NODE_91085_length_263_cov_1.505263_g90550_i0	PRJNA1144090	91085	263	1.505263	3.95884169	Campylobacterota bacterium	2026809	Bacteria	Bacteria	62.4	5.79e-9	NR	MCB9492830.1	2026809	g90550	i0	44.9	0.889733840304182	78	31	89	2	236	3	813	878	MCB9492830.1 hypothetical protein [Campylobacterota bacterium]	diamond	234	62.4	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
28365194	28365194	PRJNA1144090_P_NODE_6446_length_1126_cov_8.470085_g6116_i0	PRJNA1144090	6446	1126	8.470085	95.3731571	Campylobacterota bacterium	2026809	Bacteria	Bacteria	161	1.9199999999999998e-42	NR	MEA3353466.1	2026809	g6116	i0	33.9	0.967140319715808	363	176	93.5	16	1057	5	3	313	MEA3353466.1 DUF2235 domain-containing protein [Campylobacterota bacterium]	diamond	1089	161	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29627889	29627889	PRJNA1144090_P_NODE_71150_length_300_cov_1.321586_g70615_i0	PRJNA1144090	71150	300	1.321586	3.964758	Campylobacterota bacterium	2026809	Bacteria	Bacteria	42.4	0.041	NR	MDQ1339672.1	2026809	g70615	i0	42.1	0.57	57	30	57	1	182	12	16	69	MDQ1339672.1 hypothetical protein [Campylobacterota bacterium]	diamond	171	42.4	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
30355369	30355369	PRJNA1144090_P_NODE_51312_length_356_cov_1.632509_g50777_i0	PRJNA1144090	51312	356	1.632509	5.81173204	Campylobacter coli	195	Bacteria	Bacteria	130	1.01e-36	NR	WP_402370336.1	195	g50777	i0	100	0.530898876404494	63	0	53.1	0	355	167	37	99	WP_402370336.1 hypothetical protein [Campylobacter coli]	diamond	189	130	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
31144246	31144246	PRJNA1144090_P_NODE_108815_length_245_cov_1.581395_g108280_i0	PRJNA1144090	108815	245	1.581395	3.87441775	Campylobacter coli	195	Bacteria	Bacteria	77.8	1.05e-16	NR	WP_402370331.1	195	g108280	i0	100	0.46530612244898	38	0	46.5	0	131	244	1	38	WP_402370331.1 hypothetical protein [Campylobacter coli]	diamond	114	77.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
31492782	31492782	PRJNA1144090_P_NODE_58556_length_332_cov_1.212355_g58021_i0	PRJNA1144090	58556	332	1.212355	4.0250186	Nitratifractor sp.	2268144	Bacteria	Bacteria	44.3	0.00896	NR	HGZ70199.1	2268144	g58021	i0	33.7	0.75	83	39	64.2	3	308	96	35	113	HGZ70199.1 hypothetical protein [Nitratifractor sp.]	diamond	249	44.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Nitratifractor	Nitratifractor sp.
31714042	31714042	PRJNA1144090_P_NODE_75157_length_291_cov_2.119266_g74622_i0	PRJNA1144090	75157	291	2.119266	6.16706406	Campylobacter coli	195	Bacteria	Bacteria	197	3.99e-59	NR	WP_402370334.1	195	g74622	i0	100	1	97	0	100	0	291	1	259	355	WP_402370334.1 protein rep [Campylobacter coli]	diamond	291	197	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
31797624	31797624	PRJNA1144090_P_NODE_81517_length_279_cov_1.495146_g80982_i0	PRJNA1144090	81517	279	1.495146	4.17145734	Bacteria	2	Bacteria	Bacteria	51.2	2.71e-6	NR	GAA9125269.1	210	g80982	i0	69	2.53763440860215	29	9	31.2	0	271	185	4	32	GAA9125269.1 hypothetical protein Kyoto190A_0810 [Helicobacter pylori]	diamond	708	51.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32882945	32882945	PRJNA1144090_P_NODE_53440_length_348_cov_2.240000_g52905_i0	PRJNA1144090	53440	348	2.24	7.7952	Helicobacter marmotae	152490	Bacteria	Bacteria	48.5	0.00116	NR	WP_104699558.1	152490	g52905	i0	31.6	0.681034482758621	79	52	68.1	1	2	238	192	268	WP_104699558.1 DNA polymerase I [Helicobacter marmotae]	diamond	237	48.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter marmotae

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