metadata: contig_metadata: 10 rows where bioproject = "PRJEB12982" and tax

10 rows where bioproject = "PRJEB12982" 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
5123408	5123408	PRJEB12982_P_NODE_3605_length_404_cov_1.292958_g3442_i0	PRJEB12982	3605	404	1.292958	5.22355032	Heterostelium album	2086695	Evosea	other_Eukaryota	272	2.73e-68	NTclustered	gi\|1160557950\|ref\|XM_020575808.1\|	670386	g3442	i0	85.441	128.170792079208	261	38	65	0	2	262	1072	1332	Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA	blastn	51781	272	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
6399121	6399121	PRJEB12982_P_NODE_19986_length_163_cov_0.894737_g19823_i0	PRJEB12982	19986	163	0.894737	1.45842131	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	66.2	4.48e-12	NR	KAH3763125.1	1580589	g19823	i0	72.5	0.736196319018405	40	11	73.6	0	44	163	6	45	KAH3763125.1 60S acidic ribosomal protein P1 [Pelomyxa schiedti]	diamond	120	66.2	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
21697582	21697582	PRJEB12982_P_NODE_12758_length_196_cov_1.387755_g12595_i0	PRJEB12982	12758	196	1.387755	2.7199998	Telaepolella tubasferens	1346289	Evosea	other_Eukaryota	246	7.25e-61	NTclustered	gi\|167859711\|gb\|EU273435.1\|	1346289	g12595	i0	89.286	96.5663265306122	196	21	100	0	1	196	357	162	Telaepolella tubasferens clone 1 actin gene, partial cds	blastn	18927	246	1	Eukaryota	Amoebozoa	Evosea	Variosea		Flamellidae	Telaepolella	Telaepolella tubasferens
26589552	26589552	PRJEB12982_P_NODE_12441_length_199_cov_1.000000_g12278_i0	PRJEB12982	12441	199	1	1.99	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	60.5	1.18e-8	NR	PRP89338.1	1890364	g12278	i0	60.4	0.723618090452261	48	19	72.4	0	25	168	47	94	PRP89338.1 cobalamin synthesis protein P47K [Planoprotostelium fungivorum]	diamond	144	60.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27791303	27791303	PRJEB12982_P_NODE_10264_length_220_cov_1.192982_g10101_i0	PRJEB12982	10264	220	1.192982	2.6245604	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	69.7	4.67e-12	NR	PRP89404.1	1890364	g10101	i0	54.7	1.8	64	23	87.3	1	218	27	226	283	PRP89404.1 spermidine synthase [Planoprotostelium fungivorum]	diamond	396	69.7	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28170085	28170085	PRJEB12982_P_NODE_19646_length_163_cov_0.894737_g19483_i0	PRJEB12982	19646	163	0.894737	1.45842131	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	70.1	1.53e-12	NR	KAF2070078.1	133409	g19483	i0	61.1	1.96932515337423	54	21	99.4	0	2	163	75	128	KAF2070078.1 hypothetical protein CYY_008604 [Polysphondylium violaceum]	diamond	321	70.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30349558	30349558	PRJEB12982_P_NODE_15432_length_176_cov_1.204724_g15269_i0	PRJEB12982	15432	176	1.204724	2.12031424	Physarum polycephalum	5791	Evosea	other_Eukaryota	59.7	1.61e-9	NR	P18322.3	5791	g15269	i0	74.3	0.596590909090909	35	9	59.7	0	176	72	91	125	P18322.3 RecName: Full=Profilin-P [Physarum polycephalum]	diamond	105	59.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
31986367	31986367	PRJEB12982_P_NODE_20438_length_162_cov_0.902655_g20275_i0	PRJEB12982	20438	162	0.902655	1.4623011	Dictyostelium	5782	Evosea	other_Eukaryota	50.4	2.24e-5	NR	XP_003290573.1	5786	g20275	i0	49.1	2.09259259259259	57	22	98.1	3	161	3	170	223	XP_003290573.1 uncharacterized protein DICPUDRAFT_155103 [Dictyostelium purpureum]	diamond	339	50.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
32119564	32119564	PRJEB12982_P_NODE_18158_length_165_cov_0.879310_g17995_i0	PRJEB12982	18158	165	0.87931	1.4508615	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	60.8	5.15e-9	NR	KAH3758651.1	1580589	g17995	i0	50	0.981818181818182	54	26	98.2	1	163	2	184	236	KAH3758651.1 IBR domain protein [Pelomyxa schiedti]	diamond	162	60.8	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
32562667	32562667	PRJEB12982_P_NODE_17179_length_167_cov_0.864407_g17016_i0	PRJEB12982	17179	167	0.864407	1.44355969	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	61.2	3.91e-9	NR	XP_643747.1	352472	g17016	i0	60.7	1.9940119760479	56	16	98.8	2	1	165	256	306	XP_643747.1 hypothetical protein DDB_G0275107 [Dictyostelium discoideum AX4]	diamond	333	61.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum

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