metadata: contig_metadata: 9 rows where bioproject = "PRJNA792582", tax_clade = "Amoebozoa" and tax

9 rows where bioproject = "PRJNA792582", 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
3327970	3327970	PRJNA792582_P_NODE_18243_length_403_cov_1.290909_g17429_i0	PRJNA792582	18243	403	1.290909	5.20236327	Polyschismium peyerimhoffii	2911783	Evosea	other_Eukaryota	276	2.11e-69	NTclustered	gi\|2161226355\|gb\|MZ313553.1\|	2911783	g17429	i0	88.066	36.1712158808933	243	16	58	11	142	376	6800	6563	Polyschismium peyerimhoffii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	14577	276	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Polyschismium	Polyschismium peyerimhoffii
9705127	9705127	PRJNA792582_P_NODE_21348_length_373_cov_1.003333_g20534_i0	PRJNA792582	21348	373	1.003333	3.74243209	Telaepolella tubasferens	1346289	Evosea	other_Eukaryota	431	3.9e-116	NTclustered	gi\|167859711\|gb\|EU273435.1\|	1346289	g20534	i0	88.219	99.4343163538874	365	38	98	5	1	365	360	1	Telaepolella tubasferens clone 1 actin gene, partial cds	blastn	37089	431	1	Eukaryota	Amoebozoa	Evosea	Variosea		Flamellidae	Telaepolella	Telaepolella tubasferens
16079368	16079368	PRJNA792582_P_NODE_27433_length_330_cov_1.186770_g26619_i0	PRJNA792582	27433	330	1.18677	3.916341	Arcyria sp. 'tenuissima'	3129282	Evosea	other_Eukaryota	337	7.66e-88	NTclustered	gi\|2698738389\|gb\|PP491458.1\|	3129282	g26619	i0	85.196	38.4787878787879	331	46	100	2	1	330	703	1031	Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence	blastn	12698	337	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria sp. 'tenuissima'
22454145	22454145	PRJNA792582_P_NODE_27398_length_330_cov_1.435798_g26584_i0	PRJNA792582	27398	330	1.435798	4.7381334	Heterostelium album	2086695	Evosea	other_Eukaryota	67.6	1.11e-6	NTclustered	gi\|1160569142\|ref\|XM_020571968.1\|	670386	g26584	i0	97.436	1.65757575757576	39	1	12	0	114	152	42	80	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	547	67.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
23729696	23729696	PRJNA792582_P_NODE_17759_length_409_cov_1.166667_g16945_i0	PRJNA792582	17759	409	1.166667	4.77166803	Didymium spongiosum	289992	Evosea	other_Eukaryota	326	2.1e-84	NTclustered	gi\|2161226356\|gb\|MZ313554.1\|	289992	g16945	i0	83.607	6.60880195599022	366	41	86	16	42	394	7194	7553	Mucilago crustacea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	2703	326	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium spongiosum
28885310	28885310	PRJNA792582_P_NODE_42528_length_271_cov_1.409091_g41714_i0	PRJNA792582	42528	271	1.409091	3.81863661	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	60.5	2.18e-8	NR	PRP81416.1	1890364	g41714	i0	44.4	0.797047970479705	72	40	79.7	0	225	10	95	166	PRP81416.1 hypothetical protein PROFUN_10946, partial [Planoprotostelium fungivorum]	diamond	216	60.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29169730	29169730	PRJNA792582_P_NODE_47989_length_255_cov_3.109890_g47175_i0	PRJNA792582	47989	255	3.10989	7.9302195	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	81.3	7.02e-16	NR	KAF2078060.1	133409	g47175	i0	59.2	2.35294117647059	71	29	83.5	0	43	255	160	230	KAF2078060.1 hypothetical protein CYY_000611 [Polysphondylium violaceum]	diamond	600	81.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30401808	30401808	PRJNA792582_P_NODE_54153_length_246_cov_2.231214_g53339_i0	PRJNA792582	54153	246	2.231214	5.48878644	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	49.7	2.55e-5	NR	XP_020429212.1	670386	g53339	i0	46.9	0.597560975609756	49	26	59.8	0	244	98	7	55	XP_020429212.1 hypothetical protein PPL_09836 [Heterostelium album PN500]	diamond	147	49.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
31665538	31665538	PRJNA792582_P_NODE_25157_length_344_cov_2.763838_g24343_i0	PRJNA792582	25157	344	2.763838	9.50760272	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	46.2	0.00679	NR	XP_020436579.1	670386	g24343	i0	42.9	0.366279069767442	42	24	36.6	0	1	126	5	46	XP_020436579.1 hypothetical protein PPL_02499 [Heterostelium album PN500]	diamond	126	46.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album

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