metadata: contig_metadata: 6 rows where bioproject = "PRJNA596870" and tax

6 rows where bioproject = "PRJNA596870" 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
14597193	14597193	PRJNA596870_P_NODE_22372_length_285_cov_1.061321_g22239_i0	PRJNA596870	22372	285	1.061321	3.02476485	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	56.5	0.002	NTclustered	gi\|2794976691\|ref\|XM_067864732.1\|	2049356	g22239	i0	96.97	0.417543859649123	33	1	12	0	110	142	640	608	Monocercomonoides exilis uncharacterized protein (MONOS_12136), mRNA	blastn	119	56.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
28293223	28293223	PRJNA596870_P_NODE_37106_length_244_cov_0.900585_g36973_i0	PRJNA596870	37106	244	0.900585	2.1974274	Giardia	5740	Fornicata	other_Eukaryota	49.7	1.35e-4	NR	ESU44889.1	5741	g36973	i0	36.1	2.02868852459016	83	36	87.3	3	231	19	264	341	ESU44889.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	495	50.1	0.992015968063872	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29511202	29511202	PRJNA596870_P_NODE_17290_length_318_cov_1.257143_g17157_i0	PRJNA596870	17290	318	1.257143	3.99771474	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	48.1	6.06e-4	NR	KAJ5080472.1	1746090	g17157	i0	43.1	0.547169811320755	58	27	49.1	1	212	57	5	62	KAJ5080472.1 zinc finger ccch domain-containing protein [Anaeramoeba ignava]	diamond	174	48.1	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
29605703	29605703	PRJNA596870_P_NODE_30610_length_250_cov_0.870056_g30477_i0	PRJNA596870	30610	250	0.870056	2.17514	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	47	0.00127	NR	KAK2947385.1	2049346	g30477	i0	36.2	0.828	69	36	82.8	2	33	239	17	77	KAK2947385.1 putative Polyadenylate-binding protein [Blattamonas nauphoetae]	diamond	207	47	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
30490623	30490623	PRJNA596870_P_NODE_16513_length_324_cov_1.533865_g16380_i0	PRJNA596870	16513	324	1.533865	4.9697226	Giardia intestinalis	5741	Fornicata	other_Eukaryota	53.9	1.13e-5	NR	ESU38240.1	5741	g16380	i0	50.9	0.490740740740741	53	25	48.1	1	147	302	246	298	ESU38240.1 Variant-specific surface protein [Giardia intestinalis]	diamond	159	53.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31502126	31502126	PRJNA596870_P_NODE_31596_length_249_cov_0.875000_g31463_i0	PRJNA596870	31596	249	0.875	2.17875	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	52.4	1.6e-5	NR	KAG9394939.1	201153	g31463	i0	37.7	0.831325301204819	69	40	83.1	1	249	43	7	72	KAG9394939.1 Protein kinase domain [Carpediemonas membranifera]	diamond	207	52.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera

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