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

5 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax_clade = "Discoba"

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_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
29067531	29067531	PRJNA546018_S_NODE_20248_length_359_cov_4.516779_g19923_i0	PRJNA546018	20248	359	4.516779	16.21523661	Bodo saltans	75058	Euglenozoa	other_Eukaryota	58.5	4.14e-7	NR	CUG91007.1	75058	g19923	i0	40.6	0.844011142061281	101	52	79.4	4	50	334	290	388	CUG91007.1 guanylate cyclase, putative [Bodo saltans]	diamond	303	58.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29477562	29477562	PRJNA546018_S_NODE_22050_length_342_cov_3.960854_g21725_i0	PRJNA546018	22050	342	3.960854	13.54612068	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	150	1.77e-39	NR	XP_002682839.1	5762	g21725	i0	77.4	1.00877192982456	115	18	98.2	3	341	6	748	857	XP_002682839.1 ATP-dependent RNA helicase [Naegleria gruberi]	diamond	345	150	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
30077754	30077754	PRJNA546018_S_NODE_20512_length_356_cov_8.216949_g20187_i0	PRJNA546018	20512	356	8.216949	29.25233844	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	49.3	6.61e-4	NR	KAL0485512.1	1008807	g20187	i0	67.7	0.52247191011236	31	10	26.1	0	334	242	143	173	KAL0485512.1 superoxide dismutase, partial [Acrasis kona]	diamond	186	49.3	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
30204014	30204014	PRJNA546018_S_NODE_10132_length_543_cov_2.582988_g9811_i0	PRJNA546018	10132	543	2.582988	14.02562484	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	285	1.1999999999999999e-95	NR	XP_002678094.1	5762	g9811	i0	80.7	0.94475138121547	171	31	94.5	1	6	518	8	176	XP_002678094.1 uncharacterized protein NAEGRDRAFT_66657 [Naegleria gruberi]	diamond	513	285	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
31405287	31405287	PRJNA546018_S_NODE_29756_length_288_cov_2.612335_g29431_i0	PRJNA546018	29756	288	2.612335	7.5235248	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	43.5	0.0335	NR	KAJ9468174.1	91374	g29431	i0	27.7	0.979166666666667	94	65	94.8	1	282	10	52	145	KAJ9468174.1 Metacaspase-1A [Diplonema papillatum]	diamond	282	43.5	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum

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