metadata: contig_metadata: 7 rows where bioproject = "PRJNA1195551", tax_phylum = "Campylobacterota" and tax

7 rows where bioproject = "PRJNA1195551", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

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
1597210	1597210	PRJNA1195551_S_NODE_33802_length_175_cov_1.650794_g33449_i0	PRJNA1195551	33802	175	1.650794	2.8888895	Helicobacter canis	29419	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|50957150\|gb\|AY596235.1\|	29419	g33449	i0	100	137.017142857143	175	0	100	0	1	175	814	988	Helicobacter canis strain ATCC 51402 23S ribosomal RNA gene, partial sequence	blastn	23978	324	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter canis
27103905	27103905	PRJNA1195551_S_NODE_21982_length_214_cov_5.842424_g21629_i0	PRJNA1195551	21982	214	5.842424	12.50278736	Campylobacter lanienae	75658	Bacteria	Bacteria	73.2	4.24e-13	NR	WP_261517989.1	75658	g21629	i0	47	1.86448598130841	66	35	92.5	0	210	13	218	283	WP_261517989.1 restriction endonuclease subunit S [Campylobacter lanienae]	diamond	399	73.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lanienae
28575672	28575672	PRJNA1195551_S_NODE_37687_length_167_cov_1.322034_g37334_i0	PRJNA1195551	37687	167	1.322034	2.20779678	root	1	Root_unresolved	Root_unresolved	54.7	4.01e-8	NR	GAA8857404.1	210	g37334	i0	60.5	5.94610778443114	38	15	68.3	0	46	159	21	58	GAA8857404.1 hypothetical protein Kyoto154A_2210 [Helicobacter pylori]	diamond	993	54.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28872436	28872436	PRJNA1195551_S_NODE_16968_length_240_cov_2.178010_g16615_i0	PRJNA1195551	16968	240	2.17801	5.227224	Helicobacter pylori	210	Bacteria	Bacteria	53.9	7.23e-7	NR	GAA9248560.1	210	g16615	i0	52.9	1.8875	51	24	63.8	0	158	6	6	56	GAA9248560.1 hypothetical protein Kyoto199A_1460 [Helicobacter pylori]	diamond	453	53.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30894102	30894102	PRJNA1195551_S_NODE_35554_length_171_cov_1.704918_g35201_i0	PRJNA1195551	35554	171	1.704918	2.91540978	Campylobacter jejuni	197	Bacteria	Bacteria	95.9	5.38e-23	NR	WP_228567426.1	197	g35201	i0	90.6	0.929824561403509	53	5	93	0	170	12	134	186	WP_228567426.1 Hsp26/alpha crystallin family protein, partial [Campylobacter jejuni]	diamond	159	95.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
32114738	32114738	PRJNA1195551_S_NODE_25198_length_201_cov_2.394737_g24845_i0	PRJNA1195551	25198	201	2.394737	4.81342137	root	1	Root_unresolved	Root_unresolved	55.1	4.28e-8	NR	GAA9043165.1	210	g24845	i0	47.3	1.71641791044776	55	29	82.1	0	187	23	18	72	GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori]	diamond	345	55.5	0.992792792792793	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32570490	32570490	PRJNA1195551_S_NODE_34679_length_173_cov_1.677419_g34326_i0	PRJNA1195551	34679	173	1.677419	2.90193487	Helicobacter pylori	210	Bacteria	Bacteria	55.1	2.99e-8	NR	GAA9043165.1	210	g34326	i0	41.1	4.47398843930636	56	30	91.9	1	7	165	17	72	GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori]	diamond	774	55.1	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);;