metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA415856" 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
419255	419255	PRJNA415856_P_NODE_26301_length_181_cov_1.303030_g26040_i0	PRJNA415856	26301	181	1.30303	2.3584843	Campylobacter showae	204	Bacteria	Bacteria	302	1.3800000000000001e-77	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g26040	i0	96.685	11	181	6	100	0	1	181	212821	212641	Campylobacter showae genome assembly, chromosome: I	blastn	1991	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
1083540	1083540	PRJNA415856_P_NODE_44661_length_164_cov_0.886957_g44400_i0	PRJNA415856	44661	164	0.886957	1.45460948	Campylobacter	194	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2703220886\|gb\|CP148181.1\|	197	g44400	i0	100	100	164	0	100	0	1	164	509979	510142	Campylobacter jejuni strain Z1323CCJ0101 chromosome, complete genome	blastn	16400	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
2969939	2969939	PRJNA415856_P_NODE_21023_length_191_cov_1.922535_g20762_i0	PRJNA415856	21023	191	1.922535	3.67204185	Campylobacter sp. CCUG 57310	2517362	Bacteria	Bacteria	303	4.11e-78	NTclustered	gi\|1847337518\|gb\|CP053845.1\|	2517362	g20762	i0	97.727	229.837696335079	176	4	92	0	16	191	84737	84562	Campylobacter sp. CCUG 57310 chromosome, complete genome	blastn	43899	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
4246298	4246298	PRJNA415856_P_NODE_22864_length_187_cov_1.666667_g22603_i0	PRJNA415856	22864	187	1.666667	3.11666729	Helicobacter canis	29419	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|50957150\|gb\|AY596235.1\|	29419	g22603	i0	100	143.802139037433	187	0	100	0	1	187	1458	1272	Helicobacter canis strain ATCC 51402 23S ribosomal RNA gene, partial sequence	blastn	26891	346	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
4246381	4246381	PRJNA415856_P_NODE_33484_length_169_cov_1.375000_g33223_i0	PRJNA415856	33484	169	1.375	2.32375	Campylobacter showae	204	Bacteria	Bacteria	272	9.95e-69	NTclustered	gi\|1483583555\|emb\|LT631479.1\|	204	g33223	i0	95.858	28.4082840236686	169	6	100	1	1	169	553836	553669	Campylobacter showae strain B91_TPP genome assembly, chromosome: I	blastn	4801	272	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
4911463	4911463	PRJNA415856_P_NODE_28104_length_177_cov_2.414062_g27843_i0	PRJNA415856	28104	177	2.414062	4.27288974	Campylobacter	194	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|2703256232\|gb\|CP148214.1\|	197	g27843	i0	100	100	177	0	100	0	1	177	1453595	1453419	Campylobacter jejuni strain Z1323CCJ0059 chromosome, complete genome	blastn	17700	327	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
4911595	4911595	PRJNA415856_P_NODE_50824_length_161_cov_2.276786_g50563_i0	PRJNA415856	50824	161	2.276786	3.66562546	root	1	Root_unresolved	Root_unresolved	298	1.56e-76	NTclustered	gi\|1483583505\|emb\|LT631429.1\|	204	g50563	i0	100	104	161	0	100	0	1	161	33730	33570	Campylobacter showae genome assembly, plasmid: V	blastn	16744	298	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6796884	6796884	PRJNA415856_P_NODE_1066_length_943_cov_5.202461_g913_i0	PRJNA415856	1066	943	5.202461	49.05920723	Helicobacter canis	29419	Bacteria	Bacteria	355	6.49e-93	NTclustered	gi\|1721134163\|emb\|LR698964.1\|	29419	g913	i0	79.839	0.525980911983033	496	92	52	6	286	777	244671	244180	Helicobacter canis isolate MGYG-HGUT-01463 genome assembly, chromosome: 1	blastn	496	355	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
6797107	6797107	PRJNA415856_P_NODE_37026_length_166_cov_2.247863_g36765_i0	PRJNA415856	37026	166	2.247863	3.73145258	Arcobacter suis	1278212	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1474790806\|gb\|CP032100.1\|	663365	g36765	i0	100	0.168674698795181	28	0	17	0	93	120	1435517	1435490	Arcobacter suis CECT 7833 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter suis
6797261	6797261	PRJNA415856_P_NODE_6_length_6305_cov_7.217711_g5_i0	PRJNA415856	6	6305	7.217711	455.07667855	Helicobacter canis	29419	Bacteria	Bacteria	669	0	NTclustered	gi\|1721134163\|emb\|LR698964.1\|	29419	g5	i0	87.081	0.183822363203807	596	71	9	6	4575	5167	969782	969190	Helicobacter canis isolate MGYG-HGUT-01463 genome assembly, chromosome: 1	blastn	1159	669	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
7461407	7461407	PRJNA415856_P_NODE_30286_length_174_cov_1.392000_g30025_i0	PRJNA415856	30286	174	1.392	2.42208	Campylobacter	194	Bacteria	Bacteria	267	4.7999999999999993e-67	NTclustered	gi\|1483583506\|emb\|LT631430.1\|	204	g30025	i0	94.253	5.98275862068965	174	10	100	0	1	174	15468	15295	Campylobacter showae genome assembly, plasmid: VI	blastn	1041	268	0.996268656716418	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
7461480	7461480	PRJNA415856_P_NODE_40506_length_165_cov_0.879310_g40245_i0	PRJNA415856	40506	165	0.87931	1.4508615	Campylobacter	194	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1100599896\|gb\|CP017859.1\|	197	g40245	i0	100	100	165	0	100	0	1	165	825961	826125	Campylobacter jejuni strain YQ2210, complete genome	blastn	16500	305	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
8072608	8072608	PRJNA415856_P_NODE_31747_length_171_cov_2.418033_g31486_i0	PRJNA415856	31747	171	2.418033	4.13483643	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	117	5.01e-22	NTclustered	gi\|2621701254\|emb\|OY759974.1\|	2808971	g31486	i0	83.465	10.0701754385965	127	19	74	2	9	134	4930	5055	MAG: Arcobacteraceae bacterium isolate 2f960911-6b7a-430b-8fcb-36b605e4e712 genome assembly, chromosome: 1	blastn	1722	117	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
9347552	9347552	PRJNA415856_P_NODE_51028_length_161_cov_1.821429_g50767_i0	PRJNA415856	51028	161	1.821429	2.93250069	Campylobacter showae	204	Bacteria	Bacteria	283	4.3599999999999995e-72	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g50767	i0	98.742	6.95652173913043	159	2	99	0	1	159	1553806	1553964	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	1120	283	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
12562242	12562242	PRJNA415856_P_NODE_43090_length_164_cov_0.886957_g42829_i0	PRJNA415856	43090	164	0.886957	1.45460948	root	1	Root_unresolved	Root_unresolved	303	3.42e-78	NTclustered	gi\|2423708788\|gb\|CP115181.1\|	195	g42829	i0	100	135.640243902439	164	0	100	0	1	164	596516	596353	Campylobacter coli strain 18JS15S chromosome, complete genome	blastn	22245	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
13837039	13837039	PRJNA415856_P_NODE_49051_length_162_cov_0.902655_g48790_i0	PRJNA415856	49051	162	0.902655	1.4623011	Campylobacter	194	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g48790	i0	100	100	162	0	100	0	1	162	1519173	1519334	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	16200	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
14448217	14448217	PRJNA415856_P_NODE_33592_length_169_cov_1.116667_g33331_i0	PRJNA415856	33592	169	1.116667	1.88716723	Campylobacter showae	204	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|1622747600\|gb\|CP012544.1\|	204	g33331	i0	95.858	10.1420118343195	169	7	100	0	1	169	721315	721147	Campylobacter showae strain ATCC 51146 chromosome, complete genome	blastn	1714	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
15111107	15111107	PRJNA415856_P_NODE_20892_length_192_cov_1.069930_g20631_i0	PRJNA415856	20892	192	1.06993	2.0542656	Arcobacteraceae	2808963	Bacteria	Bacteria	300	5.350000000000001e-77	NTclustered	gi\|1898123824\|gb\|CP060693.1\|	28198	g20631	i0	94.792	404.03125	192	10	100	0	1	192	71444	71253	Aliarcobacter cryaerophilus strain 16CS1285-4 chromosome, complete genome	blastn	77574	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
15111234	15111234	PRJNA415856_P_NODE_38352_length_166_cov_0.871795_g38091_i0	PRJNA415856	38352	166	0.871795	1.4471797	Campylobacter	194	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1752751018\|gb\|CP044165.1\|	195	g38091	i0	100	100	166	0	100	0	1	166	697496	697661	Campylobacter coli strain AR-0416 chromosome, complete genome	blastn	16600	307	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
15111246	15111246	PRJNA415856_P_NODE_40392_length_165_cov_0.879310_g40131_i0	PRJNA415856	40392	165	0.87931	1.4508615	Campylobacter	194	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1100599896\|gb\|CP017859.1\|	197	g40131	i0	100	100	165	0	100	0	1	165	1500452	1500616	Campylobacter jejuni strain YQ2210, complete genome	blastn	16500	305	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
16996823	16996823	PRJNA415856_P_NODE_44714_length_164_cov_0.886957_g44453_i0	PRJNA415856	44714	164	0.886957	1.45460948	Campylobacter ureolyticus	827	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g44453	i0	100	3.94512195121951	164	0	100	0	1	164	1299432	1299595	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	647	303	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
18271100	18271100	PRJNA415856_P_NODE_53215_length_161_cov_0.910714_g52954_i0	PRJNA415856	53215	161	0.910714	1.46624954	Campylobacter showae	204	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|1622747600\|gb\|CP012544.1\|	204	g52954	i0	95.031	7	161	8	100	0	1	161	1940273	1940113	Campylobacter showae strain ATCC 51146 chromosome, complete genome	blastn	1127	254	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
20209777	20209777	PRJNA415856_P_NODE_50476_length_162_cov_0.902655_g50215_i0	PRJNA415856	50476	162	0.902655	1.4623011	Campylobacter	194	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2794592207\|gb\|CP126359.1\|	195	g50215	i0	100	100	162	0	100	0	1	162	483309	483470	Campylobacter coli strain BfR-CA-19087 chromosome, complete genome	blastn	16200	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
20821146	20821146	PRJNA415856_P_NODE_45257_length_163_cov_1.789474_g44996_i0	PRJNA415856	45257	163	1.789474	2.91684262	Campylobacter ureolyticus	827	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1966876394\|gb\|CP068487.1\|	827	g44996	i0	100	7.67484662576687	163	0	100	0	1	163	1136240	1136402	Campylobacter ureolyticus strain FDAARGOS_1102 chromosome	blastn	1251	302	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
22760600	22760600	PRJNA415856_P_NODE_6978_length_354_cov_1.793443_g6717_i0	PRJNA415856	6978	354	1.793443	6.34878822	root	1	Root_unresolved	Root_unresolved	649	0	NTclustered	gi\|1752751060\|gb\|CP044176.1\|	195	g6717	i0	99.718	129	354	1	100	0	1	354	20767	21120	Campylobacter coli strain AR-0411 plasmid pAR-0411, complete sequence	blastn	45666	654	0.992354740061162	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
23371408	23371408	PRJNA415856_P_NODE_29819_length_175_cov_1.126984_g29558_i0	PRJNA415856	29819	175	1.126984	1.972222	Campylobacter rectus	203	Bacteria	Bacteria	274	2.89e-69	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g29558	i0	94.857	12	175	9	100	0	1	175	2338577	2338751	Campylobacter rectus strain ATCC 33238, complete genome	blastn	2100	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus

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