RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1120586" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1120586 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
10479436 10479436 PRJNA1120586_P_NODE_16809_length_317_cov_1.741935_g16618_i0 PRJNA1120586 16809 317 1.741935 5.52193395 Plutella xylostella 51655 Arthropoda Arthropoda 207 2.39e-64   NR KAG7299483.1 51655 g16618 i0 100 21.8611987381703 105 0 99.4 0 1 315 30 134 KAG7299483.1 hypothetical protein JYU34_016444 [Plutella xylostella] diamond 6930 207 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
10479689 10479689 PRJNA1120586_P_NODE_3389_length_584_cov_2.473786_g3202_i0 PRJNA1120586 3389 584 2.473786 14.44691024 Plutella xylostella 51655 Arthropoda Arthropoda 139 1.88e-39   NR KAG7299134.1 51655 g3202 i0 100 0.333904109589041 65 0 33.4 0 57 251 1 65 KAG7299134.1 hypothetical protein JYU34_017650 [Plutella xylostella] diamond 195 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
15578745 15578745 PRJNA1120586_P_NODE_24973_length_277_cov_1.677885_g24782_i0 PRJNA1120586 24973 277 1.677885 4.64774145 Plutella xylostella 51655 Arthropoda Arthropoda 175 1.77e-48   NR KAG7298180.1 51655 g24782 i0 93.4 0.985559566787004 91 6 98.6 0 276 4 883 973 KAG7298180.1 hypothetical protein JYU34_018964 [Plutella xylostella] diamond 273 175 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
21952497 21952497 PRJNA1120586_P_NODE_10298_length_378_cov_25.391586_g10107_i0 PRJNA1120586 10298 378 25.391586 95.98019508 Plutella xylostella 51655 Arthropoda Arthropoda 135 2.18e-38   NR CAG9102783.1 51655 g10107 i0 98.6 0.587301587301587 74 1 58.7 0 64 285 1 74 CAG9102783.1 unnamed protein product [Plutella xylostella] diamond 222 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
23228067 23228067 PRJNA1120586_P_NODE_16059_length_322_cov_1.948617_g15868_i0 PRJNA1120586 16059 322 1.948617 6.27454674 Plutella xylostella 51655 Arthropoda Arthropoda 223 2.3399999999999998e-68   NR CAG9127617.1 51655 g15868 i0 99.1 0.987577639751553 106 1 98.8 0 3 320 317 422 CAG9127617.1 unnamed protein product [Plutella xylostella] diamond 318 223 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
23228470 23228470 PRJNA1120586_P_NODE_39759_length_235_cov_0.951807_g39568_i0 PRJNA1120586 39759 235 0.951807 2.23674645 Plutella xylostella 51655 Arthropoda Arthropoda 158 2.56e-44   NR CAG9111997.1 51655 g39568 i0 94.9 33.8553191489362 78 4 99.6 0 2 235 128 205 CAG9111997.1 unnamed protein product [Plutella xylostella] diamond 7956 158 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
24502403 24502403 PRJNA1120586_P_NODE_6260_length_458_cov_1.380463_g6070_i0 PRJNA1120586 6260 458 1.380463 6.32252054 Plutella xylostella 51655 Arthropoda Arthropoda 168 1.34e-50   NR KAG7294974.1 51655 g6070 i0 92.1 0.58296943231441 89 7 58.3 0 147 413 57 145 KAG7294974.1 hypothetical protein JYU34_022630 [Plutella xylostella] diamond 267 168 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
27891210 27891210 PRJNA1120586_P_NODE_17045_length_315_cov_5.581301_g16854_i0 PRJNA1120586 17045 315 5.581301 17.58109815 Papilio machaon 76193 Arthropoda Arthropoda 78.2 1.29e-16   NR KPJ13297.1 76193 g16854 i0 75 0.571428571428571 60 15 57.1 0 180 1 4 63 KPJ13297.1 hypothetical protein RR48_06795 [Papilio machaon] diamond 180 78.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio machaon
27922882 27922882 PRJNA1120586_P_NODE_33765_length_250_cov_1.243094_g33574_i0 PRJNA1120586 33765 250 1.243094 3.107735 Plutella xylostella 51655 Arthropoda Arthropoda 159 3.18e-45   NR CAG9135736.1 51655 g33574 i0 98.8 0.984 82 1 98.4 0 3 248 231 312 CAG9135736.1 unnamed protein product [Plutella xylostella] diamond 246 159 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
27986057 27986057 PRJNA1120586_P_NODE_46745_length_230_cov_0.894410_g46554_i0 PRJNA1120586 46745 230 0.89441 2.057143 Plutella xylostella 51655 Arthropoda Arthropoda 45.8 0.00257   NR CAG9129930.1 51655 g46554 i0 60.5 0.495652173913044 38 15 49.6 0 202 89 557 594 CAG9129930.1 unnamed protein product [Plutella xylostella] diamond 114 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
28080698 28080698 PRJNA1120586_P_NODE_1265_length_885_cov_4.174020_g1119_i0 PRJNA1120586 1265 885 4.17402 36.940077 Plutella xylostella 51655 Arthropoda Arthropoda 541 7.039999999999998e-193   NR CAG9102141.1 51655 g1119 i0 99.3 0.905084745762712 267 2 90.5 0 885 85 64 330 CAG9102141.1 unnamed protein product [Plutella xylostella] diamond 801 541 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
28080702 28080702 PRJNA1120586_P_NODE_4625_length_515_cov_2.246637_g4435_i0 PRJNA1120586 4625 515 2.246637 11.57018055 Plutella xylostella 51655 Arthropoda Arthropoda 125 6.41e-34   NR CAG9094774.1 51655 g4435 i0 100 0.757281553398058 65 0 37.9 0 432 238 34 98 CAG9094774.1 unnamed protein product [Plutella xylostella] diamond 390 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
28364788 28364788 PRJNA1120586_P_NODE_37686_length_240_cov_1.239766_g37495_i0 PRJNA1120586 37686 240 1.239766 2.9754384 Plutella xylostella 51655 Arthropoda Arthropoda 129 1.7199999999999998e-32   NR KAG7304767.1 51655 g37495 i0 95.4 0.8125 65 3 81.3 0 239 45 2412 2476 KAG7304767.1 hypothetical protein JYU34_010122 [Plutella xylostella] diamond 195 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
28396523 28396523 PRJNA1120586_P_NODE_18626_length_306_cov_7.379747_g18435_i0 PRJNA1120586 18626 306 7.379747 22.58202582 Plutella xylostella 51655 Arthropoda Arthropoda 136 7.9e-40   NR KAG7306593.1 51655 g18435 i0 100 0.676470588235294 69 0 67.6 0 217 11 1 69 KAG7306593.1 hypothetical protein JYU34_007964 [Plutella xylostella] diamond 207 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
28617724 28617724 PRJNA1120586_P_NODE_30967_length_258_cov_1.052910_g30776_i0 PRJNA1120586 30967 258 1.05291 2.7165078 Plutella xylostella 51655 Arthropoda Arthropoda 117 2.76e-29   NR CAG9135736.1 51655 g30776 i0 85.3 0.790697674418605 68 9 77.9 1 56 256 12 79 CAG9135736.1 unnamed protein product [Plutella xylostella] diamond 204 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
29943862 29943862 PRJNA1120586_P_NODE_31331_length_256_cov_6.454545_g31140_i0 PRJNA1120586 31331 256 6.454545 16.5236352 Plutella xylostella 51655 Arthropoda Arthropoda 115 1.44e-31   NR KAG7310045.1 51655 g31140 i0 100 0.69140625 59 0 69.1 0 177 1 1 59 KAG7310045.1 hypothetical protein JYU34_004577 [Plutella xylostella] diamond 177 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
30638668 30638668 PRJNA1120586_P_NODE_50013_length_228_cov_0.905660_g49822_i0 PRJNA1120586 50013 228 0.90566 2.0649048 Plutella xylostella 51655 Arthropoda Arthropoda 133 3.61e-34   NR CAG9129171.1 51655 g49822 i0 97 0.881578947368421 67 2 88.2 0 1 201 612 678 CAG9129171.1 unnamed protein product [Plutella xylostella] diamond 201 133 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
30796718 30796718 PRJNA1120586_P_NODE_46494_length_230_cov_0.894410_g46303_i0 PRJNA1120586 46494 230 0.89441 2.057143 Bombyx mori 7091 Arthropoda Arthropoda 42.7 0.0321   NR NP_001036981.1 7091 g46303 i0 32.4 0.88695652173913 68 33 79.6 3 212 30 877 938 NP_001036981.1 A disintegrin and metalloproteinase with thrombospondin motifs 1 precursor [Bombyx mori] diamond 204 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
30849225 30849225 PRJNA1120586_P_NODE_14134_length_337_cov_0.936567_g13943_i0 PRJNA1120586 14134 337 0.936567 3.15623079 Maniola 111919 Arthropoda Arthropoda 45.4 0.012   NR XP_045763023.1 191418 g13943 i0 38.5 1.38872403560831 52 31 45.4 1 168 16 385 436 XP_045763023.1 palmitoyltransferase Hip14 isoform X2 [Maniola jurtina] diamond 468 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Maniola Maniola jurtina
31101874 31101874 PRJNA1120586_P_NODE_17755_length_311_cov_8.508264_g17564_i0 PRJNA1120586 17755 311 8.508264 26.46070104 Lepidoptera 7088 Arthropoda Arthropoda 82.4 8.54e-18   NR KAH9645800.1 7107 g17564 i0 73.7 4.35048231511254 57 12 55 1 57 227 61 114 KAH9645800.1 hypothetical protein HF086_012527 [Spodoptera exigua] diamond 1353 82.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera exigua
31239026 31239026 PRJNA1120586_P_NODE_27115_length_270_cov_0.865672_g26924_i0 PRJNA1120586 27115 270 0.865672 2.3373144 Plutella xylostella 51655 Arthropoda Arthropoda 98.6 1.5099999999999998e-23   NR KAG7302306.1 51655 g26924 i0 98 0.544444444444444 49 1 54.4 0 1 147 138 186 KAG7302306.1 hypothetical protein JYU34_013802 [Plutella xylostella] diamond 147 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
31871685 31871685 PRJNA1120586_P_NODE_48097_length_229_cov_0.900000_g47906_i0 PRJNA1120586 48097 229 0.9 2.061 Plutella xylostella 51655 Arthropoda Arthropoda 73.9 3e-13   NR CAG9120660.1 51655 g47906 i0 85.7 3.85152838427948 42 6 55 0 227 102 257 298 CAG9120660.1 unnamed protein product [Plutella xylostella] diamond 882 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
32093199 32093199 PRJNA1120586_P_NODE_36718_length_242_cov_1.664740_g36527_i0 PRJNA1120586 36718 242 1.66474 4.0286708 Plutella xylostella 51655 Arthropoda Arthropoda 88.6 4.230000000000001e-21   NR KAG7306939.1 51655 g36527 i0 100 0.45867768595041303 37 0 45.9 0 1 111 36 72 KAG7306939.1 hypothetical protein JYU34_007062 [Plutella xylostella] diamond 111 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
32188228 32188228 PRJNA1120586_P_NODE_42978_length_233_cov_0.878049_g42787_i0 PRJNA1120586 42978 233 0.878049 2.04585417 Plutella xylostella 51655 Arthropoda Arthropoda 48.1 4.07e-4   NR CAG9104742.1 51655 g42787 i0 95.8 0.618025751072961 24 1 30.9 0 2 73 589 612 CAG9104742.1 unnamed protein product [Plutella xylostella] diamond 144 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
32304263 32304263 PRJNA1120586_P_NODE_28939_length_264_cov_1.235897_g28748_i0 PRJNA1120586 28939 264 1.235897 3.26276808 Polistes 7456 Arthropoda Arthropoda 43.1 0.0364   NR KAI4485865.1 27506 g28748 i0 35 3.40909090909091 60 37 65.9 1 203 30 773 832 KAI4485865.1 hypothetical protein M0804_006354 [Polistes exclamans] diamond 900 43.5 0.990804597701149 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes exclamans
32315067 32315067 PRJNA1120586_P_NODE_44359_length_232_cov_0.883436_g44168_i0 PRJNA1120586 44359 232 0.883436 2.04957152 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 88.2 1.35e-18   NR XP_054279311.1 74068 g44168 i0 53.2 0.995689655172414 77 35 99.6 1 231 1 87 162 XP_054279311.1 protein XRP2-like [Macrosteles quadrilineatus] diamond 231 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
32599417 32599417 PRJNA1120586_P_NODE_37780_length_239_cov_2.770588_g37589_i0 PRJNA1120586 37780 239 2.770588 6.62170532 Dendrolimus kikuchii 765133 Arthropoda Arthropoda 97.1 5.2099999999999996e-24   NR KAJ0170223.1 765133 g37589 i0 90.9 2.0836820083682 55 5 69 0 40 204 56 110 KAJ0170223.1 hypothetical protein K1T71_014151 [Dendrolimus kikuchii] diamond 498 97.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Dendrolimus Dendrolimus kikuchii
32819734 32819734 PRJNA1120586_P_NODE_33440_length_251_cov_1.186813_g33249_i0 PRJNA1120586 33440 251 1.186813 2.97890063 Plutella xylostella 51655 Arthropoda Arthropoda 142 2.2e-37   NR KAG7306514.1 51655 g33249 i0 92.8 0.99203187250996006 83 6 99.2 0 249 1 94 176 KAG7306514.1 hypothetical protein JYU34_009154 [Plutella xylostella] diamond 249 142 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella

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