RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA513467" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA513467 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
10690457 10690457 PRJNA513467_S_NODE_4429_length_189_cov_1.105263_g4406_i0 PRJNA513467 4429 189 1.105263 2.08894707 Chironomus tentans 7153 Arthropoda Arthropoda 114 7.79e-28   NR AAN85117.1 7153 g4406 i0 93.3 1.9047619047619 60 4 95.2 0 10 189 298 357 AAN85117.1 HSP70 [Chironomus tentans] diamond 360 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tentans
27330149 27330149 PRJNA513467_S_NODE_2203_length_243_cov_1.466019_g2180_i0 PRJNA513467 2203 243 1.466019 3.56242617 Polyplax serrata 468196 Arthropoda Arthropoda 94.7 1.1e-20   NR KAK6633287.1 468196 g2180 i0 63.6 1.91358024691358 77 23 95.1 1 231 1 90 161 KAK6633287.1 hypothetical protein RUM44_003888 [Polyplax serrata] diamond 465 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27330150 27330150 PRJNA513467_S_NODE_7103_length_159_cov_1.918033_g7080_i0 PRJNA513467 7103 159 1.918033 3.04967247 Polyplax serrata 468196 Arthropoda Arthropoda 88.6 8.25e-19   NR KAK6637229.1 468196 g7080 i0 88.5 1.9622641509434 52 6 98.1 0 3 158 837 888 KAK6637229.1 hypothetical protein RUM44_007643 [Polyplax serrata] diamond 312 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
28624821 28624821 PRJNA513467_S_NODE_6927_length_161_cov_1.258065_g6904_i0 PRJNA513467 6927 161 1.258065 2.02548465 Pediculus humanus corporis 121224 Arthropoda Arthropoda 98.6 2.4e-25   NR XP_002429279.1 121224 g6904 i0 86.8 0.987577639751553 53 7 98.8 0 159 1 2 54 XP_002429279.1 uncharacterized protein Phum_PHUM426160 [Pediculus humanus corporis] diamond 159 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
28656301 28656301 PRJNA513467_S_NODE_8407_length_150_cov_1.805310_g8384_i0 PRJNA513467 8407 150 1.80531 2.707965 Cyamophila willieti 2604842 Arthropoda Arthropoda 46.6 3.19e-5   NR KAL1463159.1 2604842 g8384 i0 81.5 0.54 27 5 54 0 145 65 20 46 KAL1463159.1 hypothetical protein WDU94_014940, partial [Cyamophila willieti] diamond 81 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
29887744 29887744 PRJNA513467_S_NODE_3291_length_209_cov_2.267442_g3268_i0 PRJNA513467 3291 209 2.267442 4.73895378 Trichogramma kaykai 54128 Arthropoda Arthropoda 77 2.52e-15   NR KAL3398246.1 54128 g3268 i0 73.7 1.63636363636364 57 14 80.4 1 168 1 111 167 KAL3398246.1 hypothetical protein TKK_008446 [Trichogramma kaykai] diamond 342 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma kaykai
30456676 30456676 PRJNA513467_S_NODE_1253_length_301_cov_3.276515_g1230_i0 PRJNA513467 1253 301 3.276515 9.86231015 Pediculus humanus corporis 121224 Arthropoda Arthropoda 112 2.56e-26   NR XP_002426469.1 121224 g1230 i0 87.9 0.578073089700997 58 7 57.8 0 50 223 778 835 XP_002426469.1 uncharacterized protein Phum_PHUM255010 [Pediculus humanus corporis] diamond 174 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
30740605 30740605 PRJNA513467_S_NODE_6314_length_166_cov_2.418605_g6291_i0 PRJNA513467 6314 166 2.418605 4.0148843 Anastrepha obliqua 95512 Arthropoda Arthropoda 41.6 0.0334   NR XP_054746255.1 95512 g6291 i0 40.6 0.578313253012048 32 19 57.8 0 149 54 77 108 XP_054746255.1 uncharacterized protein K02A2.6-like [Anastrepha obliqua] diamond 96 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Anastrepha Anastrepha obliqua
31735906 31735906 PRJNA513467_S_NODE_1717_length_268_cov_2.194805_g1694_i0 PRJNA513467 1717 268 2.194805 5.8820774 Arthropoda 6656 Arthropoda Arthropoda 67.8 1.23e-11   NR KAK8371844.1 85552 g1694 i0 42.9 5.08208955223881 91 49 98.5 2 5 268 1 91 KAK8371844.1 hypothetical protein O3P69_019821 [Scylla paramamosain] diamond 1362 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31847096 31847096 PRJNA513467_S_NODE_6037_length_169_cov_1.386364_g6014_i0 PRJNA513467 6037 169 1.386364 2.34295516 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 63.9 2.98e-11   NR KAG5680192.1 319348 g6014 i0 100 0.568047337278107 32 0 56.8 0 169 74 90 121 KAG5680192.1 putative 30S ribosomal protein S10 [Polypedilum vanderplanki] diamond 96 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
32480188 32480188 PRJNA513467_S_NODE_1819_length_261_cov_2.714286_g1796_i0 PRJNA513467 1819 261 2.714286 7.08428646 Aphis glycines 307491 Arthropoda Arthropoda 111 2.77e-26   NR KAE9523856.1 307491 g1796 i0 90 0.689655172413793 60 6 69 0 259 80 1236 1295 KAE9523856.1 hypothetical protein AGLY_015744 [Aphis glycines] diamond 180 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines

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