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

14 rows where analysis = "diamond", bioproject = "PRJNA1249535" 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
26789054	26789054	PRJNA1249535_S_NODE_301601_length_252_cov_1.307263_g298218_i0	PRJNA1249535	301601	252	1.307263	3.29430276	Helicobacter pylori	210	Bacteria	Bacteria	42.4	0.00535	NR	GAA8827101.1	210	g298218	i0	56.8	0.44047619047619	37	16	44	0	195	85	12	48	GAA8827101.1 hypothetical protein Kyoto149A_4360 [Helicobacter pylori]	diamond	111	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27217884	27217884	PRJNA1249535_S_NODE_314602_length_245_cov_2.267442_g311219_i0	PRJNA1249535	314602	245	2.267442	5.5552329	Campylobacterales	213849	Bacteria	Bacteria	45.8	0.00317	NR	PNV84459.1	2022749	g311219	i0	53.5	2.93877551020408	43	20	52.7	0	70	198	201	243	PNV84459.1 MAG: hypothetical protein C0627_00860 [Sulfurimonas sp.]	diamond	720	46.2	0.991341991341991	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
27484568	27484568	PRJNA1249535_S_NODE_57343_length_454_cov_2.023622_g53980_i0	PRJNA1249535	57343	454	2.023622	9.18724388	Campylobacterota bacterium	2026809	Bacteria	Bacteria	45.8	0.024	NR	NOX16478.1	2026809	g53980	i0	39.7	0.383259911894273	58	32	38.3	1	255	428	336	390	NOX16478.1 lactate utilization protein [Campylobacterota bacterium]	diamond	174	45.8	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
27547705	27547705	PRJNA1249535_S_NODE_67224_length_426_cov_5.184136_g63845_i0	PRJNA1249535	67224	426	5.184136	22.08441936	Sulfurovum sp.	1969726	Bacteria	Bacteria	57	2.52e-6	NR	MCB4751197.1	1969726	g63845	i0	43.5	7.05633802816901	62	35	43.7	0	424	239	357	418	MCB4751197.1 hypothetical protein [Sulfurovum sp.]	diamond	3006	57	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
27737426	27737426	PRJNA1249535_S_NODE_261344_length_274_cov_1.552239_g257961_i0	PRJNA1249535	261344	274	1.552239	4.25313486	Campylobacter sp. CCUG 5731	205	Bacteria	Bacteria	43.5	0.0262	NR	WP_173030823.1	2517362	g257961	i0	37.3	0.733576642335766	67	41	73.4	1	272	72	16	81	WP_173030823.1 ferrochelatase [Campylobacter sp. CCUG 57310]	diamond	201	43.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter sp. CCUG 57310
27818414	27818414	PRJNA1249535_S_NODE_228684_length_291_cov_3.174312_g225301_i0	PRJNA1249535	228684	291	3.174312	9.23724792	Campylobacterales	213849	Bacteria	Bacteria	43.5	0.034	NR	MEN8718543.1	1969726	g225301	i0	42.9	1.01030927835052	49	28	50.5	0	263	117	175	223	MEN8718543.1 PLP-dependent transferase [Sulfurovum sp.]	diamond	294	43.9	0.990888382687927	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
27831780	27831780	PRJNA1249535_S_NODE_245904_length_282_cov_2.559809_g242521_i0	PRJNA1249535	245904	282	2.559809	7.21866138	Helicobacter pylori GAM254Ai	1159043	Bacteria	Bacteria	40.8	0.0424	NR	EMH18459.1	1159043	g242521	i0	33.3	0.542553191489362	51	34	54.3	0	170	18	10	60	EMH18459.1 hypothetical protein HMPREF1415_01076 [Helicobacter pylori GAM254Ai]	diamond	153	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28021500	28021500	PRJNA1249535_S_NODE_41625_length_512_cov_2.820046_g38309_i0	PRJNA1249535	41625	512	2.820046	14.43863552	unclassified Campylobacter	2593542	Bacteria	Bacteria	50.4	9.16e-4	NR	WP_150140292.1	2593542	g38309	i0	38.5	0.380859375	65	38	36.9	1	233	45	162	226	WP_150140292.1 MULTISPECIES: MFS transporter [unclassified Campylobacter]	diamond	195	50.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter
28178939	28178939	PRJNA1249535_S_NODE_337426_length_227_cov_3.090909_g334043_i0	PRJNA1249535	337426	227	3.090909	7.01636343	Campylobacteraceae bacterium	2268179	Bacteria	Bacteria	48.5	2.19e-4	NR	NQY53283.1	2268179	g334043	i0	48	1.33480176211454	50	25	66.1	1	56	205	95	143	NQY53283.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	303	48.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
30691928	30691928	PRJNA1249535_S_NODE_251833_length_279_cov_2.140777_g248450_i0	PRJNA1249535	251833	279	2.140777	5.9727678299999996	root	1	Root_unresolved	Root_unresolved	56.2	2.99e-7	NR	GAA9176321.1	210	g248450	i0	48	3.18279569892473	75	38	80.6	1	256	32	88	161	GAA9176321.1 hypothetical protein Kyoto193A_0510 [Helicobacter pylori]	diamond	888	56.6	0.992932862190813	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31084757	31084757	PRJNA1249535_S_NODE_130595_length_348_cov_4.476364_g127212_i0	PRJNA1249535	130595	348	4.476364	15.57774672	Helicobacter pylori	210	Bacteria	Bacteria	43.1	0.00682	NR	GAA9088370.1	210	g127212	i0	54.8	0.267241379310345	31	14	26.7	0	93	1	2	32	GAA9088370.1 hypothetical protein Kyoto184A_08190 [Helicobacter pylori]	diamond	93	43.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31527501	31527501	PRJNA1249535_S_NODE_110676_length_364_cov_5.237113_g107293_i0	PRJNA1249535	110676	364	5.237113	19.06309132	Campylobacterota bacterium	2026809	Bacteria	Bacteria	42	0.0401	NR	MCI0501633.1	2026809	g107293	i0	35.8	0.436813186813187	53	32	43.7	1	223	65	11	61	MCI0501633.1 hypothetical protein [Campylobacterota bacterium]	diamond	159	42	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
31653792	31653792	PRJNA1249535_S_NODE_264737_length_272_cov_2.170854_g261354_i0	PRJNA1249535	264737	272	2.170854	5.90472288	Sulfurimonas sp.	2022749	Bacteria	Bacteria	43.1	0.0363	NR	MDB2562000.1	2022749	g261354	i0	35.1	0.628676470588235	57	36	61.8	1	214	47	44	100	MDB2562000.1 hypothetical protein [Sulfurimonas sp.]	diamond	171	43.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
32665837	32665837	PRJNA1249535_S_NODE_297420_length_254_cov_2.193370_g294037_i0	PRJNA1249535	297420	254	2.19337	5.5711598	Campylobacterales bacterium	2268180	Bacteria	Bacteria	71.2	3.4e-12	NR	MBY0539905.1	2268180	g294037	i0	67.3	0.649606299212598	55	16	65	1	249	85	333	385	MBY0539905.1 DDE-type integrase/transposase/recombinase [Campylobacterales bacterium]	diamond	165	71.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium

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