metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA316313" 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
388274	388274	PRJNA316313_P_NODE_494481_length_150_cov_3.955752_g493095_i0	PRJNA316313	494481	150	3.955752	5.933628	Campylobacter gracilis	824	Bacteria	Bacteria	137	3.28e-28	NTclustered	gi\|909717139\|gb\|CP012196.1\|	824	g493095	i0	98.701	2.76	77	1	92	0	74	150	500280	500204	Campylobacter gracilis strain ATCC 33236, complete genome	blastn	414	137	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter gracilis
1661186	1661186	PRJNA316313_P_NODE_198382_length_187_cov_3.473333_g196996_i0	PRJNA316313	198382	187	3.473333	6.49513271	Helicobacter canis	29419	Bacteria	Bacteria	63.9	7.39e-6	NTclustered	gi\|1721134163\|emb\|LR698964.1\|	29419	g196996	i0	97.297	0.197860962566845	37	1	20	0	1	37	366949	366913	Helicobacter canis isolate MGYG-HGUT-01463 genome assembly, chromosome: 1	blastn	37	63.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
1661302	1661302	PRJNA316313_P_NODE_217862_length_187_cov_3.153333_g216476_i0	PRJNA316313	217862	187	3.153333	5.89673271	Campylobacter rectus	203	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|1622745323\|gb\|CP012543.1\|	203	g216476	i0	100	1.62566844919786	76	0	81	0	112	187	2169640	2169565	Campylobacter rectus strain ATCC 33238, complete genome	blastn	304	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
4895410	4895410	PRJNA316313_P_NODE_208104_length_187_cov_3.326667_g206718_i0	PRJNA316313	208104	187	3.326667	6.22086729	Sulfurospirillum	57665	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|757804896\|dbj\|AP014724.1\|	366522	g206718	i0	100	1.59358288770053	76	0	80	0	112	187	2047275	2047350	Sulfurospirillum cavolei DNA, complete genome	blastn	298	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum cavolei
5491629	5491629	PRJNA316313_P_NODE_468925_length_151_cov_3.114035_g467539_i0	PRJNA316313	468925	151	3.114035	4.70219285	Campylobacter sp. CCUG 57310	2517362	Bacteria	Bacteria	130	5.53e-26	NTclustered	gi\|1847337518\|gb\|CP053845.1\|	2517362	g467539	i0	97.368	1.98675496688742	76	2	99	0	1	76	649587	649662	Campylobacter sp. CCUG 57310 chromosome, complete genome	blastn	300	130	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
6170270	6170270	PRJNA316313_P_NODE_153485_length_187_cov_4.546667_g152099_i0	PRJNA316313	153485	187	4.546667	8.50226729	Sulfurospirillum	57665	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|757804896\|dbj\|AP014724.1\|	366522	g152099	i0	100	1.58288770053476	76	0	81	0	1	76	1394165	1394240	Sulfurospirillum cavolei DNA, complete genome	blastn	296	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurospirillaceae	Sulfurospirillum	Sulfurospirillum cavolei
6764566	6764566	PRJNA316313_P_NODE_267426_length_187_cov_2.600000_g266040_i0	PRJNA316313	267426	187	2.6	4.862	Campylobacter showae	204	Bacteria	Bacteria	130	7.19e-26	NTclustered	gi\|1622747600\|gb\|CP012544.1\|	204	g266040	i0	97.368	3.64171122994652	76	2	41	0	112	187	326825	326900	Campylobacter showae strain ATCC 51146 chromosome, complete genome	blastn	681	130	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
6765635	6765635	PRJNA316313_P_NODE_455486_length_151_cov_3.412281_g454100_i0	PRJNA316313	455486	151	3.412281	5.15254431	Campylobacter concisus	199	Bacteria	Bacteria	226	6.859999999999999e-55	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g454100	i0	93.082	18.9602649006623	159	3	100	1	1	151	57397	57239	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	2863	226	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
8040392	8040392	PRJNA316313_P_NODE_307507_length_187_cov_2.380000_g306121_i0	PRJNA316313	307507	187	2.38	4.4506	Helicobacter hepaticus	32025	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|32263428\|gb\|AE017125.1\|	235279	g306121	i0	100	0.149732620320856	28	0	15	0	26	53	491134	491107	Helicobacter hepaticus ATCC 51449, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter hepaticus
8720691	8720691	PRJNA316313_P_NODE_361167_length_171_cov_5.089552_g359781_i0	PRJNA316313	361167	171	5.089552	8.70313392	root	1	Root_unresolved	Root_unresolved	187	3.76e-43	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g359781	i0	100	114.538011695906	101	0	59	0	1	101	565270	565370	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	19586	187	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
9316215	9316215	PRJNA316313_P_NODE_488348_length_150_cov_4.619469_g486962_i0	PRJNA316313	488348	150	4.619469	6.9292035	Campylobacter showae	204	Bacteria	Bacteria	113	5.53e-21	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g486962	i0	93.421	2.86666666666667	76	5	51	0	75	150	73960	74035	Campylobacter showae genome assembly, chromosome: I	blastn	430	113	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
10591868	10591868	PRJNA316313_P_NODE_478889_length_150_cov_7.035398_g477503_i0	PRJNA316313	478889	150	7.035398	10.553097	Campylobacter sp. CCUG 57310	2517362	Bacteria	Bacteria	152	1.17e-32	NTclustered	gi\|1847337518\|gb\|CP053845.1\|	2517362	g477503	i0	84.659	2.34666666666667	176	1	100	2	1	150	234928	235103	Campylobacter sp. CCUG 57310 chromosome, complete genome	blastn	352	152	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
15689564	15689564	PRJNA316313_P_NODE_268773_length_187_cov_2.600000_g267387_i0	PRJNA316313	268773	187	2.6	4.862	Campylobacter concisus	199	Bacteria	Bacteria	130	7.19e-26	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g267387	i0	98.63	7.81283422459893	73	1	39	0	112	184	210210	210282	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	1461	130	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
18919760	18919760	PRJNA316313_P_NODE_402955_length_151_cov_7.640351_g401569_i0	PRJNA316313	402955	151	7.640351	11.53693001	Campylobacter	194	Bacteria	Bacteria	141	2.56e-29	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g401569	i0	100	3.01986754966887	76	0	100	0	1	76	1432087	1432162	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	456	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
18920011	18920011	PRJNA316313_P_NODE_491015_length_150_cov_4.265487_g489629_i0	PRJNA316313	491015	150	4.265487	6.3982305	Campylobacter	194	Bacteria	Bacteria	143	7.049999999999998e-30	NTclustered	gi\|1829985141\|gb\|CP050963.1\|	827	g489629	i0	100	1.53333333333333	77	0	51	0	74	150	1191663	1191739	Campylobacter ureolyticus strain FDAARGOS_673 chromosome	blastn	230	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
20789657	20789657	PRJNA316313_P_NODE_481277_length_150_cov_6.026549_g479891_i0	PRJNA316313	481277	150	6.026549	9.0398235	Campylobacter concisus	199	Bacteria	Bacteria	143	7.049999999999998e-30	NTclustered	gi\|1938730527\|gb\|CP049274.1\|	199	g479891	i0	100	12.08	77	0	100	0	74	150	105190	105266	Campylobacter concisus strain P10CDO-S2 chromosome, complete genome	blastn	1812	143	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
22064386	22064386	PRJNA316313_P_NODE_444658_length_151_cov_3.798246_g443272_i0	PRJNA316313	444658	151	3.798246	5.73535146	Helicobacter canis	29419	Bacteria	Bacteria	252	1.13e-62	NTclustered	gi\|1721134163\|emb\|LR698964.1\|	29419	g443272	i0	96.689	1	151	5	100	0	1	151	534581	534731	Helicobacter canis isolate MGYG-HGUT-01463 genome assembly, chromosome: 1	blastn	151	252	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
23338497	23338497	PRJNA316313_P_NODE_206459_length_187_cov_3.353333_g205073_i0	PRJNA316313	206459	187	3.353333	6.27073271	Campylobacter showae	204	Bacteria	Bacteria	126	9.3e-25	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g205073	i0	97.297	5.18181818181818	74	2	80	0	3	76	1186978	1187051	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	969	126	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23338767	23338767	PRJNA316313_P_NODE_262419_length_187_cov_2.693333_g261033_i0	PRJNA316313	262419	187	2.693333	5.03653271	Thiomicrolovo zhangzhouensis	3131933	Bacteria	Bacteria	82.4	2.04e-11	NTclustered	gi\|2732788113\|gb\|CP147914.1\|	3131933	g261033	i0	100	10.2085561497326	44	0	24	0	28	71	1986986	1987029	Sulfurimonas sp. HSL1-2 chromosome, complete genome	blastn	1909	82.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Thiomicrolovo	Thiomicrolovo zhangzhouensis
23339012	23339012	PRJNA316313_P_NODE_306999_length_187_cov_2.380000_g305613_i0	PRJNA316313	306999	187	2.38	4.4506	Campylobacter concisus	199	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|1938726479\|gb\|CP049270.1\|	199	g305613	i0	100	4.48128342245989	76	0	41	0	112	187	1370443	1370518	Campylobacter concisus strain P26UCO-S2 chromosome, complete genome	blastn	838	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
23339695	23339695	PRJNA316313_P_NODE_414459_length_151_cov_5.412281_g413073_i0	PRJNA316313	414459	151	5.412281	8.17254431	Campylobacter concisus	199	Bacteria	Bacteria	180	5.42e-41	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g413073	i0	87.647	7.86754966887417	170	2	100	1	1	151	1058993	1059162	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	1188	180	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24612877	24612877	PRJNA316313_P_NODE_235160_length_187_cov_2.993333_g233774_i0	PRJNA316313	235160	187	2.993333	5.59753271	Campylobacter concisus	199	Bacteria	Bacteria	135	1.55e-27	NTclustered	gi\|930358546\|gb\|CP012541.1\|	199	g233774	i0	98.684	2.85026737967914	76	1	81	0	112	187	1666042	1666117	Campylobacter concisus strain ATCC 33237 chromosome, complete genome	blastn	533	135	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
25293709	25293709	PRJNA316313_P_NODE_190180_length_187_cov_3.600000_g188794_i0	PRJNA316313	190180	187	3.6	6.732	Aliarcobacter	2321111	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|1898121789\|gb\|CP060692.1\|	28198	g188794	i0	100	28.7700534759358	76	0	81	0	112	187	2013215	2013140	Aliarcobacter cryaerophilus strain 16CS0830-1 chromosome, complete genome	blastn	5380	141	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus

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