RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA674308 · 18 ✖
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
24870862 24870862 PRJNA674308_P_NODE_25480_length_198_cov_1.973154_g25245_i0 PRJNA674308 25480 198 1.973154 3.90684492 Amphimedon queenslandica 400682 Porifera other_Eukaryota 108 3.61e-19   NTclustered gi|1133464914|ref|XM_003387132.2| 400682 g25245 i0 82.645 4.66161616161616 121 21 61 0 54 174 190 70 PREDICTED: Amphimedon queenslandica ras-related C3 botulinum toxin substrate 1-like (LOC100636749), mRNA blastn 923 108 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
26669965 26669965 PRJNA674308_P_NODE_24721_length_201_cov_1.131579_g24486_i0 PRJNA674308 24721 201 1.131579 2.27447379 Dysidea avara 196820 Porifera other_Eukaryota 62 3.37e-9   NR XP_065910437.1 196820 g24486 i0 55.8 0.776119402985075 52 23 77.6 0 157 2 1 52 XP_065910437.1 protein SDA1 homolog [Dysidea avara] diamond 156 62 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
26765310 26765310 PRJNA674308_P_NODE_4361_length_459_cov_1.892683_g4126_i0 PRJNA674308 4361 459 1.892683 8.68741497 Amphimedon queenslandica 400682 Porifera other_Eukaryota 128 4.63e-33   NR XP_019848655.1 400682 g4126 i0 53.1 0.738562091503268 113 53 73.9 0 458 120 170 282 XP_019848655.1 PREDICTED: N-acetylglucosamine-1-phosphodiester alpha-N-acetylglucosaminidase-like [Amphimedon queenslandica] diamond 339 128 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
27062049 27062049 PRJNA674308_P_NODE_26922_length_193_cov_1.798611_g26687_i0 PRJNA674308 26922 193 1.798611 3.47131923 root 1 Root_unresolved Root_unresolved 63.9 6.49e-10   NR CAI8011479.1 519541 g26687 i0 50 11.9378238341969 64 27 99.5 1 1 192 115 173 CAI8011479.1 Putative K(+)-stimulated pyrophosphate-energized sodium pump [Geodia barretti] diamond 2304 63.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
27156539 27156539 PRJNA674308_P_NODE_1162_length_926_cov_2.241733_g994_i0 PRJNA674308 1162 926 2.241733 20.75844758 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 327 8.049999999999998e-107   NR XP_065187034.1 27933 g994 i0 58 8.72786177105831 264 107 85.2 3 30 818 138 398 XP_065187034.1 beta-1,3-glucan-binding protein-like [Sycon ciliatum] diamond 8082 327 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28293712 28293712 PRJNA674308_P_NODE_21226_length_214_cov_2.206061_g20991_i0 PRJNA674308 21226 214 2.206061 4.72097054 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 78.2 1.44e-16   NR XP_065199206.1 27933 g20991 i0 57.1 2.94392523364486 70 27 98.1 1 3 212 11 77 XP_065199206.1 large ribosomal subunit protein eL22-like [Sycon ciliatum] diamond 630 78.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28609590 28609590 PRJNA674308_P_NODE_50007_length_163_cov_0.912281_g49772_i0 PRJNA674308 50007 163 0.912281 1.48701803 Metazoa 33208 Porifera other_Eukaryota 82.8 9.68e-17   NR XP_064392702.1 6063 g49772 i0 90 787.950920245399 40 4 73.6 0 2 121 1528 1567 XP_064392702.1 helicase domino-like [Halichondria panicea] diamond 128436 83.2 0.995192307692308 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29387153 29387153 PRJNA674308_P_NODE_22669_length_209_cov_0.975000_g22434_i0 PRJNA674308 22669 209 0.975 2.03775 Suberites domuncula 55567 Porifera other_Eukaryota 42.7 0.0107   NR AAX48862.1 55567 g22434 i0 39.4 0.947368421052632 66 37 94.7 2 209 12 33 95 AAX48862.1 L28 [Suberites domuncula] diamond 198 42.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
29840989 29840989 PRJNA674308_P_NODE_17451_length_233_cov_1.358696_g17216_i0 PRJNA674308 17451 233 1.358696 3.16576168 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 51.2 3.2e-5   NR XP_065898984.1 196820 g17216 i0 40.7 5.33047210300429 59 35 76 0 219 43 235 293 XP_065898984.1 G2/mitotic-specific cyclin-B-like isoform X2 [Dysidea avara] diamond 1242 51.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30555519 30555519 PRJNA674308_P_NODE_22513_length_209_cov_1.812500_g22278_i0 PRJNA674308 22513 209 1.8125 3.788125 Suberites ficus 86007 Porifera other_Eukaryota 65.1 3.02e-10   NR ABB29664.1 86007 g22278 i0 46.3 4.44976076555024 67 35 96.2 1 208 8 99 164 ABB29664.1 ATPase alpha-subunit, partial [Suberites ficus] diamond 930 65.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites ficus
30587131 30587131 PRJNA674308_P_NODE_14413_length_254_cov_1.268293_g14178_i0 PRJNA674308 14413 254 1.268293 3.22146422 Oopsacas minuta 111878 Porifera other_Eukaryota 116 2.14e-29   NR KAI6646617.1 111878 g14178 i0 65.5 0.992125984251969 84 27 99.2 1 2 253 70 151 KAI6646617.1 Tartrate-resistant acid phosphatase type 5 [Oopsacas minuta] diamond 252 116 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
30934962 30934962 PRJNA674308_P_NODE_29134_length_187_cov_1.130435_g28899_i0 PRJNA674308 29134 187 1.130435 2.11391345 Dysidea avara 196820 Porifera other_Eukaryota 44.3 0.00514   NR XP_065920409.1 196820 g28899 i0 56.1 0.657754010695187 41 17 65.8 1 124 2 4 43 XP_065920409.1 protein F37C4.5-like [Dysidea avara] diamond 123 44.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31230940 31230940 PRJNA674308_P_NODE_9915_length_302_cov_2.268775_g9680_i0 PRJNA674308 9915 302 2.268775 6.8517005 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 133 9.279999999999999e-35   NR XP_064388451.1 6063 g9680 i0 58 7.91721854304636 100 42 99.3 0 3 302 209 308 XP_064388451.1 uncharacterized protein LOC135336535 [Halichondria panicea] diamond 2391 134 0.992537313432836 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31504083 31504083 PRJNA674308_P_NODE_42256_length_166_cov_1.717949_g42021_i0 PRJNA674308 42256 166 1.717949 2.85179534 Corticium candelabrum 121492 Porifera other_Eukaryota 50.8 1.84e-5   NR XP_062506349.1 121492 g42021 i0 48.1 0.939759036144578 52 26 94 1 162 7 57 107 XP_062506349.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit B-like [Corticium candelabrum] diamond 156 50.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31661869 31661869 PRJNA674308_P_NODE_30677_length_182_cov_2.345865_g30442_i0 PRJNA674308 30677 182 2.345865 4.2694743 Sycon ciliatum 27933 Porifera other_Eukaryota 77.8 5.79e-15   NR XP_065196827.1 27933 g30442 i0 52.5 1.94505494505495 59 28 97.3 0 5 181 198 256 XP_065196827.1 lysosomal aspartic protease-like [Sycon ciliatum] diamond 354 77.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31820069 31820069 PRJNA674308_P_NODE_21777_length_212_cov_1.877301_g21542_i0 PRJNA674308 21777 212 1.877301 3.97987812 Halisarca dujardinii 2583056 Porifera other_Eukaryota 75.9 5.2e-14   NR WNS50071.1 2583056 g21542 i0 49.2 0.891509433962264 63 32 89.2 0 20 208 235 297 WNS50071.1 alpha-glucosidase [Halisarca dujardinii] diamond 189 75.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Chondrillida Halisarcidae Halisarca Halisarca dujardinii
32010087 32010087 PRJNA674308_P_NODE_49818_length_163_cov_0.912281_g49583_i0 PRJNA674308 49818 163 0.912281 1.48701803 Amphimedon queenslandica 400682 Porifera other_Eukaryota 58.9 2.46e-8   NR XP_019854831.1 400682 g49583 i0 50 0.883435582822086 48 24 88.3 0 17 160 30 77 XP_019854831.1 PREDICTED: E3 ubiquitin-protein ligase CHFR-like [Amphimedon queenslandica] diamond 144 58.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32579689 32579689 PRJNA674308_P_NODE_37179_length_169_cov_0.866667_g36944_i0 PRJNA674308 37179 169 0.866667 1.46466723 Dysidea avara 196820 Porifera other_Eukaryota 68.2 1.4e-11   NR XP_065917725.1 196820 g36944 i0 54.5 5.78698224852071 55 24 97.6 1 3 167 158 211 XP_065917725.1 zinc finger protein ZPR1-like isoform X2 [Dysidea avara] diamond 978 68.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara

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