RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB75017" 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

tax_clade 1

bioproject 1

  • PRJEB75017 · 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
995575 995575 PRJEB75017_P_NODE_4061_length_435_cov_2.223757_g3932_i0 PRJEB75017 4061 435 2.223757 9.67334295 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 123 3.19e-32   NR XP_065175611.1 27933 g3932 i0 51 46.0758620689655 143 48 98.6 3 7 435 73 193 XP_065175611.1 small ribosomal subunit protein eS8-like [Sycon ciliatum] diamond 20043 124 0.991935483870968 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
3961528 3961528 PRJEB75017_P_NODE_624_length_1041_cov_3.315083_g537_i0 PRJEB75017 624 1041 3.315083 34.51001403 Porifera 6040 Porifera other_Eukaryota 354 3.539999999999999e-118   NR XP_019864009.1 400682 g537 i0 56.8 4.59077809798271 329 130 92.5 4 1030 68 2 326 XP_019864009.1 PREDICTED: cathepsin L1-like isoform X3 [Amphimedon queenslandica] diamond 4779 354 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
9062596 9062596 PRJEB75017_P_NODE_12428_length_265_cov_1.515625_g12299_i0 PRJEB75017 12428 265 1.515625 4.01640625 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.024   NTclustered gi|1133490048|ref|XM_011410244.2| 400682 g12299 i0 100 0.211320754716981 28 0 11 0 23 50 1489 1516 PREDICTED: Amphimedon queenslandica uncharacterized protein C1orf228-like (LOC100635372), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
11613901 11613901 PRJEB75017_P_NODE_7950_length_319_cov_0.951220_g7821_i0 PRJEB75017 7950 319 0.95122 3.0343918 Oscarella lobularis 121494 Porifera other_Eukaryota 163 1.8899999999999998e-46   NR XP_065828019.1 121494 g7821 i0 70.8 0.996865203761755 106 31 99.7 0 2 319 183 288 XP_065828019.1 uncharacterized protein [Oscarella lobularis] diamond 318 163 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
12888915 12888915 PRJEB75017_P_NODE_17611_length_244_cov_0.912281_g17482_i0 PRJEB75017 17611 244 0.912281 2.22596564 Dysidea cf. arenaria JV-2020 2742473 Porifera other_Eukaryota 165 2.71e-36   NTclustered gi|1849571333|gb|MT571644.1| 2742473 g17482 i0 80 13.5819672131148 235 38 95 7 2 232 535 764 Dysidea cf. arenaria JV-2020 voucher UF 3724 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial blastn 3314 165 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea cf. arenaria JV-2020
13748990 13748990 PRJEB75017_P_NODE_4711_length_404_cov_1.854985_g4582_i0 PRJEB75017 4711 404 1.854985 7.4941394 Metazoa 33208 Porifera other_Eukaryota 168 7.81e-49   NR XP_064395651.1 6063 g4582 i0 70.3 11.1534653465347 118 35 87.6 0 1 354 18 135 XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] diamond 4506 168 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
26685834 26685834 PRJEB75017_P_NODE_12641_length_263_cov_1.331579_g12512_i0 PRJEB75017 12641 263 1.331579 3.50205277 Halichondria panicea 6063 Porifera other_Eukaryota 55.8 1.03e-6   NR XP_064406772.1 6063 g12512 i0 40.2 3.6958174904943 87 50 99.2 1 2 262 209 293 XP_064406772.1 uncharacterized protein LOC135351639 [Halichondria panicea] diamond 972 55.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
26970743 26970743 PRJEB75017_P_NODE_1922_length_626_cov_1.222423_g1795_i0 PRJEB75017 1922 626 1.222423 7.65236798 Oscarella lobularis 121494 Porifera other_Eukaryota 55.5 4.53e-5   NR XP_065830564.1 121494 g1795 i0 36.8 1.0926517571885 95 54 44.1 3 3 278 464 555 XP_065830564.1 uncharacterized protein [Oscarella lobularis] diamond 684 55.5 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
27855414 27855414 PRJEB75017_P_NODE_5885_length_364_cov_0.941581_g5756_i0 PRJEB75017 5885 364 0.941581 3.42735484 Sycon ciliatum 27933 Porifera other_Eukaryota 189 9.479999999999998e-55   NR XP_065176480.1 27933 g5756 i0 78.5 6.98076923076923 121 26 99.7 0 1 363 296 416 XP_065176480.1 T-complex protein 1 subunit zeta-like [Sycon ciliatum] diamond 2541 189 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27981810 27981810 PRJEB75017_P_NODE_13385_length_256_cov_1.278689_g13256_i0 PRJEB75017 13385 256 1.278689 3.27344384 Sycon ciliatum 27933 Porifera other_Eukaryota 67 1.3099999999999999e-10   NR XP_065197105.1 27933 g13256 i0 67.5 2.80078125 83 27 97.3 0 1 249 5274 5356 XP_065197105.1 uncharacterized protein LOC135828604 [Sycon ciliatum] diamond 717 67 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29332233 29332233 PRJEB75017_P_NODE_16109_length_247_cov_1.689655_g15980_i0 PRJEB75017 16109 247 1.689655 4.17344785 Metazoa 33208 Porifera other_Eukaryota 110 4.06e-26   NR XP_065910049.1 196820 g15980 i0 64.2 5.90283400809717 81 28 98.4 1 3 245 19 98 XP_065910049.1 protein DD3-3-like [Dysidea avara] diamond 1458 110 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29339539 29339539 PRJEB75017_P_NODE_17909_length_243_cov_0.917647_g17780_i0 PRJEB75017 17909 243 0.917647 2.22988221 Geodia barretti 519541 Porifera other_Eukaryota 47.4 9.05e-4   NR CAI8054553.1 519541 g17780 i0 37.3 5.49382716049383 75 46 91.4 1 234 13 172 246 CAI8054553.1 Rapamycin-insensitive companion of mTOR [Geodia barretti] diamond 1335 47.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29876307 29876307 PRJEB75017_P_NODE_14691_length_251_cov_0.876404_g14562_i0 PRJEB75017 14691 251 0.876404 2.19977404 Amphimedon queenslandica 400682 Porifera other_Eukaryota 42.7 0.0422   NR XP_019850553.1 400682 g14562 i0 47.1 0.609561752988048 51 25 58.6 1 103 249 590 640 XP_019850553.1 PREDICTED: son of sevenless homolog 1-like [Amphimedon queenslandica] diamond 153 42.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
30128646 30128646 PRJEB75017_P_NODE_8492_length_309_cov_1.724576_g8363_i0 PRJEB75017 8492 309 1.724576 5.32893984 Dysidea avara 196820 Porifera other_Eukaryota 43.9 0.0276   NR XP_065912097.1 196820 g8363 i0 34.4 0.592233009708738 61 40 59.2 0 244 62 204 264 XP_065912097.1 voltage-dependent anion-selective channel protein 2-like [Dysidea avara] diamond 183 43.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30666003 30666003 PRJEB75017_P_NODE_10513_length_284_cov_1.109005_g10384_i0 PRJEB75017 10513 284 1.109005 3.1495742 Corticium candelabrum 121492 Porifera other_Eukaryota 93.6 1.92e-20   NR XP_062509307.1 121492 g10384 i0 48.9 1.98591549295775 94 48 99.3 0 284 3 88 181 XP_062509307.1 3-ketodihydrosphingosine reductase-like [Corticium candelabrum] diamond 564 93.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31361497 31361497 PRJEB75017_P_NODE_4636_length_407_cov_1.167665_g4507_i0 PRJEB75017 4636 407 1.167665 4.75239655 Halichondria panicea 6063 Porifera other_Eukaryota 99 4.88e-21   NR XP_064404771.1 6063 g4507 i0 48.1 3.72972972972973 129 50 92.9 3 404 27 543 657 XP_064404771.1 heat shock cognate 71 kDa protein-like [Halichondria panicea] diamond 1518 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31828363 31828363 PRJEB75017_P_NODE_3097_length_497_cov_3.422170_g2968_i0 PRJEB75017 3097 497 3.42217 17.0081849 Metazoa 33208 Porifera other_Eukaryota 51.2 4.96e-4   NR XP_062508855.1 121492 g2968 i0 37.8 3.94164989939638 74 34 44.7 1 108 329 68 129 XP_062508855.1 uncharacterized protein LOC134185084 isoform X2 [Corticium candelabrum] diamond 1959 51.6 0.992248062015504 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31835580 31835580 PRJEB75017_P_NODE_10997_length_279_cov_1.402913_g10868_i0 PRJEB75017 10997 279 1.402913 3.91412727 Dysidea avara 196820 Porifera other_Eukaryota 50.8 8.49e-5   NR XP_065905671.1 196820 g10868 i0 62.9 1.12903225806452 35 13 37.6 0 48 152 6991 7025 XP_065905671.1 uncharacterized protein [Dysidea avara] diamond 315 50.8 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);;