RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 5

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA588137 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
564765 564765 PRJNA588137_S_NODE_281_length_839_cov_2.159269_g258_i0 PRJNA588137 281 839 2.159269 18.11626691 Idotea baltica 82763 Arthropoda Arthropoda 397 9.089999999999998e-132   NR MCL4154024.1 82763 g258 i0 85.4 0.854588796185936 239 35 85.5 0 63 779 364 602 MCL4154024.1 hypothetical protein [Idotea baltica] diamond 717 397 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
18416613 18416613 PRJNA588137_S_NODE_4995_length_274_cov_1.149254_g4962_i0 PRJNA588137 4995 274 1.149254 3.14895596 Metazoa 33208 Porifera other_Eukaryota 169 3.19e-49   NR CCQ18610.1 27933 g4962 i0 86.8 85.6861313868613 91 12 99.6 0 274 2 29 119 CCQ18610.1 ribosomal protein RPL1/RPL2/RL4L4 [Sycon ciliatum] diamond 23478 169 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
19691153 19691153 PRJNA588137_S_NODE_4496_length_284_cov_0.995261_g4463_i0 PRJNA588137 4496 284 0.995261 2.82654124 Idotea baltica 82763 Arthropoda Arthropoda 116 7.91e-28   NR MCL4154024.1 82763 g4463 i0 82.2 0.77112676056338 73 13 77.1 0 65 283 276 348 MCL4154024.1 hypothetical protein [Idotea baltica] diamond 219 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
22241872 22241872 PRJNA588137_S_NODE_5298_length_268_cov_1.230769_g5265_i0 PRJNA588137 5298 268 1.230769 3.29846092 Metazoa 33208 Cnidaria other_Eukaryota 149 6.899999999999998e-44   NR XP_029193069.2 45264 g5265 i0 77.3 76.8022388059701 88 20 98.5 0 266 3 36 123 XP_029193069.2 40S ribosomal protein S15a isoform X1 [Acropora millepora] diamond 20583 149 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
27142527 27142527 PRJNA588137_S_NODE_3062_length_319_cov_1.252033_g3029_i0 PRJNA588137 3062 319 1.252033 3.99398527 Daphnia pulex 6669 Arthropoda Arthropoda 74.3 5.42e-15   NR EFX60666.1 6669 g3029 i0 46.7 2.56739811912226 75 40 70.5 0 310 86 2 76 EFX60666.1 hypothetical protein DAPPUDRAFT_19575, partial [Daphnia pulex] diamond 819 74.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27377897 27377897 PRJNA588137_S_NODE_10963_length_241_cov_0.916667_g10930_i0 PRJNA588137 10963 241 0.916667 2.20916747 Arthropoda 6656 Arthropoda Arthropoda 117 7.66e-30   NR CAL4127524.1 48144 g10930 i0 68.8 38.4647302904564 80 25 99.6 0 1 240 206 285 CAL4127524.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 9270 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
27806416 27806416 PRJNA588137_S_NODE_4144_length_291_cov_1.197248_g4111_i0 PRJNA588137 4144 291 1.197248 3.48399168 Habropoda laboriosa 597456 Arthropoda Arthropoda 68.6 5.66e-11   NR KOC58568.1 597456 g4111 i0 41.1 0.979381443298969 95 51 93.8 2 18 290 802 895 KOC58568.1 putative deoxycytidylate deaminase [Habropoda laboriosa] diamond 285 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Habropoda Habropoda laboriosa
28847980 28847980 PRJNA588137_S_NODE_5768_length_260_cov_0.882353_g5735_i0 PRJNA588137 5768 260 0.882353 2.2941178 Stylophora pistillata 50429 Cnidaria other_Eukaryota 68.6 3.71e-11   NR PFX23400.1 50429 g5735 i0 83.3 0.484615384615385 42 7 48.5 0 133 258 447 488 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 126 68.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
28847982 28847982 PRJNA588137_S_NODE_8728_length_246_cov_0.890173_g8695_i0 PRJNA588137 8728 246 0.890173 2.18982558 Allacma fusca 39272 Arthropoda Arthropoda 94.7 1.83e-20   NR CAG7728132.1 39272 g8695 i0 55.3 0.926829268292683 76 34 92.7 0 236 9 473 548 CAG7728132.1 unnamed protein product [Allacma fusca] diamond 228 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
28879650 28879650 PRJNA588137_S_NODE_4728_length_279_cov_1.334951_g4695_i0 PRJNA588137 4728 279 1.334951 3.72451329 Stylophora pistillata 50429 Cnidaria other_Eukaryota 115 1.8e-27   NR PFX23400.1 50429 g4695 i0 72.5 0.978494623655914 91 25 97.8 0 5 277 331 421 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 273 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
29051246 29051246 PRJNA588137_S_NODE_8128_length_247_cov_0.885057_g8095_i0 PRJNA588137 8128 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 119 4.4e-29   NR KAF6207491.1 248454 g8095 i0 71.1 20.0161943319838 83 23 99.6 1 2 247 574 656 KAF6207491.1 hypothetical protein GE061_015937 [Apolygus lucorum] diamond 4944 120 0.991666666666667 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
29290137 29290137 PRJNA588137_S_NODE_9509_length_244_cov_0.900585_g9476_i0 PRJNA588137 9509 244 0.900585 2.1974274 Oikopleura dioica 34765 Chordata Chordata 44.3 0.0103   NR CAG5114304.1 34765 g9476 i0 34.4 4.81967213114754 64 42 78.7 0 2 193 148 211 CAG5114304.1 Oidioi.mRNA.OKI2018_I69.chr2.g8364.t1.cds [Oikopleura dioica] diamond 1176 44.7 0.991051454138702 Eukaryota Opisthokonta Metazoa Chordata Appendicularia Copelata Oikopleuridae Oikopleura Oikopleura dioica
29605592 29605592 PRJNA588137_S_NODE_8350_length_247_cov_0.885057_g8317_i0 PRJNA588137 8350 247 0.885057 2.18609079 Clunio marinus 568069 Arthropoda Arthropoda 68.2 4.43e-11   NR CRK96648.1 568069 g8317 i0 59.6 0.692307692307692 57 20 69.2 1 234 64 555 608 CRK96648.1 CLUMA_CG009862, isoform A [Clunio marinus] diamond 171 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
30472410 30472410 PRJNA588137_S_NODE_10773_length_242_cov_0.911243_g10740_i0 PRJNA588137 10773 242 0.911243 2.20520806 Metazoa 33208 Arthropoda Arthropoda 42.7 0.0376   NR XP_044743408.1 189513 g10740 i0 48.6 1.84710743801653 35 18 43.4 0 111 7 677 711 XP_044743408.1 attractin-like protein 1 [Chrysoperla carnea] diamond 447 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Neuroptera Chrysopidae Chrysoperla Chrysoperla carnea
30774939 30774939 PRJNA588137_S_NODE_3974_length_295_cov_1.040541_g3941_i0 PRJNA588137 3974 295 1.040541 3.06959595 Suberites domuncula 55567 Porifera other_Eukaryota 132 6.379999999999998e-35   NR AAX48834.1 55567 g3941 i0 72.2 2.97966101694915 97 26 98.6 1 291 1 115 210 AAX48834.1 L4/L1 [Suberites domuncula] diamond 879 132 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
30932810 30932810 PRJNA588137_S_NODE_5654_length_262_cov_0.777778_g5621_i0 PRJNA588137 5654 262 0.777778 2.03777836 Stylophora pistillata 50429 Cnidaria other_Eukaryota 133 3.41e-34   NR PFX23400.1 50429 g5621 i0 80.5 0.99618320610687 87 17 99.6 0 262 2 460 546 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 261 133 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
31565276 31565276 PRJNA588137_S_NODE_5416_length_265_cov_2.005208_g5383_i0 PRJNA588137 5416 265 2.005208 5.3138012 Mactra antiquata 2302425 Mollusca Mollusca 66.6 1.88e-10   NR KAL4230805.1 2302425 g5383 i0 52.8 1.2 53 24 58.9 1 1 156 107 159 KAL4230805.1 Sequestosome-1 [Mactra antiquata] diamond 318 66.6 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Mactridae Mactra Mactra antiquata
31673318 31673318 PRJNA588137_S_NODE_2197_length_354_cov_1.288256_g2164_i0 PRJNA588137 2197 354 1.288256 4.56042624 Culicidae 7157 Arthropoda Arthropoda 104 1.2999999999999998e-24   NR XP_029715216.1 7160 g2164 i0 65.4 5.04237288135593 78 27 66.1 0 235 2 77 154 XP_029715216.1 large ribosomal subunit protein uL30 [Aedes albopictus] diamond 1785 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
31818019 31818019 PRJNA588137_S_NODE_1277_length_434_cov_1.066482_g1244_i0 PRJNA588137 1277 434 1.066482 4.62853188 Stylophora pistillata 50429 Cnidaria other_Eukaryota 153 1.58e-40   NR PFX23400.1 50429 g1244 i0 63.8 2.77188940092166 141 51 97.5 0 11 433 406 546 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 1203 153 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
32338062 32338062 PRJNA588137_S_NODE_4779_length_278_cov_1.126829_g4746_i0 PRJNA588137 4779 278 1.126829 3.13258462 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.8 5.06e-6   NR MCL4117871.1 82763 g4746 i0 45.5 1.98561151079137 66 36 71.2 0 274 77 5 70 MCL4117871.1 hypothetical protein [Idotea baltica] diamond 552 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32514462 32514462 PRJNA588137_S_NODE_2379_length_345_cov_0.941176_g2346_i0 PRJNA588137 2379 345 0.941176 3.2470572 Stylophora pistillata 50429 Cnidaria other_Eukaryota 167 2.57e-46   NR PFX23400.1 50429 g2346 i0 80.7 0.991304347826087 114 22 99.1 0 3 344 433 546 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 342 167 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
32546022 32546022 PRJNA588137_S_NODE_5039_length_273_cov_1.155000_g5006_i0 PRJNA588137 5039 273 1.155 3.15315 Porites evermanni 104178 Cnidaria other_Eukaryota 69.7 1.61e-11   NR CAH3187153.1 104178 g5006 i0 56.6 1.17582417582418 53 21 58.2 1 80 238 290 340 CAH3187153.1 unnamed protein product [Porites evermanni] diamond 321 69.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni
32779623 32779623 PRJNA588137_S_NODE_8460_length_246_cov_1.780347_g8427_i0 PRJNA588137 8460 246 1.780347 4.37965362 Metazoa 33208 Chordata Chordata 47.8 6.79e-4   NR XP_045011491.1 51337 g8427 i0 45.7 3.48780487804878 46 25 56.1 0 228 91 344 389 XP_045011491.1 leishmanolysin-like peptidase 2 [Jaculus jaculus] diamond 858 47.8 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Dipodidae Jaculus Jaculus jaculus

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