metadata: contig_metadata: 18 rows where bioproject = "PRJNA1108009", tax_phylum = "Campylobacterota" and tax

18 rows where bioproject = "PRJNA1108009", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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
213083	213083	PRJNA1108009_P_NODE_27161_length_248_cov_0.880000_g26843_i0	PRJNA1108009	27161	248	0.88	2.1824	Campylobacter devanensis	3161138	Bacteria	Bacteria	388	1.51e-103	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g26843	i0	97.368	0.919354838709677	228	6	92	0	1	228	485494	485721	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	228	388	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
213159	213159	PRJNA1108009_P_NODE_30261_length_243_cov_0.905882_g29943_i0	PRJNA1108009	30261	243	0.905882	2.20129326	Campylobacter vicugnae	1660076	Bacteria	Bacteria	403	5.25e-108	NTclustered	gi\|1192708697\|gb\|CP018791.1\|	1660076	g29943	i0	96.694	4.94650205761317	242	8	99	0	2	243	1335042	1334801	Campylobacter vicugnae strain RM8964, complete genome	blastn	1202	403	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
1487753	1487753	PRJNA1108009_P_NODE_26022_length_249_cov_0.875000_g25704_i0	PRJNA1108009	26022	249	0.875	2.17875	Campylobacter vicugnae	1660076	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2678412531\|gb\|CP144916.1\|	1660076	g25704	i0	99.197	32.1164658634538	249	2	100	0	1	249	26918	27166	Campylobacter vicugnae strain RM9261 chromosome, complete genome	blastn	7997	449	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
4039860	4039860	PRJNA1108009_P_NODE_25884_length_249_cov_1.687500_g25566_i0	PRJNA1108009	25884	249	1.6875	4.201875	Campylobacter devanensis	3161138	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g25566	i0	97.992	31.4457831325301	249	5	100	0	1	249	299271	299519	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	7830	433	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
5315992	5315992	PRJNA1108009_P_NODE_26765_length_248_cov_0.880000_g26447_i0	PRJNA1108009	26765	248	0.88	2.1824	Campylobacter vicugnae	1660076	Bacteria	Bacteria	377	3.26e-100	NTclustered	gi\|1192708697\|gb\|CP018791.1\|	1660076	g26447	i0	94.694	2.97983870967742	245	9	98	4	6	248	1286325	1286083	Campylobacter vicugnae strain RM8964, complete genome	blastn	739	377	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
7865700	7865700	PRJNA1108009_P_NODE_20807_length_281_cov_1.480769_g20489_i0	PRJNA1108009	20807	281	1.480769	4.16096089	Campylobacter devanensis	3161138	Bacteria	Bacteria	503	5.95e-138	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g20489	i0	98.932	1.43060498220641	281	3	100	0	1	281	1256189	1256469	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	402	503	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
7865734	7865734	PRJNA1108009_P_NODE_22087_length_271_cov_1.166667_g21769_i0	PRJNA1108009	22087	271	1.166667	3.16166757	Campylobacter vicugnae	1660076	Bacteria	Bacteria	484	2.07e-132	NTclustered	gi\|1192708697\|gb\|CP018791.1\|	1660076	g21769	i0	98.893	5.00738007380074	271	3	100	0	1	271	809937	809667	Campylobacter vicugnae strain RM8964, complete genome	blastn	1357	484	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
7865888	7865888	PRJNA1108009_P_NODE_27987_length_246_cov_1.115607_g27669_i0	PRJNA1108009	27987	246	1.115607	2.74439322	Campylobacter vicugnae	1660076	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|1192708697\|gb\|CP018791.1\|	1660076	g27669	i0	97.967	38.5447154471545	246	5	100	0	1	246	824520	824765	Campylobacter vicugnae strain RM8964, complete genome	blastn	9482	427	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
9140725	9140725	PRJNA1108009_P_NODE_27428_length_247_cov_0.885057_g27110_i0	PRJNA1108009	27428	247	0.885057	2.18609079	Campylobacter	194	Bacteria	Bacteria	159	2.2799999999999998e-48	NR	WP_086224259.1	194	g27110	i0	96.3	1.96761133603239	81	3	98.4	0	245	3	25	105	WP_086224259.1 MULTISPECIES: acyl-CoA thioesterase [Campylobacter]	diamond	486	159	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter
10416433	10416433	PRJNA1108009_P_NODE_23169_length_262_cov_1.449735_g22851_i0	PRJNA1108009	23169	262	1.449735	3.7983057	Campylobacter devanensis	3161138	Bacteria	Bacteria	353	5.85e-93	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g22851	i0	91.154	5.20992366412214	260	23	99	0	1	260	397492	397751	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	1365	353	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
10416569	10416569	PRJNA1108009_P_NODE_28929_length_245_cov_0.895349_g28611_i0	PRJNA1108009	28929	245	0.895349	2.19360505	Campylobacter devanensis	3161138	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g28611	i0	97.551	5	245	6	100	0	1	245	1457467	1457711	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	1225	420	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
11691841	11691841	PRJNA1108009_P_NODE_29050_length_245_cov_0.895349_g28732_i0	PRJNA1108009	29050	245	0.895349	2.19360505	Campylobacter devanensis	3161138	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g28732	i0	100	5	245	0	100	0	1	245	1295320	1295076	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	1225	453	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
12499318	12499318	PRJNA1108009_P_NODE_20430_length_284_cov_1.369668_g20112_i0	PRJNA1108009	20430	284	1.369668	3.88985712	Campylobacter	194	Bacteria	Bacteria	444	3.6999999999999986e-120	NTclustered	gi\|1192708697\|gb\|CP018791.1\|	1660076	g20112	i0	94.774	2.02112676056338	287	12	100	1	1	284	373359	373645	Campylobacter vicugnae strain RM8964, complete genome	blastn	574	444	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
14242013	14242013	PRJNA1108009_P_NODE_31772_length_241_cov_0.916667_g31454_i0	PRJNA1108009	31772	241	0.916667	2.20916747	Campylobacter devanensis	3161138	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|1192705590\|gb\|CP018788.1\|	3161138	g31454	i0	97.095	7	241	7	100	0	1	241	752408	752648	Campylobacter devanensis strain NCTC 13003, complete genome	blastn	1687	407	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter devanensis
15515596	15515596	PRJNA1108009_P_NODE_22413_length_268_cov_1.307692_g22095_i0	PRJNA1108009	22413	268	1.307692	3.50461456	Campylobacter vicugnae	1660076	Bacteria	Bacteria	110	1.44e-19	NTclustered	gi\|2678415085\|gb\|CP144915.1\|	1660076	g22095	i0	98.387	1.3544776119403	62	1	23	0	2	63	1089059	1088998	Campylobacter vicugnae strain RM8835 chromosome, complete genome	blastn	363	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
18064442	18064442	PRJNA1108009_P_NODE_15215_length_337_cov_1.670455_g14897_i0	PRJNA1108009	15215	337	1.670455	5.62943335	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	344	4.6899999999999985e-90	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g14897	i0	93.534	156.20178041543	232	13	69	2	3	233	236	6	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	52640	344	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
24438996	24438996	PRJNA1108009_P_NODE_26480_length_249_cov_0.875000_g26162_i0	PRJNA1108009	26480	249	0.875	2.17875	Campylobacter vicugnae	1660076	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|1192708697\|gb\|CP018791.1\|	1660076	g26162	i0	96.787	97.2248995983936	249	8	100	0	1	249	561490	561738	Campylobacter vicugnae strain RM8964, complete genome	blastn	24209	416	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter vicugnae
32785745	32785745	PRJNA1108009_P_NODE_26220_length_249_cov_0.875000_g25902_i0	PRJNA1108009	26220	249	0.875	2.17875	Helicobacter sp. 16-1353	2004996	Bacteria	Bacteria	73.9	2.66e-13	NR	WP_112060588.1	2004996	g25902	i0	50.8	0.734939759036145	61	30	73.5	0	6	188	164	224	WP_112060588.1 FecCD family ABC transporter permease [Helicobacter sp. 16-1353]	diamond	183	73.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. 16-1353

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