RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA781427" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA781427 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
3312027 3312027 PRJNA781427_P_NODE_46563_length_332_cov_1.189189_g45680_i0 PRJNA781427 46563 332 1.189189 3.94810748 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 62.1 5.2e-5   NTclustered gi|1752368665|ref|XM_030988512.1| 7668 g45680 i0 88.679 1.44277108433735 53 3 15 3 129 178 3137 3189 PREDICTED: Strongylocentrotus purpuratus protein inscuteable homolog (LOC755119), transcript variant X3, mRNA blastn 479 62.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8413164 8413164 PRJNA781427_P_NODE_19407_length_553_cov_1.495833_g18544_i0 PRJNA781427 19407 553 1.495833 8.27195649 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 78.7 8.98e-10   NTclustered gi|1752394043|ref|XM_030999247.1| 7668 g18544 i0 94.231 1.58408679927667 52 2 9 1 78 129 3339 3289 PREDICTED: Strongylocentrotus purpuratus transmembrane protein 62 (LOC585983), transcript variant X2, mRNA blastn 876 78.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
8414255 8414255 PRJNA781427_P_NODE_61247_length_284_cov_1.094787_g60363_i0 PRJNA781427 61247 284 1.094787 3.10919508 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.026   NTclustered gi|1752407301|ref|XM_030975710.1| 7668 g60363 i0 100 0.197183098591549 28 0 10 0 9 36 10394 10421 PREDICTED: Strongylocentrotus purpuratus hydrocephalus-inducing protein homolog (LOC576233), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
10964407 10964407 PRJNA781427_P_NODE_27849_length_444_cov_1.598383_g26968_i0 PRJNA781427 27849 444 1.598383 7.09682052 Anneissia japonica 1529436 Echinodermata other_Eukaryota 715 0   NTclustered gi|1826640151|ref|XM_033252220.1| 1529436 g26968 i0 95.721 18.1869369369369 444 19 100 0 1 444 602 1045 PREDICTED: Anneissia japonica tigger transposable element-derived protein 4-like (LOC117109799), mRNA blastn 8075 715 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
12241479 12241479 PRJNA781427_P_NODE_88450_length_245_cov_0.895349_g87566_i0 PRJNA781427 88450 245 0.895349 2.19360505 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 93.5 1.3e-14   NTclustered gi|1752394272|ref|XM_011670039.2| 7668 g87566 i0 86.047 45.0285714285714 86 12 35 0 91 176 1856 1941 PREDICTED: Strongylocentrotus purpuratus proton-coupled folate transporter (LOC753373), transcript variant X1, mRNA blastn 11032 93.5 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
16063523 16063523 PRJNA781427_P_NODE_55653_length_300_cov_0.995595_g54770_i0 PRJNA781427 55653 300 0.995595 2.986785 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 65.8 3.58e-6   NTclustered gi|1752394043|ref|XM_030999247.1| 7668 g54770 i0 88.889 1.76333333333333 54 4 18 2 33 86 3288 3339 PREDICTED: Strongylocentrotus purpuratus transmembrane protein 62 (LOC585983), transcript variant X2, mRNA blastn 529 65.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
19887101 19887101 PRJNA781427_P_NODE_27476_length_448_cov_1.160000_g26595_i0 PRJNA781427 27476 448 1.16 5.1968 Asterias rubens 7604 Echinodermata other_Eukaryota 220 1.12e-52   NTclustered gi|1834251991|ref|XM_033790822.1| 7604 g26595 i0 84.932 21.6473214285714 219 32 49 1 195 412 315 97 PREDICTED: Asterias rubens NEDD8 (LOC117305973), mRNA blastn 9698 220 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
23713364 23713364 PRJNA781427_P_NODE_38039_length_371_cov_1.469799_g37157_i0 PRJNA781427 38039 371 1.469799 5.45295429 Anneissia japonica 1529436 Echinodermata other_Eukaryota 52.8 0.035   NTclustered gi|1826640117|ref|XR_004445594.1| 1529436 g37157 i0 100 0.150943396226415 28 0 8 0 148 175 335 308 PREDICTED: Anneissia japonica uncharacterized LOC117109783 (LOC117109783), transcript variant X1, ncRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
23714764 23714764 PRJNA781427_P_NODE_94239_length_242_cov_0.911243_g93355_i0 PRJNA781427 94239 242 0.911243 2.20520806 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 71.3 6.02e-8   NTclustered gi|1752394043|ref|XM_030999247.1| 7668 g93355 i0 97.561 2.71074380165289 41 1 17 0 7 47 3328 3288 PREDICTED: Strongylocentrotus purpuratus transmembrane protein 62 (LOC585983), transcript variant X2, mRNA blastn 656 71.3 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus

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