metadata: contig_metadata: 27 rows where bioproject = "PRJNA473799" and tax

27 rows where bioproject = "PRJNA473799" 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
3646720	3646720	PRJNA473799_P_NODE_16023_length_287_cov_1.233645_g15749_i0	PRJNA473799	16023	287	1.233645	3.54056115	root	1	Root_unresolved	Root_unresolved	525	1.2999999999999995e-144	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g15749	i0	99.652	100	287	1	100	0	1	287	698300	698586	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	28700	525	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
4923786	4923786	PRJNA473799_P_NODE_22284_length_274_cov_1.044776_g22010_i0	PRJNA473799	22284	274	1.044776	2.86268624	Campylobacter	194	Bacteria	Bacteria	470	5.859999999999999e-128	NTclustered	gi\|1376251231\|gb\|CP021642.1\|	199	g22010	i0	97.794	12.9233576642336	272	6	99	0	3	274	343183	343454	Campylobacter concisus strain P2CDO4 chromosome, complete genome	blastn	3541	470	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
9373557	9373557	PRJNA473799_P_NODE_41608_length_247_cov_1.747126_g41334_i0	PRJNA473799	41608	247	1.747126	4.31540122	Campylobacter ureolyticus	827	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|909715533\|gb\|CP012195.1\|	1032069	g41334	i0	98.381	5.7085020242915	247	4	100	0	1	247	206444	206690	Campylobacter ureolyticus RIGS 9880 chromosome, complete genome	blastn	1410	435	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
10023978	10023978	PRJNA473799_P_NODE_29388_length_260_cov_1.267380_g29114_i0	PRJNA473799	29388	260	1.26738	3.295188	Arcobacteraceae	2808963	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|1847324382\|gb\|CP053840.1\|	1054033	g29114	i0	100	407.753846153846	260	0	100	0	1	260	2091765	2091506	Arcobacter venerupis strain LMG 26156 chromosome, complete genome	blastn	106016	481	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter venerupis
11924338	11924338	PRJNA473799_P_NODE_34630_length_251_cov_1.179775_g34356_i0	PRJNA473799	34630	251	1.179775	2.96123525	Arcobacter porcinus	1935204	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1739646276\|gb\|CP036246.2\|	1935204	g34356	i0	100	0.235059760956175	30	0	12	0	11	40	1286053	1286024	Arcobacter porcinus strain CCUG 56899 chromosome, complete genome	blastn	59	56.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter porcinus
14474319	14474319	PRJNA473799_P_NODE_36852_length_250_cov_0.870056_g36578_i0	PRJNA473799	36852	250	0.870056	2.17514	Campylobacter showae	204	Bacteria	Bacteria	196	9.88e-46	NTclustered	gi\|1483583541\|emb\|LT631465.1\|	204	g36578	i0	82.553	5.256	235	30	93	8	5	237	7111	7336	Campylobacter showae strain 129_VTPP genome assembly, plasmid: VI	blastn	1314	196	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
18297308	18297308	PRJNA473799_P_NODE_34955_length_251_cov_0.865169_g34681_i0	PRJNA473799	34955	251	0.865169	2.17157419	Campylobacter curvus	200	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|1861373391\|gb\|CP053826.1\|	200	g34681	i0	79.518	1.9840637450199201	249	45	98	5	4	249	1680812	1680567	Campylobacter curvus strain ATCC 35224 chromosome, complete genome	blastn	498	172	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter curvus
18297567	18297567	PRJNA473799_P_NODE_53855_length_241_cov_0.916667_g53581_i0	PRJNA473799	53855	241	0.916667	2.20916747	Campylobacter jejuni	197	Bacteria	Bacteria	368	1.9e-97	NTclustered	gi\|972488604\|gb\|CP010480.1\|	197	g53581	i0	94.191	78.1659751037344	241	14	100	0	1	241	1662600	1662360	Campylobacter jejuni strain CJ677CC524, complete genome	blastn	18838	368	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
18947045	18947045	PRJNA473799_P_NODE_14975_length_289_cov_1.740741_g14701_i0	PRJNA473799	14975	289	1.740741	5.03074149	Campylobacter	194	Bacteria	Bacteria	529	1.01e-145	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g14701	i0	99.654	236.349480968858	289	1	100	0	1	289	1634	1922	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	68305	529	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
19571642	19571642	PRJNA473799_P_NODE_4856_length_573_cov_4.816000_g4591_i0	PRJNA473799	4856	573	4.816	27.59568	Campylobacter showae	204	Bacteria	Bacteria	1059	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g4591	i0	100	233.987783595113	573	0	100	0	1	573	390118	389546	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	134075	1059	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
23397782	23397782	PRJNA473799_P_NODE_2619_length_877_cov_5.144279_g2388_i0	PRJNA473799	2619	877	5.144279	45.11532683	Campylobacter showae	204	Bacteria	Bacteria	1565	0	NTclustered	gi\|1483583529\|emb\|LT631453.1\|	204	g2388	i0	98.861	252.009122006841	878	9	100	1	1	877	390091	390968	Campylobacter showae strain B91_SCBr genome assembly, chromosome: I	blastn	221012	1565	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae
24671818	24671818	PRJNA473799_P_NODE_38160_length_249_cov_1.193182_g37886_i0	PRJNA473799	38160	249	1.193182	2.97102318	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	86.1	2.22e-12	NTclustered	gi\|682122801\|gb\|KJ739652.1\|	165434	g37886	i0	88.571	29.6064257028112	70	8	28	0	180	249	6	75	Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence	blastn	7372	86.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
26633029	26633029	PRJNA473799_P_NODE_5581_length_513_cov_1.527273_g5314_i0	PRJNA473799	5581	513	1.527273	7.83491049	Helicobacter pylori	210	Bacteria	Bacteria	55.8	1.32e-6	NR	GAA6899797.1	210	g5314	i0	49.2	0.35672514619883	61	31	35.7	0	179	361	54	114	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	183	55.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27282080	27282080	PRJNA473799_P_NODE_36723_length_250_cov_0.870056_g36449_i0	PRJNA473799	36723	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	50.4	6.36e-6	NR	GAA8684589.1	210	g36449	i0	55.8	4.272	52	21	61.2	2	240	88	1	51	GAA8684589.1 hypothetical protein Kyoto145A_1090 [Helicobacter pylori]	diamond	1068	50.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28023837	28023837	PRJNA473799_P_NODE_35365_length_251_cov_0.865169_g35091_i0	PRJNA473799	35365	251	0.865169	2.17157419	Helicobacter pylori	210	Bacteria	Bacteria	57.4	1.29e-8	NR	GAA8860838.1	210	g35091	i0	53.2	0.561752988047809	47	22	56.2	0	217	77	12	58	GAA8860838.1 hypothetical protein Kyoto154A_2730 [Helicobacter pylori]	diamond	141	57.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28023839	28023839	PRJNA473799_P_NODE_40545_length_248_cov_0.880000_g40271_i0	PRJNA473799	40545	248	0.88	2.1824	Helicobacter pylori	210	Bacteria	Bacteria	58.2	1.14e-7	NR	GAA6899356.1	210	g40271	i0	63.4	1.51209677419355	41	15	49.6	0	240	118	219	259	GAA6899356.1 hypothetical protein Kyoto207A_1070 [Helicobacter pylori]	diamond	375	58.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28812765	28812765	PRJNA473799_P_NODE_43968_length_246_cov_0.890173_g43694_i0	PRJNA473799	43968	246	0.890173	2.18982558	Helicobacter pylori	210	Bacteria	Bacteria	44.3	0.00201	NR	GAA8955309.1	210	g43694	i0	48.9	0.548780487804878	45	21	52.4	1	15	143	27	71	GAA8955309.1 hypothetical protein Kyoto181A_2860 [Helicobacter pylori]	diamond	135	44.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29744643	29744643	PRJNA473799_P_NODE_7970_length_383_cov_1.848387_g7696_i0	PRJNA473799	7970	383	1.848387	7.07932221	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.00555	NR	GAA6864469.1	210	g7696	i0	46.2	0.618798955613577	39	21	30.5	0	267	151	5	43	GAA6864469.1 hypothetical protein Kyoto206A_2160 [Helicobacter pylori]	diamond	237	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30138993	30138993	PRJNA473799_P_NODE_10692_length_322_cov_1.590361_g10418_i0	PRJNA473799	10692	322	1.590361	5.12096242	Helicobacter pylori	210	Bacteria	Bacteria	73.6	4.96e-15	NR	GAA8838853.1	210	g10418	i0	79.1	0.400621118012422	43	9	40.1	0	47	175	1	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	129	73.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30424139	30424139	PRJNA473799_P_NODE_12553_length_307_cov_1.123932_g12279_i0	PRJNA473799	12553	307	1.123932	3.45047124	Helicobacter pylori	210	Bacteria	Bacteria	41.2	0.0318	NR	GAA9005118.1	210	g12279	i0	54.8	0.41042345276873	42	19	41	0	248	123	12	53	GAA9005118.1 hypothetical protein Kyoto181A_6770 [Helicobacter pylori]	diamond	126	41.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30487033	30487033	PRJNA473799_P_NODE_22073_length_274_cov_1.487562_g21799_i0	PRJNA473799	22073	274	1.487562	4.07591988	Helicobacter pylori	210	Bacteria	Bacteria	66.6	3.8e-12	NR	GAA8798126.1	210	g21799	i0	87.5	1.02919708029197	32	4	35	0	247	152	1	32	GAA8798126.1 hypothetical protein Kyoto149A_1450 [Helicobacter pylori]	diamond	282	66.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30518519	30518519	PRJNA473799_P_NODE_40733_length_248_cov_0.880000_g40459_i0	PRJNA473799	40733	248	0.88	2.1824	Helicobacter pylori	210	Bacteria	Bacteria	43.9	9.92e-4	NR	GAA9117035.1	210	g40459	i0	61.5	0.314516129032258	26	10	31.5	0	169	246	4	29	GAA9117035.1 hypothetical protein Kyoto184A_10210 [Helicobacter pylori]	diamond	78	43.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31656251	31656251	PRJNA473799_P_NODE_36757_length_250_cov_0.870056_g36483_i0	PRJNA473799	36757	250	0.870056	2.17514	Helicobacter pylori	210	Bacteria	Bacteria	46.6	7.56e-4	NR	GAA9246114.1	210	g36483	i0	54.8	0.504	42	19	50.4	0	150	25	110	151	GAA9246114.1 hypothetical protein Kyoto199A_0250 [Helicobacter pylori]	diamond	126	46.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31672545	31672545	PRJNA473799_P_NODE_8937_length_356_cov_1.307420_g8663_i0	PRJNA473799	8937	356	1.30742	4.6544152	Bacteria	2	Bacteria	Bacteria	50.8	2.99e-5	NR	GAA6899797.1	210	g8663	i0	51	0.851123595505618	51	25	43	0	162	10	54	104	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	303	50.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32036046	32036046	PRJNA473799_P_NODE_32178_length_255_cov_1.379121_g31904_i0	PRJNA473799	32178	255	1.379121	3.51675855	Helicobacter pylori	210	Bacteria	Bacteria	54.3	2.2e-7	NR	GAA8992044.1	210	g31904	i0	75	0.8	32	8	37.6	0	61	156	1	32	GAA8992044.1 hypothetical protein Kyoto181A_6080 [Helicobacter pylori]	diamond	204	54.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32479247	32479247	PRJNA473799_P_NODE_48939_length_244_cov_0.883041_g48665_i0	PRJNA473799	48939	244	0.883041	2.15462004	Helicobacter pylori	210	Bacteria	Bacteria	40.8	0.0208	NR	GAA9192930.1	210	g48665	i0	72	0.307377049180328	25	7	30.7	0	152	226	20	44	GAA9192930.1 hypothetical protein Kyoto193A_3770 [Helicobacter pylori]	diamond	75	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32511015	32511015	PRJNA473799_P_NODE_25399_length_267_cov_2.597938_g25125_i0	PRJNA473799	25399	267	2.597938	6.93649446	Helicobacter pylori	210	Bacteria	Bacteria	76.3	1.39e-15	NR	GAA6899797.1	210	g25125	i0	67.8	1.40449438202247	59	19	66.3	0	263	87	59	117	GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori]	diamond	375	76.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);;