metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1073712" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1073712" 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
2738108	2738108	PRJNA1073712_P_NODE_11143_length_251_cov_0.865169_g11060_i0	PRJNA1073712	11143	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	133	3.4399999999999993e-34	NR	ACZ96462.1	5793	g11060	i0	74.7	29.7609561752988	83	21	99.2	0	249	1	316	398	ACZ96462.1 cytochrome c oxidase subunit 1 [Didymium iridis]	diamond	7470	134	0.992537313432836	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium iridis
5290446	5290446	PRJNA1073712_P_NODE_5305_length_326_cov_1.217391_g5222_i0	PRJNA1073712	5305	326	1.217391	3.96869466	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	195	1.4099999999999998e-57	NR	PRP73396.1	1890364	g5222	i0	82.4	16.7944785276074	108	19	99.4	0	2	325	45	152	PRP73396.1 alpha tubulin [Planoprotostelium fungivorum]	diamond	5475	195	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
24413519	24413519	PRJNA1073712_P_NODE_16280_length_242_cov_0.911243_g16197_i0	PRJNA1073712	16280	242	0.911243	2.20520806	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	145	1.91e-38	NR	XP_020427136.1	670386	g16197	i0	81.3	10.9090909090909	80	15	99.2	0	241	2	348	427	XP_020427136.1 elongation factor 2 [Heterostelium album PN500]	diamond	2640	145	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
26647196	26647196	PRJNA1073712_P_NODE_7741_length_285_cov_1.448113_g7658_i0	PRJNA1073712	7741	285	1.448113	4.12712205	Eumycetozoa	142796	Evosea	other_Eukaryota	124	8.51e-31	NR	KAF2071044.1	133409	g7658	i0	62.4	2.84210526315789	93	35	97.9	0	7	285	36	128	KAF2071044.1 hypothetical protein CYY_007642 [Polysphondylium violaceum]	diamond	810	124	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
26687512	26687512	PRJNA1073712_P_NODE_11841_length_250_cov_0.870056_g11758_i0	PRJNA1073712	11841	250	0.870056	2.17514	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	65.9	2.98e-10	NR	XP_020428689.1	670386	g11758	i0	47.9	0.852	71	36	84	1	210	1	14	84	XP_020428689.1 dolichyl-diphosphooligosaccharide-protein glycotransferase [Heterostelium album PN500]	diamond	213	65.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
26846171	26846171	PRJNA1073712_P_NODE_10181_length_260_cov_1.636364_g10098_i0	PRJNA1073712	10181	260	1.636364	4.2545464	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	69.3	2.02e-11	NR	KYQ96878.1	361077	g10098	i0	71.1	0.519230769230769	45	13	51.9	0	137	3	15	59	KYQ96878.1 gelation factor [Tieghemostelium lacteum]	diamond	135	69.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
28827186	28827186	PRJNA1073712_P_NODE_11988_length_250_cov_0.870056_g11905_i0	PRJNA1073712	11988	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	74.7	3.2e-14	NR	XP_648706.1	294381	g11905	i0	45.1	3.852	82	42	97.2	2	248	6	56	135	XP_648706.1 lysozyme, putative [Entamoeba histolytica HM-1:IMSS]	diamond	963	75.1	0.994673768308922	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
29309447	29309447	PRJNA1073712_P_NODE_7529_length_288_cov_1.093023_g7446_i0	PRJNA1073712	7529	288	1.093023	3.14790624	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	88.6	4.95e-18	NR	PRP84060.1	1890364	g7446	i0	49.5	1.03125	99	43	97.9	3	5	286	372	468	PRP84060.1 hypothetical protein PROFUN_08522 [Planoprotostelium fungivorum]	diamond	297	88.6	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29404252	29404252	PRJNA1073712_P_NODE_11469_length_251_cov_0.865169_g11386_i0	PRJNA1073712	11469	251	0.865169	2.17157419	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	131	1.06e-36	NR	KAF2075979.1	133409	g11386	i0	76.8	3.93227091633466	82	19	98	0	248	3	11	92	KAF2075979.1 hypothetical protein CYY_002735 [Polysphondylium violaceum]	diamond	987	131	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
29679577	29679577	PRJNA1073712_P_NODE_15550_length_243_cov_0.905882_g15467_i0	PRJNA1073712	15550	243	0.905882	2.20129326	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	110	5.38e-26	NR	KYR00361.1	361077	g15467	i0	61.5	11.6543209876543	78	30	96.3	0	242	9	537	614	KYR00361.1 myosin ID heavy chain [Tieghemostelium lacteum]	diamond	2832	110	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29783078	29783078	PRJNA1073712_P_NODE_9991_length_262_cov_1.423280_g9908_i0	PRJNA1073712	9991	262	1.42328	3.7289936	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	56.6	5.7e-7	NR	KAH3759799.1	1580589	g9908	i0	40.8	0.870229007633588	76	45	87	0	231	4	216	291	KAH3759799.1 Rab-GTPase-TBC domain protein [Pelomyxa schiedti]	diamond	228	56.6	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
31458008	31458008	PRJNA1073712_P_NODE_8916_length_272_cov_1.628141_g8833_i0	PRJNA1073712	8916	272	1.628141	4.42854352	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	129	1.5299999999999999e-34	NR	KYR02323.1	361077	g8833	i0	86.5	1.66544117647059	74	10	81.6	0	225	4	127	200	KYR02323.1 actin bundling protein [Tieghemostelium lacteum]	diamond	453	129	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32058860	32058860	PRJNA1073712_P_NODE_11478_length_251_cov_0.865169_g11395_i0	PRJNA1073712	11478	251	0.865169	2.17157419	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	57.4	2.81e-7	NR	PRP74626.1	1890364	g11395	i0	35.5	1.8406374501992	76	49	90.8	0	239	12	97	172	PRP74626.1 hypothetical protein PROFUN_03548 [Planoprotostelium fungivorum]	diamond	462	57.4	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32312350	32312350	PRJNA1073712_P_NODE_14199_length_246_cov_0.890173_g14116_i0	PRJNA1073712	14199	246	0.890173	2.18982558	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	135	2.5799999999999996e-35	NR	KAF2077271.1	133409	g14116	i0	74	5.79268292682927	77	20	93.9	0	246	16	226	302	KAF2077271.1 hypothetical protein CYY_001395 [Polysphondylium violaceum]	diamond	1425	135	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);;