RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJEB50332", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 12 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 12 ✖

bioproject 1

  • PRJEB50332 · 12 ✖

analysis 1

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
11194534 11194534 PRJEB50332_P_NODE_10309_length_223_cov_1.135802_g10227_i0 PRJEB50332 10309 223 1.135802 2.53283846 root 1 Root_unresolved Root_unresolved 105 1.75e-24   NR XP_065679188.1 6087 g10227 i0 66.2 96.5515695067265 74 25 99.6 0 222 1 544 617 XP_065679188.1 ATP-dependent translocase ABCB1 isoform X1 [Hydra vulgaris] diamond 21531 105 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
27033498 27033498 PRJEB50332_P_NODE_2842_length_341_cov_1.160714_g2760_i0 PRJEB50332 2842 341 1.160714 3.95803474 Orbicella faveolata 48498 Cnidaria other_Eukaryota 54.3 9.05e-6   NR XP_020609478.1 48498 g2760 i0 34.4 0.818181818181818 93 55 76.5 3 340 80 221 313 XP_020609478.1 uncharacterized protein LOC110048052 isoform X1 [Orbicella faveolata] diamond 279 54.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
27690621 27690621 PRJEB50332_P_NODE_5984_length_254_cov_1.497409_g5902_i0 PRJEB50332 5984 254 1.497409 3.80341886 Opisthokonta 33154 Cnidaria other_Eukaryota 51.6 3.21e-5   NR XP_066921530.1 252671 g5902 i0 32.9 2.89370078740157 82 55 96.9 0 252 7 479 560 XP_066921530.1 glycine--tRNA ligase-like [Clytia hemisphaerica] diamond 735 51.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
27785191 27785191 PRJEB50332_P_NODE_15224_length_206_cov_1.717241_g15142_i0 PRJEB50332 15224 206 1.717241 3.53751646 Metazoa 33208 Cnidaria other_Eukaryota 50.1 5.32e-5   NR XP_031553524.1 6105 g15142 i0 46.5 3.53883495145631 43 23 62.6 0 1 129 228 270 XP_031553524.1 uncharacterized protein LOC116290597, partial [Actinia tenebrosa] diamond 729 50.4 0.994047619047619 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
28581150 28581150 PRJEB50332_P_NODE_11867_length_214_cov_1.692810_g11785_i0 PRJEB50332 11867 214 1.69281 3.6226134 Porites evermanni 104178 Cnidaria other_Eukaryota 55.1 1.14e-6   NR CAH3150226.1 104178 g11785 i0 41.9 1.03738317757009 74 34 96.7 3 213 7 422 491 CAH3150226.1 unnamed protein product, partial [Porites evermanni] diamond 222 55.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
29805603 29805603 PRJEB50332_P_NODE_11511_length_216_cov_1.677419_g11429_i0 PRJEB50332 11511 216 1.677419 3.62322504 Pocillopora 46730 Cnidaria other_Eukaryota 99 1.59e-22   NR RMX40217.1 46731 g11429 i0 67.6 1.97222222222222 71 20 98.6 2 214 2 270 337 RMX40217.1 hypothetical protein pdam_00016543 [Pocillopora damicornis] diamond 426 99 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
30350054 30350054 PRJEB50332_P_NODE_12692_length_211_cov_0.866667_g12610_i0 PRJEB50332 12692 211 0.866667 1.82866737 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 80.5 9.37e-16   NR KAK3723325.1 3060491 g12610 i0 63.2 0.81042654028436 57 21 81 0 202 32 335 391 KAK3723325.1 hypothetical protein QZH41_014395, partial [Actinostola sp. cb2023] diamond 171 80.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
31360872 31360872 PRJEB50332_P_NODE_3196_length_324_cov_2.091255_g3114_i0 PRJEB50332 3196 324 2.091255 6.7756662 Porites evermanni 104178 Cnidaria other_Eukaryota 69.3 7.26e-12   NR CAH3170161.1 104178 g3114 i0 57.4 1.5462962962963 54 20 50 1 178 17 56 106 CAH3170161.1 unnamed protein product [Porites evermanni] diamond 501 69.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
31423953 31423953 PRJEB50332_P_NODE_9356_length_228_cov_1.467066_g9274_i0 PRJEB50332 9356 228 1.467066 3.34491048 Orbicella faveolata 48498 Cnidaria other_Eukaryota 60.8 1.27e-8   NR XP_020624024.1 48498 g9274 i0 57.4 2.68421052631579 54 21 71.1 1 225 64 44 95 XP_020624024.1 LOW QUALITY PROTEIN: protein LSM14 homolog B-like [Orbicella faveolata] diamond 612 60.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
32208172 32208172 PRJEB50332_P_NODE_2278_length_374_cov_1.031949_g2197_i0 PRJEB50332 2278 374 1.031949 3.85948926 Actiniaria 6103 Cnidaria other_Eukaryota 97.1 7.339999999999999e-23   NR XP_031559276.1 6105 g2197 i0 56.1 2.62299465240642 82 35 65.8 1 372 127 60 140 XP_031559276.1 40S ribosomal protein S19-like [Actinia tenebrosa] diamond 981 97.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
32208174 32208174 PRJEB50332_P_NODE_7778_length_237_cov_1.460227_g7696_i0 PRJEB50332 7778 237 1.460227 3.46073799 Metazoa 33208 Cnidaria other_Eukaryota 65.1 4.72e-10   NR XP_065639571.1 6087 g7696 i0 47.3 8.41772151898734 74 39 93.7 0 7 228 629 702 XP_065639571.1 uncharacterized protein LOC136072316 [Hydra vulgaris] diamond 1995 65.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
32625772 32625772 PRJEB50332_P_NODE_6300_length_249_cov_1.643617_g6218_i0 PRJEB50332 6300 249 1.643617 4.09260633 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 47 5.5e-4   NR XP_057316972.1 13093 g6218 i0 40.9 0.795180722891566 66 38 79.5 1 248 51 93 157 XP_057316972.1 uncharacterized protein LOC130657978 [Hydractinia symbiolongicarpus] diamond 198 47 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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