RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA407886" 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

tax_clade 1

bioproject 1

  • PRJNA407886 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
4243981 4243981 PRJNA407886_P_NODE_18184_length_616_cov_1.421731_g16513_i0 PRJNA407886 18184 616 1.421731 8.75786296 Opisthokonta 33154 Porifera other_Eukaryota 231 2.41e-72   NR XP_062520409.1 121492 g16513 i0 66.9 17.8977272727273 175 58 85.2 0 90 614 1 175 XP_062520409.1 large ribosomal subunit protein uL10-like [Corticium candelabrum] diamond 11025 233 0.991416309012876 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
8070325 8070325 PRJNA407886_P_NODE_24647_length_484_cov_4.352798_g22956_i0 PRJNA407886 24647 484 4.352798 21.06754232 Dysidea avara 196820 Porifera other_Eukaryota 201 3.25e-63   NR XP_065913053.1 196820 g22956 i0 68.5 4.61776859504132 149 45 92.4 1 3 449 1 147 XP_065913053.1 large ribosomal subunit protein uL15-like [Dysidea avara] diamond 2235 201 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
15109597 15109597 PRJNA407886_P_NODE_17952_length_621_cov_5.388686_g16282_i0 PRJNA407886 17952 621 5.388686 33.46374006 Corticium candelabrum 121492 Porifera other_Eukaryota 214 1.3599999999999998e-66   NR XP_062516318.1 121492 g16282 i0 66.5 6.27536231884058 182 59 87.4 2 619 77 56 236 XP_062516318.1 small ribosomal subunit protein eS6-like [Corticium candelabrum] diamond 3897 214 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
26822521 26822521 PRJNA407886_P_NODE_78061_length_244_cov_0.900585_g76367_i0 PRJNA407886 78061 244 0.900585 2.1974274 Sycon ciliatum 27933 Porifera other_Eukaryota 48.1 4.8e-4   NR XP_065184792.1 27933 g76367 i0 48.7 1.52459016393443 39 20 48 0 243 127 651 689 XP_065184792.1 alpha-L-rhamnosidase-like isoform X2 [Sycon ciliatum] diamond 372 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27281929 27281929 PRJNA407886_P_NODE_74183_length_247_cov_1.327586_g72489_i0 PRJNA407886 74183 247 1.327586 3.27913742 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 52.4 1.52e-5   NR XP_064389792.1 6063 g72489 i0 33.8 1.65182186234818 80 40 97.2 2 247 8 292 358 XP_064389792.1 uncharacterized protein LOC135337747 [Halichondria panicea] diamond 408 52.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27423398 27423398 PRJNA407886_P_NODE_48483_length_310_cov_1.118143_g46789_i0 PRJNA407886 48483 310 1.118143 3.4662433 Halichondria panicea 6063 Porifera other_Eukaryota 114 4.0199999999999998e-28   NR XP_064392077.1 6063 g46789 i0 50 0.967741935483871 100 49 96.8 1 302 3 210 308 XP_064392077.1 serine dehydratase-like [Halichondria panicea] diamond 300 114 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28465249 28465249 PRJNA407886_P_NODE_71286_length_250_cov_0.870056_g69592_i0 PRJNA407886 71286 250 0.870056 2.17514 Sycon ciliatum 27933 Porifera other_Eukaryota 61.6 9.31e-9   NR XP_065192083.1 27933 g69592 i0 55.2 9.264 58 23 66 1 166 2 649 706 XP_065192083.1 probable ATP-dependent RNA helicase DHX37 [Sycon ciliatum] diamond 2316 61.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28875528 28875528 PRJNA407886_P_NODE_33628_length_387_cov_1.385350_g31934_i0 PRJNA407886 33628 387 1.38535 5.3613045 Oscarella lobularis 121494 Porifera other_Eukaryota 188 5.630000000000001e-59   NR XP_065826293.1 121494 g31934 i0 74.4 7.75968992248062 125 32 96.9 0 377 3 1 125 XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] diamond 3003 188 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29050202 29050202 PRJNA407886_P_NODE_23768_length_498_cov_3.769412_g22077_i0 PRJNA407886 23768 498 3.769412 18.77167176 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 154 2.1099999999999998e-43   NR XP_064390747.1 6063 g22077 i0 60.5 10.7349397590361 147 55 88 2 2 439 94 238 XP_064390747.1 small ribosomal subunit protein eS6-like [Halichondria panicea] diamond 5346 155 0.993548387096774 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29223045 29223045 PRJNA407886_P_NODE_37309_length_362_cov_1.062284_g35615_i0 PRJNA407886 37309 362 1.062284 3.84546808 Tethya aurantium 281732 Porifera other_Eukaryota 161 3.27e-45   NR AAS72895.1 281732 g35615 i0 64.2 4.98895027624309 120 43 99.4 0 362 3 104 223 AAS72895.1 mitochondrial creatine kinase CK2 [Tethya aurantium] diamond 1806 161 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tethyida Tethyidae Tethya Tethya aurantium
29871055 29871055 PRJNA407886_P_NODE_56911_length_283_cov_1.090476_g55217_i0 PRJNA407886 56911 283 1.090476 3.08604708 Metazoa 33208 Porifera other_Eukaryota 81.3 1.82e-15   NR XP_065888782.1 196820 g55217 i0 42 8.62897526501767 88 32 93.3 1 20 283 954 1022 XP_065888782.1 dnaJ homolog subfamily C member 13-like [Dysidea avara] diamond 2442 82 0.991463414634146 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30391922 30391922 PRJNA407886_P_NODE_43473_length_330_cov_1.194553_g41779_i0 PRJNA407886 43473 330 1.194553 3.9420249 Oscarella lobularis 121494 Porifera other_Eukaryota 151 7.24e-40   NR XP_065830064.1 121494 g41779 i0 58.7 1.98181818181818 109 44 99.1 1 3 329 114 221 XP_065830064.1 protein DD3-3-like [Oscarella lobularis] diamond 654 151 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
30565752 30565752 PRJNA407886_P_NODE_29933_length_419_cov_1.387283_g28240_i0 PRJNA407886 29933 419 1.387283 5.81271577 Porifera 6040 Porifera other_Eukaryota 59.3 4.28e-7   NR XP_064385052.1 6063 g28240 i0 41.7 1.23150357995227 72 40 51.6 1 32 247 966 1035 XP_064385052.1 uncharacterized protein LOC135333952 isoform X2 [Halichondria panicea] diamond 516 59.7 0.993299832495812 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31244534 31244534 PRJNA407886_P_NODE_61535_length_270_cov_1.563452_g59841_i0 PRJNA407886 61535 270 1.563452 4.2213204 Dysidea avara 196820 Porifera other_Eukaryota 86.3 1.5e-17   NR XP_065910124.1 196820 g59841 i0 47.2 1.82222222222222 89 47 98.9 0 268 2 282 370 XP_065910124.1 26S proteasome non-ATPase regulatory subunit 13-like [Dysidea avara] diamond 492 86.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31497745 31497745 PRJNA407886_P_NODE_19256_length_587_cov_3.949416_g17580_i0 PRJNA407886 19256 587 3.949416 23.18307192 Geodia barretti 519541 Porifera other_Eukaryota 99 5.28e-22   NR CAI8029397.1 519541 g17580 i0 51.5 0.526405451448041 103 42 50.6 3 334 38 97 195 CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti] diamond 309 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31529399 31529399 PRJNA407886_P_NODE_66496_length_258_cov_1.567568_g64802_i0 PRJNA407886 66496 258 1.567568 4.04432544 Aulosaccus sp. GV-2 668579 Porifera other_Eukaryota 94.4 5.45e-22   NR ACU86972.1 668579 g64802 i0 63.1 4.7093023255814 65 23 74.4 1 194 3 7 71 ACU86972.1 cathepsin L1, partial [Aulosaccus sp. GV-2009] diamond 1215 94.4 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Rossellidae Aulosaccus Aulosaccus sp. GV-2009
31767227 31767227 PRJNA407886_P_NODE_27717_length_442_cov_1.252033_g26024_i0 PRJNA407886 27717 442 1.252033 5.53398586 Opisthokonta 33154 Porifera other_Eukaryota 141 6.329999999999999e-37   NR XP_065842901.1 121494 g26024 i0 50 5.94570135746606 146 66 99.1 2 3 440 138 276 XP_065842901.1 ornithine decarboxylase-like isoform X2 [Oscarella lobularis] diamond 2628 141 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32003824 32003824 PRJNA407886_P_NODE_80338_length_242_cov_0.911243_g78644_i0 PRJNA407886 80338 242 0.911243 2.20520806 Oscarella lobularis 121494 Porifera other_Eukaryota 71.2 2.58e-12   NR XP_065826539.1 121494 g78644 i0 61.2 6.90495867768595 49 19 60.7 0 149 3 26 74 XP_065826539.1 uncharacterized protein [Oscarella lobularis] diamond 1671 71.2 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32383471 32383471 PRJNA407886_P_NODE_81359_length_241_cov_0.916667_g79665_i0 PRJNA407886 81359 241 0.916667 2.20916747 Halichondria panicea 6063 Porifera other_Eukaryota 95.5 7.960000000000001e-21   NR XP_064382625.1 6063 g79665 i0 55.7 2.95020746887967 79 35 98.3 0 3 239 352 430 XP_064382625.1 cytoplasmic dynein 2 intermediate chain 2-like [Halichondria panicea] diamond 711 95.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32415222 32415222 PRJNA407886_P_NODE_75499_length_246_cov_0.890173_g73805_i0 PRJNA407886 75499 246 0.890173 2.18982558 Halichondria panicea 6063 Porifera other_Eukaryota 45.8 0.00327   NR XP_064384572.1 6063 g73805 i0 36.6 1 82 49 97.6 2 243 4 745 825 XP_064384572.1 mucin-2-like [Halichondria panicea] diamond 246 45.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32573478 32573478 PRJNA407886_P_NODE_21619_length_536_cov_5.302376_g19933_i0 PRJNA407886 21619 536 5.302376 28.42073536 Geodia barretti 519541 Porifera other_Eukaryota 99.8 1.6000000000000002e-22   NR CAI8029397.1 519541 g19933 i0 51.4 0.587686567164179 105 43 56.5 3 323 21 97 197 CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti] diamond 315 99.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32762143 32762143 PRJNA407886_P_NODE_28580_length_432_cov_1.715877_g26887_i0 PRJNA407886 28580 432 1.715877 7.41258864 Suberites domuncula 55567 Porifera other_Eukaryota 136 1.98e-38   NR AAX48868.1 55567 g26887 i0 64.2 2.59722222222222 123 43 85.4 1 39 407 1 122 AAX48868.1 L35 [Suberites domuncula] diamond 1122 136 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula

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