RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJDB14274" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB14274 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
9909115 9909115 PRJDB14274_S_NODE_4528_length_291_cov_1.247826_g4450_i0 PRJDB14274 4528 291 1.247826 3.63117366 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 110 6.38e-26   NR KXJ09409.1 2652724 g4450 i0 71.8 1.4639175257732 71 20 73.2 0 78 290 1 71 KXJ09409.1 Serine--tRNA ligase, cytoplasmic [Exaiptasia diaphana] diamond 426 110 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
10211448 10211448 PRJDB14274_S_NODE_9389_length_208_cov_1.326531_g9311_i0 PRJDB14274 9389 208 1.326531 2.75918448 Pocillopora damicornis 46731 Cnidaria other_Eukaryota 126 3.7899999999999997e-32   NR XP_027055263.1 46731 g9311 i0 75.4 6.96634615384615 69 17 99.5 0 207 1 37 105 XP_027055263.1 lariat debranching enzyme B-like [Pocillopora damicornis] diamond 1449 126 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
26588930 26588930 PRJDB14274_S_NODE_9121_length_210_cov_1.449664_g9043_i0 PRJDB14274 9121 210 1.449664 3.0442944 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 132 1.6399999999999999e-34   NR XP_065069824.1 499914 g9043 i0 88.4 5.91428571428571 69 8 98.6 0 3 209 364 432 XP_065069824.1 phenylalanine--tRNA ligase alpha subunit-like [Rhopilema esculentum] diamond 1242 132 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
28132144 28132144 PRJDB14274_S_NODE_4625_length_288_cov_1.493392_g4547_i0 PRJDB14274 4625 288 1.493392 4.30096896 Metazoa 33208 Cnidaria other_Eukaryota 94 5.11e-20   NR XP_028393838.1 151771 g4547 i0 60 17.5833333333333 80 30 83.3 1 45 284 280 357 XP_028393838.1 6-phosphogluconate dehydrogenase, decarboxylating-like [Dendronephthya gigantea] diamond 5064 94.7 0.992608236536431 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
28200794 28200794 PRJDB14274_S_NODE_2286_length_404_cov_1.422741_g2208_i0 PRJDB14274 2286 404 1.422741 5.74787364 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 99 1.4000000000000002e-23   NR XP_031572029.1 6105 g2208 i0 55.8 0.705445544554455 95 40 70.5 1 366 82 32 124 XP_031572029.1 keratinocyte-associated protein 2-like [Actinia tenebrosa] diamond 285 99 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
28479369 28479369 PRJDB14274_S_NODE_4226_length_300_cov_2.640167_g4148_i0 PRJDB14274 4226 300 2.640167 7.920501 Metazoa 33208 Cnidaria other_Eukaryota 79 2.52e-16   NR XP_028401543.1 151771 g4148 i0 61.4 15.82 70 27 70 0 210 1 41 110 XP_028401543.1 short coiled-coil protein B-like [Dendronephthya gigantea] diamond 4746 79 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
28573964 28573964 PRJDB14274_S_NODE_9707_length_206_cov_0.896552_g9629_i0 PRJDB14274 9707 206 0.896552 1.84689712 Metazoa 33208 Cnidaria other_Eukaryota 46.2 3.44e-4   NR KAK2571424.1 6130 g9629 i0 72.4 3.21844660194175 29 8 42.2 0 118 204 2 30 KAK2571424.1 Protein BRICK1 [Acropora cervicornis] diamond 663 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
29395026 29395026 PRJDB14274_S_NODE_7229_length_236_cov_0.845714_g7151_i0 PRJDB14274 7229 236 0.845714 1.99588504 Cnidaria 6073 Cnidaria other_Eukaryota 83.6 1.34e-16   NR XP_022794349.1 50429 g7151 i0 53.9 6.67372881355932 76 35 96.6 0 235 8 345 420 XP_022794349.1 steroid 17-alpha-hydroxylase/17,20 lyase-like [Stylophora pistillata] diamond 1575 84.3 0.991696322657177 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
29558601 29558601 PRJDB14274_S_NODE_1190_length_554_cov_1.685598_g1114_i0 PRJDB14274 1190 554 1.685598 9.33821292 Montipora foliosa 591990 Cnidaria other_Eukaryota 74.7 6.36e-12   NR XP_068689828.1 591990 g1114 i0 26.8 3.34115523465704 127 83 65 4 549 190 450 573 XP_068689828.1 transmembrane protease serine 9-like [Montipora foliosa] diamond 1851 74.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora foliosa
29678798 29678798 PRJDB14274_S_NODE_5150_length_275_cov_1.350467_g5072_i0 PRJDB14274 5150 275 1.350467 3.71378425 Metazoa 33208 Cnidaria other_Eukaryota 80.9 2.13e-15   NR XP_057291984.1 13093 g5072 i0 63.5 5.36727272727273 52 19 56.7 0 157 2 135 186 XP_057291984.1 ribosome biogenesis protein bop1-like [Hydractinia symbiolongicarpus] diamond 1476 81.6 0.991421568627451 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
31195171 31195171 PRJDB14274_S_NODE_5575_length_265_cov_1.338235_g5497_i0 PRJDB14274 5575 265 1.338235 3.54632275 Metazoa 33208 Cnidaria other_Eukaryota 79.7 3.5e-15   NR CAB4014199.1 317549 g5497 i0 44 15.1924528301887 84 45 95.1 1 1 252 208 289 CAB4014199.1 plasma kallikrein-like [Paramuricea clavata] diamond 4026 79.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
31327910 31327910 PRJDB14274_S_NODE_8316_length_220_cov_1.484277_g8238_i0 PRJDB14274 8316 220 1.484277 3.2654094 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 42.4 0.0387   NR XP_028397164.1 151771 g8238 i0 49 0.668181818181818 49 19 58.6 1 133 5 377 425 XP_028397164.1 translation initiation factor eIF-2B subunit epsilon-like [Dendronephthya gigantea] diamond 147 42.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
31891412 31891412 PRJDB14274_S_NODE_6297_length_251_cov_1.368421_g6219_i0 PRJDB14274 6297 251 1.368421 3.43473671 Metazoa 33208 Cnidaria other_Eukaryota 110 4.02e-26   NR XP_065652471.1 6087 g6219 i0 72.7 3.88446215139442 66 18 78.9 0 198 1 19 84 XP_065652471.1 NADH dehydrogenase [ubiquinone] flavoprotein 1, mitochondrial isoform X2 [Hydra vulgaris] diamond 975 110 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
32017972 32017972 PRJDB14274_S_NODE_6638_length_245_cov_1.711957_g6560_i0 PRJDB14274 6638 245 1.711957 4.19429465 Metazoa 33208 Cnidaria other_Eukaryota 70.5 4.14e-12   NR XP_022794276.1 50429 g6560 i0 54.1 5.28979591836735 61 28 74.7 0 55 237 135 195 XP_022794276.1 N-lysine methyltransferase KMT5A-like isoform X3 [Stylophora pistillata] diamond 1296 71.2 0.990168539325843 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata

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