metadata: contig_metadata: 11 rows where bioproject = "PRJNA752572", tax_clade = "Metamonada" and tax

11 rows where bioproject = "PRJNA752572", 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
27179092	27179092	PRJNA752572_P_NODE_109362_length_258_cov_1.448430_g108855_i0	PRJNA752572	109362	258	1.44843	3.7369494	Giardia intestinalis	5741	Fornicata	other_Eukaryota	53.9	5.11e-6	NR	XP_001709528.2	5741	g108855	i0	40.7	3.76744186046512	81	38	91.9	3	9	245	589	661	XP_001709528.2 VSP [Giardia intestinalis]	diamond	972	53.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
27473586	27473586	PRJNA752572_P_NODE_10503_length_798_cov_3.821756_g10155_i0	PRJNA752572	10503	798	3.821756	30.49761288	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	5.88e-31	NR	CAK8746233.1	28002	g10155	i0	36.4	1.8796992481203	250	147	93.6	2	792	46	126	364	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	1500	130	0.992307692307692	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27558194	27558194	PRJNA752572_P_NODE_53024_length_375_cov_3.455882_g52518_i0	PRJNA752572	53024	375	3.455882	12.9595575	Hexamita inflata	28002	Fornicata	other_Eukaryota	108	4.15e-25	NR	CAK8746233.1	28002	g52518	i0	45.2	1.84	115	63	92	0	28	372	1	115	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	690	108	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29074129	29074129	PRJNA752572_P_NODE_108188_length_259_cov_2.281250_g107681_i0	PRJNA752572	108188	259	2.28125	5.9084375	Giardia intestinalis	5741	Fornicata	other_Eukaryota	55.5	4.41e-7	NR	AAA19317.1	5741	g107681	i0	44.2	0.498069498069498	43	24	49.8	0	2	130	45	87	AAA19317.1 putative surface antigen, partial [Giardia intestinalis]	diamond	129	55.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29168858	29168858	PRJNA752572_P_NODE_221709_length_178_cov_1.398601_g221202_i0	PRJNA752572	221709	178	1.398601	2.48950978	Giardia intestinalis	5741	Fornicata	other_Eukaryota	42.4	0.0212	NR	ESU40358.1	5741	g221202	i0	39.3	0.943820224719101	56	32	94.4	1	175	8	12	65	ESU40358.1 Variant-specific surface protein [Giardia intestinalis]	diamond	168	42.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30242544	30242544	PRJNA752572_P_NODE_230532_length_174_cov_2.035971_g230025_i0	PRJNA752572	230532	174	2.035971	3.54258954	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	70.9	1.74e-12	NR	GKT37275.1	2918883	g230025	i0	61.4	0.982758620689655	57	22	98.3	0	3	173	105	161	GKT37275.1 Glycine--tRNA ligase, mitochondrial 1 [Aduncisulcus paluster]	diamond	171	70.9	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
31411738	31411738	PRJNA752572_P_NODE_118416_length_247_cov_1.933962_g117909_i0	PRJNA752572	118416	247	1.933962	4.77688614	Giardia intestinalis	5741	Fornicata	other_Eukaryota	45.1	0.00602	NR	ESU41386.1	5741	g117909	i0	42.9	0.595141700404858	49	22	52.2	1	104	232	530	578	ESU41386.1 Variant-specific surface protein [Giardia intestinalis]	diamond	147	45.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32044377	32044377	PRJNA752572_P_NODE_65998_length_335_cov_2.983333_g65491_i0	PRJNA752572	65998	335	2.983333	9.99416555	Giardia intestinalis	5741	Fornicata	other_Eukaryota	51.2	1.12e-4	NR	XP_001708419.2	5741	g65491	i0	39.1	1.02985074626866	115	57	92.2	5	3	311	407	520	XP_001708419.2 High cysteine membrane protein Group 6 [Giardia intestinalis]	diamond	345	51.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32244430	32244430	PRJNA752572_P_NODE_153718_length_216_cov_1.104972_g153211_i0	PRJNA752572	153718	216	1.104972	2.38673952	Giardia	5740	Fornicata	other_Eukaryota	43.9	0.0107	NR	ESU40688.1	5741	g153211	i0	41.4	3.73611111111111	70	35	91.7	3	19	216	671	738	ESU40688.1 Variant-specific surface protein [Giardia intestinalis]	diamond	807	43.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32307689	32307689	PRJNA752572_P_NODE_188299_length_194_cov_1.987421_g187792_i0	PRJNA752572	188299	194	1.987421	3.85559674	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	72.4	6.83e-13	NR	CAK8748659.1	28002	g187792	i0	51.6	6.83505154639175	64	31	99	0	1	192	1863	1926	CAK8748659.1 HINF_038578 [Hexamita inflata]	diamond	1326	72.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
32802496	32802496	PRJNA752572_P_NODE_3400_length_1211_cov_7.802721_g3217_i0	PRJNA752572	3400	1211	7.802721	94.49095131	Hexamita inflata	28002	Fornicata	other_Eukaryota	271	3.8999999999999998e-84	NR	CAK8746233.1	28002	g3217	i0	40.8	0.941370767960363	380	213	93.9	2	1171	35	1	369	CAK8746233.1 HINF_020048 [Hexamita inflata]	diamond	1140	271	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata

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