metadata: contig_metadata: 7 rows where bioproject = "PRJNA870096", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA870096", 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
12329411	12329411	PRJNA870096_S_NODE_58970_length_228_cov_22.751351_g57306_i0	PRJNA870096	58970	228	22.751351	51.87308028	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g57306	i0	100	0.12280701754386	28	0	12	0	106	133	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
28855078	28855078	PRJNA870096_S_NODE_113888_length_166_cov_2.430894_g112224_i0	PRJNA870096	113888	166	2.430894	4.03528404	Helicobacter pylori	210	Bacteria	Bacteria	40.8	0.012	NR	GAA6820949.1	210	g112224	i0	56.4	0.704819277108434	39	12	61.4	1	161	60	2	40	GAA6820949.1 hypothetical protein Kyoto200A_3790 [Helicobacter pylori]	diamond	117	40.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29454784	29454784	PRJNA870096_S_NODE_111010_length_168_cov_2.320000_g109346_i0	PRJNA870096	111010	168	2.32	3.8976	Helicobacter pylori	210	Bacteria	Bacteria	72.8	3.83e-14	NR	GAA6795647.1	210	g109346	i0	100	2.21428571428571	31	0	55.4	0	164	72	1	31	GAA6795647.1 hypothetical protein Kyoto200A_0490 [Helicobacter pylori]	diamond	372	72.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29747114	29747114	PRJNA870096_S_NODE_91150_length_184_cov_1.936170_g89486_i0	PRJNA870096	91150	184	1.93617	3.5625528	Pseudomonadati	3379134	Bacteria	Bacteria	92	6.05e-22	NR	WP_011373253.1	39766	g89486	i0	72.2	7.17391304347826	54	15	88	0	2	163	90	143	WP_011373253.1 nucleoside deaminase [Sulfurimonas denitrificans]	diamond	1320	92	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas denitrificans
30497624	30497624	PRJNA870096_S_NODE_78973_length_197_cov_1.870130_g77309_i0	PRJNA870096	78973	197	1.87013	3.6841561	Helicobacter pylori	210	Bacteria	Bacteria	39.7	0.0257	NR	GAA8983245.1	210	g77309	i0	51.7	0.441624365482233	29	14	44.2	0	82	168	6	34	GAA8983245.1 hypothetical protein Kyoto181A_5470 [Helicobacter pylori]	diamond	87	39.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31983297	31983297	PRJNA870096_S_NODE_41418_length_275_cov_88.137931_g39754_i0	PRJNA870096	41418	275	88.137931	242.37931025	Helicobacter pylori	210	Bacteria	Bacteria	84.7	1.07e-19	NR	GAA8838853.1	210	g39754	i0	92.9	0.458181818181818	42	3	45.8	0	1	126	2	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	126	84.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32592638	32592638	PRJNA870096_S_NODE_38839_length_285_cov_2.252066_g37175_i0	PRJNA870096	38839	285	2.252066	6.4183881	Pseudomonadati	3379134	Bacteria	Bacteria	67.4	5.35e-11	NR	WP_007474387.1	291048	g37175	i0	50	1.15789473684211	58	29	61.1	0	271	98	189	246	WP_007474387.1 carbonic anhydrase [Caminibacter mediatlanticus]	diamond	330	67.8	0.994100294985251	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Nautiliales	Nautiliaceae	Caminibacter	Caminibacter mediatlanticus

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