RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB6584 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
26205815 26205815 PRJEB6584o_S_NODE_6494_length_328_cov_5.539249_g6386_i0 PRJEB6584 6494 328 5.539249 18.16873672 Cnidaria 6073 Cnidaria other_Eukaryota 141 2.59e-39   NR XP_028405051.1 151771 g6386 i0 66.3 19.1707317073171 95 32 86.9 0 323 39 149 243 XP_028405051.1 60S ribosomal protein L7-like [Dendronephthya gigantea] diamond 6288 141 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Nephtheidae Dendronephthya Dendronephthya gigantea
32922998 32922998 PRJEB6584h_S_NODE_8217_length_213_cov_4.668539_g8155_i0 PRJEB6584 8217 213 4.668539 9.94398807 Scleractinia 6125 Cnidaria other_Eukaryota 42.7 0.00462   NR XP_027042795.1 46731 g8155 i0 43.9 2.30985915492958 41 23 57.7 0 213 91 43 83 XP_027042795.1 migration and invasion enhancer 1-like, partial [Pocillopora damicornis] diamond 492 42.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora damicornis
32997589 32997589 PRJEB6584o_S_NODE_11875_length_255_cov_1.618182_g11767_i0 PRJEB6584 11875 255 1.618182 4.1263641 Montipora capricornis 246305 Cnidaria other_Eukaryota 60.5 2.6e-8   NR XP_068749137.1 246305 g11767 i0 53.5 1.58823529411765 43 20 50.6 0 222 94 1560 1602 XP_068749137.1 LOW QUALITY PROTEIN: uncharacterized protein [Montipora capricornis] diamond 405 60.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora capricornis
33008493 33008493 PRJEB6584e_S_NODE_3899_length_157_cov_4.745902_g3884_i0 PRJEB6584 3899 157 4.745902 7.45106614 Metazoa 33208 Cnidaria other_Eukaryota 76.6 8.05e-15   NR XP_031556577.1 6105 g3884 i0 77.5 5.3312101910828 40 9 76.4 0 2 121 293 332 XP_031556577.1 cathepsin B-like [Actinia tenebrosa] diamond 837 77 0.994805194805195 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
33008495 33008495 PRJEB6584h_S_NODE_1419_length_362_cov_4.107034_g1357_i0 PRJEB6584 1419 362 4.107034 14.86746308 Metazoa 33208 Cnidaria other_Eukaryota 155 1.4699999999999999e-43   NR CAH3152047.1 46732 g1357 i0 84.8 8.50276243093923 79 12 65.5 0 1 237 258 336 CAH3152047.1 unnamed protein product [Pocillopora meandrina] diamond 3078 155 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora meandrina
33082750 33082750 PRJEB6584h_S_NODE_8238_length_213_cov_1.443820_g8176_i0 PRJEB6584 8238 213 1.44382 3.0753366 Hydra vulgaris 6087 Cnidaria other_Eukaryota 68.9 1.47e-11   NR XP_047142319.2 6087 g8176 i0 59.2 3.14084507042254 71 20 88.7 3 190 2 2070 2139 XP_047142319.2 uncharacterized protein LOC105845986 [Hydra vulgaris] diamond 669 68.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
33151318 33151318 PRJEB6584o_S_NODE_24712_length_190_cov_1.425806_g24604_i0 PRJEB6584 24712 190 1.425806 2.7090314 Montipora foliosa 591990 Cnidaria other_Eukaryota 45.4 0.00205   NR XP_068697267.1 591990 g24604 i0 42.2 0.710526315789474 45 26 71.1 0 7 141 308 352 XP_068697267.1 uncharacterized protein [Montipora foliosa] diamond 135 45.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Montipora Montipora foliosa
33179293 33179293 PRJEB6584o_S_NODE_1568_length_514_cov_54.766180_g1489_i0 PRJEB6584 1568 514 54.76618 281.4981652 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 110 7.91e-28   NR XP_031554634.1 6105 g1489 i0 63.6 6.74124513618677 99 35 57.2 1 500 207 1 99 XP_031554634.1 60S ribosomal protein L36-like [Actinia tenebrosa] diamond 3465 110 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa

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