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

7 rows where analysis = "diamond", bioproject = "PRJNA799842" 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
27338600	27338600	PRJNA799842_P_NODE_116843_length_271_cov_1.186869_g115270_i0	PRJNA799842	116843	271	1.186869	3.21641499	Bodo saltans	75058	Euglenozoa	other_Eukaryota	134	7.72e-37	NR	CUG06241.1	75058	g115270	i0	62.5	0.974169741697417	88	33	97.4	0	269	6	51	138	CUG06241.1 Hypothetical protein, putative [Bodo saltans]	diamond	264	134	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27496498	27496498	PRJNA799842_P_NODE_160863_length_246_cov_0.890173_g159290_i0	PRJNA799842	160863	246	0.890173	2.18982558	Trypanosoma congolense IL3	5692	Euglenozoa	other_Eukaryota	44.7	0.00795	NR	CCD17381.1	1068625	g159290	i0	32.9	1.85365853658537	76	35	80.5	2	215	18	379	448	CCD17381.1 unnamed protein product [Trypanosoma congolense IL3000]	diamond	456	44.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense
28033284	28033284	PRJNA799842_P_NODE_108785_length_280_cov_1.859903_g107212_i0	PRJNA799842	108785	280	1.859903	5.2077284	Bodo saltans	75058	Euglenozoa	other_Eukaryota	62	9.2e-9	NR	CUG00411.1	75058	g107212	i0	41.1	0.782142857142857	73	43	78.2	0	7	225	75	147	CUG00411.1 Hypothetical protein, putative [Bodo saltans]	diamond	219	62	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28980564	28980564	PRJNA799842_P_NODE_14708_length_809_cov_5.938859_g13352_i0	PRJNA799842	14708	809	5.938859	48.04536931	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	196	1.4599999999999998e-54	NR	KAJ9461372.1	91374	g13352	i0	39.6	1.74289245982695	235	141	86.8	1	706	5	378	612	KAJ9461372.1 Proline dehydrogenase 1 [Diplonema papillatum]	diamond	1410	196	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29296110	29296110	PRJNA799842_P_NODE_177289_length_243_cov_0.905882_g175716_i0	PRJNA799842	177289	243	0.905882	2.20129326	Bodo saltans	75058	Euglenozoa	other_Eukaryota	82	5.59e-16	NR	CUG74949.1	75058	g175716	i0	48.1	1	81	42	100	0	243	1	317	397	CUG74949.1 paraflagellar rod protein 2C, putative [Bodo saltans]	diamond	243	82	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29643081	29643081	PRJNA799842_P_NODE_101590_length_289_cov_1.069444_g100017_i0	PRJNA799842	101590	289	1.069444	3.09069316	Leptomonas seymouri	5684	Euglenozoa	other_Eukaryota	84.3	1.53e-16	NR	KPI89192.1	5684	g100017	i0	45.5	5.01384083044983	99	51	99.7	2	2	289	125	223	KPI89192.1 hypothetical protein ABL78_1685 [Leptomonas seymouri]	diamond	1449	84.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas seymouri
31634168	31634168	PRJNA799842_P_NODE_180216_length_243_cov_0.905882_g178643_i0	PRJNA799842	180216	243	0.905882	2.20129326	Bodo saltans	75058	Euglenozoa	other_Eukaryota	53.5	4.77e-6	NR	CUE69977.1	75058	g178643	i0	41.3	0.987654320987654	80	45	96.3	1	235	2	141	220	CUE69977.1 glutathione S-transferase, putative [Bodo saltans]	diamond	240	53.5	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);;