RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA938397" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA938397 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
2189113 2189113 PRJNA938397_S_NODE_45742_length_162_cov_3.208000_g45501_i0 PRJNA938397 45742 162 3.208 5.19696 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 159 7.72e-35   NTclustered gi|2519013454|ref|XM_057458135.1| 13093 g45501 i0 85.906 5.1358024691358 149 21 92 0 10 158 394 246 PREDICTED: Hydractinia symbiolongicarpus RING-box protein 1 (LOC130655383), mRNA blastn 832 159 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
4740805 4740805 PRJNA938397_S_NODE_14724_length_285_cov_12.758065_g14483_i0 PRJNA938397 14724 285 12.758065 36.36048525 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 62.1 4.37e-5   NTclustered gi|1778063674|ref|XR_004197995.1| 6105 g14483 i0 94.872 0.136842105263158 39 2 14 0 218 256 315 277 PREDICTED: Actinia tenebrosa uncharacterized LOC116303789 (LOC116303789), ncRNA blastn 39 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
9840943 9840943 PRJNA938397_S_NODE_26728_length_213_cov_9.488636_g26487_i0 PRJNA938397 26728 213 9.488636 20.21079468 Clavactinia serrata 1262060 Cnidaria other_Eukaryota 204 4.8899999999999997e-48   NTclustered gi|433288511|gb|JQ437280.1| 1262060 g26487 i0 89.809 69.4882629107981 157 12 73 3 1 155 155 1 Clavactinia serrata isolate 053 calmodulin gene, partial cds blastn 14801 204 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Clavactinia Clavactinia serrata
14940727 14940727 PRJNA938397_S_NODE_23292_length_229_cov_3.921875_g23051_i0 PRJNA938397 23292 229 3.921875 8.98109375 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 163 9.05e-36   NTclustered gi|1778031339|ref|XM_031697083.1| 6105 g23051 i0 80.172 1.01310043668122 232 34 99 9 4 229 2245 2470 PREDICTED: Actinia tenebrosa uncharacterized LOC116290098 (LOC116290098), mRNA blastn 232 163 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
16215683 16215683 PRJNA938397_S_NODE_20873_length_242_cov_4.126829_g20632_i0 PRJNA938397 20873 242 4.126829 9.98692618 Hydra vulgaris 6087 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2744881802|ref|XM_065807068.1| 6087 g20632 i0 96.97 0.136363636363636 33 0 14 1 10 42 977 1008 PREDICTED: Hydra vulgaris uncharacterized LOC105845740 (LOC105845740), transcript variant X3, mRNA blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
25139574 25139574 PRJNA938397_S_NODE_38500_length_177_cov_4.271429_g38259_i0 PRJNA938397 38500 177 4.271429 7.56042933 Stylophora pistillata 50429 Cnidaria other_Eukaryota 63.9 6.91e-6   NTclustered gi|1270040713|ref|XM_022926430.1| 50429 g38259 i0 97.297 0.209039548022599 37 1 21 0 38 74 823 859 PREDICTED: Stylophora pistillata cytochrome c-type heme lyase-like (LOC111323133), mRNA blastn 37 63.9 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);;