metadata: contig_metadata: 23 rows where bioproject = "PRJNA1093008" and tax

23 rows where bioproject = "PRJNA1093008" 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
8672401	8672401	PRJNA1093008_S_NODE_9267_length_453_cov_3.631579_g8942_i0	PRJNA1093008	9267	453	3.631579	16.45105287	root	1	Root_unresolved	Root_unresolved	813	0	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g8942	i0	99.553	98.6754966887417	447	1	98	1	1	446	698469	698023	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	44700	813	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
15501614	15501614	PRJNA1093008_S_NODE_8893_length_458_cov_9.600000_g8568_i0	PRJNA1093008	8893	458	9.6	43.968	Helicobacter pylori	210	Bacteria	Bacteria	168	4.05e-51	NR	WP_322538256.1	210	g8568	i0	96.4	0.550218340611354	84	3	55	0	23	274	24	107	WP_322538256.1 hypothetical protein, partial [Helicobacter pylori]	diamond	252	168	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
21421128	21421128	PRJNA1093008_S_NODE_64437_length_272_cov_1.482412_g64110_i0	PRJNA1093008	64437	272	1.482412	4.03216064	root	1	Root_unresolved	Root_unresolved	71.3	6.89e-8	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g64110	i0	92.157	18.6948529411765	51	2	19	2	3	53	685132	685180	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	5085	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
21875634	21875634	PRJNA1093008_S_NODE_70798_length_263_cov_3.647368_g70471_i0	PRJNA1093008	70798	263	3.647368	9.59257784	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g70471	i0	100	0.106463878326996	28	0	11	0	139	166	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
23971304	23971304	PRJNA1093008_S_NODE_39279_length_315_cov_1.475207_g38952_i0	PRJNA1093008	39279	315	1.475207	4.64690205	root	1	Root_unresolved	Root_unresolved	80.5	1.35e-10	NTclustered	gi\|2222034613\|gb\|CP094108.1\|	210	g38952	i0	92.857	15.9650793650794	56	2	18	1	260	315	685180	685127	Helicobacter pylori strain Hpfe073 chromosome, complete genome	blastn	5029	80.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
26963894	26963894	PRJNA1093008_S_NODE_80902_length_251_cov_4.325843_g80575_i0	PRJNA1093008	80902	251	4.325843	10.857865930000001	root	1	Root_unresolved	Root_unresolved	42.4	0.00781	NR	GAA9043165.1	210	g80575	i0	55	1.06374501992032	40	13	46.6	2	126	10	15	50	GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori]	diamond	267	42.7	0.992974238875878	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27288834	27288834	PRJNA1093008_S_NODE_26263_length_349_cov_3.369565_g25936_i0	PRJNA1093008	26263	349	3.369565	11.75978185	Helicobacter pylori	210	Bacteria	Bacteria	132	1.4e-37	NR	WP_322538256.1	210	g25936	i0	68.8	0.825214899713467	96	30	82.5	0	3	290	12	107	WP_322538256.1 hypothetical protein, partial [Helicobacter pylori]	diamond	288	132	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27352317	27352317	PRJNA1093008_S_NODE_85783_length_248_cov_1.245714_g85456_i0	PRJNA1093008	85783	248	1.245714	3.08937072	Campylobacter coli	195	Bacteria	Bacteria	50.8	3.52e-6	NR	RJF75347.1	195	g85456	i0	60	1.64516129032258	50	19	59.3	1	29	175	20	69	RJF75347.1 hypothetical protein D4Z77_08730, partial [Campylobacter coli]	diamond	408	50.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
27888757	27888757	PRJNA1093008_S_NODE_68485_length_266_cov_3.310881_g68158_i0	PRJNA1093008	68485	266	3.310881	8.80694346	Helicobacter pylori	210	Bacteria	Bacteria	47.4	5.24e-5	NR	GAA9208732.1	210	g68158	i0	47.4	0.428571428571429	38	20	42.9	0	124	237	1	38	GAA9208732.1 hypothetical protein Kyoto198A_1180 [Helicobacter pylori]	diamond	114	47.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28132938	28132938	PRJNA1093008_S_NODE_47525_length_298_cov_2.666667_g47198_i0	PRJNA1093008	47525	298	2.666667	7.94666766	Pseudomonadati	3379134	Bacteria	Bacteria	47	3.28e-4	NR	WP_240373706.1	195	g47198	i0	87.5	0.483221476510067	24	3	24.2	0	224	295	40	63	WP_240373706.1 hypothetical protein, partial [Campylobacter coli]	diamond	144	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
28836023	28836023	PRJNA1093008_S_NODE_75648_length_257_cov_2.929348_g75321_i0	PRJNA1093008	75648	257	2.929348	7.52842436	Helicobacter pylori	210	Bacteria	Bacteria	51.2	2.4e-6	NR	GAA8950830.1	210	g75321	i0	59	0.455252918287938	39	13	43.2	2	94	204	2	39	GAA8950830.1 hypothetical protein Kyoto181A_1710 [Helicobacter pylori]	diamond	117	51.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29751454	29751454	PRJNA1093008_S_NODE_66771_length_269_cov_1.178571_g66444_i0	PRJNA1093008	66771	269	1.178571	3.17035599	Helicobacter pylori	210	Bacteria	Bacteria	52.8	2.47e-6	NR	GAA9039918.1	210	g66444	i0	39.7	4.9182156133829	78	45	85.9	2	266	36	47	123	GAA9039918.1 hypothetical protein Kyoto184A_01840 [Helicobacter pylori]	diamond	1323	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30257508	30257508	PRJNA1093008_S_NODE_46592_length_300_cov_1.541850_g46265_i0	PRJNA1093008	46592	300	1.54185	4.62555	Helicobacter pylori	210	Bacteria	Bacteria	41.6	0.0196	NR	GAA9046884.1	210	g46265	i0	66.7	0.21	21	7	21	0	67	5	24	44	GAA9046884.1 hypothetical protein Kyoto184A_03270 [Helicobacter pylori]	diamond	63	41.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30572872	30572872	PRJNA1093008_S_NODE_17433_length_387_cov_1.471338_g17106_i0	PRJNA1093008	17433	387	1.471338	5.69407806	Helicobacter pylori	210	Bacteria	Bacteria	51.2	7.86e-5	NR	GAA9039287.1	210	g17106	i0	63.6	3.37984496124031	33	12	25.6	0	237	139	35	67	GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori]	diamond	1308	51.6	0.992248062015504	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31363338	31363338	PRJNA1093008_S_NODE_92156_length_243_cov_2.623529_g91829_i0	PRJNA1093008	92156	243	2.623529	6.37517547	Helicobacter pylori	210	Bacteria	Bacteria	57	2.27e-7	NR	GAA9208704.1	210	g91829	i0	58.5	0.506172839506173	41	17	50.6	0	136	14	20	60	GAA9208704.1 hypothetical protein Kyoto198A_1170 [Helicobacter pylori]	diamond	123	57	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31679348	31679348	PRJNA1093008_S_NODE_89297_length_245_cov_2.767442_g88970_i0	PRJNA1093008	89297	245	2.767442	6.7802329	Helicobacter pylori	210	Bacteria	Bacteria	40.8	0.0359	NR	GAA8909605.1	210	g88970	i0	60.7	0.342857142857143	28	11	34.3	0	162	245	26	53	GAA8909605.1 hypothetical protein Kyoto166A_1730 [Helicobacter pylori]	diamond	84	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31742612	31742612	PRJNA1093008_S_NODE_23697_length_358_cov_4.389474_g23370_i0	PRJNA1093008	23697	358	4.389474	15.71431692	Helicobacter pylori	210	Bacteria	Bacteria	44.3	0.00465	NR	GAA9237335.1	210	g23370	i0	50	0.385474860335196	46	23	38.5	0	140	3	15	60	GAA9237335.1 hypothetical protein Kyoto198A_5510 [Helicobacter pylori]	diamond	138	44.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32185751	32185751	PRJNA1093008_S_NODE_18038_length_384_cov_1.209003_g17711_i0	PRJNA1093008	18038	384	1.209003	4.64257152	Helicobacter pylori	210	Bacteria	Bacteria	47	0.0028	NR	GAA9039287.1	210	g17711	i0	34.1	0.6875	88	54	68	2	342	82	5	89	GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori]	diamond	264	47	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32249296	32249296	PRJNA1093008_S_NODE_87858_length_246_cov_2.763006_g87531_i0	PRJNA1093008	87858	246	2.763006	6.79699476	Helicobacter pylori	210	Bacteria	Bacteria	52	1.94e-6	NR	GAA8698675.1	210	g87531	i0	41.2	0.829268292682927	68	37	79.3	2	244	50	3	70	GAA8698675.1 hypothetical protein Kyoto145A_3040 [Helicobacter pylori]	diamond	204	52	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32280811	32280811	PRJNA1093008_S_NODE_62679_length_274_cov_2.298507_g62352_i0	PRJNA1093008	62679	274	2.298507	6.29790918	Helicobacter pylori	210	Bacteria	Bacteria	50.8	4.9e-6	NR	GAA6884742.1	210	g62352	i0	55.1	0.536496350364963	49	21	52.6	1	238	95	13	61	GAA6884742.1 hypothetical protein Kyoto206A_4980 [Helicobacter pylori]	diamond	147	50.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32344115	32344115	PRJNA1093008_S_NODE_55899_length_284_cov_2.189573_g55572_i0	PRJNA1093008	55899	284	2.189573	6.21838732	Sulfurovum sp.	1969726	Bacteria	Bacteria	45.1	0.00898	NR	MCB4762203.1	1969726	g55572	i0	42.9	3.62323943661972	49	26	49.6	1	281	141	60	108	MCB4762203.1 hypothetical protein [Sulfurovum sp.]	diamond	1029	45.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
32502322	32502322	PRJNA1093008_S_NODE_90839_length_244_cov_2.175439_g90512_i0	PRJNA1093008	90839	244	2.175439	5.30807116	Helicobacter pylori	210	Bacteria	Bacteria	40	0.0473	NR	GAA6873347.1	210	g90512	i0	56.7	0.368852459016393	30	13	36.9	0	172	83	18	47	GAA6873347.1 hypothetical protein Kyoto206A_3820 [Helicobacter pylori]	diamond	90	40	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32754289	32754289	PRJNA1093008_S_NODE_96440_length_240_cov_3.628743_g96113_i0	PRJNA1093008	96440	240	3.628743	8.7089832	Helicobacter pylori	210	Bacteria	Bacteria	39.7	0.0415	NR	GAA8956022.1	210	g96113	i0	62.1	0.3625	29	11	36.3	0	30	116	13	41	GAA8956022.1 hypothetical protein Kyoto181A_3010 [Helicobacter pylori]	diamond	87	39.7	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);;