RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA597223", tax_kingdom = "Metazoa" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 19 ✖

tax_kingdom 1

  • Metazoa · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA597223 · 19 ✖
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
8222309 8222309 PRJNA597223_P_NODE_38927_length_230_cov_2.343590_g37081_i0 PRJNA597223 38927 230 2.34359 5.390257 Hydra vulgaris 6087 Cnidaria other_Eukaryota 62.1 3.41e-5   NTclustered gi|2744866757|ref|XM_065800145.1| 6087 g37081 i0 94.872 0.304347826086957 39 2 17 0 94 132 539 577 PREDICTED: Hydra vulgaris procathepsin L (LOC100197138), transcript variant X2, mRNA blastn 70 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
12048170 12048170 PRJNA597223_P_NODE_35110_length_246_cov_4.417062_g33264_i0 PRJNA597223 35110 246 4.417062 10.86597252 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2782839894|ref|XM_067055043.1| 252671 g33264 i0 100 0.227642276422764 28 0 11 0 83 110 7961 7988 PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136798434), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
17147268 17147268 PRJNA597223_P_NODE_85954_length_152_cov_1.025641_g84108_i0 PRJNA597223 85954 152 1.025641 1.55897432 Acropora millepora 45264 Cnidaria other_Eukaryota 152 1.19e-32   NTclustered gi|2113819773|ref|XM_029331768.2| 45264 g84108 i0 84.768 55.1644736842105 151 23 99 0 2 152 769 619 PREDICTED: Acropora millepora endoplasmic reticulum chaperone BiP-like (LOC114955027), mRNA blastn 8385 152 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
20971367 20971367 PRJNA597223_P_NODE_42617_length_217_cov_2.587912_g40771_i0 PRJNA597223 42617 217 2.587912 5.61576904 Plumarella sp. 3126602 Cnidaria other_Eukaryota 130 8.610000000000001e-26   NTclustered gi|2689317335|gb|PP410763.1| 3126602 g40771 i0 85.484 34.3870967741936 124 18 57 0 85 208 1991 2114 Plumarella sp. voucher USNM:1606536 large subunit ribosomal RNA gene, partial sequence blastn 7462 130 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleralcyonacea Primnoidae Plumarella Plumarella sp.
22246356 22246356 PRJNA597223_P_NODE_52218_length_193_cov_1.101266_g50372_i0 PRJNA597223 52218 193 1.101266 2.12544338 Hydra vulgaris 6087 Cnidaria other_Eukaryota 89.8 1.27e-13   NTclustered gi|2744833237|ref|XM_047269120.2| 6087 g50372 i0 83 1.98445595854922 100 15 51 2 20 118 1133 1035 PREDICTED: Hydra vulgaris heat shock protein HSP 90-alpha (LOC101235897), mRNA blastn 383 89.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
23521299 23521299 PRJNA597223_P_NODE_27359_length_293_cov_6.170543_g25513_i0 PRJNA597223 27359 293 6.170543 18.07969099 Acropora formosa 126732 Cnidaria other_Eukaryota 82.4 3.47e-11   NTclustered gi|692518457|gb|KJ648506.1| 126732 g25513 i0 85.185 30.7645051194539 81 10 27 2 188 267 466 387 Acropora formosa isolate HN14 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 9014 82.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora formosa
24795668 24795668 PRJNA597223_P_NODE_82840_length_155_cov_0.925000_g80994_i0 PRJNA597223 82840 155 0.925 1.43375 Myxidium streisingeri 1542451 Cnidaria other_Eukaryota 270 3.23e-68   NTclustered gi|681870005|gb|KM001688.1| 1542451 g80994 i0 98.065 23.2451612903226 155 3 100 0 1 155 1949 2103 Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence blastn 3603 270 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxidiidae Myxidium Myxidium streisingeri
26763308 26763308 PRJNA597223_P_NODE_1701_length_1293_cov_6.421304_g130_i6 PRJNA597223 1701 1293 6.421304 83.02746072 Paramuricea clavata 317549 Cnidaria other_Eukaryota 154 1.1e-36   NR CAB4038998.1 317549 g130 i6 28.4 5.04176334106729 464 280 98.4 12 1274 3 276 727 CAB4038998.1 Retrovirus-related Pol poly from transposon, partial [Paramuricea clavata] diamond 6519 154 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
26984814 26984814 PRJNA597223_P_NODE_15862_length_419_cov_2.513021_g14062_i0 PRJNA597223 15862 419 2.513021 10.52955799 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 45.4 0.0262   NR XP_020893923.1 2652724 g14062 i0 51.7 1.2744630071599 29 14 20.8 0 186 100 343 371 XP_020893923.1 uncharacterized protein LOC110233022 [Exaiptasia diaphana] diamond 534 45.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
27282923 27282923 PRJNA597223_P_NODE_32163_length_262_cov_1.911894_g30317_i0 PRJNA597223 32163 262 1.911894 5.00916228 Metazoa 33208 Cnidaria other_Eukaryota 124 1.36e-30   NR XP_044178256.1 45264 g30317 i0 60 168.286259541985 85 34 97.3 0 261 7 652 736 XP_044178256.1 uncharacterized protein LOC122960249 [Acropora millepora] diamond 44091 125 0.992 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
27806582 27806582 PRJNA597223_P_NODE_66084_length_177_cov_2.056338_g64238_i0 PRJNA597223 66084 177 2.0563380000000002 3.63971826 Xenia sp. Carnegie-2 86540 Cnidaria other_Eukaryota 72.4 5.46e-13   NR XP_046847341.1 2897299 g64238 i0 65.2 0.779661016949153 46 16 78 0 138 1 672 717 XP_046847341.1 uncharacterized protein LOC124440960 [Xenia sp. Carnegie-2017] diamond 138 72.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
29303657 29303657 PRJNA597223_P_NODE_229_length_2740_cov_6.591497_g130_i2 PRJNA597223 229 2740 6.591497 180.6070178 Opisthokonta 33154 Cnidaria other_Eukaryota 228 1.55e-57   NR KII63648.1 669202 g130 i2 32.5 2.95948905109489 474 260 45.9 8 2737 1481 737 1205 KII63648.1 Transposon Ty3-I Gag-Pol polyprotein [Thelohanellus kitauei] diamond 8109 230 0.991304347826087 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Thelohanellus Thelohanellus kitauei
29429785 29429785 PRJNA597223_P_NODE_73709_length_165_cov_2.692308_g71863_i0 PRJNA597223 73709 165 2.692308 4.4423082 root 1 Root_unresolved Root_unresolved 77.8 1.99e-16   NR CAB4044927.1 317549 g71863 i0 64.7 3.72727272727273 51 18 92.7 0 8 160 28 78 CAB4044927.1 N6-adenine methyltransferase [Paramuricea clavata] diamond 615 77.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
30946439 30946439 PRJNA597223_P_NODE_69334_length_172_cov_1.167883_g67488_i0 PRJNA597223 69334 172 1.167883 2.00875876 Metazoa 33208 Cnidaria other_Eukaryota 84 4.14e-17   NR KAJ7387414.1 174260 g67488 i0 62.5 13.4127906976744 56 21 97.7 0 3 170 896 951 KAJ7387414.1 Vacuolar protein sorting-associated protein 33A [Desmophyllum pertusum] diamond 2307 84 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
31090896 31090896 PRJNA597223_P_NODE_64575_length_180_cov_1.613793_g62729_i0 PRJNA597223 64575 180 1.613793 2.9048274 Pocillopora meandrina 46732 Cnidaria other_Eukaryota 45.4 0.0018   NR CAH3105018.1 46732 g62729 i0 47.8 0.766666666666667 46 24 76.7 0 164 27 153 198 CAH3105018.1 unnamed protein product [Pocillopora meandrina] diamond 138 45.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Pocillopora Pocillopora meandrina
31325489 31325489 PRJNA597223_P_NODE_215_length_2806_cov_6.616384_g130_i1 PRJNA597223 215 2806 6.616384 185.65573504 Opisthokonta 33154 Cnidaria other_Eukaryota 228 1.97e-57   NR KII63648.1 669202 g130 i1 32.5 2.88987883107627 474 260 44.8 8 4 1260 737 1205 KII63648.1 Transposon Ty3-I Gag-Pol polyprotein [Thelohanellus kitauei] diamond 8109 230 0.991304347826087 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Thelohanellus Thelohanellus kitauei
31515574 31515574 PRJNA597223_P_NODE_796_length_1772_cov_5.727691_g130_i3 PRJNA597223 796 1772 5.727691 101.49468452 Opisthokonta 33154 Cnidaria other_Eukaryota 220 5.199999999999999e-58   NR KII72565.1 669202 g130 i3 32.6 4.52539503386005 439 255 68.2 7 1342 134 345 778 KII72565.1 hypothetical protein RF11_13262 [Thelohanellus kitauei] diamond 8019 220 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Myxobolidae Thelohanellus Thelohanellus kitauei
31547131 31547131 PRJNA597223_S_NODE_2736_length_187_cov_2.155405_g2679_i0 PRJNA597223 2736 187 2.155405 4.03060735 Opisthokonta 33154 Cnidaria other_Eukaryota 55.1 7.6e-7   NR KAK2556379.1 6130 g2679 i0 63.8 4.18716577540107 47 14 70.6 1 134 3 462 508 KAK2556379.1 Cell division control protein 42-like protein [Acropora cervicornis] diamond 783 55.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora cervicornis
31818160 31818160 PRJNA597223_P_NODE_22977_length_330_cov_4.023729_g21134_i0 PRJNA597223 22977 330 4.023729 13.2783057 Paramuricea clavata 317549 Cnidaria other_Eukaryota 56.2 1.84e-6   NR CAB3982733.1 317549 g21134 i0 36 1.39090909090909 86 51 78.2 2 298 41 237 318 CAB3982733.1 Transposon Ty3-G Gag-Pol poly [Paramuricea clavata] diamond 459 56.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata

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