RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where bioproject = "PRJNA312899", 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 · 32 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 32 ✖

bioproject 1

  • PRJNA312899 · 32 ✖
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
379638 379638 PRJNA312899_P_NODE_46661_length_257_cov_3.524038_g46219_i0 PRJNA312899 46661 257 3.524038 9.05677766 Stylophora pistillata 50429 Cnidaria other_Eukaryota 148 1.38e-41   NR PFX11949.1 50429 g46219 i0 79.5 2.92996108949416 83 17 96.9 0 257 9 251 333 PFX11949.1 Retrovirus-related Pol polyprotein from transposon opus [Stylophora pistillata] diamond 753 148 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
1064340 1064340 PRJNA312899_P_NODE_13561_length_513_cov_8.357759_g13131_i0 PRJNA312899 13561 513 8.357759 42.87530367 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 129 5.51e-32   NR XP_028411767.1 151771 g13131 i0 58.6 1.72514619883041 99 41 57.9 0 513 217 27 125 XP_028411767.1 cytochrome b5 reductase 4-like [Dendronephthya gigantea] diamond 885 129 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
4892631 4892631 PRJNA312899_P_NODE_61924_length_213_cov_2.487805_g61482_i0 PRJNA312899 61924 213 2.487805 5.29902465 Haliclystus 37533 Cnidaria other_Eukaryota 152 1.8e-32   NTclustered gi|66864841|gb|AY920782.1| 168739 g61482 i0 94.898 43.5727699530516 98 3 46 2 117 213 2125 2029 Haliclystus sanjuanensis large subunit 28S ribosomal RNA gene, partial sequence blastn 9281 152 1 Eukaryota Opisthokonta Metazoa Cnidaria Staurozoa Stauromedusae Haliclystidae Haliclystus Haliclystus sanjuanensis
6756938 6756938 PRJNA312899_P_NODE_26106_length_365_cov_9.553797_g25664_i0 PRJNA312899 26106 365 9.553797 34.87135905 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 178 4.8699999999999985e-55   NR XP_028410526.1 151771 g25664 i0 70.5 2.02191780821918 122 34 98.6 1 364 5 10 131 XP_028410526.1 60S ribosomal protein L27a-like [Dendronephthya gigantea] diamond 738 178 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
11267741 11267741 PRJNA312899_P_NODE_37109_length_296_cov_4.441296_g36667_i0 PRJNA312899 37109 296 4.441296 13.14623616 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 60.5 4e-8   NR XP_028394560.1 151771 g36667 i0 47.1 0.689189189189189 68 33 65.9 1 219 25 282 349 XP_028394560.1 folliculin-like [Dendronephthya gigantea] diamond 204 60.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
11267936 11267936 PRJNA312899_P_NODE_53489_length_236_cov_1.090909_g53047_i0 PRJNA312899 53489 236 1.090909 2.57454524 Saccosporidae 519444 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|237512529|gb|FJ981822.1| 271932 g53047 i0 96.97 0.542372881355932 33 0 14 1 78 109 2817 2785 Tetracapsuloides bryosalmonae clone 2 28S large subunit ribosomal RNA gene, partial sequence blastn 128 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Malacovalvulida Saccosporidae Tetracapsuloides Tetracapsuloides bryosalmonae
13817962 13817962 PRJNA312899_P_NODE_40371_length_281_cov_1.758621_g39929_i0 PRJNA312899 40371 281 1.758621 4.94172501 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.1 4.44e-18   NR XP_065671024.1 6087 g39929 i0 53.6 6.38434163701068 69 32 73.7 0 74 280 2 70 XP_065671024.1 ras-related protein Rab-18 [Hydra vulgaris] diamond 1794 85.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
15682152 15682152 PRJNA312899_P_NODE_33953_length_313_cov_2.109848_g33511_i0 PRJNA312899 33953 313 2.109848 6.60382424 Paramuricea clavata 317549 Cnidaria other_Eukaryota 156 1.32e-46   NR CAB3989122.1 317549 g33511 i0 68.3 3.98722044728434 104 33 99.7 0 2 313 11 114 CAB3989122.1 GDP-L-fucose synthase-like [Paramuricea clavata] diamond 1248 156 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
17641952 17641952 PRJNA312899_P_NODE_16354_length_466_cov_50.755396_g15916_i0 PRJNA312899 16354 466 50.755396 236.52014536 Metazoa 33208 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g15916 i0 100 6.07081545064378 31 0 7 0 165 195 31313625 31313595 Anemonia sulcata genome assembly, chromosome: 1 blastn 2829 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
19505289 19505289 PRJNA312899_P_NODE_28256_length_349_cov_2.903333_g27814_i0 PRJNA312899 28256 349 2.903333 10.13263217 Hydrozoa 6074 Cnidaria other_Eukaryota 137 2.69e-37   NR XP_057312832.1 13093 g27814 i0 50.4 2.99140401146132 115 57 98.9 0 346 2 1 115 XP_057312832.1 AN1-type zinc finger protein 2A-like [Hydractinia symbiolongicarpus] diamond 1044 137 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
26599155 26599155 PRJNA312899_P_NODE_39361_length_285_cov_5.822034_g38919_i0 PRJNA312899 39361 285 5.822034 16.5927969 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 99 3.65e-22   NR XP_065070945.1 499914 g38919 i0 58.9 0.768421052631579 73 27 76.8 1 1 219 124 193 XP_065070945.1 cysteine and glycine-rich protein 2-like [Rhopilema esculentum] diamond 219 99 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
26711720 26711720 PRJNA312899_P_NODE_16281_length_467_cov_30.521531_g15843_i0 PRJNA312899 16281 467 30.521531 142.53554977 root 1 Root_unresolved Root_unresolved 47 0.0113   NR XP_065654703.1 6087 g15843 i0 34.6 0.957173447537473 81 52 51.4 1 45 284 302 382 XP_065654703.1 uncharacterized protein LOC136081322 [Hydra vulgaris] diamond 447 47 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
26775527 26775527 PRJNA312899_P_NODE_9141_length_625_cov_5.119792_g8747_i0 PRJNA312899 9141 625 5.119792 31.9987 Acroporidae 6126 Cnidaria other_Eukaryota 151 1.5899999999999999e-40   NR KAK2552923.1 6130 g8747 i0 41.1 5.736 207 116 96.5 3 605 3 77 283 KAK2552923.1 hypothetical protein P5673_025875 [Acropora cervicornis] diamond 3585 151 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
26853053 26853053 PRJNA312899_P_NODE_53281_length_236_cov_3.245989_g52839_i0 PRJNA312899 53281 236 3.245989 7.66053404 Hydra vulgaris 6087 Cnidaria other_Eukaryota 60.8 1.41e-8   NR XP_065671679.1 6087 g52839 i0 43.6 2.58050847457627 78 39 99.2 2 2 235 234 306 XP_065671679.1 uncharacterized protein LOC136089556 [Hydra vulgaris] diamond 609 60.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
26947622 26947622 PRJNA312899_P_NODE_40462_length_280_cov_10.354978_g40020_i0 PRJNA312899 40462 280 10.354978 28.9939384 Agaricia lamarcki 262284 Cnidaria other_Eukaryota 44.3 0.00139   NR AGI04926.1 262284 g40020 i0 60.7 0.6 28 11 30 0 14 97 18 45 AGI04926.1 green fluorescent protein 2, partial [Agaricia lamarcki] diamond 168 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Agariciidae Agaricia Agaricia lamarcki
27376619 27376619 PRJNA312899_P_NODE_33043_length_318_cov_3.747212_g32601_i0 PRJNA312899 33043 318 3.747212 11.91613416 Metazoa 33208 Cnidaria other_Eukaryota 69.7 3.28e-11   NR XP_022800277.1 50429 g32601 i0 44.6 5.61320754716981 92 42 78.3 3 270 22 1883 1974 XP_022800277.1 integrator complex subunit 1-like isoform X2 [Stylophora pistillata] diamond 1785 69.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
27516667 27516667 PRJNA312899_P_NODE_30743_length_332_cov_3.646643_g30301_i0 PRJNA312899 30743 332 3.646643 12.10685476 Hydra vulgaris 6087 Cnidaria other_Eukaryota 81.3 3.21e-15   NR XP_002155572.3 6087 g30301 i0 42 1.01204819277108 112 48 99.4 5 1 330 21 117 XP_002155572.3 E3 ubiquitin-protein ligase TRIM71 [Hydra vulgaris] diamond 336 81.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
27927168 27927168 PRJNA312899_P_NODE_93345_length_164_cov_1.756522_g92903_i0 PRJNA312899 93345 164 1.756522 2.88069608 Porites evermanni 104178 Cnidaria other_Eukaryota 51.6 9.52e-6   NR CAH3196117.1 104178 g92903 i0 46.3 0.98780487804878 54 22 98.8 2 164 3 588 634 CAH3196117.1 unnamed protein product [Porites evermanni] diamond 162 51.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
28558774 28558774 PRJNA312899_P_NODE_34447_length_310_cov_4.839080_g34005_i0 PRJNA312899 34447 310 4.83908 15.001148 Nematostella vectensis 45351 Cnidaria other_Eukaryota 107 2.13e-24   NR EDO49878.1 45351 g34005 i0 51.5 0.97741935483871 101 47 97.7 1 3 305 447 545 EDO49878.1 predicted protein, partial [Nematostella vectensis] diamond 303 107 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
28905710 28905710 PRJNA312899_P_NODE_44628_length_264_cov_4.734884_g44186_i0 PRJNA312899 44628 264 4.734884 12.50009376 Acropora cervicornis 6130 Cnidaria other_Eukaryota 65.9 3.48e-10   NR KAK2547137.1 6130 g44186 i0 47.1 0.795454545454545 70 37 79.5 0 51 260 174 243 KAK2547137.1 hypothetical protein P5673_033078 [Acropora cervicornis] diamond 210 65.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
29379550 29379550 PRJNA312899_P_NODE_91089_length_165_cov_0.879310_g90647_i0 PRJNA312899 91089 165 0.87931 1.4508615 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 68.9 7.3e-12   NR XP_066923746.1 252671 g90647 i0 66 1.92727272727273 53 18 96.4 0 6 164 8 60 XP_066923746.1 uncharacterized protein [Clytia hemisphaerica] diamond 318 68.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
29505726 29505726 PRJNA312899_P_NODE_37470_length_294_cov_4.085714_g37028_i0 PRJNA312899 37470 294 4.085714 12.01199916 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 81.6 4.77e-18   NR KXJ24611.1 2652724 g37028 i0 57.1 5 70 30 71.4 0 294 85 4 73 KXJ24611.1 Protein kish-B [Exaiptasia diaphana] diamond 1470 82 0.995121951219512 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
29775823 29775823 PRJNA312899_P_NODE_16531_length_464_cov_11.672289_g16093_i0 PRJNA312899 16531 464 11.672289 54.15942096 Opisthokonta 33154 Cnidaria other_Eukaryota 84 2.64e-17   NR XP_029187045.1 45264 g16093 i0 38.5 4.97198275862069 130 71 78.2 2 14 376 13 142 XP_029187045.1 protein MIX23-like [Acropora millepora] diamond 2307 84.7 0.991735537190083 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
30123310 30123310 PRJNA312899_P_NODE_77952_length_182_cov_1.511278_g77510_i0 PRJNA312899 77952 182 1.511278 2.75052596 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47.8 2.66e-5   NR KAK2568951.1 6130 g77510 i0 48.8 7.43406593406593 43 22 70.9 0 54 182 15 57 KAK2568951.1 Coiled-coil-helix-coiled-coil-helix domain-containing protein 7 [Acropora cervicornis] diamond 1353 47.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
30232270 30232270 PRJNA312899_P_NODE_7732_length_672_cov_10.391653_g7359_i0 PRJNA312899 7732 672 10.391653 69.83190816 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 54.7 3.09e-5   NR XP_065065687.1 499914 g7359 i0 40.8 0.633928571428571 142 73 58.5 2 642 250 3 144 XP_065065687.1 28 kDa heat- and acid-stable phosphoprotein-like [Rhopilema esculentum] diamond 426 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
31370116 31370116 PRJNA312899_P_NODE_33196_length_317_cov_4.108209_g32754_i0 PRJNA312899 33196 317 4.1082090000000004 13.02302253 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 61.2 2.76e-8   NR KAK3720534.1 3060491 g32754 i0 35.3 3.00946372239748 85 54 80.4 1 61 315 129 212 KAK3720534.1 hypothetical protein QZH41_001987 [Actinostola sp. cb2023] diamond 954 61.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
31433109 31433109 PRJNA312899_P_NODE_9156_length_624_cov_33.405217_g8762_i0 PRJNA312899 9156 624 33.405217 208.44855408 Acropora digitifera 70779 Cnidaria other_Eukaryota 80.5 1.29e-13   NR XP_015755013.1 70779 g8762 i0 29.2 3.51923076923077 192 124 90.4 3 611 48 382 565 XP_015755013.1 PREDICTED: protein FAM188B-like [Acropora digitifera] diamond 2196 80.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
31622853 31622853 PRJNA312899_P_NODE_24476_length_378_cov_28.252280_g24034_i0 PRJNA312899 24476 378 28.25228 106.7936184 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 63.2 1.25e-8   NR KXJ09421.1 2652724 g24034 i0 61.2 0.388888888888889 49 19 38.9 0 153 299 1207 1255 KXJ09421.1 hypothetical protein AC249_AIPGENE16799 [Exaiptasia diaphana] diamond 147 63.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
31861729 31861729 PRJNA312899_P_NODE_38917_length_287_cov_4.857143_g38475_i0 PRJNA312899 38917 287 4.857143 13.94000041 Metazoa 33208 Cnidaria other_Eukaryota 52.8 9.19e-6   NR KAK2561347.1 6130 g38475 i0 39.4 3.47038327526132 66 40 69 0 200 3 113 178 KAK2561347.1 Universal stress protein A-like protein [Acropora cervicornis] diamond 996 53.1 0.994350282485876 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
32287622 32287622 PRJNA312899_P_NODE_41219_length_277_cov_6.043860_g40777_i0 PRJNA312899 41219 277 6.04386 16.7414922 Paramuricea clavata 317549 Cnidaria other_Eukaryota 62.4 7.13e-9   NR CAB3985912.1 317549 g40777 i0 60 0.541516245487365 50 20 54.2 0 124 273 765 814 CAB3985912.1 Hypothetical predicted protein [Paramuricea clavata] diamond 150 62.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
32368371 32368371 PRJNA312899_P_NODE_13259_length_519_cov_4.168085_g12829_i0 PRJNA312899 13259 519 4.168085 21.63236115 Opisthokonta 33154 Cnidaria other_Eukaryota 70.1 1.42e-10   NR XP_001632888.3 45351 g12829 i0 38.8 6.93063583815029 103 49 59.5 1 475 167 210 298 XP_001632888.3 palmitoyltransferase ZDHHC15B isoform X2 [Nematostella vectensis] diamond 3597 70.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
32823990 32823990 PRJNA312899_P_NODE_86500_length_167_cov_0.864407_g86058_i0 PRJNA312899 86500 167 0.864407 1.44355969 Paramuricea clavata 317549 Cnidaria other_Eukaryota 68.2 4.02e-13   NR CAB4015777.1 317549 g86058 i0 69 3.17964071856287 42 13 75.4 0 131 6 10 51 CAB4015777.1 Hypothetical predicted protein, partial [Paramuricea clavata] diamond 531 68.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata

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