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

7 rows where bioproject = "PRJNA770826", tax_clade = "Metamonada" and tax_phylum = "Parabasalia"

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
27464228	27464228	PRJNA770826_P_NODE_25663_length_168_cov_0.873950_g25492_i0	PRJNA770826	25663	168	0.87395	1.468236	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	71.6	7.72e-13	NR	XP_001317118.1	412133	g25492	i0	70	0.892857142857143	50	15	89.3	0	166	17	335	384	XP_001317118.1 OBG GTPASE family [Trichomonas vaginalis G3]	diamond	150	71.6	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
28443005	28443005	PRJNA770826_P_NODE_12346_length_229_cov_1.138889_g12175_i0	PRJNA770826	12346	229	1.138889	2.60805581	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	66.6	1.21e-10	NR	XP_068355370.1	1144522	g12175	i0	45.6	1.70305676855895	68	37	89.1	0	1	204	450	517	XP_068355370.1 calcium motive P-type ATPase [Tritrichomonas foetus]	diamond	390	66.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29106072	29106072	PRJNA770826_P_NODE_2448_length_556_cov_7.964497_g2281_i0	PRJNA770826	2448	556	7.964497	44.28260332	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	199	1.34e-61	NR	XP_068360038.1	1144522	g2281	i0	57.2	7.51079136690648	173	74	93.3	0	532	14	5	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	4176	199	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29990104	29990104	PRJNA770826_P_NODE_12491_length_227_cov_2.629213_g12320_i0	PRJNA770826	12491	227	2.629213	5.96831351	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	50.4	3.4e-5	NR	XP_001305151.1	412133	g12320	i0	41.8	0.726872246696035	55	32	72.7	0	6	170	128	182	XP_001305151.1 Golgi to endosome transport [Trichomonas vaginalis G3]	diamond	165	50.4	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31064561	31064561	PRJNA770826_P_NODE_12715_length_226_cov_0.881356_g12544_i0	PRJNA770826	12715	226	0.881356	1.99186456	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	47.4	7.19e-4	NR	XP_068349620.1	1144522	g12544	i0	31.2	1.02212389380531	77	46	92.9	2	16	225	434	510	XP_068349620.1 uncharacterized protein TRFO_37341 [Tritrichomonas foetus]	diamond	231	47.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
31199857	31199857	PRJNA770826_P_NODE_31715_length_166_cov_0.888889_g31544_i0	PRJNA770826	31715	166	0.888889	1.47555574	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	1.7e-5	NR	XP_001323658.1	412133	g31544	i0	35.8	3.86746987951807	53	34	95.8	0	164	6	245	297	XP_001323658.1 protein serine/threonine kinase protein [Trichomonas vaginalis G3]	diamond	642	51.2	0.9921875	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31728309	31728309	PRJNA770826_P_NODE_3777_length_444_cov_1.316456_g3606_i0	PRJNA770826	3777	444	1.316456	5.84506464	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	53.9	3.59e-5	NR	XP_068368591.1	1144522	g3606	i0	26.7	0.783783783783784	116	76	78.4	3	46	393	5	111	XP_068368591.1 Serine/threonine-protein kinase pakC [Tritrichomonas foetus]	diamond	348	53.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus

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