RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1034995 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
19294109 19294109 PRJNA1034995_S_NODE_13016_length_579_cov_24.897388_g12886_i0 PRJNA1034995 13016 579 24.897388 144.15587652 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 310 4.309999999999999e-101   NR KAH9392510.1 59818 g12886 i0 99.3 0.77720207253886 150 1 77.7 0 2 451 351 500 KAH9392510.1 hypothetical protein TYRP_005589 [Tyrophagus putrescentiae] diamond 450 310 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
26615468 26615468 PRJNA1034995_S_NODE_15641_length_476_cov_26.431871_g15490_i0 PRJNA1034995 15641 476 26.431871 125.81570596 Metazoa 33208 Arthropoda Arthropoda 129 2.48e-34   NR KAG0693505.1 41210 g15490 i0 98.3 45.7752100840336 60 1 37.8 0 88 267 125 184 KAG0693505.1 Serine/threonine-protein phosphatase 4 catalytic subunit B [Chionoecetes opilio] diamond 21789 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Majidae Chionoecetes Chionoecetes opilio
26932268 26932268 PRJNA1034995_S_NODE_31662_length_257_cov_3.869159_g31506_i0 PRJNA1034995 31662 257 3.869159 9.94373863 Metazoa 33208 Arthropoda Arthropoda 50.4 8.43e-5   NR XP_029718059.2 7160 g31506 i0 48 3.70038910505837 50 24 58.4 1 157 8 83 130 XP_029718059.2 uncharacterized protein LOC115260867 [Aedes albopictus] diamond 951 50.8 0.992125984251969 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
27382926 27382926 PRJNA1034995_S_NODE_54103_length_152_cov_4.027523_g53947_i0 PRJNA1034995 54103 152 4.027523 6.12183496 Rhipicephalus appendiculatus 34631 Arthropoda Arthropoda 41.6 0.0278   NR KAL1458816.1 34631 g53947 i0 53.3 0.888157894736842 45 21 88.8 0 12 146 61 105 KAL1458816.1 hypothetical protein MTO96_043442 [Rhipicephalus appendiculatus] diamond 135 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
27446256 27446256 PRJNA1034995_S_NODE_39203_length_209_cov_3.325301_g39047_i0 PRJNA1034995 39203 209 3.325301 6.94987909 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 66.2 1.83e-11   NR KAH9399100.1 59818 g39047 i0 100 0.488038277511962 34 0 48.8 0 26 127 139 172 KAH9399100.1 hypothetical protein TYRP_018002 [Tyrophagus putrescentiae] diamond 102 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
27446257 27446257 PRJNA1034995_S_NODE_49243_length_167_cov_1.483871_g49087_i0 PRJNA1034995 49243 167 1.483871 2.47806457 Phenacoccus manihoti 483259 Arthropoda Arthropoda 73.6 2.89e-14   NR YP_010491974.1 483259 g49087 i0 71.2 0.934131736526946 52 15 93.4 0 159 4 108 159 YP_010491974.1 ATP synthase F0 subunit 6 [Phenacoccus manihoti] diamond 156 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Phenacoccus Phenacoccus manihoti
27982750 27982750 PRJNA1034995_S_NODE_23185_length_338_cov_33.738983_g23029_i0 PRJNA1034995 23185 338 33.738983 114.03776254 Araneus ventricosus 182803 Arthropoda Arthropoda 42.7 0.0366   NR GBL73315.1 182803 g23029 i0 45.2 0.372781065088757 42 19 33.7 2 186 73 84 125 GBL73315.1 hypothetical protein AVEN_159350-1 [Araneus ventricosus] diamond 126 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28045845 28045845 PRJNA1034995_S_NODE_43305_length_189_cov_6.582192_g43149_i0 PRJNA1034995 43305 189 6.582192 12.44034288 Homarus americanus 6706 Arthropoda Arthropoda 62.4 1.19e-9   NR XP_042243337.1 6706 g43149 i0 67.4 1.33333333333333 43 14 68.3 0 151 23 195 237 XP_042243337.1 zinc finger BED domain-containing protein 5-like [Homarus americanus] diamond 252 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
28551250 28551250 PRJNA1034995_S_NODE_39087_length_209_cov_58.584337_g38931_i0 PRJNA1034995 39087 209 58.584337 122.44126433 Scylla paramamosain 85552 Arthropoda Arthropoda 43.1 0.0135   NR XP_063863861.1 85552 g38931 i0 49 0.732057416267943 51 22 67.5 2 196 56 88 138 XP_063863861.1 uncharacterized protein LOC135102475 [Scylla paramamosain] diamond 153 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
28614236 28614236 PRJNA1034995_S_NODE_20927_length_369_cov_30.196319_g20771_i0 PRJNA1034995 20927 369 30.196319 111.42441711 Palaemon carinicauda 392227 Arthropoda Arthropoda 44.3 0.0382   NR XP_068250707.1 392227 g20771 i0 69 0.707317073170732 29 8 23.6 1 215 129 29 56 XP_068250707.1 SCAN domain-containing protein 3-like [Palaemon carinicauda] diamond 261 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Palaemon Palaemon carinicauda
28677496 28677496 PRJNA1034995_S_NODE_13367_length_557_cov_28.982490_g13228_i0 PRJNA1034995 13367 557 28.98249 161.4324693 Caligus rogercresseyi 217165 Arthropoda Arthropoda 131 8.27e-32   NR QQP50210.1 217165 g13228 i0 69.3 2.84380610412926 88 27 47.4 0 3 266 322 409 QQP50210.1 Uncharacterized protein FKW44_011137 [Caligus rogercresseyi] diamond 1584 132 0.992424242424242 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
28677499 28677499 PRJNA1034995_S_NODE_37407_length_219_cov_4.045455_g37251_i0 PRJNA1034995 37407 219 4.045455 8.85954645 Aethina tumida 116153 Arthropoda Arthropoda 42.7 0.0286   NR XP_049822105.1 116153 g37251 i0 37.5 0.767123287671233 56 32 72.6 1 49 207 166 221 XP_049822105.1 structural maintenance of chromosomes protein 6-like [Aethina tumida] diamond 168 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Aethina Aethina tumida
28709108 28709108 PRJNA1034995_S_NODE_25507_length_311_cov_29.298507_g25351_i0 PRJNA1034995 25507 311 29.298507 91.11835677 Trichonephila clavipes 2585209 Arthropoda Arthropoda 106 8.18e-27   NR GFT08640.1 2585209 g25351 i0 71.7 1.83279742765273 60 17 57.9 0 311 132 63 122 GFT08640.1 QLQ domain-containing protein [Trichonephila clavipes] diamond 570 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
29182730 29182730 PRJNA1034995_S_NODE_19169_length_398_cov_35.509859_g19014_i0 PRJNA1034995 19169 398 35.509859 141.32923882 Caligus rogercresseyi 217165 Arthropoda Arthropoda 52.4 8.53e-5   NR QQP50210.1 217165 g19014 i0 76.7 1.35678391959799 30 7 22.6 0 254 343 329 358 QQP50210.1 Uncharacterized protein FKW44_011137 [Caligus rogercresseyi] diamond 540 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
29655752 29655752 PRJNA1034995_S_NODE_48570_length_169_cov_2.920635_g48414_i0 PRJNA1034995 48570 169 2.920635 4.93587315 Ixodes scapularis 6945 Arthropoda Arthropoda 45.8 0.00112   NR XP_040079185.1 6945 g48414 i0 52.9 7.13609467455621 34 16 60.4 0 117 16 203 236 XP_040079185.1 uncharacterized protein LOC120850656 [Ixodes scapularis] diamond 1206 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
30635290 30635290 PRJNA1034995_S_NODE_20613_length_374_cov_25.163142_g20457_i0 PRJNA1034995 20613 374 25.163142 94.11015108 Trichonephila clavipes 2585209 Arthropoda Arthropoda 63.2 2.95e-9   NR GFU88854.1 2585209 g20457 i0 71.9 0.25668449197861 32 9 25.7 0 279 374 1 32 GFU88854.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 96 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
31425552 31425552 PRJNA1034995_S_NODE_25636_length_310_cov_12.831461_g25480_i0 PRJNA1034995 25636 310 12.831461 39.7775291 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 47.8 0.00106   NR CAL4102522.1 48144 g25480 i0 62.1 0.280645161290323 29 11 28.1 0 218 304 151 179 CAL4102522.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 87 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica

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