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

7 rows where bioproject = "PRJNA615175", 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
1871043	1871043	PRJNA615175_P_NODE_30282_length_248_cov_0.880000_g30114_i0	PRJNA615175	30282	248	0.88	2.1824	Sulfurimonas sp. SWIR-19	2878390	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2111132204\|gb\|CP084578.1\|	2878390	g30114	i0	100	0.112903225806452	28	0	11	0	193	220	745700	745727	Sulfurimonas sp. SWIR-19 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp. SWIR-19
7527577	7527577	PRJNA615175_P_NODE_2186_length_1037_cov_4.882780_g2069_i0	PRJNA615175	2186	1037	4.88278	50.6344286	root	1	Root_unresolved	Root_unresolved	1236	0	NTclustered	gi\|2096309699\|gb\|CP083377.1\|	195	g2069	i0	99.558	67.0578592092575	679	2	65	1	359	1037	1024961	1024284	Campylobacter coli strain C203110 chromosome, complete genome	blastn	69539	1236	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
12074297	12074297	PRJNA615175_P_NODE_27490_length_252_cov_2.972067_g27322_i0	PRJNA615175	27490	252	2.972067	7.48960884	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|1817415263\|gb\|CP026655.1\|	28198	g27322	i0	98.413	1	252	3	100	1	1	252	1179005	1178755	Aliarcobacter cryaerophilus strain G13RTA chromosome, complete genome	blastn	252	442	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
29227919	29227919	PRJNA615175_P_NODE_2289_length_1014_cov_5.011690_g2170_i0	PRJNA615175	2289	1014	5.01169	50.8185366	Campylobacteraceae bacterium	2268179	Bacteria	Bacteria	77.8	5.8e-12	NR	MDR1615017.1	2268179	g2170	i0	29.3	1.09467455621302	181	116	51.2	5	106	624	4	180	MDR1615017.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	1110	77.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
29322290	29322290	PRJNA615175_P_NODE_19769_length_312_cov_3.757322_g19601_i0	PRJNA615175	19769	312	3.757322	11.72284464	Helicobacter pylori	210	Bacteria	Bacteria	41.6	0.0324	NR	GAA9124962.1	210	g19601	i0	100	0.173076923076923	18	0	17.3	0	312	259	19	36	GAA9124962.1 hypothetical protein Kyoto190A_0650 [Helicobacter pylori]	diamond	54	41.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29669333	29669333	PRJNA615175_P_NODE_16310_length_348_cov_2.581818_g16142_i0	PRJNA615175	16310	348	2.581818	8.98472664	Desulfurellales bacterium	2482794	Bacteria	Bacteria	80.5	6.98e-15	NR	TXH52561.1	2482794	g16142	i0	41.9	1.00862068965517	117	61	96.6	4	337	2	323	437	TXH52561.1 MAG: DEAD/DEAH box helicase [Desulfurellales bacterium]	diamond	351	80.5	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
31135640	31135640	PRJNA615175_P_NODE_29135_length_249_cov_1.579545_g28967_i0	PRJNA615175	29135	249	1.579545	3.93306705	Pseudomonadati	3379134	Bacteria	Bacteria	48.5	2.12e-5	NR	GAA9125267.1	210	g28967	i0	80.8	0.891566265060241	26	4	30.1	1	199	125	6	31	GAA9125267.1 hypothetical protein Kyoto190A_0800 [Helicobacter pylori]	diamond	222	48.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori

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