RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1145997 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
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
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
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
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
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
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
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);;