RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJEB7366", 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 · 21 ✖

tax_kingdom 1

  • Metazoa · 21 ✖

tax_clade 1

bioproject 1

  • PRJEB7366 · 21 ✖
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
7787640 7787640 PRJEB7366_P_NODE_2667_length_588_cov_1.566004_g2271_i0 PRJEB7366 2667 588 1.566004 9.20810352 Oscarella lobularis 121494 Porifera other_Eukaryota 459 2.9299999999999992e-124   NTclustered gi|2746774523|ref|XM_065971111.1| 121494 g2271 i0 80.993 97.2908163265306 584 105 99 6 1 581 455 1035 PREDICTED: Oscarella lobularis tubulin beta-4B chain (LOC136184245), mRNA blastn 57207 459 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
9923569 9923569 PRJEB7366_P_NODE_21168_length_164_cov_3.410853_g20734_i0 PRJEB7366 21168 164 3.410853 5.59379892 Metazoa 33208 Porifera other_Eukaryota 110 8.01e-20   NTclustered gi|2749508265|ref|XM_066030399.1| 196820 g20734 i0 81.679 24.2865853658537 131 24 80 0 19 149 287 157 PREDICTED: Dysidea avara tubulin alpha-1A chain-like (LOC136239626), mRNA blastn 3983 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
21812007 21812007 PRJEB7366_P_NODE_15758_length_196_cov_1.739130_g15324_i0 PRJEB7366 15758 196 1.73913 3.4086948 Metazoa 33208 Porifera other_Eukaryota 122 1.51e-30   NR XP_064390129.1 6063 g15324 i0 89.2 11.9387755102041 65 7 99.5 0 2 196 209 273 XP_064390129.1 T-complex protein 1 subunit gamma-like [Halichondria panicea] diamond 2340 122 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
24361096 24361096 PRJEB7366_P_NODE_5620_length_378_cov_2.402332_g5187_i0 PRJEB7366 5620 378 2.402332 9.08081496 Metazoa 33208 Porifera other_Eukaryota 198 1.45e-56   NR AZI95706.1 6063 g5187 i0 72.8 103.984126984127 125 34 99.2 0 3 377 8 132 AZI95706.1 valosin containing protein, partial [Halichondria panicea] diamond 39306 200 0.99 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
26876185 26876185 PRJEB7366_P_NODE_10541_length_254_cov_1.132420_g10107_i0 PRJEB7366 10541 254 1.13242 2.8763468 Sycon ciliatum 27933 Porifera other_Eukaryota 64.7 7.84e-10   NR XP_065191600.1 27933 g10107 i0 35.6 1.96062992125984 87 48 96.9 3 5 250 331 414 XP_065191600.1 alpha-protein kinase vwkA-like [Sycon ciliatum] diamond 498 64.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27255312 27255312 PRJEB7366_P_NODE_22323_length_159_cov_3.145161_g21889_i0 PRJEB7366 22323 159 3.145161 5.00080599 Corticium candelabrum 121492 Porifera other_Eukaryota 108 2.3e-27   NR XP_062504194.1 121492 g21889 i0 92.3 18.6415094339623 52 4 98.1 0 157 2 44 95 XP_062504194.1 E3 ubiquitin-protein ligase RING2-like [Corticium candelabrum] diamond 2964 108 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27476548 27476548 PRJEB7366_P_NODE_3923_length_471_cov_1.697248_g3499_i0 PRJEB7366 3923 471 1.697248 7.99403808 Ephydatia muelleri 6052 Porifera other_Eukaryota 84.7 4.1e-16   NR CAQ54046.1 6052 g3499 i0 36.2 3.81528662420382 163 90 96.8 6 467 12 174 333 CAQ54046.1 silicatein alpha 2 [Ephydatia muelleri] diamond 1797 84.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Spongillida Spongillidae Ephydatia Ephydatia muelleri
27508302 27508302 PRJEB7366_P_NODE_2583_length_600_cov_2.228319_g2192_i0 PRJEB7366 2583 600 2.228319 13.369914 Dysidea avara 196820 Porifera other_Eukaryota 128 2.46e-30   NR XP_065890435.1 196820 g2192 i0 39 0.885 177 103 86 2 68 583 531 707 XP_065890435.1 filamin-B-like [Dysidea avara] diamond 531 128 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28234044 28234044 PRJEB7366_P_NODE_20866_length_166_cov_1.221374_g20432_i0 PRJEB7366 20866 166 1.221374 2.02748084 Geodia barretti 519541 Porifera other_Eukaryota 82.8 3.36e-19   NR CAI8041938.1 519541 g20432 i0 66.7 1.91566265060241 51 17 92.2 0 156 4 19 69 CAI8041938.1 WD repeat-containing protein 61, partial [Geodia barretti] diamond 318 83.2 0.995192307692308 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28290125 28290125 PRJEB7366_P_NODE_18186_length_180_cov_1.103448_g17752_i0 PRJEB7366 18186 180 1.103448 1.9862064 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 54.3 1.36e-6   NR XP_065828496.1 121494 g17752 i0 51.7 8.58333333333333 60 18 100 3 1 180 342 390 XP_065828496.1 digestive cysteine proteinase 1-like [Oscarella lobularis] diamond 1545 54.7 0.992687385740402 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28360476 28360476 PRJEB7366_P_NODE_21586_length_163_cov_0.937500_g21152_i0 PRJEB7366 21586 163 0.9375 1.528125 Oscarella lobularis 121494 Porifera other_Eukaryota 75.1 4.97e-14   NR XP_065836296.1 121494 g21152 i0 66.7 1.91411042944785 51 17 93.9 0 163 11 515 565 XP_065836296.1 uncharacterized protein [Oscarella lobularis] diamond 312 75.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28834196 28834196 PRJEB7366_P_NODE_16868_length_188_cov_1.718954_g16434_i0 PRJEB7366 16868 188 1.718954 3.23163352 Dysidea avara 196820 Porifera other_Eukaryota 93.2 8.13e-23   NR XP_065890751.1 196820 g16434 i0 70.5 9.73404255319149 61 16 97.3 1 183 1 1 59 XP_065890751.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Dysidea avara] diamond 1830 93.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28897287 28897287 PRJEB7366_P_NODE_7268_length_322_cov_1.756098_g6834_i0 PRJEB7366 7268 322 1.756098 5.65463556 Sycon ciliatum 27933 Porifera other_Eukaryota 148 9.13e-39   NR XP_065194361.1 27933 g6834 i0 72.9 3.98757763975155 107 29 99.7 0 321 1 596 702 XP_065194361.1 major vault protein-like [Sycon ciliatum] diamond 1284 148 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29465321 29465321 PRJEB7366_P_NODE_15670_length_197_cov_0.987654_g15236_i0 PRJEB7366 15670 197 0.987654 1.94567838 Sycon ciliatum 27933 Porifera other_Eukaryota 55.8 4.89e-7   NR XP_065196108.1 27933 g15236 i0 53.5 1.30964467005076 43 19 64 1 1 126 211 253 XP_065196108.1 uncharacterized protein LOC135827567 [Sycon ciliatum] diamond 258 55.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31013554 31013554 PRJEB7366_P_NODE_15895_length_195_cov_1.706250_g15461_i0 PRJEB7366 15895 195 1.70625 3.3271875 Amphimedon queenslandica 400682 Porifera other_Eukaryota 70.9 2.47e-12   NR XP_011403751.1 400682 g15461 i0 64.4 1.38461538461538 45 16 69.2 0 1 135 698 742 XP_011403751.1 PREDICTED: multidrug resistance protein 1A-like, partial [Amphimedon queenslandica] diamond 270 70.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
31013566 31013566 PRJEB7366_P_NODE_9235_length_277_cov_1.471074_g8801_i0 PRJEB7366 9235 277 1.471074 4.07487498 Oopsacas minuta 111878 Porifera other_Eukaryota 56.2 9.94e-7   NR KAI6650937.1 111878 g8801 i0 38.5 1.68953068592058 78 39 84.5 1 1 234 100 168 KAI6650937.1 Lysosome membrane protein 2-like [Oopsacas minuta] diamond 468 56.2 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
31234659 31234659 PRJEB7366_P_NODE_22155_length_160_cov_1.600000_g21721_i0 PRJEB7366 22155 160 1.6 2.56 Oscarella lobularis 121494 Porifera other_Eukaryota 43.5 0.00668   NR XP_065840784.1 121494 g21721 i0 64.5 0.58125 31 11 58.1 0 53 145 99 129 XP_065840784.1 uncharacterized protein [Oscarella lobularis] diamond 93 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31677542 31677542 PRJEB7366_P_NODE_23397_length_155_cov_1.583333_g22963_i0 PRJEB7366 23397 155 1.583333 2.45416615 Dysidea avara 196820 Porifera other_Eukaryota 48.9 7.43e-5   NR XP_065882326.1 196820 g22963 i0 84 1.45161290322581 25 4 48.4 0 3 77 503 527 XP_065882326.1 aspartate--tRNA ligase, cytoplasmic-like [Dysidea avara] diamond 225 48.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31986599 31986599 PRJEB7366_P_NODE_3198_length_531_cov_2.391129_g2791_i0 PRJEB7366 3198 531 2.391129 12.69689499 Opisthokonta 33154 Porifera other_Eukaryota 231 2.43e-74   NR XP_064399518.1 6063 g2791 i0 64.6 93.5875706214689 175 58 98.3 2 8 529 1 172 XP_064399518.1 ADP-ribosylation factor 4-like [Halichondria panicea] diamond 49695 233 0.991416309012876 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32113418 32113418 PRJEB7366_P_NODE_11138_length_245_cov_1.466667_g10704_i0 PRJEB7366 11138 245 1.466667 3.59333415 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 86.7 1.34e-17   NR XP_062500190.1 121492 g10704 i0 47.5 11.865306122449 80 42 98 0 244 5 342 421 XP_062500190.1 major vault protein-like [Corticium candelabrum] diamond 2907 87 0.996551724137931 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32650494 32650494 PRJEB7366_P_NODE_14400_length_208_cov_1.156069_g13966_i0 PRJEB7366 14400 208 1.156069 2.40462352 Opisthokonta 33154 Porifera other_Eukaryota 79.3 3.05e-15   NR XP_065184507.1 27933 g13966 i0 60.9 17.9134615384615 69 26 99.5 1 208 2 563 630 XP_065184507.1 eukaryotic translation initiation factor 3 subunit C-like [Sycon ciliatum] diamond 3726 79.3 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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