metadata: contig_metadata: 5 rows where bioproject = "PRJNA1151638" and tax

5 rows where bioproject = "PRJNA1151638" 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
9229872	9229872	PRJNA1151638_P_NODE_1148_length_423_cov_1.388571_g1081_i0	PRJNA1151638	1148	423	1.388571	5.87365533	Helicobacter sp.	218	Bacteria	Bacteria	95.9	3.26e-22	NR	MDU7693553.1	218	g1081	i0	98	0.354609929078014	50	1	35.5	0	151	2	2	51	MDU7693553.1 hypothetical protein [Helicobacter sp.]	diamond	150	95.9	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
26787211	26787211	PRJNA1151638_P_NODE_1001_length_447_cov_1.887701_g934_i0	PRJNA1151638	1001	447	1.887701	8.43802347	Helicobacter sp.	218	Bacteria	Bacteria	200	5.35e-62	NR	MDU7693550.1	218	g934	i0	96.9	0.651006711409396	97	3	65.1	0	329	39	1	97	MDU7693550.1 hypothetical protein [Helicobacter sp.]	diamond	291	200	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
27008467	27008467	PRJNA1151638_P_NODE_1262_length_404_cov_3.586103_g1195_i0	PRJNA1151638	1262	404	3.586103	14.48785612	Helicobacter sp.	218	Bacteria	Bacteria	122	3.44e-33	NR	MDU7693551.1	218	g1195	i0	93.5	0.690594059405941	93	6	69.1	0	72	350	1	93	MDU7693551.1 hypothetical protein [Helicobacter sp.]	diamond	279	122	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter sp.
29345612	29345612	PRJNA1151638_P_NODE_2229_length_326_cov_2.403162_g2162_i0	PRJNA1151638	2229	326	2.403162	7.83430812	Sulfurimonas sp.	2022749	Bacteria	Bacteria	56.6	1.15e-6	NR	MDA7817910.1	2022749	g2162	i0	47.2	0.487730061349693	53	28	48.8	0	324	166	278	330	MDA7817910.1 DNA adenine methylase [Sulfurimonas sp.]	diamond	159	56.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurimonadaceae	Sulfurimonas	Sulfurimonas sp.
32569922	32569922	PRJNA1151638_P_NODE_3779_length_272_cov_2.351759_g3712_i0	PRJNA1151638	3779	272	2.351759	6.39678448	Helicobacter sp.	218	Bacteria	Bacteria	84	1.79e-17	NR	MDU7693549.1	218	g3712	i0	97.8	1.00367647058824	91	1	99.3	1	3	272	35	125	MDU7693549.1 hypothetical protein [Helicobacter sp.]	diamond	273	84	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter 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);;