RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA922890 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
26842261 26842261 PRJNA922890_P_NODE_76121_length_232_cov_0.883436_g75711_i0 PRJNA922890 76121 232 0.883436 2.04957152 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 68.9 3.41e-12   NR KAJ1526781.1 439358 g75711 i0 46.6 1.88793103448276 73 39 94.4 0 219 1 9 81 KAJ1526781.1 hypothetical protein ONE63_008354 [Megalurothrips usitatus] diamond 438 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Megalurothrips Megalurothrips usitatus
27498761 27498761 PRJNA922890_P_NODE_66443_length_237_cov_1.726190_g66033_i0 PRJNA922890 66443 237 1.72619 4.0910703 Daphnia pulex 6669 Arthropoda Arthropoda 47.4 7.31e-4   NR XP_046440211.1 6669 g66033 i0 48.1 2.65822784810127 54 26 65.8 1 225 70 180 233 XP_046440211.1 40S ribosomal protein S3a-like [Daphnia pulex] diamond 630 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
29550769 29550769 PRJNA922890_P_NODE_80410_length_229_cov_1.600000_g80000_i0 PRJNA922890 80410 229 1.6 3.664 Idotea baltica 82763 Arthropoda Arthropoda 133 5.66e-37   NR MCL4112850.1 82763 g80000 i0 76 2.96069868995633 75 18 98.3 0 227 3 160 234 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 678 133 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29613759 29613759 PRJNA922890_P_NODE_70570_length_234_cov_1.715152_g70160_i0 PRJNA922890 70570 234 1.715152 4.01345568 Daphnia pulex 6669 Arthropoda Arthropoda 119 1.43e-31   NR EFX61420.1 6669 g70160 i0 73 0.948717948717949 74 20 94.9 0 224 3 151 224 EFX61420.1 hypothetical protein DAPPUDRAFT_339680 [Daphnia pulex] diamond 222 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
29835075 29835075 PRJNA922890_P_NODE_75291_length_232_cov_0.895706_g74881_i0 PRJNA922890 75291 232 0.895706 2.07803792 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 41.2 0.0314   NR KAK9877722.1 420089 g74881 i0 46.3 0.698275862068966 54 27 67.2 1 232 77 44 97 KAK9877722.1 hypothetical protein WA026_019402 [Henosepilachna vigintioctopunctata] diamond 162 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata
30758674 30758674 PRJNA922890_P_NODE_76634_length_231_cov_1.333333_g76224_i0 PRJNA922890 76634 231 1.333333 3.07999923 root 1 Root_unresolved Root_unresolved 53.1 7.12e-6   NR GBN61280.1 182803 g76224 i0 50.9 6.33766233766234 53 26 68.8 0 204 46 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
30821814 30821814 PRJNA922890_P_NODE_69374_length_235_cov_0.879518_g68964_i0 PRJNA922890 69374 235 0.879518 2.0668673 root 1 Root_unresolved Root_unresolved 55.8 1.97e-7   NR ODM98394.1 48709 g68964 i0 58.7 1.13617021276596 46 19 58.7 0 231 94 108 153 ODM98394.1 Fucose mutarotase [Orchesella cincta] diamond 267 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
30846190 30846190 PRJNA922890_P_NODE_67174_length_237_cov_0.869048_g66764_i0 PRJNA922890 67174 237 0.869048 2.05964376 Triops cancriformis 194544 Arthropoda Arthropoda 94.4 2.18e-20   NR CAG4651919.1 194544 g66764 i0 54.9 2.07594936708861 82 33 98.7 2 1 234 246 327 CAG4651919.1 EOG090X0822 [Triops cancriformis] diamond 492 94.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Notostraca Triopsidae Triops Triops cancriformis
31011355 31011355 PRJNA922890_P_NODE_77974_length_231_cov_0.888889_g77564_i0 PRJNA922890 77974 231 0.888889 2.05333359 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 129 3.4599999999999997e-37   NR NP_001037277.1 7091 g77564 i0 77.3 125.779220779221 75 17 97.4 0 2 226 8 82 NP_001037277.1 ribosomal protein S27 [Bombyx mori] diamond 29055 130 0.992307692307692 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
31707027 31707027 PRJNA922890_P_NODE_73917_length_233_cov_0.878049_g73507_i0 PRJNA922890 73917 233 0.878049 2.04585417 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 60.5 1.76e-8   NR XP_049852605.1 7010 g73507 i0 39.2 3.64377682403433 74 44 95.3 1 1 222 294 366 XP_049852605.1 transmembrane protein 104 homolog isoform X2 [Schistocerca gregaria] diamond 849 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32150037 32150037 PRJNA922890_P_NODE_22498_length_402_cov_1.735736_g22088_i0 PRJNA922890 22498 402 1.735736 6.97765872 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 150 2.73e-43   NR EFX61290.1 6669 g22088 i0 61.9 18.7537313432836 134 51 100 0 402 1 42 175 EFX61290.1 hypothetical protein DAPPUDRAFT_69961 [Daphnia pulex] diamond 7539 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
32206030 32206030 PRJNA922890_P_NODE_78038_length_231_cov_0.888889_g77628_i0 PRJNA922890 78038 231 0.888889 2.05333359 Gryllus bimaculatus 6999 Arthropoda Arthropoda 43.5 0.0141   NR GLH15574.1 6999 g77628 i0 37.6 1.1038961038961 85 36 88.3 3 214 11 20 104 GLH15574.1 Protein of unknown function [Gryllus bimaculatus] diamond 255 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
32592930 32592930 PRJNA922890_P_NODE_56839_length_259_cov_1.536842_g56429_i0 PRJNA922890 56839 259 1.536842 3.98042078 Metazoa 33208 Arthropoda Arthropoda 102 2.88e-24   NR XP_002402767.2 6945 g56429 i0 80.4 5.93050193050193 56 11 64.9 0 259 92 38 93 XP_002402767.2 60S ribosomal protein L8 [Ixodes scapularis] diamond 1536 103 0.990291262135922 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis

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