RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA929940" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA929940 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
26620405 26620405 PRJNA929940_S_NODE_38581_length_177_cov_2.928571_g38346_i0 PRJNA929940 38581 177 2.928571 5.18357067 root 1 Root_unresolved Root_unresolved 128 4.66e-35   NR KAH8035867.1 6941 g38346 i0 98.3 111 59 1 100 0 177 1 128 186 KAH8035867.1 hypothetical protein HPB51_010619 [Rhipicephalus microplus] diamond 19647 129 0.992248062015504 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
26746723 26746723 PRJNA929940_S_NODE_35861_length_182_cov_3.517241_g35626_i0 PRJNA929940 35861 182 3.517241 6.40137862 Metazoa 33208 Arthropoda Arthropoda 129 4.38e-36   NR XP_046451926.1 6669 g35626 i0 100 124.615384615385 60 0 98.9 0 181 2 100 159 XP_046451926.1 NEDD8-conjugating enzyme Ubc12 [Daphnia pulex] diamond 22680 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27088258 27088258 PRJNA929940_S_NODE_56622_length_153_cov_1.327586_g56387_i0 PRJNA929940 56622 153 1.327586 2.03120658 Ladona fulva 123851 Arthropoda Arthropoda 41.2 0.038   NR KAG8233884.1 123851 g56387 i0 58.5 5.49019607843137 41 17 80.4 0 151 29 71 111 KAG8233884.1 hypothetical protein J437_LFUL005211 [Ladona fulva] diamond 840 41.6 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
27126361 27126361 PRJNA929940_S_NODE_32442_length_190_cov_1.712418_g32207_i0 PRJNA929940 32442 190 1.712418 3.2535942 Metazoa 33208 Arthropoda Arthropoda 139 9.65e-41   NR XP_022257306.1 6850 g32207 i0 100 76.0894736842105 61 0 96.3 0 3 185 14 74 XP_022257306.1 PHD finger-like domain-containing protein 5A isoform X1 [Limulus polyphemus] diamond 14457 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
27916268 27916268 PRJNA929940_S_NODE_52065_length_158_cov_1.289256_g51830_i0 PRJNA929940 52065 158 1.289256 2.03702448 Arthropoda 6656 Arthropoda Arthropoda 61.2 1.76e-9   NR XP_047496552.1 139456 g51830 i0 53.2 2.6962025316455702 47 22 89.2 0 6 146 179 225 XP_047496552.1 zinc finger protein 574-like [Penaeus chinensis] diamond 426 61.6 0.993506493506494 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus chinensis
28130540 28130540 PRJNA929940_S_NODE_44125_length_168_cov_2.488550_g43890_i0 PRJNA929940 44125 168 2.48855 4.180764 Dermacentor silvarum 543639 Arthropoda Arthropoda 80.5 6.55e-16   NR XP_049521085.1 543639 g43890 i0 64.8 0.964285714285714 54 19 96.4 0 6 167 644 697 XP_049521085.1 ankyrin repeat domain-containing protein 50-like [Dermacentor silvarum] diamond 162 80.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor silvarum
28793325 28793325 PRJNA929940_S_NODE_34467_length_185_cov_3.364865_g34232_i0 PRJNA929940 34467 185 3.364865 6.22500025 Scylla paramamosain 85552 Arthropoda Arthropoda 70.5 2.81e-12   NR KAK8374182.1 85552 g34232 i0 91.4 19.8810810810811 35 3 56.8 0 79 183 72 106 KAK8374182.1 hypothetical protein O3P69_018917 [Scylla paramamosain] diamond 3678 70.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
29077763 29077763 PRJNA929940_S_NODE_24768_length_211_cov_1.551724_g24533_i0 PRJNA929940 24768 211 1.551724 3.27413764 Portunus trituberculatus 210409 Arthropoda Arthropoda 48.1 1.12e-4   NR XP_045139323.1 210409 g24533 i0 52.8 0.511848341232227 36 17 51.2 0 205 98 85 120 XP_045139323.1 general transcription factor II-I repeat domain-containing protein 2-like [Portunus trituberculatus] diamond 108 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
29305617 29305617 PRJNA929940_S_NODE_55369_length_154_cov_1.965812_g55134_i0 PRJNA929940 55369 154 1.965812 3.02735048 Metazoa 33208 Arthropoda Arthropoda 107 1.86e-25   NR XP_069969438.1 6689 g55134 i0 98 420.253246753247 50 1 97.4 0 1 150 1019 1068 XP_069969438.1 C-Jun-amino-terminal kinase-interacting protein 4 isoform X2 [Penaeus vannamei] diamond 64719 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
29361841 29361841 PRJNA929940_S_NODE_58389_length_151_cov_1.692982_g58154_i0 PRJNA929940 58389 151 1.692982 2.55640282 Homarus americanus 6706 Arthropoda Arthropoda 48.5 9.31e-5   NR KAG7164879.1 6706 g58154 i0 92.3 0.516556291390728 26 2 51.7 0 150 73 219 244 KAG7164879.1 Helix-loop-helix protein 1-like, partial [Homarus americanus] diamond 78 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Nephropidae Homarus Homarus americanus
29456185 29456185 PRJNA929940_S_NODE_7610_length_328_cov_10.766323_g7375_i0 PRJNA929940 7610 328 10.766323 35.31353944 Elatichrosis sp. 3088754 Arthropoda Arthropoda 194 3.72e-60   NR WPO56402.1 3088754 g7375 i0 92.9 1.88414634146341 99 7 90.5 0 297 1 1 99 WPO56402.1 super sex combs, partial [Elatichrosis sp.] diamond 618 194 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Elateridae Elatichrosis Elatichrosis sp.
29677179 29677179 PRJNA929940_S_NODE_21370_length_223_cov_2.306452_g21135_i0 PRJNA929940 21370 223 2.306452 5.14338796 Limulus polyphemus 6850 Arthropoda Arthropoda 42.7 0.0289   NR XP_022256201.1 6850 g21135 i0 37.1 0.94170403587444 70 38 94.2 1 212 3 132 195 XP_022256201.1 LOW QUALITY PROTEIN: transcriptional activator cubitus interruptus-like [Limulus polyphemus] diamond 210 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
29779284 29779284 PRJNA929940_S_NODE_36371_length_181_cov_3.763889_g36136_i0 PRJNA929940 36371 181 3.763889 6.81263909 Metazoa 33208 Arthropoda Arthropoda 127 1.8199999999999999e-34   NR XP_032596078.1 7222 g36136 i0 100 164.088397790055 60 0 99.4 0 180 1 56 115 XP_032596078.1 uncharacterized protein LOC6567379 isoform X2 [Drosophila grimshawi] diamond 29700 127 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila grimshawi
29930357 29930357 PRJNA929940_S_NODE_9111_length_308_cov_3.944649_g8876_i0 PRJNA929940 9111 308 3.944649 12.14951892 Oppiella nova 334625 Arthropoda Arthropoda 43.9 0.0197   NR CAD7640152.1 334625 g8876 i0 87 0.224025974025974 23 3 22.4 0 239 307 129 151 CAD7640152.1 unnamed protein product, partial [Oppiella nova] diamond 69 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
30246325 30246325 PRJNA929940_S_NODE_3472_length_433_cov_8.406566_g3239_i0 PRJNA929940 3472 433 8.406566 36.40043078 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 48.1 0.00227   NR KAH9407846.1 59818 g3239 i0 60 0.242494226327945 35 14 24.2 0 110 6 75 109 KAH9407846.1 hypothetical protein TYRP_011491 [Tyrophagus putrescentiae] diamond 105 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30758747 30758747 PRJNA929940_S_NODE_34574_length_185_cov_2.364865_g34339_i0 PRJNA929940 34574 185 2.364865 4.37500025 Metazoa 33208 Arthropoda Arthropoda 128 1.0799999999999999e-32   NR XP_046464481.1 6669 g34339 i0 98.4 427.345945945946 61 1 98.9 0 184 2 911 971 XP_046464481.1 histone-lysine N-methyltransferase EZH2-like isoform X1 [Daphnia pulex] diamond 79059 129 0.992248062015504 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
30846457 30846457 PRJNA929940_S_NODE_41594_length_172_cov_2.007407_g41359_i0 PRJNA929940 41594 172 2.007407 3.45274004 Cloeon dipterum 197152 Arthropoda Arthropoda 51.2 1.47e-5   NR XP_065350669.1 197152 g41359 i0 59.4 0.558139534883721 32 13 55.8 0 5 100 32 63 XP_065350669.1 gastrula zinc finger protein XlCGF26.1-like [Cloeon dipterum] diamond 96 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
31517460 31517460 PRJNA929940_S_NODE_29376_length_197_cov_2.531250_g29141_i0 PRJNA929940 29376 197 2.53125 4.9865625 Metazoa 33208 Arthropoda Arthropoda 136 2.57e-35   NR XP_008184788.1 7029 g29141 i0 98.5 301.903553299492 65 1 99 0 1 195 2583 2647 XP_008184788.1 dynein heavy chain, cytoplasmic isoform X1 [Acyrthosiphon pisum] diamond 59475 137 0.992700729927007 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
32143011 32143011 PRJNA929940_S_NODE_20798_length_225_cov_8.335106_g20563_i0 PRJNA929940 20798 225 8.335106 18.7539885 Trichonephila clavata 2740835 Arthropoda Arthropoda 60.8 4.53e-10   NR GFR17751.1 2740835 g20563 i0 61.4 15.0133333333333 44 17 58.7 0 3 134 42 85 GFR17751.1 DNA-directed RNA polymerases I, II, and III subunit RPABC5 [Trichonephila clavata] diamond 3378 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavata
32806210 32806210 PRJNA929940_S_NODE_55820_length_154_cov_1.000000_g55585_i0 PRJNA929940 55820 154 1 1.54 Eriocheir sinensis 95602 Arthropoda Arthropoda 58.2 7.85e-9   NR XP_050699429.1 95602 g55585 i0 52.3 1.83116883116883 44 21 85.7 0 2 133 70 113 XP_050699429.1 replication initiator 1-like [Eriocheir sinensis] diamond 282 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis

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