metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA682370" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA682370" 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
18516607	18516607	PRJNA682370_S_NODE_6435_length_307_cov_1.915441_g5823_i0	PRJNA682370	6435	307	1.915441	5.88040387	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	93.6	1.66e-20	NR	KAJ5068478.1	1746090	g5823	i0	53.4	4.54397394136808	88	34	85	3	9	269	28	109	KAJ5068478.1 hypothetical protein M0811_02411 [Anaeramoeba ignava]	diamond	1395	93.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
27840005	27840005	PRJNA682370_S_NODE_12264_length_206_cov_1.362573_g11652_i0	PRJNA682370	12264	206	1.362573	2.80690038	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	90.5	3.46e-19	NR	KAJ5079114.1	1746090	g11652	i0	65.7	1.95145631067961	67	23	97.6	0	201	1	153	219	KAJ5079114.1 alpha-actinin-2 [Anaeramoeba ignava]	diamond	402	90.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
28313914	28313914	PRJNA682370_S_NODE_21526_length_157_cov_1.745902_g20914_i0	PRJNA682370	21526	157	1.745902	2.74106614	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	45.1	0.00171	NR	KAJ4459703.1	342808	g20914	i0	51.1	2.44585987261146	47	19	89.8	1	12	152	113	155	KAJ4459703.1 putative charged multivesicular body protein 6 [Paratrimastix pyriformis]	diamond	384	45.1	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28988800	28988800	PRJNA682370_S_NODE_9688_length_236_cov_2.064677_g9076_i0	PRJNA682370	9688	236	2.064677	4.87263772	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	45.8	0.00275	NR	ESU38829.1	5741	g9076	i0	41.9	5.04661016949153	62	27	77.5	4	214	32	225	278	ESU38829.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	1191	45.8	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29545108	29545108	PRJNA682370_S_NODE_8390_length_259_cov_2.406250_g7778_i0	PRJNA682370	8390	259	2.40625	6.2321875	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	83.6	8.42e-19	NR	KAJ3428161.1	1746091	g7778	i0	56.7	3.1969111969112	60	26	69.5	0	3	182	12	71	KAJ3428161.1 enolase-phosphatase e1 [Anaeramoeba flamelloides]	diamond	828	83.6	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31377850	31377850	PRJNA682370_S_NODE_3896_length_413_cov_3.309524_g3285_i0	PRJNA682370	3896	413	3.309524	13.66833412	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	151	2.19e-42	NR	KAJ5075674.1	1746090	g3285	i0	49.6	0.966101694915254	133	64	94.4	1	394	5	117	249	KAJ5075674.1 hypothetical protein M0811_07246 [Anaeramoeba ignava]	diamond	399	151	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava

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