metadata: contig_metadata: 23 rows where bioproject = "PRJNA493828", tax_clade = "Opisthokonta" and tax

23 rows where bioproject = "PRJNA493828", 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
474526	474526	PRJNA493828_P_NODE_14441_length_310_cov_5.776371_g14022_i0	PRJNA493828	14441	310	5.776371	17.9067501	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	73.1	2.22e-8	NTclustered	gi\|393794738\|dbj\|AK389162.1\|	6161	g14022	i0	100	0.125806451612903	39	0	13	0	235	273	1017	979	Dugesia japonica cDNA, clone: Dj_aH_323_M14.full, full-insert sequence, expressed in adult head	blastn	39	73.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
1749912	1749912	PRJNA493828_P_NODE_48462_length_197_cov_5.620968_g48043_i0	PRJNA493828	48462	197	5.620968	11.07330696	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	359	8.98e-95	NTclustered	gi\|4102591\|gb\|AF013153.1\|	6161	g48043	i0	100	98.8020304568528	194	0	98	0	1	194	1600	1407	Dugesia japonica 18S type I ribosomal RNA gene, complete sequence	blastn	19464	359	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
1749942	1749942	PRJNA493828_P_NODE_6182_length_444_cov_20.102426_g5784_i0	PRJNA493828	6182	444	20.102426	89.25477144	Marionfyfea adventor	3040208	Platyhelminthes	Platyhelminthes	662	0	NTclustered	gi\|2893358306\|gb\|PV014941.1\|	3040208	g5784	i0	94.064	38.5990990990991	438	22	98	4	1	436	691	1126	Marionfyfea adventor isolate MarionAdv_2022-07 large subunit ribosomal RNA gene, partial sequence	blastn	17138	662	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Geoplanidae	Marionfyfea	Marionfyfea adventor
3025764	3025764	PRJNA493828_P_NODE_3943_length_545_cov_8.148305_g3565_i0	PRJNA493828	3943	545	8.148305	44.40826225	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	898	0	NTclustered	gi\|1667392\|gb\|U31084.1\|DMU31084	79327	g3565	i0	95.528	100.757798165138	559	10	100	5	1	545	13	570	Dugesia mediterranea 18S ribosomal RNA type I gene, complete sequence	blastn	54913	898	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
5578616	5578616	PRJNA493828_P_NODE_885_length_1116_cov_5.047939_g651_i0	PRJNA493828	885	1116	5.047939	56.33499924	Provortex psammophilus	66825	Platyhelminthes	Platyhelminthes	117	3.97e-21	NTclustered	gi\|3098112\|gb\|AF022754.1\|AF022754	66825	g651	i0	85.345	11.676523297491	116	13	10	4	979	1093	133	245	Provortex psammophilus 28S ribosomal RNA gene, partial sequence	blastn	13031	117	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Provorticidae	Provortex	Provortex psammophilus
8127830	8127830	PRJNA493828_P_NODE_34187_length_248_cov_1.325714_g33768_i0	PRJNA493828	34187	248	1.325714	3.28777072	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	327	3.33e-85	NTclustered	gi\|339759461\|dbj\|AB576209.1\|	6161	g33768	i0	95.588	4.39112903225806	204	9	82	0	44	247	1	204	Dugesia japonica DjhistonH2B mRNA for histone H2B, partial cds	blastn	1089	327	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
9402998	9402998	PRJNA493828_P_NODE_5848_length_456_cov_4.438642_g5456_i0	PRJNA493828	5848	456	4.438642	20.24020752	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	241	8.790000000000001e-59	NTclustered	gi\|2436991639\|gb\|OQ348021.1\|	6161	g5456	i0	80.635	0.75219298245614	315	57	69	4	114	426	715	403	Dugesia japonica WTAP mRNA, complete cds	blastn	343	241	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
10034860	10034860	PRJNA493828_P_NODE_15948_length_310_cov_2.611814_g15529_i0	PRJNA493828	15948	310	2.611814	8.0966234	Dugesia	6160	Platyhelminthes	Platyhelminthes	198	3.5199999999999995e-46	NTclustered	gi\|1900775492\|gb\|MT994165.1\|	2771395	g15529	i0	91.156	41.7225806451613	147	11	47	2	165	310	1	146	Dugesia sp. ML-2020 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	12934	198	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia sp. ML-2020
11953523	11953523	PRJNA493828_P_NODE_3510_length_574_cov_3.666667_g3145_i0	PRJNA493828	3510	574	3.666667	21.04666858	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	178	8.959999999999999e-40	NTclustered	gi\|7470\|emb\|X01551.1\|	6161	g3145	i0	93.388	0.210801393728223	121	7	21	1	326	446	120	1	Dugesia japonica (Furuyu) 5S ribosomal RNA	blastn	121	178	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
11953703	11953703	PRJNA493828_P_NODE_5070_length_487_cov_6.053140_g4680_i0	PRJNA493828	5070	487	6.05314	29.4787918	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	898	0	NTclustered	gi\|546143622\|ref\|NC_022448.1\|	79327	g4680	i0	100	25.5770020533881	486	0	99	0	2	487	22919	23404	Schmidtea mediterranea mitochondrion, complete genome	blastn	12456	898	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
13228807	13228807	PRJNA493828_P_NODE_47331_length_203_cov_4.484615_g46912_i0	PRJNA493828	47331	203	4.484615	9.10376845	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	374	3.319999999999999e-99	NTclustered	gi\|1667392\|gb\|U31084.1\|DMU31084	79327	g46912	i0	100	99.7487684729064	202	0	99	0	1	202	1435	1636	Dugesia mediterranea 18S ribosomal RNA type I gene, complete sequence	blastn	20249	374	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
14503329	14503329	PRJNA493828_P_NODE_20652_length_285_cov_1.863208_g20233_i0	PRJNA493828	20652	285	1.863208	5.3101428	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	132	3.29e-26	NTclustered	gi\|687155131\|emb\|LN004666.1\|	99802	g20233	i0	96.25	49.8280701754386	80	3	28	0	85	164	4409	4330	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0004623	blastn	14201	132	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
17051858	17051858	PRJNA493828_P_NODE_18034_length_296_cov_2.793722_g17615_i0	PRJNA493828	18034	296	2.793722	8.26941712	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	283	8.949999999999999e-72	NTclustered	gi\|62199298\|gb\|AY967668.1\|	79327	g17615	i0	84.286	2.29054054054054	280	34	91	3	5	274	477	756	Schmidtea mediterranea clone NBE.7.02A mRNA sequence	blastn	678	283	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
18326108	18326108	PRJNA493828_P_NODE_13355_length_319_cov_9.967480_g12936_i0	PRJNA493828	13355	319	9.96748	31.7962612	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	477	4.159999999999998e-130	NTclustered	gi\|393794550\|dbj\|AK388974.1\|	6161	g12936	i0	94.006	46.4858934169279	317	16	99	3	4	319	617	931	Dugesia japonica cDNA, clone: Dj_aH_000_05707HH.full, full-insert sequence, expressed in adult head	blastn	14829	477	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
19600618	19600618	PRJNA493828_P_NODE_29036_length_258_cov_4.859459_g28617_i0	PRJNA493828	29036	258	4.859459	12.53740422	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	464	2.5499999999999994e-126	NTclustered	gi\|109631072\|gb\|DQ665992.1\|	79327	g28617	i0	99.222	92.9612403100775	257	2	99	0	2	258	533	277	Schmidtea mediterranea 28S ribosomal RNA gene, partial sequence	blastn	23984	464	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
20876214	20876214	PRJNA493828_P_NODE_11317_length_342_cov_7.204461_g10898_i0	PRJNA493828	11317	342	7.204461	24.63925662	Marionfyfea adventor	3040208	Platyhelminthes	Platyhelminthes	540	5.66e-149	NTclustered	gi\|2893358306\|gb\|PV014941.1\|	3040208	g10898	i0	95.058	77.7017543859649	344	15	100	2	1	342	444	101	Marionfyfea adventor isolate MarionAdv_2022-07 large subunit ribosomal RNA gene, partial sequence	blastn	26574	540	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Geoplanidae	Marionfyfea	Marionfyfea adventor
27408827	27408827	PRJNA493828_P_NODE_34003_length_248_cov_2.371429_g33584_i0	PRJNA493828	34003	248	2.371429	5.88114392	Metazoa	33208	Platyhelminthes	Platyhelminthes	103	2.1399999999999994e-23	NR	THD19534.1	6192	g33584	i0	66.2	8.69758064516129	77	25	93.1	1	231	1	743	818	THD19534.1 KRAB-A domain-containing protein [Fasciola hepatica]	diamond	2157	103	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
28008652	28008652	PRJNA493828_P_NODE_43965_length_226_cov_5.150327_g43546_i0	PRJNA493828	43965	226	5.150327	11.63973902	Trematoda	6178	Platyhelminthes	Platyhelminthes	57.4	2.11e-7	NR	VDP31318.1	6186	g43546	i0	67.5	1.5929203539823	40	13	53.1	0	121	2	1	40	VDP31318.1 unnamed protein product [Schistosoma curassoni]	diamond	360	57.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma curassoni
28040122	28040122	PRJNA493828_P_NODE_39545_length_241_cov_1.494048_g39126_i0	PRJNA493828	39545	241	1.494048	3.60065568	Paragonimus	34503	Platyhelminthes	Platyhelminthes	58.5	9.83e-8	NR	KAF7255426.1	59628	g39126	i0	58.7	2.17842323651452	63	23	74.7	2	61	240	229	291	KAF7255426.1 hypothetical protein EG68_07515 [Paragonimus skrjabini miyazakii]	diamond	525	58.9	0.99320882852292	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus skrjabini miyazakii
29003709	29003709	PRJNA493828_P_NODE_36328_length_245_cov_1.773256_g35909_i0	PRJNA493828	36328	245	1.773256	4.3444772	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	92.4	1.02e-21	NR	BAL40993.1	6161	g35909	i0	77.4	0.759183673469388	62	14	75.9	0	25	210	85	146	BAL40993.1 NADH dehydrogenase subunit 6, partial [Dugesia japonica]	diamond	186	92.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
29192824	29192824	PRJNA493828_P_NODE_20029_length_287_cov_2.878505_g19610_i0	PRJNA493828	20029	287	2.878505	8.26130935	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	92	6.38e-20	NR	PAA80599.1	282301	g19610	i0	58.1	5.09059233449477	62	26	64.8	0	9	194	1	62	PAA80599.1 hypothetical protein BOX15_Mlig022332g1 [Macrostomum lignano]	diamond	1461	92	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30266793	30266793	PRJNA493828_P_NODE_41472_length_235_cov_3.222222_g41053_i0	PRJNA493828	41472	235	3.222222	7.5722217	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	102	2.1e-25	NR	ADW66114.1	79327	g41053	i0	55.1	0.995744680851064	78	35	99.6	0	2	235	34	111	ADW66114.1 pol polyprotein, partial [Schmidtea mediterranea]	diamond	234	102	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
30456397	30456397	PRJNA493828_P_NODE_34113_length_248_cov_1.645714_g33694_i0	PRJNA493828	34113	248	1.645714	4.08137072	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	53.9	4.5e-6	NR	KAL3316647.1	1844966	g33694	i0	39.5	1.04032258064516	86	46	99.2	2	1	246	94	177	KAL3316647.1 DNA polymerase epsilon subunit 2 [Cichlidogyrus casuarinus]	diamond	258	53.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus

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