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

6 rows where bioproject = "PRJNA1010662", 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
3981338	3981338	PRJNA1010662_P_NODE_3844_length_267_cov_1.674312_g3785_i0	PRJNA1010662	3844	267	1.674312	4.47041304	Helicobacter pylori	210	Bacteria	Bacteria	58.4	5.25e-4	NTclustered	gi\|2641848563\|gb\|CP078334.1\|	210	g3785	i0	100	1.31460674157303	31	0	12	0	80	110	285575	285605	Helicobacter pylori strain HpGP-SPA-308 chromosome, complete genome	blastn	351	58.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
6533114	6533114	PRJNA1010662_P_NODE_6946_length_211_cov_3.765432_g6887_i0	PRJNA1010662	6946	211	3.765432	7.94506152	Helicobacter pylori	210	Bacteria	Bacteria	67.6	6.62e-7	NTclustered	gi\|2642281662\|gb\|CP078399.1\|	210	g6887	i0	91.837	5.44075829383886	49	2	23	2	45	92	7812	7765	Helicobacter pylori strain HpGP-POR-115 chromosome, complete genome	blastn	1148	67.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
13754885	13754885	PRJNA1010662_S_NODE_3731_length_177_cov_1.126866_g3686_i0	PRJNA1010662	3731	177	1.126866	1.99455282	Campylobacter	194	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|285194055\|gb\|GU425725.1\|	203	g3686	i0	100	106	177	0	100	0	1	177	725	549	Campylobacter rectus clone WWP_SS3_P12 16S ribosomal RNA gene, partial sequence	blastn	18762	327	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter rectus
28992834	28992834	PRJNA1010662_S_NODE_4028_length_171_cov_2.250000_g3983_i0	PRJNA1010662	4028	171	2.25	3.8475	Helicobacter pylori	210	Bacteria	Bacteria	46.2	5.4e-5	NR	GAA8909252.1	210	g3983	i0	57.1	1.19298245614035	35	15	61.4	0	25	129	8	42	GAA8909252.1 hypothetical protein Kyoto166A_1650 [Helicobacter pylori]	diamond	204	46.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29371463	29371463	PRJNA1010662_S_NODE_3689_length_178_cov_1.422222_g3644_i0	PRJNA1010662	3689	178	1.422222	2.53155516	Helicobacter pylori	210	Bacteria	Bacteria	63.9	2.87e-11	NR	WP_322538264.1	210	g3644	i0	51.7	2.02247191011236	60	28	99.4	1	178	2	16	75	WP_322538264.1 hypothetical protein, partial [Helicobacter pylori]	diamond	360	63.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30003082	30003082	PRJNA1010662_P_NODE_6351_length_219_cov_0.917647_g6292_i0	PRJNA1010662	6351	219	0.917647	2.00964693	Sulfurimonas sp.	2022749	Bacteria	Bacteria	42.4	0.0399	NR	WP_299947353.1	2022749	g6292	i0	40.5	0.575342465753425	42	25	57.5	0	94	219	3502	3543	WP_299947353.1 calcium-binding protein [Sulfurimonas sp.]	diamond	126	42.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.

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