metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1126198" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1126198" 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
26838064	26838064	PRJNA1126198_P_NODE_470281_length_242_cov_0.917160_g469560_i0	PRJNA1126198	470281	242	0.91716	2.2195272	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.1	8.47e-12	NR	KAJ4452535.1	342808	g469560	i0	45	5.91322314049587	80	39	99.2	1	242	3	613	687	KAJ4452535.1 putative Calcium-dependent protein kinase 15 [Paratrimastix pyriformis]	diamond	1431	70.1	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
27418193	27418193	PRJNA1126198_P_NODE_430103_length_246_cov_0.884393_g429382_i0	PRJNA1126198	430103	246	0.884393	2.17560678	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	53.5	5.33e-6	NR	XP_068347933.1	1144522	g429382	i0	42	0.98780487804878	81	42	98.8	2	2	244	207	282	XP_068347933.1 Cell division control protein 2 like protein [Tritrichomonas foetus]	diamond	243	53.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28238632	28238632	PRJNA1126198_P_NODE_363846_length_252_cov_1.910615_g363125_i0	PRJNA1126198	363846	252	1.910615	4.8147498	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	107	1.66e-25	NR	KAJ3434462.1	1746091	g363125	i0	53.6	3	84	39	100	0	252	1	63	146	KAJ3434462.1 muscle-specific protein [Anaeramoeba flamelloides]	diamond	756	107	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31018215	31018215	PRJNA1126198_P_NODE_99555_length_343_cov_1.274074_g98837_i0	PRJNA1126198	99555	343	1.274074	4.37007382	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	164	1.55e-44	NR	KAJ3429226.1	1746091	g98837	i0	65.8	2.99125364431487	114	39	99.7	0	342	1	350	463	KAJ3429226.1 arginine--tRNA ligase cytoplasmic-related [Anaeramoeba flamelloides]	diamond	1026	164	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31397639	31397639	PRJNA1126198_P_NODE_461376_length_243_cov_0.900000_g460655_i0	PRJNA1126198	461376	243	0.9	2.187	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	59.7	3.81e-8	NR	KAJ3445196.1	1746091	g460655	i0	46.8	0.975308641975309	79	39	96.3	2	236	3	54	130	KAJ3445196.1 beta-hexosaminidase [Anaeramoeba flamelloides]	diamond	237	59.7	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides

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