RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA896973 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26834318 26834318 PRJNA896973_P_NODE_21861_length_251_cov_0.865169_g21767_i0 PRJNA896973 21861 251 0.865169 2.17157419 Nesidiocoris tenuis 355587 Arthropoda Arthropoda 51.6 2.97e-5   NR BET00649.1 355587 g21767 i0 75 0.430278884462151 36 9 43 0 108 1 63 98 BET00649.1 Sulfotransferase family [Nesidiocoris tenuis] diamond 108 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Nesidiocoris Nesidiocoris tenuis
26992246 26992246 PRJNA896973_P_NODE_19822_length_260_cov_5.887701_g19728_i0 PRJNA896973 19822 260 5.887701 15.3080226 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 47 2.55e-4   NR KAJ8043773.1 206669 g19728 i0 51.1 1.11923076923077 47 23 54.2 0 35 175 53 99 KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] diamond 291 47 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
27087394 27087394 PRJNA896973_P_NODE_12802_length_311_cov_2.462185_g12708_i0 PRJNA896973 12802 311 2.462185 7.65739535 Engystomops pustulosus 76066 Chordata Chordata 47 2.86e-4   NR KAG8536220.1 76066 g12708 i0 59 0.37620578778135 39 9 32.8 2 107 6 37 73 KAG8536220.1 hypothetical protein GDO81_026873 [Engystomops pustulosus] diamond 117 47 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
27087400 27087400 PRJNA896973_S_NODE_2782_length_244_cov_3.345029_g2768_i0 PRJNA896973 2782 244 3.345029 8.16187076 Halotydeus destructor 2874060 Arthropoda Arthropoda 68.9 2.14e-11   NR KAI1283234.1 2874060 g2768 i0 64.3 2.31147540983607 42 15 51.6 0 96 221 100 141 KAI1283234.1 CUGBP Elav-like family member 2 [Halotydeus destructor] diamond 564 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
27403498 27403498 PRJNA896973_P_NODE_22963_length_249_cov_0.875000_g22869_i0 PRJNA896973 22963 249 0.875 2.17875 Halocaridina rubra 373956 Arthropoda Arthropoda 74.7 2.19e-13   NR KAK7041662.1 373956 g22869 i0 84.8 0.55421686746988 46 6 54.2 1 115 249 424 469 KAK7041662.1 coiled-coil domain containing protein 64, partial [Halocaridina rubra] diamond 138 74.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
27435191 27435191 PRJNA896973_S_NODE_2403_length_258_cov_2.313514_g2389_i0 PRJNA896973 2403 258 2.313514 5.96886612 Polyplax serrata 468196 Arthropoda Arthropoda 69.3 1.93e-11   NR KAK6645501.1 468196 g2389 i0 50 0.930232558139535 80 38 90.7 2 256 23 459 538 KAK6645501.1 hypothetical protein RUM43_001778 [Polyplax serrata] diamond 240 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27624555 27624555 PRJNA896973_S_NODE_2424_length_257_cov_2.027174_g2410_i0 PRJNA896973 2424 257 2.027174 5.20983718 Leptotrombidium deliense 299467 Arthropoda Arthropoda 45.1 0.00705   NR RWS30729.1 299467 g2410 i0 33.8 0.933852140077821 80 49 88.7 1 232 5 2441 2520 RWS30729.1 apolipophorins-like protein [Leptotrombidium deliense] diamond 240 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
28823929 28823929 PRJNA896973_S_NODE_1928_length_283_cov_1.800000_g1914_i0 PRJNA896973 1928 283 1.8 5.094 Loxostege sticticalis 481309 Arthropoda Arthropoda 52.4 2.21e-5   NR KAL0849736.1 481309 g1914 i0 33 0.932862190812721 88 59 93.3 0 269 6 13 100 KAL0849736.1 hypothetical protein ABMA28_011694 [Loxostege sticticalis] diamond 264 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Crambidae Loxostege Loxostege sticticalis
29834578 29834578 PRJNA896973_P_NODE_27571_length_242_cov_0.911243_g27477_i0 PRJNA896973 27571 242 0.911243 2.20520806 Neocaridina denticulata sinensis 274643 Arthropoda Arthropoda 117 2.5099999999999996e-31   NR XLL28172.1 274643 g27477 i0 87.7 0.706611570247934 57 7 70.7 0 71 241 66 122 XLL28172.1 type I crustin [Neocaridina denticulata sinensis] diamond 171 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Neocaridina Neocaridina denticulata
29842244 29842244 PRJNA896973_S_NODE_491_length_532_cov_5.313725_g477_i0 PRJNA896973 491 532 5.313725 28.269017 Adineta 104781 Rotifera other_Eukaryota 100 8.11e-21   NR CAF0777571.1 249248 g477 i0 100 1.2687969924812 45 0 25.4 0 340 206 142 186 CAF0777571.1 unnamed protein product [Adineta ricciae] diamond 675 100 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
30340628 30340628 PRJNA896973_P_NODE_20292_length_258_cov_1.286486_g20198_i0 PRJNA896973 20292 258 1.286486 3.31913388 Macrobrachium nipponense 159736 Arthropoda Arthropoda 69.7 2.17e-13   NR XP_064099722.1 159736 g20198 i0 70 1.31395348837209 50 13 55.8 1 14 157 1 50 XP_064099722.1 shematrin-like protein 2 [Macrobrachium nipponense] diamond 339 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
30624266 30624266 PRJNA896973_P_NODE_28273_length_241_cov_0.904762_g28179_i0 PRJNA896973 28273 241 0.904762 2.18047642 Halocaridina rubra 373956 Arthropoda Arthropoda 124 2.6799999999999996e-31   NR KAK7020658.1 373956 g28179 i0 73.2 1.0207468879668 82 18 98.3 2 239 3 393 473 KAK7020658.1 hypothetical protein SK128_008362 [Halocaridina rubra] diamond 246 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
31066969 31066969 PRJNA896973_P_NODE_21555_length_251_cov_1.730337_g21461_i0 PRJNA896973 21555 251 1.730337 4.34314587 Macrobrachium nipponense 159736 Arthropoda Arthropoda 62 2.17e-10   NR XP_064099722.1 159736 g21461 i0 67.4 0.549800796812749 46 13 52.6 1 4 135 5 50 XP_064099722.1 shematrin-like protein 2 [Macrobrachium nipponense] diamond 138 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
31635880 31635880 PRJNA896973_S_NODE_1696_length_299_cov_2.247788_g1682_i0 PRJNA896973 1696 299 2.247788 6.72088612 Trichonephila clavipes 2585209 Arthropoda Arthropoda 43.1 0.0439   NR GFV94339.1 2585209 g1682 i0 53.1 0.321070234113712 32 15 32.1 0 2 97 18 49 GFV94339.1 uncharacterized protein TNCV_2267931 [Trichonephila clavipes] diamond 96 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
32110525 32110525 PRJNA896973_P_NODE_6138_length_426_cov_0.787535_g6044_i0 PRJNA896973 6138 426 0.787535 3.3548991 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 104 4.02e-25   NR AAX25032.2 6182 g6044 i0 86.5 0.366197183098592 52 7 36.6 0 102 257 104 155 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 156 104 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32308350 32308350 PRJNA896973_P_NODE_28219_length_241_cov_0.916667_g28125_i0 PRJNA896973 28219 241 0.916667 2.20916747 Anura 8342 Chordata Chordata 104 7.859999999999998e-24   NR XP_040195325.1 8407 g28125 i0 72.7 18.5850622406639 66 18 82.2 0 2 199 1192 1257 XP_040195325.1 uncharacterized protein LOC120928293 [Rana temporaria] diamond 4479 104 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Rana Rana temporaria
32876005 32876005 PRJNA896973_S_NODE_2320_length_262_cov_1.724868_g2306_i0 PRJNA896973 2320 262 1.724868 4.51915416 Opisthokonta 33154 Arthropoda Arthropoda 44.3 0.013   NR CRL03922.1 568069 g2306 i0 34.4 1.54580152671756 61 40 69.8 0 25 207 319 379 CRL03922.1 CLUMA_CG017043, isoform A [Clunio marinus] diamond 405 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus

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