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

7 rows where bioproject = "PRJEB80557", 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
6099716	6099716	PRJEB80557_S_NODE_31105_length_174_cov_1.232000_g30709_i0	PRJEB80557	31105	174	1.232	2.14368	root	1	Root_unresolved	Root_unresolved	278	2.22e-70	NTclustered	gi\|1226876681\|gb\|CP022559.1\|	197	g30709	i0	98.113	88.9022988505747	159	3	91	0	1	159	698336	698178	Campylobacter jejuni strain 11168H/araE chromosome, complete genome	blastn	15469	279	0.996415770609319	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
7374123	7374123	PRJEB80557_S_NODE_34126_length_167_cov_1.296610_g33730_i0	PRJEB80557	34126	167	1.29661	2.1653387	Campylobacter	194	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1207769205\|gb\|MF351718.1\|	199	g33730	i0	100	234.011976047904	167	0	100	0	1	167	841	1007	Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence	blastn	39080	309	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
25222761	25222761	PRJEB80557_S_NODE_8840_length_305_cov_1.414062_g8444_i0	PRJEB80557	8840	305	1.414062	4.3128891	root	1	Root_unresolved	Root_unresolved	486	6.579999999999998e-133	NTclustered	gi\|1377039872\|gb\|MF037584.1\|	195	g8444	i0	97.544	40.0918032786885	285	6	93	1	1	285	1043	1326	Campylobacter coli strain SHP40 cfrC gene cluster, complete sequence	blastn	12228	486	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
26615261	26615261	PRJEB80557_S_NODE_8441_length_311_cov_1.740458_g8045_i0	PRJEB80557	8441	311	1.740458	5.41282438	Sulfurimonas	202746	Bacteria	Bacteria	110	4.04e-26	NR	WP_320342666.1	2022749	g8045	i0	62.5	10.6012861736334	88	33	84.9	0	48	311	1	88	WP_320342666.1 nucleotide sugar dehydrogenase [Sulfurimonas sp.]	diamond	3297	110	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
28202652	28202652	PRJEB80557_S_NODE_32026_length_171_cov_2.475410_g31630_i0	PRJEB80557	32026	171	2.47541	4.2329511	Helicobacter pylori	210	Bacteria	Bacteria	39.7	0.0362	NR	GAA6966648.1	210	g31630	i0	65.4	0.456140350877193	26	6	40.4	1	3	71	4	29	GAA6966648.1 hypothetical protein Kyoto211A_2720 [Helicobacter pylori]	diamond	78	39.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
28739649	28739649	PRJEB80557_S_NODE_15467_length_238_cov_2.333333_g15071_i0	PRJEB80557	15467	238	2.333333	5.55333254	Helicobacter pylori	210	Bacteria	Bacteria	73.6	2.12e-15	NR	GAA6798490.1	210	g15071	i0	92.9	0.529411764705882	42	3	52.9	0	173	48	1	42	GAA6798490.1 hypothetical protein Kyoto200A_1590 [Helicobacter pylori]	diamond	126	73.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31298118	31298118	PRJEB80557_S_NODE_21535_length_205_cov_1.974359_g21139_i0	PRJEB80557	21535	205	1.974359	4.04743595	Campylobacter lari	201	Bacteria	Bacteria	53.9	2.22e-7	NR	WP_393922211.1	201	g21139	i0	65.6	3.39512195121951	32	11	46.8	0	108	203	7	38	WP_393922211.1 4Fe-4S cluster-binding domain-containing protein, partial [Campylobacter lari]	diamond	696	53.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter lari

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