metadata: contig_metadata: 8 rows where bioproject = "PRJNA1218818" and tax

8 rows where bioproject = "PRJNA1218818" 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
5436895	5436895	PRJNA1218818_P_NODE_13885_length_331_cov_1.081395_g13818_i0	PRJNA1218818	13885	331	1.081395	3.57941745	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	182	3.81e-41	NTclustered	gi\|470247107\|ref\|XM_004357209.1\|	261658	g13818	i0	80.567	3.31117824773414	247	38	73	9	79	320	257	16	Cavenderia fasciculata 40S ribosomal protein S17 (rps17), partial mRNA	blastn	1096	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
11249681	11249681	PRJNA1218818_P_NODE_24729_length_250_cov_0.870056_g24662_i0	PRJNA1218818	24729	250	0.870056	2.17514	Dictyostelium	5782	Evosea	other_Eukaryota	154	6.03e-33	NTclustered	gi\|1912394\|gb\|U49169.1\|DDU49169	44689	g24662	i0	78.723	3.3	235	46	93	4	17	249	380	148	Dictyostelium discoideum V-ATPase A subunit (vatA) mRNA, complete cds	blastn	825	154	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
26964887	26964887	PRJNA1218818_P_NODE_25502_length_248_cov_0.880000_g25435_i0	PRJNA1218818	25502	248	0.88	2.1824	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.9	2.91e-12	NR	XP_003290595.1	5786	g25435	i0	46.3	6.73790322580645	82	42	99.2	1	246	1	42	121	XP_003290595.1 RNA polymerase II core subunit [Dictyostelium purpureum]	diamond	1671	70.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
27388968	27388968	PRJNA1218818_P_NODE_27383_length_244_cov_0.900585_g27316_i0	PRJNA1218818	27383	244	0.900585	2.1974274	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	64.7	6.76e-10	NR	KYQ91113.1	361077	g27316	i0	42.4	2.04098360655738	92	38	98.4	2	242	3	519	607	KYQ91113.1 myotubularin-related protein [Tieghemostelium lacteum]	diamond	498	64.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29775481	29775481	PRJNA1218818_P_NODE_27571_length_244_cov_0.900585_g27504_i0	PRJNA1218818	27571	244	0.900585	2.1974274	Dictyosteliales	2058949	Evosea	other_Eukaryota	62.4	4.55e-9	NR	XP_003289339.1	5786	g27504	i0	44.8	3.57786885245902	58	31	70.1	1	205	35	642	699	XP_003289339.1 uncharacterized protein DICPUDRAFT_98323 [Dictyostelium purpureum]	diamond	873	62.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
30167344	30167344	PRJNA1218818_P_NODE_28512_length_242_cov_0.911243_g28445_i0	PRJNA1218818	28512	242	0.911243	2.20520806	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	77.8	7.43e-15	NR	KYR03061.1	361077	g28445	i0	50	0.892561983471074	72	36	89.3	0	236	21	4	75	KYR03061.1 bisphosphate nucleotidase [Tieghemostelium lacteum]	diamond	216	77.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
30262567	30262567	PRJNA1218818_P_NODE_24752_length_250_cov_0.870056_g24685_i0	PRJNA1218818	24752	250	0.870056	2.17514	Entamoeba invadens IP1	370355	Evosea	other_Eukaryota	45.8	0.00327	NR	XP_004185078.1	370355	g24685	i0	47.8	0.552	46	23	55.2	1	21	158	561	605	XP_004185078.1 hypothetical protein EIN_012090 [Entamoeba invadens IP1]	diamond	138	45.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens
32444198	32444198	PRJNA1218818_P_NODE_27439_length_244_cov_0.900585_g27372_i0	PRJNA1218818	27439	244	0.900585	2.1974274	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	105	3.0899999999999993e-24	NR	XP_004359378.1	261658	g27372	i0	63.9	1.77049180327869	72	26	88.5	0	216	1	410	481	XP_004359378.1 delta 9 fatty acid desaturase [Cavenderia fasciculata]	diamond	432	105	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata

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