metadata: contig_metadata: 29 rows where bioproject = "PRJNA1013345", tax_phylum = "Campylobacterota" and tax

29 rows where bioproject = "PRJNA1013345", 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
158321	158321	PRJNA1013345_P_NODE_25221_length_163_cov_1.413793_g25091_i0	PRJNA1013345	25221	163	1.413793	2.30448259	Campylobacter concisus	199	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g25091	i0	99.387	11	163	1	100	0	1	163	752847	753009	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	1793	296	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
2708460	2708460	PRJNA1013345_P_NODE_12843_length_188_cov_1.503546_g12713_i0	PRJNA1013345	12843	188	1.503546	2.82666648	Campylobacter concisus	199	Bacteria	Bacteria	335	1.4299999999999995e-87	NTclustered	gi\|1938717787\|gb\|CP060705.1\|	199	g12713	i0	98.93	15.8191489361702	187	2	99	0	1	187	1881282	1881096	Campylobacter concisus strain P13UCO-S1 chromosome, complete genome	blastn	2974	335	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
2708488	2708488	PRJNA1013345_P_NODE_13983_length_185_cov_1.217391_g13853_i0	PRJNA1013345	13983	185	1.217391	2.25217335	Campylobacter concisus	199	Bacteria	Bacteria	331	1.81e-86	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g13853	i0	98.919	14.9783783783784	185	2	100	0	1	185	777893	777709	Campylobacter concisus strain RMIT-O23 chromosome	blastn	2771	331	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
2708495	2708495	PRJNA1013345_P_NODE_14363_length_184_cov_1.408759_g14233_i0	PRJNA1013345	14363	184	1.408759	2.59211656	Campylobacter concisus	199	Bacteria	Bacteria	340	2.99e-89	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g14233	i0	100	22.0271739130435	184	0	100	0	1	184	711704	711887	Campylobacter concisus strain RMIT-O23 chromosome	blastn	4053	340	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
2708574	2708574	PRJNA1013345_P_NODE_20003_length_171_cov_2.241935_g19873_i0	PRJNA1013345	20003	171	2.241935	3.83370885	Campylobacter concisus	199	Bacteria	Bacteria	294	2.16e-75	NTclustered	gi\|1935895612\|gb\|CP049232.1\|	199	g19873	i0	97.661	3.98830409356725	171	4	100	0	1	171	1895886	1895716	Campylobacter concisus strain H9O-S2 chromosome, complete genome	blastn	682	294	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
3984875	3984875	PRJNA1013345_P_NODE_26844_length_162_cov_0.878261_g26714_i0	PRJNA1013345	26844	162	0.878261	1.42278282	Campylobacter concisus	199	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g26714	i0	98.765	9	162	2	100	0	1	162	393393	393554	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	1458	289	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
5261001	5261001	PRJNA1013345_P_NODE_13905_length_185_cov_1.478261_g13775_i0	PRJNA1013345	13905	185	1.478261	2.73478285	Campylobacter concisus	199	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|1935888393\|gb\|CP049239.1\|	199	g13775	i0	100	45.3081081081081	185	0	100	0	1	185	1702890	1702706	Campylobacter concisus strain P3UCO1 chromosome, complete genome	blastn	8382	342	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6536417	6536417	PRJNA1013345_P_NODE_18626_length_174_cov_2.377953_g18496_i0	PRJNA1013345	18626	174	2.377953	4.13763822	Campylobacter concisus	199	Bacteria	Bacteria	311	2.19e-80	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g18496	i0	98.851	6.97701149425287	174	2	100	0	1	174	1973886	1973713	Campylobacter concisus strain RMIT-O23 chromosome	blastn	1214	311	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
6536482	6536482	PRJNA1013345_P_NODE_22726_length_166_cov_1.159664_g22596_i0	PRJNA1013345	22726	166	1.159664	1.92504224	Campylobacter concisus	199	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|1938717787\|gb\|CP060705.1\|	199	g22596	i0	98.773	12.8132530120482	163	2	98	0	1	163	1334611	1334773	Campylobacter concisus strain P13UCO-S1 chromosome, complete genome	blastn	2127	291	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
9085877	9085877	PRJNA1013345_P_NODE_24948_length_163_cov_2.232759_g24818_i0	PRJNA1013345	24948	163	2.232759	3.63939717	Campylobacter concisus	199	Bacteria	Bacteria	279	5.73e-71	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g24818	i0	97.546	14.0061349693252	163	4	100	0	1	163	1369802	1369964	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	2283	279	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
10361416	10361416	PRJNA1013345_P_NODE_16809_length_178_cov_2.335878_g16679_i0	PRJNA1013345	16809	178	2.335878	4.15786284	Campylobacter concisus	199	Bacteria	Bacteria	313	6.259999999999999e-81	NTclustered	gi\|1938719709\|gb\|CP049264.1\|	199	g16679	i0	98.315	9.9438202247191	178	3	100	0	1	178	1136423	1136246	Campylobacter concisus strain P11CDO-S1 chromosome, complete genome	blastn	1770	313	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12911895	12911895	PRJNA1013345_P_NODE_23691_length_165_cov_0.864407_g23561_i0	PRJNA1013345	23691	165	0.864407	1.42627155	Campylobacter concisus	199	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g23561	i0	100	18.0606060606061	165	0	100	0	1	165	839889	840053	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	2980	305	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
12911914	12911914	PRJNA1013345_P_NODE_24751_length_164_cov_0.871795_g24621_i0	PRJNA1013345	24751	164	0.871795	1.4297438	Campylobacter concisus	199	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g24621	i0	97.576	11.0731707317073	165	3	100	1	1	164	621987	622151	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	1816	281	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
15460843	15460843	PRJNA1013345_P_NODE_17793_length_176_cov_2.062016_g17663_i0	PRJNA1013345	17793	176	2.062016	3.62914816	Campylobacter concisus	199	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|1938724023\|gb\|CP060707.1\|	199	g17663	i0	100	17.9602272727273	176	0	100	0	1	176	1836878	1836703	Campylobacter concisus strain P1CDO2 chromosome, complete genome	blastn	3161	326	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16735326	16735326	PRJNA1013345_P_NODE_27874_length_161_cov_0.894737_g27744_i0	PRJNA1013345	27874	161	0.894737	1.44052657	Campylobacter concisus	199	Bacteria	Bacteria	287	3.37e-73	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g27744	i0	98.765	5.01242236024845	162	1	100	1	1	161	1170095	1169934	Campylobacter concisus strain RMIT-O23 chromosome	blastn	807	287	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16735330	16735330	PRJNA1013345_P_NODE_28294_length_160_cov_1.805310_g28164_i0	PRJNA1013345	28294	160	1.80531	2.888496	Campylobacter concisus	199	Bacteria	Bacteria	283	4.32e-72	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g28164	i0	98.742	9.8	159	2	99	0	1	159	298896	299054	Campylobacter concisus strain RMIT-O23 chromosome	blastn	1568	283	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16735364	16735364	PRJNA1013345_P_NODE_29874_length_159_cov_0.910714_g29744_i0	PRJNA1013345	29874	159	0.910714	1.44803526	Campylobacter concisus	199	Bacteria	Bacteria	278	2e-70	NTclustered	gi\|1938717787\|gb\|CP060705.1\|	199	g29744	i0	98.113	15.9496855345912	159	3	100	0	1	159	789558	789716	Campylobacter concisus strain P13UCO-S1 chromosome, complete genome	blastn	2536	278	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
16735418	16735418	PRJNA1013345_P_NODE_33214_length_154_cov_2.457944_g33084_i0	PRJNA1013345	33214	154	2.457944	3.78523376	Campylobacter concisus	199	Bacteria	Bacteria	268	1.15e-67	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g33084	i0	98.052	12.0064935064935	154	3	100	0	1	154	327165	327318	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	1849	268	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19283731	19283731	PRJNA1013345_P_NODE_11976_length_192_cov_3.593103_g11846_i0	PRJNA1013345	11976	192	3.593103	6.89875776	Campylobacter concisus	199	Bacteria	Bacteria	316	5.31e-82	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g11846	i0	96.354	17.84375	192	7	100	0	1	192	1207747	1207556	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	3426	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19283951	19283951	PRJNA1013345_P_NODE_24456_length_164_cov_0.871795_g24326_i0	PRJNA1013345	24456	164	0.871795	1.4297438	Campylobacter concisus	199	Bacteria	Bacteria	274	2.68e-69	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g24326	i0	96.933	10.7987804878049	163	5	99	0	1	163	180829	180667	Campylobacter concisus strain RMIT-O23 chromosome	blastn	1771	274	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20559378	20559378	PRJNA1013345_P_NODE_17517_length_177_cov_1.423077_g17387_i0	PRJNA1013345	17517	177	1.423077	2.51884629	Campylobacter concisus	199	Bacteria	Bacteria	316	4.799999999999999e-82	NTclustered	gi\|2699822930\|gb\|CP147773.1\|	199	g17387	i0	98.87	14.2033898305085	177	2	100	0	1	177	1285937	1285761	Campylobacter concisus strain RMIT-O23 chromosome	blastn	2514	316	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
21834967	21834967	PRJNA1013345_P_NODE_14258_length_184_cov_1.788321_g14128_i0	PRJNA1013345	14258	184	1.788321	3.29051064	Campylobacter concisus	199	Bacteria	Bacteria	329	6.47e-86	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g14128	i0	98.913	21.1684782608696	184	2	100	0	1	184	1196903	1196720	Campylobacter concisus strain RMIT-O23 chromosome	blastn	3895	329	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
21835038	21835038	PRJNA1013345_P_NODE_18538_length_174_cov_3.755906_g18408_i0	PRJNA1013345	18538	174	3.755906	6.53527644	Campylobacter concisus	199	Bacteria	Bacteria	300	4.73e-77	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g18408	i0	97.701	33.0057471264368	174	4	100	0	1	174	1191241	1191068	Campylobacter concisus strain RMIT-O23 chromosome	blastn	5743	300	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
23110688	23110688	PRJNA1013345_P_NODE_28479_length_160_cov_1.353982_g28349_i0	PRJNA1013345	28479	160	1.353982	2.1663712	Campylobacter concisus	199	Bacteria	Bacteria	285	1.2e-72	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g28349	i0	98.75	9.9375	160	2	100	0	1	160	989257	989416	Campylobacter concisus strain RMIT-O23 chromosome	blastn	1590	285	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24384415	24384415	PRJNA1013345_P_NODE_23420_length_165_cov_0.864407_g23290_i0	PRJNA1013345	23420	165	0.864407	1.42627155	Campylobacter concisus	199	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g23290	i0	96.97	10.969696969697	165	5	100	0	1	165	1918155	1918319	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	1810	278	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
24384445	24384445	PRJNA1013345_P_NODE_25360_length_163_cov_0.879310_g25230_i0	PRJNA1013345	25360	163	0.87931	1.4332753	Campylobacter concisus	199	Bacteria	Bacteria	285	1.23e-72	NTclustered	gi\|1938715890\|gb\|CP049263.1\|	199	g25230	i0	98.16	4.01226993865031	163	3	100	0	1	163	103928	104090	Campylobacter concisus strain H16O-S1 chromosome, complete genome	blastn	654	285	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
27509028	27509028	PRJNA1013345_P_NODE_4183_length_292_cov_1.420408_g4054_i0	PRJNA1013345	4183	292	1.420408	4.14759136	Aliarcobacter sp.	2321116	Bacteria	Bacteria	115	3.0099999999999993e-28	NR	MBP6714533.1	2321116	g4054	i0	66.3	0.883561643835616	86	28	88.4	1	280	23	112	196	MBP6714533.1 hypothetical protein [Aliarcobacter sp.]	diamond	258	115	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter sp.
30508807	30508807	PRJNA1013345_P_NODE_22293_length_166_cov_3.823529_g22163_i0	PRJNA1013345	22293	166	3.823529	6.34705814	Helicobacter pylori	210	Bacteria	Bacteria	61.2	4.97e-10	NR	GAA8684133.1	210	g22163	i0	84.2	0.686746987951807	38	5	66.9	1	113	3	2	39	GAA8684133.1 hypothetical protein Kyoto145A_0980 [Helicobacter pylori]	diamond	114	61.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31646527	31646527	PRJNA1013345_P_NODE_33077_length_154_cov_3.654206_g32947_i0	PRJNA1013345	33077	154	3.654206	5.62747724	Helicobacter pylori	210	Bacteria	Bacteria	49.3	2.79e-6	NR	GAA8799114.1	210	g32947	i0	100	0.798701298701299	41	0	79.9	0	152	30	13	53	GAA8799114.1 hypothetical protein Kyoto149A_1670 [Helicobacter pylori]	diamond	123	49.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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