RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA315314", tax_kingdom = "Metazoa" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 18 ✖

tax_kingdom 1

  • Metazoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA315314 · 18 ✖
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
6758720 6758720 PRJNA315314_S_NODE_6946_length_306_cov_2702.375451_g6625_i0 PRJNA315314 6946 306 2702.375451 8269.26888006 Acropora formosa 126732 Cnidaria other_Eukaryota 87.9 7.82e-13   NTclustered gi|692518457|gb|KJ648506.1| 126732 g6625 i0 86.42 28.6732026143791 81 9 26 2 183 262 466 387 Acropora formosa isolate HN14 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 8774 87.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora formosa
9993495 9993495 PRJNA315314_S_NODE_3728_length_414_cov_14.812987_g3407_i0 PRJNA315314 3728 414 14.812987 61.32576618 Ceratomyxa 60661 Cnidaria other_Eukaryota 135 3.84e-27   NTclustered gi|241911744|gb|FJ417050.1| 650980 g3407 i0 77.982 51.4710144927536 218 46 53 1 1 218 2952 2737 Ceratomyxa sp. M0422 28S large subunit ribosomal RNA gene, partial sequence blastn 21309 135 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Ceratomyxidae Ceratomyxa Ceratomyxa sp. M0422
15092967 15092967 PRJNA315314_S_NODE_14932_length_211_cov_16.620879_g14611_i0 PRJNA315314 14932 211 16.620879 35.07005469 Leptothecata 500008 Cnidaria other_Eukaryota 113 8.38e-21   NTclustered gi|66864860|gb|AY920800.1| 47071 g14611 i0 84.348 49.4312796208531 115 18 55 0 97 211 2689 2575 Blackfordia virginica large subunit 28S ribosomal RNA gene, partial sequence blastn 10430 113 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Blackfordiidae Blackfordia Blackfordia virginica
15683279 15683279 PRJNA315314_S_NODE_1113_length_723_cov_69.466859_g888_i0 PRJNA315314 1113 723 69.466859 502.24539057 Trachyphyllia geoffroyi 196280 Cnidaria other_Eukaryota 1251 0   NTclustered gi|23503507|dbj|AB085641.1| 196280 g888 i0 100 37.9377593360996 677 0 94 0 5 681 1 677 Trachyphyllia geoffroyi mRNA for Kaede, complete cds blastn 27429 1251 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Trachyphyllia Trachyphyllia geoffroyi
16367866 16367866 PRJNA315314_S_NODE_25673_length_165_cov_7.117647_g25352_i0 PRJNA315314 25673 165 7.117647 11.74411755 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 65.8 1.77e-6   NTclustered gi|1603829774|ref|XR_003690458.1| 151771 g25352 i0 93.333 41.430303030303 45 2 27 1 121 165 2262 2305 PREDICTED: Dendronephthya gigantea large subunit ribosomal RNA (LOC114544542), rRNA blastn 6836 65.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
19506835 19506835 PRJNA315314_S_NODE_2456_length_505_cov_9.699580_g2152_i0 PRJNA315314 2456 505 9.69958 48.982879 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 251 1.94e-81   NR XP_065063129.1 499914 g2152 i0 73.9 0.932673267326733 157 41 93.3 0 504 34 89 245 XP_065063129.1 large ribosomal subunit protein uL30-like [Rhopilema esculentum] diamond 471 251 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
26725782 26725782 PRJNA315314_S_NODE_5281_length_349_cov_5.796875_g4960_i0 PRJNA315314 5281 349 5.796875 20.23109375 Actinostola sp. cb2 3060491 Cnidaria other_Eukaryota 56.6 1.67e-6   NR KAK3748527.1 3060491 g4960 i0 53.1 0.421203438395415 49 23 42.1 0 1 147 472 520 KAK3748527.1 hypothetical protein QZH41_012374 [Actinostola sp. cb2023] diamond 147 56.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actinostolidae Actinostola Actinostola sp. cb2023
26789617 26789617 PRJNA315314_S_NODE_1381_length_651_cov_13.792605_g1143_i0 PRJNA315314 1381 651 13.792605 89.78985855 Acropora digitifera 70779 Cnidaria other_Eukaryota 135 3.92e-33   NR XP_015751633.1 70779 g1143 i0 46.5 2.19354838709677 155 73 71.4 3 169 633 352 496 XP_015751633.1 PREDICTED: retinoschisin-like isoform X2 [Acropora digitifera] diamond 1428 135 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
27137095 27137095 PRJNA315314_S_NODE_1442_length_639_cov_7.998361_g1200_i0 PRJNA315314 1442 639 7.998361 51.10952679 Acropora digitifera 70779 Cnidaria other_Eukaryota 176 2.49e-51   NR XP_015760005.1 70779 g1200 i0 58.2 2.04694835680751 146 61 68.5 0 11 448 1 146 XP_015760005.1 PREDICTED: 60S ribosomal protein L13a-like isoform X1 [Acropora digitifera] diamond 1308 176 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
27643203 27643203 PRJNA315314_S_NODE_22664_length_175_cov_1.404110_g22343_i0 PRJNA315314 22664 175 1.40411 2.4571925 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 63.5 2.73e-10   NR KAJ7374682.1 174260 g22343 i0 52 3.51428571428571 50 24 85.7 0 173 24 24 73 KAJ7374682.1 phosphatidic acid transporter [Desmophyllum pertusum] diamond 615 63.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
28022063 28022063 PRJNA315314_S_NODE_27345_length_161_cov_2.174242_g27024_i0 PRJNA315314 27345 161 2.174242 3.50052962 Montipora capricornis 246305 Cnidaria other_Eukaryota 65.5 1.15e-10   NR XP_068737037.1 246305 g27024 i0 60.8 1.91925465838509 51 20 95 0 157 5 137 187 XP_068737037.1 adenylyl cyclase-associated protein 1-like [Montipora capricornis] diamond 309 65.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
28685130 28685130 PRJNA315314_S_NODE_15547_length_208_cov_1.430168_g15226_i0 PRJNA315314 15547 208 1.430168 2.97474944 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 47.8 3.9e-4   NR XP_028398568.1 151771 g15226 i0 42.3 0.75 52 30 75 0 191 36 387 438 XP_028398568.1 ribosomal oxygenase 1-like [Dendronephthya gigantea] diamond 156 47.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
29884964 29884964 PRJNA315314_S_NODE_26251_length_164_cov_2.000000_g25930_i0 PRJNA315314 26251 164 2 3.28 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 50.8 1.76e-5   NR KAJ7390040.1 174260 g25930 i0 48.9 2.81707317073171 47 22 84.1 2 141 4 37 82 KAJ7390040.1 hypothetical protein OS493_027565 [Desmophyllum pertusum] diamond 462 50.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
29979543 29979543 PRJNA315314_S_NODE_30591_length_154_cov_1.104000_g30270_i0 PRJNA315314 30591 154 1.104 1.70016 Montipora capricornis 246305 Cnidaria other_Eukaryota 42.4 0.0156   NR XP_068744571.1 246305 g30270 i0 40.4 2.68831168831169 57 25 95.5 2 4 150 533 588 XP_068744571.1 uncharacterized protein [Montipora capricornis] diamond 414 42.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
30264213 30264213 PRJNA315314_S_NODE_10192_length_253_cov_29.941964_g9871_i0 PRJNA315314 10192 253 29.941964 75.75316892 Porites lobata 104759 Cnidaria other_Eukaryota 42.7 0.0414   NR CAH3174760.1 104759 g9871 i0 50 0.426877470355731 36 18 42.7 0 214 107 363 398 CAH3174760.1 unnamed protein product [Porites lobata] diamond 108 42.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
30422293 30422293 PRJNA315314_S_NODE_24773_length_168_cov_2.935252_g24452_i0 PRJNA315314 24773 168 2.935252 4.93122336 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 50.1 2.86e-5   NR XP_028402102.1 151771 g24452 i0 45.3 1.89285714285714 53 29 94.6 0 165 7 135 187 XP_028402102.1 TLD domain-containing protein 1-like [Dendronephthya gigantea] diamond 318 50.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
30485124 30485124 PRJNA315314_S_NODE_17493_length_197_cov_1.904762_g17172_i0 PRJNA315314 17493 197 1.904762 3.75238114 Hydra vulgaris 6087 Cnidaria other_Eukaryota 90.5 2.07e-19   NR XP_065676196.1 6087 g17172 i0 71.4 0.959390862944162 63 18 95.9 0 193 5 246 308 XP_065676196.1 aspartate aminotransferase, mitochondrial isoform X2 [Hydra vulgaris] diamond 189 90.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
31780955 31780955 PRJNA315314_S_NODE_24237_length_170_cov_1.617021_g23916_i0 PRJNA315314 24237 170 1.617021 2.7489357 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 48.9 9.37e-5   NR XP_028400596.1 151771 g23916 i0 47.9 1.69411764705882 48 21 77.6 1 26 157 1505 1552 XP_028400596.1 LOW QUALITY PROTEIN: neurofibromin-like [Dendronephthya gigantea] diamond 288 48.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea

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