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

6 rows where analysis = "diamond", bioproject = "PRJNA909412" 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
6353206	6353206	PRJNA909412_P_NODE_1405_length_465_cov_3.105634_g1266_i0	PRJNA909412	1405	465	3.105634	14.4411981	Monomorphina pyrum	96784	Euglenozoa	other_Eukaryota	230	2.61e-73	NR	AGR66195.1	96784	g1266	i0	68.6	0.987096774193548	153	48	98.7	0	464	6	61	213	AGR66195.1 methionine adenosyltransferase, partial [Monomorphina pyrum]	diamond	459	230	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Monomorphina	Monomorphina pyrum
27056128	27056128	PRJNA909412_P_NODE_5102_length_231_cov_3.062500_g4961_i0	PRJNA909412	5102	231	3.0625	7.074375	Leptomonas seymouri	5684	Euglenozoa	other_Eukaryota	42.7	0.0307	NR	KPI82449.1	5684	g4961	i0	46.3	0.701298701298701	54	14	50.6	1	231	115	71	124	KPI82449.1 putative nucleolar RNA-binding protein, partial [Leptomonas seymouri]	diamond	162	42.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas seymouri
27372427	27372427	PRJNA909412_P_NODE_11923_length_165_cov_2.293651_g11782_i0	PRJNA909412	11923	165	2.293651	3.78452415	Perkinsela sp. CCAP 156	1935466	Euglenozoa	other_Eukaryota	58.9	2.48e-8	NR	KNH03693.1	1314962	g11782	i0	51.1	0.854545454545454	47	23	85.5	0	146	6	74	120	KNH03693.1 DNA-directed RNA polymerase II subunit RPB2 [Perkinsela sp. CCAP 1560/4]	diamond	141	58.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
27537498	27537498	PRJNA909412_P_NODE_2303_length_351_cov_2.330128_g2163_i0	PRJNA909412	2303	351	2.330128	8.17874928	Trypanosoma	5690	Euglenozoa	other_Eukaryota	78.6	2.68e-14	NR	XP_028879565.1	67003	g2163	i0	33.3	3.8034188034188	114	75	96.6	1	11	349	91	204	XP_028879565.1 delta8 fatty acid desaturase-like protein [Trypanosoma theileri]	diamond	1335	79	0.994936708860759	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
29021760	29021760	PRJNA909412_P_NODE_6928_length_200_cov_2.074534_g6787_i0	PRJNA909412	6928	200	2.074534	4.149068	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	53.9	1.54e-6	NR	CCW67585.1	223615	g6787	i0	51.9	8.025	54	25	81	1	169	8	122	174	CCW67585.1 unnamed protein product [Phytomonas sp. Hart1]	diamond	1605	53.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Phytomonas	Phytomonas sp. Hart1
32142524	32142524	PRJNA909412_P_NODE_9538_length_174_cov_1.651852_g9397_i0	PRJNA909412	9538	174	1.651852	2.87422248	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	68.9	6.08e-12	NR	KAJ9443952.1	91374	g9397	i0	69.8	0.741379310344828	43	13	74.1	0	172	44	274	316	KAJ9443952.1 Bardet-Biedl syndrome 5 protein-like protein [Diplonema papillatum]	diamond	129	68.9	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum

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