metadata: contig_metadata: 13 rows where bioproject = "PRJNA438687", tax_clade = "Amoebozoa" and tax

13 rows where bioproject = "PRJNA438687", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"

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
5538965	5538965	PRJNA438687_S_NODE_2585_length_277_cov_3.099174_g2495_i0	PRJNA438687	2585	277	3.099174	8.58471198	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	115	3.2e-21	NTclustered	gi\|19911164\|dbj\|AB066364.1\|	108607	g2495	i0	95.775	25.3465703971119	71	3	26	0	207	277	324	394	Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2	blastn	7021	115	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi
6194276	6194276	PRJNA438687_S_NODE_6865_length_166_cov_3.221374_g6775_i0	PRJNA438687	6865	166	3.221374	5.34748084	Endolimax	110787	Evosea	other_Eukaryota	137	3.73e-28	NTclustered	gi\|443299289\|gb\|JX101954.1\|	1284676	g6775	i0	96.386	50.1265060240964	83	3	50	0	84	166	2032	2114	Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence	blastn	8321	137	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Endolimax	Endolimax piscium
6813156	6813156	PRJNA438687_S_NODE_7966_length_153_cov_1.508475_g7876_i0	PRJNA438687	7966	153	1.508475	2.30796675	Lepidoderma carestianum	290853	Evosea	other_Eukaryota	222	9.029999999999999e-54	NTclustered	gi\|374255718\|emb\|HE614618.2\|	290853	g7876	i0	93.96	84.5359477124183	149	6	97	3	6	153	1690	1836	Lepidoderma carestianum partial 18S rRNA gene, strain It-K71	blastn	12934	222	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Lepidoderma	Lepidoderma carestianum
9363380	9363380	PRJNA438687_S_NODE_6648_length_169_cov_9.626866_g6558_i0	PRJNA438687	6648	169	9.626866	16.26940354	Iodamoeba sp. RL1	1089794	Evosea	other_Eukaryota	261	2.15e-65	NTclustered	gi\|347976701\|gb\|JN635746.1\|	1089794	g6558	i0	94.643	96.4497041420118	168	9	99	0	2	169	1385	1218	Iodamoeba sp. RL1 isolate EM081 clone 3.1 small subunit ribosomal RNA gene, partial sequence	blastn	16300	261	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Iodamoeba	Iodamoeba sp. RL1
10639225	10639225	PRJNA438687_S_NODE_5589_length_187_cov_1.552632_g5499_i0	PRJNA438687	5589	187	1.552632	2.90342184	Entamoeba histolytica	5759	Evosea	other_Eukaryota	156	1.19e-33	NTclustered	gi\|1865795\|emb\|Y11271.1\|	5759	g5499	i0	90	3.31550802139037	120	12	64	0	68	187	904	1023	E.histolytica ss1 gene	blastn	620	156	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
10639235	10639235	PRJNA438687_S_NODE_6009_length_179_cov_2.840278_g5919_i0	PRJNA438687	6009	179	2.840278	5.08409762	Comatricha laxa	1450423	Evosea	other_Eukaryota	207	3.06e-49	NTclustered	gi\|2324671363\|gb\|ON155996.1\|	1450423	g5919	i0	88.506	29.7932960893855	174	17	97	3	6	179	989	819	Comatricha laxa isolate EdHa large subunit ribosomal RNA gene, partial sequence; and ribozyme genes, complete sequence	blastn	5333	207	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Comatricha	Comatricha laxa
11914008	11914008	PRJNA438687_S_NODE_2050_length_303_cov_2.194030_g1960_i0	PRJNA438687	2050	303	2.19403	6.6479109	uncultured Iodamoeba	1208758	Evosea	other_Eukaryota	401	2.4299999999999993e-107	NTclustered	gi\|674280004\|gb\|KC922234.1\|	1208758	g1960	i0	90.385	16.9471947194719	312	20	100	7	1	303	402	92	Uncultured Iodamoeba clone SA5 18S ribosomal RNA gene, partial sequence	blastn	5135	401	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae		uncultured Iodamoeba
14463984	14463984	PRJNA438687_S_NODE_4012_length_222_cov_2.566845_g3922_i0	PRJNA438687	4012	222	2.566845	5.6983959	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	128	3.18e-25	NTclustered	gi\|19911164\|dbj\|AB066364.1\|	108607	g3922	i0	85.271	46.1666666666667	129	13	58	6	1	128	1609	1486	Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2	blastn	10249	128	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi
19561203	19561203	PRJNA438687_S_NODE_2996_length_258_cov_14.672646_g2906_i0	PRJNA438687	2996	258	14.672646	37.85542668	Mastigamoeba errans	1211411	Evosea	other_Eukaryota	305	1.63e-78	NTclustered	gi\|399769442\|gb\|JX157637.1\|	1211411	g2906	i0	97.753	85.3178294573643	178	3	69	1	2	178	1387	1564	Mastigamoeba errans isolate HRAANM small subunit ribosomal RNA gene, partial sequence	blastn	22012	305	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba errans
19561284	19561284	PRJNA438687_S_NODE_7436_length_159_cov_1.459677_g7346_i0	PRJNA438687	7436	159	1.459677	2.32088643	Mastigamoeba errans	1211411	Evosea	other_Eukaryota	244	2.02e-60	NTclustered	gi\|399769442\|gb\|JX157637.1\|	1211411	g7346	i0	97.241	1.76100628930818	145	3	91	1	1	144	968	1112	Mastigamoeba errans isolate HRAANM small subunit ribosomal RNA gene, partial sequence	blastn	280	244	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba errans
20217473	20217473	PRJNA438687_S_NODE_7856_length_154_cov_1.806723_g7766_i0	PRJNA438687	7856	154	1.806723	2.78235342	Didymium	5792	Evosea	other_Eukaryota	67.6	4.51e-7	NTclustered	gi\|2687\|emb\|X60210.1\|	5793	g7766	i0	80.851	6.1038961038961	94	11	59	7	1	91	2889	2800	D.iridis LSU rRNA gene	blastn	940	67.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium iridis
20836952	20836952	PRJNA438687_S_NODE_7317_length_160_cov_4.304000_g7227_i0	PRJNA438687	7317	160	4.304	6.8864	Armaparvus browni	3387425	Evosea	other_Eukaryota	97.1	6.04e-16	NTclustered	gi\|2871328632\|gb\|PQ778044.1\|	3387425	g7227	i0	92.647	32.51875	68	4	43	1	3	70	1349	1415	Armaparvus browni strain ZIN.2023.15 small subunit ribosomal RNA gene, partial sequence	blastn	5203	97.1	1	Eukaryota	Amoebozoa	Evosea				Armaparvus	Armaparvus browni
22768152	22768152	PRJNA438687_S_NODE_6738_length_168_cov_2.112782_g6648_i0	PRJNA438687	6738	168	2.112782	3.54947376	Diderma	289935	Evosea	other_Eukaryota	289	9.879999999999999e-74	NTclustered	gi\|374255716\|emb\|HE614616.2\|	372584	g6648	i0	97.619	97.125	168	4	100	0	1	168	313	480	Diderma niveum partial 18S rRNA gene, strain It-K66	blastn	16317	289	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Diderma	Diderma niveum

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