RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 15 ✖

bioproject 1

  • PRJNA1115053 · 15 ✖
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
1502858 1502858 PRJNA1115053_S_NODE_34962_length_381_cov_4.251479_g33148_i0 PRJNA1115053 34962 381 4.251479 16.19813499 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 54.7 0.01   NTclustered gi|2519002640|ref|XM_057452941.1| 13093 g33148 i0 100 0.0761154855643045 29 0 8 0 352 380 766 794 PREDICTED: Hydractinia symbiolongicarpus uncharacterized LOC130647178 (LOC130647178), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
5325461 5325461 PRJNA1115053_S_NODE_106105_length_253_cov_2.014286_g104288_i0 PRJNA1115053 106105 253 2.014286 5.09614358 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 52.8 0.023   NTclustered gi|2202666560|ref|XR_006951441.1| 2897299 g104288 i0 100 0.110671936758893 28 0 11 0 1 28 1 28 PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
6601042 6601042 PRJNA1115053_S_NODE_123806_length_238_cov_1.225641_g121989_i0 PRJNA1115053 123806 238 1.225641 2.91702558 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.021   NTclustered gi|2917940740|emb|OZ237567.1| 6108 g121989 i0 100 0.117647058823529 28 0 12 0 165 192 13504796 13504823 Anemonia sulcata genome assembly, chromosome: 13 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
6606396 6606396 PRJNA1115053_S_NODE_36506_length_375_cov_6.891566_g34691_i0 PRJNA1115053 36506 375 6.891566 25.8433725 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 52.8 0.036   NTclustered gi|1603825712|ref|XM_028561550.1| 151771 g34691 i0 94.118 0.0906666666666667 34 2 9 0 36 69 722 755 PREDICTED: Dendronephthya gigantea caspase-9-like (LOC114541744), mRNA blastn 34 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
7875526 7875526 PRJNA1115053_S_NODE_113467_length_246_cov_2.551724_g111650_i0 PRJNA1115053 113467 246 2.551724 6.27724104 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2917940745|emb|OZ237569.1| 6108 g111650 i0 96.774 0.126016260162602 31 1 13 0 125 155 2018376 2018346 Anemonia sulcata genome assembly, chromosome: 15 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
9952507 9952507 PRJNA1115053_S_NODE_179128_length_203_cov_2.400000_g177311_i0 PRJNA1115053 179128 203 2.4 4.872 Acropora 6127 Cnidaria other_Eukaryota 54.7 0.005   NTclustered gi|2114235770|ref|XM_044323304.1| 45264 g177311 i0 100 8.13300492610837 29 0 14 0 105 133 454 426 PREDICTED: Acropora millepora D-inositol 3-phosphate glycosyltransferase-like (LOC122960804), mRNA blastn 1651 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
16805009 16805009 PRJNA1115053_S_NODE_339434_length_152_cov_2.761468_g337617_i0 PRJNA1115053 339434 152 2.761468 4.19743136 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 54.7 0.003   NTclustered gi|1619675426|ref|XM_021054020.2| 2652724 g337617 i0 100 6 29 0 19 0 1 29 2249 2277 PREDICTED: Exaiptasia diaphana uncharacterized LOC110247564 (LOC110247564), mRNA blastn 912 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
18075486 18075486 PRJNA1115053_S_NODE_160855_length_213_cov_1.411765_g159038_i0 PRJNA1115053 160855 213 1.411765 3.00705945 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.019   NTclustered gi|2917940687|emb|OZ237555.1| 6108 g159038 i0 92.105 0.178403755868545 38 2 18 1 128 165 4040201 4040237 Anemonia sulcata genome assembly, chromosome: 1 blastn 38 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
20625089 20625089 PRJNA1115053_S_NODE_166477_length_210_cov_1.287425_g164660_i0 PRJNA1115053 166477 210 1.287425 2.7035925 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 52.8 0.018   NTclustered gi|2202666560|ref|XR_006951441.1| 2897299 g164660 i0 100 0.133333333333333 28 0 13 0 1 28 1 28 PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
26941345 26941345 PRJNA1115053_S_NODE_304322_length_160_cov_1.641026_g302505_i0 PRJNA1115053 304322 160 1.641026 2.6256416 Paramuricea clavata 317549 Cnidaria other_Eukaryota 52 6.61e-6   NR CAB4027350.1 317549 g302505 i0 51.2 4.03125 43 21 80.6 0 1 129 117 159 CAB4027350.1 Transposon Tf2-6 poly, partial [Paramuricea clavata] diamond 645 52 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
27384189 27384189 PRJNA1115053_S_NODE_220963_length_185_cov_3.126761_g219146_i0 PRJNA1115053 220963 185 3.126761 5.78450785 Paramuricea clavata 317549 Cnidaria other_Eukaryota 43.9 0.00547   NR CAB4006633.1 317549 g219146 i0 48.5 4.94594594594595 33 17 53.5 0 172 74 74 106 CAB4006633.1 Hypothetical predicted protein, partial [Paramuricea clavata] diamond 915 43.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
27668386 27668386 PRJNA1115053_S_NODE_310164_length_159_cov_0.836207_g308347_i0 PRJNA1115053 310164 159 0.836207 1.32956913 Paramuricea clavata 317549 Cnidaria other_Eukaryota 63.5 3.99e-10   NR CAB4022477.1 317549 g308347 i0 59.2 8.32075471698113 49 20 92.5 0 6 152 4 52 CAB4022477.1 Hypothetical predicted protein [Paramuricea clavata] diamond 1323 63.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
31015843 31015843 PRJNA1115053_S_NODE_171915_length_207_cov_1.463415_g170098_i0 PRJNA1115053 171915 207 1.463415 3.02926905 Paramuricea clavata 317549 Cnidaria other_Eukaryota 47.8 3.41e-4   NR CAB4001341.1 317549 g170098 i0 55 2.28985507246377 40 18 58 0 64 183 83 122 CAB4001341.1 Hypothetical predicted protein [Paramuricea clavata] diamond 474 47.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
32059470 32059470 PRJNA1115053_S_NODE_193618_length_197_cov_0.772727_g191801_i0 PRJNA1115053 193618 197 0.772727 1.52227219 Porites lobata 104759 Cnidaria other_Eukaryota 76.6 8.4e-17   NR CAH3187615.1 104759 g191801 i0 56.9 0.989847715736041 65 19 99 1 2 196 1 56 CAH3187615.1 unnamed protein product [Porites lobata] diamond 195 76.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
32754698 32754698 PRJNA1115053_S_NODE_180360_length_203_cov_1.200000_g178543_i0 PRJNA1115053 180360 203 1.2 2.436 Acropora millepora 45264 Cnidaria other_Eukaryota 42 0.0242   NR XP_044183263.1 45264 g178543 i0 36 0.738916256157635 50 32 73.9 0 52 201 104 153 XP_044183263.1 dedicator of cytokinesis protein 9-like [Acropora millepora] diamond 150 42 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora

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