metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1082072" 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_order	tax_family	tax_genus	tax_species
18868814	18868814	PRJNA1082072_P_NODE_795_length_371_cov_1.479866_g788_i0	PRJNA1082072	795	371	1.479866	5.49030286	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	172	9.17e-52	NR	KAJ3430008.1	1746091	g788	i0	61	3.04043126684636	123	48	99.5	0	369	1	68	190	KAJ3430008.1 hypothetical protein M0812_23008 [Anaeramoeba flamelloides]	diamond	1128	172	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
27099057	27099057	PRJNA1082072_P_NODE_1742_length_272_cov_2.170854_g1735_i0	PRJNA1082072	1742	272	2.170854	5.90472288	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	93.2	4.01e-21	NR	KAJ3430008.1	1746091	g1735	i0	53.2	0.871323529411765	79	37	87.1	0	270	34	129	207	KAJ3430008.1 hypothetical protein M0812_23008 [Anaeramoeba flamelloides]	diamond	237	93.2	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
27857109	27857109	PRJNA1082072_P_NODE_2965_length_241_cov_0.916667_g2958_i0	PRJNA1082072	2965	241	0.916667	2.20916747	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	78.6	1.37e-15	NR	KAA6379712.1	222440	g2958	i0	47.7	1.07053941908714	86	39	99.6	1	240	1	65	150	KAA6379712.1 MAG: putative elav G [Streblomastix strix]	diamond	258	78.6	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
28362291	28362291	PRJNA1082072_P_NODE_926_length_349_cov_1.115942_g919_i0	PRJNA1082072	926	349	1.115942	3.89463758	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	121	5.44e-32	NR	XP_068360038.1	1144522	g919	i0	53	9.75644699140401	115	54	98.9	0	347	3	59	173	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	3405	121	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28551966	28551966	PRJNA1082072_P_NODE_1507_length_286_cov_1.107981_g1500_i0	PRJNA1082072	1507	286	1.107981	3.16882566	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	75.5	1.96e-13	NR	KAJ5079114.1	1746090	g1500	i0	45.3	0.996503496503496	95	52	99.7	0	286	2	338	432	KAJ5079114.1 alpha-actinin-2 [Anaeramoeba ignava]	diamond	285	75.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30920766	30920766	PRJNA1082072_P_NODE_1814_length_268_cov_1.343590_g1807_i0	PRJNA1082072	1814	268	1.34359	3.6008212	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	67.4	1.05e-10	NR	KAJ5077145.1	1746090	g1807	i0	43.7	1.7910447761194	71	40	79.5	0	4	216	409	479	KAJ5077145.1 pep-cterm sorting domain-containing protein [Anaeramoeba ignava]	diamond	480	67.4	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
31038693	31038693	PRJNA1082072_P_NODE_2775_length_243_cov_0.905882_g2768_i0	PRJNA1082072	2775	243	0.905882	2.20129326	Hexamitidae	5739	Fornicata	other_Eukaryota	45.8	0.0029	NR	ESU40123.1	5741	g2768	i0	39	3.01234567901235	59	34	70.4	1	53	223	173	231	ESU40123.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	732	45.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31132897	31132897	PRJNA1082072_P_NODE_1275_length_307_cov_1.166667_g1268_i0	PRJNA1082072	1275	307	1.166667	3.58166769	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	76.6	9.92e-14	NR	KAJ4454393.1	342808	g1268	i0	43	1.96416938110749	100	51	97.7	2	3	302	1426	1519	KAJ4454393.1 putative Alpha-actinin A [Paratrimastix pyriformis]	diamond	603	77	0.994805194805195	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32470543	32470543	PRJNA1082072_P_NODE_2239_length_249_cov_1.750000_g2232_i0	PRJNA1082072	2239	249	1.75	4.3575	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	45.1	0.00579	NR	XP_068354929.1	1144522	g2232	i0	34.5	0.662650602409639	55	36	66.3	0	244	80	222	276	XP_068354929.1 uncharacterized protein TRFO_07339 [Tritrichomonas foetus]	diamond	165	45.1	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus

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