metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJDB3785" and tax

12 rows where analysis = "diamond", bioproject = "PRJDB3785" and tax_phylum = "Euglenozoa"

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
20409567	20409567	PRJDB3785_S_NODE_6137_length_304_cov_1.662745_g5984_i0	PRJDB3785	6137	304	1.662745	5.0547448	Strigomonas culicis	28005	Euglenozoa	other_Eukaryota	175	1.06e-51	NR	EPY33803.1	28005	g5984	i0	79	9.86842105263158	100	21	98.7	0	302	3	204	303	EPY33803.1 elongation factor 1-alpha [Strigomonas culicis]	diamond	3000	175	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
24234575	24234575	PRJDB3785_S_NODE_12920_length_213_cov_3.743902_g12767_i0	PRJDB3785	12920	213	3.743902	7.97451126	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	113	1.23e-27	NR	TPP51631.1	5661	g12767	i0	72.9	26.6197183098592	70	19	98.6	0	3	212	306	375	TPP51631.1 translation elongation factor EF-1, subunit alpha [Leishmania donovani]	diamond	5670	113	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani
24234758	24234758	PRJDB3785_S_NODE_3840_length_391_cov_1.517544_g3687_i0	PRJDB3785	3840	391	1.517544	5.93359704	Perkinsela sp. CCAP 156	1935466	Euglenozoa	other_Eukaryota	192	4.7199999999999994e-57	NR	KNH05488.1	1314962	g3687	i0	70	4.96419437340153	130	37	99.7	1	2	391	229	356	KNH05488.1 ribosomal protein L3 [Perkinsela sp. CCAP 1560/4]	diamond	1941	192	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
27095605	27095605	PRJDB3785_S_NODE_27302_length_161_cov_0.910714_g27149_i0	PRJDB3785	27302	161	0.910714	1.46624954	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	88.6	8.62e-19	NR	AAF71706.1	3039	g27149	i0	79.2	2.96273291925466	53	11	98.8	0	2	160	372	424	AAF71706.1 elongation factor 2, partial [Euglena gracilis]	diamond	477	88.6	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
28485275	28485275	PRJDB3785_S_NODE_5827_length_312_cov_2.536122_g5674_i0	PRJDB3785	5827	312	2.536122	7.91270064	Strigomonas culicis	28005	Euglenozoa	other_Eukaryota	68.9	5.71e-12	NR	EPY31477.1	28005	g5674	i0	41.7	0.990384615384615	103	49	91.3	5	310	26	3	102	EPY31477.1 IgE-dependent histamine-releasing factor [Strigomonas culicis]	diamond	309	68.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
28826413	28826413	PRJDB3785_S_NODE_13448_length_210_cov_1.149068_g13295_i0	PRJDB3785	13448	210	1.149068	2.4130428	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	72.8	6.11e-13	NR	XP_067081308.1	5694	g13295	i0	60	5.47142857142857	60	24	85.7	0	30	209	221	280	XP_067081308.1 major vault protein, putative [Trypanosoma equiperdum]	diamond	1149	73.2	0.994535519125683	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma equiperdum
29457827	29457827	PRJDB3785_S_NODE_16070_length_195_cov_1.123288_g15917_i0	PRJDB3785	16070	195	1.123288	2.1904116	Trypanosoma	5690	Euglenozoa	other_Eukaryota	80.1	3.83e-17	NR	5T5H_P	5693	g15917	i0	65.1	5.75384615384615	63	22	96.9	0	195	7	83	145	5T5H_P Chain P, 40S ribosomal protein L14 [Trypanosoma cruzi]	diamond	1122	80.5	0.995031055900621	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
30443329	30443329	PRJDB3785_S_NODE_21353_length_173_cov_1.096774_g21200_i0	PRJDB3785	21353	173	1.096774	1.89741902	Bodo saltans	75058	Euglenozoa	other_Eukaryota	88.2	2.05e-20	NR	CUE63139.1	75058	g21200	i0	70.2	5.93063583815029	57	17	98.8	0	172	2	18	74	CUE63139.1 40S ribosomal protein S18, putative [Bodo saltans]	diamond	1026	88.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31327922	31327922	PRJDB3785_S_NODE_12836_length_214_cov_1.539394_g12683_i0	PRJDB3785	12836	214	1.539394	3.29430316	Leishmania braziliensis	5660	Euglenozoa	other_Eukaryota	104	1.0999999999999998e-24	NR	CAJ2470497.1	5660	g12683	i0	69.6	1.86448598130841	69	21	96.7	0	213	7	161	229	CAJ2470497.1 unnamed protein product [Leishmania braziliensis]	diamond	399	104	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
31897341	31897341	PRJDB3785_S_NODE_16757_length_192_cov_1.006993_g16604_i0	PRJDB3785	16757	192	1.006993	1.93342656	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	97.8	9.55e-25	NR	XP_067193009.1	715481	g16604	i0	66.7	0.984375	63	21	98.4	0	191	3	27	89	XP_067193009.1 HpcH/HpaI aldolase/citrate lyase domain [Trypanosoma melophagium]	diamond	189	97.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
32429424	32429424	PRJDB3785_S_NODE_10519_length_233_cov_3.027174_g10366_i0	PRJDB3785	10519	233	3.027174	7.05331542	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	92.8	6.98e-22	NR	XP_029237886.1	5698	g10366	i0	59.2	1.96995708154506	76	30	97.9	1	228	1	70	144	XP_029237886.1 60S ribosomal protein L4, partial [Trypanosoma rangeli]	diamond	459	93.2	0.995708154506438	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
32719271	32719271	PRJDB3785_S_NODE_9160_length_249_cov_2.280000_g9007_i0	PRJDB3785	9160	249	2.28	5.6772	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	82	1.46e-16	NR	QLA09580.1	3039	g9007	i0	54.8	1.75903614457831	73	31	88	1	249	31	48	118	QLA09580.1 40S small subunit ribosomal protein eS4 [Euglena gracilis]	diamond	438	82	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis

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