metadata: contig_metadata: 5 rows where bioproject = "PRJNA1102048", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA1102048", 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
6123078	6123078	PRJNA1102048_P_NODE_17965_length_237_cov_3.030488_g17861_i0	PRJNA1102048	17965	237	3.030488	7.18225656	Helicobacter	209	Bacteria	Bacteria	63.9	9.83e-6	NTclustered	gi\|2288874529\|dbj\|AP026684.1\|	35817	g17861	i0	93.023	0.362869198312236	43	3	18	0	182	224	1184498	1184540	Helicobacter heilmannii ASB1 DNA, complete genome	blastn	86	63.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter heilmannii
12498823	12498823	PRJNA1102048_P_NODE_16050_length_244_cov_0.900585_g15946_i0	PRJNA1102048	16050	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	1.02e-5	NTclustered	gi\|2642539130\|gb\|CP078819.1\|	210	g15946	i0	100	6.19262295081967	34	0	14	0	1	34	7708	7675	Helicobacter pylori strain HpGP-JOR-001 chromosome, complete genome	blastn	1511	63.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
15047701	15047701	PRJNA1102048_P_NODE_6612_length_336_cov_1.703422_g6508_i0	PRJNA1102048	6612	336	1.703422	5.72349792	root	1	Root_unresolved	Root_unresolved	60.2	1.89e-4	NTclustered	gi\|2641454253\|gb\|CP078941.1\|	210	g6508	i0	94.737	5.94642857142857	38	2	11	0	20	57	1398995	1398958	Helicobacter pylori strain HpGP-COL-306 chromosome, complete genome	blastn	1998	60.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29719957	29719957	PRJNA1102048_P_NODE_1230_length_681_cov_2.444079_g1132_i0	PRJNA1102048	1230	681	2.444079	16.64417799	Sulfurimonas sp.	2022749	Bacteria	Bacteria	105	2.5600000000000003e-22	NR	MDD2789235.1	2022749	g1132	i0	40.5	0.674008810572687	153	84	64.3	4	664	227	258	410	MDD2789235.1 hypothetical protein [Sulfurimonas sp.]	diamond	459	105	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
31363404	31363404	PRJNA1102048_P_NODE_10496_length_273_cov_1.020000_g10392_i0	PRJNA1102048	10496	273	1.02	2.7846	Campylobacterota bacterium	2026809	Bacteria	Bacteria	64.3	9.78e-10	NR	MCL4431196.1	2026809	g10392	i0	44.7	0.835164835164835	76	41	83.5	1	44	271	2	76	MCL4431196.1 hypothetical protein [Campylobacterota bacterium]	diamond	228	64.3	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota 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);;