RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB20058 · 15 ✖

analysis 1

  • diamond · 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
26292505 26292505 PRJEB20058_P_NODE_121390_length_362_cov_1.946844_g118573_i0 PRJEB20058 121390 362 1.946844 7.04757528 Metazoa 33208 Cnidaria other_Eukaryota 123 9.93e-34   NR XP_029186813.1 45264 g118573 i0 71.1 6.38950276243094 90 26 74.6 0 54 323 18 107 XP_029186813.1 40S ribosomal protein S25-like [Acropora millepora] diamond 2313 124 0.991935483870968 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
32910637 32910637 PRJEB20058_P_NODE_14945_length_1073_cov_6.993083_g13147_i0 PRJEB20058 14945 1073 6.993083 75.03578059 Nematostella vectensis 45351 Cnidaria other_Eukaryota 94.7 5.87e-18   NR XP_032239045.2 45351 g13147 i0 24.6 0.841565703634669 301 185 80.8 9 1018 152 42 312 XP_032239045.2 uncharacterized protein LOC5513669 [Nematostella vectensis] diamond 903 94.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
32911485 32911485 PRJEB20058_P_NODE_77569_length_471_cov_2.385366_g74789_i0 PRJEB20058 77569 471 2.385366 11.23507386 Stylophora pistillata 50429 Cnidaria other_Eukaryota 66.2 2.57e-9   NR PFX31755.1 50429 g74789 i0 31.8 5.00636942675159 154 102 96.2 3 457 5 22 175 PFX31755.1 putative RNA-directed DNA polymerase from transposon X-element [Stylophora pistillata] diamond 2358 66.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
32928569 32928569 PRJEB20058_P_NODE_61153_length_535_cov_45.989451_g58391_i0 PRJEB20058 61153 535 45.989451 246.04356285 Paramuricea clavata 317549 Cnidaria other_Eukaryota 69.7 2.63e-10   NR CAB4015551.1 317549 g58391 i0 39.6 1.67102803738318 149 78 77.4 6 57 470 114 261 CAB4015551.1 Hypothetical predicted protein [Paramuricea clavata] diamond 894 69.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
32939956 32939956 PRJEB20058_P_NODE_127561_length_350_cov_3.840830_g124742_i0 PRJEB20058 127561 350 3.84083 13.442905 Metazoa 33208 Cnidaria other_Eukaryota 104 3.1599999999999996e-23   NR XP_031554092.1 6105 g124742 i0 47.7 13.32 107 56 91.7 0 326 6 543 649 XP_031554092.1 solute carrier family 49 member 4 homolog [Actinia tenebrosa] diamond 4662 104 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
32962881 32962881 PRJEB20058_P_NODE_50954_length_589_cov_2.481061_g48223_i0 PRJEB20058 50954 589 2.481061 14.61344929 Anemonia viridis 51769 Cnidaria other_Eukaryota 76.6 2.03e-13   NR AOW71502.1 51769 g48223 i0 45.8 2.54668930390492 96 35 48.4 2 67 351 107 186 AOW71502.1 gluthatione peroxidase [Anemonia viridis] diamond 1500 76.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia viridis
32991495 32991495 PRJEB20058_P_NODE_241739_length_211_cov_12.793333_g238914_i0 PRJEB20058 241739 211 12.793333 26.99393263 Metazoa 33208 Cnidaria other_Eukaryota 47 7.91e-4   NR XP_031551517.1 6105 g238914 i0 51.3 4.09478672985782 39 18 55.5 1 37 153 41 78 XP_031551517.1 sodium- and chloride-dependent GABA transporter 3-like [Actinia tenebrosa] diamond 864 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
32996560 32996560 PRJEB20058_P_NODE_222587_length_241_cov_1.027778_g219762_i0 PRJEB20058 222587 241 1.027778 2.47694498 Paramuricea clavata 317549 Cnidaria other_Eukaryota 99.4 4.03e-22   NR CAB3993334.1 317549 g219762 i0 54.4 14.4522821576763 79 36 98.3 0 3 239 214 292 CAB3993334.1 Transposon Tf2-6 poly [Paramuricea clavata] diamond 3483 99.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
33008244 33008244 PRJEB20058_P_NODE_128123_length_349_cov_4.072917_g125304_i0 PRJEB20058 128123 349 4.072917 14.21448033 root 1 Root_unresolved Root_unresolved 47 0.00161   NR XP_057309642.1 13093 g125304 i0 36.4 5.25214899713467 55 35 47.3 0 180 344 93 147 XP_057309642.1 protein phosphatase 1 regulatory subunit 27-like isoform X2 [Hydractinia symbiolongicarpus] diamond 1833 47 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus
33008384 33008384 PRJEB20058_P_NODE_43723_length_636_cov_2.841739_g41052_i0 PRJEB20058 43723 636 2.841739 18.07346004 Pocilloporidae 46729 Cnidaria other_Eukaryota 112 1.29e-24   NR XP_027046674.1 46731 g41052 i0 46 2.66509433962264 113 57 53.3 1 465 127 119 227 XP_027046674.1 uncharacterized protein LOC113674391 [Pocillopora damicornis] diamond 1695 112 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
33025592 33025592 PRJEB20058_P_NODE_248828_length_197_cov_4.088235_g246003_i0 PRJEB20058 248828 197 4.088235 8.05382295 root 1 Root_unresolved Root_unresolved 63.5 9.19e-10   NR RMX40327.1 46731 g246003 i0 52.6 9.67005076142132 57 27 86.8 0 19 189 100 156 RMX40327.1 hypothetical protein pdam_00008706 [Pocillopora damicornis] diamond 1905 63.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
33047506 33047506 PRJEB20058_P_NODE_186077_length_269_cov_3.298077_g183254_i0 PRJEB20058 186077 269 3.298077 8.87182713 Hydra vulgaris 6087 Cnidaria other_Eukaryota 60.5 2.87e-8   NR XP_065643996.1 6087 g183254 i0 51.7 1.29368029739777 58 28 64.7 0 252 79 434 491 XP_065643996.1 uncharacterized protein LOC136075292 [Hydra vulgaris] diamond 348 60.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
33059621 33059621 PRJEB20058_P_NODE_97893_length_412_cov_13.578348_g95090_i0 PRJEB20058 97893 412 13.578348 55.94279376 Opisthokonta 33154 Cnidaria other_Eukaryota 113 9.999999999999999e-29   NR KAK2565893.1 6130 g95090 i0 62.3 11.6577669902913 106 39 77.2 1 22 339 62 166 KAK2565893.1 60S ribosomal protein L35 [Acropora cervicornis] diamond 4803 114 0.991228070175439 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
33081809 33081809 PRJEB20058_P_NODE_21366_length_900_cov_3.821216_g19246_i0 PRJEB20058 21366 900 3.821216 34.390944 Hydra vulgaris 6087 Cnidaria other_Eukaryota 60.8 3.36e-6   NR XP_047123111.2 6087 g19246 i0 61 0.136666666666667 41 16 13.7 0 21 143 748 788 XP_047123111.2 uncharacterized protein LOC105846128, partial [Hydra vulgaris] diamond 123 60.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
33178997 33178997 PRJEB20058_P_NODE_128504_length_348_cov_11.895470_g125685_i0 PRJEB20058 128504 348 11.89547 41.3962356 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 125 3.5e-31   NR XP_027043449.1 46731 g125685 i0 57 2.37068965517241 100 38 81.9 1 335 51 369 468 XP_027043449.1 DNA polymerase delta subunit 2-like [Pocillopora damicornis] diamond 825 126 0.992063492063492 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis

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