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

7 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_phylum = "Evosea"

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
14394861	14394861	PRJNA188516_P_NODE_2032_length_243_cov_1.072165_g1982_i0	PRJNA188516	2032	243	1.072165	2.60536095	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	90.1	9.61e-22	NR	PRP81011.1	1890364	g1982	i0	77.4	3.12345679012346	62	13	76.5	1	26	211	9	69	PRP81011.1 40S ribosomal protein S28 [Planoprotostelium fungivorum]	diamond	759	90.1	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
26662125	26662125	PRJNA188516_P_NODE_6061_length_162_cov_0.920354_g6011_i0	PRJNA188516	6061	162	0.920354	1.49097348	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	79	2.18e-15	NR	KAH3764675.1	1580589	g6011	i0	57.1	1.03703703703704	56	21	98.1	1	159	1	660	715	KAH3764675.1 e3 ubiquitin-protein ligase [Pelomyxa schiedti]	diamond	168	79	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
28860098	28860098	PRJNA188516_P_NODE_5828_length_163_cov_0.912281_g5778_i0	PRJNA188516	5828	163	0.912281	1.48701803	Eumycetozoa	142796	Evosea	other_Eukaryota	60.5	6.77e-9	NR	KAF2073298.1	133409	g5778	i0	51.9	1.87730061349693	52	25	95.7	0	161	6	491	542	KAF2073298.1 hypothetical protein CYY_005397 [Polysphondylium violaceum]	diamond	306	60.8	0.995065789473684	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
29095138	29095138	PRJNA188516_P_NODE_5568_length_164_cov_0.886957_g5518_i0	PRJNA188516	5568	164	0.886957	1.45460948	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	68.9	7.32e-12	NR	PRP80802.1	1890364	g5518	i0	60.8	1.86585365853659	51	20	93.3	0	160	8	263	313	PRP80802.1 clathrin heavy chain, partial [Planoprotostelium fungivorum]	diamond	306	68.9	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30295520	30295520	PRJNA188516_P_NODE_2992_length_197_cov_2.527027_g2942_i0	PRJNA188516	2992	197	2.527027	4.97824319	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	76.6	1.96e-14	NR	PRP77394.1	1890364	g2942	i0	44.6	0.989847715736041	65	36	99	0	196	2	300	364	PRP77394.1 hypothetical protein PROFUN_14400 [Planoprotostelium fungivorum]	diamond	195	76.6	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32019999	32019999	PRJNA188516_P_NODE_5358_length_164_cov_0.904348_g5308_i0	PRJNA188516	5358	164	0.904348	1.48313072	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	66.2	6.5e-11	NR	XP_020428166.1	670386	g5308	i0	55.6	8.76219512195122	54	24	98.8	0	163	2	458	511	XP_020428166.1 pleckstrin domain-containing protein [Heterostelium album PN500]	diamond	1437	66.6	0.993993993993994	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
32381920	32381920	PRJNA188516_P_NODE_4739_length_167_cov_0.881356_g4689_i0	PRJNA188516	4739	167	0.881356	1.47186452	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	54.7	8.11e-7	NR	KAF2078218.1	133409	g4689	i0	54.2	1.72455089820359	48	21	84.4	1	25	165	1172	1219	KAF2078218.1 hypothetical protein CYY_000508 [Polysphondylium violaceum]	diamond	288	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum

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