metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1240805" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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
26724953	26724953	PRJNA1240805_P_NODE_2041_length_338_cov_7.204152_g1992_i0	PRJNA1240805	2041	338	7.204152	24.35003376	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	111	4.509999999999999e-28	NR	QLA09622.1	3039	g1992	i0	62.8	0.763313609467456	86	29	73.7	1	28	276	97	182	QLA09622.1 60S large subunit ribosomal protein eL18 [Euglena gracilis]	diamond	258	111	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
26820590	26820590	PRJNA1240805_P_NODE_5361_length_197_cov_4.506757_g5312_i0	PRJNA1240805	5361	197	4.506757	8.87831129	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	52.8	9.31e-7	NR	KAJ9462441.1	91374	g5312	i0	71.9	5.36040609137056	32	9	48.7	0	23	118	87	118	KAJ9462441.1 60S ribosomal protein L35a [Diplonema papillatum]	diamond	1056	52.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27579034	27579034	PRJNA1240805_P_NODE_5144_length_201_cov_9.986842_g5095_i0	PRJNA1240805	5144	201	9.986842	20.07355242	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	82.4	7.35e-19	NR	QLA09593.1	3039	g5095	i0	97.6	0.611940298507463	41	1	61.2	0	24	146	36	76	QLA09593.1 40S small subunit ribosomal protein eS28 [Euglena gracilis]	diamond	123	82.4	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
29031721	29031721	PRJNA1240805_P_NODE_4008_length_230_cov_8.502762_g3959_i0	PRJNA1240805	4008	230	8.502762	19.5563526	Bodo saltans	75058	Euglenozoa	other_Eukaryota	62	3.27e-10	NR	CUG91869.1	75058	g3959	i0	43.3	2.49130434782609	67	37	86.1	1	217	20	49	115	CUG91869.1 coatamer zeta subunit, putative [Bodo saltans]	diamond	573	62	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31559130	31559130	PRJNA1240805_P_NODE_7096_length_173_cov_1.435484_g7047_i0	PRJNA1240805	7096	173	1.435484	2.48338732	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	51.6	1.08e-5	NR	KAJ9468081.1	91374	g7047	i0	63.2	7.5606936416185	38	14	65.9	0	60	173	116	153	KAJ9468081.1 member 9 [Diplonema papillatum]	diamond	1308	51.6	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32886003	32886003	PRJNA1240805_P_NODE_3740_length_239_cov_2.705263_g3691_i0	PRJNA1240805	3740	239	2.705263	6.46557857	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	69.3	1.78e-12	NR	Q84TU6.1	3039	g3691	i0	88.6	0.439330543933054	35	4	43.9	0	230	126	139	173	Q84TU6.1 RecName: Full=Cytochrome b6-f complex subunit 4, chloroplastic; AltName: Full=17 kDa polypeptide; Flags: Precursor [Euglena gracilis]	diamond	105	69.3	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);;