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

5 rows where analysis = "diamond", bioproject = "PRJNA1192965" 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
10524220	10524220	PRJNA1192965_P_NODE_849_length_412_cov_4.306785_g830_i0	PRJNA1192965	849	412	4.306785	17.7439542	root	1	Root_unresolved	Root_unresolved	204	1.03e-64	NR	KAJ5080793.1	1746090	g830	i0	66.9	6.93932038834951	136	45	99	0	410	3	1	136	KAJ5080793.1 40S ribosomal protein S11 [Anaeramoeba ignava]	diamond	2859	205	0.995121951219512	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28620023	28620023	PRJNA1192965_P_NODE_647_length_467_cov_4.893401_g628_i0	PRJNA1192965	647	467	4.893401	22.85218267	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	186	6.21e-57	NR	XP_068360038.1	1144522	g628	i0	60.3	1.9593147751606	151	60	97	0	15	467	5	155	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	915	186	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28702095	28702095	PRJNA1192965_P_NODE_4087_length_247_cov_0.885057_g4068_i0	PRJNA1192965	4087	247	0.885057	2.18609079	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	127	2.12e-33	NR	KAJ5066882.1	1746090	g4068	i0	72.3	1.95546558704453	83	21	98.4	1	5	247	120	202	KAJ5066882.1 fructose-bisphosphate aldolase [Anaeramoeba ignava]	diamond	483	127	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
29756356	29756356	PRJNA1192965_P_NODE_5091_length_241_cov_0.916667_g5072_i0	PRJNA1192965	5091	241	0.916667	2.20916747	Giardia intestinalis	5741	Fornicata	other_Eukaryota	48.5	3.25e-4	NR	ESU43468.1	5741	g5072	i0	49.2	0.759336099585062	61	25	73.4	3	2	178	326	382	ESU43468.1 Variant-specific surface protein [Giardia intestinalis]	diamond	183	48.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29914585	29914585	PRJNA1192965_P_NODE_1051_length_381_cov_4.987013_g1032_i0	PRJNA1192965	1051	381	4.987013	19.00051953	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	132	2.81e-36	NR	KAJ4455598.1	342808	g1032	i0	53	8.8503937007874	117	55	92.1	0	364	14	14	130	KAJ4455598.1 putative 40S ribosomal protein S19-1 [Paratrimastix pyriformis]	diamond	3372	132	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis

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