RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA404067" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 26 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA404067 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
20816290 20816290 PRJNA404067_P_NODE_29077_length_213_cov_1.657895_g28690_i0 PRJNA404067 29077 213 1.657895 3.53131635 Blattella germanica 6973 Arthropoda Arthropoda 107 4.57e-28   NR PSN49442.1 6973 g28690 i0 82.6 0.971830985915493 69 3 97.2 1 209 3 56 115 PSN49442.1 hypothetical protein C0J52_06604 [Blattella germanica] diamond 207 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
26632276 26632276 PRJNA404067_P_NODE_19101_length_240_cov_0.888268_g18714_i0 PRJNA404067 19101 240 0.888268 2.1318432 Araneus ventricosus 182803 Arthropoda Arthropoda 87.4 1.98e-20   NR GBM00704.1 182803 g18714 i0 64.4 2.1875 59 20 72.5 1 237 64 26 84 GBM00704.1 hypothetical protein AVEN_150879-1 [Araneus ventricosus] diamond 525 87.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
26663615 26663615 PRJNA404067_P_NODE_39601_length_199_cov_2.057971_g39214_i0 PRJNA404067 39601 199 2.057971 4.09536229 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 79.3 1.54e-15   NR GLV35412.1 49296 g39214 i0 71.2 0.78391959798995 52 15 78.4 0 161 6 77 128 GLV35412.1 Regulatory particle non-ATPase 12 [Carabus blaptoides fortunei] diamond 156 79.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
26726874 26726874 PRJNA404067_P_NODE_35021_length_204_cov_2.398601_g34634_i0 PRJNA404067 35021 204 2.398601 4.89314604 Drosophila bipectinata 42026 Arthropoda Arthropoda 72.8 3.47e-13   NR XP_017106240.3 42026 g34634 i0 50.8 1.92647058823529 63 29 92.6 1 203 15 250 310 XP_017106240.3 putative trypsin-6 [Drosophila bipectinata] diamond 393 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila bipectinata
26790716 26790716 PRJNA404067_P_NODE_32581_length_207_cov_1.691781_g32194_i0 PRJNA404067 32581 207 1.691781 3.50198667 Vespula squamosa 30214 Arthropoda Arthropoda 42.4 0.0322   NR KAL2713230.1 30214 g32194 i0 33.3 0.782608695652174 54 36 78.3 0 173 12 1152 1205 KAL2713230.1 glutamate receptor 1-like isoform X1 [Vespula squamosa] diamond 162 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula squamosa
26807392 26807392 PRJNA404067_P_NODE_33081_length_207_cov_0.876712_g32694_i0 PRJNA404067 33081 207 0.876712 1.81479384 Daphnia 6668 Arthropoda Arthropoda 50.1 5.91e-5   NR XP_046449329.1 6669 g32694 i0 56.8 1.60869565217391 37 16 53.6 0 199 89 421 457 XP_046449329.1 uncharacterized protein LOC124197828 [Daphnia pulex] diamond 333 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27138210 27138210 PRJNA404067_P_NODE_7922_length_408_cov_5.605187_g7543_i0 PRJNA404067 7922 408 5.605187 22.86916296 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 55.1 2.1e-6   NR GLV61243.1 49296 g7543 i0 28 0.919117647058823 125 90 91.9 0 407 33 25 149 GLV61243.1 hypothetical protein CBL_04487, partial [Carabus blaptoides fortunei] diamond 375 55.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
27360043 27360043 PRJNA404067_P_NODE_27463_length_217_cov_1.083333_g27076_i0 PRJNA404067 27463 217 1.083333 2.35083261 Ooceraea biroi 2015173 Arthropoda Arthropoda 42.4 0.0362   NR XP_011341830.2 2015173 g27076 i0 31.7 0.870967741935484 63 40 87.1 1 192 4 140 199 XP_011341830.2 uncharacterized protein LOC105281937 [Ooceraea biroi] diamond 189 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Ooceraea Ooceraea biroi
28559898 28559898 PRJNA404067_P_NODE_36287_length_203_cov_1.394366_g35900_i0 PRJNA404067 36287 203 1.394366 2.83056298 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 60.8 8.99e-9   NR GLV43117.1 49296 g35900 i0 71.8 0.576354679802956 39 11 57.6 0 10 126 691 729 GLV43117.1 big brain [Carabus blaptoides fortunei] diamond 117 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
28765791 28765791 PRJNA404067_P_NODE_19907_length_237_cov_1.426136_g19520_i0 PRJNA404067 19907 237 1.426136 3.37994232 Oppiidae 229795 Arthropoda Arthropoda 55.5 8.3e-7   NR CAD7656423.1 334625 g19520 i0 52.8 2.9493670886076 53 22 63.3 1 5 154 135 187 CAD7656423.1 unnamed protein product [Oppiella nova] diamond 699 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
29033611 29033611 PRJNA404067_P_NODE_11448_length_314_cov_1.683794_g11063_i0 PRJNA404067 11448 314 1.683794 5.28711316 Coccinella septempunctata 41139 Arthropoda Arthropoda 47.8 0.00159   NR XP_044755170.1 41139 g11063 i0 40.9 0.630573248407643 66 33 58.3 3 51 233 7673 7737 XP_044755170.1 uncharacterized protein LOC123314117 [Coccinella septempunctata] diamond 198 47.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
29033617 29033617 PRJNA404067_P_NODE_23068_length_228_cov_0.874251_g22681_i0 PRJNA404067 23068 228 0.874251 1.99329228 Oppia nitens 1686743 Arthropoda Arthropoda 49.3 1.51e-4   NR XP_054160445.1 1686743 g22681 i0 50 0.763157894736842 58 25 72.4 2 3 167 118 174 XP_054160445.1 uncharacterized protein LOC128958589 [Oppia nitens] diamond 174 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
29033624 29033624 PRJNA404067_P_NODE_41768_length_189_cov_4.867188_g41381_i0 PRJNA404067 41768 189 4.867188 9.19898532 Periplaneta americana 6978 Arthropoda Arthropoda 55.5 4.22e-7   NR XP_069685703.1 6978 g41381 i0 48.9 1.50793650793651 47 24 74.6 0 47 187 30 76 XP_069685703.1 salivary glue protein Sgs-3-like [Periplaneta americana] diamond 285 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
29397368 29397368 PRJNA404067_P_NODE_16249_length_257_cov_3.979592_g15862_i0 PRJNA404067 16249 257 3.979592 10.22755144 Insecta 50557 Arthropoda Arthropoda 68.2 5.05e-11   NR XP_039308798.1 13686 g15862 i0 42 2.83657587548638 81 43 94.6 2 13 255 275 351 XP_039308798.1 uncharacterized protein LOC105201938 isoform X2 [Solenopsis invicta] diamond 729 68.6 0.994169096209913 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Solenopsis Solenopsis invicta
29727719 29727719 PRJNA404067_P_NODE_40710_length_194_cov_2.022556_g40323_i0 PRJNA404067 40710 194 2.022556 3.92375864 Larinioides sclopetarius 280406 Arthropoda Arthropoda 62.8 9.64e-10   NR CAL1262169.1 280406 g40323 i0 69.2 0.603092783505155 39 12 60.3 0 78 194 202 240 CAL1262169.1 unnamed protein product [Larinioides sclopetarius] diamond 117 62.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Larinioides Larinioides sclopetarius
29965843 29965843 PRJNA404067_P_NODE_45391_length_165_cov_6.326923_g45004_i0 PRJNA404067 45391 165 6.326923 10.43942295 root 1 Root_unresolved Root_unresolved 46.6 4.77e-4   NR XP_020291778.1 219809 g45004 i0 41.5 2.63636363636364 53 31 96.4 0 163 5 89 141 XP_020291778.1 uncharacterized protein LOC109858690 [Pseudomyrmex gracilis] diamond 435 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Pseudomyrmex Pseudomyrmex gracilis
30043770 30043770 PRJNA404067_P_NODE_41631_length_190_cov_2.186047_g41244_i0 PRJNA404067 41631 190 2.186047 4.1534893 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 42.4 0.0233   NR GLV34832.1 49296 g41244 i0 40 0.631578947368421 40 24 63.2 0 125 6 48 87 GLV34832.1 hypothetical protein CBL_09312 [Carabus blaptoides fortunei] diamond 120 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
30328730 30328730 PRJNA404067_P_NODE_28152_length_215_cov_1.889610_g27765_i0 PRJNA404067 28152 215 1.88961 4.0626615 Allacma fusca 39272 Arthropoda Arthropoda 68.6 2.06e-11   NR CAG7719401.1 39272 g27765 i0 52.4 0.87906976744186 63 27 87.9 1 19 207 193 252 CAG7719401.1 unnamed protein product [Allacma fusca] diamond 189 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
30517771 30517771 PRJNA404067_P_NODE_20473_length_235_cov_1.689655_g20086_i0 PRJNA404067 20473 235 1.689655 3.97068925 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 60.1 2.6e-8   NR XP_054268689.1 74068 g20086 i0 47.9 3.1531914893617 71 35 90.6 1 235 23 539 607 XP_054268689.1 ATP-dependent DNA helicase PIF1-like [Macrosteles quadrilineatus] diamond 741 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
30865249 30865249 PRJNA404067_P_NODE_32814_length_207_cov_1.143836_g32427_i0 PRJNA404067 32814 207 1.143836 2.36774052 Rhagoletis zephyria 28612 Arthropoda Arthropoda 44.7 0.0048   NR XP_017461811.1 28612 g32427 i0 49.2 0.855072463768116 59 30 85.5 0 3 179 432 490 XP_017461811.1 PREDICTED: titin-like, partial [Rhagoletis zephyria] diamond 177 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
30897100 30897100 PRJNA404067_P_NODE_10554_length_333_cov_9.937500_g10169_i0 PRJNA404067 10554 333 9.9375 33.091875 Papilio machaon 76193 Arthropoda Arthropoda 46.6 0.00426   NR XP_045535256.1 76193 g10169 i0 54.8 0.558558558558559 31 14 27.9 0 97 5 284 314 XP_045535256.1 protein tramtrack, beta isoform isoform X7 [Papilio machaon] diamond 186 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio machaon
31292772 31292772 PRJNA404067_P_NODE_19955_length_237_cov_1.170455_g19568_i0 PRJNA404067 19955 237 1.170455 2.77397835 Diptera 7147 Arthropoda Arthropoda 98.6 7.73e-22   NR XP_055683102.1 7200 g19568 i0 54.7 13.2911392405063 75 34 94.9 0 230 6 1770 1844 XP_055683102.1 LOW QUALITY PROTEIN: fatty acid synthase-like, partial [Lutzomyia longipalpis] diamond 3150 99 0.995959595959596 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
31940211 31940211 PRJNA404067_P_NODE_40857_length_193_cov_2.492424_g40470_i0 PRJNA404067 40857 193 2.492424 4.81037832 Galendromus occidentalis 34638 Arthropoda Arthropoda 68.6 1.52e-11   NR XP_003739039.1 34638 g40470 i0 51.6 0.994818652849741 64 31 99.5 0 2 193 451 514 XP_003739039.1 conserved oligomeric Golgi complex subunit 8 [Galendromus occidentalis] diamond 192 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
32510195 32510195 PRJNA404067_P_NODE_34639_length_205_cov_0.888889_g34252_i0 PRJNA404067 34639 205 0.888889 1.82222245 Ladona fulva 123851 Arthropoda Arthropoda 45.1 0.00345   NR KAG8221905.1 123851 g34252 i0 41.3 0.921951219512195 63 31 92.2 2 204 16 253 309 KAG8221905.1 hypothetical protein J437_LFUL006724 [Ladona fulva] diamond 189 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
32730671 32730671 PRJNA404067_P_NODE_12500_length_297_cov_1.076271_g12113_i0 PRJNA404067 12500 297 1.076271 3.19652487 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 80.9 5.77e-16   NR GLV44901.1 49296 g12113 i0 59.6 0.575757575757576 57 23 57.6 0 110 280 52 108 GLV44901.1 hypothetical protein CBL_14526 [Carabus blaptoides fortunei] diamond 171 80.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides
32778570 32778570 PRJNA404067_P_NODE_32660_length_207_cov_1.417808_g32273_i0 PRJNA404067 32660 207 1.417808 2.93486256 Arthropoda 6656 Arthropoda Arthropoda 71.2 2.14e-12   NR XP_055950903.1 94029 g32273 i0 53.4 20.231884057971 58 27 84.1 0 7 180 368 425 XP_055950903.1 uncharacterized protein K02A2.6-like [Argiope bruennichi] diamond 4188 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi

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