metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA414036" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA414036" 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
26807449	26807449	PRJNA414036_P_NODE_16681_length_365_cov_8.390909_g14978_i0	PRJNA414036	16681	365	8.390909	30.62681785	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.5	4.61e-7	NR	WJH19482.1	3039	g14978	i0	62.3	138.608219178082	77	29	63.3	0	349	119	1787	1863	WJH19482.1 Pre-mRNA-processing-splicing factor 8 (PRPF8) [Euglena gracilis]	diamond	50592	58.5	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29159995	29159995	PRJNA414036_P_NODE_71509_length_179_cov_18.104167_g69770_i0	PRJNA414036	71509	179	18.104167	32.40645893	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	73.9	1.5e-13	NR	KAF5218269.1	5693	g69770	i0	62.1	0.972067039106145	58	22	97.2	0	2	175	175	232	KAF5218269.1 hypothetical protein ECC02_008847 [Trypanosoma cruzi]	diamond	174	73.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
29317585	29317585	PRJNA414036_P_NODE_1869_length_644_cov_38.134647_g1487_i0	PRJNA414036	1869	644	38.134647	245.58712668	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	78.2	1.44e-13	NR	PWV04596.1	5693	g1487	i0	46.5	5.52018633540373	101	54	47	0	316	14	10	110	PWV04596.1 putative heat-shock protein hsp70 [Trypanosoma cruzi]	diamond	3555	78.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
29570117	29570117	PRJNA414036_P_NODE_5170_length_518_cov_9.006211_g4231_i0	PRJNA414036	5170	518	9.006211	46.65217298	Trypanosoma vivax	5699	Euglenozoa	other_Eukaryota	105	2.2699999999999994e-23	NR	KAH8619235.1	5699	g4231	i0	46.3	0.94980694980695	164	76	95	1	14	505	144	295	KAH8619235.1 Ubiquitin 2 like Rad60 SUMO like Ubiquitin family Ubiquitin like domain [Trypanosoma vivax]	diamond	492	105	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
31055312	31055312	PRJNA414036_P_NODE_80495_length_162_cov_2.291339_g78756_i0	PRJNA414036	80495	162	2.291339	3.71196918	Trypanosoma congolense IL3	5692	Euglenozoa	other_Eukaryota	42	0.0231	NR	CCC89923.1	1068625	g78756	i0	46.5	0.796296296296296	43	21	79.6	1	12	140	113	153	CCC89923.1 unnamed protein product [Trypanosoma congolense IL3000]	diamond	129	42	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense
31704063	31704063	PRJNA414036_P_NODE_5117_length_519_cov_6.452479_g4186_i0	PRJNA414036	5117	519	6.452479	33.48836601	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.9	1.54e-6	NR	WJH19482.1	3039	g4186	i0	62.3	97.4797687861272	77	29	44.5	0	503	273	1787	1863	WJH19482.1 Pre-mRNA-processing-splicing factor 8 (PRPF8) [Euglena gracilis]	diamond	50592	58.9	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
32478628	32478628	PRJNA414036_P_NODE_29899_length_274_cov_24.058577_g28163_i0	PRJNA414036	29899	274	24.058577	65.92050098	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	79.7	4.81e-15	NR	KAF5218269.1	5693	g28163	i0	48.2	0.930656934306569	85	44	93.1	0	267	13	147	231	KAF5218269.1 hypothetical protein ECC02_008847 [Trypanosoma cruzi]	diamond	255	79.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
32604769	32604769	PRJNA414036_P_NODE_30700_length_270_cov_6.417021_g28964_i0	PRJNA414036	30700	270	6.417021	17.3259567	Leishmania tarentolae	5689	Euglenozoa	other_Eukaryota	57	1.25e-7	NR	GET88847.1	5689	g28964	i0	75	0.933333333333333	28	7	31.1	0	51	134	125	152	GET88847.1 60S ribosomal protein L17, putative [Leishmania tarentolae]	diamond	252	57	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania tarentolae
32793452	32793452	PRJNA414036_P_NODE_28360_length_282_cov_67.214575_g26625_i0	PRJNA414036	28360	282	67.214575	189.5451015	Leishmania tarentolae	5689	Euglenozoa	other_Eukaryota	88.2	5.9e-18	NR	GET90209.1	5689	g26625	i0	55.4	0.978723404255319	92	41	97.9	0	280	5	10	101	GET90209.1 heat-shock protein hsp70, putative [Leishmania tarentolae]	diamond	276	88.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania tarentolae
32841680	32841680	PRJNA414036_P_NODE_63040_length_205_cov_1.811765_g61301_i0	PRJNA414036	63040	205	1.811765	3.71411825	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.1	0.0168	NR	XP_002676216.1	5762	g61301	i0	66.7	7.11219512195122	27	9	39.5	0	2	82	21	47	XP_002676216.1 uncharacterized protein NAEGRDRAFT_68607 [Naegleria gruberi]	diamond	1458	43.5	0.990804597701149	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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