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

5 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_clade = "Amoebozoa"

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
26678278	26678278	PRJEB28062_P_NODE_119541_length_261_cov_12.537234_g117178_i0	PRJEB28062	119541	261	12.537234	32.72218074	Eumycetozoa	142796	Evosea	other_Eukaryota	59.3	6.74e-8	NR	XP_003284481.1	5786	g117178	i0	42.6	7.91954022988506	68	38	77	1	236	36	766	833	XP_003284481.1 uncharacterized protein DICPUDRAFT_91322 [Dictyostelium purpureum]	diamond	2067	59.7	0.993299832495812	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
28833247	28833247	PRJEB28062_P_NODE_135068_length_224_cov_15.668874_g132704_i0	PRJEB28062	135068	224	15.668874	35.09827776	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	68.9	1.69e-11	NR	KAF2068976.1	133409	g132704	i0	54.5	1.32589285714286	55	25	73.7	0	27	191	62	116	KAF2068976.1 hypothetical protein CYY_009708 [Polysphondylium violaceum]	diamond	297	68.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30191061	30191061	PRJEB28062_P_NODE_135712_length_219_cov_5.883562_g133348_i0	PRJEB28062	135712	219	5.883562	12.88500078	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	55.1	1.23e-6	NR	XP_020427517.1	670386	g133348	i0	62.2	0.616438356164384	45	16	61.6	1	198	64	458	501	XP_020427517.1 3-oxoacid CoA-transferase [Heterostelium album PN500]	diamond	135	55.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
31044613	31044613	PRJEB28062_P_NODE_45895_length_530_cov_26.474836_g43554_i0	PRJEB28062	45895	530	26.474836	140.3166308	Physarum polycephalum	5791	Evosea	other_Eukaryota	116	8.839999999999998e-30	NR	BAE94683.1	5791	g43554	i0	45.7	0.730188679245283	129	65	70.8	3	95	469	5	132	BAE94683.1 cytochrome b5 [Physarum polycephalum]	diamond	387	116	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
32845911	32845911	PRJEB28062_P_NODE_136000_length_216_cov_22.370629_g133636_i0	PRJEB28062	136000	216	22.370629	48.32055864	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	102	1.1399999999999999e-23	NR	PRP89791.1	1890364	g133636	i0	92.5	0.736111111111111	53	4	73.6	0	24	182	416	468	PRP89791.1 hypothetical protein PROFUN_00133 [Planoprotostelium fungivorum]	diamond	159	102	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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