RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA615351 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
9524353 9524353 PRJNA615351_P_NODE_78948_length_432_cov_2.921914_g64921_i0 PRJNA615351 78948 432 2.921914 12.62266848 Stylophora pistillata 50429 Cnidaria other_Eukaryota 52.8 0.042   NTclustered gi|1270064853|ref|XM_022939357.1| 50429 g64921 i0 94.286 0.162037037037037 35 0 8 2 134 167 5830 5797 PREDICTED: Stylophora pistillata uncharacterized LOC111333730 (LOC111333730), transcript variant X2, mRNA blastn 70 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
10078532 10078532 PRJNA615351_P_NODE_42708_length_849_cov_3.228501_g31855_i0 PRJNA615351 42708 849 3.228501 27.40997349 Metazoa 33208 Cnidaria other_Eukaryota 54.7 0.024   NTclustered gi|2917940731|emb|OZ237564.1| 6108 g31855 i0 96.875 0.071849234393404 32 1 4 0 690 721 7414733 7414702 Anemonia sulcata genome assembly, chromosome: 10 blastn 61 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
13349782 13349782 PRJNA615351_P_NODE_157471_length_180_cov_1.365517_g143371_i0 PRJNA615351 157471 180 1.365517 2.4579306 Anemonia sulcata 6108 Cnidaria other_Eukaryota 60.2 9.13e-5   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g143371 i0 91.111 6.71666666666667 45 3 24 1 2 45 19250964 19250920 Anemonia sulcata genome assembly, chromosome: 2 blastn 1209 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
13350158 13350158 PRJNA615351_P_NODE_92951_length_350_cov_2.746032_g78866_i0 PRJNA615351 92951 350 2.746032 9.611112 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 58.4 7.11e-4   NTclustered gi|2519010898|ref|XM_057456886.1| 13093 g78866 i0 100 5.76571428571429 31 0 9 0 127 157 2007 1977 PREDICTED: Hydractinia symbiolongicarpus inverted formin-2-like (LOC130654329), transcript variant X2, mRNA blastn 2018 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
14624419 14624419 PRJNA615351_P_NODE_131112_length_223_cov_4.957447_g117012_i0 PRJNA615351 131112 223 4.957447 11.05510681 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 52.8 0.02   NTclustered gi|1603802270|ref|XM_028549295.1| 151771 g117012 i0 100 0.125560538116592 28 0 13 0 98 125 1196 1169 PREDICTED: Dendronephthya gigantea insulin-like growth factor 1 receptor (LOC114527598), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
14624453 14624453 PRJNA615351_P_NODE_143752_length_200_cov_1.212121_g129652_i0 PRJNA615351 143752 200 1.212121 2.424242 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 52.8 0.017   NTclustered gi|1619644177|ref|XM_021045421.2| 2652724 g129652 i0 100 0.28 28 0 14 0 156 183 304 277 PREDICTED: Exaiptasia diaphana phosphatase and actin regulator 1 (LOC110239686), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
14624555 14624555 PRJNA615351_P_NODE_182552_length_154_cov_1.075630_g168452_i0 PRJNA615351 182552 154 1.07563 1.6564702 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 132 1.58e-26   NTclustered gi|2518990430|ref|XM_057446035.1| 13093 g168452 i0 82.55 1.93506493506494 149 26 97 0 1 149 258 406 PREDICTED: Hydractinia symbiolongicarpus V-type proton ATPase catalytic subunit A (LOC130636348), mRNA blastn 298 132 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
14624556 14624556 PRJNA615351_P_NODE_182712_length_154_cov_1.000000_g168612_i0 PRJNA615351 182712 154 1 1.54 Acropora digitifera 70779 Cnidaria other_Eukaryota 58.4 2.72e-4   NTclustered gi|1005427144|ref|XM_015895873.1| 70779 g168612 i0 100 3.16233766233766 31 0 20 0 29 59 614 584 PREDICTED: Acropora digitifera oncoprotein-induced transcript 3 protein-like (LOC107331300), transcript variant X1, mRNA blastn 487 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
20276417 20276417 PRJNA615351_P_NODE_170016_length_165_cov_2.115385_g155916_i0 PRJNA615351 170016 165 2.115385 3.49038525 Metazoa 33208 Cnidaria other_Eukaryota 63.9 6.37e-6   NTclustered gi|241911763|gb|FJ417069.1| 371550 g155916 i0 100 19.9818181818182 34 0 21 0 76 109 1660 1693 Palliatus indecorus isolate M0424 28S large subunit ribosomal RNA gene, partial sequence blastn 3297 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Sphaerosporidae Palliatus Palliatus indecorus
20997925 20997925 PRJNA615351_P_NODE_182417_length_154_cov_1.336134_g168317_i0 PRJNA615351 182417 154 1.336134 2.05764636 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 86.1 1.25e-12   NTclustered gi|2782837714|ref|XM_067054490.1| 252671 g168317 i0 93.103 39.5974025974026 58 4 38 0 75 132 2262 2319 PREDICTED: Clytia hemisphaerica myosin-10-like (LOC136797908), mRNA blastn 6098 86.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
20997927 20997927 PRJNA615351_P_NODE_182777_length_154_cov_0.857143_g168677_i0 PRJNA615351 182777 154 0.857143 1.32000022 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 122 9.499999999999999e-24   NTclustered gi|1778039570|ref|XM_031701382.1| 6105 g168677 i0 85.593 4.31168831168831 118 15 76 2 7 123 1023 907 PREDICTED: Actinia tenebrosa 26S proteasome regulatory subunit 7 (LOC116293885), mRNA blastn 664 122 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
22273115 22273115 PRJNA615351_P_NODE_86798_length_383_cov_2.652299_g72724_i0 PRJNA615351 86798 383 2.652299 10.15830517 Anemonia sulcata 6108 Cnidaria other_Eukaryota 56.5 0.003   NTclustered gi|2917940714|emb|OZ237561.1| 6108 g72724 i0 100 0.0783289817232376 30 0 8 0 264 293 9651359 9651388 Anemonia sulcata genome assembly, chromosome: 7 blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
23548075 23548075 PRJNA615351_P_NODE_136879_length_212_cov_1.367232_g122779_i0 PRJNA615351 136879 212 1.367232 2.89853184 Parvicapsula minibicornis 109801 Cnidaria other_Eukaryota 126 1.0799999999999999e-24   NTclustered gi|605060084|gb|KF874224.1| 109801 g122779 i0 86.842 55.6839622641509 114 13 54 2 99 212 233 344 Parvicapsula minibicornis 28S ribosomal RNA gene, partial sequence blastn 11805 126 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Parvicapsulidae Parvicapsula Parvicapsula minibicornis
23548454 23548454 PRJNA615351_P_NODE_80379_length_423_cov_2.649485_g64921_i1 PRJNA615351 80379 423 2.649485 11.20732155 Stylophora pistillata 50429 Cnidaria other_Eukaryota 52.8 0.041   NTclustered gi|1270064853|ref|XM_022939357.1| 50429 g64921 i1 94.286 0.16548463356974 35 0 8 2 266 299 5797 5830 PREDICTED: Stylophora pistillata uncharacterized LOC111333730 (LOC111333730), transcript variant X2, mRNA blastn 70 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata

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