RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1101946" 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

  • PRJNA1101946 · 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
9138919 9138919 PRJNA1101946_S_NODE_9368_length_253_cov_105.794118_g9269_i0 PRJNA1101946 9368 253 105.794118 267.65911854 root 1 Root_unresolved Root_unresolved 67.8 1.66e-11   NR 3U0K_B 6118 g9269 i0 64.3 3.3201581027668 56 20 66.4 0 168 1 1 56 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 840 68.2 0.994134897360704 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
14240024 14240024 PRJNA1101946_S_NODE_1572_length_424_cov_6.293333_g1473_i0 PRJNA1101946 1572 424 6.293333 26.68373192 root 1 Root_unresolved Root_unresolved 77 3.46e-14   NR 3U0K_B 6118 g1473 i0 70.4 2.66745283018868 54 16 38.2 0 243 404 1 54 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 1131 77.4 0.994832041343669 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
27185259 27185259 PRJNA1101946_S_NODE_9382_length_253_cov_41.225490_g9283_i0 PRJNA1101946 9382 253 41.22549 104.3004897 root 1 Root_unresolved Root_unresolved 57.4 1.39e-7   NR 3U0K_B 6118 g9283 i0 67.9 3.3201581027668 56 18 66.4 0 86 253 1 56 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 840 57.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
27848510 27848510 PRJNA1101946_S_NODE_24284_length_163_cov_21.894737_g24185_i0 PRJNA1101946 24284 163 21.894737 35.68842131 root 1 Root_unresolved Root_unresolved 89.7 3.24e-20   NR 3EVP_A 6100 g24185 i0 75.9 586.380368098159 54 13 99.4 0 162 1 176 229 3EVP_A Chain A, Green fluorescent protein,Green fluorescent protein [Aequorea victoria] diamond 95580 90.5 0.991160220994475 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Aequoreidae Aequorea Aequorea victoria
28006772 28006772 PRJNA1101946_S_NODE_16425_length_198_cov_27.765101_g16326_i0 PRJNA1101946 16425 198 27.765101 54.974899980000004 root 1 Root_unresolved Root_unresolved 53.5 1.86e-6   NR 3U0K_B 6118 g16326 i0 73 3.92424242424242 37 10 56.1 0 113 3 1 37 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 777 53.9 0.992578849721707 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
28417161 28417161 PRJNA1101946_S_NODE_12066_length_229_cov_4.788889_g11967_i0 PRJNA1101946 12066 229 4.788889 10.96655581 root 1 Root_unresolved Root_unresolved 46.2 0.00141   NR 3U0K_B 6118 g11967 i0 55.3 3.07860262008734 47 21 61.6 0 89 229 1 47 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 705 46.6 0.991416309012876 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
28552127 28552127 PRJNA1101946_S_NODE_13827_length_216_cov_4.035928_g13728_i0 PRJNA1101946 13827 216 4.035928 8.71760448 Paramuricea clavata 317549 Cnidaria other_Eukaryota 45.4 0.00144   NR CAB4019895.1 317549 g13728 i0 45.2 3.95833333333333 42 23 58.3 0 212 87 26 67 CAB4019895.1 Hypothetical predicted protein, partial [Paramuricea clavata] diamond 855 45.8 0.991266375545852 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Plexauridae Paramuricea Paramuricea clavata
28732805 28732805 PRJNA1101946_S_NODE_11707_length_232_cov_5.934426_g11608_i0 PRJNA1101946 11707 232 5.934426 13.76786832 root 1 Root_unresolved Root_unresolved 64.3 2.64e-10   NR 3U0K_B 6118 g11608 i0 62.3 3.42672413793103 53 20 68.5 0 73 231 1 53 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 795 64.7 0.993817619783617 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
28732807 28732807 PRJNA1101946_S_NODE_8667_length_261_cov_4.905660_g8568_i0 PRJNA1101946 8667 261 4.90566 12.8037726 root 1 Root_unresolved Root_unresolved 44.3 0.0104   NR 3U0K_B 6118 g8568 i0 83.3 1.93103448275862 24 4 27.6 0 72 1 29 52 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 504 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
30153490 30153490 PRJNA1101946_S_NODE_8532_length_262_cov_13.553991_g8433_i0 PRJNA1101946 8532 262 13.553991 35.51145642 root 1 Root_unresolved Root_unresolved 62.4 2.05e-9   NR 3U0K_B 6118 g8433 i0 67.9 3.83587786259542 56 18 64.1 0 95 262 1 56 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 1005 62.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
30280571 30280571 PRJNA1101946_S_NODE_7232_length_278_cov_4.480349_g7133_i0 PRJNA1101946 7232 278 4.480349 12.45537022 root 1 Root_unresolved Root_unresolved 58.5 6.85e-8   NR 3U0K_B 6118 g7133 i0 67.3 3.49640287769784 52 17 56.1 0 123 278 1 52 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 972 58.5 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor
30975354 30975354 PRJNA1101946_S_NODE_10674_length_241_cov_3.453125_g10575_i0 PRJNA1101946 10674 241 3.453125 8.32203125 root 1 Root_unresolved Root_unresolved 44.3 0.0105   NR PFX21664.1 50429 g10575 i0 42.2 1.0207468879668 45 26 56 0 181 47 230 274 PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] diamond 246 44.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
32745774 32745774 PRJNA1101946_S_NODE_16420_length_198_cov_38.476510_g16321_i0 PRJNA1101946 16420 198 38.47651 76.1834898 root 1 Root_unresolved Root_unresolved 51.2 1.34e-5   NR 3U0K_B 6118 g16321 i0 67.6 3.92424242424242 37 12 56.1 0 86 196 1 37 3U0K_B Chain B, RCaMP [Entacmaea quadricolor] diamond 777 51.6 0.992248062015504 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Entacmaea Entacmaea quadricolor

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