metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA293022" 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
373341	373341	PRJNA293022_P_NODE_57841_length_183_cov_1.432836_g57104_i0	PRJNA293022	57841	183	1.432836	2.62208988	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	95.1	7.76e-22	NR	KAH3761736.1	1580589	g57104	i0	66.7	5.01639344262295	60	19	96.7	1	1	177	46	105	KAH3761736.1 protein disulfide-isomerase A6 [Pelomyxa schiedti]	diamond	918	95.1	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
26725608	26725608	PRJNA293022_P_NODE_67961_length_169_cov_0.866667_g67224_i0	PRJNA293022	67961	169	0.866667	1.46466723	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	61.6	2.9e-9	NR	XP_003285271.1	5786	g67224	i0	59.1	0.781065088757396	44	18	78.1	0	167	36	78	121	XP_003285271.1 uncharacterized protein DICPUDRAFT_76201 [Dictyostelium purpureum]	diamond	132	61.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
26884527	26884527	PRJNA293022_P_NODE_74201_length_165_cov_0.896552_g73464_i0	PRJNA293022	74201	165	0.896552	1.4793108	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	85.1	1.55e-17	NR	KAH3763756.1	1580589	g73464	i0	72.2	1.96363636363636	54	15	98.2	0	162	1	61	114	KAH3763756.1 major vault protein [Pelomyxa schiedti]	diamond	324	85.1	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
26996744	26996744	PRJNA293022_P_NODE_74062_length_165_cov_0.896552_g73325_i0	PRJNA293022	74062	165	0.896552	1.4793108	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.5	1.98e-6	NR	XP_004359736.1	261658	g73325	i0	49	2.85454545454545	51	26	92.7	0	163	11	593	643	XP_004359736.1 putative phosphatidylinositol phosphate kinase [Cavenderia fasciculata]	diamond	471	53.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
28242598	28242598	PRJNA293022_P_NODE_39246_length_223_cov_1.183908_g38509_i0	PRJNA293022	39246	223	1.183908	2.64011484	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	81.6	1.34e-17	NR	XP_003284479.1	5786	g38509	i0	54	0.847533632286996	63	29	84.8	0	193	5	86	148	XP_003284479.1 uncharacterized protein DICPUDRAFT_148253 [Dictyostelium purpureum]	diamond	189	81.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
28905603	28905603	PRJNA293022_P_NODE_65068_length_172_cov_1.252033_g64331_i0	PRJNA293022	65068	172	1.252033	2.15349676	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	67.8	2.11e-11	NR	PRP80058.1	1890364	g64331	i0	62.3	0.924418604651163	53	20	92.4	0	159	1	212	264	PRP80058.1 tripeptidyl peptidase I precursor [Planoprotostelium fungivorum]	diamond	159	67.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30186486	30186486	PRJNA293022_P_NODE_25272_length_281_cov_1.551724_g24535_i0	PRJNA293022	25272	281	1.551724	4.36034444	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	71.6	3.7e-13	NR	KAF2071651.1	133409	g24535	i0	40.2	1.97508896797153	92	53	98.2	1	277	2	79	168	KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum]	diamond	555	71.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30390582	30390582	PRJNA293022_P_NODE_55593_length_187_cov_1.079710_g54856_i0	PRJNA293022	55593	187	1.07971	2.0190577	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	58.2	4.78e-9	NR	XP_004350852.1	261658	g54856	i0	45.6	0.914438502673797	57	31	91.4	0	185	15	36	92	XP_004350852.1 40S ribosomal protein S25 [Cavenderia fasciculata]	diamond	171	58.2	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);;