RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA793147", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 17 ✖

tax_kingdom 1

  • Metazoa · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA793147 · 17 ✖

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
16080784 16080784 PRJNA793147_P_NODE_60273_length_227_cov_1.398734_g60007_i0 PRJNA793147 60273 227 1.398734 3.17512618 Oscarella lobularis 121494 Porifera other_Eukaryota 71.2 2.61e-12   NR XP_065828428.1 121494 g60007 i0 53.9 1.00440528634361 76 31 99.1 2 1 225 341 413 XP_065828428.1 uncharacterized protein [Oscarella lobularis] diamond 228 71.2 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
19904274 19904274 PRJNA793147_P_NODE_20056_length_373_cov_0.940789_g19790_i0 PRJNA793147 20056 373 0.940789 3.50914297 Metazoa 33208 Porifera other_Eukaryota 204 5.42e-65   NR XP_062508382.1 121492 g19790 i0 73.4 17.8069705093834 124 32 98.9 1 1 369 26 149 XP_062508382.1 SUMO-conjugating enzyme UBC9 [Corticium candelabrum] diamond 6642 206 0.990291262135922 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
26610417 26610417 PRJNA793147_P_NODE_42401_length_259_cov_1.315789_g42135_i0 PRJNA793147 42401 259 1.315789 3.40789351 Amphimedon queenslandica 400682 Porifera other_Eukaryota 48.1 5.59e-4   NR XP_003386227.1 400682 g42135 i0 38.5 1.11196911196911 96 40 98.5 4 1 255 363 450 XP_003386227.1 PREDICTED: chromatin assembly factor 1 subunit B-like [Amphimedon queenslandica] diamond 288 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
26809851 26809851 PRJNA793147_P_NODE_49401_length_238_cov_1.751479_g49135_i0 PRJNA793147 49401 238 1.751479 4.16852002 Porifera 6040 Porifera other_Eukaryota 98.2 8.95e-22   NR XP_062520341.1 121492 g49135 i0 60.8 3.98319327731092 79 31 99.6 0 238 2 149 227 XP_062520341.1 inosine-5'-monophosphate dehydrogenase 2-like isoform X2 [Corticium candelabrum] diamond 948 98.2 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
26904855 26904855 PRJNA793147_P_NODE_48901_length_240_cov_1.438596_g48635_i0 PRJNA793147 48901 240 1.438596 3.4526304 Metazoa 33208 Porifera other_Eukaryota 101 8.989999999999999e-23   NR XP_062513515.1 121492 g48635 i0 56.9 4.4375 72 30 90 1 9 224 806 876 XP_062513515.1 trichohyalin-like isoform X2 [Corticium candelabrum] diamond 1065 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
26999517 26999517 PRJNA793147_P_NODE_59902_length_228_cov_0.905660_g59636_i0 PRJNA793147 59902 228 0.90566 2.0649048 Metazoa 33208 Porifera other_Eukaryota 113 4.92e-27   NR XP_065178924.1 27933 g59636 i0 64 94.5394736842105 75 27 98.7 0 3 227 775 849 XP_065178924.1 E3 ubiquitin-protein ligase Itchy-like isoform X2 [Sycon ciliatum] diamond 21555 113 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27179954 27179954 PRJNA793147_P_NODE_19262_length_381_cov_1.711538_g18996_i0 PRJNA793147 19262 381 1.711538 6.52095978 Sycon ciliatum 27933 Porifera other_Eukaryota 107 9.6e-28   NR XP_065183449.1 27933 g18996 i0 58.6 1.34645669291339 87 35 67.7 1 26 283 3 89 XP_065183449.1 small ubiquitin-related modifier 1-like [Sycon ciliatum] diamond 513 107 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27906378 27906378 PRJNA793147_P_NODE_63205_length_217_cov_2.432432_g62939_i0 PRJNA793147 63205 217 2.432432 5.27837744 Dysidea avara 196820 Porifera other_Eukaryota 97.4 1.3400000000000002e-21   NR XP_065910166.1 196820 g62939 i0 66.7 2.93087557603687 72 24 99.5 0 217 2 423 494 XP_065910166.1 T-complex protein 1 subunit beta-like [Dysidea avara] diamond 636 97.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28033089 28033089 PRJNA793147_P_NODE_5445_length_781_cov_4.477528_g5216_i0 PRJNA793147 5445 781 4.477528 34.96949368 Sycon ciliatum 27933 Porifera other_Eukaryota 249 1.8200000000000003e-79   NR XP_065198808.1 27933 g5216 i0 61.1 13.7016645326504 226 86 86.4 2 1 675 22 246 XP_065198808.1 14-3-3-like protein 2 [Sycon ciliatum] diamond 10701 249 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28380213 28380213 PRJNA793147_P_NODE_16086_length_421_cov_1.985795_g15820_i0 PRJNA793147 16086 421 1.985795 8.36019695 Sycon ciliatum 27933 Porifera other_Eukaryota 144 2.73e-41   NR XP_065191589.1 27933 g15820 i0 51.8 0.990498812351544 139 66 98.3 1 7 420 1 139 XP_065191589.1 coactosin-like protein [Sycon ciliatum] diamond 417 144 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28601353 28601353 PRJNA793147_P_NODE_28807_length_311_cov_1.190083_g28541_i0 PRJNA793147 28807 311 1.190083 3.70115813 Halichondria panicea 6063 Porifera other_Eukaryota 161 1.9199999999999993e-43   NR XP_064403007.1 6063 g28541 i0 77.7 2.97106109324759 103 22 99.4 1 2 310 89 190 XP_064403007.1 alpha-actinin-1-like [Halichondria panicea] diamond 924 161 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29043474 29043474 PRJNA793147_P_NODE_60768_length_227_cov_0.911392_g60502_i0 PRJNA793147 60768 227 0.911392 2.06885984 Oscarella lobularis 121494 Porifera other_Eukaryota 67.4 4.87e-11   NR XP_065830042.1 121494 g60502 i0 44 0.991189427312775 75 42 99.1 0 226 2 1 75 XP_065830042.1 uncharacterized protein [Oscarella lobularis] diamond 225 67.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29106541 29106541 PRJNA793147_P_NODE_20248_length_371_cov_1.155629_g19982_i0 PRJNA793147 20248 371 1.155629 4.28738359 Sycon ciliatum 27933 Porifera other_Eukaryota 70.9 1.73e-11   NR XP_065178187.1 27933 g19982 i0 53.7 1.62533692722372 67 31 54.2 0 201 1 155 221 XP_065178187.1 gelsolin-like protein 1 [Sycon ciliatum] diamond 603 70.9 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29674429 29674429 PRJNA793147_P_NODE_28410_length_313_cov_1.274590_g28144_i0 PRJNA793147 28410 313 1.27459 3.9894667 Dysidea avara 196820 Porifera other_Eukaryota 73.9 8.52e-13   NR XP_065890057.1 196820 g28144 i0 40.2 0.833865814696486 87 52 83.4 0 265 5 274 360 XP_065890057.1 oxysterol-binding protein 1-like [Dysidea avara] diamond 261 73.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31611634 31611634 PRJNA793147_P_NODE_42796_length_258_cov_1.132275_g42530_i0 PRJNA793147 42796 258 1.132275 2.9212695 Metazoa 33208 Porifera other_Eukaryota 57.8 2.23e-7   NR XP_065176923.1 27933 g42530 i0 31 5.98837209302326 87 49 89.5 2 18 248 554 639 XP_065176923.1 nuclear protein localization protein 4 homolog [Sycon ciliatum] diamond 1545 57.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31643044 31643044 PRJNA793147_P_NODE_57956_length_229_cov_0.900000_g57690_i0 PRJNA793147 57956 229 0.9 2.061 Metazoa 33208 Porifera other_Eukaryota 61.2 2.44e-9   NR XP_064382942.1 6063 g57690 i0 60.8 3.91703056768559 51 19 66.8 1 2 154 56 105 XP_064382942.1 serine/arginine-rich splicing factor 10-like [Halichondria panicea] diamond 897 61.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31674690 31674690 PRJNA793147_P_NODE_62937_length_221_cov_2.578947_g62671_i0 PRJNA793147 62937 221 2.578947 5.69947287 Metazoa 33208 Porifera other_Eukaryota 77 1.94e-14   NR XP_064395120.1 6063 g62671 i0 48.7 12.1628959276018 76 35 99.1 3 219 1 119 193 XP_064395120.1 dnaJ homolog subfamily A member 1-like [Halichondria panicea] diamond 2688 77.4 0.994832041343669 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea

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