metadata: contig_metadata: 15 rows where bioproject = "PRJNA849822", tax_clade = "Metamonada" and tax

15 rows where bioproject = "PRJNA849822", 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
26651457	26651457	PRJNA849822_P_NODE_2581_length_1024_cov_2.986330_g2449_i0	PRJNA849822	2581	1024	2.98633	30.5800192	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52	0.00332	NR	ESU40613.1	5741	g2449	i0	30.6	0.5771484375	111	57	31.9	4	484	158	478	570	ESU40613.1 Variant-specific surface protein [Giardia intestinalis]	diamond	591	52	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
26674758	26674758	PRJNA849822_P_NODE_23801_length_297_cov_1.281250_g23627_i0	PRJNA849822	23801	297	1.28125	3.8053125	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	151	4.8e-42	NR	KAG9393145.1	201153	g23627	i0	63.8	4.2020202020202	105	32	100	1	1	297	154	258	KAG9393145.1 Mitogen activated protein kinase 13 [Carpediemonas membranifera]	diamond	1248	151	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
26706495	26706495	PRJNA849822_P_NODE_43221_length_242_cov_0.923077_g43047_i0	PRJNA849822	43221	242	0.923077	2.23384634	Hexamita inflata	28002	Fornicata	other_Eukaryota	73.6	5.19e-13	NR	CAK8768477.1	28002	g43047	i0	48.4	1.68595041322314	64	33	79.3	0	50	241	303	366	CAK8768477.1 HINF_082120 [Hexamita inflata]	diamond	408	73.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27623847	27623847	PRJNA849822_P_NODE_43624_length_238_cov_3.012121_g43450_i0	PRJNA849822	43624	238	3.012121	7.16884798	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	55.1	1.56e-6	NR	EFO64479.1	658858	g43450	i0	38.5	0.819327731092437	65	40	81.9	0	11	205	100	164	EFO64479.1 Topoisomerase I-related protein [Giardia lamblia P15]	diamond	195	55.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28231515	28231515	PRJNA849822_P_NODE_26946_length_281_cov_1.081731_g26772_i0	PRJNA849822	26946	281	1.081731	3.03966411	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	113	1.2200000000000002e-27	NR	XP_001705161.1	5741	g26772	i0	75	10.7188612099644	72	18	76.9	0	217	2	3	74	XP_001705161.1 Kinase, CMGC MAPK [Giardia intestinalis]	diamond	3012	114	0.991228070175439	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28768460	28768460	PRJNA849822_P_NODE_23427_length_299_cov_1.411504_g23253_i0	PRJNA849822	23427	299	1.411504	4.22039696	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	2.22e-30	NR	CAK8812229.1	28002	g23253	i0	60.2	2.85953177257525	98	39	98.3	0	2	295	778	875	CAK8812229.1 HINF_059731 [Hexamita inflata]	diamond	855	124	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29738765	29738765	PRJNA849822_P_NODE_14330_length_385_cov_1.881410_g14156_i0	PRJNA849822	14330	385	1.88141	7.2434285	Kipferlia bialata	797122	Fornicata	other_Eukaryota	92.4	3.67e-20	NR	GIQ80663.1	797122	g14156	i0	47.4	1.76883116883117	114	56	87.3	3	339	4	20	131	GIQ80663.1 glycoside hydrolase, family 25 [Kipferlia bialata]	diamond	681	92.4	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
29738814	29738814	PRJNA849822_P_NODE_41850_length_243_cov_1.511765_g41676_i0	PRJNA849822	41850	243	1.511765	3.67358895	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	47	0.00118	NR	XP_067760321.1	348837	g41676	i0	48.7	0.481481481481481	39	18	48.1	1	172	56	153	189	XP_067760321.1 Cysteine-rich membrane protein 2 [Spironucleus salmonicida]	diamond	117	47	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
29802165	29802165	PRJNA849822_P_NODE_43231_length_242_cov_0.923077_g43057_i0	PRJNA849822	43231	242	0.923077	2.23384634	Giardia intestinalis	5741	Fornicata	other_Eukaryota	48.9	2.56e-4	NR	XP_001704713.1	5741	g43057	i0	36.9	2.03305785123967	84	44	99.2	2	240	1	2926	3004	XP_001704713.1 IAD-1alpha dynein heavy chain [Giardia intestinalis]	diamond	492	48.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30695068	30695068	PRJNA849822_P_NODE_8613_length_515_cov_1.411765_g8441_i0	PRJNA849822	8613	515	1.411765	7.27058975	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	61.6	1.52e-7	NR	TNJ30320.1	5742	g8441	i0	47.8	0.745631067961165	67	29	38.4	4	272	469	33	94	TNJ30320.1 VSP protein [Giardia muris]	diamond	384	61.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
30971341	30971341	PRJNA849822_P_NODE_32534_length_256_cov_1.704918_g32360_i0	PRJNA849822	32534	256	1.704918	4.36459008	Giardia intestinalis assemblage B	1394984	Fornicata	other_Eukaryota	43.9	0.0166	NR	KWX14799.1	1394984	g32360	i0	47.4	0.9609375	38	20	44.5	0	176	63	117	154	KWX14799.1 Neurogenic locus Notch protein precursor/ EGF-like cyst protein [Giardia intestinalis assemblage B]	diamond	246	43.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31128839	31128839	PRJNA849822_P_NODE_37815_length_248_cov_0.891429_g37641_i0	PRJNA849822	37815	248	0.891429	2.21074392	Hexamita inflata	28002	Fornicata	other_Eukaryota	43.5	0.022	NR	CAK8752750.1	28002	g37641	i0	30	0.967741935483871	80	41	78.6	1	42	236	1682	1761	CAK8752750.1 HINF_005582 [Hexamita inflata]	diamond	240	43.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
31350625	31350625	PRJNA849822_P_NODE_31496_length_260_cov_1.668449_g31322_i0	PRJNA849822	31496	260	1.668449	4.3379674	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	50.8	6.32e-5	NR	GKT32966.1	2918883	g31322	i0	34.1	0.946153846153846	82	53	94.6	1	247	2	150	230	GKT32966.1 Importin subunit alpha like protein [Aduncisulcus paluster]	diamond	246	50.8	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
31445374	31445374	PRJNA849822_P_NODE_13256_length_403_cov_1.318182_g13082_i0	PRJNA849822	13256	403	1.318182	5.31227346	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	45.8	0.0158	NR	GKT36552.1	2918883	g13082	i0	47.5	0.297766749379653	40	21	29.8	0	398	279	416	455	GKT36552.1 cellulase (glycosyl hydrolase family 5) subfamily protein [Aduncisulcus paluster]	diamond	120	45.8	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
32204673	32204673	PRJNA849822_P_NODE_26698_length_282_cov_1.119617_g26524_i0	PRJNA849822	26698	282	1.119617	3.15731994	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	57	5.91e-7	NR	GKT16204.1	2918883	g26524	i0	35.1	1.03191489361702	97	54	97.9	3	6	281	281	373	GKT16204.1 hypothetical protein ADUPG1_010873 [Aduncisulcus paluster]	diamond	291	57	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);;