RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1156092 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
6680587 6680587 PRJNA1156092_P_NODE_19386_length_268_cov_0.989744_g19256_i0 PRJNA1156092 19386 268 0.989744 2.65251392 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 127 1.2599999999999999e-34   NR MCL4117824.1 82763 g19256 i0 65.9 13.7910447761194 88 30 98.5 0 3 266 59 146 MCL4117824.1 hypothetical protein [Idotea baltica] diamond 3696 128 0.9921875 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
16879980 16879980 PRJNA1156092_P_NODE_28614_length_245_cov_0.895349_g28484_i0 PRJNA1156092 28614 245 0.895349 2.19360505 Anthophora plagiata 597819 Arthropoda Arthropoda 105 7.9499999999999995e-25   NR CAK9815393.1 597819 g28484 i0 64.2 0.991836734693878 81 26 99.2 1 243 1 261 338 CAK9815393.1 Ubiquitin-like modifier-activating enzyme 5 [Anthophora plagiata] diamond 243 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
18154596 18154596 PRJNA1156092_P_NODE_24675_length_249_cov_0.875000_g24545_i0 PRJNA1156092 24675 249 0.875 2.17875 Opisthokonta 33154 Arthropoda Arthropoda 148 3.749999999999999e-40   NR XP_037044461.1 38358 g24545 i0 78 37.5421686746988 82 18 98.8 0 248 3 295 376 XP_037044461.1 catalase-like [Bradysia coprophila] diamond 9348 148 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
26945249 26945249 PRJNA1156092_P_NODE_29622_length_244_cov_0.900585_g29492_i0 PRJNA1156092 29622 244 0.900585 2.1974274 Tigriopus californicus 6832 Arthropoda Arthropoda 42.4 0.0446   NR TRY79554.1 6832 g29492 i0 39.4 1.74590163934426 71 33 76.2 3 188 3 117 186 TRY79554.1 hypothetical protein TCAL_07299 [Tigriopus californicus] diamond 426 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27451371 27451371 PRJNA1156092_P_NODE_25143_length_248_cov_0.880000_g25013_i0 PRJNA1156092 25143 248 0.88 2.1824 Orchesella cincta 48709 Arthropoda Arthropoda 45.4 0.00444   NR ODM93766.1 48709 g25013 i0 39.7 0.701612903225806 58 29 66.5 3 17 181 330 384 ODM93766.1 putative zinc finger protein [Orchesella cincta] diamond 174 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
27723497 27723497 PRJNA1156092_P_NODE_31404_length_242_cov_0.911243_g31274_i0 PRJNA1156092 31404 242 0.911243 2.20520806 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 60.1 2.73e-8   NR CAG9826136.1 107213 g31274 i0 54.3 3.89256198347107 46 21 57 0 35 172 243 288 CAG9826136.1 unnamed protein product [Diabrotica balteata] diamond 942 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica balteata
28114046 28114046 PRJNA1156092_P_NODE_30645_length_243_cov_0.905882_g30515_i0 PRJNA1156092 30645 243 0.905882 2.20129326 Penaeus vannamei 6689 Arthropoda Arthropoda 42.7 0.0354   NR ROT83115.1 6689 g30515 i0 52.4 0.777777777777778 63 20 66.7 4 53 214 1 62 ROT83115.1 hypothetical protein C7M84_023708 [Penaeus vannamei] diamond 189 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
28430052 28430052 PRJNA1156092_P_NODE_30406_length_243_cov_0.905882_g30276_i0 PRJNA1156092 30406 243 0.905882 2.20129326 Bombus terrestris 30195 Arthropoda Arthropoda 43.5 0.0109   NR XP_012168698.1 30195 g30276 i0 67.6 2.33333333333333 34 10 40.7 1 100 2 57 90 XP_012168698.1 iron-sulfur cluster assembly 1 homolog, mitochondrial isoform X2 [Bombus terrestris] diamond 567 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
29112468 29112468 PRJNA1156092_P_NODE_23368_length_250_cov_0.870056_g23238_i0 PRJNA1156092 23368 250 0.870056 2.17514 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 51.2 4.15e-5   NR KAH0818701.1 7067 g23238 i0 67.6 9.132 34 11 40.8 0 117 16 92 125 KAH0818701.1 hypothetical protein GEV33_004089 [Tenebrio molitor] diamond 2283 51.6 0.992248062015504 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
29175707 29175707 PRJNA1156092_P_NODE_16729_length_286_cov_1.446009_g16599_i0 PRJNA1156092 16729 286 1.446009 4.13558574 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 83.2 3.67e-16   NR KAG9509202.1 1670756 g16599 i0 72.5 10.951048951049 51 14 53.5 0 155 3 2 52 KAG9509202.1 T-complex protein 1 subunit eta, partial [Fragariocoptes setiger] diamond 3132 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Phytoptidae Fragariocoptes Fragariocoptes setiger
29282228 29282228 PRJNA1156092_P_NODE_10609_length_343_cov_0.877778_g10479_i0 PRJNA1156092 10609 343 0.877778 3.01077854 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 101 3.72e-22   NR XP_040572573.1 72036 g10479 i0 44.5 2.92128279883382 110 61 96.2 0 14 343 855 964 XP_040572573.1 glycogen debranching enzyme-like [Lepeophtheirus salmonis] diamond 1002 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
29333407 29333407 PRJNA1156092_P_NODE_7749_length_388_cov_1.466667_g7619_i0 PRJNA1156092 7749 388 1.466667 5.69066796 Arthropoda 6656 Arthropoda Arthropoda 144 5.879999999999999e-38   NR XP_063867887.1 85552 g7619 i0 53.6 23.9613402061856 125 57 96.6 1 12 386 20 143 XP_063867887.1 ornithine decarboxylase-like [Scylla paramamosain] diamond 9297 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
29345638 29345638 PRJNA1156092_P_NODE_30989_length_242_cov_0.976331_g30859_i0 PRJNA1156092 30989 242 0.976331 2.36272102 Araneus ventricosus 182803 Arthropoda Arthropoda 44.7 0.00741   NR GBM49182.1 182803 g30859 i0 46.7 0.557851239669422 45 24 55.8 0 164 30 76 120 GBM49182.1 hypothetical protein AVEN_2876-1 [Araneus ventricosus] diamond 135 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
29566504 29566504 PRJNA1156092_P_NODE_20090_length_263_cov_1.215789_g19960_i0 PRJNA1156092 20090 263 1.215789 3.19752507 Condylostylus longicornis 2530218 Arthropoda Arthropoda 110 3.0100000000000004e-27   NR XP_055388650.1 2530218 g19960 i0 58.6 0.992395437262357 87 36 99.2 0 2 262 218 304 XP_055388650.1 60S ribosomal protein L7a-like [Condylostylus longicornis] diamond 261 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
29566507 29566507 PRJNA1156092_P_NODE_24250_length_249_cov_0.875000_g24120_i0 PRJNA1156092 24250 249 0.875 2.17875 Holotrichia oblita 644536 Arthropoda Arthropoda 75.9 8.46e-14   NR KAI4464785.1 644536 g24120 i0 44.6 0.891566265060241 74 41 89.2 0 248 27 48 121 KAI4464785.1 katanin p80 subunit [Holotrichia oblita] diamond 222 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Holotrichia Holotrichia oblita
31051666 31051666 PRJNA1156092_P_NODE_31495_length_242_cov_0.911243_g31365_i0 PRJNA1156092 31495 242 0.911243 2.20520806 Lucilia sericata 13632 Arthropoda Arthropoda 89 2e-18   NR XP_037816429.1 13632 g31365 i0 56.5 4.27685950413223 69 30 85.5 0 241 35 1045 1113 XP_037816429.1 probable multidrug resistance-associated protein lethal(2)03659 isoform X2 [Lucilia sericata] diamond 1035 89 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia sericata
31482094 31482094 PRJNA1156092_P_NODE_24276_length_249_cov_0.875000_g24146_i0 PRJNA1156092 24276 249 0.875 2.17875 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.5 2.55e-17   NR KAK4880046.1 1421715 g24146 i0 49.3 4.49397590361446 75 37 89.2 1 245 24 280 354 KAK4880046.1 hypothetical protein RN001_008192 [Aquatica leii] diamond 1119 85.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Aquatica Aquatica leii
31525759 31525759 PRJNA1156092_P_NODE_17256_length_282_cov_2.210526_g17126_i0 PRJNA1156092 17256 282 2.210526 6.23368332 Zophobas morio 2755281 Arthropoda Arthropoda 144 1.34e-41   NR XP_063900196.1 2755281 g17126 i0 78.7 2.92553191489362 94 20 100 0 1 282 2 95 XP_063900196.1 small ribosomal subunit protein uS4-like [Zophobas morio] diamond 825 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
32348437 32348437 PRJNA1156092_P_NODE_8439_length_375_cov_1.754967_g8309_i0 PRJNA1156092 8439 375 1.754967 6.58112625 Idotea baltica 82763 Arthropoda Arthropoda 181 1.3e-55   NR MCL4120794.1 82763 g8309 i0 72.4 2.968 123 34 98.4 0 5 373 24 146 MCL4120794.1 hypothetical protein [Idotea baltica] diamond 1113 181 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32379930 32379930 PRJNA1156092_P_NODE_25899_length_247_cov_0.885057_g25769_i0 PRJNA1156092 25899 247 0.885057 2.18609079 Araneus ventricosus 182803 Arthropoda Arthropoda 45.4 0.00428   NR GBM78340.1 182803 g25769 i0 58.8 0.412955465587045 34 14 41.3 0 238 137 47 80 GBM78340.1 Ankyrin-3 [Araneus ventricosus] diamond 102 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
32462629 32462629 PRJNA1156092_P_NODE_2639_length_608_cov_1.437383_g2512_i0 PRJNA1156092 2639 608 1.437383 8.73928864 Insecta 50557 Arthropoda Arthropoda 130 3.18e-32   NR ALO64872.1 88531 g2512 i0 36.7 18.0493421052632 188 113 91.8 3 1 558 46 229 ALO64872.1 cytochrome b [Lasioglossum lativentre] diamond 10974 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Lasioglossum Lasioglossum lativentre
32663942 32663942 PRJNA1156092_P_NODE_18960_length_270_cov_2.294416_g18830_i0 PRJNA1156092 18960 270 2.294416 6.1949232 Uloborus diversus 327109 Arthropoda Arthropoda 69.3 8.77e-13   NR XP_054710691.1 327109 g18830 i0 54.2 6.37777777777778 72 33 80 0 259 44 5 76 XP_054710691.1 60S ribosomal protein L35-like [Uloborus diversus] diamond 1722 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus

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