metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA454503" 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
1717541	1717541	PRJNA454503_P_NODE_58902_length_210_cov_0.872483_g58573_i0	PRJNA454503	58902	210	0.872483	1.8322143	Ophirina amphinema	2108040	Root_unresolved	Root_unresolved	115	6.63e-31	NR	BBD14155.1	2108040	g58573	i0	92.9	1.7	56	4	80	0	41	208	3	58	BBD14155.1 NADH dehydrogenase subunit 10 [Ophirina amphinema]	diamond	357	115	1	Eukaryota	Discoba			Jakobida	Ophirinidae	Ophirina	Ophirina amphinema
26981167	26981167	PRJNA454503_P_NODE_81922_length_203_cov_0.915493_g81593_i0	PRJNA454503	81922	203	0.915493	1.85845079	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	59.3	3.19e-8	NR	KAJ9450176.1	91374	g81593	i0	37	1.07881773399015	73	34	90.1	1	17	199	614	686	KAJ9450176.1 Laminin subunit alpha [Diplonema papillatum]	diamond	219	59.3	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27107552	27107552	PRJNA454503_P_NODE_26862_length_244_cov_1.830601_g26533_i0	PRJNA454503	26862	244	1.830601	4.46666644	Bodo saltans	75058	Euglenozoa	other_Eukaryota	103	5.6799999999999995e-25	NR	CUG06241.1	75058	g26533	i0	56.2	0.897540983606557	73	32	89.8	0	2	220	119	191	CUG06241.1 Hypothetical protein, putative [Bodo saltans]	diamond	219	103	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28465889	28465889	PRJNA454503_P_NODE_82566_length_203_cov_0.915493_g82237_i0	PRJNA454503	82566	203	0.915493	1.85845079	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	72	1.04e-12	NR	XP_002680730.1	5762	g82237	i0	56.5	0.916256157635468	62	27	91.6	0	3	188	291	352	XP_002680730.1 uncharacterized protein NAEGRDRAFT_63893 [Naegleria gruberi]	diamond	186	72	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28640019	28640019	PRJNA454503_P_NODE_88587_length_194_cov_2.451128_g88258_i0	PRJNA454503	88587	194	2.451128	4.75518832	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.8	2.72e-18	NR	XP_002669477.1	5762	g88258	i0	67.3	5.28865979381443	49	16	75.8	0	45	191	76	124	XP_002669477.1 uncharacterized protein NAEGRDRAFT_75564 [Naegleria gruberi]	diamond	1026	83.6	0.990430622009569	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29665178	29665178	PRJNA454503_P_NODE_70870_length_206_cov_0.896552_g70541_i0	PRJNA454503	70870	206	0.896552	1.84689712	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	137	1.34e-36	NR	XP_002672214.1	5762	g70541	i0	85.3	0.990291262135922	68	10	99	0	1	204	255	322	XP_002672214.1 uncharacterized protein NAEGRDRAFT_52379 [Naegleria gruberi]	diamond	204	137	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29665180	29665180	PRJNA454503_P_NODE_75930_length_205_cov_0.902778_g75601_i0	PRJNA454503	75930	205	0.902778	1.8506949	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	58.5	5.78e-8	NR	KAJ9446475.1	91374	g75601	i0	43.3	4.06829268292683	60	32	87.8	1	3	182	171	228	KAJ9446475.1 putative cytokinin riboside 5prime-monophosphate phosphoribohydrolase LOGL1 [Diplonema papillatum]	diamond	834	58.5	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
30234116	30234116	PRJNA454503_P_NODE_34392_length_234_cov_1.098266_g34063_i0	PRJNA454503	34392	234	1.098266	2.56994244	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	69.7	1.01e-11	NR	XP_044543911.1	51637	g34063	i0	39.5	1.96153846153846	76	42	97.4	1	232	5	317	388	XP_044543911.1 uncharacterized protein C9374_010481 [Naegleria lovaniensis]	diamond	459	69.7	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis
30834435	30834435	PRJNA454503_P_NODE_81214_length_203_cov_0.915493_g80885_i0	PRJNA454503	81214	203	0.915493	1.85845079	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	52.4	8.8e-6	NR	XP_044546350.1	51637	g80885	i0	80	0.517241379310345	35	7	51.7	0	203	99	781	815	XP_044546350.1 uncharacterized protein C9374_007726 [Naegleria lovaniensis]	diamond	105	52.4	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis

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