RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1108487", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Porifera · 19 ✖

tax_kingdom 1

  • Metazoa · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1108487 · 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
4848623 4848623 PRJNA1108487_P_NODE_8024_length_257_cov_1.641304_g7958_i0 PRJNA1108487 8024 257 1.641304 4.21815128 Tethyida 1779163 Porifera other_Eukaryota 141 4.85e-29   NTclustered gi|147931669|gb|AY626308.2| 283613 g7958 i0 94.505 35.3968871595331 91 5 35 0 6 96 2390 2300 Axos cliftoni voucher G300111 28S large subunit ribosomal RNA gene, complete sequence blastn 9097 141 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tethyida Hemiasterellidae Axos Axos cliftoni
13773858 13773858 PRJNA1108487_P_NODE_351_length_1024_cov_2.234490_g307_i0 PRJNA1108487 351 1024 2.23449 22.8811776 Amphimedon queenslandica 400682 Porifera other_Eukaryota 138 3.45e-35   NR XP_003384181.1 400682 g307 i0 35.8 0.5888671875 201 117 58.9 4 267 869 31 219 XP_003384181.1 PREDICTED: probable GH family 25 lysozyme 2 [Amphimedon queenslandica] diamond 603 138 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
16323114 16323114 PRJNA1108487_P_NODE_6653_length_279_cov_1.131068_g6587_i0 PRJNA1108487 6653 279 1.131068 3.15567972 Homosclerophorida 81000 Porifera other_Eukaryota 103 1.73e-23   NR XP_062517183.1 121492 g6587 i0 55.4 1.90322580645161 92 41 98.9 0 277 2 740 831 XP_062517183.1 uncharacterized protein LOC134192460 [Corticium candelabrum] diamond 531 103 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27059012 27059012 PRJNA1108487_P_NODE_10562_length_244_cov_1.824561_g10496_i0 PRJNA1108487 10562 244 1.824561 4.45192884 Opisthokonta 33154 Porifera other_Eukaryota 50.1 9.5e-5   NR XP_065889521.1 196820 g10496 i0 55.6 0.959016393442623 36 16 44.3 0 108 1 13 48 XP_065889521.1 mRNA export factor-like [Dysidea avara] diamond 234 50.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27162331 27162331 PRJNA1108487_P_NODE_2182_length_459_cov_1.191710_g2116_i0 PRJNA1108487 2182 459 1.19171 5.4699489 Amphimedon queenslandica 400682 Porifera other_Eukaryota 112 5.06e-26   NR XP_003383100.1 400682 g2116 i0 49.5 0.712418300653595 109 53 69.9 1 19 339 185 293 XP_003383100.1 PREDICTED: uncharacterized protein LOC100635885 [Amphimedon queenslandica] diamond 327 112 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28204530 28204530 PRJNA1108487_P_NODE_2486_length_430_cov_1.700280_g2420_i0 PRJNA1108487 2486 430 1.70028 7.311204 Corticium candelabrum 121492 Porifera other_Eukaryota 148 1.2899999999999999e-39   NR XP_062502257.1 121492 g2420 i0 56.3 0.941860465116279 135 53 94.2 2 430 26 289 417 XP_062502257.1 histone acetyltransferase KAT8-like [Corticium candelabrum] diamond 405 148 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29435807 29435807 PRJNA1108487_P_NODE_3750_length_356_cov_1.102473_g3684_i0 PRJNA1108487 3750 356 1.102473 3.92480388 Oscarella lobularis 121494 Porifera other_Eukaryota 84.3 1.05e-16   NR XP_065836391.1 121494 g3684 i0 46.9 0.682584269662921 81 43 68.3 0 105 347 66 146 XP_065836391.1 2-oxoglutarate and iron-dependent oxygenase domain-containing protein 3-like [Oscarella lobularis] diamond 243 84.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29553471 29553471 PRJNA1108487_P_NODE_1070_length_639_cov_12.181979_g1007_i0 PRJNA1108487 1070 639 12.181979 77.84284581 Porifera 6040 Porifera other_Eukaryota 174 1.6e-51   NR XP_062508348.1 121492 g1007 i0 70.9 5.9906103286385 127 37 59.6 0 202 582 36 162 XP_062508348.1 large ribosomal subunit protein uL23-like [Corticium candelabrum] diamond 3828 175 0.994285714285714 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29814909 29814909 PRJNA1108487_P_NODE_1831_length_499_cov_2.464789_g1765_i0 PRJNA1108487 1831 499 2.464789 12.29929711 Geodia barretti 519541 Porifera other_Eukaryota 84.7 4.37e-17   NR CAI8030757.1 519541 g1765 i0 51.1 0.541082164328657 90 35 51.1 3 243 497 78 163 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 270 84.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29837779 29837779 PRJNA1108487_P_NODE_6051_length_291_cov_1.197248_g5985_i0 PRJNA1108487 6051 291 1.197248 3.48399168 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 83.6 2.98e-16   NR XP_065902060.1 196820 g5985 i0 44.2 4.84536082474227 95 48 93.8 2 283 11 737 830 XP_065902060.1 uncharacterized protein [Dysidea avara] diamond 1410 84.3 0.991696322657177 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29972938 29972938 PRJNA1108487_P_NODE_1291_length_586_cov_2.040936_g1226_i0 PRJNA1108487 1291 586 2.040936 11.95988496 Oscarella lobularis 121494 Porifera other_Eukaryota 180 8.29e-49   NR XP_065830064.1 121494 g1226 i0 53.3 4.66382252559727 182 73 89.1 6 523 2 1 178 XP_065830064.1 protein DD3-3-like [Oscarella lobularis] diamond 2733 180 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
30225654 30225654 PRJNA1108487_P_NODE_4392_length_333_cov_0.896154_g4326_i0 PRJNA1108487 4392 333 0.896154 2.98419282 Oscarella lobularis 121494 Porifera other_Eukaryota 128 6.899999999999999e-32   NR XP_065826338.1 121494 g4326 i0 55.6 1.78378378378378 99 40 89.2 1 329 33 146 240 XP_065826338.1 alpha-glucosidase 2-like isoform X2 [Oscarella lobularis] diamond 594 128 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
30984161 30984161 PRJNA1108487_P_NODE_494_length_903_cov_19.401205_g443_i0 PRJNA1108487 494 903 19.401205 175.19288115 Geodia barretti 519541 Porifera other_Eukaryota 148 3.91e-40   NR CAI8030757.1 519541 g443 i0 51.8 0.551495016611296 166 65 52.8 6 614 138 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 498 148 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31521606 31521606 PRJNA1108487_P_NODE_9016_length_250_cov_1.762712_g8950_i0 PRJNA1108487 9016 250 1.762712 4.40678 Dysidea avara 196820 Porifera other_Eukaryota 55.1 1.92e-6   NR XP_065913515.1 196820 g8950 i0 52.5 1.416 59 26 70.8 2 183 7 1713 1769 XP_065913515.1 uncharacterized protein [Dysidea avara] diamond 354 55.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31647779 31647779 PRJNA1108487_P_NODE_9377_length_249_cov_0.886364_g9311_i0 PRJNA1108487 9377 249 0.886364 2.20704636 Dysidea avara 196820 Porifera other_Eukaryota 44.3 0.0053   NR XP_065888767.1 196820 g9311 i0 34.8 0.831325301204819 69 45 83.1 0 7 213 20 88 XP_065888767.1 uncharacterized protein [Dysidea avara] diamond 207 44.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31869303 31869303 PRJNA1108487_P_NODE_2977_length_393_cov_1.218750_g2911_i0 PRJNA1108487 2977 393 1.21875 4.7896875 Halichondria panicea 6063 Porifera other_Eukaryota 112 4.73e-26   NR XP_064386786.1 6063 g2911 i0 52.2 0.862595419847328 113 50 86.3 2 3 341 129 237 XP_064386786.1 uncharacterized protein LOC135335273 [Halichondria panicea] diamond 339 112 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31932584 31932584 PRJNA1108487_P_NODE_6317_length_286_cov_1.154930_g6251_i0 PRJNA1108487 6317 286 1.15493 3.3030998 Corticium candelabrum 121492 Porifera other_Eukaryota 90.9 5.59e-19   NR XP_062522744.1 121492 g6251 i0 42.2 0.944055944055944 90 52 94.4 0 6 275 245 334 XP_062522744.1 uncharacterized protein LOC134197434 [Corticium candelabrum] diamond 270 90.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32312659 32312659 PRJNA1108487_P_NODE_10879_length_243_cov_0.917647_g10813_i0 PRJNA1108487 10879 243 0.917647 2.22988221 Dysidea avara 196820 Porifera other_Eukaryota 56.6 4.7e-7   NR XP_065883965.1 196820 g10813 i0 37.3 1.60493827160494 75 39 92.6 2 227 3 118 184 XP_065883965.1 tripartite motif-containing protein 2-like [Dysidea avara] diamond 390 56.6 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32430275 32430275 PRJNA1108487_P_NODE_8599_length_252_cov_0.871508_g8533_i0 PRJNA1108487 8599 252 0.871508 2.19620016 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 53.5 3.92e-6   NR XP_065834761.1 121494 g8533 i0 42 2.9047619047619 81 38 96.4 1 248 6 145 216 XP_065834761.1 alpha-ketoglutarate-dependent dioxygenase alkB homolog 7, mitochondrial-like [Oscarella lobularis] diamond 732 53.5 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis

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