metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1199330" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1199330" 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
19452234	19452234	PRJNA1199330_P_NODE_81896_length_271_cov_1.378788_g81197_i0	PRJNA1199330	81896	271	1.378788	3.73651548	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	116	4.21e-30	NR	WP_295143622.1	218934	g81197	i0	96.7	0.675276752767528	61	2	67.5	0	185	3	1	61	WP_295143622.1 pseudaminic acid cytidylyltransferase [uncultured Campylobacter sp.]	diamond	183	116	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
27009173	27009173	PRJNA1199330_P_NODE_88722_length_264_cov_2.418848_g88023_i0	PRJNA1199330	88722	264	2.418848	6.38575872	uncultured Campylobacter sp.	218934	Bacteria	Bacteria	137	2.5599999999999996e-35	NR	WP_298833284.1	218934	g88023	i0	79.5	1	88	17	98.9	1	262	2	878	965	WP_298833284.1 calcium-binding protein [uncultured Campylobacter sp.]	diamond	264	137	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	uncultured Campylobacter sp.
28809112	28809112	PRJNA1199330_P_NODE_108468_length_247_cov_2.511494_g107769_i0	PRJNA1199330	108468	247	2.511494	6.20339018	Helicobacter pylori	210	Bacteria	Bacteria	44.7	6.99e-4	NR	GAA8930966.1	210	g107769	i0	74.1	0.327935222672065	27	7	32.8	0	245	165	16	42	GAA8930966.1 hypothetical protein Kyoto166A_4300 [Helicobacter pylori]	diamond	81	44.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29567118	29567118	PRJNA1199330_P_NODE_88530_length_264_cov_3.157068_g87831_i0	PRJNA1199330	88530	264	3.157068	8.33465952	Helicobacter pylori	210	Bacteria	Bacteria	58.2	1.27e-8	NR	GAA6860517.1	210	g87831	i0	56.7	1.10227272727273	67	17	62.5	1	255	91	1	67	GAA6860517.1 hypothetical protein Kyoto206A_1350 [Helicobacter pylori]	diamond	291	58.2	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
32254262	32254262	PRJNA1199330_P_NODE_96118_length_257_cov_1.695652_g95419_i0	PRJNA1199330	96118	257	1.695652	4.35782564	Helicobacter pylori	210	Bacteria	Bacteria	60.5	3.08e-10	NR	GAA8757316.1	210	g95419	i0	66.7	0.852140077821012	36	12	42	0	67	174	4	39	GAA8757316.1 hypothetical protein Kyoto147A_3750 [Helicobacter pylori]	diamond	219	60.5	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);;