metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1092581" 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
7849458	7849458	PRJNA1092581_P_NODE_37567_length_448_cov_2.677333_g37035_i0	PRJNA1092581	37567	448	2.677333	11.99445184	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	109	1.45e-24	NR	KAJ9447580.1	91374	g37035	i0	56.2	1.40625	105	41	67	1	446	147	256	360	KAJ9447580.1 Kinesin-like protein unc-104 [Diplonema papillatum]	diamond	630	109	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27035963	27035963	PRJNA1092581_P_NODE_66622_length_322_cov_2.923695_g66089_i0	PRJNA1092581	66622	322	2.923695	9.4142979	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	104	3.64e-24	NR	XP_011780224.1	679716	g66089	i0	50	0.93167701863354	100	50	93.2	0	300	1	27	126	XP_011780224.1 TGF-beta receptor interacting protein 1 [Trypanosoma brucei gambiense DAL972]	diamond	300	104	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
27099128	27099128	PRJNA1092581_P_NODE_35802_length_460_cov_2.010336_g35270_i0	PRJNA1092581	35802	460	2.010336	9.2475456	Bodo saltans	75058	Euglenozoa	other_Eukaryota	153	2.6499999999999994e-42	NR	CUG90006.1	75058	g35270	i0	55.6	0.867391304347826	133	59	86.7	0	2	400	205	337	CUG90006.1 WD40 repeat-containing protein, putative [Bodo saltans]	diamond	399	153	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29215187	29215187	PRJNA1092581_P_NODE_92949_length_264_cov_3.319372_g92416_i0	PRJNA1092581	92949	264	3.319372	8.76314208	Bodo saltans	75058	Euglenozoa	other_Eukaryota	125	1.4799999999999998e-31	NR	CUG92151.1	75058	g92416	i0	74.7	0.852272727272727	75	19	85.2	0	245	21	67	141	CUG92151.1 Hypothetical protein, putative [Bodo saltans]	diamond	225	125	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29522020	29522020	PRJNA1092581_P_NODE_93710_length_263_cov_2.189474_g93177_i0	PRJNA1092581	93710	263	2.189474	5.75831662	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	69.7	8.06e-12	NR	XP_015659094.1	157538	g93177	i0	56.1	2.78326996197719	82	31	87.8	1	16	246	137	218	XP_015659094.1 putative 60S ribosomal protein L13 [Leptomonas pyrrhocoris]	diamond	732	69.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
29593456	29593456	PRJNA1092581_P_NODE_98370_length_255_cov_4.637363_g97837_i0	PRJNA1092581	98370	255	4.637363	11.82527565	Procryptobia sorokini	351715	Euglenozoa	other_Eukaryota	54.7	2.57e-6	NR	AIM46995.1	351715	g97837	i0	75	0.423529411764706	36	9	42.4	0	23	130	443	478	AIM46995.1 translation elongation factor-like protein [Procryptobia sorokini]	diamond	108	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Parabodonida		Procryptobia	Procryptobia sorokini
30004465	30004465	PRJNA1092581_P_NODE_100691_length_252_cov_1.525140_g100158_i0	PRJNA1092581	100691	252	1.52514	3.8433528	Bodo saltans	75058	Euglenozoa	other_Eukaryota	46.2	0.00266	NR	CUG88143.1	75058	g100158	i0	47.2	0.630952380952381	53	28	63.1	0	237	79	1575	1627	CUG88143.1 transmembrane protein, putative [Bodo saltans]	diamond	159	46.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31458198	31458198	PRJNA1092581_P_NODE_68836_length_316_cov_2.395062_g68303_i0	PRJNA1092581	68836	316	2.395062	7.56839592	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	119	1.6499999999999999e-28	NR	XP_028887863.1	67003	g68303	i0	55.1	1.80379746835443	98	44	93	0	303	10	1391	1488	XP_028887863.1 putative dynein heavy chain [Trypanosoma theileri]	diamond	570	119	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
32312479	32312479	PRJNA1092581_P_NODE_109099_length_241_cov_4.130952_g108566_i0	PRJNA1092581	109099	241	4.130952	9.95559432	Bodo saltans	75058	Euglenozoa	other_Eukaryota	45.8	0.00303	NR	CUG17862.1	75058	g108566	i0	50	0.49792531120332	40	20	49.8	0	112	231	76	115	CUG17862.1 Hypothetical protein, putative [Bodo saltans]	diamond	120	45.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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