RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA597223 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
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);;