metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1192965" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1192965" 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
320578	320578	PRJNA1192965_P_NODE_5121_length_241_cov_0.916667_g5102_i0	PRJNA1192965	5121	241	0.916667	2.20916747	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	425	1.11e-114	NTclustered	gi\|21308717\|gb\|AY068084.1\|	79327	g5102	i0	98.34	1.57261410788382	241	4	100	0	1	241	415	175	Schmidtea mediterranea clone HB.22.6h unknown mRNA sequence	blastn	379	425	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
1595156	1595156	PRJNA1192965_P_NODE_1642_length_322_cov_1.554217_g1623_i0	PRJNA1192965	1642	322	1.554217	5.00457874	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	534	2.46e-147	NTclustered	gi\|21307903\|gb\|AY067270.1\|	79327	g1623	i0	95.342	1	322	15	100	0	1	322	422	101	Schmidtea mediterranea clone H.26.11d unknown mRNA sequence	blastn	322	534	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
1595171	1595171	PRJNA1192965_P_NODE_5302_length_229_cov_2.653846_g5283_i0	PRJNA1192965	5302	229	2.653846	6.07730734	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	342	1.08e-89	NTclustered	gi\|24795526\|gb\|AY066157.1\|	79327	g5283	i0	98.953	8.52401746724891	191	2	83	0	1	191	199	9	Schmidtea mediterranea clone H.6.10a(T3) unknown mRNA sequence	blastn	1952	342	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
2871274	2871274	PRJNA1192965_P_NODE_1143_length_370_cov_2.848485_g1124_i0	PRJNA1192965	1143	370	2.848485	10.5393945	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	569	7.85e-158	NTclustered	gi\|24795696\|gb\|AY066075.1\|	79327	g1124	i0	98.452	1.24054054054054	323	3	87	2	50	370	1	323	Schmidtea mediterranea clone H.117.10a unknown mRNA sequence	blastn	459	569	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
4147407	4147407	PRJNA1192965_P_NODE_1484_length_336_cov_1.057034_g1465_i0	PRJNA1192965	1484	336	1.057034	3.55163424	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	617	2.49e-172	NTclustered	gi\|24795864\|gb\|AY066277.1\|	79327	g1465	i0	99.702	2	336	1	100	0	1	336	390	725	Schmidtea mediterranea clone D6.contig unknown mRNA sequence	blastn	672	617	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
6698357	6698357	PRJNA1192965_P_NODE_1146_length_370_cov_2.043771_g1127_i0	PRJNA1192965	1146	370	2.043771	7.5619527	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	584	2.7999999999999987e-162	NTclustered	gi\|21307911\|gb\|AY067278.1\|	79327	g1127	i0	95.531	0.967567567567568	358	14	96	2	1	356	282	639	Schmidtea mediterranea clone hsp70 unknown mRNA sequence	blastn	358	584	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
6698371	6698371	PRJNA1192965_P_NODE_2986_length_260_cov_1.197861_g2967_i0	PRJNA1192965	2986	260	1.197861	3.1144386	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	464	2.57e-126	NTclustered	gi\|390098843\|gb\|JX070082.1\|	79327	g2967	i0	98.846	192.988461538462	260	3	100	0	1	260	311	52	Schmidtea mediterranea histone H3 mRNA, complete cds	blastn	50177	464	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
6698378	6698378	PRJNA1192965_P_NODE_4826_length_243_cov_0.905882_g4807_i0	PRJNA1192965	4826	243	0.905882	2.20129326	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	449	6.65e-122	NTclustered	gi\|62199237\|gb\|AY967607.1\|	79327	g4807	i0	100	1	243	0	100	0	1	243	569	327	Schmidtea mediterranea clone NBE.4.02A mRNA sequence	blastn	243	449	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
6698388	6698388	PRJNA1192965_P_NODE_926_length_402_cov_1.793313_g907_i0	PRJNA1192965	926	402	1.793313	7.20911826	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	540	6.75e-149	NTclustered	gi\|321149936\|gb\|GU591869.1\|	79327	g907	i0	100	0.72636815920398	292	0	73	0	1	292	105	396	Schmidtea mediterranea lectin-like protein mRNA, partial cds	blastn	292	540	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
9248420	9248420	PRJNA1192965_P_NODE_2148_length_292_cov_1.059361_g2129_i0	PRJNA1192965	2148	292	1.059361	3.09333412	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	540	4.74e-149	NTclustered	gi\|62199138\|gb\|AY967508.1\|	79327	g2129	i0	100	1.51712328767123	292	0	100	0	1	292	432	141	Schmidtea mediterranea clone HE.3.02F mRNA sequence	blastn	443	540	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
10524209	10524209	PRJNA1192965_P_NODE_3729_length_249_cov_0.875000_g3710_i0	PRJNA1192965	3729	249	0.875	2.17875	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	453	5.29e-123	NTclustered	gi\|820716148\|gb\|KM981949.1\|	79327	g3710	i0	99.598	1	249	0	100	1	1	249	44	291	Schmidtea mediterranea set nuclear proto-oncogene mRNA, partial cds	blastn	249	453	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
11799070	11799070	PRJNA1192965_P_NODE_1670_length_320_cov_1.643725_g1651_i0	PRJNA1192965	1670	320	1.643725	5.25992	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	586	6.65e-163	NTclustered	gi\|386783738\|gb\|JX010521.1\|	79327	g1651	i0	99.688	2	320	1	100	0	1	320	381	62	Schmidtea mediterranea clone Smed_00968_V2 Y box protein-1 mRNA, partial cds	blastn	640	586	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
11799100	11799100	PRJNA1192965_P_NODE_910_length_403_cov_3.024242_g891_i0	PRJNA1192965	910	403	3.024242	12.18769526	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	691	0	NTclustered	gi\|21308486\|gb\|AY067853.1\|	79327	g891	i0	96.774	1.83126550868486	403	13	100	0	1	403	541	139	Schmidtea mediterranea unknown mRNA sequence	blastn	738	691	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
13074091	13074091	PRJNA1192965_P_NODE_1291_length_355_cov_1.092199_g1272_i0	PRJNA1192965	1291	355	1.092199	3.87730645	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	604	2.059999999999999e-168	NTclustered	gi\|24795543\|gb\|AY066219.1\|	79327	g1272	i0	96.927	1.48169014084507	358	7	100	4	1	355	439	795	Schmidtea mediterranea clone H.9.7b unknown mRNA sequence	blastn	526	604	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
14349571	14349571	PRJNA1192965_P_NODE_3932_length_247_cov_1.770115_g3913_i0	PRJNA1192965	3932	247	1.770115	4.37218405	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	457	4.05e-124	NTclustered	gi\|847028351\|gb\|KT163648.1\|	79327	g3913	i0	100	2.96761133603239	247	0	100	0	1	247	841	595	Schmidtea mediterranea slc25a-30 (slc25a-30) mRNA, complete cds	blastn	733	457	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
15623290	15623290	PRJNA1192965_P_NODE_333_length_623_cov_17.965455_g315_i0	PRJNA1192965	333	623	17.965455	111.92478465	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	1151	0	NTclustered	gi\|753176482\|gb\|KM821047.2\|	79327	g315	i0	100	31.2760834670947	623	0	100	0	1	623	12866	13488	Schmidtea mediterranea mitochondrion, complete genome	blastn	19485	1151	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
18172114	18172114	PRJNA1192965_P_NODE_2055_length_297_cov_4.044643_g2036_i0	PRJNA1192965	2055	297	4.044643	12.01258971	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	538	1.74e-148	NTclustered	gi\|21308043\|gb\|AY067410.1\|	79327	g2036	i0	99.327	98.1784511784512	297	2	100	0	1	297	330	34	Schmidtea mediterranea clone H.18.11a unknown mRNA sequence	blastn	29159	538	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
18172133	18172133	PRJNA1192965_P_NODE_815_length_420_cov_2.345821_g796_i0	PRJNA1192965	815	420	2.345821	9.8524482	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	773	0	NTclustered	gi\|21308110\|gb\|AY067477.1\|	79327	g796	i0	99.762	2.06666666666667	420	1	100	0	1	420	501	82	Schmidtea mediterranea clone GST unknown mRNA sequence	blastn	868	773	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
19446527	19446527	PRJNA1192965_P_NODE_1536_length_331_cov_1.193798_g1517_i0	PRJNA1192965	1536	331	1.193798	3.95147138	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	250	1.03e-61	NTclustered	gi\|386783688\|gb\|JX010496.1\|	79327	g1517	i0	80.547	0.993957703927492	329	60	99	3	1	327	332	6	Schmidtea mediterranea clone Smed_17458_V2 GLI pathogenesis related-1 mRNA, partial cds	blastn	329	250	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
19446534	19446534	PRJNA1192965_P_NODE_2356_length_284_cov_1.317536_g2337_i0	PRJNA1192965	2356	284	1.317536	3.74180224	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	381	2.9399999999999995e-101	NTclustered	gi\|21308312\|gb\|AY067679.1\|	79327	g2337	i0	94.561	2.84859154929577	239	11	83	2	1	237	401	639	Schmidtea mediterranea clone H.103.11h unknown mRNA sequence	blastn	809	381	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
21997251	21997251	PRJNA1192965_P_NODE_898_length_405_cov_4.677711_g879_i0	PRJNA1192965	898	405	4.677711	18.94472955	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	693	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g879	i0	97.531	1	405	10	100	0	1	405	417	13	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	405	693	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
24546545	24546545	PRJNA1192965_P_NODE_1200_length_364_cov_1.587629_g1181_i0	PRJNA1192965	1200	364	1.587629	5.77896956	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	665	0	NTclustered	gi\|21308651\|gb\|AY068018.1\|	79327	g1181	i0	99.451	2.29395604395604	364	2	100	0	1	364	431	68	Schmidtea mediterranea clone H.58.9f(T3) unknown mRNA sequence	blastn	835	665	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
24546554	24546554	PRJNA1192965_P_NODE_2580_length_275_cov_1.163366_g2561_i0	PRJNA1192965	2580	275	1.163366	3.1992565	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	455	1.65e-123	NTclustered	gi\|62199196\|gb\|AY967566.1\|	79327	g2561	i0	96.958	0.956363636363636	263	8	96	0	13	275	456	194	Schmidtea mediterranea clone NBE.2.02B mRNA sequence	blastn	263	455	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
24546561	24546561	PRJNA1192965_P_NODE_4000_length_247_cov_0.885057_g3981_i0	PRJNA1192965	4000	247	0.885057	2.18609079	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	438	1.4699999999999995e-118	NTclustered	gi\|568219349\|gb\|KF730667.1\|	79327	g3981	i0	98.785	1	247	2	100	1	1	247	23	268	Schmidtea mediterranea calreticulin-2 mRNA, complete cds	blastn	247	438	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
24546562	24546562	PRJNA1192965_P_NODE_4160_length_246_cov_0.890173_g4141_i0	PRJNA1192965	4160	246	0.890173	2.18982558	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	449	6.74e-122	NTclustered	gi\|109631072\|gb\|DQ665992.1\|	79327	g4141	i0	99.595	100	247	0	100	1	1	246	1024	778	Schmidtea mediterranea 28S ribosomal RNA gene, partial sequence	blastn	24600	449	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);;