RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1255065" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1255065 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
26757159 26757159 PRJNA1255065_P_NODE_152201_length_162_cov_0.920354_g149973_i0 PRJNA1255065 152201 162 0.920354 1.49097348 Oppia nitens 1686743 Arthropoda Arthropoda 83.6 4.62e-17   NR XP_054152904.1 1686743 g149973 i0 64.8 1 54 19 100 0 162 1 342 395 XP_054152904.1 probable ATP-dependent RNA helicase DDX28 [Oppia nitens] diamond 162 83.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
27073783 27073783 PRJNA1255065_P_NODE_149102_length_162_cov_0.920354_g146874_i0 PRJNA1255065 149102 162 0.920354 1.49097348 Vespula maculifrons 7453 Arthropoda Arthropoda 41.2 0.0454   NR KAL2746184.1 7453 g146874 i0 54.5 0.611111111111111 33 15 61.1 0 37 135 499 531 KAL2746184.1 nucleolar protein 10-like [Vespula maculifrons] diamond 99 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula maculifrons
27200014 27200014 PRJNA1255065_P_NODE_151942_length_162_cov_0.920354_g149714_i0 PRJNA1255065 151942 162 0.920354 1.49097348 Chironomus riparius 315576 Arthropoda Arthropoda 68.9 7.27e-12   NR CAG9804052.1 315576 g149714 i0 68.5 1 54 15 100 1 162 1 426 477 CAG9804052.1 unnamed protein product [Chironomus riparius] diamond 162 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
27231814 27231814 PRJNA1255065_P_NODE_111243_length_168_cov_0.873950_g109015_i0 PRJNA1255065 111243 168 0.87395 1.468236 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 58.9 2.72e-8   NR KAG5666411.1 319348 g109015 i0 55.6 1.78571428571429 45 20 80.4 0 138 4 2085 2129 KAG5666411.1 hypothetical protein PVAND_014440 [Polypedilum vanderplanki] diamond 300 58.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
27547744 27547744 PRJNA1255065_P_NODE_142464_length_163_cov_0.912281_g140236_i0 PRJNA1255065 142464 163 0.912281 1.48701803 Periplaneta americana 6978 Arthropoda Arthropoda 63.9 4.24e-10   NR KAJ4449078.1 6978 g140236 i0 57.7 0.957055214723926 52 22 95.7 0 1 156 124 175 KAJ4449078.1 hypothetical protein ANN_00473 [Periplaneta americana] diamond 156 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
28368587 28368587 PRJNA1255065_P_NODE_146966_length_163_cov_0.903509_g144738_i0 PRJNA1255065 146966 163 0.903509 1.47271967 Galendromus occidentalis 34638 Arthropoda Arthropoda 88.2 9.21e-19   NR XP_003739737.1 34638 g144738 i0 73.6 1.95092024539877 53 14 97.5 0 3 161 256 308 XP_003739737.1 DDB1- and CUL4-associated factor 13 [Galendromus occidentalis] diamond 318 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
29112854 29112854 PRJNA1255065_P_NODE_119968_length_167_cov_0.881356_g117740_i0 PRJNA1255065 119968 167 0.881356 1.47186452 Insecta 50557 Arthropoda Arthropoda 103 5e-24   NR XP_063225294.1 93214 g117740 i0 89.1 4.94011976047904 55 6 98.8 0 166 2 108 162 XP_063225294.1 trafficking kinesin-binding protein milt isoform X2 [Bacillus rossius redtenbacheri] diamond 825 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
29252512 29252512 PRJNA1255065_P_NODE_150629_length_162_cov_0.920354_g148401_i0 PRJNA1255065 150629 162 0.920354 1.49097348 Penaeus vannamei 6689 Arthropoda Arthropoda 82.8 6.37e-17   NR ROT73456.1 6689 g148401 i0 78 0.925925925925926 50 11 92.6 0 2 151 316 365 ROT73456.1 hypothetical protein C7M84_008121 [Penaeus vannamei] diamond 150 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
29852753 29852753 PRJNA1255065_P_NODE_89811_length_186_cov_1.518248_g87583_i0 PRJNA1255065 89811 186 1.518248 2.82394128 Halyomorpha halys 286706 Arthropoda Arthropoda 43.9 0.00598   NR XP_024215328.1 286706 g87583 i0 51.4 0.596774193548387 37 18 59.7 0 47 157 194 230 XP_024215328.1 protein BTG1 isoform X2 [Halyomorpha halys] diamond 111 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
29884436 29884436 PRJNA1255065_P_NODE_126491_length_166_cov_0.888889_g124263_i0 PRJNA1255065 126491 166 0.888889 1.47555574 Liposcelis entomophila 550478 Arthropoda Arthropoda 53.5 2.08e-6   NR QWV54006.1 550478 g124263 i0 47.3 1.96987951807229 55 29 99.4 0 2 166 1529 1583 QWV54006.1 vitellogenin [Liposcelis entomophila] diamond 327 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Liposcelididae Liposcelis Liposcelis entomophila
29916031 29916031 PRJNA1255065_P_NODE_112571_length_168_cov_0.873950_g110343_i0 PRJNA1255065 112571 168 0.87395 1.468236 Ceratitis capitata 7213 Arthropoda Arthropoda 43.5 0.00717   NR CAD7015496.1 7213 g110343 i0 57.4 0.839285714285714 47 18 83.9 1 146 6 420 464 CAD7015496.1 unnamed protein product, partial [Ceratitis capitata] diamond 141 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
30042193 30042193 PRJNA1255065_P_NODE_120351_length_167_cov_0.881356_g118123_i0 PRJNA1255065 120351 167 0.881356 1.47186452 Scylla paramamosain 85552 Arthropoda Arthropoda 49.7 4.68e-5   NR KAK8398046.1 85552 g118123 i0 78.6 1.50898203592814 28 6 50.3 0 167 84 201 228 KAK8398046.1 hypothetical protein O3P69_003745 [Scylla paramamosain] diamond 252 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
30516128 30516128 PRJNA1255065_P_NODE_104633_length_169_cov_1.500000_g102405_i0 PRJNA1255065 104633 169 1.5 2.535 Folsomia candida 158441 Arthropoda Arthropoda 47 4.45e-4   NR OXA40551.1 158441 g102405 i0 39.6 0.940828402366864 53 29 94.1 1 7 165 145 194 OXA40551.1 hypothetical protein Fcan01_24761 [Folsomia candida] diamond 159 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
30579106 30579106 PRJNA1255065_P_NODE_145813_length_163_cov_0.912281_g143585_i0 PRJNA1255065 145813 163 0.912281 1.48701803 Clunio marinus 568069 Arthropoda Arthropoda 112 1.2e-27   NR CRL01779.1 568069 g143585 i0 92.6 1.98773006134969 54 4 99.4 0 163 2 335 388 CRL01779.1 CLUMA_CG014995, isoform A [Clunio marinus] diamond 324 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
30768997 30768997 PRJNA1255065_P_NODE_123554_length_166_cov_0.888889_g121326_i0 PRJNA1255065 123554 166 0.888889 1.47555574 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 72 5.16e-13   NR KFM63799.1 407821 g121326 i0 73.9 0.831325301204819 46 12 83.1 0 22 159 2 47 KFM63799.1 Pogo transposable element with KRAB, partial [Stegodyphus mimosarum] diamond 138 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
31292306 31292306 PRJNA1255065_P_NODE_112795_length_168_cov_0.873950_g110567_i0 PRJNA1255065 112795 168 0.87395 1.468236 Insecta 50557 Arthropoda Arthropoda 44.7 0.00226   NR KAK1124531.1 60889 g110567 i0 59.4 9.21428571428571 32 13 57.1 0 73 168 134 165 KAK1124531.1 hypothetical protein K0M31_006879 [Melipona bicolor] diamond 1548 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Melipona Melipona bicolor
31812237 31812237 PRJNA1255065_P_NODE_15877_length_714_cov_5.852632_g13933_i0 PRJNA1255065 15877 714 5.852632 41.78779248 Tribolium castaneum 7070 Arthropoda Arthropoda 88.2 4.85e-18   NR KYB24744.1 7070 g13933 i0 64.6 0.663865546218487 158 22 60.5 3 169 600 1 138 KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum] diamond 474 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
32318768 32318768 PRJNA1255065_P_NODE_142219_length_163_cov_0.912281_g139991_i0 PRJNA1255065 142219 163 0.912281 1.48701803 Cyphomyrmex costatus 456900 Arthropoda Arthropoda 41.2 0.0434   NR KYM96604.1 456900 g139991 i0 48.6 0.644171779141104 35 16 64.4 1 146 42 459 491 KYM96604.1 DNA-directed RNA polymerase III subunit RPC5 [Cyphomyrmex costatus] diamond 105 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cyphomyrmex Cyphomyrmex costatus
32540166 32540166 PRJNA1255065_P_NODE_142639_length_163_cov_0.912281_g140411_i0 PRJNA1255065 142639 163 0.912281 1.48701803 Bactrocera tryoni 59916 Arthropoda Arthropoda 59.7 1.17e-8   NR XP_039970749.1 59916 g140411 i0 47.2 0.975460122699387 53 28 97.5 0 159 1 81 133 XP_039970749.1 uncharacterized protein LOC120782507 [Bactrocera tryoni] diamond 159 59.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Bactrocera Bactrocera tryoni

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