RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA1214993", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 22 ✖

tax_kingdom 1

  • Metazoa · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA1214993 · 22 ✖

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
1605009 1605009 PRJNA1214993_P_NODE_1422_length_863_cov_2.989873_g1270_i0 PRJNA1214993 1422 863 2.989873 25.80260399 Oscarella lobularis 121494 Porifera other_Eukaryota 400 1.38e-136   NR XP_065841661.1 121494 g1270 i0 68.5 7.79374275782155 279 88 97 0 842 6 2 280 XP_065841661.1 large ribosomal subunit protein uL4A-like [Oscarella lobularis] diamond 6726 400 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
6708156 6708156 PRJNA1214993_P_NODE_2506_length_662_cov_4.848896_g2330_i0 PRJNA1214993 2506 662 4.848896 32.09969152 Metazoa 33208 Porifera other_Eukaryota 229 5.01e-71   NR XP_062520409.1 121492 g2330 i0 66.7 21.7160120845921 171 57 77.5 0 149 661 1 171 XP_062520409.1 large ribosomal subunit protein uL10-like [Corticium candelabrum] diamond 14376 229 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
19456390 19456390 PRJNA1214993_P_NODE_2176_length_707_cov_2.676656_g2005_i0 PRJNA1214993 2176 707 2.676656 18.92395792 Metazoa 33208 Porifera other_Eukaryota 296 3.6e-98   NR XP_062521049.1 121492 g2005 i0 68.4 9.33097595473833 225 61 93.4 2 660 1 26 245 XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum] diamond 6597 298 0.993288590604027 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27420578 27420578 PRJNA1214993_P_NODE_25203_length_243_cov_1.458824_g25017_i0 PRJNA1214993 25203 243 1.458824 3.54494232 Corticium candelabrum 121492 Porifera other_Eukaryota 55.1 1.66e-6   NR XP_062502461.1 121492 g25017 i0 38.7 0.925925925925926 75 46 92.6 0 3 227 444 518 XP_062502461.1 alpha-actinin-like [Corticium candelabrum] diamond 225 55.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28304363 28304363 PRJNA1214993_P_NODE_5266_length_466_cov_1.190840_g5081_i0 PRJNA1214993 5266 466 1.19084 5.5493144 Geodia barretti 519541 Porifera other_Eukaryota 72 3.27e-12   NR CAI8029397.1 519541 g5081 i0 43.8 0.618025751072961 96 45 56.7 4 428 165 47 141 CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti] diamond 288 72 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28462486 28462486 PRJNA1214993_P_NODE_3406_length_574_cov_3.063872_g3224_i0 PRJNA1214993 3406 574 3.063872 17.58662528 Corticium candelabrum 121492 Porifera other_Eukaryota 117 4.01e-30   NR XP_062501865.1 121492 g3224 i0 61.5 0.475609756097561 91 35 47.6 0 300 572 6 96 XP_062501865.1 large ribosomal subunit protein eL22-like [Corticium candelabrum] diamond 273 117 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28702187 28702187 PRJNA1214993_P_NODE_13927_length_296_cov_0.843049_g13741_i0 PRJNA1214993 13927 296 0.843049 2.49542504 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 83.6 2.98e-16   NR XP_064403734.1 6063 g13741 i0 47.8 3.82094594594595 92 45 93.2 1 5 280 161 249 XP_064403734.1 uncharacterized protein sll0103-like [Halichondria panicea] diamond 1131 83.6 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28746397 28746397 PRJNA1214993_P_NODE_10347_length_341_cov_1.361940_g10161_i0 PRJNA1214993 10347 341 1.36194 4.6442154 Oscarella lobularis 121494 Porifera other_Eukaryota 93.2 2.19e-19   NR XP_065829286.1 121494 g10161 i0 46.4 4.09970674486804 112 48 98.5 4 2 337 280 379 XP_065829286.1 agrin-like [Oscarella lobularis] diamond 1398 93.2 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29062285 29062285 PRJNA1214993_P_NODE_11308_length_327_cov_1.830709_g11122_i0 PRJNA1214993 11308 327 1.830709 5.98641843 Amphimedon queenslandica 400682 Porifera other_Eukaryota 168 7.959999999999999e-47   NR XP_011406795.1 400682 g11122 i0 76.6 1.71559633027523 94 22 86.2 0 2 283 187 280 XP_011406795.1 PREDICTED: uncharacterized protein LOC100632176 [Amphimedon queenslandica] diamond 561 168 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
29472324 29472324 PRJNA1214993_P_NODE_14530_length_290_cov_1.437788_g14344_i0 PRJNA1214993 14530 290 1.437788 4.1695852 Dysidea avara 196820 Porifera other_Eukaryota 75.5 2.06e-13   NR XP_065911656.1 196820 g14344 i0 50.6 2.51379310344828 77 37 79.7 1 14 244 893 968 XP_065911656.1 BOS complex subunit NOMO1-like isoform X1 [Dysidea avara] diamond 729 75.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29838668 29838668 PRJNA1214993_P_NODE_18391_length_261_cov_1.553191_g18205_i0 PRJNA1214993 18391 261 1.553191 4.05382851 Metazoa 33208 Porifera other_Eukaryota 75.1 1.26e-13   NR XP_064393864.1 6063 g18205 i0 46.5 1.67816091954023 71 38 81.6 0 215 3 9 79 XP_064393864.1 uncharacterized protein LOC135341280 [Halichondria panicea] diamond 438 75.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30249719 30249719 PRJNA1214993_P_NODE_7032_length_407_cov_1.239521_g6847_i0 PRJNA1214993 7032 407 1.239521 5.04485047 Metazoa 33208 Porifera other_Eukaryota 129 4.4899999999999997e-32   NR XP_065183512.1 27933 g6847 i0 61 2.43980343980344 100 39 73.7 0 318 19 417 516 XP_065183512.1 selenoprotein N-like [Sycon ciliatum] diamond 993 129 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30325976 30325976 PRJNA1214993_P_NODE_24272_length_245_cov_0.906977_g24086_i0 PRJNA1214993 24272 245 0.906977 2.22209365 Geodia barretti 519541 Porifera other_Eukaryota 67 6.87e-11   NR CAI8005751.1 519541 g24086 i0 42.3 5.79183673469388 78 45 95.5 0 9 242 96 173 CAI8005751.1 Probable E3 ubiquitin-protein ligase HERC4 [Geodia barretti] diamond 1419 67 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
30514989 30514989 PRJNA1214993_P_NODE_2133_length_713_cov_2.332813_g1962_i0 PRJNA1214993 2133 713 2.332813 16.63295669 Geodia barretti 519541 Porifera other_Eukaryota 132 1.7e-34   NR CAI8030757.1 519541 g1962 i0 52 0.631136044880785 150 57 60.2 6 284 712 18 159 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 450 132 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
30672840 30672840 PRJNA1214993_P_NODE_15753_length_281_cov_1.322115_g15567_i0 PRJNA1214993 15753 281 1.322115 3.71514315 Sycon ciliatum 27933 Porifera other_Eukaryota 74.3 4.76e-13   NR XP_065195124.1 27933 g15567 i0 40.4 2.79715302491103 89 50 91.8 2 281 24 560 648 XP_065195124.1 deleted in malignant brain tumors 1 protein-like [Sycon ciliatum] diamond 786 74.3 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31146482 31146482 PRJNA1214993_P_NODE_15755_length_281_cov_1.302885_g15569_i0 PRJNA1214993 15755 281 1.302885 3.66110685 Geodia barretti 519541 Porifera other_Eukaryota 58.2 2.22e-7   NR CAI8024789.1 519541 g15569 i0 47.8 0.715302491103203 67 29 65.1 1 93 275 429 495 CAI8024789.1 Squamous cell carcinoma antigen recognized by T-cells 3 [Geodia barretti] diamond 201 58.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31526520 31526520 PRJNA1214993_P_NODE_23776_length_246_cov_0.890173_g23590_i0 PRJNA1214993 23776 246 0.890173 2.18982558 Sycon ciliatum 27933 Porifera other_Eukaryota 43.5 0.0146   NR XP_065176749.1 27933 g23590 i0 41.5 0.646341463414634 53 31 64.6 0 2 160 87 139 XP_065176749.1 calcineurin B homologous protein 1-like [Sycon ciliatum] diamond 159 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31716157 31716157 PRJNA1214993_P_NODE_15717_length_281_cov_1.500000_g15531_i0 PRJNA1214993 15717 281 1.5 4.215 Sycon ciliatum 27933 Porifera other_Eukaryota 70.9 7.83e-12   NR XP_065187533.1 27933 g15531 i0 44 0.97153024911032 91 43 91.8 3 277 20 1404 1491 XP_065187533.1 uncharacterized protein LOC135818131 isoform X1 [Sycon ciliatum] diamond 273 70.9 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32064075 32064075 PRJNA1214993_P_NODE_18838_length_258_cov_1.356757_g18652_i0 PRJNA1214993 18838 258 1.356757 3.50043306 Sycon ciliatum 27933 Porifera other_Eukaryota 62.4 3.51e-9   NR XP_065183035.1 27933 g18652 i0 85.7 0.813953488372093 35 5 40.7 0 154 258 40 74 XP_065183035.1 small ribosomal subunit protein uS5-like [Sycon ciliatum] diamond 210 62.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32380681 32380681 PRJNA1214993_P_NODE_16399_length_276_cov_1.305419_g16213_i0 PRJNA1214993 16399 276 1.305419 3.60295644 Amphimedon queenslandica 400682 Porifera other_Eukaryota 55.5 1.84e-6   NR XP_011402743.2 400682 g16213 i0 59 0.978260869565217 39 16 42.4 0 34 150 29 67 XP_011402743.2 PREDICTED: acidic mammalian chitinase-like [Amphimedon queenslandica] diamond 270 55.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32380683 32380683 PRJNA1214993_P_NODE_17139_length_270_cov_1.969543_g16953_i0 PRJNA1214993 17139 270 1.969543 5.3177661 Amphimedon queenslandica 400682 Porifera other_Eukaryota 54.3 4.02e-6   NR XP_019857249.1 400682 g16953 i0 30.7 1.95555555555556 88 59 97.8 1 265 2 51 136 XP_019857249.1 PREDICTED: cathepsin O-like [Amphimedon queenslandica] diamond 528 54.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32651845 32651845 PRJNA1214993_P_NODE_2400_length_677_cov_1.480132_g2226_i0 PRJNA1214993 2400 677 1.480132 10.02049364 Metazoa 33208 Porifera other_Eukaryota 128 2.13e-30   NR XP_065829286.1 121494 g2226 i0 43.5 4.53323485967504 170 64 66.9 5 225 677 196 352 XP_065829286.1 agrin-like [Oscarella lobularis] diamond 3069 128 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);;