RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB12982 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
15323034 15323034 PRJEB12982_P_NODE_12053_length_202_cov_1.666667_g11890_i0 PRJEB12982 12053 202 1.666667 3.36666734 Idotea baltica 82763 Arthropoda Arthropoda 129 2.61e-35   NR MCL4112850.1 82763 g11890 i0 88.1 0.995049504950495 67 8 99.5 0 2 202 41 107 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 201 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26589555 26589555 PRJEB12982_P_NODE_17141_length_167_cov_0.864407_g16978_i0 PRJEB12982 17141 167 0.864407 1.44355969 Oppiella nova 334625 Arthropoda Arthropoda 72 6.25e-13   NR CAD7657410.1 334625 g16978 i0 57.4 2.91017964071856 54 23 97 0 5 166 380 433 CAD7657410.1 unnamed protein product [Oppiella nova] diamond 486 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
26906490 26906490 PRJEB12982_P_NODE_3322_length_423_cov_1.467914_g3161_i0 PRJEB12982 3322 423 1.467914 6.20927622 Arctia plantaginis 874455 Arthropoda Arthropoda 91.3 1.46e-18   NR CAB3245451.1 874455 g3161 i0 44.6 5.57446808510638 101 56 71.6 0 2 304 235 335 CAB3245451.1 unnamed protein product [Arctia plantaginis] diamond 2358 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Erebidae Arctia Arctia plantaginis
27001192 27001192 PRJEB12982_P_NODE_14422_length_183_cov_1.141791_g14259_i0 PRJEB12982 14422 183 1.141791 2.08947753 Tigriopus californicus 6832 Arthropoda Arthropoda 75.5 1.67e-15   NR XP_059090465.1 6832 g14259 i0 60 0.983606557377049 60 24 98.4 0 3 182 58 117 XP_059090465.1 small ribosomal subunit protein eS12-like [Tigriopus californicus] diamond 180 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27190955 27190955 PRJEB12982_P_NODE_13022_length_194_cov_1.351724_g12859_i0 PRJEB12982 13022 194 1.351724 2.62234456 Idotea baltica 82763 Arthropoda Arthropoda 106 1.19e-26   NR MCL4112850.1 82763 g12859 i0 73.4 0.989690721649485 64 17 99 0 192 1 125 188 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 192 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27254168 27254168 PRJEB12982_P_NODE_13963_length_187_cov_0.884058_g13800_i0 PRJEB12982 13963 187 0.884058 1.65318846 Spodoptera frugiperda 7108 Arthropoda Arthropoda 53.9 2.04e-6   NR XP_050559425.1 7108 g13800 i0 48.3 6.7379679144385 60 30 96.3 1 183 4 500 558 XP_050559425.1 unextended protein [Spodoptera frugiperda] diamond 1260 53.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
27254169 27254169 PRJEB12982_P_NODE_14383_length_183_cov_1.522388_g14220_i0 PRJEB12982 14383 183 1.522388 2.78597004 Idotea baltica 82763 Arthropoda Arthropoda 103 3.47e-25   NR MCL4127684.1 82763 g14220 i0 83.3 0.983606557377049 60 10 98.4 0 2 181 93 152 MCL4127684.1 hypothetical protein [Idotea baltica] diamond 180 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27444195 27444195 PRJEB12982_P_NODE_20223_length_162_cov_0.902655_g20060_i0 PRJEB12982 20223 162 0.902655 1.4623011 Cardiocondyla obscurior 286306 Arthropoda Arthropoda 64.7 1.06e-11   NR XP_070528861.1 286306 g20060 i0 59.3 3 54 22 100 0 162 1 56 109 XP_070528861.1 thioredoxin-2 [Cardiocondyla obscurior] diamond 486 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cardiocondyla Cardiocondyla obscurior
28485842 28485842 PRJEB12982_P_NODE_17747_length_166_cov_0.871795_g17584_i0 PRJEB12982 17747 166 0.871795 1.4471797 Ephemera danica 1049336 Arthropoda Arthropoda 48.1 1.65e-4   NR KAF4529565.1 1049336 g17584 i0 55.1 0.885542168674699 49 22 88.6 0 1 147 341 389 KAF4529565.1 hypothetical protein B566_EDAN017715 [Ephemera danica] diamond 147 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Ephemeridae Ephemera Ephemera danica
28574145 28574145 PRJEB12982_P_NODE_11647_length_206_cov_1.522293_g11484_i0 PRJEB12982 11647 206 1.522293 3.13592358 root 1 Root_unresolved Root_unresolved 51.6 3.63e-6   NR AFZ78854.1 36987 g11484 i0 40.7 12.1893203883495 54 29 74.3 1 153 1 4 57 AFZ78854.1 ricin-type beta-trefoil lectin domain-containing protein [Coptotermes formosanus] diamond 2511 52 0.992307692307692 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
29432728 29432728 PRJEB12982_P_NODE_11010_length_212_cov_1.791411_g10847_i0 PRJEB12982 11010 212 1.791411 3.79779132 Homalodisca vitripennis 197043 Arthropoda Arthropoda 92.8 4.3e-20   NR XP_046678972.1 197043 g10847 i0 66.2 0.962264150943396 68 22 94.8 1 3 203 54 121 XP_046678972.1 legumain-like [Homalodisca vitripennis] diamond 204 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
30854471 30854471 PRJEB12982_P_NODE_14234_length_184_cov_1.511111_g14071_i0 PRJEB12982 14234 184 1.511111 2.78044424 Brassicogethes aeneus 1431903 Arthropoda Arthropoda 58.9 3.25e-8   NR CAH0554441.1 1431903 g14071 i0 84.5 0.945652173913043 58 9 94.6 0 6 179 10060 10117 CAH0554441.1 unnamed protein product [Brassicogethes aeneus] diamond 174 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Brassicogethes Brassicogethes aeneus
30886107 30886107 PRJEB12982_P_NODE_5834_length_307_cov_1.368217_g5671_i0 PRJEB12982 5834 307 1.368217 4.20042619 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 138 2.21e-37   NR XP_043231682.1 1232801 g5671 i0 61.1 9.29315960912052 95 37 92.8 0 286 2 108 202 XP_043231682.1 procathepsin L-like [Amphibalanus amphitrite] diamond 2853 138 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
31195349 31195349 PRJEB12982_P_NODE_17055_length_167_cov_0.864407_g16892_i0 PRJEB12982 17055 167 0.864407 1.44355969 root 1 Root_unresolved Root_unresolved 49.7 1.43e-5   NR XP_014090959.1 104688 g16892 i0 45.5 3.84431137724551 55 28 98.8 2 166 2 81 133 XP_014090959.1 small ribosomal subunit protein eS12 [Bactrocera oleae] diamond 642 50.1 0.992015968063872 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera oleae
31233507 31233507 PRJEB12982_P_NODE_10015_length_223_cov_1.465517_g9852_i0 PRJEB12982 10015 223 1.465517 3.26810291 Sarcoptes scabiei 52283 Arthropoda Arthropoda 80.5 4.28e-16   NR KAF7487925.1 52283 g9852 i0 67.2 6.94170403587444 64 20 86.1 1 195 4 1 63 KAF7487925.1 N-acetyltransferase 9-like protein [Sarcoptes scabiei] diamond 1548 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei
31423459 31423459 PRJEB12982_P_NODE_9616_length_228_cov_1.441341_g9453_i0 PRJEB12982 9616 228 1.441341 3.28625748 Lasioglossum lativentre 88531 Arthropoda Arthropoda 48.9 1.96e-4   NR ALO64872.1 88531 g9453 i0 39.2 0.973684210526316 74 45 97.4 0 224 3 168 241 ALO64872.1 cytochrome b [Lasioglossum lativentre] diamond 222 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Lasioglossum Lasioglossum lativentre
31644745 31644745 PRJEB12982_P_NODE_10957_length_213_cov_1.243902_g10794_i0 PRJEB12982 10957 213 1.243902 2.64951126 Hyalella azteca 294128 Arthropoda Arthropoda 46.2 9.49e-4   NR XP_018014974.1 294128 g10794 i0 39.7 1.02816901408451 73 37 97.2 3 208 2 89 158 XP_018014974.1 E3 ubiquitin-protein ligase RNF170 [Hyalella azteca] diamond 219 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Amphipoda Hyalellidae Hyalella Hyalella azteca
31739605 31739605 PRJEB12982_P_NODE_17617_length_166_cov_0.871795_g17454_i0 PRJEB12982 17617 166 0.871795 1.4471797 Tigriopus californicus 6832 Arthropoda Arthropoda 68.6 9.62e-13   NR XP_059098743.1 6832 g17454 i0 71.7 13.3915662650602 53 15 95.8 0 161 3 61 113 XP_059098743.1 ubiquitin-ribosomal protein eS31 fusion protein [Tigriopus californicus] diamond 2223 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
32049737 32049737 PRJEB12982_P_NODE_15098_length_178_cov_1.379845_g14935_i0 PRJEB12982 15098 178 1.379845 2.4561241 Arachnida 6854 Arthropoda Arthropoda 97.1 1.05e-22   NR RWS29157.1 299467 g14935 i0 74.6 9.9438202247191 59 15 99.4 0 2 178 148 206 RWS29157.1 Proteasome subunit beta type-5-like protein [Leptotrombidium deliense] diamond 1770 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
32341129 32341129 PRJEB12982_P_NODE_17239_length_167_cov_0.864407_g17076_i0 PRJEB12982 17239 167 0.864407 1.44355969 Aphidius gifuensis 684658 Arthropoda Arthropoda 51.2 1.35e-5   NR XP_044002608.1 684658 g17076 i0 46.3 2.92814371257485 54 29 97 0 5 166 272 325 XP_044002608.1 synaptic functional regulator FMR1 isoform X4 [Aphidius gifuensis] diamond 489 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Aphidius Aphidius gifuensis
32587749 32587749 PRJEB12982_P_NODE_13739_length_188_cov_1.834532_g13576_i0 PRJEB12982 13739 188 1.834532 3.44892016 Metazoa 33208 Arthropoda Arthropoda 86.7 1.76e-19   NR XP_022169293.1 13164 g13576 i0 65.6 5.82446808510638 61 21 97.3 0 4 186 28 88 XP_022169293.1 60S ribosomal protein L4-B, partial [Myzus persicae] diamond 1095 86.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae

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