metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA222400" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA222400" 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
4194298	4194298	PRJNA222400_P_NODE_44_length_1869_cov_176.039011_g34_i0	PRJNA222400	44	1869	176.039011	3290.16911559	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	1469	0	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g34	i0	94.544	23.242910647405	953	48	100	3	895	1845	8033	8983	Stenostomum sthenum mitochondrion, complete genome	blastn	43441	1469	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
4194335	4194335	PRJNA222400_P_NODE_7644_length_167_cov_1.322034_g7611_i0	PRJNA222400	7644	167	1.322034	2.20779678	Stenostomum leucops	52061	Platyhelminthes	Platyhelminthes	309	7.53e-80	NTclustered	gi\|28273263\|gb\|AY157151.1\|	52061	g7611	i0	100	70.3712574850299	167	0	100	0	1	167	2717	2883	Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence	blastn	11752	309	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
8020606	8020606	PRJNA222400_P_NODE_407_length_784_cov_22.402721_g382_i0	PRJNA222400	407	784	22.402721	175.63733264	Taenia pisiformis	85432	Platyhelminthes	Platyhelminthes	1426	0	NTclustered	gi\|288904134\|ref\|NC_013844.1\|	85432	g382	i0	100	84.3494897959184	772	0	98	0	1	772	8672	9443	Taenia pisiformis mitochondrion, complete genome	blastn	66130	1426	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia pisiformis
9295265	9295265	PRJNA222400_P_NODE_2968_length_274_cov_3.186667_g2935_i0	PRJNA222400	2968	274	3.186667	8.73146758	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	283	8.2e-72	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g2935	i0	85.556	1.68978102189781	270	39	99	0	1	270	11557	11826	Stenostomum sthenum mitochondrion, complete genome	blastn	463	283	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
9295326	9295326	PRJNA222400_P_NODE_8628_length_164_cov_1.347826_g8595_i0	PRJNA222400	8628	164	1.347826	2.21043464	Taenia solium	6204	Platyhelminthes	Platyhelminthes	239	9.79e-59	NTclustered	gi\|27464495\|gb\|AF529186.1\|	6204	g8595	i0	95.333	0.914634146341463	150	7	91	0	1	150	192	341	Taenia solium U6 snRNA and U5 snRNA genes, complete sequence	blastn	150	239	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia solium
10571254	10571254	PRJNA222400_P_NODE_3449_length_246_cov_1.319797_g3416_i0	PRJNA222400	3449	246	1.319797	3.24670062	Taenia solium	6204	Platyhelminthes	Platyhelminthes	283	7.239999999999999e-72	NTclustered	gi\|2235366277\|gb\|MW452936.1\|	6204	g3416	i0	88.889	1.84146341463415	234	21	94	4	16	246	297	66	Taenia solium putative vacuolar ATPase membrane sector associated protein (AAP8) mRNA, complete cds	blastn	453	283	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia solium
10571281	10571281	PRJNA222400_P_NODE_6129_length_181_cov_1.575758_g6096_i0	PRJNA222400	6129	181	1.575758	2.85212198	Taenia pisiformis	85432	Platyhelminthes	Platyhelminthes	335	1.36e-87	NTclustered	gi\|403397587\|gb\|JN990310.1\|	85432	g6096	i0	100	15.9226519337017	181	0	100	0	1	181	37	217	Taenia pisiformis isolate PZ2 cytochrome oxidase subunit 2 (COII) gene, partial cds; mitochondrial	blastn	2882	335	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia pisiformis
10571293	10571293	PRJNA222400_P_NODE_69_length_1572_cov_11.332239_g56_i0	PRJNA222400	69	1572	11.332239	178.14279708	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	1622	0	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g56	i0	85.476	70.7035623409669	1556	226	99	0	10	1565	1	1556	Stenostomum sthenum mitochondrion, complete genome	blastn	111146	1622	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
11259745	11259745	PRJNA222400_P_NODE_8889_length_163_cov_1.947368_g8856_i0	PRJNA222400	8889	163	1.947368	3.17420984	Stenostomum	39238	Platyhelminthes	Platyhelminthes	302	1.22e-77	NTclustered	gi\|209968707\|gb\|FJ384870.1\|	52061	g8856	i0	100	59.7423312883436	163	0	100	0	1	163	1004	842	Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence	blastn	9738	302	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
14396237	14396237	PRJNA222400_P_NODE_2412_length_317_cov_1.604478_g2379_i0	PRJNA222400	2412	317	1.604478	5.08619526	Taenia asiatica	60517	Platyhelminthes	Platyhelminthes	219	2.77e-52	NTclustered	gi\|145314258\|gb\|EF420459.1\|	60517	g2379	i0	80.065	0.965299684542587	306	51	94	9	9	306	26	329	Taenia asiatica clone TaHC9-C7 mRNA sequence	blastn	306	219	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia asiatica
14396265	14396265	PRJNA222400_P_NODE_4932_length_201_cov_1.026316_g4899_i0	PRJNA222400	4932	201	1.026316	2.06289516	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	204	4.5599999999999997e-48	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g4899	i0	85	0.995024875621891	200	30	99	0	2	201	15651	15452	Stenostomum sthenum mitochondrion, complete genome	blastn	200	204	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
15084090	15084090	PRJNA222400_P_NODE_5352_length_194_cov_0.917241_g5319_i0	PRJNA222400	5352	194	0.917241	1.77944754	Cyclophyllidea	6201	Platyhelminthes	Platyhelminthes	215	2.02e-51	NTclustered	gi\|1436048523\|gb\|MH699793.1\|	2126061	g5319	i0	98.361	64.8711340206186	122	2	63	0	73	194	1931	2052	Valipora minuta isolate DNA960 large subunit ribosomal RNA gene, partial sequence	blastn	12585	215	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Gryporhynchidae	Valipora	Valipora minuta
15670005	15670005	PRJNA222400_P_NODE_4353_length_213_cov_0.951220_g4320_i0	PRJNA222400	4353	213	0.95122	2.0260986	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	111	3.05e-20	NTclustered	gi\|1373863168\|ref\|XM_024497961.1\|	6210	g4320	i0	91.358	0.380281690140845	81	7	38	0	1	81	388	468	Echinococcus granulosus hypothetical protein (EGR_08712), partial mRNA	blastn	81	111	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
15670028	15670028	PRJNA222400_P_NODE_593_length_667_cov_3.131068_g563_i0	PRJNA222400	593	667	3.131068	20.88422356	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	1092	0	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g563	i0	96.252	2	667	24	100	1	1	667	1950	2615	Stenostomum sthenum mitochondrion, complete genome	blastn	1334	1092	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
16944455	16944455	PRJNA222400_P_NODE_194_length_1067_cov_8.120825_g178_i0	PRJNA222400	194	1067	8.120825	86.64920275	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	941	0	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g178	i0	82.649	1.28022492970947	1072	176	100	9	1	1067	5563	4497	Stenostomum sthenum mitochondrion, complete genome	blastn	1366	941	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
16944485	16944485	PRJNA222400_P_NODE_4094_length_220_cov_2.263158_g4061_i0	PRJNA222400	4094	220	2.263158	4.9789476	Taenia pisiformis	85432	Platyhelminthes	Platyhelminthes	388	1.31e-103	NTclustered	gi\|380703135\|gb\|JQ609339.1\|	85432	g4061	i0	98.643	7.11363636363636	221	0	100	2	1	220	932	1150	Taenia pisiformis isolate Linyi 18S ribosomal RNA gene, complete sequence	blastn	1565	388	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia pisiformis
16944491	16944491	PRJNA222400_P_NODE_4694_length_205_cov_2.346154_g4661_i0	PRJNA222400	4694	205	2.346154	4.8096157	Taenia pisiformis	85432	Platyhelminthes	Platyhelminthes	379	7.229999999999999e-101	NTclustered	gi\|288904134\|ref\|NC_013844.1\|	85432	g4661	i0	100	72.419512195122	205	0	100	0	1	205	10607	10811	Taenia pisiformis mitochondrion, complete genome	blastn	14846	379	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia pisiformis
17634133	17634133	PRJNA222400_P_NODE_3534_length_241_cov_1.375000_g3501_i0	PRJNA222400	3534	241	1.375	3.31375	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	76.8	1.29e-9	NTclustered	gi\|124784678\|gb\|EF201959.1\|	60517	g3501	i0	97.727	3.35269709543568	44	1	18	0	1	44	371	414	Taenia asiatica clone HC1-G8 polyubiquitin mRNA, partial cds	blastn	808	76.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia asiatica
18218871	18218871	PRJNA222400_P_NODE_4835_length_202_cov_1.686275_g4802_i0	PRJNA222400	4835	202	1.686275	3.4062755	Taenia pisiformis	85432	Platyhelminthes	Platyhelminthes	374	3.3e-99	NTclustered	gi\|288904134\|ref\|NC_013844.1\|	85432	g4802	i0	100	99.5148514851485	202	0	100	0	1	202	9795	9996	Taenia pisiformis mitochondrion, complete genome	blastn	20102	374	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia pisiformis
20768744	20768744	PRJNA222400_P_NODE_6117_length_182_cov_0.939850_g6084_i0	PRJNA222400	6117	182	0.93985	1.710527	Taenia asiatica	60517	Platyhelminthes	Platyhelminthes	326	8.260000000000001e-85	NTclustered	gi\|1089667335\|dbj\|AP017670.1\|	60517	g6084	i0	98.901	4	182	2	100	0	1	182	1125	944	Taenia asiatica mitochondrial DNA, complete genome	blastn	728	326	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia asiatica
20768757	20768757	PRJNA222400_P_NODE_757_length_598_cov_1.681239_g726_i0	PRJNA222400	757	598	1.681239	10.05380922	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	102	5.79e-17	NTclustered	gi\|1373852346\|ref\|XM_024492550.1\|	6210	g726	i0	83.486	1.94147157190635	109	18	18	0	425	533	4903	4795	Echinococcus granulosus Myosin heavy chain, striated muscle (EGR_03301), partial mRNA	blastn	1161	102	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
23319299	23319299	PRJNA222400_P_NODE_7079_length_169_cov_1.733333_g7046_i0	PRJNA222400	7079	169	1.733333	2.92933277	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	139	1.05e-28	NTclustered	gi\|3386330\|gb\|L08894.1\|ECCMDH	6210	g7046	i0	81.657	1	169	29	99	2	1	167	929	1097	Echinococcus granulosus malate dehydrogenase (MDH) mRNA, complete cds	blastn	169	139	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
24593399	24593399	PRJNA222400_P_NODE_1500_length_419_cov_1.348649_g1467_i0	PRJNA222400	1500	419	1.348649	5.65083931	Hydatigera taeniaeformis	6205	Platyhelminthes	Platyhelminthes	313	1.68e-80	NTclustered	gi\|295901295\|dbj\|AB531990.1\|	6205	g1467	i0	82.955	0.840095465393795	352	54	83	3	1	346	405	54	Taenia taeniaeformis mRNA for immunogenic protein, complete cds	blastn	352	313	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Hydatigera	Hydatigera taeniaeformis

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