RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1044115" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1044115 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
171283 171283 PRJNA1044115_P_NODE_19461_length_330_cov_3.712062_g19277_i0 PRJNA1044115 19461 330 3.712062 12.2498046 Metazoa 33208 Arthropoda Arthropoda 239 1.24e-76   NR XP_031337859.1 7054 g19277 i0 99.1 268.545454545455 109 1 99.1 0 3 329 146 254 XP_031337859.1 serine/threonine-protein phosphatase PP1-beta catalytic subunit isoform X1 [Photinus pyralis] diamond 88620 241 0.991701244813278 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis
20572743 20572743 PRJNA1044115_P_NODE_40357_length_244_cov_0.912281_g40173_i0 PRJNA1044115 40357 244 0.912281 2.22596564 Arthropoda 6656 Arthropoda Arthropoda 125 8.4e-35   NR KAK9731596.1 7064 g40173 i0 72.8 1.97950819672131 81 22 99.6 0 244 2 17 97 KAK9731596.1 WD domain, G-beta repeat [Popillia japonica] diamond 483 126 0.992063492063492 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Popillia Popillia japonica
22685664 22685664 PRJNA1044115_P_NODE_36338_length_249_cov_4.676136_g36154_i0 PRJNA1044115 36338 249 4.676136 11.64357864 Diptera 7147 Arthropoda Arthropoda 125 2.3399999999999998e-34   NR XP_061394727.1 27455 g36154 i0 78.9 6.27710843373494 76 15 91.6 1 22 249 14 88 XP_061394727.1 peptidyl-prolyl cis-trans isomerase [Musca vetustissima] diamond 1563 126 0.992063492063492 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca vetustissima
26647070 26647070 PRJNA1044115_P_NODE_33781_length_253_cov_2.288889_g33597_i0 PRJNA1044115 33781 253 2.288889 5.79088917 Arthropoda 6656 Arthropoda Arthropoda 52.4 1.76e-5   NR XP_024871481.1 300111 g33597 i0 66.7 3.05928853754941 36 12 42.7 0 238 131 970 1005 XP_024871481.1 uncharacterized protein LOC112454357 isoform X3 [Temnothorax curvispinosus] diamond 774 52.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Temnothorax Temnothorax curvispinosus
27351549 27351549 PRJNA1044115_P_NODE_33063_length_256_cov_1.644809_g32879_i0 PRJNA1044115 33063 256 1.644809 4.21071104 Trichonephila clavipes 2585209 Arthropoda Arthropoda 68.6 2.24e-12   NR GFX37588.1 2585209 g32879 i0 81.8 2.66015625 33 6 38.7 0 46 144 26 58 GFX37588.1 transposable element Tcb1 transposase [Trichonephila clavipes] diamond 681 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
27375215 27375215 PRJNA1044115_P_NODE_27763_length_278_cov_1.521951_g27579_i0 PRJNA1044115 27763 278 1.521951 4.23102378 Metazoa 33208 Arthropoda Arthropoda 67.8 8.93e-11   NR NP_732295.1 7227 g27579 i0 76.7 13.6618705035971 43 10 46.4 0 131 3 466 508 NP_732295.1 well-rounded, isoform B [Drosophila melanogaster] diamond 3798 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
29553248 29553248 PRJNA1044115_P_NODE_40450_length_244_cov_0.912281_g40266_i0 PRJNA1044115 40450 244 0.912281 2.22596564 Metazoa 33208 Arthropoda Arthropoda 45.1 0.00589   NR XP_064469921.1 34597 g40266 i0 40.5 2.09016393442623 42 25 51.6 0 186 61 751 792 XP_064469921.1 uncharacterized protein LOC135384658 [Ornithodoros turicata] diamond 510 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Argasidae Ornithodoros Ornithodoros turicata
30090234 30090234 PRJNA1044115_P_NODE_12912_length_413_cov_2.285294_g12728_i0 PRJNA1044115 12912 413 2.285294 9.43826422 Arthropoda 6656 Arthropoda Arthropoda 48.9 0.0016   NR KAH9407368.1 59818 g12728 i0 39.3 2.0774818401937 112 61 76.3 1 409 95 399 510 KAH9407368.1 hypothetical protein TYRP_012923 [Tyrophagus putrescentiae] diamond 858 49.3 0.991886409736308 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30572130 30572130 PRJNA1044115_P_NODE_28553_length_274_cov_1.890547_g28369_i0 PRJNA1044115 28553 274 1.890547 5.18009878 Zophobas morio 2755281 Arthropoda Arthropoda 67.8 3.12e-12   NR XP_063914116.1 2755281 g28369 i0 81.6 1.66423357664234 38 6 41.6 1 274 161 61 97 XP_063914116.1 E3 ubiquitin-protein ligase PPP1R11 [Zophobas morio] diamond 456 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Zophobas Zophobas morio
30920102 30920102 PRJNA1044115_P_NODE_31854_length_261_cov_0.829787_g31670_i0 PRJNA1044115 31854 261 0.829787 2.16574407 Caligus rogercresseyi 217165 Arthropoda Arthropoda 70.1 1.07e-11   NR QQP50210.1 217165 g31670 i0 67.4 1.58620689655172 46 15 52.9 0 63 200 422 467 QQP50210.1 Uncharacterized protein FKW44_011137 [Caligus rogercresseyi] diamond 414 70.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Caligus Caligus rogercresseyi
31552417 31552417 PRJNA1044115_P_NODE_36796_length_249_cov_0.886364_g36612_i0 PRJNA1044115 36796 249 0.886364 2.20704636 Rhipicephalus microplus 6941 Arthropoda Arthropoda 40.8 0.0451   NR KAH8039972.1 6941 g36612 i0 81.8 0.265060240963855 22 4 26.5 0 67 2 3 24 KAH8039972.1 hypothetical protein HPB51_009228 [Rhipicephalus microplus] diamond 66 40.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus microplus
31741831 31741831 PRJNA1044115_P_NODE_35797_length_250_cov_1.762712_g35613_i0 PRJNA1044115 35797 250 1.762712 4.40678 Agrilus planipennis 224129 Arthropoda Arthropoda 68.6 1.08e-12   NR XP_018319698.1 224129 g35613 i0 61.7 1.164 47 18 56.4 0 10 150 17 63 XP_018319698.1 kelch-like protein 18 [Agrilus planipennis] diamond 291 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
32374887 32374887 PRJNA1044115_P_NODE_34879_length_252_cov_0.871508_g34695_i0 PRJNA1044115 34879 252 0.871508 2.19620016 Cyprideis torosa 163714 Arthropoda Arthropoda 69.3 1.52e-11   NR CAD7232077.1 163714 g34695 i0 53.6 0.666666666666667 56 26 66.7 0 3 170 9 64 CAD7232077.1 unnamed protein product [Cyprideis torosa] diamond 168 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cytherideidae Cyprideis Cyprideis torosa

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