RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 22 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA478247 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
447828 447828 PRJNA478247_P_NODE_161_length_1173_cov_1.925699_g118_i0 PRJNA478247 161 1173 1.925699 22.58844927 root 1 Root_unresolved Root_unresolved 478 2.99e-163   NR XP_044754826.1 41139 g118 i0 75.6 169.687979539642 315 76 80.3 1 1171 230 195 509 XP_044754826.1 ATP synthase subunit beta, mitochondrial-like [Coccinella septempunctata] diamond 199044 482 0.991701244813278 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
5551413 5551413 PRJNA478247_P_NODE_1765_length_270_cov_1.908714_g1659_i0 PRJNA478247 1765 270 1.908714 5.1535278 Schistocerca gregaria 7010 Arthropoda Arthropoda 99.4 1.2399999999999999e-23   NR XP_049851497.1 7010 g1659 i0 68.2 0.944444444444444 85 23 91.1 2 22 267 1 84 XP_049851497.1 uncharacterized protein LOC126326081 [Schistocerca gregaria] diamond 255 99.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
10651468 10651468 PRJNA478247_P_NODE_969_length_416_cov_5.904393_g863_i0 PRJNA478247 969 416 5.904393 24.56227488 Galendromus occidentalis 34638 Arthropoda Arthropoda 143 1.2099999999999999e-40   NR XP_003746752.1 34638 g863 i0 56.1 5.69711538461539 132 54 94.5 2 395 3 15 143 XP_003746752.1 eukaryotic translation initiation factor 5A-1 [Galendromus occidentalis] diamond 2370 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
11926413 11926413 PRJNA478247_P_NODE_3110_length_172_cov_1.755245_g3004_i0 PRJNA478247 3110 172 1.755245 3.0190214 Schistocerca gregaria 7010 Arthropoda Arthropoda 62.4 1.42e-9   NR XP_049848932.1 7010 g3004 i0 64.1 2.52906976744186 39 14 68 0 119 3 28 66 XP_049848932.1 succinate--CoA ligase [ADP/GDP-forming] subunit alpha, mitochondrial-like [Schistocerca gregaria] diamond 435 62.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
17025043 17025043 PRJNA478247_P_NODE_834_length_456_cov_2.911007_g729_i0 PRJNA478247 834 456 2.911007 13.27419192 Idotea baltica 82763 Arthropoda Arthropoda 159 2.67e-46   NR MCL4113740.1 82763 g729 i0 61.2 0.848684210526316 129 49 84.2 1 389 6 5 133 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 387 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
22124224 22124224 PRJNA478247_P_NODE_1438_length_315_cov_1.744755_g1332_i0 PRJNA478247 1438 315 1.744755 5.49597825 Metazoa 33208 Arthropoda Arthropoda 169 1.22e-51   NR KAK2703744.1 6661 g1332 i0 78.8 25.0666666666667 104 22 99 0 312 1 17 120 KAK2703744.1 hypothetical protein QYM36_017882 [Artemia franciscana] diamond 7896 170 0.994117647058824 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
22124231 22124231 PRJNA478247_P_NODE_518_length_629_cov_2.541667_g421_i0 PRJNA478247 518 629 2.541667 15.98708543 Metazoa 33208 Arthropoda Arthropoda 306 1.0499999999999996e-96   NR KAH9530130.1 6954 g421 i0 78.6 92.6613672496025 192 39 91.6 1 587 12 514 703 KAH9530130.1 Alanyl-tRNA editing protein Aarsd1 [Dermatophagoides farinae] diamond 58284 307 0.996742671009772 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
23400032 23400032 PRJNA478247_P_NODE_3619_length_151_cov_1.549180_g3513_i0 PRJNA478247 3619 151 1.54918 2.3392618 Idotea baltica 82763 Arthropoda Arthropoda 78.6 1.08e-15   NR MCL4144816.1 82763 g3513 i0 71.4 0.973509933774834 49 14 97.4 0 149 3 163 211 MCL4144816.1 hypothetical protein [Idotea baltica] diamond 147 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
26807653 26807653 PRJNA478247_P_NODE_1621_length_287_cov_3.903101_g1515_i0 PRJNA478247 1621 287 3.903101 11.20189987 Metazoa 33208 Arthropoda Arthropoda 77.4 9.29e-16   NR XP_046911151.1 6954 g1515 i0 68.3 12.7421602787456 60 19 62.7 0 19 198 73 132 XP_046911151.1 ubiquitin-like protein 1-40S ribosomal protein S27a [Dermatophagoides farinae] diamond 3657 77.8 0.994858611825193 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
27187031 27187031 PRJNA478247_P_NODE_2202_length_228_cov_2.849246_g2096_i0 PRJNA478247 2202 228 2.849246 6.49628088 Opisthokonta 33154 Arthropoda Arthropoda 78.2 4.2e-16   NR XP_001657309.1 7159 g2096 i0 52.2 3.65789473684211 69 31 90.8 1 224 18 88 154 XP_001657309.1 eukaryotic translation initiation factor 5A [Aedes aegypti] diamond 834 78.6 0.994910941475827 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
27424146 27424146 PRJNA478247_P_NODE_523_length_626_cov_3.211055_g426_i0 PRJNA478247 523 626 3.211055 20.1012043 Acyrthosiphon pisum 7029 Arthropoda Arthropoda 189 2.66e-57   NR NP_001155681.1 7029 g426 i0 57 2.66932907348243 186 72 86.7 3 608 66 1 183 NP_001155681.1 ribosomal protein L18 [Acyrthosiphon pisum] diamond 1671 189 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Acyrthosiphon Acyrthosiphon pisum
27598057 27598057 PRJNA478247_P_NODE_704_length_504_cov_4.229474_g599_i0 PRJNA478247 704 504 4.229474 21.31654896 Opisthokonta 33154 Arthropoda Arthropoda 231 5.53e-75   NR CAD7282753.1 399045 g599 i0 78.6 4.32142857142857 145 31 86.3 0 477 43 1 145 CAD7282753.1 unnamed protein product [Notodromas monacha] diamond 2178 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
28402726 28402726 PRJNA478247_P_NODE_1006_length_405_cov_3.135638_g900_i0 PRJNA478247 1006 405 3.135638 12.6993339 Allacma fusca 39272 Arthropoda Arthropoda 130 4.26e-35   NR CAG7723843.1 39272 g900 i0 51.6 3.71851851851852 124 59 91.9 1 32 403 5 127 CAG7723843.1 unnamed protein product [Allacma fusca] diamond 1506 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
28434332 28434332 PRJNA478247_P_NODE_3126_length_171_cov_2.063380_g3020_i0 PRJNA478247 3126 171 2.06338 3.5283798 Sitodiplosis mosellana 263140 Arthropoda Arthropoda 42.4 0.0195   NR XP_055314946.1 263140 g3020 i0 66.7 1.47368421052632 30 10 52.6 0 75 164 867 896 XP_055314946.1 eukaryotic translation initiation factor 4 gamma 3 isoform X9 [Sitodiplosis mosellana] diamond 252 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Sitodiplosis Sitodiplosis mosellana
28955806 28955806 PRJNA478247_P_NODE_2048_length_243_cov_1.537383_g1942_i0 PRJNA478247 2048 243 1.537383 3.73584069 Metazoa 33208 Arthropoda Arthropoda 55.1 1.66e-6   NR XP_017481987.1 28612 g1942 i0 36.3 4.9382716049382704 80 43 98.8 2 3 242 668 739 XP_017481987.1 PREDICTED: protein argonaute-3 [Rhagoletis zephyria] diamond 1200 55.5 0.992792792792793 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
29286656 29286656 PRJNA478247_P_NODE_3549_length_153_cov_2.540323_g3443_i0 PRJNA478247 3549 153 2.540323 3.88669419 Oppiella nova 334625 Arthropoda Arthropoda 92.8 3.66e-22   NR CAD7656091.1 334625 g3443 i0 75.5 2.90196078431373 49 12 96.1 0 5 151 93 141 CAD7656091.1 unnamed protein product [Oppiella nova] diamond 444 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
30060604 30060604 PRJNA478247_P_NODE_2871_length_185_cov_2.570513_g2765_i0 PRJNA478247 2871 185 2.570513 4.75544905 Metazoa 33208 Arthropoda Arthropoda 67.4 2.83e-11   NR CAD7252915.1 69355 g2765 i0 60.8 4.03783783783784 51 17 77.8 1 181 38 273 323 CAD7252915.1 unnamed protein product, partial [Darwinula stevensoni] diamond 747 67.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
30708123 30708123 PRJNA478247_P_NODE_3614_length_151_cov_1.721311_g3508_i0 PRJNA478247 3614 151 1.721311 2.59917961 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 49.3 5.21e-5   NR CAB4065563.1 72036 g3508 i0 48.8 2.44370860927152 41 21 81.5 0 138 16 167 207 CAB4065563.1 TGM1 [Lepeophtheirus salmonis] diamond 369 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
31245302 31245302 PRJNA478247_P_NODE_2475_length_209_cov_3.250000_g2369_i0 PRJNA478247 2475 209 3.25 6.7925 Idotea baltica 82763 Arthropoda Arthropoda 113 4.15e-29   NR MCL4112850.1 82763 g2369 i0 71 0.990430622009569 69 20 99 0 207 1 94 162 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 207 113 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31782862 31782862 PRJNA478247_P_NODE_2877_length_185_cov_1.884615_g2771_i0 PRJNA478247 2877 185 1.884615 3.48653775 Schistocerca gregaria 7010 Arthropoda Arthropoda 50.4 1.16e-5   NR XP_049851313.1 7010 g2771 i0 46.8 0.762162162162162 47 25 76.2 0 185 45 98 144 XP_049851313.1 myosin regulatory light chain-like [Schistocerca gregaria] diamond 141 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32115665 32115665 PRJNA478247_P_NODE_1898_length_255_cov_1.575221_g1792_i0 PRJNA478247 1898 255 1.575221 4.01681355 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 121 1.06e-33   NR XP_049850973.1 7010 g1792 i0 69.7 3.57647058823529 76 23 89.4 0 248 21 31 106 XP_049850973.1 uncharacterized protein LOC126324509 [Schistocerca gregaria] diamond 912 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32432054 32432054 PRJNA478247_P_NODE_2459_length_211_cov_1.846154_g2353_i0 PRJNA478247 2459 211 1.846154 3.89538494 Sarcoptiformes 83137 Arthropoda Arthropoda 107 2.47e-26   NR KAI7692677.1 52283 g2353 i0 65.7 21.0568720379147 70 24 99.5 0 2 211 186 255 KAI7692677.1 hypothetical protein SSS_06703 [Sarcoptes scabiei] diamond 4443 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Sarcoptidae Sarcoptes Sarcoptes scabiei

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