RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB27957 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
27127598 27127598 PRJEB27957_P_NODE_76322_length_195_cov_2.472603_g76212_i0 PRJEB27957 76322 195 2.472603 4.82157585 Tachinus subterraneus 879013 Arthropoda Arthropoda 42 0.0338   NR ARH54680.1 879013 g76212 i0 39.2 0.784615384615385 51 31 78.5 0 165 13 35 85 ARH54680.1 ATP synthase F0 subunit 6 [Tachinus subterraneus] diamond 153 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Tachinus Tachinus subterraneus
27317820 27317820 PRJEB27957_P_NODE_104483_length_169_cov_0.866667_g104373_i0 PRJEB27957 104483 169 0.866667 1.46466723 Nymphon striatum 424472 Arthropoda Arthropoda 42 0.0255   NR KAG1654967.1 424472 g104373 i0 82.4 0.301775147928994 17 3 30.2 0 91 41 97 113 KAG1654967.1 hypothetical protein GQR58_024765 [Nymphon striatum] diamond 51 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
27570248 27570248 PRJEB27957_P_NODE_111224_length_166_cov_1.752137_g111114_i0 PRJEB27957 111224 166 1.752137 2.90854742 Rhipicephalus appendiculatus 34631 Arthropoda Arthropoda 43.9 0.0052   NR KAL1470208.1 34631 g111114 i0 51.3 0.704819277108434 39 19 70.5 0 121 5 5 43 KAL1470208.1 hypothetical protein MTO96_040572 [Rhipicephalus appendiculatus] diamond 117 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
27791444 27791444 PRJEB27957_P_NODE_95664_length_176_cov_0.850394_g95554_i0 PRJEB27957 95664 176 0.850394 1.49669344 Eupeodes corollae 290404 Arthropoda Arthropoda 51.2 1.53e-5   NR XP_055910110.1 290404 g95554 i0 39.7 1.90909090909091 58 34 97.2 1 172 2 224 281 XP_055910110.1 zinc finger protein 391-like [Eupeodes corollae] diamond 336 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Eupeodes Eupeodes corollae
27980822 27980822 PRJEB27957_P_NODE_80485_length_191_cov_1.316901_g80375_i0 PRJEB27957 80485 191 1.316901 2.51528091 Ixodes scapularis 6945 Arthropoda Arthropoda 48.9 1.21e-4   NR XP_040356372.1 6945 g80375 i0 35.8 0.832460732984293 53 34 83.2 0 21 179 283 335 XP_040356372.1 uncharacterized protein LOC121046324 [Ixodes scapularis] diamond 159 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
28100481 28100481 PRJEB27957_P_NODE_111405_length_166_cov_1.333333_g111295_i0 PRJEB27957 111405 166 1.333333 2.21333278 Nymphalidae 33415 Arthropoda Arthropoda 60.5 7.37e-9   NR CAH2106948.1 104508 g111295 i0 57.7 5.67469879518072 52 19 94 1 2 157 538 586 CAH2106948.1 unnamed protein product [Euphydryas editha] diamond 942 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Euphydryas Euphydryas editha
28233112 28233112 PRJEB27957_P_NODE_59566_length_216_cov_2.329341_g59456_i0 PRJEB27957 59566 216 2.329341 5.03137656 Ceratitis capitata 7213 Arthropoda Arthropoda 49.7 9.36e-5   NR CAD6993233.1 7213 g59456 i0 47.7 2.41666666666667 44 23 61.1 0 214 83 251 294 CAD6993233.1 unnamed protein product [Ceratitis capitata] diamond 522 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
28296408 28296408 PRJEB27957_P_NODE_41646_length_249_cov_1.040000_g41536_i0 PRJEB27957 41646 249 1.04 2.5896 Agrilus planipennis 224129 Arthropoda Arthropoda 50.8 5.59e-5   NR XP_025836012.1 224129 g41536 i0 69 0.349397590361446 29 9 34.9 0 2 88 521 549 XP_025836012.1 zinc finger protein 345 [Agrilus planipennis] diamond 87 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
28549319 28549319 PRJEB27957_P_NODE_46627_length_238_cov_1.132275_g46517_i0 PRJEB27957 46627 238 1.132275 2.6948145 Phthorimaea operculella 192464 Arthropoda Arthropoda 50.8 4.82e-5   NR KAI5637226.1 192464 g46517 i0 55.6 0.894957983193277 36 16 45.4 0 1 108 394 429 KAI5637226.1 hypothetical protein NE865_10123 [Phthorimaea operculella] diamond 213 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Gelechiidae Phthorimaea Phthorimaea operculella
28643998 28643998 PRJEB27957_P_NODE_84707_length_187_cov_1.115942_g84597_i0 PRJEB27957 84707 187 1.115942 2.08681154 Araneus ventricosus 182803 Arthropoda Arthropoda 62.4 9.03e-10   NR GBL85036.1 182803 g84597 i0 43.9 4.17112299465241 66 23 83.4 2 169 14 32 97 GBL85036.1 Transposable element Tc1 transposase [Araneus ventricosus] diamond 780 62.8 0.993630573248408 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
28991461 28991461 PRJEB27957_P_NODE_99188_length_172_cov_1.691057_g99078_i0 PRJEB27957 99188 172 1.691057 2.90861804 Araneus ventricosus 182803 Arthropoda Arthropoda 50.1 3.8e-5   NR GBN61280.1 182803 g99078 i0 51.1 3.13953488372093 45 20 75 1 32 160 1150 1194 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 540 50.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
29243786 29243786 PRJEB27957_P_NODE_65889_length_208_cov_1.308176_g65779_i0 PRJEB27957 65889 208 1.308176 2.72100608 Daphnia magna 35525 Arthropoda Arthropoda 48.1 1.72e-5   NR KZS01806.1 35525 g65779 i0 50 1.00961538461538 46 16 66.3 1 138 1 8 46 KZS01806.1 Uncharacterized protein APZ42_001427 [Daphnia magna] diamond 210 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
29338546 29338546 PRJEB27957_P_NODE_113729_length_166_cov_0.888889_g113619_i0 PRJEB27957 113729 166 0.888889 1.47555574 Aquatica leii 1421715 Arthropoda Arthropoda 41.6 0.0343   NR KAK4885331.1 1421715 g113619 i0 35 1.44578313253012 40 26 72.3 0 17 136 286 325 KAK4885331.1 hypothetical protein RN001_001602 [Aquatica leii] diamond 240 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Aquatica Aquatica leii
29811915 29811915 PRJEB27957_P_NODE_40151_length_252_cov_1.798030_g40041_i0 PRJEB27957 40151 252 1.79803 4.5310356 Caerostris darwini 1538125 Arthropoda Arthropoda 41.6 0.0452   NR GIY31693.1 1538125 g40041 i0 41.3 0.547619047619048 46 23 54.8 2 205 68 52 93 GIY31693.1 uncharacterized protein CDAR_557141 [Caerostris darwini] diamond 138 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
29906954 29906954 PRJEB27957_P_NODE_81731_length_190_cov_1.070922_g81621_i0 PRJEB27957 81731 190 1.070922 2.0347518 Orchesella dallaii 48710 Arthropoda Arthropoda 67 5.17e-11   NR CAL8068833.1 48710 g81621 i0 80.5 24.3631578947368 41 8 64.7 0 124 2 479 519 CAL8068833.1 unnamed protein product [Orchesella dallaii] diamond 4629 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
30096249 30096249 PRJEB27957_P_NODE_116052_length_165_cov_0.896552_g115942_i0 PRJEB27957 116052 165 0.896552 1.4793108 Araneus ventricosus 182803 Arthropoda Arthropoda 58.5 7.42e-9   NR GBM50487.1 182803 g115942 i0 72.7 0.6 33 9 60 0 113 15 127 159 GBM50487.1 hypothetical protein AVEN_254767-1 [Araneus ventricosus] diamond 99 58.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30665097 30665097 PRJEB27957_P_NODE_100813_length_171_cov_1.278689_g100703_i0 PRJEB27957 100813 171 1.278689 2.18655819 Trichonephila clavipes 2585209 Arthropoda Arthropoda 62 1.06e-10   NR GFV39670.1 2585209 g100703 i0 64.1 1.36842105263158 39 14 68.4 0 153 37 51 89 GFV39670.1 uncharacterized protein TNCV_4183751 [Trichonephila clavipes] diamond 234 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
30696581 30696581 PRJEB27957_P_NODE_4694_length_548_cov_1.625251_g4591_i0 PRJEB27957 4694 548 1.625251 8.90637548 Araneus ventricosus 182803 Arthropoda Arthropoda 51.2 1.14e-4   NR GBM06688.1 182803 g4591 i0 37.2 0.958029197080292 94 40 44.9 4 140 385 41 127 GBM06688.1 hypothetical protein AVEN_227037-1 [Araneus ventricosus] diamond 525 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30785002 30785002 PRJEB27957_P_NODE_55134_length_223_cov_1.419540_g55024_i0 PRJEB27957 55134 223 1.41954 3.1655742 Metazoa 33208 Arthropoda Arthropoda 57 1.93e-7   NR XP_045118463.1 210409 g55024 i0 78.1 3.02690582959641 32 7 43 0 61 156 25 56 XP_045118463.1 general transcription factor II-I repeat domain-containing protein 2B-like [Portunus trituberculatus] diamond 675 57.4 0.993031358885017 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Portunus Portunus trituberculatus
30791466 30791466 PRJEB27957_P_NODE_40894_length_250_cov_2.860697_g40784_i0 PRJEB27957 40894 250 2.860697 7.1517425 Trichonephila clavipes 2585209 Arthropoda Arthropoda 66.6 4.57e-12   NR GFV22439.1 2585209 g40784 i0 74.4 0.468 39 10 46.8 0 38 154 51 89 GFV22439.1 transposable element Tcb1 transposase, partial [Trichonephila clavipes] diamond 117 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
30886255 30886255 PRJEB27957_P_NODE_64974_length_209_cov_1.493750_g64864_i0 PRJEB27957 64974 209 1.49375 3.1219375 Diaphorina citri 121845 Arthropoda Arthropoda 55.5 1.31e-7   NR XP_026684748.1 121845 g64864 i0 61.1 1.43540669856459 36 14 51.7 0 3 110 2 37 XP_026684748.1 protein krueppel-like [Diaphorina citri] diamond 300 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
31201779 31201779 PRJEB27957_P_NODE_74775_length_197_cov_1.527027_g74665_i0 PRJEB27957 74775 197 1.527027 3.00824319 Araneus ventricosus 182803 Arthropoda Arthropoda 44.7 4.93e-4   NR GBL82659.1 182803 g74665 i0 55.9 0.517766497461929 34 15 51.8 0 44 145 4 37 GBL82659.1 hypothetical protein AVEN_266717-1, partial [Araneus ventricosus] diamond 102 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
31233660 31233660 PRJEB27957_P_NODE_27295_length_293_cov_1.487705_g27185_i0 PRJEB27957 27295 293 1.487705 4.35897565 Allacma fusca 39272 Arthropoda Arthropoda 44.7 0.0137   NR CAG7816599.1 39272 g27185 i0 51.2 0.419795221843003 41 18 39.9 2 89 205 224 264 CAG7816599.1 unnamed protein product [Allacma fusca] diamond 123 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
31455323 31455323 PRJEB27957_P_NODE_48476_length_234_cov_2.059459_g48366_i0 PRJEB27957 48476 234 2.059459 4.81913406 Drosophila willistoni 7260 Arthropoda Arthropoda 43.1 0.0232   NR EDW79167.1 7260 g48366 i0 34.7 1.25641025641026 49 32 62.8 0 197 51 6 54 EDW79167.1 uncharacterized protein Dwil_GK12702 [Drosophila willistoni] diamond 294 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila willistoni
32182961 32182961 PRJEB27957_P_NODE_26158_length_298_cov_1.228916_g26048_i0 PRJEB27957 26158 298 1.228916 3.66216968 Araneus ventricosus 182803 Arthropoda Arthropoda 60.1 3.81e-8   NR GBM61631.1 182803 g26048 i0 40.3 0.775167785234899 77 41 72.5 3 65 280 146 222 GBM61631.1 hypothetical protein AVEN_122248-1 [Araneus ventricosus] diamond 231 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus

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