metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1174207" 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
26977169	26977169	PRJNA1174207_P_NODE_16442_length_354_cov_1.096085_g15913_i0	PRJNA1174207	16442	354	1.096085	3.8801409	Perkinsela sp. CCAP 156	1935466	Euglenozoa	other_Eukaryota	62.4	1e-9	NR	KNH07262.1	1314962	g15913	i0	46.5	1.67796610169492	99	40	77.1	4	334	62	24	117	KNH07262.1 hypothetical protein XU18_1794 [Perkinsela sp. CCAP 1560/4]	diamond	594	62.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
28272081	28272081	PRJNA1174207_P_NODE_39406_length_243_cov_2.700000_g38877_i0	PRJNA1174207	39406	243	2.7	6.561	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	114	2.2600000000000003e-27	NR	KAJ9463026.1	91374	g38877	i0	69.6	0.975308641975309	79	23	96.3	1	3	236	571	649	KAJ9463026.1 Tetratricopeptide repeat protein 30-like protein [Diplonema papillatum]	diamond	237	114	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
28828081	28828081	PRJNA1174207_P_NODE_24168_length_289_cov_1.902778_g23639_i0	PRJNA1174207	24168	289	1.902778	5.49902842	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	112	2.79e-28	NR	KAG8343516.1	5699	g23639	i0	62.5	1.8477508650519	88	30	91.3	2	23	286	8	92	KAG8343516.1 tRNA (guanine-N(7)-)-methyltransferase [Trypanosoma vivax]	diamond	534	112	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
32695713	32695713	PRJNA1174207_P_NODE_24500_length_288_cov_1.260465_g23971_i0	PRJNA1174207	24500	288	1.260465	3.6301392	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	77.8	7.01e-15	NR	KAJ9452845.1	91374	g23971	i0	72.9	0.614583333333333	59	16	61.5	0	180	4	19	77	KAJ9452845.1 60S ribosomal protein L7a-1 [Diplonema papillatum]	diamond	177	77.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32903781	32903781	PRJNA1174207_P_NODE_28960_length_269_cov_1.311224_g28431_i0	PRJNA1174207	28960	269	1.311224	3.52719256	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	1.52e-5	NR	TPP48223.1	5661	g28431	i0	44.7	8.55390334572491	47	26	52.4	0	24	164	101	147	TPP48223.1 Flagellar C1a complex subunit C1a-32 family protein [Leishmania donovani]	diamond	2301	53.1	0.994350282485876	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani

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