RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1196384 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
2318530 2318530 PRJNA1196384_S_NODE_622_length_478_cov_4.782313_g559_i0 PRJNA1196384 622 478 4.782313 22.85945614 Suberitida 1779162 Porifera other_Eukaryota 230 2.23e-74   NR XP_064407071.1 6063 g559 i0 71.5 2.97489539748954 158 42 99.2 1 2 475 16 170 XP_064407071.1 large ribosomal subunit protein eL18-like [Halichondria panicea] diamond 1422 230 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
7976003 7976003 PRJNA1196384_S_NODE_207_length_750_cov_3.539972_g161_i0 PRJNA1196384 207 750 3.539972 26.54979 Dysidea avara 196820 Porifera other_Eukaryota 297 1.84e-98   NR XP_065898052.1 196820 g161 i0 62.8 0.936 234 87 93.6 0 704 3 5 238 XP_065898052.1 large ribosomal subunit protein uL30-like [Dysidea avara] diamond 702 297 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
9971256 9971256 PRJNA1196384_S_NODE_1468_length_321_cov_5.232394_g1404_i0 PRJNA1196384 1468 321 5.232394 16.79598474 Metazoa 33208 Porifera other_Eukaryota 145 1.72e-41   NR XP_062504869.1 121492 g1404 i0 75.8 2.55140186915888 91 22 85 0 2 274 114 204 XP_062504869.1 large ribosomal subunit protein eL15-like [Corticium candelabrum] diamond 819 145 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
13076358 13076358 PRJNA1196384_S_NODE_771_length_435_cov_2.839196_g707_i0 PRJNA1196384 771 435 2.839196 12.3505026 Metazoa 33208 Porifera other_Eukaryota 214 1.76e-67   NR XP_065836436.1 121494 g707 i0 73.4 2.95862068965517 143 38 98.6 0 433 5 7 149 XP_065836436.1 small ribosomal subunit protein eS6-like [Oscarella lobularis] diamond 1287 214 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
15625432 15625432 PRJNA1196384_S_NODE_1653_length_305_cov_3.988806_g1589_i0 PRJNA1196384 1653 305 3.988806 12.1658583 Opisthokonta 33154 Porifera other_Eukaryota 144 5.439999999999999e-42   NR CCQ18628.1 27933 g1589 i0 80.7 2.45901639344262 83 16 81.6 0 1 249 50 132 CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum] diamond 750 144 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
18894653 18894653 PRJNA1196384_S_NODE_835_length_420_cov_5.430809_g771_i0 PRJNA1196384 835 420 5.430809 22.8093978 Metazoa 33208 Porifera other_Eukaryota 170 1.11e-51   NR AAX48860.1 55567 g771 i0 61.6 6.25 125 48 89.3 0 420 46 12 136 AAX48860.1 L27 [Suberites domuncula] diamond 2625 170 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
21999545 21999545 PRJNA1196384_S_NODE_898_length_404_cov_3.487738_g834_i0 PRJNA1196384 898 404 3.487738 14.09046152 Dysidea avara 196820 Porifera other_Eukaryota 147 7.839999999999999e-43   NR XP_065916847.1 196820 g834 i0 68.1 0.883663366336634 119 38 88.4 0 403 47 4 122 XP_065916847.1 large ribosomal subunit protein uL29-like [Dysidea avara] diamond 357 147 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
26679764 26679764 PRJNA1196384_S_NODE_7401_length_157_cov_1.466667_g7337_i0 PRJNA1196384 7401 157 1.466667 2.30266719 Metazoa 33208 Porifera other_Eukaryota 77.8 4.88e-15   NR XP_064391610.1 6063 g7337 i0 77.1 10.5477707006369 48 11 91.7 0 155 12 799 846 XP_064391610.1 major vault protein-like [Halichondria panicea] diamond 1656 77.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27103908 27103908 PRJNA1196384_S_NODE_1422_length_325_cov_3.579861_g1358_i0 PRJNA1196384 1422 325 3.579861 11.63454825 Sycon ciliatum 27933 Porifera other_Eukaryota 146 7.05e-42   NR XP_065178541.1 27933 g1358 i0 73.6 3.91384615384615 106 28 97.8 0 323 6 12 117 XP_065178541.1 large ribosomal subunit protein eL13-like [Sycon ciliatum] diamond 1272 146 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27344519 27344519 PRJNA1196384_S_NODE_1983_length_278_cov_4.834025_g1919_i0 PRJNA1196384 1983 278 4.834025 13.4385895 root 1 Root_unresolved Root_unresolved 102 2.99e-24   NR XP_062507858.1 121492 g1919 i0 69.6 2.19064748201439 69 20 73.4 1 276 73 208 276 XP_062507858.1 small ribosomal subunit protein uS5 [Corticium candelabrum] diamond 609 102 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27988477 27988477 PRJNA1196384_S_NODE_1405_length_327_cov_2.258621_g1341_i0 PRJNA1196384 1405 327 2.258621 7.38569067 Oscarella lobularis 121494 Porifera other_Eukaryota 118 1.88e-29   NR XP_065838198.1 121494 g1341 i0 55.3 2.3302752293578 85 38 78 0 1 255 244 328 XP_065838198.1 uncharacterized protein [Oscarella lobularis] diamond 762 118 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
30596818 30596818 PRJNA1196384_S_NODE_3973_length_199_cov_1.388889_g3909_i0 PRJNA1196384 3973 199 1.388889 2.76388911 Porifera 6040 Porifera other_Eukaryota 43.9 0.00395   NR XP_064388996.1 6063 g3909 i0 36.5 1.76381909547739 52 33 78.4 0 3 158 15 66 XP_064388996.1 uncharacterized protein LOC135337030 [Halichondria panicea] diamond 351 43.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30754987 30754987 PRJNA1196384_S_NODE_3074_length_222_cov_1.145946_g3010_i0 PRJNA1196384 3074 222 1.145946 2.54400012 Metazoa 33208 Porifera other_Eukaryota 68.6 2.33e-11   NR XP_065175264.1 27933 g3010 i0 69.8 10.2567567567568 43 13 58.1 0 4 132 838 880 XP_065175264.1 alpha-actinin, sarcomeric-like [Sycon ciliatum] diamond 2277 68.9 0.995645863570392 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30894104 30894104 PRJNA1196384_S_NODE_3914_length_200_cov_2.374233_g3850_i0 PRJNA1196384 3914 200 2.374233 4.748466 Oscarella lobularis 121494 Porifera other_Eukaryota 45.8 0.00118   NR XP_065831338.1 121494 g3850 i0 36.9 0.975 65 40 97.5 1 3 197 121 184 XP_065831338.1 uncharacterized protein [Oscarella lobularis] diamond 195 45.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
30976221 30976221 PRJNA1196384_S_NODE_2034_length_274_cov_4.194093_g1970_i0 PRJNA1196384 2034 274 4.194093 11.49181482 Metazoa 33208 Porifera other_Eukaryota 133 3.01e-38   NR XP_062518002.1 121492 g1970 i0 84.2 8.4963503649635 76 12 83.2 0 273 46 32 107 XP_062518002.1 large ribosomal subunit protein eL43-like [Corticium candelabrum] diamond 2328 133 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31052183 31052183 PRJNA1196384_S_NODE_1415_length_326_cov_1.851211_g1351_i0 PRJNA1196384 1415 326 1.851211 6.03494786 Amphimedon queenslandica 400682 Porifera other_Eukaryota 93.2 1.55e-21   NR XP_003390483.1 400682 g1351 i0 67.6 1.36196319018405 74 21 68.1 1 326 105 80 150 XP_003390483.1 PREDICTED: myosin-2 essential light chain-like isoform X2 [Amphimedon queenslandica] diamond 444 93.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
31558034 31558034 PRJNA1196384_S_NODE_8156_length_152_cov_1.339130_g8092_i0 PRJNA1196384 8156 152 1.33913 2.0354776 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 1.53e-6   NR XP_065846837.1 121494 g8092 i0 50 0.986842105263158 50 20 98.7 1 152 3 60 104 XP_065846837.1 large ribosomal subunit protein eL18-like [Oscarella lobularis] diamond 150 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32285791 32285791 PRJNA1196384_S_NODE_5859_length_171_cov_2.014925_g5795_i0 PRJNA1196384 5859 171 2.014925 3.44552175 Corticium candelabrum 121492 Porifera other_Eukaryota 49.7 3.04e-5   NR XP_062511357.1 121492 g5795 i0 44.9 0.859649122807018 49 27 86 0 161 15 40 88 XP_062511357.1 uncharacterized protein LOC134187252 [Corticium candelabrum] diamond 147 49.7 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32507192 32507192 PRJNA1196384_S_NODE_539_length_508_cov_3.382166_g477_i0 PRJNA1196384 539 508 3.382166 17.18140328 Corticium candelabrum 121492 Porifera other_Eukaryota 52.4 1.95e-4   NR XP_062506628.1 121492 g477 i0 44.9 0.40748031496063 69 38 40.7 0 292 498 279 347 XP_062506628.1 myc proto-oncogene protein-like isoform X3 [Corticium candelabrum] diamond 207 52.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32872417 32872417 PRJNA1196384_S_NODE_1240_length_347_cov_4.038710_g1176_i0 PRJNA1196384 1240 347 4.03871 14.0143237 Porifera 6040 Porifera other_Eukaryota 142 7.77e-41   NR CCQ18628.1 27933 g1176 i0 75.8 6.38040345821326 91 22 78.7 0 347 75 41 131 CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum] diamond 2214 142 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);;