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

7 rows where analysis = "diamond", bioproject = "PRJEB14803" 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
20422237	20422237	PRJEB14803_P_NODE_4897_length_630_cov_7.332773_g4500_i0	PRJEB14803	4897	630	7.332773	46.1964699	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	301	9.24e-102	NR	XP_001322019.1	412133	g4500	i0	83.5	4.89047619047619	170	28	81	0	616	107	3	172	XP_001322019.1 peptidyl-prolyl cis-trans isomerase protein [Trichomonas vaginalis G3]	diamond	3081	301	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
26747780	26747780	PRJEB14803_P_NODE_22901_length_236_cov_1.651741_g22435_i0	PRJEB14803	22901	236	1.651741	3.89810876	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	53.9	3.96e-6	NR	XP_068354014.1	1144522	g22435	i0	63.4	0.521186440677966	41	15	52.1	0	207	85	392	432	XP_068354014.1 Clan CA, family C19, ubiquitin hydrolase-like cysteine peptidase [Tritrichomonas foetus]	diamond	123	53.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28738491	28738491	PRJEB14803_P_NODE_19047_length_267_cov_2.461207_g18581_i0	PRJEB14803	19047	267	2.461207	6.57142269	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	57	4.72e-7	NR	XP_001329056.1	412133	g18581	i0	37.7	1.87640449438202	77	45	86.5	2	28	258	1	74	XP_001329056.1 ribosomal protein S6 kinase family [Trichomonas vaginalis G3]	diamond	501	57	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
29401513	29401513	PRJEB14803_P_NODE_15969_length_300_cov_2.437736_g15503_i0	PRJEB14803	15969	300	2.437736	7.313208	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	79	3.79e-15	NR	XP_001581855.1	412133	g15503	i0	47.1	1.02	102	45	96	2	292	5	129	227	XP_001581855.1 hypothetical protein TVAGG3_0565230 [Trichomonas vaginalis G3]	diamond	306	79	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30349627	30349627	PRJEB14803_P_NODE_32212_length_189_cov_1.961039_g31746_i0	PRJEB14803	32212	189	1.961039	3.70636371	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	60.1	9.51e-9	NR	XP_001329861.1	412133	g31746	i0	54.5	0.873015873015873	55	25	87.3	0	188	24	27	81	XP_001329861.1 ankyrin repeat protein family [Trichomonas vaginalis G3]	diamond	165	60.1	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30981209	30981209	PRJEB14803_P_NODE_5214_length_608_cov_3.387435_g4811_i0	PRJEB14803	5214	608	3.387435	20.5956048	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	72.8	3.81e-11	NR	XP_067774481.1	135588	g4811	i0	27.6	0.838815789473684	170	117	83.9	2	576	67	236	399	XP_067774481.1 Pumilio-family RNA binding repeat containing protein [Histomonas meleagridis]	diamond	510	72.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
31708207	31708207	PRJEB14803_P_NODE_35637_length_178_cov_1.118881_g35171_i0	PRJEB14803	35637	178	1.118881	1.99160818	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	77.4	9.49e-15	NR	XP_068367627.1	1144522	g35171	i0	55.4	1.93820224719101	56	25	94.4	0	7	174	437	492	XP_068367627.1 Type III restriction enzyme, res subunit family protein [Tritrichomonas foetus]	diamond	345	77.4	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);;