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

7 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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
15456138	15456138	PRJNA1005695_P_NODE_25033_length_300_cov_1.352423_g24181_i0	PRJNA1005695	25033	300	1.352423	4.057269	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	127	1.15e-31	NR	CCW64685.1	479712	g24181	i0	62.5	2.84	96	36	96	0	11	298	371	466	CCW64685.1 unnamed protein product [Phytomonas sp. EM1]	diamond	852	127	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Phytomonas	Phytomonas sp. EM1
27792767	27792767	PRJNA1005695_P_NODE_35004_length_252_cov_1.458101_g34152_i0	PRJNA1005695	35004	252	1.458101	3.67441452	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	86.3	9.11e-18	NR	WJH19528.1	3039	g34152	i0	47.5	0.952380952380952	80	42	95.2	0	11	250	107	186	WJH19528.1 Mitotic checkpoint protein BUB3 [Euglena gracilis]	diamond	240	86.3	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29813250	29813250	PRJNA1005695_P_NODE_22131_length_319_cov_2.430894_g21279_i0	PRJNA1005695	22131	319	2.430894	7.75455186	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	56.2	1.53e-6	NR	RNC44100.1	5693	g21279	i0	37.9	3.29153605015674	87	48	76.2	3	317	75	286	372	RNC44100.1 protein kinase [Trypanosoma cruzi]	diamond	1050	56.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
31132564	31132564	PRJNA1005695_P_NODE_37015_length_248_cov_0.891429_g36163_i0	PRJNA1005695	37015	248	0.891429	2.21074392	Trypanosoma	5690	Euglenozoa	other_Eukaryota	69.3	1.7e-11	NR	XP_009307139.1	71804	g36163	i0	52.9	4.62096774193548	68	29	78.6	1	17	211	253	320	XP_009307139.1 putative dynamin, putative,vacuolar sortin protein 1 [Trypanosoma grayi]	diamond	1146	69.7	0.994261119081779	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
31835919	31835919	PRJNA1005695_P_NODE_35537_length_251_cov_0.876404_g34685_i0	PRJNA1005695	35537	251	0.876404	2.19977404	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	85.9	2.13e-17	NR	KAJ9460418.1	91374	g34685	i0	55.7	0.944223107569721	79	32	93.2	2	241	8	246	322	KAJ9460418.1 Ornithine decarboxylase [Diplonema papillatum]	diamond	237	85.9	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32152553	32152553	PRJNA1005695_P_NODE_37038_length_248_cov_0.891429_g36186_i0	PRJNA1005695	37038	248	0.891429	2.21074392	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	137	1.24e-38	NR	6ZJ3_SI	3039	g36186	i0	78	0.991935483870968	82	18	99.2	0	247	2	115	196	6ZJ3_SI Chain SI, Ribosomal protein eS7 [Euglena gracilis]	diamond	246	137	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
32279284	32279284	PRJNA1005695_P_NODE_29119_length_277_cov_1.465686_g28267_i0	PRJNA1005695	29119	277	1.465686	4.05995022	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	138	1.32e-36	NR	KAJ9467333.1	91374	g28267	i0	66.3	0.996389891696751	92	31	99.6	0	2	277	184	275	KAJ9467333.1 Tryptophan--tRNA ligase [Diplonema papillatum]	diamond	276	138	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum

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