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

5 rows where bioproject = "PRJNA906294" 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
29014175	29014175	PRJNA906294_P_NODE_146568_length_316_cov_6.061728_g142452_i0	PRJNA906294	146568	316	6.061728	19.15506048	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	99.8	1.0199999999999999e-23	NR	XP_068360038.1	1144522	g142452	i0	50.5	0.958860759493671	101	50	95.9	0	1	303	77	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	303	99.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29140402	29140402	PRJNA906294_P_NODE_207649_length_249_cov_0.869318_g203533_i0	PRJNA906294	207649	249	0.869318	2.16460182	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	50.4	7.62e-6	NR	XP_001322150.1	412133	g203533	i0	41.7	0.72289156626506	60	35	72.3	0	246	67	19	78	XP_001322150.1 COMM domain containing protein 5 family [Trichomonas vaginalis G3]	diamond	180	50.4	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30213786	30213786	PRJNA906294_P_NODE_4772_length_2548_cov_3.335354_g4009_i0	PRJNA906294	4772	2548	3.335354	84.98481992	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	110	7.06e-21	NR	XP_067770880.1	135588	g4009	i0	26.2	1.04199372056515	439	268	47.2	15	24	1226	22	442	XP_067770880.1 C2 domain containing protein [Histomonas meleagridis]	diamond	2655	110	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
31984057	31984057	PRJNA906294_P_NODE_208018_length_249_cov_0.863636_g203902_i0	PRJNA906294	208018	249	0.863636	2.15045364	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	42.7	0.0413	NR	XP_001313467.1	412133	g203902	i0	31.1	0.891566265060241	74	50	89.2	1	4	225	258	330	XP_001313467.1 nuclear pore complex assembly [Trichomonas vaginalis G3]	diamond	222	42.7	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32458894	32458894	PRJNA906294_P_NODE_176839_length_279_cov_1.004854_g172723_i0	PRJNA906294	176839	279	1.004854	2.80354266	Tritrichomonas musculus	1915356	Parabasalia	other_Eukaryota	86.3	4.69e-18	NR	KAK8834563.1	1915356	g172723	i0	47.3	1.98924731182796	93	48	100	1	1	279	144	235	KAK8834563.1 hypothetical protein M9Y10_027545 [Tritrichomonas musculus]	diamond	555	86.3	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas musculus

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