metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax_clade = "Amoebozoa"

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
27372223	27372223	PRJNA900999_S_NODE_3283_length_230_cov_2.666667_g3227_i0	PRJNA900999	3283	230	2.666667	6.1333341	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	59.3	4.35e-8	NR	XP_004356364.1	261658	g3227	i0	57.8	0.58695652173913	45	19	58.7	0	169	35	348	392	XP_004356364.1 leucine-rich repeat-containing protein [Cavenderia fasciculata]	diamond	135	59.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
28477008	28477008	PRJNA900999_S_NODE_4666_length_201_cov_3.313953_g4610_i0	PRJNA900999	4666	201	3.313953	6.66104553	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	43.5	0.0109	NR	PRP80728.1	1890364	g4610	i0	66.7	0.402985074626866	27	9	40.3	0	5	85	266	292	PRP80728.1 ras-related protein Rab-2A [Planoprotostelium fungivorum]	diamond	81	43.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30845754	30845754	PRJNA900999_S_NODE_2674_length_248_cov_3.283105_g2618_i0	PRJNA900999	2674	248	3.283105	8.1421004	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	67	1.11e-10	NR	XP_004340627.1	1257118	g2618	i0	49.2	0.786290322580645	65	31	76.2	1	56	244	29	93	XP_004340627.1 pigment precursor permease subfamily protein [Acanthamoeba castellanii str. Neff]	diamond	195	67	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30845760	30845760	PRJNA900999_S_NODE_8634_length_158_cov_2.550388_g8578_i0	PRJNA900999	8634	158	2.550388	4.02961304	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	55.5	1.17e-7	NR	PRP76760.1	1890364	g8578	i0	59.5	0.70253164556962	37	13	66.5	1	33	137	130	166	PRP76760.1 hypothetical protein PROFUN_14885 [Planoprotostelium fungivorum]	diamond	111	55.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32742682	32742682	PRJNA900999_S_NODE_2080_length_271_cov_3.342975_g2024_i0	PRJNA900999	2080	271	3.342975	9.05946225	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	44.3	0.0107	NR	XP_642519.1	352472	g2024	i0	28.6	0.85239852398524	77	53	85.2	1	4	234	126	200	XP_642519.1 hypothetical protein DDB_G0277703 [Dictyostelium discoideum AX4]	diamond	231	44.3	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);;