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

5 rows where bioproject = "PRJNA857143" 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
23794990	23794990	PRJNA857143_S_NODE_100299_length_313_cov_1.216667_g99206_i0	PRJNA857143	100299	313	1.216667	3.80816771	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	52.8	0.029	NTclustered	gi\|2806476195\|ref\|XM_068490372.1\|	1144522	g99206	i0	94.118	0.108626198083067	34	2	11	0	257	290	2294	2261	Tritrichomonas foetus uncharacterized protein (TRFO_01892), partial mRNA	blastn	34	52.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28286593	28286593	PRJNA857143_S_NODE_84646_length_332_cov_2.084942_g83553_i0	PRJNA857143	84646	332	2.084942	6.92200744	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	58.5	2.84e-7	NR	XP_068360338.1	1144522	g83553	i0	37.1	1.80722891566265	70	44	63.3	0	332	123	232	301	XP_068360338.1 CAMK family protein kinase [Tritrichomonas foetus]	diamond	600	58.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28634351	28634351	PRJNA857143_S_NODE_93287_length_321_cov_1.572581_g92194_i0	PRJNA857143	93287	321	1.572581	5.04798501	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	86.3	4.57e-17	NR	XP_067776010.1	135588	g92194	i0	47.3	0.869158878504673	93	49	86.9	0	4	282	371	463	XP_067776010.1 AGC family protein kinase [Histomonas meleagridis]	diamond	279	86.3	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
30908289	30908289	PRJNA857143_S_NODE_147774_length_268_cov_2.000000_g146681_i0	PRJNA857143	147774	268	2	5.36	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	63.5	2.35e-9	NR	XP_001304645.1	412133	g146681	i0	42.6	0.761194029850746	68	37	76.1	2	2	205	415	480	XP_001304645.1 hydrantoinase/dihydropyrimidinase family member family [Trichomonas vaginalis G3]	diamond	204	63.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31066359	31066359	PRJNA857143_S_NODE_111355_length_301_cov_1.210526_g110262_i0	PRJNA857143	111355	301	1.210526	3.64368326	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	52.8	2.15e-5	NR	EAX89583.1	412133	g110262	i0	37.2	2.75083056478405	78	47	75.7	1	1	228	354	431	EAX89583.1 C2 domain containing protein [Trichomonas vaginalis G3]	diamond	828	52.8	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);;