metadata: contig_metadata: 7 rows where bioproject = "PRJNA1146029", tax_clade = "Metamonada" and tax

7 rows where bioproject = "PRJNA1146029", tax_clade = "Metamonada" and tax_superkingdom = "Eukaryota"

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
2841111	2841111	PRJNA1146029_P_NODE_9883_length_290_cov_2.479263_g9602_i0	PRJNA1146029	9883	290	2.479263	7.1898627	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	164	6.11e-50	NR	KAJ5074353.1	1746090	g9602	i0	76	41.3068965517241	96	23	99.3	0	1	288	25	120	KAJ5074353.1 hypothetical protein M0811_00982 [Anaeramoeba ignava]	diamond	11979	164	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
18141906	18141906	PRJNA1146029_P_NODE_3075_length_487_cov_1.673913_g2798_i0	PRJNA1146029	3075	487	1.673913	8.15195631	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	162	2.29e-47	NR	KAJ5073093.1	1746090	g2798	i0	70.6	2.02053388090349	109	32	67.1	0	484	158	96	204	KAJ5073093.1 ribosomal protein L15 [Anaeramoeba ignava]	diamond	984	162	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
20691603	20691603	PRJNA1146029_P_NODE_18097_length_248_cov_0.880000_g17816_i0	PRJNA1146029	18097	248	0.88	2.1824	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	70.5	5.45e-12	NR	KAJ5070615.1	1746090	g17816	i0	56.1	2.15322580645161	57	25	69	0	177	7	116	172	KAJ5070615.1 cysteine protease rd19c-related [Anaeramoeba ignava]	diamond	534	70.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
29912781	29912781	PRJNA1146029_P_NODE_14211_length_263_cov_1.557895_g13930_i0	PRJNA1146029	14211	263	1.557895	4.09726385	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	94.7	4.16e-21	NR	KAJ4461978.1	342808	g13930	i0	47.1	0.992395437262357	87	46	99.2	0	263	3	216	302	KAJ4461978.1 putative Dimethyladenosine transferase [Paratrimastix pyriformis]	diamond	261	94.7	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30312770	30312770	PRJNA1146029_P_NODE_6652_length_343_cov_2.659259_g6374_i0	PRJNA1146029	6652	343	2.659259	9.12125837	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	57.8	6.12e-7	NR	KAH0786265.1	135588	g6374	i0	33.9	7.82798833819242	112	28	98	3	336	1	126	191	KAH0786265.1 CAMK family protein kinase [Histomonas meleagridis]	diamond	2685	58.2	0.993127147766323	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
31556185	31556185	PRJNA1146029_P_NODE_15016_length_257_cov_1.673913_g14735_i0	PRJNA1146029	15016	257	1.673913	4.30195641	Giardia intestinalis	5741	Fornicata	other_Eukaryota	44.7	0.00887	NR	ESU44296.1	5741	g14735	i0	57.6	0.385214007782101	33	14	38.5	0	4	102	11	43	ESU44296.1 Variant-specific surface protein [Giardia intestinalis]	diamond	99	44.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32883034	32883034	PRJNA1146029_P_NODE_14120_length_264_cov_1.167539_g13839_i0	PRJNA1146029	14120	264	1.167539	3.08230296	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	97.1	3.850000000000001e-21	NR	KAJ5066923.1	1746090	g13839	i0	55.4	1.04545454545455	92	34	96.6	2	256	2	218	309	KAJ5066923.1 severin [Anaeramoeba ignava]	diamond	276	97.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava

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