metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA605033" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA605033" 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
26966629	26966629	PRJNA605033_P_NODE_149002_length_195_cov_2.031250_g147433_i0	PRJNA605033	149002	195	2.03125	3.9609375	Bacteria	2	Bacteria	Bacteria	110	6.58e-29	NR	WP_272949338.1	195	g147433	i0	93.8	15.6923076923077	64	4	98.5	0	3	194	79	142	WP_272949338.1 carbon starvation CstA family protein, partial [Campylobacter coli]	diamond	3060	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
26985044	26985044	PRJNA605033_P_NODE_142362_length_201_cov_50.686747_g140793_i0	PRJNA605033	142362	201	50.686747	101.88036147	Helicobacter pylori	210	Bacteria	Bacteria	73.9	7.77e-16	NR	GAA8692375.1	210	g140793	i0	93.8	0.477611940298507	32	2	47.8	0	2	97	14	45	GAA8692375.1 hypothetical protein Kyoto145A_2350 [Helicobacter pylori]	diamond	96	73.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27156106	27156106	PRJNA605033_P_NODE_98882_length_222_cov_1.978610_g97313_i0	PRJNA605033	98882	222	1.97861	4.3925142	Bacteria	2	Bacteria	Bacteria	52.4	1.12e-5	NR	WP_104762197.1	137778	g97313	i0	88	15.2027027027027	25	3	33.8	0	148	222	133	157	WP_104762197.1 GDP-mannose 4,6-dehydratase [Helicobacter aurati]	diamond	3375	52.8	0.992424242424242	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter aurati
27743743	27743743	PRJNA605033_P_NODE_45904_length_245_cov_34.371429_g44336_i0	PRJNA605033	45904	245	34.371429	84.21000105	Helicobacter pylori	210	Bacteria	Bacteria	42	0.0314	NR	GAA9213376.1	210	g44336	i0	94.7	0.23265306122449	19	1	23.3	0	94	150	66	84	GAA9213376.1 hypothetical protein Kyoto198A_2640 [Helicobacter pylori]	diamond	57	42	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27775202	27775202	PRJNA605033_P_NODE_224244_length_157_cov_1.639344_g222675_i0	PRJNA605033	224244	157	1.639344	2.57377008	Helicobacter pylori	210	Bacteria	Bacteria	48.9	1.41e-5	NR	GAA9128289.1	210	g222675	i0	55.8	0.821656050955414	43	19	82.2	0	1	129	60	102	GAA9128289.1 hypothetical protein Kyoto190A_1620 [Helicobacter pylori]	diamond	129	48.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28374876	28374876	PRJNA605033_P_NODE_27566_length_286_cov_2.450199_g26001_i0	PRJNA605033	27566	286	2.450199	7.00756914	Helicobacter pylori	210	Bacteria	Bacteria	40.4	0.0378	NR	GAA9056084.1	210	g26001	i0	65	0.20979020979021	20	7	21	0	12	71	1	20	GAA9056084.1 hypothetical protein Kyoto184A_04520 [Helicobacter pylori]	diamond	60	40.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29038216	29038216	PRJNA605033_P_NODE_16628_length_348_cov_27.543131_g15078_i0	PRJNA605033	16628	348	27.543131	95.85009588	Helicobacter pylori	210	Bacteria	Bacteria	55.1	4.43e-7	NR	GAA9106486.1	210	g15078	i0	97.6	0.706896551724138	82	2	70.7	0	347	102	1	82	GAA9106486.1 hypothetical protein Kyoto184A_09600 [Helicobacter pylori]	diamond	246	55.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29416742	29416742	PRJNA605033_P_NODE_247389_length_150_cov_2.686957_g245820_i0	PRJNA605033	247389	150	2.686957	4.0304355	Helicobacter pylori	210	Bacteria	Bacteria	66.6	5.01e-12	NR	GAA9038119.1	210	g245820	i0	72.9	0.96	48	13	96	0	145	2	53	100	GAA9038119.1 hypothetical protein Kyoto184A_01030 [Helicobacter pylori]	diamond	144	66.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30206219	30206219	PRJNA605033_P_NODE_98192_length_222_cov_1.994652_g96623_i0	PRJNA605033	98192	222	1.994652	4.42812744	Helicobacter pylori	210	Bacteria	Bacteria	51.6	2.95e-6	NR	GAA9128289.1	210	g96623	i0	43.1	1.75675675675676	65	18	87.8	1	222	28	22	67	GAA9128289.1 hypothetical protein Kyoto190A_1620 [Helicobacter pylori]	diamond	390	51.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30333317	30333317	PRJNA605033_P_NODE_8712_length_469_cov_4.576037_g7217_i0	PRJNA605033	8712	469	4.576037	21.46161353	Helicobacter pylori	210	Bacteria	Bacteria	46.6	6.45e-4	NR	GAA8766134.1	210	g7217	i0	90.5	0.134328358208955	21	2	13.4	0	228	290	1	21	GAA8766134.1 hypothetical protein Kyoto147A_4290 [Helicobacter pylori]	diamond	63	46.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30377982	30377982	PRJNA605033_P_NODE_195472_length_167_cov_13.356061_g193903_i0	PRJNA605033	195472	167	13.356061	22.30462187	Pseudomonadati	3379134	Bacteria	Bacteria	58.9	2.14e-9	NR	GAA9176272.1	210	g193903	i0	85.2	1.92215568862275	27	4	48.5	0	158	78	1	27	GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori]	diamond	321	58.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30428068	30428068	PRJNA605033_P_NODE_9193_length_457_cov_3.500000_g7686_i0	PRJNA605033	9193	457	3.5	15.995	Helicobacter pylori	210	Bacteria	Bacteria	58.5	2.02e-8	NR	GAA8732422.1	210	g7686	i0	100	0.183807439824945	28	0	18.4	0	103	186	31	58	GAA8732422.1 hypothetical protein Kyoto147A_0630 [Helicobacter pylori]	diamond	84	58.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30933173	30933173	PRJNA605033_P_NODE_102034_length_222_cov_1.919786_g100465_i0	PRJNA605033	102034	222	1.919786	4.26192492	Campylobacter ureolyticus	827	Bacteria	Bacteria	54.3	2.29e-6	NR	WP_016646312.1	827	g100465	i0	100	0.324324324324324	24	0	32.4	0	221	150	80	103	WP_016646312.1 amidophosphoribosyltransferase [Campylobacter ureolyticus]	diamond	72	54.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter ureolyticus
31534016	31534016	PRJNA605033_P_NODE_48276_length_242_cov_2.033816_g46708_i0	PRJNA605033	48276	242	2.033816	4.92183472	Helicobacter pylori	210	Bacteria	Bacteria	47.8	5.97e-5	NR	GAA9117791.1	210	g46708	i0	95.5	0.272727272727273	22	1	27.3	0	241	176	5	26	GAA9117791.1 hypothetical protein Kyoto184A_10260 [Helicobacter pylori]	diamond	66	47.8	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);;