RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB3785 · 11 ✖

analysis 1

  • blastn · 11 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
1282936 1282936 PRJDB3785_S_NODE_102_length_2793_cov_30.232507_g91_i0 PRJDB3785 102 2793 30.232507 844.39392051 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1589 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g91 i0 85.09 65.671679197995 1556 232 95 0 65 1620 1556 1 Stenostomum sthenum mitochondrion, complete genome blastn 183421 1589 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
2558765 2558765 PRJDB3785_S_NODE_403_length_1218_cov_3.148845_g361_i0 PRJDB3785 403 1218 3.148845 38.3529321 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 813 0   NTclustered gi|926460135|gb|KR132212.1| 282301 g361 i0 80.519 85.1042692939245 1078 194 88 15 8 1077 1097 2166 Macrostomum lignano clone HSP90 heat shock protein 90 (hsp90) mRNA, complete cds blastn 103657 813 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
3531812 3531812 PRJDB3785_S_NODE_23603_length_166_cov_1.581197_g23450_i0 PRJDB3785 23603 166 1.581197 2.62478702 Stenostomum 39238 Platyhelminthes Platyhelminthes 268 1.27e-67   NTclustered gi|209968707|gb|FJ384870.1| 52061 g23450 i0 95.783 17 166 7 100 0 1 166 590 755 Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence blastn 2822 268 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum leucops
7661189 7661189 PRJDB3785_S_NODE_3067_length_443_cov_7.104061_g2915_i0 PRJDB3785 3067 443 7.104061 31.47099023 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 721 0   NTclustered gi|68479954|gb|DQ076149.1| 6182 g2915 i0 96.56 0.984198645598194 436 14 98 1 1 436 446 12 Schistosoma japonicum clone 1XA1 unknown mRNA blastn 436 721 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
8935712 8935712 PRJDB3785_S_NODE_1388_length_681_cov_6.599684_g1268_i0 PRJDB3785 1388 681 6.599684 44.94384804 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1140 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g1268 i0 96.916 2 681 20 100 1 1 681 1940 2619 Stenostomum sthenum mitochondrion, complete genome blastn 1362 1140 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
8935775 8935775 PRJDB3785_S_NODE_1968_length_564_cov_6.662136_g1825_i0 PRJDB3785 1968 564 6.662136 37.57444704 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 58.4 0.001   NTclustered gi|291196118|emb|FN263188.1| 282301 g1825 i0 97.059 0.817375886524823 34 1 6 0 526 559 1189 1156 Macrostomum lignano mRNA for beta actin-like 1 protein (act gene) blastn 461 58.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
8935894 8935894 PRJDB3785_S_NODE_528_length_1081_cov_15.614341_g475_i0 PRJDB3785 528 1081 15.614341 168.79102621 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 935 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g475 i0 82.468 2.27289546716004 1078 179 99 9 1 1073 4497 5569 Stenostomum sthenum mitochondrion, complete genome blastn 2457 935 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
12762407 12762407 PRJDB3785_S_NODE_26191_length_162_cov_1.539823_g26038_i0 PRJDB3785 26191 162 1.539823 2.49451326 Microplana cingulata 1816069 Platyhelminthes Platyhelminthes 104 3.67e-18   NTclustered gi|1021016759|gb|KU872669.1| 1816069 g26038 i0 87.234 33.6172839506173 94 8 57 4 1 92 535 444 Microplana cingulata isolate 1175U465 Elongation Factor 1-alpha (EF 1-alpha) gene, partial cds blastn 5446 104 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Geoplanidae Microplana Microplana cingulata
12762495 12762495 PRJDB3785_S_NODE_651_length_993_cov_106.955508_g584_i0 PRJDB3785 651 993 106.955508 1062.06819444 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1482 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g584 i0 94.496 21.8569989929507 963 49 97 3 7 967 8981 8021 Stenostomum sthenum mitochondrion, complete genome blastn 21704 1482 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
22960862 22960862 PRJDB3785_S_NODE_4939_length_341_cov_1.640411_g4786_i0 PRJDB3785 4939 341 1.640411 5.59380151 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|687154405|emb|LN001892.1| 99802 g4786 i0 96.97 0.290322580645161 33 1 10 0 168 200 8849 8817 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0001877 blastn 99 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
24234687 24234687 PRJDB3785_S_NODE_22280_length_169_cov_2.166667_g22127_i0 PRJDB3785 22280 169 2.166667 3.66166723 Echinococcus granulosus 6210 Platyhelminthes Platyhelminthes 102 1.38e-17   NTclustered gi|1373852346|ref|XM_024492550.1| 6210 g22127 i0 83.486 3.98224852071006 109 18 64 0 60 168 4903 4795 Echinococcus granulosus Myosin heavy chain, striated muscle (EGR_03301), partial mRNA blastn 673 102 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Taeniidae Echinococcus Echinococcus granulosus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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