RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJEB12237", tax_clade = "Opisthokonta" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 22 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 22 ✖

bioproject 1

  • PRJEB12237 · 22 ✖
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
7672915 7672915 PRJEB12237_P_NODE_7527_length_203_cov_1.666667_g7331_i0 PRJEB12237 7527 203 1.666667 3.38333401 Metazoa 33208 Cnidaria other_Eukaryota 101 2.74e-24   NR XP_027050760.1 46731 g7331 i0 73.9 19.1083743842365 69 16 99 1 202 2 1 69 XP_027050760.1 40S ribosomal protein S3a [Pocillopora damicornis] diamond 3879 101 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
10223458 10223458 PRJEB12237_P_NODE_5709_length_248_cov_1.004695_g5513_i0 PRJEB12237 5709 248 1.004695 2.4916436 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2917940720|emb|OZ237562.1| 6108 g5513 i0 100 0.116935483870968 29 0 12 0 10 38 547239 547267 Anemonia sulcata genome assembly, chromosome: 8 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
26937909 26937909 PRJEB12237_P_NODE_11902_length_152_cov_1.324786_g11706_i0 PRJEB12237 11902 152 1.324786 2.01367472 Porites evermanni 104178 Cnidaria other_Eukaryota 50.8 1.49e-5   NR CAH3018640.1 104178 g11706 i0 50 1.89473684210526 48 24 94.7 0 144 1 456 503 CAH3018640.1 unnamed protein product [Porites evermanni] diamond 288 50.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
27500829 27500829 PRJEB12237_P_NODE_3743_length_338_cov_2.326733_g3547_i0 PRJEB12237 3743 338 2.326733 7.86435754 Anthozoa 6101 Cnidaria other_Eukaryota 93.2 4.89e-22   NR XP_022795971.1 50429 g3547 i0 52.6 18.0177514792899 78 37 69.2 0 337 104 2 79 XP_022795971.1 probable 60S ribosomal protein L37-A [Stylophora pistillata] diamond 6090 93.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
27822888 27822888 PRJEB12237_P_NODE_11144_length_158_cov_0.975610_g10948_i0 PRJEB12237 11144 158 0.97561 1.5414638 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 59.7 1.21e-8   NR KAK3700595.1 3060491 g10948 i0 48 3.77848101265823 50 26 94.9 0 156 7 560 609 KAK3700595.1 hypothetical protein QZH41_001586 [Actinostola sp. cb2023] diamond 597 59.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
27847850 27847850 PRJEB12237_P_NODE_1704_length_552_cov_2.061896_g1523_i0 PRJEB12237 1704 552 2.061896 11.38166592 Metazoa 33208 Cnidaria other_Eukaryota 56.2 3.59e-6   NR XP_032220179.2 45351 g1523 i0 48.6 2.57065217391304 72 35 39.1 2 58 273 9 78 XP_032220179.2 histone H1-delta [Nematostella vectensis] diamond 1419 56.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
28138719 28138719 PRJEB12237_P_NODE_8825_length_183_cov_1.351351_g8629_i0 PRJEB12237 8825 183 1.351351 2.47297233 Stylophora pistillata 50429 Cnidaria other_Eukaryota 44.3 0.00492   NR PFX32089.1 50429 g8629 i0 56.8 0.60655737704918 37 16 60.7 0 180 70 463 499 PFX32089.1 60S ribosomal protein L4-B [Stylophora pistillata] diamond 111 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
28321549 28321549 PRJEB12237_P_NODE_10806_length_161_cov_1.230159_g10610_i0 PRJEB12237 10806 161 1.230159 1.98055599 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 79.3 5.97e-16   NR XP_066920090.1 252671 g10610 i0 64.6 10.7329192546584 48 17 89.4 0 161 18 248 295 XP_066920090.1 vacuolar protein sorting-associated protein 26C-like [Clytia hemisphaerica] diamond 1728 80.1 0.990012484394507 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
28359337 28359337 PRJEB12237_P_NODE_12026_length_151_cov_1.379310_g11830_i0 PRJEB12237 12026 151 1.37931 2.0827581 Nematostella vectensis 45351 Cnidaria other_Eukaryota 77.4 9.54e-17   NR XP_032218678.1 45351 g11830 i0 81.4 6.83443708609272 43 8 85.4 0 1 129 71 113 XP_032218678.1 60S ribosomal protein L35a [Nematostella vectensis] diamond 1032 77.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
28675346 28675346 PRJEB12237_P_NODE_6127_length_236_cov_1.194030_g5931_i0 PRJEB12237 6127 236 1.19403 2.8179108 Orbicella faveolata 48498 Cnidaria other_Eukaryota 46.6 0.00145   NR XP_020629462.1 48498 g5931 i0 42.2 1.14406779661017 45 26 57.2 0 1 135 337 381 XP_020629462.1 interferon-related developmental regulator 1-like [Orbicella faveolata] diamond 270 46.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
28833044 28833044 PRJEB12237_P_NODE_8028_length_195_cov_1.000000_g7832_i0 PRJEB12237 8028 195 1 1.95 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 94.4 1.17e-20   NR KXJ26381.1 2652724 g7832 i0 68.8 0.984615384615385 64 20 98.5 0 2 193 119 182 KXJ26381.1 T-complex protein 1 subunit beta [Exaiptasia diaphana] diamond 192 94.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
29932129 29932129 PRJEB12237_P_NODE_5451_length_256_cov_3.027149_g5255_i0 PRJEB12237 5451 256 3.027149 7.74950144 root 1 Root_unresolved Root_unresolved 44.3 0.0126   NR PFX21664.1 50429 g5255 i0 42.2 0.9609375 45 26 52.7 0 184 50 230 274 PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] diamond 246 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
30216092 30216092 PRJEB12237_P_NODE_4352_length_306_cov_1.476015_g4156_i0 PRJEB12237 4352 306 1.476015 4.5166059 Scleractinia 6125 Cnidaria other_Eukaryota 83.2 1.1e-16   NR XP_020622178.1 48498 g4156 i0 42.7 6.76470588235294 96 54 94.1 1 1 288 86 180 XP_020622178.1 translocon-associated protein subunit alpha-like [Orbicella faveolata] diamond 2070 83.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
30222497 30222497 PRJEB12237_P_NODE_12072_length_151_cov_1.034483_g11876_i0 PRJEB12237 12072 151 1.034483 1.56206933 Nematostella vectensis 45351 Cnidaria other_Eukaryota 56.6 1.3e-7   NR XP_048583861.1 45351 g11876 i0 57.1 0.973509933774834 49 20 97.4 1 149 3 879 926 XP_048583861.1 protein disulfide-isomerase A4-like [Nematostella vectensis] diamond 147 56.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
30538490 30538490 PRJEB12237_P_NODE_8633_length_186_cov_0.993377_g8437_i0 PRJEB12237 8633 186 0.993377 1.84768122 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 64.3 4.19e-10   NR XP_065065856.1 499914 g8437 i0 62.5 0.645161290322581 40 15 64.5 0 54 173 263 302 XP_065065856.1 protein DD3-3-like [Rhopilema esculentum] diamond 120 64.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
30626862 30626862 PRJEB12237_P_NODE_5973_length_240_cov_1.560976_g5777_i0 PRJEB12237 5973 240 1.560976 3.7463424 Metazoa 33208 Cnidaria other_Eukaryota 45.8 0.00291   NR XP_065651880.1 6087 g5777 i0 38.2 7.0125 55 33 68.8 1 74 238 696 749 XP_065651880.1 uncharacterized protein LOC136079653 [Hydra vulgaris] diamond 1683 45.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
30664908 30664908 PRJEB12237_P_NODE_3973_length_325_cov_1.496552_g3777_i0 PRJEB12237 3973 325 1.496552 4.863794 Nematostella vectensis 45351 Cnidaria other_Eukaryota 84.3 1.92e-16   NR XP_001640531.2 45351 g3777 i0 49.4 0.766153846153846 83 40 76.6 1 268 20 4 84 XP_001640531.2 elongation factor 1-gamma-A [Nematostella vectensis] diamond 249 84.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
31012449 31012449 PRJEB12237_P_NODE_3255_length_372_cov_1.329377_g3059_i0 PRJEB12237 3255 372 1.329377 4.94528244 Hydra vulgaris 6087 Cnidaria other_Eukaryota 72.4 1.05e-12   NR XP_065662037.1 6087 g3059 i0 56.9 0.524193548387097 65 25 50.8 2 368 180 98 161 XP_065662037.1 uncharacterized protein LOC136084845 [Hydra vulgaris] diamond 195 72.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
31107119 31107119 PRJEB12237_P_NODE_2095_length_493_cov_1.864629_g1907_i0 PRJEB12237 2095 493 1.864629 9.19262097 Stylophora pistillata 50429 Cnidaria other_Eukaryota 65.1 7.03e-9   NR XP_022794989.1 50429 g1907 i0 45.6 4.77687626774848 79 34 48.1 3 466 230 281 350 XP_022794989.1 protein hedgehog-like [Stylophora pistillata] diamond 2355 65.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
31385653 31385653 PRJEB12237_P_NODE_12196_length_150_cov_1.043478_g12000_i0 PRJEB12237 12196 150 1.043478 1.565217 Metazoa 33208 Cnidaria other_Eukaryota 81.6 3.64e-17   NR XP_031572380.1 6105 g12000 i0 65.3 16.66 49 17 98 0 149 3 138 186 XP_031572380.1 N-terminal Xaa-Pro-Lys N-methyltransferase 1-B-like [Actinia tenebrosa] diamond 2499 81.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
31480696 31480696 PRJEB12237_P_NODE_10516_length_163_cov_1.875000_g10320_i0 PRJEB12237 10516 163 1.875 3.05625 Metazoa 33208 Cnidaria other_Eukaryota 49.3 1.47e-5   NR EDO33935.1 45351 g10320 i0 73.7 4.19631901840491 38 10 69.9 0 114 1 1 38 EDO33935.1 predicted protein [Nematostella vectensis] diamond 684 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
32024526 32024526 PRJEB12237_P_NODE_6578_length_224_cov_1.746032_g6382_i0 PRJEB12237 6578 224 1.746032 3.91111168 Hydra vulgaris 6087 Cnidaria other_Eukaryota 66.2 4.31e-11   NR XP_047131876.1 6087 g6382 i0 59.3 0.723214285714286 54 21 72.3 1 47 208 89 141 XP_047131876.1 uncharacterized protein LOC124810917 [Hydra vulgaris] diamond 162 66.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris

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