metadata: contig_metadata: 6 rows where bioproject = "PRJNA1008624", tax_kingdom = "Pseudomonadati" and tax

6 rows where bioproject = "PRJNA1008624", tax_kingdom = "Pseudomonadati" 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
2704971	2704971	PRJNA1008624_P_NODE_8723_length_283_cov_1.952991_g8535_i0	PRJNA1008624	8723	283	1.952991	5.52696453	Campylobacter coli	195	Bacteria	Bacteria	200	1.3800000000000002e-64	NR	MCH3765060.1	195	g8535	i0	97.9	0.996466431095406	94	2	99.6	0	1	282	2	95	MCH3765060.1 cupin domain-containing protein [Campylobacter coli]	diamond	282	200	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
28329336	28329336	PRJNA1008624_P_NODE_3906_length_433_cov_5.335938_g3720_i0	PRJNA1008624	3906	433	5.335938	23.10461154	Malaciobacter pacificus	1080223	Bacteria	Bacteria	119	8.66e-32	NR	WP_130233966.1	1080223	g3720	i0	53.2	1.53117782909931	109	47	75.5	1	372	46	1	105	WP_130233966.1 putative quinol monooxygenase [Malaciobacter pacificus]	diamond	663	119	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter pacificus
28582157	28582157	PRJNA1008624_P_NODE_23787_length_179_cov_1.230769_g23599_i0	PRJNA1008624	23787	179	1.230769	2.20307651	Helicobacter sp. 12S	218	Bacteria	Bacteria	51.2	1.41e-5	NR	WP_095225561.1	1476199	g23599	i0	49.2	0.988826815642458	59	26	97.2	3	4	177	68	123	WP_095225561.1 phosphatidylserine decarboxylase [Helicobacter sp. 12S02634-8]	diamond	177	51.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp. 12S02634-8
29710825	29710825	PRJNA1008624_P_NODE_34570_length_163_cov_2.280702_g34382_i0	PRJNA1008624	34570	163	2.280702	3.71754426	Pseudomonadati	3379134	Bacteria	Bacteria	98.2	2.93e-25	NR	MCH3765093.1	195	g34382	i0	100	2.92638036809816	53	0	97.5	0	1	159	14	66	MCH3765093.1 hypothetical protein [Campylobacter coli]	diamond	477	98.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
30003054	30003054	PRJNA1008624_P_NODE_30031_length_167_cov_0.881356_g29843_i0	PRJNA1008624	30031	167	0.881356	1.47186452	Helicobacter pylori	210	Bacteria	Bacteria	99	1.36e-25	NR	WP_316500743.1	210	g29843	i0	100	0.970059880239521	54	0	97	0	166	5	18	71	WP_316500743.1 hypothetical protein, partial [Helicobacter pylori]	diamond	162	99	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30761310	30761310	PRJNA1008624_P_NODE_35574_length_163_cov_0.912281_g35386_i0	PRJNA1008624	35574	163	0.912281	1.48701803	Desulfurellales bacterium	2482794	Bacteria	Bacteria	63.5	5.62e-10	NR	TXH52806.1	2482794	g35386	i0	61.5	0.957055214723926	52	20	95.7	0	7	162	287	338	TXH52806.1 MAG: hypothetical protein E6Q97_14785 [Desulfurellales bacterium]	diamond	156	63.5	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales 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);;