metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax_clade = "Metamonada"

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_family	tax_genus	tax_species
11128189	11128189	PRJNA944406_P_NODE_41529_length_271_cov_1.510101_g40570_i0	PRJNA944406	41529	271	1.510101	4.09237371	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	71.2	3.99e-12	NR	KAJ5072673.1	1746090	g40570	i0	72.3	3.70848708487085	47	13	52	0	127	267	2	48	KAJ5072673.1 nad-dependent epimerase/dehydratase [Anaeramoeba ignava]	diamond	1005	71.2	1	Eukaryota	Metamonada		Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27972937	27972937	PRJNA944406_P_NODE_35085_length_277_cov_1.509804_g34126_i0	PRJNA944406	35085	277	1.509804	4.18215708	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	53.5	3.32e-6	NR	KAJ4457922.1	342808	g34126	i0	36.7	0.649819494584838	60	38	65	0	276	97	114	173	KAJ4457922.1 putative integral membrane protein [Paratrimastix pyriformis]	diamond	180	53.5	1	Eukaryota	Metamonada	Preaxostyla	Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28478139	28478139	PRJNA944406_P_NODE_28486_length_283_cov_1.828571_g27527_i0	PRJNA944406	28486	283	1.828571	5.17485593	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	134	6.22e-35	NR	KAJ5067249.1	1746090	g27527	i0	63.4	0.985865724381625	93	34	98.6	0	3	281	217	309	KAJ5067249.1 coronin [Anaeramoeba ignava]	diamond	279	134	1	Eukaryota	Metamonada		Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
31953412	31953412	PRJNA944406_P_NODE_41077_length_271_cov_2.171717_g40118_i0	PRJNA944406	41077	271	2.171717	5.88535307	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	79.3	6.87e-15	NR	KAJ5077328.1	1746090	g40118	i0	43.8	0.985239852398524	89	49	98.5	1	3	269	644	731	KAJ5077328.1 hypothetical protein M0811_05850 [Anaeramoeba ignava]	diamond	267	79.3	1	Eukaryota	Metamonada		Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
32491594	32491594	PRJNA944406_P_NODE_95619_length_244_cov_0.900585_g94660_i0	PRJNA944406	95619	244	0.900585	2.1974274	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	58.5	1.02e-7	NR	KAJ5076984.1	1746090	g94660	i0	35.4	0.971311475409836	79	48	97.1	2	244	8	336	411	KAJ5076984.1 hypothetical protein M0811_00304 [Anaeramoeba ignava]	diamond	237	58.5	1	Eukaryota	Metamonada		Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
32648894	32648894	PRJNA944406_P_NODE_86480_length_246_cov_0.890173_g85521_i0	PRJNA944406	86480	246	0.890173	2.18982558	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	49.3	1.92e-4	NR	KAG9394630.1	201153	g85521	i0	44.4	0.548780487804878	45	20	48.8	1	29	148	809	853	KAG9394630.1 Periplasmic binding protein [Carpediemonas membranifera]	diamond	135	49.3	1	Eukaryota	Metamonada	Fornicata		Carpediemonas	Carpediemonas membranifera

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