RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA764222" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA764222 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
8397903 8397903 PRJNA764222_S_NODE_24027_length_192_cov_1.827586_g23869_i0 PRJNA764222 24027 192 1.827586 3.50896512 Ceratitis capitata 7213 Arthropoda Arthropoda 101 4.26e-23   NR CAD7015493.1 7213 g23869 i0 88.9 0.84375 54 6 84.4 0 192 31 193 246 CAD7015493.1 unnamed protein product [Ceratitis capitata] diamond 162 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
14773461 14773461 PRJNA764222_S_NODE_11752_length_251_cov_2.284314_g11594_i0 PRJNA764222 11752 251 2.284314 5.73362814 Bradysia odoriphaga 1564500 Arthropoda Arthropoda 164 3.839999999999999e-47   NR KAG4072441.1 1564500 g11594 i0 97.5 0.968127490039841 81 2 96.8 0 5 247 1 81 KAG4072441.1 hypothetical protein HA402_004373 [Bradysia odoriphaga] diamond 243 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia odoriphaga
27179444 27179444 PRJNA764222_S_NODE_6902_length_288_cov_2.493776_g6744_i0 PRJNA764222 6902 288 2.493776 7.18207488 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 71.2 6.83e-13   NR XP_021928219.1 136037 g6744 i0 56.5 0.71875 69 22 71.9 1 233 27 121 181 XP_021928219.1 uncharacterized protein LOC110833914 isoform X1 [Zootermopsis nevadensis] diamond 207 71.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
27306209 27306209 PRJNA764222_S_NODE_14243_length_237_cov_2.194737_g14085_i0 PRJNA764222 14243 237 2.194737 5.20152669 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 43.5 0.00647   NR KDR22370.1 136037 g14085 i0 50 0.506329113924051 40 20 50.6 0 53 172 14 53 KDR22370.1 hypothetical protein L798_01081 [Zootermopsis nevadensis] diamond 120 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
27558543 27558543 PRJNA764222_S_NODE_19564_length_211_cov_2.573171_g19406_i0 PRJNA764222 19564 211 2.573171 5.42939081 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 88.2 3.69e-20   NR KAJ6638453.1 35572 g19406 i0 68.8 1.7914691943128 64 20 91 0 2 193 90 153 KAJ6638453.1 hypothetical protein Bhyg_11188 [Pseudolycoriella hygida] diamond 378 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
27590523 27590523 PRJNA764222_S_NODE_8664_length_273_cov_1.150442_g8506_i0 PRJNA764222 8664 273 1.150442 3.14070666 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 77.4 7.56e-15   NR KAG5677327.1 319348 g8506 i0 40.7 1.98901098901099 91 54 100 0 273 1 152 242 KAG5677327.1 hypothetical protein PVAND_007095 [Polypedilum vanderplanki] diamond 543 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
29042900 29042900 PRJNA764222_S_NODE_2208_length_398_cov_1.760684_g2050_i0 PRJNA764222 2208 398 1.760684 7.00752232 Bradysia coprophila 38358 Arthropoda Arthropoda 167 3.66e-45   NR XP_037043261.1 38358 g2050 i0 82.6 0.693467336683417 92 16 69.3 0 397 122 1915 2006 XP_037043261.1 vitellogenin-A1-like [Bradysia coprophila] diamond 276 167 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
29547712 29547712 PRJNA764222_S_NODE_19530_length_211_cov_3.323171_g19372_i0 PRJNA764222 19530 211 3.323171 7.01189081 Chironomus riparius 315576 Arthropoda Arthropoda 107 9.91e-28   NR CAG9798656.1 315576 g19372 i0 85.5 0.781990521327014 55 8 78.2 0 1 165 87 141 CAG9798656.1 unnamed protein product [Chironomus riparius] diamond 165 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
30021760 30021760 PRJNA764222_S_NODE_17231_length_222_cov_2.017143_g17073_i0 PRJNA764222 17231 222 2.017143 4.47805746 Nesidiocoris tenuis 355587 Arthropoda Arthropoda 66.2 1.44e-10   NR CAB0001583.1 355587 g17073 i0 44.1 9.60810810810811 68 37 90.5 1 205 5 530 597 CAB0001583.1 unnamed protein product [Nesidiocoris tenuis] diamond 2133 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Miridae Nesidiocoris Nesidiocoris tenuis
30316106 30316106 PRJNA764222_S_NODE_2112_length_404_cov_5.218487_g1954_i0 PRJNA764222 2112 404 5.218487 21.08268748 root 1 Root_unresolved Root_unresolved 53.1 5.15e-5   NR GBN61280.1 182803 g1954 i0 50.9 4.81930693069307 53 26 39.4 0 123 281 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1947 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30748357 30748357 PRJNA764222_S_NODE_5454_length_304_cov_1.964981_g5296_i0 PRJNA764222 5454 304 1.964981 5.97354224 Chironomus tepperi 113505 Arthropoda Arthropoda 177 2.56e-53   NR XP_070504695.1 113505 g5296 i0 84.3 2.01315789473684 102 15 99.7 1 303 1 128 229 XP_070504695.1 chymotrypsin-2-like [Chironomus tepperi] diamond 612 177 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
30906471 30906471 PRJNA764222_S_NODE_4854_length_312_cov_1.803774_g4696_i0 PRJNA764222 4854 312 1.803774 5.62777488 Chironomus tepperi 113505 Arthropoda Arthropoda 124 1.33e-33   NR XP_070498202.1 113505 g4696 i0 96.7 1.15384615384615 60 2 57.7 0 310 131 126 185 XP_070498202.1 signal peptidase complex catalytic subunit SEC11A [Chironomus tepperi] diamond 360 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
30938032 30938032 PRJNA764222_S_NODE_19354_length_212_cov_2.466667_g19196_i0 PRJNA764222 19354 212 2.466667 5.22933404 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 71.6 1.03e-12   NR KAJ6642562.1 35572 g19196 i0 77.8 1.33018867924528 45 10 63.7 0 1 135 250 294 KAJ6642562.1 Hemolysin E [Pseudolycoriella hygida] diamond 282 71.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
31190285 31190285 PRJNA764222_S_NODE_33595_length_155_cov_2.527778_g33437_i0 PRJNA764222 33595 155 2.527778 3.9180559 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 78.2 5.59e-16   NR KAG5668460.1 319348 g33437 i0 81.6 2.90322580645161 49 8 92.9 1 11 154 164 212 KAG5668460.1 hypothetical protein PVAND_016400 [Polypedilum vanderplanki] diamond 450 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
31222028 31222028 PRJNA764222_S_NODE_5135_length_308_cov_1.992337_g4977_i0 PRJNA764222 5135 308 1.992337 6.13639796 Oppiella nova 334625 Arthropoda Arthropoda 41.6 0.0491   NR CAD7663271.1 334625 g4977 i0 31.5 0.711038961038961 73 47 71.1 1 5 223 18 87 CAD7663271.1 unnamed protein product, partial [Oppiella nova] diamond 219 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
32329794 32329794 PRJNA764222_S_NODE_13299_length_242_cov_2.374359_g13141_i0 PRJNA764222 13299 242 2.374359 5.74594878 Clunio marinus 568069 Arthropoda Arthropoda 43.1 0.0258   NR CRK99038.1 568069 g13141 i0 68.3 0.508264462809917 41 9 50.8 1 241 119 331 367 CRK99038.1 CLUMA_CG012153, isoform A [Clunio marinus] diamond 123 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus

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