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

5 rows where bioproject = "PRJNA407368" 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
27724339	27724339	PRJNA407368_S_NODE_5324_length_238_cov_2.339713_g5222_i0	PRJNA407368	5324	238	2.339713	5.56851694	Halarcobacter	2321115	Bacteria	Bacteria	90.1	3.03e-20	NR	WP_129082865.1	877500	g5222	i0	61.4	10.6008403361345	70	27	88.2	0	21	230	107	176	WP_129082865.1 DedA family protein [Halarcobacter anaerophilus]	diamond	2523	90.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Halarcobacter	Halarcobacter anaerophilus
30075328	30075328	PRJNA407368_S_NODE_3032_length_341_cov_6.727564_g2930_i0	PRJNA407368	3032	341	6.727564	22.94099324	Helicobacter pylori	210	Bacteria	Bacteria	85.5	1.2e-19	NR	GAA8838853.1	210	g2930	i0	92.9	0.36950146627566	42	3	37	0	331	206	2	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	126	85.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
31387924	31387924	PRJNA407368_S_NODE_1656_length_488_cov_9.015251_g1560_i0	PRJNA407368	1656	488	9.015251	43.99442488	Campylobacter	194	Bacteria	Bacteria	49.3	1.07e-4	NR	WP_251831854.1	197	g1560	i0	46.9	0.903688524590164	49	24	28.9	1	142	2	1	49	WP_251831854.1 hypothetical protein [Campylobacter jejuni]	diamond	441	49.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
32351973	32351973	PRJNA407368_S_NODE_9479_length_162_cov_3.000000_g9377_i0	PRJNA407368	9479	162	3	4.86	Desulfurellales bacterium	2482794	Bacteria	Bacteria	66.6	4.54e-11	NR	TXH53030.1	2482794	g9377	i0	73.6	1.96296296296296	53	14	98.1	0	161	3	110	162	TXH53030.1 MAG: hypothetical protein E6Q97_14060 [Desulfurellales bacterium]	diamond	318	66.6	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium
32793339	32793339	PRJNA407368_S_NODE_5120_length_245_cov_2.333333_g5018_i0	PRJNA407368	5120	245	2.333333	5.71666585	Desulfurellales bacterium	2482794	Bacteria	Bacteria	106	1.12e-25	NR	TXH53380.1	2482794	g5018	i0	63.3	0.96734693877551	79	29	96.7	0	238	2	84	162	TXH53380.1 MAG: hypothetical protein E6Q97_13350 [Desulfurellales bacterium]	diamond	237	106	1	Bacteria	Pseudomonadati	Campylobacterota	Desulfurellia	Desulfurellales			Desulfurellales bacterium

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