metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB2925" 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
14054321	14054321	PRJEB2925_P_NODE_7712_length_452_cov_1.712230_g6509_i0	PRJEB2925	7712	452	1.71223	7.7392796	Petalomonas cantuscygni	56452	Euglenozoa	other_Eukaryota	182	6.49e-51	NR	ABG77329.1	56452	g6509	i0	66.5	1.06858407079646	161	43	99.6	1	452	3	124	284	ABG77329.1 Hsp90, partial [Petalomonas cantuscygni]	diamond	483	182	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Petalomonadida	Scytomonadidae	Petalomonas	Petalomonas cantuscygni
16602976	16602976	PRJEB2925_P_NODE_7734_length_451_cov_1.634615_g6531_i0	PRJEB2925	7734	451	1.634615	7.37211365	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	223	5.06e-71	NR	QLA09565.1	3039	g6531	i0	77.6	51.19955654102	143	32	95.1	0	429	1	7	149	QLA09565.1 40S small subunit ribosomal protein uS3 [Euglena gracilis]	diamond	23091	224	0.995535714285714	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
19151662	19151662	PRJEB2925_P_NODE_4736_length_629_cov_1.910774_g3761_i0	PRJEB2925	4736	629	1.910774	12.01876846	Petalomonas cantuscygni	56452	Euglenozoa	other_Eukaryota	283	2.61e-88	NR	ABG77329.1	56452	g3761	i0	69.9	0.996820349761526	209	51	99.7	1	3	629	405	601	ABG77329.1 Hsp90, partial [Petalomonas cantuscygni]	diamond	627	283	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Petalomonadida	Scytomonadidae	Petalomonas	Petalomonas cantuscygni
21702902	21702902	PRJEB2925_P_NODE_7658_length_454_cov_1.892601_g6459_i0	PRJEB2925	7658	454	1.892601	8.59240854	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	261	3.26e-84	NR	AAC99646.1	3039	g6459	i0	82	0.991189427312775	150	27	99.1	0	452	3	220	369	AAC99646.1 actin [Euglena gracilis]	diamond	450	261	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
27216161	27216161	PRJEB2925_P_NODE_6382_length_516_cov_4.195426_g5261_i0	PRJEB2925	6382	516	4.195426	21.64839816	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	74.3	1.44e-13	NR	KNH05339.1	1314962	g5261	i0	39.4	1.73255813953488	104	63	60.5	0	315	4	2	105	KNH05339.1 ribosomal protein L31 [Perkinsela sp. CCAP 1560/4]	diamond	894	74.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
27697042	27697042	PRJEB2925_P_NODE_9924_length_369_cov_1.416168_g8652_i0	PRJEB2925	9924	369	1.416168	5.22565992	Angomonas deanei	59799	Euglenozoa	other_Eukaryota	127	1e-34	NR	EPY28045.1	59799	g8652	i0	61.2	1.96747967479675	121	43	95.1	2	356	6	26	146	EPY28045.1 histone H3 [Angomonas deanei]	diamond	726	127	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
28233178	28233178	PRJEB2925_P_NODE_16646_length_238_cov_1.768473_g15368_i0	PRJEB2925	16646	238	1.768473	4.20896574	Bodo saltans	75058	Euglenozoa	other_Eukaryota	52.4	7.4e-6	NR	CUG89236.1	75058	g15368	i0	100	0.315126050420168	25	0	31.5	0	75	1	117	141	CUG89236.1 60S ribosomal protein L18, putative [Bodo saltans]	diamond	75	52.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28801580	28801580	PRJEB2925_P_NODE_16008_length_248_cov_1.126761_g14730_i0	PRJEB2925	16008	248	1.126761	2.79436728	Strigomonas culicis	28005	Euglenozoa	other_Eukaryota	73.2	7.6e-13	NR	EPY31750.1	28005	g14730	i0	44.3	1.8991935483871	79	44	95.6	0	237	1	682	760	EPY31750.1 heat shock protein 110kDa [Strigomonas culicis]	diamond	471	73.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
29243856	29243856	PRJEB2925_P_NODE_11109_length_334_cov_1.976589_g9835_i0	PRJEB2925	11109	334	1.976589	6.60180726	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	116	6.489999999999999e-31	NR	QLA09628.1	3039	g9835	i0	51.4	0.94311377245509	105	50	93.4	1	315	4	1	105	QLA09628.1 60S large subunit ribosomal protein eL27 [Euglena gracilis]	diamond	315	116	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29528056	29528056	PRJEB2925_P_NODE_15010_length_261_cov_1.827434_g13732_i0	PRJEB2925	15010	261	1.827434	4.76960274	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	53.1	3.15e-7	NR	QLA09639.1	3039	g13732	i0	79.3	0.333333333333333	29	6	33.3	0	9	95	1	29	QLA09639.1 60S large subunit ribosomal protein eL39 [Euglena gracilis]	diamond	87	53.1	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
30444133	30444133	PRJEB2925_P_NODE_6393_length_516_cov_1.469854_g5272_i0	PRJEB2925	6393	516	1.469854	7.58444664	Bodo saltans	75058	Euglenozoa	other_Eukaryota	288	1.51e-95	NR	CUG87640.1	75058	g5272	i0	83.1	1.02906976744186	177	23	98.8	2	2	511	100	276	CUG87640.1 40S ribosomal protein S4, putative [Bodo saltans]	diamond	531	288	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31259049	31259049	PRJEB2925_P_NODE_1815_length_1289_cov_10.440191_g1345_i0	PRJEB2925	1815	1289	10.440191	134.57406199	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	125	9.36e-31	NR	KAJ9469984.1	91374	g1345	i0	55.4	0.514352211016292	112	45	24.9	2	1286	966	3	114	KAJ9469984.1 hypothetical protein DIPPA_35953 [Diplonema papillatum]	diamond	663	125	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32024763	32024763	PRJEB2925_P_NODE_15478_length_255_cov_1.277273_g14200_i0	PRJEB2925	15478	255	1.277273	3.25704615	Trypanosoma rangeli	5698	Euglenozoa	other_Eukaryota	43.1	0.00755	NR	XP_029235543.1	5698	g14200	i0	29.2	1.67058823529412	72	51	84.7	0	26	241	13	84	XP_029235543.1 ribonucleoprotein p18, mitochondrial precursor, partial [Trypanosoma rangeli]	diamond	426	43.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
32246544	32246544	PRJEB2925_P_NODE_14118_length_273_cov_2.642857_g12840_i0	PRJEB2925	14118	273	2.642857	7.21499961	Strigomonas culicis	28005	Euglenozoa	other_Eukaryota	117	2.4699999999999997e-30	NR	EPY29430.1	28005	g12840	i0	67.4	2.85714285714286	86	28	94.5	0	273	16	124	209	EPY29430.1 heat shock protein 70 [Strigomonas culicis]	diamond	780	117	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
32839409	32839409	PRJEB2925_P_NODE_9480_length_383_cov_3.879310_g8210_i0	PRJEB2925	9480	383	3.87931	14.8577573	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	84.3	2.59e-17	NR	XP_818671.1	5693	g8210	i0	41.8	7.7154046997389	122	65	95.6	2	367	2	76	191	XP_818671.1 translation elongation factor 1-beta, putative [Trypanosoma cruzi]	diamond	2955	85.1	0.990599294947121	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi

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