metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA816047" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA816047" 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
25595958	25595958	PRJNA816047a_S_NODE_74113_length_248_cov_1.805714_g71453_i0	PRJNA816047	74113	248	1.805714	4.47817072	Campylobacter jejuni	197	Bacteria	Bacteria	134	2.3e-39	NR	MBP0443134.1	197	g71453	i0	98.6	0.870967741935484	72	1	87.1	0	227	12	1	72	MBP0443134.1 hypothetical protein [Campylobacter jejuni]	diamond	216	134	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
25728595	25728595	PRJNA816047a_S_NODE_31850_length_365_cov_20967.253425_g29190_i0	PRJNA816047	31850	365	20967.253425	76530.47500125	Desulfurellales bacterium	2482794	Bacteria	Bacteria	159	2.81e-47	NR	TXH58056.1	2482794	g29190	i0	71.9	1.69315068493151	114	30	92.1	1	21	356	1	114	TXH58056.1 MAG: hypothetical protein E6Q97_03180 [Desulfurellales bacterium]	diamond	618	159	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
26280102	26280102	PRJNA816047b_S_NODE_46342_length_253_cov_1.511111_g44030_i0	PRJNA816047	46342	253	1.511111	3.82311083	Campylobacter jejuni	197	Bacteria	Bacteria	115	8.26e-28	NR	EOH1988368.1	197	g44030	i0	96.4	0.66403162055336	56	2	66.4	0	47	214	590	645	EOH1988368.1 phage tail protein [Campylobacter jejuni]	diamond	168	115	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
26420280	26420280	PRJNA816047d_S_NODE_37711_length_350_cov_2.272727_g35876_i0	PRJNA816047	37711	350	2.272727	7.9545445	Pseudomonadati	3379134	Bacteria	Bacteria	133	2.8e-38	NR	MCH3765105.1	195	g35876	i0	97.1	1.16571428571429	68	2	58.3	0	145	348	1	68	MCH3765105.1 hypothetical protein [Campylobacter coli]	diamond	408	133	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
26555333	26555333	PRJNA816047d_S_NODE_22088_length_462_cov_2.540342_g20267_i0	PRJNA816047	22088	462	2.540342	11.73638004	Campylobacter jejuni	197	Bacteria	Bacteria	119	3.1599999999999997e-32	NR	MBP0443134.1	197	g20267	i0	100	0.409090909090909	63	0	40.9	0	189	1	1	63	MBP0443134.1 hypothetical protein [Campylobacter jejuni]	diamond	189	119	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
32973522	32973522	PRJNA816047d_S_NODE_44730_length_326_cov_3.769231_g42895_i0	PRJNA816047	44730	326	3.769231	12.28769306	Halarcobacter mediterraneus	2023153	Bacteria	Bacteria	72.8	1.74e-12	NR	WP_129061275.1	2023153	g42895	i0	59.6	0.975460122699387	52	21	47.9	0	244	89	4	55	WP_129061275.1 6-phosphofructokinase [Halarcobacter mediterraneus]	diamond	318	72.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter mediterraneus
33007614	33007614	PRJNA816047d_S_NODE_71347_length_272_cov_2.890411_g69512_i0	PRJNA816047	71347	272	2.890411	7.86191792	Sulfurovum sp.	1969726	Bacteria	Bacteria	60.8	2.24e-8	NR	MCB4782643.1	1969726	g69512	i0	34.3	6.72794117647059	67	44	73.9	0	204	4	135	201	MCB4782643.1 reverse transcriptase family protein [Sulfurovum sp.]	diamond	1830	60.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
33058274	33058274	PRJNA816047d_S_NODE_115741_length_243_cov_1.021053_g113906_i0	PRJNA816047	115741	243	1.021053	2.48115879	Helicobacter pylori	210	Bacteria	Bacteria	48.9	3.2e-5	NR	GAA8734158.1	210	g113906	i0	82.1	0.345679012345679	28	5	34.6	0	236	153	1	28	GAA8734158.1 hypothetical protein Kyoto147A_1520 [Helicobacter pylori]	diamond	84	48.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33075089	33075089	PRJNA816047b_S_NODE_14797_length_407_cov_1.437126_g12487_i0	PRJNA816047	14797	407	1.437126	5.84910282	Desulfurellales bacterium	2482794	Bacteria	Bacteria	160	1.2e-47	NR	TXH58056.1	2482794	g12487	i0	80.4	2.13759213759214	97	19	71.5	0	5	295	52	148	TXH58056.1 MAG: hypothetical protein E6Q97_03180 [Desulfurellales bacterium]	diamond	870	160	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
33075749	33075749	PRJNA816047d_S_NODE_60493_length_290_cov_3.696203_g58658_i0	PRJNA816047	60493	290	3.696203	10.7189887	Sulfurovum sp.	1969726	Bacteria	Bacteria	159	1.0199999999999999e-43	NR	MDD3500783.1	1969726	g58658	i0	89.2	0.858620689655172	83	9	85.9	0	269	21	387	469	MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.]	diamond	249	159	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
33075828	33075828	PRJNA816047d_S_NODE_72549_length_270_cov_151.391705_g70714_i0	PRJNA816047	72549	270	151.391705	408.7576035	Helicobacter pylori	210	Bacteria	Bacteria	80.1	6.68e-18	NR	GAA8838853.1	210	g70714	i0	92.5	0.444444444444444	40	3	44.4	0	269	150	4	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	120	80.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
33143309	33143309	PRJNA816047a_S_NODE_74247_length_248_cov_1.337143_g71587_i0	PRJNA816047	74247	248	1.337143	3.31611464	Campylobacter jejuni	197	Bacteria	Bacteria	147	3.69e-44	NR	WP_240386170.1	197	g71587	i0	96.2	1.91129032258065	79	3	95.6	0	238	2	11	89	WP_240386170.1 hypothetical protein, partial [Campylobacter jejuni]	diamond	474	147	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni

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