metadata: contig_metadata: 9 rows where bioproject = "PRJNA597223" and tax

9 rows where bioproject = "PRJNA597223" 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
569359	569359	PRJNA597223_P_NODE_66641_length_176_cov_2.007092_g64795_i0	PRJNA597223	66641	176	2.007092	3.53248192	Didymium spongiosum	289992	Evosea	other_Eukaryota	128	2.4e-25	NTclustered	gi\|2161226356\|gb\|MZ313554.1\|	289992	g64795	i0	93.182	3.24431818181818	88	5	50	1	45	132	6916	7002	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	571	128	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium spongiosum
3120303	3120303	PRJNA597223_P_NODE_57503_length_186_cov_3.344371_g55657_i0	PRJNA597223	57503	186	3.344371	6.22053006	Badhamia foliicola	647245	Evosea	other_Eukaryota	335	1.4099999999999996e-87	NTclustered	gi\|1864351373\|gb\|MT704208.1\|	647245	g55657	i0	99.457	98.9623655913979	184	1	99	0	1	184	230	413	Badhamia foliicola voucher MM21366 small subunit ribosomal RNA gene, partial sequence	blastn	18407	335	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Badhamia	Badhamia foliicola
5673311	5673311	PRJNA597223_P_NODE_80445_length_157_cov_1.885246_g78599_i0	PRJNA597223	80445	157	1.885246	2.95983622	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	76.8	7.69e-10	NTclustered	gi\|187764061\|ref\|NC_010653.1\|	261658	g78599	i0	86.957	1.22929936305732	69	7	43	2	2	69	10237	10170	Dictyostelium fasciculatum mitochondrion, complete genome	blastn	193	76.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
8222146	8222146	PRJNA597223_P_NODE_25767_length_306_cov_2.738007_g23923_i0	PRJNA597223	25767	306	2.738007	8.37830142	Hagiwaraea rhizopodium	361088	Evosea	other_Eukaryota	329	1.18e-85	NTclustered	gi\|169930326\|gb\|EU360787.1\|	361088	g23923	i0	87.197	92.4803921568627	289	37	94	0	3	291	163	451	Hagiwaraea rhizopodium isolate Ausk Y-4 elongation factor 1 alpha gene, partial cds	blastn	28299	329	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Hagiwaraea	Hagiwaraea rhizopodium
9497884	9497884	PRJNA597223_P_NODE_75548_length_163_cov_1.648438_g73702_i0	PRJNA597223	75548	163	1.648438	2.68695394	Physarum viride	289972	Evosea	other_Eukaryota	243	7.51e-60	NTclustered	gi\|1996571749\|gb\|MW693025.1\|	289972	g73702	i0	95.395	83.2760736196319	152	7	93	0	12	163	325	476	Physarum viride voucher MYX7886 small subunit ribosomal RNA gene, partial sequence	blastn	13574	243	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum viride
13323224	13323224	PRJNA597223_P_NODE_61111_length_186_cov_1.377483_g59265_i0	PRJNA597223	61111	186	1.377483	2.56211838	Schizoplasmodium cavostelioides	661160	Evosea	other_Eukaryota	189	1.1599999999999999e-43	NTclustered	gi\|254679473\|gb\|FJ544418.1\|	661160	g59265	i0	90.411	67.5967741935484	146	10	78	3	40	184	755	897	Schizoplasmodium cavostelioides isolate NZ05-24l-2 18S ribosomal RNA gene, partial sequence	blastn	12573	189	1	Eukaryota	Amoebozoa	Evosea	Variosea	Fractovitellida	Schizoplasmodiidae	Schizoplasmodium	Schizoplasmodium cavostelioides
13323467	13323467	PRJNA597223_P_NODE_83251_length_154_cov_1.957983_g81405_i0	PRJNA597223	83251	154	1.957983	3.01529382	Entamoeba gingivalis	38877	Evosea	other_Eukaryota	283	4.12e-72	NTclustered	gi\|2425687081\|gb\|OQ225449.1\|	38877	g81405	i0	100	74.9220779220779	153	0	99	0	1	153	1602	1754	Entamoeba gingivalis isolate ALA_ST3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence	blastn	11538	283	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba gingivalis
26890236	26890236	PRJNA597223_P_NODE_48501_length_201_cov_1.385542_g46655_i0	PRJNA597223	48501	201	1.385542	2.78493942	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	100	2.36e-24	NR	KYR02481.1	361077	g46655	i0	75.8	1.85074626865672	62	15	92.5	0	6	191	41	102	KYR02481.1 LIM-type zinc finger-containing protein [Tieghemostelium lacteum]	diamond	372	100	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29132628	29132628	PRJNA597223_P_NODE_23689_length_324_cov_2.003460_g21845_i0	PRJNA597223	23689	324	2.00346	6.4912104	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	59.3	1.5e-7	NR	PRP81517.1	1890364	g21845	i0	42	0.638888888888889	69	35	63.9	3	226	20	437	500	PRP81517.1 hypothetical protein PROFUN_10879 [Planoprotostelium fungivorum]	diamond	207	59.3	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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