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

23 rows where analysis = "blastn", bioproject = "PRJNA698538" 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
1957207	1957207	PRJNA698538_S_NODE_12782_length_327_cov_4.618110_g12616_i0	PRJNA698538	12782	327	4.61811	15.1012197	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	604	1.8799999999999993e-168	NTclustered	gi\|386783716\|gb\|JX010510.1\|	79327	g12616	i0	100	1.95412844036697	327	0	100	0	1	327	1183	857	Schmidtea mediterranea clone Smed_00025_V2 glutathione S transferase-1 mRNA, complete cds	blastn	639	604	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
2459271	2459271	PRJNA698538_S_NODE_23182_length_267_cov_2.103093_g23016_i0	PRJNA698538	23182	267	2.103093	5.61525831	Schmidtea	55270	Platyhelminthes	Platyhelminthes	483	7.31e-132	NTclustered	gi\|4102590\|gb\|AF013152.1\|AF013152	50054	g23016	i0	99.251	98.2771535580524	267	2	100	0	1	267	378	112	Schmidtea polychroa 18S type I ribosomal RNA gene, complete sequence	blastn	26240	486	0.993827160493827	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea polychroa
2459280	2459280	PRJNA698538_S_NODE_3562_length_448_cov_5.410667_g3396_i0	PRJNA698538	3562	448	5.410667	24.23978816	Metazoa	33208	Platyhelminthes	Platyhelminthes	815	0	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g3396	i0	100	98.4375	441	0	98	0	1	441	450	10	Schistosoma japonicum unknown mRNA	blastn	44100	815	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
3232557	3232557	PRJNA698538_S_NODE_743_length_718_cov_3.003101_g593_i0	PRJNA698538	743	718	3.003101	21.56226518	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	1225	0	NTclustered	gi\|109631072\|gb\|DQ665992.1\|	79327	g593	i0	99.12	95.7994428969359	682	2	94	4	41	718	318	999	Schmidtea mediterranea 28S ribosomal RNA gene, partial sequence	blastn	68784	1225	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
5784689	5784689	PRJNA698538_S_NODE_11425_length_337_cov_7.431818_g11259_i0	PRJNA698538	11425	337	7.431818	25.04522666	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	623	5.369999999999999e-174	NTclustered	gi\|1667392\|gb\|U31084.1\|DMU31084	79327	g11259	i0	100	98.700296735905	337	0	100	0	1	337	619	955	Dugesia mediterranea 18S ribosomal RNA type I gene, complete sequence	blastn	33262	623	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
5784782	5784782	PRJNA698538_S_NODE_17045_length_300_cov_2.374449_g16879_i0	PRJNA698538	17045	300	2.374449	7.123347	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	544	3.78e-150	NTclustered	gi\|546143622\|ref\|NC_022448.1\|	79327	g16879	i0	99.333	8.40666666666667	300	2	100	0	1	300	22758	23057	Schmidtea mediterranea mitochondrion, complete genome	blastn	2522	544	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
7060043	7060043	PRJNA698538_S_NODE_28346_length_246_cov_0.930636_g28180_i0	PRJNA698538	28346	246	0.930636	2.28936456	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	324	4.26e-84	NTclustered	gi\|21308472\|gb\|AY067839.1\|	79327	g28180	i0	86.585	1	246	33	100	0	1	246	35	280	Schmidtea mediterranea clone HB.1.3e unknown mRNA sequence	blastn	246	324	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
7060062	7060062	PRJNA698538_S_NODE_29406_length_243_cov_0.905882_g29240_i0	PRJNA698538	29406	243	0.905882	2.20129326	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	444	3.09e-120	NTclustered	gi\|2330502764\|gb\|OL957297.1\|	79327	g29240	i0	99.588	1	243	1	100	0	1	243	704	462	Schmidtea mediterranea C-type lectin Lecg mRNA, complete cds	blastn	243	444	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
9609676	9609676	PRJNA698538_S_NODE_11988_length_333_cov_3.223077_g11822_i0	PRJNA698538	11988	333	3.223077	10.73284641	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	545	1.18e-150	NTclustered	gi\|24795663\|gb\|AY067023.1\|	79327	g11822	i0	95.796	2.00600600600601	333	12	99	1	1	331	333	1	Schmidtea mediterranea clone H.5.4b unknown mRNA sequence	blastn	668	545	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
9609967	9609967	PRJNA698538_S_NODE_3208_length_459_cov_42.326425_g3042_i0	PRJNA698538	3208	459	42.326425	194.27829075	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	846	0	NTclustered	gi\|546143622\|ref\|NC_022448.1\|	79327	g3042	i0	100	34.3681917211329	458	0	99	0	1	458	23015	23472	Schmidtea mediterranea mitochondrion, complete genome	blastn	15775	846	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12160523	12160523	PRJNA698538_S_NODE_20630_length_280_cov_1.980676_g20464_i0	PRJNA698538	20630	280	1.980676	5.5458928	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	497	2.76e-136	NTclustered	gi\|21308321\|gb\|AY067688.1\|	79327	g20464	i0	98.571	2.78928571428571	280	4	100	0	1	280	74	353	Schmidtea mediterranea clone HB.8.6b unknown mRNA sequence	blastn	781	497	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12160673	12160673	PRJNA698538_S_NODE_29410_length_243_cov_0.905882_g29244_i0	PRJNA698538	29410	243	0.905882	2.20129326	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	427	3.11e-115	NTclustered	gi\|386783762\|gb\|JX010533.1\|	79327	g29244	i0	98.354	1	243	4	100	0	1	243	956	714	Schmidtea mediterranea clone Smed_02142_V2 hypothetical protein mRNA, complete cds	blastn	243	427	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
14710401	14710401	PRJNA698538_S_NODE_25832_length_255_cov_1.010989_g25666_i0	PRJNA698538	25832	255	1.010989	2.57802195	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	429	9.159999999999999e-116	NTclustered	gi\|24796213\|gb\|AY066687.1\|	79327	g25666	i0	96.471	1	255	9	100	0	1	255	297	43	Schmidtea mediterranea clone H.7.7f unknown mRNA sequence	blastn	255	429	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
14710430	14710430	PRJNA698538_S_NODE_27932_length_247_cov_1.500000_g27766_i0	PRJNA698538	27932	247	1.5	3.705	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	442	1.1299999999999995e-119	NTclustered	gi\|24796399\|gb\|AY066907.1\|	79327	g27766	i0	98.785	1	247	3	100	0	1	247	354	108	Schmidtea mediterranea clone H.17.7f unknown mRNA sequence	blastn	247	442	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
15984007	15984007	PRJNA698538_S_NODE_17413_length_298_cov_1.644444_g17247_i0	PRJNA698538	17413	298	1.644444	4.90044312	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	520	6.319999999999999e-143	NTclustered	gi\|21307908\|gb\|AY067275.1\|	79327	g17247	i0	97.659	1.09731543624161	299	6	100	1	1	298	74	372	Schmidtea mediterranea clone H.31.12d unknown mRNA sequence	blastn	327	520	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
17259242	17259242	PRJNA698538_S_NODE_21314_length_277_cov_0.955882_g21148_i0	PRJNA698538	21314	277	0.955882	2.64779314	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	497	2.7199999999999993e-136	NTclustered	gi\|24795995\|gb\|AY066473.1\|	79327	g21148	i0	98.556	1	277	4	100	0	1	277	17	293	Schmidtea mediterranea clone HB.9.4g unknown mRNA sequence	blastn	277	497	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
19808417	19808417	PRJNA698538_S_NODE_30116_length_241_cov_0.916667_g29950_i0	PRJNA698538	30116	241	0.916667	2.20916747	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	446	8.519999999999999e-121	NTclustered	gi\|82470539\|gb\|DQ186986.1\|	79327	g29950	i0	100	2	241	0	100	0	1	241	2460	2700	Schmidtea mediterranea PIWI-like protein 2 (wi-2) mRNA, complete cds	blastn	482	446	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
19808446	19808446	PRJNA698538_S_NODE_4136_length_431_cov_2.558659_g3970_i0	PRJNA698538	4136	431	2.558659	11.02782029	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	736	0	NTclustered	gi\|21309401\|gb\|AY068772.1\|	79327	g3970	i0	96.984	1	431	13	100	0	1	431	7	437	Schmidtea mediterranea clone H.111.3a unknown mRNA sequence	blastn	431	736	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
22358404	22358404	PRJNA698538_S_NODE_12598_length_329_cov_1.011719_g12432_i0	PRJNA698538	12598	329	1.011719	3.32855551	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	540	5.42e-149	NTclustered	gi\|336044477\|gb\|JF827607.1\|	6161	g12432	i0	98.684	19.3617021276596	304	4	92	0	26	329	391	694	Dugesia japonica isolate DjSH 28S ribosomal RNA gene, partial sequence	blastn	6370	540	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
22358721	22358721	PRJNA698538_S_NODE_5718_length_399_cov_1.819018_g5552_i0	PRJNA698538	5718	399	1.819018	7.25788182	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	647	0	NTclustered	gi\|21307902\|gb\|AY067269.1\|	79327	g5552	i0	97.861	4.09774436090226	374	8	94	0	1	374	71	444	Schmidtea mediterranea clone HB.10.10a unknown mRNA sequence	blastn	1635	647	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
23634264	23634264	PRJNA698538_S_NODE_19919_length_284_cov_1.094787_g19753_i0	PRJNA698538	19919	284	1.094787	3.10919508	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	436	6.2e-118	NTclustered	gi\|21308487\|gb\|AY067854.1\|	79327	g19753	i0	93.333	1.00352112676056	285	18	100	1	1	284	348	64	Schmidtea mediterranea unknown mRNA sequence	blastn	285	436	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
23634537	23634537	PRJNA698538_S_NODE_8919_length_359_cov_5.402098_g8753_i0	PRJNA698538	8919	359	5.402098	19.39353182	Girardia tigrina	6162	Platyhelminthes	Platyhelminthes	586	7.539999999999998e-163	NTclustered	gi\|1699009\|gb\|U78718.1\|GTU78718	6162	g8753	i0	96.1	48.4122562674095	359	14	100	0	1	359	2095	2453	Dugesia tigrina 26S ribosomal RNA gene, partial sequence	blastn	17380	586	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Girardia	Girardia tigrina
24907876	24907876	PRJNA698538_S_NODE_4100_length_432_cov_1.635097_g3934_i0	PRJNA698538	4100	432	1.635097	7.06361904	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	660	0	NTclustered	gi\|62199111\|gb\|AY967481.1\|	79327	g3934	i0	99.18	30.3356481481481	366	3	85	0	67	432	16	381	Schmidtea mediterranea clone HE.1.06C mRNA sequence	blastn	13105	660	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea

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