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

5 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax_kingdom = "Fusobacteriati"

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
26605377	26605377	PRJNA615351_P_NODE_17301_length_1582_cov_31.299935_g12509_i0	PRJNA615351	17301	1582	31.299935	495.1649717	Sebaldella sp.	2819260	Bacteria	Bacteria	61.6	5.19e-6	NR	MBP9479720.1	2819260	g12509	i0	21.6	1.04867256637168	268	191	50.3	3	209	1003	45	296	MBP9479720.1 MATE family efflux transporter [Sebaldella sp.]	diamond	1659	61.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella sp.
27744019	27744019	PRJNA615351_P_NODE_127704_length_231_cov_1.836735_g113604_i0	PRJNA615351	127704	231	1.836735	4.24285785	Fusobacteriota bacterium	2060921	Bacteria	Bacteria	49.3	1.51e-4	NR	MCI0502174.1	2060921	g113604	i0	43.1	0.844155844155844	65	32	84.4	1	14	208	119	178	MCI0502174.1 NADPH-dependent glutamate synthase [Fusobacteriota bacterium]	diamond	195	49.3	1	Bacteria	Fusobacteriati	Fusobacteriota					Fusobacteriota bacterium
27901426	27901426	PRJNA615351_P_NODE_13345_length_1795_cov_3.688068_g9584_i0	PRJNA615351	13345	1795	3.688068	66.2008206	Sneathia sp. DSM 16631	2777994	Bacteria	Bacteria	55.1	0.00104	NR	WP_192942066.1	2777994	g9584	i0	30.5	0.158774373259053	95	63	15.4	1	5	280	271	365	WP_192942066.1 class III lanthionine synthetase LanKC [Sneathia sp. DSM 16631]	diamond	285	55.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sp. DSM 16631
29227982	29227982	PRJNA615351_P_NODE_14249_length_1742_cov_3.949619_g9584_i1	PRJNA615351	14249	1742	3.949619	68.80236298	Sneathia sp. DSM 16631	2777994	Bacteria	Bacteria	55.1	9.94e-4	NR	WP_192942066.1	2777994	g9584	i1	30.5	0.163605051664753	95	63	15.8	1	5	280	271	365	WP_192942066.1 class III lanthionine synthetase LanKC [Sneathia sp. DSM 16631]	diamond	285	55.1	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sp. DSM 16631
32008768	32008768	PRJNA615351_P_NODE_62078_length_575_cov_1.372222_g48671_i0	PRJNA615351	62078	575	1.372222	7.8902765	uncultured Cetobacterium sp.	527638	Bacteria	Bacteria	46.6	0.0311	NR	WP_294096266.1	527638	g48671	i0	39.1	0.48	92	46	47	3	290	559	383	466	WP_294096266.1 Na/Pi cotransporter family protein [uncultured Cetobacterium sp.]	diamond	276	46.6	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	uncultured Cetobacterium sp.

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