RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 24 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA572587 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
4386610 4386610 PRJNA572587_P_NODE_6084_length_502_cov_27.883002_g5763_i0 PRJNA572587 6084 502 27.883002 139.97267004 Nilaparvata lugens 108931 Arthropoda Arthropoda 63.5 4.91e-10   NR XP_039278123.1 108931 g5763 i0 52.6 1.94223107569721 57 27 34.1 0 495 325 16 72 XP_039278123.1 RNA polymerase II transcriptional coactivator-like [Nilaparvata lugens] diamond 975 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
26762972 26762972 PRJNA572587_P_NODE_24901_length_225_cov_4.698864_g24573_i0 PRJNA572587 24901 225 4.698864 10.572444 Apolygus lucorum 248454 Arthropoda Arthropoda 62 2.25e-9   NR KAF6212895.1 248454 g24573 i0 67.4 0.613333333333333 46 15 61.3 0 180 43 47 92 KAF6212895.1 hypothetical protein GE061_010605 [Apolygus lucorum] diamond 138 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Apolygus Apolygus lucorum
26762982 26762982 PRJNA572587_P_NODE_35701_length_184_cov_11.896296_g35373_i0 PRJNA572587 35701 184 11.896296 21.88918464 Polyplax serrata 468196 Arthropoda Arthropoda 101 7.339999999999999e-24   NR KAK6619904.1 468196 g35373 i0 90.6 1.72826086956522 53 5 86.4 0 182 24 130 182 KAK6619904.1 hypothetical protein RUM44_006304 [Polyplax serrata] diamond 318 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27016138 27016138 PRJNA572587_P_NODE_16622_length_280_cov_72.025974_g16294_i0 PRJNA572587 16622 280 72.025974 201.6727272 Penaeus vannamei 6689 Arthropoda Arthropoda 45.4 0.00614   NR ROT76458.1 6689 g16294 i0 47.8 0.739285714285714 69 35 73.9 1 12 218 362 429 ROT76458.1 hypothetical protein C7M84_004948 [Penaeus vannamei] diamond 207 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27061461 27061461 PRJNA572587_P_NODE_2882_length_773_cov_6.403315_g2053_i1 PRJNA572587 2882 773 6.403315 49.49762495 root 1 Root_unresolved Root_unresolved 103 3.42e-21   NR CAL4104840.1 48144 g2053 i1 46.1 3.22509702457956 115 54 44.6 2 469 125 182 288 CAL4104840.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 2493 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
27743189 27743189 PRJNA572587_P_NODE_9564_length_386_cov_22.827893_g9237_i0 PRJNA572587 9564 386 22.827893 88.11566698 Penaeus vannamei 6689 Arthropoda Arthropoda 45.1 0.0261   NR ROT77260.1 6689 g9237 i0 39 0.816062176165803 105 55 78.5 4 16 318 86 185 ROT77260.1 hypothetical protein C7M84_004117 [Penaeus vannamei] diamond 315 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27806235 27806235 PRJNA572587_P_NODE_7564_length_442_cov_13.732824_g7239_i0 PRJNA572587 7564 442 13.732824 60.69908208 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 109 1.3399999999999999e-24   NR KFM62707.1 407821 g7239 i0 59.3 0.950226244343891 140 57 95 0 421 2 599 738 KFM62707.1 Laminin subunit alpha-2, partial [Stegodyphus mimosarum] diamond 420 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
27869028 27869028 PRJNA572587_P_NODE_3845_length_663_cov_8.908795_g3555_i0 PRJNA572587 3845 663 8.908795 59.06531085 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 136 6.95e-35   NR KAH9390418.1 59818 g3555 i0 67 0.493212669683258 109 13 49.3 1 24 350 190 275 KAH9390418.1 hypothetical protein TYRP_023070, partial [Tyrophagus putrescentiae] diamond 327 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28058584 28058584 PRJNA572587_P_NODE_36945_length_181_cov_2.946970_g36617_i0 PRJNA572587 36945 181 2.94697 5.3340157 Oppiella nova 334625 Arthropoda Arthropoda 48.9 1.08e-4   NR CAD7653615.1 334625 g36617 i0 70.4 1.34254143646409 27 8 44.8 0 17 97 331 357 CAD7653615.1 unnamed protein product, partial [Oppiella nova] diamond 243 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
28184690 28184690 PRJNA572587_P_NODE_4506_length_601_cov_82.677536_g4201_i0 PRJNA572587 4506 601 82.677536 496.89199136 Frankliniella fusca 407009 Arthropoda Arthropoda 352 6.49e-122   NR KAK3932691.1 407009 g4201 i0 94.1 0.843594009983361 169 10 84.4 0 21 527 1 169 KAK3932691.1 Putative thiol protease R355 [Frankliniella fusca] diamond 507 352 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Thysanoptera Thripidae Frankliniella Frankliniella fusca
28279432 28279432 PRJNA572587_P_NODE_10046_length_375_cov_11.233129_g9719_i0 PRJNA572587 10046 375 11.233129 42.12423375 Lucilia sericata 13632 Arthropoda Arthropoda 132 7.13e-34   NR XP_037816196.1 13632 g9719 i0 85.1 2.368 74 11 59.2 0 355 134 345 418 XP_037816196.1 equilibrative nucleoside transporter 1 [Lucilia sericata] diamond 888 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia sericata
28279440 28279440 PRJNA572587_P_NODE_29286_length_205_cov_20.647436_g28958_i0 PRJNA572587 29286 205 20.647436 42.3272438 Caligus rogercresseyi 217165 Arthropoda Arthropoda 52.4 9.12e-6   NR QQP50210.1 217165 g28958 i0 49.2 1.72682926829268 59 24 77.6 1 195 37 430 488 QQP50210.1 Uncharacterized protein FKW44_011137 [Caligus rogercresseyi] diamond 354 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
28293139 28293139 PRJNA572587_P_NODE_16846_length_278_cov_26.222707_g16518_i0 PRJNA572587 16846 278 26.222707 72.89912546 Lepidoptera 7088 Arthropoda Arthropoda 69.3 2.61e-11   NR XP_050550436.1 7108 g16518 i0 75.6 1.99640287769784 45 11 48.6 0 26 160 811 855 XP_050550436.1 uncharacterized protein LOC118279092 [Spodoptera frugiperda] diamond 555 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera frugiperda
28640739 28640739 PRJNA572587_P_NODE_31807_length_197_cov_0.972973_g31479_i0 PRJNA572587 31807 197 0.972973 1.91675681 Metazoa 33208 Arthropoda Arthropoda 68.9 1.16e-11   NR CAL4065462.1 48144 g31479 i0 56 2.34517766497462 50 21 76.1 1 169 20 78 126 CAL4065462.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 462 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
28784662 28784662 PRJNA572587_P_NODE_26787_length_216_cov_6.000000_g26459_i0 PRJNA572587 26787 216 6 12.96 Uroleucon formosanum 796250 Arthropoda Arthropoda 110 3.7e-26   NR KAL4126998.1 796250 g26459 i0 85.5 16.3333333333333 62 9 86.1 0 21 206 681 742 KAL4126998.1 hypothetical protein QTP88_011196 [Uroleucon formosanum] diamond 3528 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
29840368 29840368 PRJNA572587_P_NODE_2251_length_865_cov_8.376225_g2053_i0 PRJNA572587 2251 865 8.376225 72.45434625 root 1 Root_unresolved Root_unresolved 104 5.3e-21   NR CAL4104840.1 48144 g2053 i0 41.8 1.57803468208092 134 63 44 3 561 181 182 307 CAL4104840.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 1365 105 0.990476190476191 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
30205609 30205609 PRJNA572587_P_NODE_29632_length_204_cov_9.458065_g29304_i0 PRJNA572587 29632 204 9.458065 19.2944526 Armadillidium nasatum 96803 Arthropoda Arthropoda 73.9 2.03e-13   NR KAB7501558.1 96803 g29304 i0 100 0.558823529411765 38 0 55.9 0 91 204 15 52 KAB7501558.1 26S protease regulatory subunit 6A [Armadillidium nasatum] diamond 114 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium nasatum
31072647 31072647 PRJNA572587_P_NODE_29615_length_204_cov_12.529032_g29287_i0 PRJNA572587 29615 204 12.529032 25.55922528 Araneae 6893 Arthropoda Arthropoda 98.2 2.85e-24   NR XP_055953994.1 94029 g29287 i0 73.1 1.52941176470588 52 14 76.5 0 179 24 93 144 XP_055953994.1 U24-ctenitoxin-Pn1a-like [Argiope bruennichi] diamond 312 98.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
31565095 31565095 PRJNA572587_P_NODE_19856_length_254_cov_34.673171_g19528_i0 PRJNA572587 19856 254 34.673171 88.06985434 Penaeus vannamei 6689 Arthropoda Arthropoda 43.1 0.0306   NR ROT76113.1 6689 g19528 i0 47.2 0.850393700787402 72 30 80.3 4 49 252 176 243 ROT76113.1 hypothetical protein C7M84_005294 [Penaeus vannamei] diamond 216 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
31944284 31944284 PRJNA572587_P_NODE_26557_length_217_cov_4.613095_g26229_i0 PRJNA572587 26557 217 4.613095 10.01041615 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 70.1 5.65e-12   NR KAH9387719.1 59818 g26229 i0 91.2 0.470046082949309 34 3 47 0 2 103 371 404 KAH9387719.1 hypothetical protein TYRP_008913 [Tyrophagus putrescentiae] diamond 102 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32134405 32134405 PRJNA572587_P_NODE_17298_length_274_cov_5.200000_g16970_i0 PRJNA572587 17298 274 5.2 14.248 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 92 2.36e-22   NR KAH9403786.1 59818 g16970 i0 92 0.547445255474453 50 4 54.7 0 150 1 11 60 KAH9403786.1 hypothetical protein TYRP_014978, partial [Tyrophagus putrescentiae] diamond 150 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32211264 32211264 PRJNA572587_P_NODE_7678_length_439_cov_4.423077_g7353_i0 PRJNA572587 7678 439 4.423077 19.41730803 Opisthokonta 33154 Arthropoda Arthropoda 59.3 4.63e-8   NR KAL3218452.1 6941 g7353 i0 44.3 2.15261958997722 79 38 50.6 2 207 428 23 100 KAL3218452.1 hypothetical protein MRX96_050717 [Rhipicephalus microplus] diamond 945 59.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
32324485 32324485 PRJNA572587_P_NODE_4899_length_574_cov_16.695238_g4585_i0 PRJNA572587 4899 574 16.695238 95.83066612 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 71.6 1.07e-10   NR KAH9391901.1 59818 g4585 i0 71.4 0.25609756097561 49 14 25.6 0 29 175 1780 1828 KAH9391901.1 hypothetical protein TYRP_022400, partial [Tyrophagus putrescentiae] diamond 147 71.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
32639929 32639929 PRJNA572587_P_NODE_23960_length_230_cov_3.132597_g23632_i0 PRJNA572587 23960 230 3.132597 7.2049731 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 49.3 2.37e-5   NR KAH9400472.1 59818 g23632 i0 73.3 0.391304347826087 30 8 39.1 0 37 126 42 71 KAH9400472.1 hypothetical protein TYRP_002037 [Tyrophagus putrescentiae] diamond 90 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae

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