metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA643700" 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
27112723	27112723	PRJNA643700_P_NODE_263822_length_230_cov_2.314917_g262266_i0	PRJNA643700	263822	230	2.314917	5.3243091	Helicobacter trogontum	50960	Bacteria	Bacteria	41.6	0.0348	NR	TLD96448.1	50960	g262266	i0	38.6	1.72173913043478	44	27	57.4	0	178	47	36	79	TLD96448.1 hypothetical protein LS80_008400 [Helicobacter trogontum]	diamond	396	41.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter trogontum
28976135	28976135	PRJNA643700_P_NODE_210768_length_269_cov_1.418182_g209212_i0	PRJNA643700	210768	269	1.418182	3.81490958	unclassified Campylobacter	2593542	Bacteria	Bacteria	45.1	0.00722	NR	WP_150139290.1	2593542	g209212	i0	37.7	0.680297397769517	61	29	58	2	259	104	159	219	WP_150139290.1 MULTISPECIES: glycosyltransferase family 2 protein [unclassified Campylobacter]	diamond	183	45.1	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter
29039434	29039434	PRJNA643700_P_NODE_328188_length_195_cov_4.082192_g326632_i0	PRJNA643700	328188	195	4.082192	7.9602744	Campylobacterota bacterium	2026809	Bacteria	Bacteria	43.1	0.0144	NR	RLA72111.1	2026809	g326632	i0	41.9	0.661538461538462	43	25	66.2	0	162	34	71	113	RLA72111.1 MAG: hypothetical protein DRG30_07700 [Campylobacterota bacterium]	diamond	129	43.1	1	Bacteria	Pseudomonadati	Campylobacterota					Campylobacterota bacterium
29607125	29607125	PRJNA643700_P_NODE_80670_length_466_cov_2.400480_g79126_i0	PRJNA643700	80670	466	2.40048	11.1862368	Poseidonibacter lekithochrous	1904463	Bacteria	Bacteria	45.4	0.0323	NR	WP_071626310.1	1904463	g79126	i0	34.2	0.489270386266094	76	48	47.6	1	150	371	132	207	WP_071626310.1 type IV pili methyl-accepting chemotaxis transducer N-terminal domain-containing protein [Poseidonibacter lekithochrous]	diamond	228	45.4	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Poseidonibacter	Poseidonibacter lekithochrous
29733558	29733558	PRJNA643700_P_NODE_277970_length_222_cov_1.242775_g276414_i0	PRJNA643700	277970	222	1.242775	2.7589605	Aliarcobacter cryaerophilus	28198	Bacteria	Bacteria	42.7	0.0277	NR	WP_342837299.1	28198	g276414	i0	39	0.797297297297297	59	33	78.4	2	14	187	208	264	WP_342837299.1 MBL fold metallo-hydrolase [Aliarcobacter cryaerophilus]	diamond	177	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter cryaerophilus
30397710	30397710	PRJNA643700_P_NODE_244913_length_243_cov_1.386598_g243357_i0	PRJNA643700	244913	243	1.386598	3.36943314	Campylobacteraceae bacterium	2268179	Bacteria	Bacteria	41.6	0.0275	NR	MBV5278496.1	2268179	g243357	i0	37.5	0.691358024691358	56	33	67.9	2	182	18	34	88	MBV5278496.1 hypothetical protein [Campylobacteraceae bacterium]	diamond	168	41.6	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae		Campylobacteraceae bacterium
32673268	32673268	PRJNA643700_P_NODE_232640_length_252_cov_1.133005_g231084_i0	PRJNA643700	232640	252	1.133005	2.8551726	Campylobacter iguaniorum	1244531	Bacteria	Bacteria	42.7	0.0395	NR	WP_038453659.1	1244531	g231084	i0	45.9	0.44047619047619	37	20	44	0	108	218	316	352	WP_038453659.1 sensor histidine kinase [Campylobacter iguaniorum]	diamond	111	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter iguaniorum

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