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

14 rows where analysis = "diamond", bioproject = "PRJNA751877" 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
726558	726558	PRJNA751877_P_NODE_5281_length_427_cov_1.644068_g5159_i0	PRJNA751877	5281	427	1.644068	7.02017036	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	107	2.5100000000000004e-27	NR	KYQ93417.1	361077	g5159	i0	68.4	1.04683840749415	76	24	53.4	0	408	181	1	76	KYQ93417.1 40S ribosomal protein S21 [Tieghemostelium lacteum]	diamond	447	107	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
13480113	13480113	PRJNA751877_P_NODE_19471_length_269_cov_0.867347_g19349_i0	PRJNA751877	19471	269	0.867347	2.33316343	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	91.7	1.09e-19	NR	CAA26255.1	44689	g19349	i0	50	4.47211895910781	80	39	89.2	1	13	252	128	206	CAA26255.1 cysteine proteinase I precursor [Dictyostelium discoideum]	diamond	1203	91.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
26641232	26641232	PRJNA751877_P_NODE_7781_length_377_cov_1.013158_g7659_i0	PRJNA751877	7781	377	1.013158	3.81960566	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	101	7.079999999999999e-24	NR	PRP80577.1	1890364	g7659	i0	62.6	0.724137931034483	91	33	71.6	1	317	48	125	215	PRP80577.1 hypothetical protein PROFUN_12339 [Planoprotostelium fungivorum]	diamond	273	101	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
26957681	26957681	PRJNA751877_P_NODE_29822_length_241_cov_0.916667_g29700_i0	PRJNA751877	29822	241	0.916667	2.20916747	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	112	3.25e-27	NR	PRP81576.1	1890364	g29700	i0	73.3	1.87966804979253	75	20	93.4	0	240	16	86	160	PRP81576.1 hypothetical protein PROFUN_01083 [Planoprotostelium fungivorum]	diamond	453	112	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27947181	27947181	PRJNA751877_P_NODE_20885_length_259_cov_2.069892_g20763_i0	PRJNA751877	20885	259	2.069892	5.36102028	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.9	1.88e-13	NR	XP_003283857.1	5786	g20763	i0	46.3	10.0888030888031	80	33	92.7	1	242	3	10	79	XP_003283857.1 40S ribosomal protein S20 [Dictyostelium purpureum]	diamond	2613	70.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
28389112	28389112	PRJNA751877_P_NODE_22466_length_251_cov_0.865169_g22344_i0	PRJNA751877	22466	251	0.865169	2.17157419	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	159	7.94e-45	NR	XP_004366862.1	261658	g22344	i0	84.3	41.0677290836653	83	13	99.2	0	251	3	243	325	XP_004366862.1 phenylalanine 4-monooxygenase [Cavenderia fasciculata]	diamond	10308	160	0.99375	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
28820967	28820967	PRJNA751877_P_NODE_22368_length_251_cov_0.865169_g22246_i0	PRJNA751877	22368	251	0.865169	2.17157419	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	102	2.99e-23	NR	XP_003288217.1	5786	g22246	i0	56.6	0.99203187250996006	83	35	99.2	1	3	251	8	89	XP_003288217.1 uncharacterized protein DICPUDRAFT_152431 [Dictyostelium purpureum]	diamond	249	102	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
29462379	29462379	PRJNA751877_P_NODE_27470_length_244_cov_1.619883_g27348_i0	PRJNA751877	27470	244	1.619883	3.95251452	Dictyosteliales	2058949	Evosea	other_Eukaryota	57	2.54e-7	NR	KAF2078363.1	133409	g27348	i0	46.4	1.70901639344262	69	37	84.8	0	3	209	30	98	KAF2078363.1 hypothetical protein CYY_000347 [Polysphondylium violaceum]	diamond	417	57	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30526654	30526654	PRJNA751877_P_NODE_24093_length_249_cov_0.875000_g23971_i0	PRJNA751877	24093	249	0.875	2.17875	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	57.4	2.71e-7	NR	KAF2072033.1	133409	g23971	i0	34.6	0.975903614457831	81	49	95.2	2	11	247	362	440	KAF2072033.1 hypothetical protein CYY_006644 [Polysphondylium violaceum]	diamond	243	57.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30969200	30969200	PRJNA751877_P_NODE_17074_length_284_cov_0.914692_g16952_i0	PRJNA751877	17074	284	0.914692	2.59772528	Entamoeba histolytica	5759	Evosea	other_Eukaryota	116	8.78e-31	NR	AAC31935.1	5759	g16952	i0	61.7	1.98591549295775	94	34	99.3	2	284	3	19	110	AAC31935.1 Rho GDP exchange inhibitor, partial [Entamoeba histolytica]	diamond	564	116	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
31380105	31380105	PRJNA751877_P_NODE_15756_length_291_cov_2.018349_g15634_i0	PRJNA751877	15756	291	2.018349	5.87339559	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	92.8	4.66e-20	NR	XP_020436051.1	670386	g15634	i0	65.4	1.60824742268041	78	24	77.3	1	258	34	180	257	XP_020436051.1 actin bundling protein [Heterostelium album PN500]	diamond	468	92.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
31380108	31380108	PRJNA751877_P_NODE_22736_length_251_cov_0.865169_g22614_i0	PRJNA751877	22736	251	0.865169	2.17157419	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	112	2.04e-30	NR	PRP89405.1	1890364	g22614	i0	68.9	0.884462151394422	74	23	88.4	0	243	22	18	91	PRP89405.1 40S ribosomal protein S21 [Planoprotostelium fungivorum]	diamond	222	112	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32107507	32107507	PRJNA751877_P_NODE_11918_length_327_cov_1.212598_g11796_i0	PRJNA751877	11918	327	1.212598	3.96519546	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	123	7.389999999999999e-32	NR	KAH3732769.1	1580589	g11796	i0	57.3	1.00917431192661	110	37	99.1	2	327	4	59	160	KAH3732769.1 actin bundling protein [Pelomyxa schiedti]	diamond	330	123	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
32297783	32297783	PRJNA751877_P_NODE_4939_length_437_cov_1.780220_g4817_i0	PRJNA751877	4939	437	1.78022	7.7795614	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	152	1.5699999999999996e-43	NR	PRP86688.1	1890364	g4817	i0	62.8	0.8306636155606412	121	45	83.1	0	435	73	86	206	PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum]	diamond	363	152	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);;