metadata: contig_metadata: 10 rows where bioproject = "PRJNA1123436", tax_phylum = "Evosea" and tax

10 rows where bioproject = "PRJNA1123436", tax_phylum = "Evosea" and tax_superkingdom = "Eukaryota"

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
3579889	3579889	PRJNA1123436_P_NODE_127043_length_241_cov_0.916667_g125829_i0	PRJNA1123436	127043	241	0.916667	2.20916747	Didymium	5792	Evosea	other_Eukaryota	204	5.66e-48	NTclustered	gi\|2687\|emb\|X60210.1\|	5793	g125829	i0	91.781	49	146	12	61	0	1	146	2900	2755	D.iridis LSU rRNA gene	blastn	11809	204	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium iridis
4106071	4106071	PRJNA1123436_P_NODE_116544_length_244_cov_0.900585_g115330_i0	PRJNA1123436	116544	244	0.900585	2.1974274	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	138	2.09e-37	NR	XP_020436317.1	670386	g115330	i0	80.2	3.97131147540984	81	16	99.6	0	1	243	291	371	XP_020436317.1 zinc-containing alcohol dehydrogenase [Heterostelium album PN500]	diamond	969	138	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
5382424	5382424	PRJNA1123436_P_NODE_15485_length_694_cov_2.233494_g14313_i0	PRJNA1123436	15485	694	2.233494	15.50044836	Didymium iridis	5793	Evosea	other_Eukaryota	529	2.6299999999999993e-145	NTclustered	gi\|2687\|emb\|X60210.1\|	5793	g14313	i0	86.519	7.83861671469741	497	47	71	12	99	593	1706	2184	D.iridis LSU rRNA gene	blastn	5440	529	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium iridis
7407854	7407854	PRJNA1123436_P_NODE_89486_length_260_cov_1.647059_g88272_i0	PRJNA1123436	89486	260	1.647059	4.2823534	Physariida	5789	Evosea	other_Eukaryota	300	7.66e-77	NTclustered	gi\|3221\|emb\|V01159.1\|	5791	g88272	i0	87.594	67.4269230769231	266	24	100	7	1	260	1831	1569	Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA	blastn	17531	300	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
11233031	11233031	PRJNA1123436_P_NODE_54249_length_339_cov_0.793233_g53035_i0	PRJNA1123436	54249	339	0.793233	2.68905987	root	1	Root_unresolved	Root_unresolved	577	4.2699999999999996e-160	NTclustered	gi\|1057487735\|gb\|KX539428.1\|	133408	g53035	i0	97.345	99.6991150442478	339	9	100	0	1	339	923	585	Acytostelium leptosomum strain FG12A aconitate (aco1) gene, complete cds	blastn	33798	582	0.991408934707904	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium leptosomum
12508400	12508400	PRJNA1123436_P_NODE_53070_length_342_cov_1.996283_g51856_i0	PRJNA1123436	53070	342	1.996283	6.82728786	Didymiaceae	1115745	Evosea	other_Eukaryota	191	6.57e-44	NTclustered	gi\|2687\|emb\|X60210.1\|	5793	g51856	i0	95.798	34.9853801169591	119	4	35	1	7	125	2636	2519	D.iridis LSU rRNA gene	blastn	11965	191	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium iridis
14308817	14308817	PRJNA1123436_P_NODE_53952_length_339_cov_2.266917_g52738_i0	PRJNA1123436	53952	339	2.266917	7.68484863	Angulamoeba microcystivorans	1654978	Evosea	other_Eukaryota	331	3.6700000000000004e-86	NTclustered	gi\|295983902\|gb\|HM017143.1\|	1654978	g52738	i0	100	45.7315634218289	179	0	97	0	1	179	317	495	Angulamoeba microcystivorans strain A1WVB 18S ribosomal RNA gene, partial sequence	blastn	15503	331	1	Eukaryota	Amoebozoa	Evosea	Variosea			Angulamoeba	Angulamoeba microcystivorans
18880937	18880937	PRJNA1123436_P_NODE_19955_length_594_cov_1.445298_g18757_i0	PRJNA1123436	19955	594	1.445298	8.58507012	Physariida	5789	Evosea	other_Eukaryota	361	8.589999999999999e-95	NTclustered	gi\|2616764609\|gb\|OR769378.1\|	289939	g18757	i0	85.838	52.8316498316498	346	41	69	7	254	594	852	1194	Craterium dictyosporum voucher LE286398 small subunit ribosomal RNA gene, partial sequence	blastn	31382	364	0.991758241758242	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Craterium	Craterium dictyosporum
28333496	28333496	PRJNA1123436_P_NODE_128706_length_229_cov_2.166667_g127492_i0	PRJNA1123436	128706	229	2.166667	4.96166743	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	77.4	1.93e-14	NR	KAF2071788.1	133409	g127492	i0	48.1	1.00873362445415	77	36	96.9	3	223	2	408	483	KAF2071788.1 hypothetical protein CYY_006895 [Polysphondylium violaceum]	diamond	231	77.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30196469	30196469	PRJNA1123436_P_NODE_99552_length_250_cov_0.870056_g98338_i0	PRJNA1123436	99552	250	0.870056	2.17514	Entamoeba invadens	33085	Evosea	other_Eukaryota	82.8	3.17e-16	NR	BAN41639.1	33085	g98338	i0	50.6	0.948	79	37	92.4	2	7	237	367	445	BAN41639.1 actin binding protein, putative [Entamoeba invadens]	diamond	237	82.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens

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