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

7 rows where analysis = "diamond", bioproject = "PRJNA229468" 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
26870589	26870589	PRJNA229468_S_NODE_641_length_203_cov_1.324675_g628_i0	PRJNA229468	641	203	1.324675	2.68909025	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.6	3.23e-14	NR	XP_001301101.1	412133	g628	i0	55.2	1.98029556650246	67	30	99	0	2	202	98	164	XP_001301101.1 ribosomal protein family [Trichomonas vaginalis G3]	diamond	402	73.6	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27421864	27421864	PRJNA229468_S_NODE_1163_length_164_cov_0.886957_g1150_i0	PRJNA229468	1163	164	0.886957	1.45460948	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	41.6	0.0143	NR	GKT36224.1	2918883	g1150	i0	41.2	1.75609756097561	51	26	93.3	1	158	6	61	107	GKT36224.1 ubiquitin-fusion protein [Aduncisulcus paluster]	diamond	288	41.6	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
27926825	27926825	PRJNA229468_S_NODE_325_length_275_cov_2.030973_g312_i0	PRJNA229468	325	275	2.030973	5.58517575	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	144	8.13e-42	NR	XP_067763597.1	348837	g312	i0	70.3	0.992727272727273	91	27	99.3	0	2	274	8	98	XP_067763597.1 Nucleoside diphosphate kinase [Spironucleus salmonicida]	diamond	273	144	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
28368767	28368767	PRJNA229468_S_NODE_226_length_326_cov_1.104693_g213_i0	PRJNA229468	226	326	1.104693	3.60129918	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	44.3	0.0219	NR	XP_001316090.1	412133	g213	i0	41.9	0.395705521472393	43	25	39.6	0	2	130	25	67	XP_001316090.1 ankyrin repeat-containing protein DDB G0279043 family [Trichomonas vaginalis G3]	diamond	129	44.3	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
29852922	29852922	PRJNA229468_S_NODE_891_length_178_cov_1.581395_g878_i0	PRJNA229468	891	178	1.581395	2.8148831	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	46.6	6.92e-4	NR	KAJ3435885.1	1746091	g878	i0	41.9	2.81460674157303	62	24	87.6	3	2	157	141	200	KAJ3435885.1 camk family protein kinase [Anaeramoeba flamelloides]	diamond	501	46.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31242981	31242981	PRJNA229468_S_NODE_835_length_182_cov_1.533835_g822_i0	PRJNA229468	835	182	1.533835	2.7915797	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	100	7.93e-24	NR	GKT34402.1	2918883	g822	i0	79.7	1.94505494505495	59	12	97.3	0	179	3	48	106	GKT34402.1 60S ribosomal protein L5 [Aduncisulcus paluster]	diamond	354	100	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
32697538	32697538	PRJNA229468_S_NODE_240_length_320_cov_1.003690_g227_i0	PRJNA229468	240	320	1.00369	3.211808	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	67	1.03e-11	NR	KAJ4453711.1	342808	g227	i0	51.6	1.265625	64	29	60	1	14	205	4	65	KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis]	diamond	405	67	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis

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