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

5 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax_clade = "Metamonada"

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
27309111	27309111	PRJNA909412_P_NODE_3943_length_265_cov_1.482301_g3802_i0	PRJNA909412	3943	265	1.482301	3.92809765	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	48.9	3.04e-4	NR	KAJ5066685.1	1746090	g3802	i0	63.3	0.339622641509434	30	11	34	0	265	176	8	37	KAJ5066685.1 zinc finger protein [Anaeramoeba ignava]	diamond	90	48.9	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28484697	28484697	PRJNA909412_P_NODE_17686_length_150_cov_2.180180_g17545_i0	PRJNA909412	17686	150	2.18018	3.27027	Tritrichomonadida	740972	Parabasalia	other_Eukaryota	47.4	1.68e-4	NR	XP_068347843.1	1144522	g17545	i0	45.8	10.7	48	24	96	1	4	147	52	97	XP_068347843.1 Ras-related protein Rab-4B [Tritrichomonas foetus]	diamond	1605	47.8	0.99163179916318	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28635347	28635347	PRJNA909412_P_NODE_13467_length_160_cov_2.917355_g13326_i0	PRJNA909412	13467	160	2.917355	4.667768	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	75.1	4.72e-14	NR	KAJ5079116.1	1746090	g13326	i0	76.7	11.79375	43	10	80.6	0	29	157	7	49	KAJ5079116.1 glycine--tRNA ligase [Anaeramoeba ignava]	diamond	1887	75.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
29329691	29329691	PRJNA909412_P_NODE_12349_length_162_cov_1.691057_g12208_i0	PRJNA909412	12349	162	1.691057	2.73951234	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	70.1	2.75e-12	NR	KAJ5072858.1	1746090	g12208	i0	62.3	0.981481481481482	53	20	98.1	0	160	2	1922	1974	KAJ5072858.1 protein rrp5 [Anaeramoeba ignava]	diamond	159	70.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
29392999	29392999	PRJNA909412_P_NODE_2789_length_316_cov_2.375451_g2649_i0	PRJNA909412	2789	316	2.375451	7.50642516	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	66.6	3.53e-10	NR	KAJ6249989.1	1746091	g2649	i0	81.1	1.05379746835443	37	7	35.1	0	111	1	129	165	KAJ6249989.1 alpha-aminoadipic semialdehyde dehydrogenase [Anaeramoeba flamelloides]	diamond	333	66.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides

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