RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA896554" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA896554 · 13 ✖

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
17449785 17449785 PRJNA896554_P_NODE_49654_length_676_cov_12.698176_g42249_i0 PRJNA896554 49654 676 12.698176 85.83966976 Corticium candelabrum 121492 Porifera other_Eukaryota 154 5.27e-44   NR XP_062513731.1 121492 g42249 i0 65.3 0.53698224852071 121 42 53.7 0 621 259 2 122 XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] diamond 363 154 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
22548053 22548053 PRJNA896554_P_NODE_24378_length_1534_cov_3.182067_g19532_i0 PRJNA896554 24378 1534 3.182067 48.81290778 Opisthokonta 33154 Porifera other_Eukaryota 631 5.08e-223   NR XP_065174475.1 27933 g19532 i0 73 35.8631029986962 403 107 78.4 1 1470 268 24 426 XP_065174475.1 isocitrate dehydrogenase [NADP], mitochondrial-like [Sycon ciliatum] diamond 55014 631 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
26683438 26683438 PRJNA896554_P_NODE_62841_length_511_cov_1.805936_g55310_i0 PRJNA896554 62841 511 1.805936 9.22833296 Metazoa 33208 Porifera other_Eukaryota 47.8 0.0089   NR XP_065192631.1 27933 g55310 i0 91.3 1.16242661448141 23 2 13.5 0 45 113 586 608 XP_065192631.1 protein DD3-3-like [Sycon ciliatum] diamond 594 48.1 0.993762993762994 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
26810270 26810270 PRJNA896554_P_NODE_71861_length_444_cov_1.245283_g64321_i0 PRJNA896554 71861 444 1.245283 5.52905652 Porifera 6040 Porifera other_Eukaryota 136 5.14e-34   NR XP_065903858.1 196820 g64321 i0 67.4 1.85135135135135 92 29 61.5 1 170 442 298 389 XP_065903858.1 uncharacterized protein [Dysidea avara] diamond 822 136 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28760900 28760900 PRJNA896554_P_NODE_51407_length_648_cov_1.801739_g43960_i0 PRJNA896554 51407 648 1.801739 11.67526872 Haliclona caerulea 1131259 Porifera other_Eukaryota 66.2 5.45e-9   NR UST29452.1 1131259 g43960 i0 33.3 4.19907407407407 117 68 50.5 3 458 132 85 199 UST29452.1 blastula protease, partial [Haliclona caerulea] diamond 2721 66.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Chalinidae Haliclona Haliclona caerulea
28800081 28800081 PRJNA896554_P_NODE_72107_length_442_cov_1.924119_g64567_i0 PRJNA896554 72107 442 1.924119 8.50460598 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 161 3.6699999999999997e-47   NR XP_065175611.1 27933 g64567 i0 57.3 9.89592760180996 143 61 97.1 0 3 431 61 203 XP_065175611.1 small ribosomal subunit protein eS8-like [Sycon ciliatum] diamond 4374 161 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30245422 30245422 PRJNA896554_P_NODE_153392_length_250_cov_0.870056_g145852_i0 PRJNA896554 153392 250 0.870056 2.17514 Geodia barretti 519541 Porifera other_Eukaryota 79 3.68e-16   NR CAI8010848.1 519541 g145852 i0 50.6 1.02 85 40 99.6 1 1 249 33 117 CAI8010848.1 Sialidase-2 [Geodia barretti] diamond 255 79 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31351322 31351322 PRJNA896554_P_NODE_132576_length_272_cov_3.643216_g125036_i0 PRJNA896554 132576 272 3.643216 9.90954752 Oscarella lobularis 121494 Porifera other_Eukaryota 84.3 1.1e-16   NR XP_065840417.1 121494 g125036 i0 46.7 0.992647058823529 90 48 99.3 0 272 3 188 277 XP_065840417.1 glutathione reductase, mitochondrial-like [Oscarella lobularis] diamond 270 84.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31549004 31549004 PRJNA896554_P_NODE_109296_length_311_cov_0.970588_g101756_i0 PRJNA896554 109296 311 0.970588 3.01852868 Metazoa 33208 Porifera other_Eukaryota 54.7 5.36e-6   NR XP_065894835.1 196820 g101756 i0 40.6 2.7395498392283 101 51 96.5 3 2 301 80 172 XP_065894835.1 uncharacterized protein [Dysidea avara] diamond 852 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31864838 31864838 PRJNA896554_P_NODE_89037_length_364_cov_1.353952_g81497_i0 PRJNA896554 89037 364 1.353952 4.92838528 Metazoa 33208 Porifera other_Eukaryota 153 2.45e-40   NR XP_064400598.1 6063 g81497 i0 57.9 10.9697802197802 121 50 99.7 1 2 364 58 177 XP_064400598.1 protein DD3-3-like [Halichondria panicea] diamond 3993 154 0.993506493506494 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32149905 32149905 PRJNA896554_P_NODE_171058_length_242_cov_1.822485_g163518_i0 PRJNA896554 171058 242 1.822485 4.4104137 Opisthokonta 33154 Porifera other_Eukaryota 43.1 0.0267   NR XP_062506232.1 121492 g163518 i0 42.9 4.05371900826446 63 30 76.9 2 199 14 237 294 XP_062506232.1 uncharacterized protein LOC134182804 [Corticium candelabrum] diamond 981 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32522054 32522054 PRJNA896554_P_NODE_44399_length_777_cov_2.338068_g37179_i0 PRJNA896554 44399 777 2.338068 18.16678836 Geodia barretti 519541 Porifera other_Eukaryota 147 3.2299999999999993e-40   NR CAI8030757.1 519541 g37179 i0 52.5 0.617760617760618 160 61 59.1 6 494 36 18 169 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 480 147 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32710806 32710806 PRJNA896554_P_NODE_125040_length_283_cov_1.833333_g117500_i0 PRJNA896554 125040 283 1.833333 5.18833239 Amphimedon queenslandica 400682 Porifera other_Eukaryota 43.1 0.0451   NR XP_019854288.1 400682 g117500 i0 57.7 0.275618374558304 26 11 27.6 0 16 93 244 269 XP_019854288.1 PREDICTED: alsin-like [Amphimedon queenslandica] diamond 78 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica

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