metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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
1428122	1428122	PRJNA1005695_P_NODE_10082_length_489_cov_4.903846_g9231_i0	PRJNA1005695	10082	489	4.903846	23.97980694	Euglenaformis parasitica	2995132	Euglenozoa	other_Eukaryota	706	0	NTclustered	gi\|2518670619\|dbj\|LC739408.1\|	2995132	g9231	i0	93.224	77.4907975460123	487	21	99	10	6	489	1495	1018	Euglenaformis parasitica 0622 gene for 28S rRNA, partial sequence	blastn	37893	706	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglenaformis	Euglenaformis parasitica
1428439	1428439	PRJNA1005695_P_NODE_7542_length_571_cov_4.236948_g6709_i0	PRJNA1005695	7542	571	4.236948	24.19297308	Paratrypanosoma confusum	1470209	Euglenozoa	other_Eukaryota	342	2.98e-89	NTclustered	gi\|452768944\|gb\|KC534676.1\|	1470209	g6709	i0	81.093	81.5148861646235	439	74	76	8	5	437	483	48	Trypanosomatidae sp. TS-2013 clone C24978L43121o22 hypothetical protein gene, partial cds	blastn	46545	342	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Paratrypanosoma	Paratrypanosoma confusum
3979805	3979805	PRJNA1005695_P_NODE_14344_length_403_cov_1.690909_g13492_i0	PRJNA1005695	14344	403	1.690909	6.81436327	Euglenaformis parasitica	2995132	Euglenozoa	other_Eukaryota	568	3.1e-157	NTclustered	gi\|2518670619\|dbj\|LC739408.1\|	2995132	g13492	i0	92.308	93.9578163771712	403	25	100	2	1	403	1727	2123	Euglenaformis parasitica 0622 gene for 28S rRNA, partial sequence	blastn	37865	568	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglenaformis	Euglenaformis parasitica
11632029	11632029	PRJNA1005695_P_NODE_20430_length_333_cov_19.630769_g19578_i0	PRJNA1005695	20430	333	19.630769	65.37046077	Euglenaformis parasitica	2995132	Euglenozoa	other_Eukaryota	508	1.55e-139	NTclustered	gi\|2518670619\|dbj\|LC739408.1\|	2995132	g19578	i0	94.562	77.6366366366366	331	14	99	4	3	333	466	140	Euglenaformis parasitica 0622 gene for 28S rRNA, partial sequence	blastn	25853	508	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglenaformis	Euglenaformis parasitica
15456169	15456169	PRJNA1005695_P_NODE_28833_length_278_cov_2.229268_g27981_i0	PRJNA1005695	28833	278	2.229268	6.19736504	Petalomonas cantuscygni	56452	Euglenozoa	other_Eukaryota	156	1.9e-33	NTclustered	gi\|118574972\|gb\|EF108310.1\|	56452	g27981	i0	90	0.431654676258993	120	12	43	0	157	276	235	116	Petalomonas cantuscygni strain CCAP 1259/1 large subunit ribosomal RNA (rnl) gene, partial sequence	blastn	120	156	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Petalomonadida	Scytomonadidae	Petalomonas	Petalomonas cantuscygni
16730538	16730538	PRJNA1005695_P_NODE_41994_length_223_cov_7.966667_g41142_i0	PRJNA1005695	41994	223	7.966667	17.76566741	Euglenaformis parasitica	2995132	Euglenozoa	other_Eukaryota	344	2.92e-90	NTclustered	gi\|2518670619\|dbj\|LC739408.1\|	2995132	g41142	i0	95.023	28.3542600896861	221	7	99	3	1	220	2443	2660	Euglenaformis parasitica 0622 gene for 28S rRNA, partial sequence	blastn	6323	344	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglenaformis	Euglenaformis parasitica
18005189	18005189	PRJNA1005695_P_NODE_20155_length_336_cov_2.266160_g19303_i0	PRJNA1005695	20155	336	2.26616	7.6142976000000004	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	60.2	1.89e-4	NTclustered	gi\|2787694620\|ref\|XM_067337686.1\|	715481	g19303	i0	100	0.351190476190476	32	0	10	0	213	244	1027	996	Trypanosoma melophagium Protein kinase domain (LSM04_000753), partial mRNA	blastn	118	60.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
21830398	21830398	PRJNA1005695_P_NODE_37158_length_248_cov_0.891429_g36306_i0	PRJNA1005695	37158	248	0.891429	2.21074392	Heterolobosea sp.	1892890	Heterolobosea	other_Eukaryota	252	2.06e-62	NTclustered	gi\|1059971677\|gb\|KT892699.1\|	1892890	g36306	i0	88.372	8.4758064516129	215	17	86	4	1	214	1029	822	Heterolobosea sp. strain LPG3 18S ribosomal RNA gene, partial sequence	blastn	2102	252	1	Eukaryota	Discoba	Heterolobosea					Heterolobosea sp.
24379667	24379667	PRJNA1005695_P_NODE_39120_length_244_cov_0.912281_g38268_i0	PRJNA1005695	39120	244	0.912281	2.22596564	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	63.9	1.02e-5	NTclustered	gi\|290976222\|ref\|XM_002670794.1\|	5762	g38268	i0	90.196	0.586065573770492	51	2	43	3	136	185	388	340	Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56359), mRNA	blastn	143	63.9	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);;