RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1035005", 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

  • PRJNA1035005 · 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
2282988 2282988 PRJNA1035005_P_NODE_20302_length_299_cov_1.535398_g19896_i0 PRJNA1035005 20302 299 1.535398 4.59084002 Oscarella lobularis 121494 Porifera other_Eukaryota 89.4 8.17e-20   NR XP_065829396.1 121494 g19896 i0 55.1 0.782608695652174 78 34 78.3 1 296 63 108 184 XP_065829396.1 ras-related protein Rap-1b-like [Oscarella lobularis] diamond 234 89.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
2719649 2719649 PRJNA1035005_P_NODE_9643_length_368_cov_2.071186_g9238_i0 PRJNA1035005 9643 368 2.071186 7.62196448 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 81.6 5.58e-16   NR XP_064383121.1 6063 g9238 i0 82.4 3.52173913043478 51 9 41.6 0 16 168 189 239 XP_064383121.1 14-3-3-like protein 1 [Halichondria panicea] diamond 1296 82.4 0.990291262135922 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
11647197 11647197 PRJNA1035005_P_NODE_1250_length_1168_cov_1.448402_g970_i0 PRJNA1035005 1250 1168 1.448402 16.91733536 Merlia normani 1325619 Porifera other_Eukaryota 193 6.72e-44   NTclustered gi|514227047|gb|KC952723.1| 1325619 g970 i0 82.883 10.9708904109589 222 29 18 9 508 723 249 31 Merlia normani voucher MNRJ15831 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 12814 193 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Merliida Merliidae Merlia Merlia normani
23121015 23121015 PRJNA1035005_P_NODE_31139_length_281_cov_1.394231_g30733_i0 PRJNA1035005 31139 281 1.394231 3.91778911 Metazoa 33208 Porifera other_Eukaryota 135 1.11e-34   NR XP_065194361.1 27933 g30733 i0 77.4 5.94661921708185 93 21 99.3 0 281 3 607 699 XP_065194361.1 major vault protein-like [Sycon ciliatum] diamond 1671 135 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27153147 27153147 PRJNA1035005_P_NODE_2582_length_705_cov_2.859177_g2198_i0 PRJNA1035005 2582 705 2.859177 20.15719785 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 198 9.65e-58   NR XP_065916476.1 196820 g2198 i0 53.6 3.05531914893617 179 79 76.2 3 705 169 221 395 XP_065916476.1 LOW QUALITY PROTEIN: beta-1,3-glucan-binding protein-like [Dysidea avara] diamond 2154 200 0.99 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27288005 27288005 PRJNA1035005_P_NODE_23583_length_291_cov_1.348624_g23177_i0 PRJNA1035005 23583 291 1.348624 3.92449584 Dysidea avara 196820 Porifera other_Eukaryota 63.2 2.18e-9   NR XP_065898052.1 196820 g23177 i0 64.9 0.587628865979381 57 17 58.8 1 109 279 12 65 XP_065898052.1 large ribosomal subunit protein uL30-like [Dysidea avara] diamond 171 63.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27501337 27501337 PRJNA1035005_P_NODE_11423_length_350_cov_1.126354_g11018_i0 PRJNA1035005 11423 350 1.126354 3.942239 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 128 1.37e-31   NR XP_062522731.1 121492 g11018 i0 57.8 3.01714285714286 116 41 99.4 2 348 1 27 134 XP_062522731.1 protein DD3-3-like [Corticium candelabrum] diamond 1056 128 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28045855 28045855 PRJNA1035005_P_NODE_44505_length_264_cov_1.225131_g44099_i0 PRJNA1035005 44505 264 1.225131 3.23434584 Sycon ciliatum 27933 Porifera other_Eukaryota 44.7 0.01   NR XP_065183210.1 27933 g44099 i0 32.5 0.909090909090909 80 52 89.8 2 263 27 196 274 XP_065183210.1 WD repeat-containing protein 75-like [Sycon ciliatum] diamond 240 44.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28100915 28100915 PRJNA1035005_P_NODE_84545_length_242_cov_1.284024_g84139_i0 PRJNA1035005 84545 242 1.284024 3.10733808 Metazoa 33208 Porifera other_Eukaryota 136 5.97e-36   NR XP_064383005.1 6063 g84139 i0 75 14.8512396694215 80 20 99.2 0 240 1 339 418 XP_064383005.1 elongation factor 1-alpha [Halichondria panicea] diamond 3594 137 0.992700729927007 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28424916 28424916 PRJNA1035005_P_NODE_23146_length_291_cov_2.018349_g22740_i0 PRJNA1035005 23146 291 2.018349 5.87339559 Oscarella lobularis 121494 Porifera other_Eukaryota 92 4.3700000000000005e-21   NR XP_065836116.1 121494 g22740 i0 54.8 2.94845360824742 73 33 75.3 0 285 67 93 165 XP_065836116.1 small ribosomal subunit protein eS19-like [Oscarella lobularis] diamond 858 92 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28740533 28740533 PRJNA1035005_P_NODE_28227_length_285_cov_1.297170_g27821_i0 PRJNA1035005 28227 285 1.29717 3.6969345 Halichondria panicea 6063 Porifera other_Eukaryota 70.9 2.6e-13   NR XP_064391496.1 6063 g27821 i0 45.2 0.768421052631579 73 39 76.8 1 61 279 12 83 XP_064391496.1 selenoprotein M-like [Halichondria panicea] diamond 219 70.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28866791 28866791 PRJNA1035005_P_NODE_22048_length_293_cov_1.872727_g21642_i0 PRJNA1035005 22048 293 1.872727 5.48709011 Oscarella lobularis 121494 Porifera other_Eukaryota 132 2.96e-33   NR XP_065838323.1 121494 g21642 i0 58.8 0.993174061433447 97 40 99.3 0 3 293 291 387 XP_065838323.1 LOW QUALITY PROTEIN: uncharacterized protein [Oscarella lobularis] diamond 291 132 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28898257 28898257 PRJNA1035005_P_NODE_80088_length_244_cov_0.912281_g79682_i0 PRJNA1035005 80088 244 0.912281 2.22596564 Oscarella lobularis 121494 Porifera other_Eukaryota 43.5 0.0212   NR XP_065827354.1 121494 g79682 i0 55.9 1.06967213114754 34 15 41.8 0 1 102 318 351 XP_065827354.1 uncharacterized protein [Oscarella lobularis] diamond 261 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29655762 29655762 PRJNA1035005_P_NODE_4550_length_499_cov_2.194836_g4151_i0 PRJNA1035005 4550 499 2.194836 10.95223164 Corticium candelabrum 121492 Porifera other_Eukaryota 184 8.03e-51   NR XP_062522731.1 121492 g4151 i0 56.6 7.99599198396794 166 58 99.8 3 498 1 40 191 XP_062522731.1 protein DD3-3-like [Corticium candelabrum] diamond 3990 184 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29782457 29782457 PRJNA1035005_P_NODE_31191_length_281_cov_1.336538_g30785_i0 PRJNA1035005 31191 281 1.336538 3.75567178 Dysidea avara 196820 Porifera other_Eukaryota 46.2 0.00362   NR XP_065917578.1 196820 g30785 i0 40.4 0.555160142348754 52 31 55.5 0 96 251 320 371 XP_065917578.1 uncharacterized protein [Dysidea avara] diamond 156 46.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30438174 30438174 PRJNA1035005_P_NODE_48113_length_259_cov_1.677419_g47707_i0 PRJNA1035005 48113 259 1.677419 4.34451521 Opisthokonta 33154 Porifera other_Eukaryota 81.6 5.85e-16   NR XP_064399891.1 6063 g47707 i0 58.6 12.7760617760618 70 29 81.1 0 252 43 255 324 XP_064399891.1 mitogen-activated protein kinase 14-like [Halichondria panicea] diamond 3309 82 0.995121951219512 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31583951 31583951 PRJNA1035005_P_NODE_26336_length_287_cov_1.761682_g25930_i0 PRJNA1035005 26336 287 1.761682 5.05602734 Corticium candelabrum 121492 Porifera other_Eukaryota 138 2.0199999999999997e-37   NR XP_062510655.1 121492 g25930 i0 69.8 0.898954703832753 86 26 89.9 0 263 6 20 105 XP_062510655.1 aldo-keto reductase family 1 member A1-like [Corticium candelabrum] diamond 258 138 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31900060 31900060 PRJNA1035005_P_NODE_12557_length_340_cov_1.382022_g12152_i0 PRJNA1035005 12557 340 1.382022 4.6988748 Halichondria panicea 6063 Porifera other_Eukaryota 115 2.6200000000000003e-27   NR XP_064403837.1 6063 g12152 i0 53 4.03235294117647 115 51 98.8 1 2 337 684 798 XP_064403837.1 phospholipase B1, membrane-associated-like [Halichondria panicea] diamond 1371 115 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32153255 32153255 PRJNA1035005_P_NODE_61878_length_250_cov_0.881356_g61472_i0 PRJNA1035005 61878 250 0.881356 2.20339 Amphimedon queenslandica 400682 Porifera other_Eukaryota 70.1 9.34e-12   NR XP_019851601.1 400682 g61472 i0 46 2.088 87 41 98.4 4 248 3 794 879 XP_019851601.1 PREDICTED: 1-phosphatidylinositol 4,5-bisphosphate phosphodiesterase beta-4-like [Amphimedon queenslandica] diamond 522 70.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica

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