RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA799842" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA799842 · 28 ✖

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
7173027 7173027 PRJNA799842_P_NODE_3546_length_1559_cov_67.380888_g2963_i0 PRJNA799842 3546 1559 67.380888 1050.46804392 Opisthokonta 33154 Porifera other_Eukaryota 551 1.0299999999999999e-190   NR AQM52339.1 121494 g2963 i0 58.6 25.5182809493265 457 175 87.6 5 35 1399 1 445 AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis] diamond 39783 556 0.991007194244604 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
23745733 23745733 PRJNA799842_P_NODE_11739_length_915_cov_3.749406_g10511_i0 PRJNA799842 11739 915 3.749406 34.3070649 Metazoa 33208 Porifera other_Eukaryota 280 8.86e-90   NR CCQ18613.1 27933 g10511 i0 53.5 5.33114754098361 273 127 89.5 0 892 74 10 282 CCQ18613.1 60S acidic ribosomal protein P0 [Sycon ciliatum] diamond 4878 280 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
26642426 26642426 PRJNA799842_P_NODE_24321_length_600_cov_2.874763_g22783_i0 PRJNA799842 24321 600 2.874763 17.248578 Corticium candelabrum 121492 Porifera other_Eukaryota 260 2.39e-85   NR XP_062510361.1 121492 g22783 i0 67.2 3.805 189 62 94.5 0 17 583 1 189 XP_062510361.1 large ribosomal subunit protein uL13-like [Corticium candelabrum] diamond 2283 260 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
26800785 26800785 PRJNA799842_P_NODE_190521_length_241_cov_0.886905_g188948_i0 PRJNA799842 190521 241 0.886905 2.13744105 Dysidea avara 196820 Porifera other_Eukaryota 71.2 3.15e-12   NR XP_065918830.1 196820 g188948 i0 49.3 0.933609958506224 75 38 93.4 0 233 9 310 384 XP_065918830.1 uncharacterized protein [Dysidea avara] diamond 225 71.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27370433 27370433 PRJNA799842_P_NODE_43403_length_432_cov_1.286908_g41830_i0 PRJNA799842 43403 432 1.286908 5.55944256 Geodia barretti 519541 Porifera other_Eukaryota 165 1.52e-45   NR CAI8008875.1 519541 g41830 i0 61.5 1.875 143 51 99.3 1 4 432 30 168 CAI8008875.1 2-hydroxyacyl-CoA lyase 2 [Geodia barretti] diamond 810 165 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
27631788 27631788 PRJNA799842_P_NODE_88604_length_308_cov_0.982979_g87031_i0 PRJNA799842 88604 308 0.982979 3.02757532 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 67 5.22e-11   NR ABD65446.1 55567 g87031 i0 37.6 2.43506493506493 85 51 81.8 2 263 12 50 133 ABD65446.1 Rab41/43, partial [Suberites domuncula] diamond 750 67 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
28042223 28042223 PRJNA799842_P_NODE_40425_length_449_cov_1.542553_g38854_i0 PRJNA799842 40425 449 1.542553 6.92606297 Metazoa 33208 Porifera other_Eukaryota 144 1.38e-37   NR XP_064394295.1 6063 g38854 i0 46.3 69.8752783964365 149 79 99.6 1 448 2 258 405 XP_064394295.1 RAC-gamma serine/threonine-protein kinase-like [Halichondria panicea] diamond 31374 145 0.993103448275862 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28096303 28096303 PRJNA799842_P_NODE_175785_length_243_cov_1.358824_g174212_i0 PRJNA799842 175785 243 1.358824 3.30194232 Oopsacas minuta 111878 Porifera other_Eukaryota 45.8 0.00289   NR KAI6652006.1 111878 g174212 i0 41.5 1.62962962962963 53 31 65.4 0 235 77 215 267 KAI6652006.1 Vacuolar protein sorting-associated protein 72-like [Oopsacas minuta] diamond 396 45.8 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28128025 28128025 PRJNA799842_P_NODE_52925_length_390_cov_1.933754_g51352_i0 PRJNA799842 52925 390 1.933754 7.5416406 Corticium candelabrum 121492 Porifera other_Eukaryota 99.8 5.96e-23   NR XP_062519832.1 121492 g51352 i0 43.2 0.961538461538462 125 63 93.8 2 383 18 2 121 XP_062519832.1 LIM and SH3 domain protein 1-like [Corticium candelabrum] diamond 375 99.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28664720 28664720 PRJNA799842_P_NODE_47467_length_412_cov_2.628319_g45894_i0 PRJNA799842 47467 412 2.628319 10.82867428 Dysidea avara 196820 Porifera other_Eukaryota 137 6.23e-37   NR XP_065919226.1 196820 g45894 i0 44.2 2.80339805825243 129 72 93.9 0 395 9 1 129 XP_065919226.1 zinc finger protein-like 1 homolog [Dysidea avara] diamond 1155 137 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28705322 28705322 PRJNA799842_P_NODE_8967_length_1045_cov_11.346708_g7907_i0 PRJNA799842 8967 1045 11.346708 118.5730986 Metazoa 33208 Porifera other_Eukaryota 180 3.32e-50   NR KAI6649628.1 111878 g7907 i0 34.4 6.54258373205742 317 197 89.9 7 51 989 4 313 KAI6649628.1 Cathepsin L [Oopsacas minuta] diamond 6837 180 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28853949 28853949 PRJNA799842_P_NODE_98228_length_293_cov_1.400000_g96655_i0 PRJNA799842 98228 293 1.4 4.102 Oscarella lobularis 121494 Porifera other_Eukaryota 111 5.830000000000001e-27   NR XP_065843080.1 121494 g96655 i0 50.5 2.97952218430034 97 47 99.3 1 3 293 207 302 XP_065843080.1 L-threonine 3-dehydrogenase, mitochondrial-like isoform X1 [Oscarella lobularis] diamond 873 111 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28958010 28958010 PRJNA799842_P_NODE_165488_length_245_cov_1.197674_g163915_i0 PRJNA799842 165488 245 1.197674 2.9343013 Metazoa 33208 Porifera other_Eukaryota 113 3.12e-28   NR XP_064397297.1 6063 g163915 i0 88.9 191.767346938776 63 7 77.1 0 190 2 162 224 XP_064397297.1 rRNA 2'-O-methyltransferase fibrillarin-like [Halichondria panicea] diamond 46983 114 0.991228070175439 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29052650 29052650 PRJNA799842_P_NODE_124148_length_262_cov_2.037037_g122575_i0 PRJNA799842 124148 262 2.037037 5.33703694 Metazoa 33208 Porifera other_Eukaryota 78.6 1.15e-15   NR XP_062507813.1 121492 g122575 i0 50 7.72900763358779 80 35 89.3 2 260 27 73 149 XP_062507813.1 Golgi apparatus membrane protein TVP23 homolog B-like isoform X1 [Corticium candelabrum] diamond 2025 78.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29115782 29115782 PRJNA799842_P_NODE_191268_length_231_cov_2.278481_g189695_i0 PRJNA799842 191268 231 2.278481 5.26329111 Opisthokonta 33154 Porifera other_Eukaryota 59.3 3.6e-8   NR XP_064400429.1 6063 g189695 i0 43.2 1.90909090909091 74 39 96.1 1 10 231 12 82 XP_064400429.1 F-actin-capping protein subunit alpha-1-like [Halichondria panicea] diamond 441 59.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29391000 29391000 PRJNA799842_P_NODE_39649_length_454_cov_1.545932_g38078_i0 PRJNA799842 39649 454 1.545932 7.01853128 Dysidea avara 196820 Porifera other_Eukaryota 74.3 3.39e-12   NR XP_065908425.1 196820 g38078 i0 47.4 0.515418502202643 78 40 51.5 1 1 234 179 255 XP_065908425.1 2-hydroxyacyl-CoA lyase 2-like [Dysidea avara] diamond 234 74.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29399791 29399791 PRJNA799842_P_NODE_10009_length_991_cov_4.022876_g8895_i0 PRJNA799842 10009 991 4.022876 39.86670116 Metazoa 33208 Porifera other_Eukaryota 157 4.929999999999998e-41   NR XP_065891123.1 196820 g8895 i0 36.7 3.8234106962664 289 152 79.9 8 30 821 4 286 XP_065891123.1 stromal membrane-associated protein 1-like [Dysidea avara] diamond 3789 157 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29453675 29453675 PRJNA799842_P_NODE_70170_length_341_cov_2.421642_g68597_i0 PRJNA799842 70170 341 2.421642 8.25779922 Oopsacas minuta 111878 Porifera other_Eukaryota 48.1 2.17e-4   NR KAI6651473.1 111878 g68597 i0 35.5 0.668621700879765 76 44 62.5 1 276 64 21 96 KAI6651473.1 hypothetical protein LOD99_5081 [Oopsacas minuta] diamond 228 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
29801216 29801216 PRJNA799842_P_NODE_93271_length_300_cov_2.035242_g91698_i0 PRJNA799842 93271 300 2.035242 6.105726 Geodia barretti 519541 Porifera other_Eukaryota 108 3.41e-27   NR CAI8055673.1 519541 g91698 i0 51 0.98 98 47 97 1 300 10 109 206 CAI8055673.1 Stromal cell-derived factor 2 [Geodia barretti] diamond 294 108 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29832888 29832888 PRJNA799842_P_NODE_172231_length_244_cov_0.900585_g170658_i0 PRJNA799842 172231 244 0.900585 2.1974274 Sycon ciliatum 27933 Porifera other_Eukaryota 60.5 2.17e-8   NR XP_065183499.1 27933 g170658 i0 35.3 1.04508196721311 85 47 94.7 1 1 231 473 557 XP_065183499.1 gelsolin, cytoplasmic-like [Sycon ciliatum] diamond 255 60.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29905214 29905214 PRJNA799842_P_NODE_49791_length_403_cov_0.915152_g48218_i0 PRJNA799842 49791 403 0.915152 3.68806256 Opisthokonta 33154 Porifera other_Eukaryota 183 1.9099999999999994e-55   NR XP_065846404.1 121494 g48218 i0 63.2 5.90322580645161 133 49 99 0 401 3 108 240 XP_065846404.1 uncharacterized protein [Oscarella lobularis] diamond 2379 184 0.994565217391304 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29968278 29968278 PRJNA799842_P_NODE_184091_length_242_cov_0.911243_g182518_i0 PRJNA799842 184091 242 0.911243 2.20520806 Opisthokonta 33154 Porifera other_Eukaryota 69.3 8.28e-13   NR XP_062516633.1 121492 g182518 i0 58.6 10.995867768595 58 24 71.9 0 1 174 71 128 XP_062516633.1 small ribosomal subunit protein eS17-like [Corticium candelabrum] diamond 2661 69.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29990915 29990915 PRJNA799842_P_NODE_189111_length_241_cov_0.916667_g187538_i0 PRJNA799842 189111 241 0.916667 2.20916747 Corticium candelabrum 121492 Porifera other_Eukaryota 62.4 3.97e-9   NR XP_062514091.1 121492 g187538 i0 47.9 0.908713692946058 73 36 89.6 2 218 3 47 118 XP_062514091.1 lysosomal acid phosphatase-like [Corticium candelabrum] diamond 219 62.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31674754 31674754 PRJNA799842_P_NODE_9897_length_997_cov_3.225108_g8789_i0 PRJNA799842 9897 997 3.225108 32.15432676 Metazoa 33208 Porifera other_Eukaryota 108 3.0800000000000003e-22   NR XP_065916092.1 196820 g8789 i0 25.7 1.79037111334002 304 203 86.1 5 900 43 43 341 XP_065916092.1 cytoplasmic dynein 1 light intermediate chain 2-like [Dysidea avara] diamond 1785 108 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31697500 31697500 PRJNA799842_P_NODE_159897_length_246_cov_1.445087_g158324_i0 PRJNA799842 159897 246 1.445087 3.55491402 Corticium candelabrum 121492 Porifera other_Eukaryota 48.1 4.64e-4   NR XP_062503998.1 121492 g158324 i0 40.2 1.91463414634146 87 44 98.8 3 4 246 64 148 XP_062503998.1 ester hydrolase C11orf54 homolog [Corticium candelabrum] diamond 471 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31855616 31855616 PRJNA799842_P_NODE_16437_length_758_cov_4.119708_g15012_i0 PRJNA799842 16437 758 4.119708 31.22738664 Geodia barretti 519541 Porifera other_Eukaryota 160 7.22e-45   NR CAI7998431.1 519541 g15012 i0 43.6 0.771767810026385 195 108 76.8 2 645 64 10 203 CAI7998431.1 Osteoclast-stimulating factor 1 [Geodia barretti] diamond 585 160 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32583484 32583484 PRJNA799842_P_NODE_100839_length_290_cov_1.059908_g99266_i0 PRJNA799842 100839 290 1.059908 3.0737332 Sycon ciliatum 27933 Porifera other_Eukaryota 75.1 2.45e-13   NR XP_065187940.1 27933 g99266 i0 39.6 1.87241379310345 91 54 93.1 1 286 17 294 384 XP_065187940.1 prosaposin-like [Sycon ciliatum] diamond 543 75.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32740928 32740928 PRJNA799842_P_NODE_61060_length_364_cov_1.821306_g59487_i0 PRJNA799842 61060 364 1.821306 6.62955384 Amphimedon queenslandica 400682 Porifera other_Eukaryota 78.2 7.38e-16   NR XP_003387445.1 400682 g59487 i0 58.7 2.71153846153846 63 26 51.9 0 19 207 5 67 XP_003387445.1 PREDICTED: 60S acidic ribosomal protein P1-like [Amphimedon queenslandica] diamond 987 78.2 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);;