RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1195551" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1195551 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
4149454 4149454 PRJNA1195551_S_NODE_10364_length_291_cov_7.157025_g10011_i0 PRJNA1195551 10364 291 7.157025 20.82694275 Diploptera punctata 6984 Arthropoda Arthropoda 75.5 2.33e-15   NR KAJ9585135.1 6984 g10011 i0 81.4 3.83505154639175 43 8 44.3 0 291 163 53 95 KAJ9585135.1 hypothetical protein L9F63_003087, partial [Diploptera punctata] diamond 1116 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
11801040 11801040 PRJNA1195551_S_NODE_12090_length_275_cov_2.508850_g11737_i0 PRJNA1195551 12090 275 2.50885 6.8993375 Cymbaeremaeus cymba 503589 Arthropoda Arthropoda 94 2.2400000000000003e-21   NR BFM37237.1 503589 g11737 i0 56 2.97818181818182 91 40 99.3 0 273 1 112 202 BFM37237.1 ATPase subunit 6 [Cymbaeremaeus cymba] diamond 819 94 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Cymbaeremaeidae Cymbaeremaeus Cymbaeremaeus cymba
13076137 13076137 PRJNA1195551_S_NODE_13191_length_266_cov_1.437788_g12838_i0 PRJNA1195551 13191 266 1.437788 3.82451608 Orchesella dallaii 48710 Arthropoda Arthropoda 95.9 1.03e-20   NR CAL8090815.1 48710 g12838 i0 80.3 0.68796992481203 61 12 68.8 0 184 2 248 308 CAL8090815.1 unnamed protein product [Orchesella dallaii] diamond 183 95.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
24548731 24548731 PRJNA1195551_S_NODE_5500_length_370_cov_3.190031_g5147_i0 PRJNA1195551 5500 370 3.190031 11.8031147 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 93.6 2.38e-20   NR TRY64025.1 6832 g5147 i0 48.5 5.73243243243243 101 52 81.9 0 4 306 150 250 TRY64025.1 hypothetical protein TCAL_14131 [Tigriopus californicus] diamond 2121 93.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27103904 27103904 PRJNA1195551_S_NODE_16482_length_243_cov_2.963918_g16129_i0 PRJNA1195551 16482 243 2.963918 7.20232074 Portunus trituberculatus 210409 Arthropoda Arthropoda 44.7 0.00626   NR MPC69193.1 210409 g16129 i0 42.2 0.555555555555556 45 25 55.6 1 10 144 135 178 MPC69193.1 hypothetical protein [Portunus trituberculatus] diamond 135 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
27154208 27154208 PRJNA1195551_S_NODE_1682_length_663_cov_72.089577_g1384_i0 PRJNA1195551 1682 663 72.089577 477.95389551 root 1 Root_unresolved Root_unresolved 53.1 3.8e-4   NR GBN61280.1 182803 g1384 i0 50.9 2.20814479638009 53 26 24 0 123 281 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
27388707 27388707 PRJNA1195551_S_NODE_10083_length_294_cov_5.253061_g9730_i0 PRJNA1195551 10083 294 5.253061 15.44399934 Araneus ventricosus 182803 Arthropoda Arthropoda 43.9 0.00719   NR GBN16923.1 182803 g9730 i0 37 0.551020408163265 54 31 54.1 2 261 103 21 72 GBN16923.1 hypothetical protein AVEN_210185-1 [Araneus ventricosus] diamond 162 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
27912478 27912478 PRJNA1195551_S_NODE_6385_length_347_cov_5.550336_g6032_i0 PRJNA1195551 6385 347 5.550336 19.25966592 Opisthokonta 33154 Arthropoda Arthropoda 132 2.31e-36   NR ABY62737.1 6661 g6032 i0 60.6 11.4812680115274 109 41 92.5 1 5 325 78 186 ABY62737.1 ribosomal protein L9e [Artemia franciscana] diamond 3984 133 0.992481203007519 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27925313 27925313 PRJNA1195551_S_NODE_11845_length_277_cov_3.850877_g11492_i0 PRJNA1195551 11845 277 3.850877 10.66692929 Portunus trituberculatus 210409 Arthropoda Arthropoda 45.8 0.00345   NR MPC69193.1 210409 g11492 i0 40 0.487364620938628 45 26 48.7 1 19 153 135 178 MPC69193.1 hypothetical protein [Portunus trituberculatus] diamond 135 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
28304156 28304156 PRJNA1195551_S_NODE_29886_length_185_cov_7.316176_g29533_i0 PRJNA1195551 29886 185 7.316176 13.5349256 Araneus ventricosus 182803 Arthropoda Arthropoda 44.7 0.00167   NR GBO03872.1 182803 g29533 i0 47.5 5.74054054054054 40 21 64.9 0 57 176 31 70 GBO03872.1 hypothetical protein AVEN_149986-1 [Araneus ventricosus] diamond 1062 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28967370 28967370 PRJNA1195551_S_NODE_15688_length_248_cov_5.195980_g15335_i0 PRJNA1195551 15688 248 5.19598 12.8860304 Folsomia candida 158441 Arthropoda Arthropoda 103 1.82e-26   NR OXA43656.1 158441 g15335 i0 100 0.653225806451613 54 0 65.3 0 2 163 51 104 OXA43656.1 hypothetical protein Fcan01_21673 [Folsomia candida] diamond 162 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
29144366 29144366 PRJNA1195551_S_NODE_11589_length_279_cov_6.960870_g11236_i0 PRJNA1195551 11589 279 6.96087 19.4208273 Insecta 50557 Arthropoda Arthropoda 166 8.62e-51   NR NP_001284995.1 7227 g11236 i0 98.9 21.4516129032258 87 1 93.5 0 3 263 65 151 NP_001284995.1 ribosomal protein S14b, isoform B [Drosophila melanogaster] diamond 5985 167 0.994011976047904 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
30091230 30091230 PRJNA1195551_S_NODE_21972_length_214_cov_6.860606_g21619_i0 PRJNA1195551 21972 214 6.860606 14.68169684 Tenebrionidae 7065 Arthropoda Arthropoda 114 4.31e-30   NR KAJ3617189.1 7067 g21619 i0 73.5 4.76635514018692 68 18 95.3 0 214 11 117 184 KAJ3617189.1 hypothetical protein MTP99_007436 [Tenebrio molitor] diamond 1020 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
30167081 30167081 PRJNA1195551_S_NODE_12512_length_271_cov_5.063063_g12159_i0 PRJNA1195551 12512 271 5.063063 13.72090073 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 62 8.29e-9   NR RWS02056.1 1965070 g12159 i0 68.9 0.498154981549816 45 13 48.7 1 269 138 506 550 RWS02056.1 cell division cycle protein 20-like protein [Dinothrombium tinctorium] diamond 135 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
30533693 30533693 PRJNA1195551_S_NODE_9093_length_305_cov_3.601562_g8740_i0 PRJNA1195551 9093 305 3.601562 10.9847641 Metazoa 33208 Arthropoda Arthropoda 99.4 4.0999999999999994e-24   NR XP_037083006.1 41117 g8740 i0 79.2 10.5737704918033 53 11 52.1 0 302 144 94 146 XP_037083006.1 40S ribosomal protein S15-like [Pollicipes pollicipes] diamond 3225 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
31494707 31494707 PRJNA1195551_S_NODE_9976_length_295_cov_7.252033_g9623_i0 PRJNA1195551 9976 295 7.252033 21.39349735 Orchesella cincta 48709 Arthropoda Arthropoda 81.6 1.52e-15   NR ODN06434.1 48709 g9623 i0 68 2.03389830508475 100 24 98.6 3 292 2 224 318 ODN06434.1 Serine/threonine-protein phosphatase 1 regulatory subunit 10, partial [Orchesella cincta] diamond 600 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
32727701 32727701 PRJNA1195551_S_NODE_23760_length_207_cov_1.227848_g23407_i0 PRJNA1195551 23760 207 1.227848 2.54164536 Penaeus vannamei 6689 Arthropoda Arthropoda 44.3 0.00674   NR XP_070000310.1 6689 g23407 i0 35.1 0.826086956521739 57 33 82.6 2 19 189 260 312 XP_070000310.1 uncharacterized protein [Penaeus vannamei] diamond 171 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
32809459 32809459 PRJNA1195551_S_NODE_24240_length_205_cov_1.333333_g23887_i0 PRJNA1195551 24240 205 1.333333 2.73333265 Blattodea 85823 Arthropoda Arthropoda 76.6 6.86e-15   NR XP_069677800.1 6978 g23887 i0 56.3 2.0780487804878 71 28 99.5 1 204 1 156 226 XP_069677800.1 glutamine amidotransferase-like class 1 domain-containing protein 3, mitochondrial [Periplaneta americana] diamond 426 77 0.994805194805195 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana

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