metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA438111" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA438111" 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
26680660	26680660	PRJNA438111_P_NODE_20001_length_240_cov_1.417062_g19376_i0	PRJNA438111	20001	240	1.417062	3.4009488	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	71.6	2.3e-12	NR	XP_067769627.1	135588	g19376	i0	41.9	3.7375	74	43	92.5	0	14	235	81	154	XP_067769627.1 Serine/threonine-protein kinase 4 [Histomonas meleagridis]	diamond	897	71.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
29239689	29239689	PRJNA438111_P_NODE_1469_length_779_cov_4.861333_g1128_i0	PRJNA438111	1469	779	4.861333	37.86978407	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	189	4.58e-56	NR	XP_001300248.1	412133	g1128	i0	44.3	14.8613607188703	219	114	84.3	3	60	716	1	211	XP_001300248.1 small Rab GTPase Rab11a [Trichomonas vaginalis G3]	diamond	11577	190	0.994736842105263	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
29538931	29538931	PRJNA438111_P_NODE_1570_length_755_cov_13.129477_g1214_i0	PRJNA438111	1570	755	13.129477	99.12755135	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	94.4	3.26e-19	NR	XP_068360986.1	1144522	g1214	i0	36.3	0.623841059602649	157	74	60.4	7	262	717	102	237	XP_068360986.1 uncharacterized protein TRFO_23795 [Tritrichomonas foetus]	diamond	471	94.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30423850	30423850	PRJNA438111_P_NODE_1373_length_803_cov_26.954780_g1050_i0	PRJNA438111	1373	803	26.95478	216.4468834	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	124	1.36e-30	NR	XP_068360986.1	1144522	g1050	i0	38.8	0.616438356164384	165	86	59	5	509	36	83	239	XP_068360986.1 uncharacterized protein TRFO_23795 [Tritrichomonas foetus]	diamond	495	124	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
31103213	31103213	PRJNA438111_P_NODE_33175_length_209_cov_4.266667_g32550_i0	PRJNA438111	33175	209	4.266667	8.91733403	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77.4	1.64e-15	NR	XP_001579579.1	412133	g32550	i0	51.4	4.03349282296651	70	29	97.6	2	207	4	42	108	XP_001579579.1 translation initiation factor protein [Trichomonas vaginalis G3]	diamond	843	77.8	0.994858611825193	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31339900	31339900	PRJNA438111_P_NODE_82056_length_156_cov_3.354331_g81431_i0	PRJNA438111	82056	156	3.354331	5.23275636	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	51.6	8.34e-6	NR	XP_068358930.1	1144522	g81431	i0	51.2	0.788461538461538	41	20	78.8	0	154	32	1773	1813	XP_068358930.1 uncharacterized protein TRFO_26397 [Tritrichomonas foetus]	diamond	123	51.6	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);;