RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1123309" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1123309 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
8682271 8682271 PRJNA1123309_P_NODE_6467_length_581_cov_2.318898_g6109_i0 PRJNA1123309 6467 581 2.318898 13.47279738 root 1 Root_unresolved Root_unresolved 229 8.919999999999998e-69   NR XP_020614734.1 48498 g6109 i0 66.7 22.2702237521515 165 55 85.2 0 82 576 35 199 XP_020614734.1 propionyl-CoA carboxylase alpha chain, mitochondrial-like [Orbicella faveolata] diamond 12939 229 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
11756799 11756799 PRJNA1123309_P_NODE_33310_length_287_cov_1.327103_g32930_i0 PRJNA1123309 33310 287 1.327103 3.80878561 Opisthokonta 33154 Cnidaria other_Eukaryota 82.4 1.49e-16   NR XP_057289659.1 13093 g32930 i0 67.2 1.37979094076655 64 21 66.9 0 15 206 198 261 XP_057289659.1 60S ribosomal protein L7a-like [Hydractinia symbiolongicarpus] diamond 396 83.2 0.990384615384615 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
26658436 26658436 PRJNA1123309_P_NODE_17201_length_376_cov_1.402640_g16822_i0 PRJNA1123309 17201 376 1.40264 5.2739264 Dendronephthya gigantea 151771 Cnidaria other_Eukaryota 46.2 0.00977   NR XP_028410190.1 151771 g16822 i0 37.8 0.590425531914894 74 42 55.9 2 16 225 348 421 XP_028410190.1 ranBP-type and C3HC4-type zinc finger-containing protein 1-like [Dendronephthya gigantea] diamond 222 46.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
26785542 26785542 PRJNA1123309_P_NODE_12581_length_430_cov_1.100840_g12205_i0 PRJNA1123309 12581 430 1.10084 4.733612 Orbicella faveolata 48498 Cnidaria other_Eukaryota 154 5.3e-42   NR XP_020609917.1 48498 g12205 i0 50.3 0.997674418604651 143 68 98.4 3 1 423 15 156 XP_020609917.1 nucleoredoxin-like [Orbicella faveolata] diamond 429 154 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
26975218 26975218 PRJNA1123309_P_NODE_24882_length_322_cov_1.823293_g24502_i0 PRJNA1123309 24882 322 1.823293 5.87100346 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 52.8 2.7e-5   NR KXJ25354.1 2652724 g24502 i0 43.9 1.91925465838509 66 34 59.6 2 310 119 105 169 KXJ25354.1 Venom prothrombin activator oscutarin-C non-catalytic subunit [Exaiptasia diaphana] diamond 618 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
27070145 27070145 PRJNA1123309_P_NODE_23522_length_330_cov_1.564202_g23143_i0 PRJNA1123309 23522 330 1.564202 5.1618666 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 54.7 6.23e-6   NR KAJ7387199.1 174260 g23143 i0 38 1.56363636363636 92 49 83.6 2 36 311 399 482 KAJ7387199.1 hypothetical protein OS493_004169 [Desmophyllum pertusum] diamond 516 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
28070087 28070087 PRJNA1123309_P_NODE_1785_length_993_cov_1.831522_g1550_i0 PRJNA1123309 1785 993 1.831522 18.18701346 Scleractinia 6125 Cnidaria other_Eukaryota 338 3.89e-108   NR XP_022796521.1 50429 g1550 i0 56.5 3.85498489425982 322 128 96.7 4 985 26 272 583 XP_022796521.1 NADP-dependent malic enzyme-like isoform X1 [Stylophora pistillata] diamond 3828 339 0.997050147492625 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
28965125 28965125 PRJNA1123309_P_NODE_17688_length_372_cov_0.936455_g17309_i0 PRJNA1123309 17688 372 0.936455 3.4836126 Nematostella vectensis 45351 Cnidaria other_Eukaryota 70.9 2.05e-11   NR EDO46141.1 45351 g17309 i0 45.8 1.25 96 44 71 1 109 372 95 190 EDO46141.1 predicted protein, partial [Nematostella vectensis] diamond 465 70.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
29080561 29080561 PRJNA1123309_P_NODE_19228_length_359_cov_2.653846_g18849_i0 PRJNA1123309 19228 359 2.653846 9.52730714 Montipora 46703 Cnidaria other_Eukaryota 50.1 3.58e-4   NR XP_068739685.1 246305 g18849 i0 51.9 1.57103064066852 52 24 43.5 1 245 90 406 456 XP_068739685.1 tripartite motif-containing protein 3-like [Montipora capricornis] diamond 564 50.4 0.994047619047619 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
29249009 29249009 PRJNA1123309_P_NODE_20509_length_350_cov_1.061372_g20130_i0 PRJNA1123309 20509 350 1.061372 3.714802 Hydra vulgaris 6087 Cnidaria other_Eukaryota 48.1 0.00171   NR XP_065661936.1 6087 g20130 i0 25.7 0.968571428571429 113 61 90.9 4 335 18 1863 1959 XP_065661936.1 uncharacterized protein LOC136084821 [Hydra vulgaris] diamond 339 48.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
29333091 29333091 PRJNA1123309_P_NODE_44669_length_259_cov_0.962366_g44289_i0 PRJNA1123309 44669 259 0.962366 2.49252794 Scleractinia 6125 Cnidaria other_Eukaryota 58.5 1.23e-7   NR XP_015765774.1 70779 g44289 i0 42.6 9.11583011583012 61 33 70.7 1 184 2 441 499 XP_015765774.1 PREDICTED: sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like isoform X2 [Acropora digitifera] diamond 2361 58.9 0.99320882852292 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora digitifera
30249210 30249210 PRJNA1123309_P_NODE_44532_length_259_cov_1.392473_g44152_i0 PRJNA1123309 44532 259 1.392473 3.60650507 Acropora 6127 Cnidaria other_Eukaryota 56.6 5.73e-7   NR XP_029191963.2 45264 g44152 i0 47.2 1.22779922779923 53 27 60.2 1 257 102 88 140 XP_029191963.2 TRAF-type zinc finger domain-containing protein 1-like [Acropora millepora] diamond 318 56.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
30975798 30975798 PRJNA1123309_P_NODE_23834_length_328_cov_1.839216_g23454_i0 PRJNA1123309 23834 328 1.839216 6.03262848 Acropora 6127 Cnidaria other_Eukaryota 55.8 2.36e-6   NR KAK2567112.1 6130 g23454 i0 42.6 1.24390243902439 68 33 59.5 2 299 105 405 469 KAK2567112.1 putative ankyrin repeat protein [Acropora cervicornis] diamond 408 55.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis

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