metadata: contig_metadata: 6 rows where bioproject = "PRJNA998413" and tax

6 rows where bioproject = "PRJNA998413" 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
16281972	16281972	PRJNA998413_S_NODE_6973_length_248_cov_6.227027_g6942_i0	PRJNA998413	6973	248	6.227027	15.44302696	Malaciobacter marinus	505249	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1474785413\|gb\|CP032101.1\|	505249	g6942	i0	100	0.112903225806452	28	0	11	0	123	150	1771291	1771318	Malaciobacter marinus strain JCM 15502 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Malaciobacter	Malaciobacter marinus
29363482	29363482	PRJNA998413_S_NODE_5769_length_263_cov_1.245000_g5738_i0	PRJNA998413	5769	263	1.245	3.27435	Helicobacter pylori	210	Bacteria	Bacteria	51.2	3.75e-5	NR	GAA8854026.1	210	g5738	i0	35.7	2.66920152091255	84	46	93.5	3	254	9	122	199	GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori]	diamond	702	51.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29552607	29552607	PRJNA998413_S_NODE_11050_length_216_cov_1.562092_g11019_i0	PRJNA998413	11050	216	1.562092	3.37411872	Helicobacter pylori	210	Bacteria	Bacteria	71.2	6.21e-14	NR	WP_322538264.1	210	g11019	i0	50	1.94444444444444	70	35	97.2	0	214	5	41	110	WP_322538264.1 hypothetical protein, partial [Helicobacter pylori]	diamond	420	71.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29647144	29647144	PRJNA998413_S_NODE_9610_length_225_cov_1.240741_g9579_i0	PRJNA998413	9610	225	1.240741	2.79166725	Helicobacter pylori	210	Bacteria	Bacteria	42.7	0.00282	NR	GAA8933130.1	210	g9579	i0	69	0.386666666666667	29	9	38.7	0	167	81	26	54	GAA8933130.1 hypothetical protein Kyoto166A_4430 [Helicobacter pylori]	diamond	87	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
30911329	30911329	PRJNA998413_S_NODE_8614_length_233_cov_1.229412_g8583_i0	PRJNA998413	8614	233	1.229412	2.86452996	Helicobacter pylori	210	Bacteria	Bacteria	103	1.62e-26	NR	WP_322538256.1	210	g8583	i0	74.6	0.862660944206009	67	17	86.3	0	233	33	14	80	WP_322538256.1 hypothetical protein, partial [Helicobacter pylori]	diamond	201	103	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32498639	32498639	PRJNA998413_S_NODE_13219_length_209_cov_1.376712_g13188_i0	PRJNA998413	13219	209	1.376712	2.87732808	root	1	Root_unresolved	Root_unresolved	46.6	1.05e-4	NR	GAA9043165.1	210	g13188	i0	58.6	2.61244019138756	29	12	41.6	0	180	94	14	42	GAA9043165.1 hypothetical protein Kyoto184A_02530 [Helicobacter pylori]	diamond	546	46.6	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);;