RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939369 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
26715055 26715055 PRJNA939369_S_NODE_50681_length_257_cov_1.114130_g50264_i0 PRJNA939369 50681 257 1.11413 2.8633141 Timema 61471 Arthropoda Arthropoda 142 3.31e-41   NR CAD7458426.1 61484 g50264 i0 92.2 4.49416342412451 77 6 89.9 0 255 25 90 166 CAD7458426.1 unnamed protein product [Timema tahoe] diamond 1155 142 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema tahoe
27341249 27341249 PRJNA939369_S_NODE_76183_length_241_cov_0.916667_g75766_i0 PRJNA939369 76183 241 0.916667 2.20916747 Schistocerca americana 7009 Arthropoda Arthropoda 45.8 0.00227   NR XP_046982045.1 7009 g75766 i0 82.7 1.21991701244813 52 8 63.5 1 218 66 100 151 XP_046982045.1 cuticle protein 63 isoform X1 [Schistocerca americana] diamond 294 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca americana
27341251 27341251 PRJNA939369_S_NODE_78463_length_230_cov_3.350318_g78046_i0 PRJNA939369 78463 230 3.350318 7.7057314 Penaeus vannamei 6689 Arthropoda Arthropoda 43.1 0.023   NR ROT84525.1 6689 g78046 i0 78.6 0.365217391304348 28 6 36.5 0 86 3 445 472 ROT84525.1 Cytochrome P450 2J6 [Penaeus vannamei] diamond 84 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27561910 27561910 PRJNA939369_S_NODE_60404_length_248_cov_1.422857_g59987_i0 PRJNA939369 60404 248 1.422857 3.52868536 Cinara cedri 506608 Arthropoda Arthropoda 71.6 2.36e-13   NR VVC42816.1 506608 g59987 i0 68.5 0.653225806451613 54 17 65.3 0 85 246 103 156 VVC42816.1 Hypothetical protein CINCED_3A015187 [Cinara cedri] diamond 162 71.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
27821942 27821942 PRJNA939369_S_NODE_70204_length_244_cov_0.900585_g69787_i0 PRJNA939369 70204 244 0.900585 2.1974274 Metazoa 33208 Arthropoda Arthropoda 47.4 8.2e-4   NR XP_053604900.1 58824 g69787 i0 44.7 3.31967213114754 38 21 46.7 0 242 129 314 351 XP_053604900.1 baculoviral IAP repeat-containing protein 7-B isoform X3 [Plodia interpunctella] diamond 810 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Plodia Plodia interpunctella
28730407 28730407 PRJNA939369_S_NODE_28687_length_305_cov_0.909483_g28270_i0 PRJNA939369 28687 305 0.909483 2.77392315 Anthophora retusa 597843 Arthropoda Arthropoda 60.5 4.76e-8   NR CAK9828016.1 597843 g28270 i0 69.2 0.767213114754098 39 12 38.4 0 125 9 397 435 CAK9828016.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Anthophora retusa] diamond 234 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora retusa
28824826 28824826 PRJNA939369_S_NODE_44648_length_267_cov_1.556701_g44231_i0 PRJNA939369 44648 267 1.556701 4.15639167 Timema genevievae 629358 Arthropoda Arthropoda 43.1 0.00797   NR CAD7597679.1 629358 g44231 i0 46.9 0.808988764044944 32 17 36 0 68 163 43 74 CAD7597679.1 unnamed protein product, partial [Timema genevievae] diamond 216 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema genevievae
29330247 29330247 PRJNA939369_S_NODE_28369_length_305_cov_7.215517_g27952_i0 PRJNA939369 28369 305 7.215517 22.00732685 Penaeus monodon 6687 Arthropoda Arthropoda 81.3 2.23e-16   NR XP_037800646.1 6687 g27952 i0 92.7 0.40327868852459 41 3 40.3 0 2 124 174 214 XP_037800646.1 probable global transcription activator SNF2L2 [Penaeus monodon] diamond 123 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
29431733 29431733 PRJNA939369_S_NODE_66589_length_245_cov_1.790698_g66172_i0 PRJNA939369 66589 245 1.790698 4.3872101 Ixodes 6944 Arthropoda Arthropoda 97.4 2.11e-21   NR EEC20589.1 6945 g66172 i0 61.7 4.93469387755102 81 31 99.2 0 245 3 381 461 EEC20589.1 methyltransferase, putative [Ixodes scapularis] diamond 1209 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
29558174 29558174 PRJNA939369_S_NODE_43610_length_269_cov_1.607143_g43193_i0 PRJNA939369 43610 269 1.607143 4.32321467 Schistocerca 7008 Arthropoda Arthropoda 150 3.3699999999999993e-43   NR XP_046980025.1 7009 g43193 i0 80.9 3.97026022304833 89 17 99.3 0 2 268 36 124 XP_046980025.1 protein takeout-like [Schistocerca americana] diamond 1068 151 0.993377483443709 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca americana
29867090 29867090 PRJNA939369_S_NODE_43911_length_269_cov_1.005102_g43494_i0 PRJNA939369 43911 269 1.005102 2.70372438 Penaeus vannamei 6689 Arthropoda Arthropoda 57.8 1.53e-7   NR XP_069986747.1 6689 g43494 i0 35.4 1.26022304832714 113 44 93.7 3 6 257 87 199 XP_069986747.1 uncharacterized protein [Penaeus vannamei] diamond 339 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
30025179 30025179 PRJNA939369_S_NODE_56871_length_250_cov_0.870056_g56454_i0 PRJNA939369 56871 250 0.870056 2.17514 Maniola hyperantus 2795564 Arthropoda Arthropoda 43.9 0.0152   NR XP_069362377.1 2795564 g56454 i0 44.7 0.456 38 21 45.6 0 187 74 241 278 XP_069362377.1 transmembrane protein 53-like [Maniola hyperantus] diamond 114 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Maniola Maniola hyperantus
30372957 30372957 PRJNA939369_S_NODE_58712_length_249_cov_0.965909_g58295_i0 PRJNA939369 58712 249 0.965909 2.40511341 Schistocerca piceifrons 274613 Arthropoda Arthropoda 52.8 3.09e-6   NR XP_047113812.1 274613 g58295 i0 46.9 0.975903614457831 81 35 88 3 21 239 1 81 XP_047113812.1 uncharacterized protein LOC124791394 [Schistocerca piceifrons] diamond 243 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca piceifrons
30783294 30783294 PRJNA939369_S_NODE_2214_length_748_cov_2.278519_g1835_i0 PRJNA939369 2214 748 2.278519 17.04332212 Timema douglasi 61478 Arthropoda Arthropoda 142 4.6099999999999995e-35   NR CAD7202817.1 61478 g1835 i0 69.5 5.05347593582888 105 32 42.1 0 736 422 431 535 CAD7202817.1 unnamed protein product [Timema douglasi] diamond 3780 142 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema douglasi
31106142 31106142 PRJNA939369_S_NODE_3015_length_658_cov_6.095726_g2617_i0 PRJNA939369 3015 658 6.095726 40.10987708 root 1 Root_unresolved Root_unresolved 53.1 3.74e-4   NR GBN61280.1 182803 g2617 i0 50.9 2.22492401215805 53 26 24.2 0 537 379 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
32364667 32364667 PRJNA939369_S_NODE_69779_length_244_cov_0.900585_g69362_i0 PRJNA939369 69779 244 0.900585 2.1974274 Schistocerca serialis cubense 2023355 Arthropoda Arthropoda 54.7 2.35e-6   NR XP_049941490.1 2023355 g69362 i0 49.4 0.995901639344262 81 36 99.6 2 244 2 697 772 XP_049941490.1 uncharacterized transmembrane protein DDB_G0289901-like [Schistocerca serialis cubense] diamond 243 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca serialis
32711791 32711791 PRJNA939369_S_NODE_28260_length_306_cov_0.991416_g27843_i0 PRJNA939369 28260 306 0.991416 3.03373296 Schistocerca gregaria 7010 Arthropoda Arthropoda 72.8 2.21e-12   NR XP_049862025.1 7010 g27843 i0 62.2 0.725490196078431 74 26 70.6 1 91 306 122 195 XP_049862025.1 elastin-like [Schistocerca gregaria] diamond 222 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
32844748 32844748 PRJNA939369_S_NODE_30360_length_300_cov_0.973568_g29943_i0 PRJNA939369 30360 300 0.973568 2.920704 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.6 0.00275   NR XP_053612251.1 58824 g29943 i0 27 1.94 89 65 89 0 298 32 129 217 XP_053612251.1 TLC domain-containing protein 5-like isoform X2 [Plodia interpunctella] diamond 582 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pyralidae Plodia Plodia interpunctella

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