metadata: contig_metadata: 11 rows where bioproject = "PRJNA1063685", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJNA1063685", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4006223	4006223	PRJNA1063685_S_NODE_60304_length_279_cov_2.087379_g59761_i0	PRJNA1063685	60304	279	2.087379	5.82378741	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	162	1.02e-45	NR	XP_009164529.1	6198	g59761	i0	80.6	56	93	18	100	0	279	1	8	100	XP_009164529.1 hypothetical protein T265_02106 [Opisthorchis viverrini]	diamond	15624	162	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
5282655	5282655	PRJNA1063685_S_NODE_71345_length_247_cov_2.333333_g70802_i0	PRJNA1063685	71345	247	2.333333	5.76333251	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	1.7e-32	NR	XP_018650791.1	6183	g70802	i0	69.1	36.3400809716599	81	25	98.4	0	246	4	491	571	XP_018650791.1 glycogen synthase [Schistosoma mansoni]	diamond	8976	130	0.992307692307692	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
20138444	20138444	PRJNA1063685_S_NODE_49776_length_320_cov_2.858300_g49233_i0	PRJNA1063685	49776	320	2.8583	9.14656	Opisthorchiidae	6196	Platyhelminthes	Platyhelminthes	575	1.44e-159	NTclustered	gi\|1632161475\|gb\|MK450524.1\|	79923	g49233	i0	99.369	98.803125	317	2	99	0	4	320	5197	5513	Clonorchis sinensis isolate CSB 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S ribosomal RNA intergenic spacer, partial sequence	blastn	31617	575	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
23132006	23132006	PRJNA1063685_S_NODE_52839_length_306_cov_8.480687_g52296_i0	PRJNA1063685	52839	306	8.480687	25.95090222	Stenostomum leucops	52061	Platyhelminthes	Platyhelminthes	374	5.359999999999998e-99	NTclustered	gi\|28273263\|gb\|AY157151.1\|	52061	g52296	i0	90.625	48.7058823529412	288	17	93	7	21	306	2180	2459	Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence	blastn	14904	374	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
26995312	26995312	PRJNA1063685_S_NODE_8902_length_646_cov_11.354276_g8396_i0	PRJNA1063685	8902	646	11.354276	73.34862296	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	167	8.74e-49	NR	KAH8861678.1	6182	g8396	i0	50.6	12.8730650154799	172	82	79.9	2	2	517	15	183	KAH8861678.1 Ras-related protein Rap-1A [Schistosoma japonicum]	diamond	8316	167	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27627700	27627700	PRJNA1063685_S_NODE_73124_length_243_cov_9.076471_g72581_i0	PRJNA1063685	73124	243	9.076471	22.05582453	root	1	Root_unresolved	Root_unresolved	58.5	9.83e-8	NR	PAA93844.1	282301	g72581	i0	44.9	4.20987654320988	49	27	60.5	0	65	211	423	471	PAA93844.1 hypothetical protein BOX15_Mlig026033g1, partial [Macrostomum lignano]	diamond	1023	58.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
28669589	28669589	PRJNA1063685_S_NODE_6207_length_701_cov_4.353503_g5733_i0	PRJNA1063685	6207	701	4.353503	30.51805603	Metazoa	33208	Platyhelminthes	Platyhelminthes	49.3	0.0033	NR	PAA72397.1	282301	g5733	i0	27.3	1.54493580599144	139	81	59.5	5	3	419	62	180	PAA72397.1 hypothetical protein BOX15_Mlig017771g3 [Macrostomum lignano]	diamond	1083	49.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
29837608	29837608	PRJNA1063685_S_NODE_62571_length_271_cov_4.787879_g62028_i0	PRJNA1063685	62571	271	4.787879	12.97515209	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	44.3	0.00347	NR	CDS42784.1	6211	g62028	i0	34.5	3.54243542435424	55	35	60.9	1	89	253	53	106	CDS42784.1 mitochondrial import inner membrane translocase [Echinococcus multilocularis]	diamond	960	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus multilocularis
30983555	30983555	PRJNA1063685_S_NODE_69294_length_252_cov_0.899441_g68751_i0	PRJNA1063685	69294	252	0.899441	2.26659132	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	110	6.210000000000001e-26	NR	VDL59387.1	6216	g68751	i0	64.2	10.6190476190476	81	29	96.4	0	6	248	282	362	VDL59387.1 unnamed protein product [Hymenolepis diminuta]	diamond	2676	110	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
31109606	31109606	PRJNA1063685_S_NODE_5555_length_717_cov_7.635093_g5099_i0	PRJNA1063685	5555	717	7.635093	54.74361681	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	100	2.99e-20	NR	THD27958.1	6192	g5099	i0	39.3	0.627615062761506	150	82	60.7	4	44	478	345	490	THD27958.1 Dual specificity protein phosphatase 10 [Fasciola hepatica]	diamond	450	100	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
32050333	32050333	PRJNA1063685_S_NODE_6838_length_686_cov_18.303426_g6352_i0	PRJNA1063685	6838	686	18.303426	125.56150236	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	227	8.549999999999999e-72	NR	VZI07411.1	99802	g6352	i0	59	12.3979591836735	183	74	80	1	623	75	4	185	VZI07411.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	8505	227	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei

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