RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1122875 · 13 ✖

analysis 1

  • blastn · 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
277870 277870 PRJNA1122875_P_NODE_47441_length_247_cov_0.885057_g47217_i0 PRJNA1122875 47441 247 0.885057 2.18609079 Hydra vulgaris 6087 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2744878905|ref|XM_065805702.1| 6087 g47217 i0 100 0.226720647773279 28 0 11 0 95 122 1004 977 PREDICTED: Hydra vulgaris uncharacterized LOC100203232 (LOC100203232), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
1551984 1551984 PRJNA1122875_P_NODE_12102_length_478_cov_1.953086_g11879_i0 PRJNA1122875 12102 478 1.953086 9.33575108 Stylophora pistillata 50429 Cnidaria other_Eukaryota 52.8 0.047   NTclustered gi|1270035183|ref|XM_022923491.1| 50429 g11879 i0 100 0.0585774058577406 28 0 6 0 21 48 1889 1916 PREDICTED: Stylophora pistillata flocculation protein FLO11-like (LOC111320794), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
2304085 2304085 PRJNA1122875_P_NODE_43082_length_251_cov_0.865169_g42858_i0 PRJNA1122875 43082 251 0.865169 2.17157419 Metazoa 33208 Cnidaria other_Eukaryota 54.7 0.006   NTclustered gi|2917940740|emb|OZ237567.1| 6108 g42858 i0 100 0.354581673306773 29 0 12 0 133 161 7855161 7855189 Anemonia sulcata genome assembly, chromosome: 13 blastn 89 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
4104793 4104793 PRJNA1122875_P_NODE_39444_length_264_cov_1.607330_g39220_i0 PRJNA1122875 39444 264 1.60733 4.2433512 Taxella eximia 1673623 Cnidaria other_Eukaryota 283 7.859999999999999e-72   NTclustered gi|1560754618|gb|MH155637.1| 1673623 g39220 i0 85.985 98.905303030303 264 37 100 0 1 264 292 29 Taxella eximia isolate MAL09-381 calmodulin gene, partial cds blastn 26111 283 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Aglaopheniidae Taxella Taxella eximia
6131615 6131615 PRJNA1122875_P_NODE_27665_length_313_cov_2.320833_g27441_i0 PRJNA1122875 27665 313 2.320833 7.26420729 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 180 1.29e-40   NTclustered gi|2917940693|emb|OZ237556.1| 6108 g27441 i0 81.944 28.0127795527157 216 35 68 4 100 313 1572146 1571933 Anemonia sulcata genome assembly, chromosome: 2 blastn 8768 180 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
6655823 6655823 PRJNA1122875_P_NODE_8186_length_571_cov_1.835341_g7968_i0 PRJNA1122875 8186 571 1.835341 10.47979711 Orbicella faveolata 48498 Cnidaria other_Eukaryota 62.1 9.36e-5   NTclustered gi|1176089628|ref|XM_020759535.1| 48498 g7968 i0 94.872 0.189141856392294 39 2 7 0 166 204 802 840 PREDICTED: Orbicella faveolata heterogeneous nuclear ribonucleoprotein K-like (LOC110053319), transcript variant X1, mRNA blastn 108 62.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
7930737 7930737 PRJNA1122875_P_NODE_46227_length_248_cov_0.880000_g46003_i0 PRJNA1122875 46227 248 0.88 2.1824 Eunicella cavolini 317547 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2918369535|emb|OZ237717.1| 317547 g46003 i0 100 0.112903225806452 28 0 11 0 122 149 21080213 21080186 Eunicella cavolini genome assembly, chromosome: 1 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
9956734 9956734 PRJNA1122875_P_NODE_21688_length_356_cov_2.416961_g21464_i0 PRJNA1122875 21688 356 2.416961 8.60438116 Ellisella 328399 Cnidaria other_Eukaryota 97.1 1.53e-15   NTclustered gi|2689317297|gb|PP410744.1| 2751895 g21464 i0 95.161 15.9129213483146 62 2 17 1 16 77 3588 3528 Ellisella elongata voucher USNM:1660444 large subunit ribosomal RNA gene, partial sequence blastn 5665 97.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleralcyonacea Ellisellidae Ellisella Ellisella elongata
14306416 14306416 PRJNA1122875_P_NODE_22932_length_347_cov_2.383212_g22708_i0 PRJNA1122875 22932 347 2.383212 8.26974564 Anemonia sulcata 6108 Cnidaria other_Eukaryota 54.7 0.009   NTclustered gi|2917940766|emb|OZ237573.1| 6108 g22708 i0 100 0.0835734870317003 29 0 8 0 93 121 8320375 8320403 Anemonia sulcata genome assembly, chromosome: 19 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
14306789 14306789 PRJNA1122875_P_NODE_53272_length_241_cov_1.375000_g53048_i0 PRJNA1122875 53272 241 1.375 3.31375 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 139 1.62e-28   NTclustered gi|1619657919|ref|XM_021048316.2| 2652724 g53048 i0 79.793 0.800829875518672 193 35 79 4 10 200 609 799 PREDICTED: Exaiptasia diaphana eukaryotic translation initiation factor 6 (LOC110242338), mRNA blastn 193 139 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
16331137 16331137 PRJNA1122875_P_NODE_23413_length_344_cov_1.704797_g23189_i0 PRJNA1122875 23413 344 1.704797 5.86450168 Campanulariidae 27800 Cnidaria other_Eukaryota 298 3.79e-76   NTclustered gi|62825405|gb|AY789839.1| 314509 g23189 i0 86.131 78.0552325581395 274 38 80 0 64 337 3 276 Orthopyxis integra voucher 454ca4 calmodulin gene, partial cds blastn 26851 298 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Campanulariidae Orthopyxis Orthopyxis integra
19403841 19403841 PRJNA1122875_P_NODE_8956_length_550_cov_2.230608_g8737_i0 PRJNA1122875 8956 550 2.230608 12.268344 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 195 8.5e-45   NTclustered gi|2782929037|ref|XM_067073665.1| 252671 g8737 i0 79.433 5.63636363636364 282 52 51 5 243 521 1163 885 PREDICTED: Clytia hemisphaerica calreticulin-like (LOC136817322), mRNA blastn 3100 195 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
20679364 20679364 PRJNA1122875_P_NODE_5997_length_649_cov_1.951389_g5784_i0 PRJNA1122875 5997 649 1.951389 12.66451461 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 58.4 0.001   NTclustered gi|2518958458|ref|XM_057461671.1| 13093 g5784 i0 97.059 0.104776579352851 34 1 5 0 312 345 2877 2844 PREDICTED: Hydractinia symbiolongicarpus trichohyalin-like (LOC130662747), transcript variant X2, mRNA blastn 68 58.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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