metadata: contig_metadata: 5 rows where bioproject = "PRJNA1068513" and tax

5 rows where bioproject = "PRJNA1068513" 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
7834465	7834465	PRJNA1068513_S_NODE_967_length_699_cov_11.271565_g928_i0	PRJNA1068513	967	699	11.271565	78.78823935	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	75	1.49e-8	NTclustered	gi\|1064244907\|gb\|KX425904.1\|	1144522	g928	i0	85.135	0.832618025751073	74	9	10	2	256	328	495	423	Tritrichomonas foetus isolate NAM-27 cysteine protease 1 gene, partial cds	blastn	582	75	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28141414	28141414	PRJNA1068513_S_NODE_7705_length_327_cov_3.688976_g7659_i0	PRJNA1068513	7705	327	3.688976	12.06295152	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	43.5	0.0318	NR	XP_001322178.1	412133	g7659	i0	42.6	0.431192660550459	47	25	43.1	1	324	184	136	180	XP_001322178.1 small Ras GTPase Rsp [Trichomonas vaginalis G3]	diamond	141	43.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
29530466	29530466	PRJNA1068513_S_NODE_14150_length_197_cov_2.766129_g14104_i0	PRJNA1068513	14150	197	2.766129	5.44927413	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	47	6.45e-4	NR	XP_068351632.1	1144522	g14104	i0	47.9	1.46192893401015	48	24	73.1	1	195	52	219	265	XP_068351632.1 CAMK family protein kinase [Tritrichomonas foetus]	diamond	288	47	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30415205	30415205	PRJNA1068513_S_NODE_3853_length_455_cov_2.573298_g3808_i0	PRJNA1068513	3853	455	2.573298	11.7085059	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	107	7.1e-24	NR	XP_001307808.1	412133	g3808	i0	42.9	0.876923076923077	133	76	87.7	0	455	57	341	473	XP_001307808.1 Clan MH, family M20, peptidase T-like metallopeptidase dapE [Trichomonas vaginalis G3]	diamond	399	107	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32248985	32248985	PRJNA1068513_S_NODE_1638_length_601_cov_24.403409_g1597_i0	PRJNA1068513	1638	601	24.403409	146.66448809	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	200	1.12e-61	NR	XP_068360038.1	1144522	g1597	i0	57.2	1.73211314475874	173	74	86.4	0	6	524	5	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	1041	200	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);;