RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 26 ✖

tax_clade 1

bioproject 1

  • PRJNA1145997 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
5392568 5392568 PRJNA1145997_P_NODE_26845_length_460_cov_16.842377_g24228_i0 PRJNA1145997 26845 460 16.842377 77.4749342 Mus musculus 10090 Chordata Chordata 222 2.88e-72   NR NP_061354.1 10090 g24228 i0 100 0.710869565217391 109 0 71.1 0 81 407 1 109 NP_061354.1 C-X-C motif chemokine 13 precursor [Mus musculus] diamond 327 222 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
7942402 7942402 PRJNA1145997_P_NODE_27087_length_453_cov_4.936842_g24470_i0 PRJNA1145997 27087 453 4.936842 22.36389426 root 1 Root_unresolved Root_unresolved 168 3.63e-45   NR XP_017174599.2 10090 g24470 i0 55.2 2.88079470198675 145 63 96 1 453 19 301 443 XP_017174599.2 agouti-signaling protein isoform X1 [Mus musculus] diamond 1305 169 0.994082840236686 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
7942807 7942807 PRJNA1145997_P_NODE_51847_length_199_cov_7.912698_g49228_i0 PRJNA1145997 51847 199 7.912698 15.74626902 Collembola 30001 Arthropoda Arthropoda 119 8.870000000000001e-33   NR CAG7822269.1 39272 g49228 i0 96.6 2.65326633165829 59 2 88.9 0 178 2 43 101 CAG7822269.1 unnamed protein product [Allacma fusca] diamond 528 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
23241713 23241713 PRJNA1145997_P_NODE_26839_length_460_cov_55.085271_g24222_i0 PRJNA1145997 26839 460 55.085271 253.3922466 Mus musculus 10090 Chordata Chordata 199 1.46e-63   NR NP_067249.1 10090 g24222 i0 100 1.27826086956522 98 0 63.9 0 379 86 1 98 NP_067249.1 C-X-C motif chemokine 10 precursor [Mus musculus] diamond 588 199 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
26943910 26943910 PRJNA1145997_P_NODE_49602_length_239_cov_4.590361_g46983_i0 PRJNA1145997 49602 239 4.590361 10.97096279 Haemaphysalis longicornis 44386 Arthropoda Arthropoda 78.2 5.56e-17   NR KAH9368946.1 44386 g46983 i0 62.1 0.728033472803347 58 19 69 1 25 189 17 74 KAH9368946.1 hypothetical protein HPB48_001014 [Haemaphysalis longicornis] diamond 174 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Haemaphysalis Haemaphysalis longicornis
27449968 27449968 PRJNA1145997_P_NODE_27483_length_442_cov_5.821138_g24866_i0 PRJNA1145997 27483 442 5.821138 25.72942996 Folsomia candida 158441 Arthropoda Arthropoda 76.3 4.45e-13   NR OXA42701.1 158441 g24866 i0 58.7 0.427601809954751 63 26 42.8 0 398 210 220 282 OXA42701.1 RRP15-like protein [Folsomia candida] diamond 189 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
27880707 27880707 PRJNA1145997_P_NODE_43885_length_250_cov_0.881356_g41266_i0 PRJNA1145997 43885 250 0.881356 2.20339 Chordata 7711 Chordata Chordata 53.9 4.69e-6   NR XP_042324636.1 8520 g41266 i0 37.2 7.476 78 48 93.6 1 235 2 110 186 XP_042324636.1 palmitoyltransferase ZDHHC13 isoform X2 [Sceloporus undulatus] diamond 1869 54.3 0.992633517495396 Eukaryota Opisthokonta Metazoa Chordata Lepidosauria Squamata Phrynosomatidae Sceloporus Sceloporus undulatus
28112701 28112701 PRJNA1145997_P_NODE_17725_length_794_cov_12.886269_g15332_i0 PRJNA1145997 17725 794 12.886269 102.31697586 Allacma fusca 39272 Arthropoda Arthropoda 151 6.48e-42   NR CAG7837712.1 39272 g15332 i0 44.4 0.612090680100756 162 85 61.2 2 170 655 3 159 CAG7837712.1 unnamed protein product [Allacma fusca] diamond 486 151 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
28207390 28207390 PRJNA1145997_P_NODE_33386_length_328_cov_5.521569_g30767_i0 PRJNA1145997 33386 328 5.521569 18.11074632 Mizuhopecten yessoensis 6573 Mollusca Mollusca 53.5 1.64e-5   NR XP_021366139.1 6573 g30767 i0 30.5 2.3140243902439 82 47 75 1 26 271 612 683 XP_021366139.1 translation initiation factor eIF-2B subunit epsilon-like [Mizuhopecten yessoensis] diamond 759 53.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
28354305 28354305 PRJNA1145997_P_NODE_33806_length_323_cov_4.016000_g31187_i0 PRJNA1145997 33806 323 4.016 12.97168 Bradysia 35571 Arthropoda Arthropoda 152 4.249999999999999e-43   NR XP_037028325.1 38358 g31187 i0 91.9 1.59752321981424 86 7 79.9 0 309 52 226 311 XP_037028325.1 coatomer subunit epsilon [Bradysia coprophila] diamond 516 152 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
28397016 28397016 PRJNA1145997_P_NODE_45066_length_248_cov_0.891429_g42447_i0 PRJNA1145997 45066 248 0.891429 2.21074392 Meles meles 9662 Chordata Chordata 43.1 0.0282   NR XP_045870494.1 9662 g42447 i0 38.5 0.629032258064516 52 31 61.7 1 66 218 230 281 XP_045870494.1 uncharacterized protein LOC123948079 [Meles meles] diamond 156 43.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Mustelidae Meles Meles meles
28870543 28870543 PRJNA1145997_P_NODE_25308_length_509_cov_8.977064_g22692_i0 PRJNA1145997 25308 509 8.977064 45.69325576 Allacma fusca 39272 Arthropoda Arthropoda 94.4 6.52e-19   NR CAG7819059.1 39272 g22692 i0 56.1 0.483300589390963 82 34 48.3 1 20 265 669 748 CAG7819059.1 unnamed protein product [Allacma fusca] diamond 246 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
29438567 29438567 PRJNA1145997_P_NODE_49870_length_236_cov_4.233129_g47251_i0 PRJNA1145997 49870 236 4.233129 9.99018444 Pleurodeles waltl 8319 Chordata Chordata 83.6 1.5e-17   NR KAJ1185330.1 8319 g47251 i0 72.9 0.75 59 12 69.9 1 70 234 107 165 KAJ1185330.1 hypothetical protein NDU88_002123 [Pleurodeles waltl] diamond 177 83.6 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Caudata Salamandridae Pleurodeles Pleurodeles waltl
30892221 30892221 PRJNA1145997_P_NODE_41054_length_259_cov_7.279570_g38435_i0 PRJNA1145997 41054 259 7.27957 18.8540863 Didymodactylos carnosus 1234261 Rotifera other_Eukaryota 53.5 7.23e-6   NR CAF1121289.1 1234261 g38435 i0 45 1.85328185328185 80 31 88 4 247 20 611 681 CAF1121289.1 unnamed protein product [Didymodactylos carnosus] diamond 480 53.5 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Didymodactylos Didymodactylos carnosus
31050326 31050326 PRJNA1145997_P_NODE_18195_length_773_cov_9.334286_g15756_i0 PRJNA1145997 18195 773 9.334286 72.15403078 Allacma fusca 39272 Arthropoda Arthropoda 64.3 4.14e-8   NR CAG7822973.1 39272 g15756 i0 59.6 0.221216041397154 57 21 21.7 2 144 311 197 252 CAG7822973.1 unnamed protein product [Allacma fusca] diamond 171 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
31113012 31113012 PRJNA1145997_P_NODE_34895_length_310_cov_6.042194_g32276_i0 PRJNA1145997 34895 310 6.042194 18.7308014 Cotesia glomerata 32391 Arthropoda Arthropoda 84.3 1.34e-17   NR XP_044578424.1 32391 g32276 i0 88.2 0.493548387096774 51 6 49.4 0 293 141 158 208 XP_044578424.1 troponin I isoform X9 [Cotesia glomerata] diamond 153 84.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
31492839 31492839 PRJNA1145997_P_NODE_37076_length_288_cov_3.548837_g34457_i0 PRJNA1145997 37076 288 3.548837 10.22065056 Brachionus plicatilis 10195 Rotifera other_Eukaryota 135 1.87e-39   NR RNA36285.1 10195 g34457 i0 79.5 0.8125 78 16 81.3 0 3 236 6 83 RNA36285.1 40S ribosomal S21 [Brachionus plicatilis] diamond 234 135 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
31524414 31524414 PRJNA1145997_P_NODE_12536_length_1087_cov_93.951677_g10736_i0 PRJNA1145997 12536 1087 93.951677 1021.25472899 Staurois parvus 386267 Chordata Chordata 51.2 0.00178   NR CAI9550647.1 386267 g10736 i0 51.1 0.416743330266789 47 18 11.6 2 365 490 159 205 CAI9550647.1 unnamed protein product [Staurois parvus] diamond 453 51.2 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
31714086 31714086 PRJNA1145997_P_NODE_21597_length_638_cov_11.100885_g19005_i0 PRJNA1145997 21597 638 11.100885 70.8236463 Allacma fusca 39272 Arthropoda Arthropoda 47.8 0.0197   NR CAG7652974.1 39272 g19005 i0 49.4 0.371473354231975 79 23 31.5 4 428 628 22 95 CAG7652974.1 unnamed protein product [Allacma fusca] diamond 237 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
31998807 31998807 PRJNA1145997_P_NODE_50198_length_232_cov_4.283019_g47579_i0 PRJNA1145997 50198 232 4.283019 9.93660408 Eupeodes corollae 290404 Arthropoda Arthropoda 60.1 2.34e-8   NR XP_055914317.1 290404 g47579 i0 58.7 0.594827586206897 46 18 58.2 1 221 87 366 411 XP_055914317.1 vitellogenin-1-like [Eupeodes corollae] diamond 138 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
32114365 32114365 PRJNA1145997_P_NODE_37678_length_283_cov_4.419048_g35059_i0 PRJNA1145997 37678 283 4.419048 12.50590584 Sciaridae 7184 Arthropoda Arthropoda 80.5 3.07e-15   NR KAJ6638799.1 35572 g35059 i0 81.3 1.1660777385159 48 9 50.9 0 23 166 377 424 KAJ6638799.1 Saccharopine dehydrogenase-like oxidoreductase [Pseudolycoriella hygida] diamond 330 81.3 0.990159901599016 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
32252214 32252214 PRJNA1145997_P_NODE_24138_length_547_cov_3.516878_g21527_i0 PRJNA1145997 24138 547 3.516878 19.23732266 Portunus trituberculatus 210409 Arthropoda Arthropoda 45.4 0.0397   NR MPC69193.1 210409 g21527 i0 44.4 0.246800731261426 45 24 24.7 1 340 206 135 178 MPC69193.1 hypothetical protein [Portunus trituberculatus] diamond 135 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
32252219 32252219 PRJNA1145997_P_NODE_36838_length_290_cov_4.391705_g34219_i0 PRJNA1145997 36838 290 4.391705 12.7359445 Abscondita terminalis 2069292 Arthropoda Arthropoda 53.9 2.35e-7   NR KAF5307021.1 2069292 g34219 i0 56.6 0.548275862068966 53 20 53.8 2 33 188 1 51 KAF5307021.1 hypothetical protein FQR65_LT07164 [Abscondita terminalis] diamond 159 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Abscondita Abscondita terminalis
32442053 32442053 PRJNA1145997_P_NODE_48379_length_243_cov_0.917647_g45760_i0 PRJNA1145997 48379 243 0.917647 2.22988221 Drosophila guanche 7266 Arthropoda Arthropoda 46.2 0.00217   NR XP_034138067.1 7266 g45760 i0 34.4 0.790123456790123 64 39 75.3 1 211 29 387 450 XP_034138067.1 probable cytochrome P450 12d1 proximal, mitochondrial [Drosophila guanche] diamond 192 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila guanche
32694142 32694142 PRJNA1145997_P_NODE_40180_length_265_cov_4.906250_g37561_i0 PRJNA1145997 40180 265 4.90625 13.0015625 Penaeus vannamei 6689 Arthropoda Arthropoda 45.1 0.00748   NR ROT73918.1 6689 g37561 i0 45.3 0.6 53 27 60 1 19 177 516 566 ROT73918.1 hypothetical protein C7M84_007613 [Penaeus vannamei] diamond 159 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32757228 32757228 PRJNA1145997_P_NODE_34760_length_312_cov_2.418410_g32141_i0 PRJNA1145997 34760 312 2.41841 7.5454392 Lasius niger 67767 Arthropoda Arthropoda 56.2 1.48e-6   NR KMQ95680.1 67767 g32141 i0 64.1 3.40384615384615 39 14 37.5 0 191 307 32 70 KMQ95680.1 molybdenum cofactor biosynthesis protein 1-like protein [Lasius niger] diamond 1062 56.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Lasius Lasius niger

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