metadata: contig_metadata: 11 rows where bioproject = "PRJNA971676" and tax

11 rows where bioproject = "PRJNA971676" 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
6047657	6047657	PRJNA971676_P_NODE_10565_length_281_cov_1.317308_g10476_i0	PRJNA971676	10565	281	1.317308	3.70163548	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	56.5	0.002	NTclustered	gi\|2806442842\|ref\|XM_068514408.1\|	1144522	g10476	i0	100	0.217081850533808	30	0	11	0	132	161	290	261	Tritrichomonas foetus SNF2 family N-terminal domain containing protein (TRFO_42633), partial mRNA	blastn	61	56.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
13698414	13698414	PRJNA971676_P_NODE_4111_length_398_cov_0.947692_g4022_i0	PRJNA971676	4111	398	0.947692	3.77181416	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	204	9.44e-60	NR	KAJ5069438.1	1746090	g4022	i0	72.5	3.9572864321608	131	36	98.7	0	2	394	356	486	KAJ5069438.1 plastin-3 [Anaeramoeba ignava]	diamond	1575	204	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27316897	27316897	PRJNA971676_P_NODE_7963_length_312_cov_1.694561_g7874_i0	PRJNA971676	7963	312	1.694561	5.28703032	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.9	9.47e-13	NR	KAJ4454393.1	342808	g7874	i0	34.3	1.83653846153846	102	67	98.1	0	307	2	1406	1507	KAJ4454393.1 putative Alpha-actinin A [Paratrimastix pyriformis]	diamond	573	73.9	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27626431	27626431	PRJNA971676_P_NODE_5964_length_347_cov_0.843066_g5875_i0	PRJNA971676	5964	347	0.843066	2.92543902	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	84.3	3.24e-16	NR	KAJ5073099.1	1746090	g5875	i0	36	0.959654178674352	111	71	96	0	339	7	353	463	KAJ5073099.1 alpha-actinin sarcomeric-like protein [Anaeramoeba ignava]	diamond	333	84.3	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28068276	28068276	PRJNA971676_P_NODE_9985_length_286_cov_2.093897_g9896_i0	PRJNA971676	9985	286	2.093897	5.98854542	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	82	7.77e-16	NR	KAJ3428123.1	1746091	g9896	i0	42.6	2.11888111888112	101	52	99.7	3	2	286	265	365	KAJ3428123.1 oxysterol-binding protein [Anaeramoeba flamelloides]	diamond	606	82	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28131606	28131606	PRJNA971676_P_NODE_605_length_900_cov_2.946796_g534_i0	PRJNA971676	605	900	2.946796	26.521164	Kipferlia bialata	797122	Fornicata	other_Eukaryota	52.4	0.00208	NR	GIQ80334.1	797122	g534	i0	27.3	0.683333333333333	205	129	62.3	7	664	104	719	921	GIQ80334.1 hypothetical protein KIPB_001114, partial [Kipferlia bialata]	diamond	615	52.4	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
28605071	28605071	PRJNA971676_P_NODE_13707_length_251_cov_1.443820_g13618_i0	PRJNA971676	13707	251	1.44382	3.6239882	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	77	6.18e-15	NR	KAJ3428586.1	1746091	g13618	i0	46.2	0.932270916334661	78	41	93.2	1	250	17	139	215	KAJ3428586.1 hypothetical protein M0812_23913 [Anaeramoeba flamelloides]	diamond	234	77	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
28952616	28952616	PRJNA971676_P_NODE_15988_length_249_cov_0.875000_g15899_i0	PRJNA971676	15988	249	0.875	2.17875	Kipferlia bialata	797122	Fornicata	other_Eukaryota	105	1.31e-24	NR	GIQ82379.1	797122	g15899	i0	53.7	0.987951807228916	82	38	98.8	0	2	247	43	124	GIQ82379.1 myo-inositol-1-phosphate synthase [Kipferlia bialata]	diamond	246	105	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
30752726	30752726	PRJNA971676_P_NODE_8714_length_302_cov_1.340611_g8625_i0	PRJNA971676	8714	302	1.340611	4.04864522	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	52.8	2.32e-5	NR	KAJ5071803.1	1746090	g8625	i0	33.7	1.8476821192053	92	59	89.4	1	6	275	827	918	KAJ5071803.1 leucine rich repeat family protein [Anaeramoeba ignava]	diamond	558	52.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30847477	30847477	PRJNA971676_P_NODE_8774_length_301_cov_1.350877_g8685_i0	PRJNA971676	8774	301	1.350877	4.06613977	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	123	6.59e-31	NR	KAJ5067249.1	1746090	g8685	i0	56.6	0.98671096345515	99	43	98.7	0	301	5	283	381	KAJ5067249.1 coronin [Anaeramoeba ignava]	diamond	297	123	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
32017385	32017385	PRJNA971676_P_NODE_10838_length_278_cov_1.360976_g10749_i0	PRJNA971676	10838	278	1.360976	3.78351328	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	77	5.11e-14	NR	KAJ5078389.1	1746090	g10749	i0	47.2	1.5431654676259	72	38	77.7	0	217	2	378	449	KAJ5078389.1 guanine exchange factor for rac 30 [Anaeramoeba ignava]	diamond	429	77	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);;