RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA771359" 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

  • PRJNA771359 · 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
13500790 13500790 PRJNA771359_S_NODE_3591_length_178_cov_1.028369_g3508_i0 PRJNA771359 3591 178 1.028369 1.83049682 Idotea baltica 82763 Arthropoda Arthropoda 105 3.82e-26   NR MCL4112850.1 82763 g3508 i0 78 0.99438202247191 59 13 99.4 0 177 1 97 155 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 177 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
14775918 14775918 PRJNA771359_S_NODE_172_length_673_cov_5.444969_g101_i0 PRJNA771359 172 673 5.444969 36.64464137 Daphnia pulex 6669 Arthropoda Arthropoda 368 1.18e-125   NR EFX60189.1 6669 g101 i0 88.4 0.99851411589896 224 3 99.9 1 1 672 70 270 EFX60189.1 hypothetical protein DAPPUDRAFT_344845, partial [Daphnia pulex] diamond 672 368 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
19058510 19058510 PRJNA771359_S_NODE_4815_length_156_cov_0.949580_g4732_i0 PRJNA771359 4815 156 0.94958 1.4813448 Idotea baltica 82763 Arthropoda Arthropoda 86.3 4.32e-19   NR MCL4118453.1 82763 g4732 i0 86 0.961538461538462 50 7 96.2 0 2 151 130 179 MCL4118453.1 hypothetical protein [Idotea baltica] diamond 150 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26609878 26609878 PRJNA771359_S_NODE_3161_length_189_cov_1.269737_g3078_i0 PRJNA771359 3161 189 1.269737 2.39980293 Idotea baltica 82763 Arthropoda Arthropoda 115 1.83e-31   NR MCL4119848.1 82763 g3078 i0 88.9 2 63 7 100 0 1 189 22 84 MCL4119848.1 hypothetical protein [Idotea baltica] diamond 378 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26831838 26831838 PRJNA771359_S_NODE_3741_length_174_cov_1.671533_g3658_i0 PRJNA771359 3741 174 1.671533 2.90846742 Frankliniella fusca 407009 Arthropoda Arthropoda 42 0.0279   NR KAK3919349.1 407009 g3658 i0 36.1 2.10344827586207 61 29 96.6 3 172 5 745 800 KAK3919349.1 ATP-dependent DNA helicase [Frankliniella fusca] diamond 366 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella fusca
26967845 26967845 PRJNA771359_S_NODE_242_length_585_cov_2.437956_g169_i0 PRJNA771359 242 585 2.437956 14.2620426 root 1 Root_unresolved Root_unresolved 85.5 1.89e-15   NR TRY66722.1 6832 g169 i0 36.2 2.90769230769231 105 60 53.8 2 581 267 1631 1728 TRY66722.1 hypothetical protein TCAL_13779, partial [Tigriopus californicus] diamond 1701 85.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27084955 27084955 PRJNA771359_S_NODE_5002_length_153_cov_1.172414_g4919_i0 PRJNA771359 5002 153 1.172414 1.79379342 Daphnia pulex 6669 Arthropoda Arthropoda 87 8.22e-20   NR EFX61290.1 6669 g4919 i0 100 0.980392156862745 50 0 98 0 151 2 128 177 EFX61290.1 hypothetical protein DAPPUDRAFT_69961 [Daphnia pulex] diamond 150 87 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27369693 27369693 PRJNA771359_S_NODE_4583_length_159_cov_1.139344_g4500_i0 PRJNA771359 4583 159 1.139344 1.81155696 Daphnia pulex 6669 Arthropoda Arthropoda 85.1 1.77e-19   NR EFX61299.1 6669 g4500 i0 83.3 0.905660377358491 48 8 90.6 0 1 144 88 135 EFX61299.1 hypothetical protein DAPPUDRAFT_69950, partial [Daphnia pulex] diamond 144 85.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27622110 27622110 PRJNA771359_S_NODE_3584_length_178_cov_1.595745_g3501_i0 PRJNA771359 3584 178 1.595745 2.8404261 Idotea baltica 82763 Arthropoda Arthropoda 97.1 4.059999999999999e-23   NR MCL4118453.1 82763 g3501 i0 81.4 0.99438202247191 59 11 99.4 0 177 1 15 73 MCL4118453.1 hypothetical protein [Idotea baltica] diamond 177 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29390259 29390259 PRJNA771359_S_NODE_3489_length_180_cov_1.881119_g3406_i0 PRJNA771359 3489 180 1.881119 3.3860142 Idotea baltica 82763 Arthropoda Arthropoda 112 1.2599999999999998e-29   NR MCL4120794.1 82763 g3406 i0 89.8 0.983333333333333 59 6 98.3 0 179 3 42 100 MCL4120794.1 hypothetical protein [Idotea baltica] diamond 177 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
29999818 29999818 PRJNA771359_S_NODE_4491_length_160_cov_1.804878_g4408_i0 PRJNA771359 4491 160 1.804878 2.8878048 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.9 4.27e-22   NR XP_008544997.1 69319 g4408 i0 79.2 60.6 53 11 99.4 0 160 2 132 184 XP_008544997.1 40S ribosomal protein SA [Microplitis demolitor] diamond 9696 96.3 0.995846313603323 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
30031318 30031318 PRJNA771359_S_NODE_4511_length_160_cov_0.951220_g4428_i0 PRJNA771359 4511 160 0.95122 1.521952 root 1 Root_unresolved Root_unresolved 88.6 2.83e-21   NR MCL4125692.1 82763 g4428 i0 75.9 2.00625 54 12 99.4 1 159 1 34 87 MCL4125692.1 hypothetical protein [Idotea baltica] diamond 321 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31674575 31674575 PRJNA771359_S_NODE_1657_length_261_cov_1.736607_g1574_i0 PRJNA771359 1657 261 1.736607 4.53254427 Opisthokonta 33154 Arthropoda Arthropoda 124 3.89e-34   NR NP_001037269.1 7091 g1574 i0 82.2 37.8965517241379 73 13 83.9 0 261 43 80 152 NP_001037269.1 ribosomal protein S18 [Bombyx mori] diamond 9891 125 0.992 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
31737812 31737812 PRJNA771359_S_NODE_2817_length_200_cov_1.638037_g2734_i0 PRJNA771359 2817 200 1.638037 3.276074 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 88.6 2.3400000000000003e-21   NR XP_037899689.1 7396 g2734 i0 67.2 37.005 64 21 96 0 9 200 3 66 XP_037899689.1 40S ribosomal protein S2-like [Glossina fuscipes] diamond 7401 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
32181033 32181033 PRJNA771359_S_NODE_2718_length_203_cov_2.722892_g2635_i0 PRJNA771359 2718 203 2.722892 5.52747076 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 108 3.58e-27   NR XP_023026582.1 7539 g2635 i0 77.3 11.6600985221675 66 15 97.5 0 6 203 112 177 XP_023026582.1 60S ribosomal protein L7 [Leptinotarsa decemlineata] diamond 2367 109 0.990825688073395 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
32834417 32834417 PRJNA771359_S_NODE_4480_length_160_cov_2.203252_g4397_i0 PRJNA771359 4480 160 2.203252 3.5252032 Schistocerca gregaria 7010 Arthropoda Arthropoda 58.9 2.04e-8   NR XP_049849294.1 7010 g4397 i0 58 0.9375 50 17 93.8 1 159 10 226 271 XP_049849294.1 60S ribosomal protein L5-like [Schistocerca gregaria] diamond 150 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria

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