metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1028258" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1028258" 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
10366890	10366890	PRJNA1028258_P_NODE_145169_length_232_cov_0.871166_g144606_i0	PRJNA1028258	145169	232	0.871166	2.02110512	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	92.8	2.44e-21	NR	XP_001316606.1	412133	g144606	i0	56.6	10.8491379310345	76	33	98.3	0	4	231	28	103	XP_001316606.1 regulation of endocytosis [Trichomonas vaginalis G3]	diamond	2517	92.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27035046	27035046	PRJNA1028258_P_NODE_173602_length_226_cov_0.872611_g173039_i0	PRJNA1028258	173602	226	0.872611	1.97210086	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	105	1.61e-25	NR	XP_001316445.1	412133	g173039	i0	54.7	0.995575221238938	75	34	99.6	0	225	1	124	198	XP_001316445.1 phosphoprotein phosphatase protein [Trichomonas vaginalis G3]	diamond	225	105	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27540724	27540724	PRJNA1028258_P_NODE_41104_length_394_cov_2.390769_g40541_i0	PRJNA1028258	41104	394	2.390769	9.41962986	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	167	9.54e-50	NR	XP_068360038.1	1144522	g40541	i0	61.8	0.99746192893401	131	50	99.7	0	1	393	7	137	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	393	167	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
27848264	27848264	PRJNA1028258_P_NODE_173264_length_226_cov_0.904459_g172701_i0	PRJNA1028258	173264	226	0.904459	2.04407734	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77	1.37e-14	NR	XP_001300296.1	412133	g172701	i0	50.7	9.76991150442478	71	35	94.2	0	14	226	108	178	XP_001300296.1 protein serine/threonine kinase protein [Trichomonas vaginalis G3]	diamond	2208	77.4	0.994832041343669	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
28172066	28172066	PRJNA1028258_P_NODE_22486_length_537_cov_1.365385_g21929_i0	PRJNA1028258	22486	537	1.365385	7.33211745	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	174	1.24e-51	NR	KAH0785682.1	135588	g21929	i0	55.4	0.826815642458101	148	66	82.7	0	532	89	11	158	KAH0785682.1 Ras-related protein RABD1 [Histomonas meleagridis]	diamond	444	174	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
28322012	28322012	PRJNA1028258_P_NODE_154506_length_230_cov_0.881988_g153943_i0	PRJNA1028258	154506	230	0.881988	2.0285724	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.2	5.98e-13	NR	XP_067773816.1	135588	g153943	i0	46.5	4.86521739130435	71	38	92.6	0	213	1	32	102	XP_067773816.1 putative alpha-actinin [Histomonas meleagridis]	diamond	1119	73.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
30730106	30730106	PRJNA1028258_P_NODE_137274_length_234_cov_0.860606_g136711_i0	PRJNA1028258	137274	234	0.860606	2.01381804	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	90.9	2.73e-19	NR	XP_068359062.1	1144522	g136711	i0	60	0.961538461538462	75	30	96.2	0	2	226	347	421	XP_068359062.1 STE family protein kinase [Tritrichomonas foetus]	diamond	225	90.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30880196	30880196	PRJNA1028258_P_NODE_51714_length_353_cov_1.630282_g51151_i0	PRJNA1028258	51714	353	1.630282	5.75489546	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.8	3.25e-23	NR	XP_067768974.1	135588	g51151	i0	46.2	9.73937677053824	117	47	99.4	2	1	351	44	144	XP_067768974.1 ribosomal protein S19e [Histomonas meleagridis]	diamond	3438	97.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
31425422	31425422	PRJNA1028258_P_NODE_124696_length_240_cov_1.865497_g124133_i0	PRJNA1028258	124696	240	1.865497	4.4771928	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	72	1.72e-12	NR	XP_001304301.1	412133	g124133	i0	44.2	2.8875	77	42	96.3	1	9	239	337	412	XP_001304301.1 ribonuclease family [Trichomonas vaginalis G3]	diamond	693	72	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32026607	32026607	PRJNA1028258_P_NODE_8518_length_855_cov_3.043257_g8076_i0	PRJNA1028258	8518	855	3.043257	26.01984735	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	74.7	4.3e-12	NR	XP_001304133.1	412133	g8076	i0	29.4	0.571929824561404	163	109	55.8	4	15	491	7	167	XP_001304133.1 GTPase protein [Trichomonas vaginalis G3]	diamond	489	74.7	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis

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