metadata: contig_metadata: 6 rows where bioproject = "PRJNA561138" and tax

6 rows where bioproject = "PRJNA561138" 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
3681951	3681951	PRJNA561138_P_NODE_23583_length_258_cov_1.572973_g23388_i0	PRJNA561138	23583	258	1.572973	4.05827034	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	405	1.56e-108	NTclustered	gi\|388850727\|gb\|JX021440.1\|	5661	g23388	i0	94.961	100	258	13	100	0	1	258	879	622	Leishmania donovani strain IAND/CN/93/4 heat-shock protein 70 (hsp70) gene, partial cds	blastn	25800	405	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani
10059175	10059175	PRJNA561138_P_NODE_20508_length_285_cov_1.320755_g20313_i0	PRJNA561138	20508	285	1.320755	3.76415175	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	137	1.85e-35	NR	KPI89762.1	5684	g20313	i0	64.9	7.91578947368421	94	33	98.9	0	283	2	487	580	KPI89762.1 alkyldihydroxyacetonephosphate synthase (ADS1) [Leptomonas seymouri]	diamond	2256	137	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas seymouri
10749410	10749410	PRJNA561138_P_NODE_24849_length_251_cov_0.865169_g24654_i0	PRJNA561138	24849	251	0.865169	2.17157419	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	159	6.049999999999999e-43	NR	XP_002679205.1	5762	g24654	i0	95.1	0.9800796812749	82	4	98	0	4	249	531	612	XP_002679205.1 uncharacterized protein NAEGRDRAFT_38509 [Naegleria gruberi]	diamond	246	159	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
14574163	14574163	PRJNA561138_P_NODE_5192_length_544_cov_1.152866_g5001_i0	PRJNA561138	5192	544	1.152866	6.27159104	Neobodo designis	312471	Euglenozoa	other_Eukaryota	939	0	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g5001	i0	97.794	157	544	12	100	0	1	544	1166	623	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	85408	939	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
27377764	27377764	PRJNA561138_P_NODE_24883_length_250_cov_1.740113_g24688_i0	PRJNA561138	24883	250	1.740113	4.3502825	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	43.5	0.0181	NR	EPY29015.1	59799	g24688	i0	34.7	2.592	72	41	86.4	2	35	250	1	66	EPY29015.1 hypothetical protein AGDE_10168 [Angomonas deanei]	diamond	648	43.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
30427068	30427068	PRJNA561138_P_NODE_24793_length_251_cov_0.865169_g24598_i0	PRJNA561138	24793	251	0.865169	2.17157419	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	85.1	5.03e-17	NR	XP_044551457.1	51637	g24598	i0	41	0.932270916334661	78	45	92	1	233	3	11	88	XP_044551457.1 uncharacterized protein C9374_001797 [Naegleria lovaniensis]	diamond	234	85.1	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);;