metadata: contig_metadata: 7 rows where bioproject = "PRJNA1034995" and tax

7 rows where bioproject = "PRJNA1034995" 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
27540801	27540801	PRJNA1034995_S_NODE_22804_length_343_cov_25.510000_g22648_i0	PRJNA1034995	22804	343	25.51	87.4993	Helicobacter pylori	210	Bacteria	Bacteria	107	2e-27	NR	WP_322538256.1	210	g22648	i0	94.3	0.463556851311953	53	3	46.4	0	320	162	55	107	WP_322538256.1 hypothetical protein, partial [Helicobacter pylori]	diamond	159	107	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27667187	27667187	PRJNA1034995_S_NODE_15864_length_470_cov_7.683841_g15713_i0	PRJNA1034995	15864	470	7.683841	36.1140527	Helicobacter pylori	210	Bacteria	Bacteria	48.1	3.07e-4	NR	GAA6904105.1	210	g15713	i0	37.7	0.38936170212766	61	38	38.9	0	43	225	9	69	GAA6904105.1 hypothetical protein Kyoto207A_2120 [Helicobacter pylori]	diamond	183	48.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29308753	29308753	PRJNA1034995_S_NODE_14489_length_511_cov_40.367521_g14340_i0	PRJNA1034995	14489	511	40.367521000000004	206.27803231	uncultured Arcobacter sp.	165434	Bacteria	Bacteria	81.3	1.69e-14	NR	WP_298749163.1	165434	g14340	i0	43.9	1.69080234833659	107	54	61.6	2	315	1	87	189	WP_298749163.1 hypothetical protein [uncultured Arcobacter sp.]	diamond	864	81.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	uncultured Arcobacter sp.
29434841	29434841	PRJNA1034995_S_NODE_35230_length_232_cov_3.894180_g35074_i0	PRJNA1034995	35230	232	3.89418	9.0344976	Campylobacterales bacterium	2268180	Bacteria	Bacteria	86.3	8.51e-18	NR	MBE0496800.1	2268180	g35074	i0	57.3	0.969827586206897	75	32	97	0	230	6	58	132	MBE0496800.1 hypothetical protein [Campylobacterales bacterium]	diamond	225	86.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
30185064	30185064	PRJNA1034995_S_NODE_29472_length_274_cov_8.160173_g29316_i0	PRJNA1034995	29472	274	8.160173	22.35887402	root	1	Root_unresolved	Root_unresolved	43.1	0.00432	NR	GAA8950830.1	210	g29316	i0	48.8	1.64233576642336	41	20	43.8	1	264	145	21	61	GAA8950830.1 hypothetical protein Kyoto181A_1710 [Helicobacter pylori]	diamond	450	43.5	0.990804597701149	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30825007	30825007	PRJNA1034995_S_NODE_16554_length_452_cov_22.564792_g16400_i0	PRJNA1034995	16554	452	22.564792	101.99285984	Campylobacter coli	195	Bacteria	Bacteria	50.8	1.61e-4	NR	RJF56794.1	195	g16400	i0	38.7	0.497787610619469	75	43	47.8	1	236	451	20	94	RJF56794.1 hypothetical protein D4Z76_09165, partial [Campylobacter coli]	diamond	225	50.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
31322635	31322635	PRJNA1034995_S_NODE_26835_length_298_cov_38.670588_g26679_i0	PRJNA1034995	26835	298	38.670588	115.23835224	root	1	Root_unresolved	Root_unresolved	43.1	0.00422	NR	GAA8827101.1	210	g26679	i0	51.9	2.01342281879195	52	21	51.3	2	253	101	1	49	GAA8827101.1 hypothetical protein Kyoto149A_4360 [Helicobacter pylori]	diamond	600	43.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);;