RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1108009", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 14 ✖

tax_kingdom 1

  • Metazoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA1108009 · 14 ✖

analysis 1

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
6590859 6590859 PRJNA1108009_P_NODE_14326_length_349_cov_1.101449_g14008_i0 PRJNA1108009 14326 349 1.101449 3.84405701 Opisthokonta 33154 Porifera other_Eukaryota 129 1.6e-35   NR XP_062516624.1 121492 g14008 i0 59 46.2893982808023 105 41 88.5 1 310 2 11 115 XP_062516624.1 uncharacterized protein LOC134191983 [Corticium candelabrum] diamond 16155 129 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
9140299 9140299 PRJNA1108009_P_NODE_11688_length_392_cov_0.877743_g11370_i0 PRJNA1108009 11688 392 0.877743 3.44075256 Metazoa 33208 Porifera other_Eukaryota 190 6.049999999999998e-56   NR XP_065827325.1 121494 g11370 i0 75.4 20.5790816326531 118 29 90.3 0 1 354 316 433 XP_065827325.1 adenosylhomocysteinase B-like [Oscarella lobularis] diamond 8067 191 0.994764397905759 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
15048143 15048143 PRJNA1108009_P_NODE_12272_length_381_cov_1.730519_g11954_i0 PRJNA1108009 12272 381 1.730519 6.59327739 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 171 2.02e-50   NR AAX48880.1 55567 g11954 i0 61.1 17.8582677165354 126 49 99.2 0 380 3 123 248 AAX48880.1 S4 [Suberites domuncula] diamond 6804 172 0.994186046511628 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
15048207 15048207 PRJNA1108009_P_NODE_26512_length_249_cov_0.875000_g26194_i0 PRJNA1108009 26512 249 0.875 2.17875 Opisthokonta 33154 Porifera other_Eukaryota 115 3.83e-29   NR BAA81700.1 31330 g26194 i0 65.1 15.7831325301205 83 28 98.8 1 249 4 124 206 BAA81700.1 G protein a subunit 4, partial [Ephydatia fluviatilis] diamond 3930 116 0.991379310344828 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia fluviatilis
18064399 18064399 PRJNA1108009_P_NODE_13895_length_354_cov_2.316726_g13577_i0 PRJNA1108009 13895 354 2.316726 8.20121004 Oscarella lobularis 121494 Porifera other_Eukaryota 154 7.739999999999999e-43   NR XP_065832878.1 121494 g13577 i0 64.5 3.02542372881356 121 38 98.3 4 6 353 190 310 XP_065832878.1 cathepsin B-like cysteine proteinase 4 [Oscarella lobularis] diamond 1071 154 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
27099263 27099263 PRJNA1108009_P_NODE_28622_length_245_cov_1.343023_g28304_i0 PRJNA1108009 28622 245 1.343023 3.29040635 Amphimedon queenslandica 400682 Porifera other_Eukaryota 108 2.21e-25   NR XP_011406795.1 400682 g28304 i0 78.3 1.45714285714286 60 13 73.5 0 245 66 229 288 XP_011406795.1 PREDICTED: uncharacterized protein LOC100632176 [Amphimedon queenslandica] diamond 357 108 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28394087 28394087 PRJNA1108009_P_NODE_24586_length_251_cov_1.443820_g24268_i0 PRJNA1108009 24586 251 1.44382 3.6239882 Dysidea avara 196820 Porifera other_Eukaryota 74.3 3.1e-13   NR XP_065906674.1 196820 g24268 i0 42.9 0.920318725099602 77 44 92 0 235 5 577 653 XP_065906674.1 krev interaction trapped protein 1-like [Dysidea avara] diamond 231 74.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29364394 29364394 PRJNA1108009_P_NODE_23649_length_258_cov_1.664865_g23331_i0 PRJNA1108009 23649 258 1.664865 4.2953517 Metazoa 33208 Porifera other_Eukaryota 117 7.239999999999999e-32   NR AAX48900.1 55567 g23331 i0 66.7 12.6976744186047 84 28 97.7 0 254 3 6 89 AAX48900.1 S24 [Suberites domuncula] diamond 3276 117 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
30668000 30668000 PRJNA1108009_P_NODE_26793_length_248_cov_0.880000_g26475_i0 PRJNA1108009 26793 248 0.88 2.1824 Oscarella lobularis 121494 Porifera other_Eukaryota 48.1 5.11e-4   NR XP_065843584.1 121494 g26475 i0 51.1 0.544354838709677 45 20 54.4 2 82 216 173 215 XP_065843584.1 neurogenic locus Notch protein-like [Oscarella lobularis] diamond 135 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
30762902 30762902 PRJNA1108009_P_NODE_23134_length_262_cov_1.925926_g22816_i0 PRJNA1108009 23134 262 1.925926 5.04592612 Halichondria panicea 6063 Porifera other_Eukaryota 106 1.88e-24   NR XP_064383636.1 6063 g22816 i0 59.5 0.904580152671756 79 30 90.5 1 2 238 147 223 XP_064383636.1 uncharacterized protein LOC135332200 [Halichondria panicea] diamond 237 106 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30952564 30952564 PRJNA1108009_P_NODE_18014_length_306_cov_1.321888_g17696_i0 PRJNA1108009 18014 306 1.321888 4.04497728 Geodia cydonium 6047 Porifera other_Eukaryota 103 4.18e-24   NR CAA71554.1 6047 g17696 i0 54 0.980392156862745 100 45 98 1 5 304 64 162 CAA71554.1 cathepsin [Geodia cydonium] diamond 300 103 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia cydonium
31363458 31363458 PRJNA1108009_P_NODE_31516_length_241_cov_0.916667_g31198_i0 PRJNA1108009 31516 241 0.916667 2.20916747 Oscarella lobularis 121494 Porifera other_Eukaryota 59.3 4.97e-8   NR XP_065837297.1 121494 g31198 i0 41.5 3.06224066390041 82 42 98.3 2 5 241 249 327 XP_065837297.1 uncharacterized protein [Oscarella lobularis] diamond 738 59.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32439184 32439184 PRJNA1108009_P_NODE_6119_length_564_cov_2.706721_g5807_i0 PRJNA1108009 6119 564 2.706721 15.26590644 Geodia barretti 519541 Porifera other_Eukaryota 146 6.39e-41   NR CAI8030757.1 519541 g5807 i0 51.2 0.882978723404255 166 66 84.6 6 490 14 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 498 146 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32745808 32745808 PRJNA1108009_P_NODE_22900_length_264_cov_1.612565_g22582_i0 PRJNA1108009 22900 264 1.612565 4.2571716 Opisthokonta 33154 Porifera other_Eukaryota 53.5 7.6e-6   NR XP_065883749.1 196820 g22582 i0 39.7 2.53409090909091 73 43 81.8 1 27 242 715 787 XP_065883749.1 N-alpha-acetyltransferase 15, NatA auxiliary subunit-like [Dysidea avara] diamond 669 53.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara

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