metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA904835" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA904835" 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
27308946	27308946	PRJNA904835_P_NODE_41123_length_294_cov_1.045249_g40867_i0	PRJNA904835	41123	294	1.045249	3.07303206	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	43.1	0.0479	NR	KAA6383012.1	222440	g40867	i0	28.4	1.11224489795918	109	62	94.9	4	6	284	7	115	KAA6383012.1 MAG: putative Zinc finger protein 862 [Streblomastix strix]	diamond	327	43.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
27719754	27719754	PRJNA904835_P_NODE_57244_length_243_cov_0.905882_g56988_i0	PRJNA904835	57244	243	0.905882	2.20129326	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	46.2	0.00221	NR	XP_068355083.1	1144522	g56988	i0	31.1	0.91358024691358	74	34	86.4	2	243	34	183	243	XP_068355083.1 uncharacterized protein TRFO_31142 [Tritrichomonas foetus]	diamond	222	46.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28477081	28477081	PRJNA904835_P_NODE_43246_length_284_cov_1.412322_g42990_i0	PRJNA904835	43246	284	1.412322	4.01099448	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	44.3	0.018	NR	XP_068369377.1	1144522	g42990	i0	31	1.78521126760563	100	57	96.1	4	3	275	996	1092	XP_068369377.1 uncharacterized protein TRFO_41941 [Tritrichomonas foetus]	diamond	507	44.3	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29487239	29487239	PRJNA904835_P_NODE_50970_length_251_cov_0.865169_g50714_i0	PRJNA904835	50970	251	0.865169	2.17157419	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	50.4	7.83e-5	NR	KAJ3429776.1	1746091	g50714	i0	43.1	2.58167330677291	72	39	83.7	1	211	2	304	375	KAJ3429776.1 polyadenylate-binding protein [Anaeramoeba flamelloides]	diamond	648	50.4	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29557991	29557991	PRJNA904835_P_NODE_23750_length_410_cov_1.350148_g23495_i0	PRJNA904835	23750	410	1.350148	5.5356068	root	1	Root_unresolved	Root_unresolved	84	1.9e-17	NR	KAJ3447275.1	1746091	g23495	i0	41.5	2.26829268292683	94	54	68.8	1	2	283	12	104	KAJ3447275.1 ras-related protein rab-26 [Anaeramoeba flamelloides]	diamond	930	84	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29676513	29676513	PRJNA904835_P_NODE_34450_length_330_cov_1.420233_g34194_i0	PRJNA904835	34450	330	1.420233	4.6867689	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	104	5.1399999999999994e-24	NR	KAJ5077547.1	1746090	g34194	i0	50.5	2.95454545454545	109	47	93.6	3	329	21	38	145	KAJ5077547.1 hypothetical protein M0811_05646 [Anaeramoeba ignava]	diamond	975	104	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30087400	30087400	PRJNA904835_P_NODE_37732_length_312_cov_0.841004_g37476_i0	PRJNA904835	37732	312	0.841004	2.62393248	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	45.1	0.0126	NR	KAJ5073038.1	1746090	g37476	i0	37	0.884615384615385	92	54	85.6	3	305	39	375	465	KAJ5073038.1 atp synthase coupling factor b [Anaeramoeba ignava]	diamond	276	45.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);;