metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA902515" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA902515" 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
3432041	3432041	PRJNA902515_P_NODE_5063_length_345_cov_1.147059_g5040_i0	PRJNA902515	5063	345	1.147059	3.95735355	Tritrichomonas musculus	1915356	Parabasalia	other_Eukaryota	63.5	6.03e-9	NR	KAK8834280.1	1915356	g5040	i0	69.6	0.4	46	12	38.3	1	344	213	204	249	KAK8834280.1 hypothetical protein M9Y10_032052 [Tritrichomonas musculus]	diamond	138	63.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas musculus
12360213	12360213	PRJNA902515_P_NODE_15690_length_243_cov_0.917647_g15667_i0	PRJNA902515	15690	243	0.917647	2.22988221	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	99.4	7.85e-25	NR	XP_068364958.1	1144522	g15667	i0	57.5	0.987654320987654	80	34	98.8	0	3	242	3	82	XP_068364958.1 Thioredoxin [Tritrichomonas foetus]	diamond	240	99.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
13634993	13634993	PRJNA902515_P_NODE_16331_length_236_cov_3.576687_g16308_i0	PRJNA902515	16331	236	3.576687	8.44098132	Tritrichomonas musculus	1915356	Parabasalia	other_Eukaryota	107	4.22e-26	NR	KAK8834819.1	1915356	g16308	i0	76.4	0.915254237288136	72	15	89	1	2	211	189	260	KAK8834819.1 alpha-actinin [Tritrichomonas musculus]	diamond	216	107	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas musculus
25107506	25107506	PRJNA902515_P_NODE_9240_length_274_cov_1.462687_g9217_i0	PRJNA902515	9240	274	1.462687	4.00776238	Tritrichomonas musculus	1915356	Parabasalia	other_Eukaryota	94.4	4.9900000000000006e-21	NR	KAK8834655.1	1915356	g9217	i0	52.6	0.854014598540146	78	36	85.4	1	262	29	126	202	KAK8834655.1 hypothetical protein M9Y10_026543 [Tritrichomonas musculus]	diamond	234	94.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas musculus
32805490	32805490	PRJNA902515_P_NODE_11660_length_252_cov_0.871508_g11637_i0	PRJNA902515	11660	252	0.871508	2.19620016	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	143	1.4799999999999998e-37	NR	XP_068356026.1	1144522	g11637	i0	80.7	0.988095238095238	83	16	98.8	0	251	3	633	715	XP_068356026.1 uncharacterized protein TRFO_06944 [Tritrichomonas foetus]	diamond	249	143	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);;