metadata: contig_metadata: 8 rows where bioproject = "PRJNA666695", tax_clade = "Metamonada" and tax

8 rows where bioproject = "PRJNA666695", tax_clade = "Metamonada" and tax_phylum = "Fornicata"

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
27315036	27315036	PRJNA666695_S_NODE_13283_length_487_cov_1.887892_g12200_i0	PRJNA666695	13283	487	1.887892	9.19403404	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.7	9.07e-18	NR	TNJ29478.1	5742	g12200	i0	56.7	2.02669404517454	67	29	41.3	0	2	202	119	185	TNJ29478.1 ADP-ribosylation factor 1 [Giardia muris]	diamond	987	86.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
27429386	27429386	PRJNA666695_S_NODE_113823_length_206_cov_2.230303_g112729_i0	PRJNA666695	113823	206	2.230303	4.59442418	Hexamita inflata	28002	Fornicata	other_Eukaryota	49.3	8.85e-5	NR	CAK8785446.1	28002	g112729	i0	34.8	1.82038834951456	66	41	93.2	1	7	198	62	127	CAK8785446.1 HINF_046843 [Hexamita inflata]	diamond	375	49.3	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27871102	27871102	PRJNA666695_S_NODE_180465_length_158_cov_2.521368_g179371_i0	PRJNA666695	180465	158	2.521368	3.98376144	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	50.8	1.62e-5	NR	KAG9394508.1	201153	g179371	i0	56.8	0.70253164556962	37	16	70.3	0	32	142	657	693	KAG9394508.1 Pro-kumamolisin, activation domain [Carpediemonas membranifera]	diamond	111	50.8	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
28514836	28514836	PRJNA666695_S_NODE_84687_length_237_cov_1.780612_g83593_i0	PRJNA666695	84687	237	1.780612	4.22005044	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.4	6.2e-11	NR	TNJ29833.1	5742	g83593	i0	47.4	2.9746835443038	78	38	97.5	2	233	3	286	361	TNJ29833.1 actin [Giardia muris]	diamond	705	67.8	0.994100294985251	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
29165925	29165925	PRJNA666695_S_NODE_135629_length_188_cov_1.653061_g134535_i0	PRJNA666695	135629	188	1.653061	3.10775468	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	55.8	4.22e-7	NR	KAG9389986.1	201153	g134535	i0	40	0.957446808510638	60	36	95.7	0	5	184	192	251	KAG9389986.1 putative enzymatic polyprotein [Carpediemonas membranifera]	diamond	180	55.8	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
29197416	29197416	PRJNA666695_S_NODE_104089_length_215_cov_3.471264_g102995_i0	PRJNA666695	104089	215	3.471264	7.4632176	Hexamita inflata	28002	Fornicata	other_Eukaryota	59.3	1.13e-8	NR	CAK8758626.1	28002	g102995	i0	45	0.837209302325581	60	30	79.5	1	214	44	105	164	CAK8758626.1 HINF_095475 [Hexamita inflata]	diamond	180	59.3	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29714229	29714229	PRJNA666695_S_NODE_64110_length_266_cov_2.453333_g63016_i0	PRJNA666695	64110	266	2.453333	6.52586578	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	102	2.6199999999999998e-23	NR	KAG9392729.1	201153	g63016	i0	52.3	3.03383458646617	88	42	99.2	0	266	3	96	183	KAG9392729.1 hypothetical protein J8273_5868 [Carpediemonas membranifera]	diamond	807	102	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32073032	32073032	PRJNA666695_S_NODE_146838_length_180_cov_1.323741_g145744_i0	PRJNA666695	146838	180	1.323741	2.3827338	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	73.6	2.13e-13	NR	GKT28405.1	2918883	g145744	i0	62.1	1.93333333333333	58	22	96.7	0	179	6	565	622	GKT28405.1 hypothetical protein ADUPG1_000628, partial [Aduncisulcus paluster]	diamond	348	73.6	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster

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