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

6 rows where bioproject = "PRJEB11523" 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
20109038	20109038	PRJEB11523_P_NODE_5936_length_189_cov_23.007143_g5858_i0	PRJEB11523	5936	189	23.007143	43.48350027	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	239	1.16e-58	NTclustered	gi\|1207899568\|ref\|XR_002460820.1\|	347515	g5858	i0	92.857	109.444444444444	168	7	86	4	24	186	1585	1752	Leishmania major strain Friedlin 28S ribosomal RNA (LSU-alpha) partial rRNA	blastn	20685	239	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
21384653	21384653	PRJEB11523_P_NODE_4157_length_234_cov_8.016216_g4079_i0	PRJEB11523	4157	234	8.016216	18.75794544	Naegleria	5761	Heterolobosea	other_Eukaryota	366	6.59e-97	NTclustered	gi\|2618963742\|gb\|OR769034.1\|	5762	g4079	i0	99.502	10.2735042735043	201	1	86	0	13	213	4279	4079	Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	2404	366	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
21384658	21384658	PRJEB11523_P_NODE_5497_length_198_cov_4.174497_g5419_i0	PRJEB11523	5497	198	4.174497	8.26550406	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	228	2.659999999999999e-55	NTclustered	gi\|169656123\|gb\|EU429363.1\|	5659	g5419	i0	95.804	82.3636363636364	143	3	72	3	7	148	309	449	Leishmania amazonensis clone AR249 28S ribosomal RNA (LSU-beta)-like gene, partial sequence	blastn	16308	230	0.991304347826087	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
28548886	28548886	PRJEB11523_P_NODE_9087_length_153_cov_2.778846_g9009_i0	PRJEB11523	9087	153	2.778846	4.25163438	Bodo saltans	75058	Euglenozoa	other_Eukaryota	42.4	0.0149	NR	CUE73294.1	75058	g9009	i0	69.7	0.647058823529412	33	8	62.7	2	11	106	1938	1969	CUE73294.1 Hypothetical protein, putative [Bodo saltans]	diamond	99	42.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30222251	30222251	PRJEB11523_P_NODE_752_length_693_cov_50.442547_g686_i0	PRJEB11523	752	693	50.442547	349.56685071	Bodo saltans	75058	Euglenozoa	other_Eukaryota	381	5.569999999999998e-119	NR	CUG89890.1	75058	g686	i0	96.5	0.857142857142857	198	7	85.7	0	54	647	238	435	CUG89890.1 Hypothetical protein, putative [Bodo saltans]	diamond	594	381	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31233204	31233204	PRJEB11523_P_NODE_5335_length_202_cov_1.686275_g5257_i0	PRJEB11523	5335	202	1.686275	3.4062755	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	117	1.1000000000000002e-28	NR	XP_002671758.1	5762	g5257	i0	91.8	0.905940594059406	61	5	90.6	0	12	194	986	1046	XP_002671758.1 uncharacterized protein NAEGRDRAFT_81445 [Naegleria gruberi]	diamond	183	117	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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