metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_clade = "Discoba"

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
10615297	10615297	PRJNA395690_P_NODE_10129_length_256_cov_0.966184_g9977_i0	PRJNA395690	10129	256	0.966184	2.47343104	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	95.9	6.05e-22	NR	AEL74938.1	1073397	g9977	i0	52.4	10.9921875	84	40	98.4	0	3	254	26	109	AEL74938.1 elongation factor 2, partial [Ichthyobodo-related endosymbiont of Neoparamoeba]	diamond	2814	95.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae		Ichthyobodo-related endosymbiont of Neoparamoeba
15106725	15106725	PRJNA395690_P_NODE_26972_length_170_cov_1.314050_g26820_i0	PRJNA395690	26972	170	1.31405	2.233885	Bodo saltans	75058	Euglenozoa	other_Eukaryota	73.6	6.31e-15	NR	CUF90321.1	75058	g26820	i0	72.9	0.847058823529412	48	13	84.7	0	144	1	1	48	CUF90321.1 60S ribosomal protein L22, putative [Bodo saltans]	diamond	144	73.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27201576	27201576	PRJNA395690_P_NODE_28402_length_167_cov_0.864407_g28250_i0	PRJNA395690	28402	167	0.864407	1.44355969	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	101	4.89e-24	NR	XP_009312354.1	71804	g28250	i0	77.4	0.952095808383233	53	12	95.2	0	160	2	130	182	XP_009312354.1 hypothetical protein DQ04_05251070 [Trypanosoma grayi]	diamond	159	101	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
27833370	27833370	PRJNA395690_P_NODE_34724_length_162_cov_0.902655_g34572_i0	PRJNA395690	34724	162	0.902655	1.4623011	Bodo saltans	75058	Euglenozoa	other_Eukaryota	94.4	1.6400000000000002e-21	NR	ACI16047.1	75058	g34572	i0	76.9	0.962962962962963	52	12	96.3	0	6	161	159	210	ACI16047.1 hypothetical protein [Bodo saltans]	diamond	156	94.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28023032	28023032	PRJNA395690_P_NODE_3505_length_420_cov_1.633423_g3356_i0	PRJNA395690	3505	420	1.633423	6.8603766	Perkinsela sp. CCAP 156	1935466	Euglenozoa	other_Eukaryota	84.7	1.14e-17	NR	KNH05062.1	1314962	g3356	i0	43.5	1.97142857142857	92	52	65.7	0	276	1	18	109	KNH05062.1 translation initiation factor eIF-5A family protein [Perkinsela sp. CCAP 1560/4]	diamond	828	84.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
29934326	29934326	PRJNA395690_P_NODE_28331_length_167_cov_0.864407_g28179_i0	PRJNA395690	28331	167	0.864407	1.44355969	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	70.9	2.13e-13	NR	EPY22638.1	28005	g28179	i0	68.5	1.94011976047904	54	15	97	2	164	3	126	177	EPY22638.1 large subunit ribosomal protein L31e [Strigomonas culicis]	diamond	324	71.6	0.990223463687151	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
32431791	32431791	PRJNA395690_P_NODE_9019_length_271_cov_1.378378_g8867_i0	PRJNA395690	9019	271	1.378378	3.73540438	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	141	1.26e-39	NR	WCZ58714.1	221724	g8867	i0	67.4	5.87822878228782	89	29	98.5	0	3	269	60	148	WCZ58714.1 60S ribosomal protein L8 [Seculamonas ecuadoriensis]	diamond	1593	141	1	Eukaryota	Discoba			Jakobida		Seculamonas	Seculamonas ecuadoriensis
32762001	32762001	PRJNA395690_P_NODE_20960_length_184_cov_1.607407_g20808_i0	PRJNA395690	20960	184	1.607407	2.95762888	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	66.2	2.64e-11	NR	XP_011774409.1	679716	g20808	i0	69.6	9.76630434782609	46	14	75	0	180	43	169	214	XP_011774409.1 40S ribosomal protein S16, putative [Trypanosoma brucei gambiense DAL972]	diamond	1797	66.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei

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