RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJEB81171" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 30 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB81171 · 30 ✖

analysis 1

  • diamond · 30 ✖
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
9066613 9066613 PRJEB81171_P_NODE_1088_length_625_cov_2.987319_g966_i0 PRJEB81171 1088 625 2.987319 18.67074375 Stegodyphus mimosarum 407821 Arthropoda Arthropoda 233 6.14e-75   NR KFM82963.1 407821 g966 i0 69.8 19.608 162 49 77.8 0 573 88 1 162 KFM82963.1 60S ribosomal protein L12, partial [Stegodyphus mimosarum] diamond 12255 233 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus mimosarum
10342360 10342360 PRJEB81171_P_NODE_2429_length_426_cov_2.750708_g2302_i0 PRJEB81171 2429 426 2.750708 11.71801608 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 195 4.4e-60   NR KAG8290268.1 197043 g2302 i0 70.9 15.9154929577465 141 41 99.3 0 2 424 47 187 KAG8290268.1 hypothetical protein J6590_086369 [Homalodisca vitripennis] diamond 6780 196 0.994897959183674 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
11617878 11617878 PRJEB81171_P_NODE_1670_length_510_cov_5.636156_g1547_i0 PRJEB81171 1670 510 5.636156 28.7443956 Pseudodiaptomus poplesia 213370 Arthropoda Arthropoda 143 2.34e-40   NR ALS04589.1 213370 g1547 i0 51.8 3.25882352941176 137 66 80.6 0 453 43 1 137 ALS04589.1 40S ribosomal protein S12 [Pseudodiaptomus poplesia] diamond 1662 143 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Pseudodiaptomidae Pseudodiaptomus Pseudodiaptomus poplesia
19264856 19264856 PRJEB81171_P_NODE_1036_length_642_cov_6.210896_g915_i0 PRJEB81171 1036 642 6.210896 39.87395232 Arthropoda 6656 Arthropoda Arthropoda 235 3.55e-75   NR XP_062716849.1 7160 g915 i0 65.1 9.22429906542056 195 63 88.8 1 641 72 10 204 XP_062716849.1 small ribosomal subunit protein eS8-like [Aedes albopictus] diamond 5922 237 0.991561181434599 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
19264920 19264920 PRJEB81171_P_NODE_4136_length_326_cov_0.924901_g4009_i0 PRJEB81171 4136 326 0.924901 3.01517726 Opisthokonta 33154 Arthropoda Arthropoda 100 1.22e-24   NR XP_037799029.1 6687 g4009 i0 57 4.4079754601227 79 34 72.7 0 242 6 16 94 XP_037799029.1 cytochrome b5-like [Penaeus monodon] diamond 1437 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
23949083 23949083 PRJEB81171_P_NODE_1019_length_646_cov_2.635253_g899_i0 PRJEB81171 1019 646 2.635253 17.02373438 Lutzomyia longipalpis 7200 Arthropoda Arthropoda 155 1.78e-43   NR XP_055693994.1 7200 g899 i0 41.4 0.975232198142415 210 120 96.1 1 621 1 1 210 XP_055693994.1 probable elongation factor 1-beta [Lutzomyia longipalpis] diamond 630 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Lutzomyia Lutzomyia longipalpis
26844621 26844621 PRJEB81171_P_NODE_8721_length_248_cov_0.891429_g8594_i0 PRJEB81171 8721 248 0.891429 2.21074392 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 44.7 0.00843   NR KAF0298551.1 1232801 g8594 i0 28.6 1.86290322580645 77 54 93.1 1 243 13 815 890 KAF0298551.1 Protein diaphanous [Amphibalanus amphitrite] diamond 462 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
26900490 26900490 PRJEB81171_P_NODE_4061_length_329_cov_0.882812_g3934_i0 PRJEB81171 4061 329 0.882812 2.90445148 Metazoa 33208 Arthropoda Arthropoda 82.8 5.46e-16   NR KAF7280281.1 354439 g3934 i0 46.1 1.40425531914894 76 41 69.3 0 95 322 7 82 KAF7280281.1 hypothetical protein GWI33_006193 [Rhynchophorus ferrugineus] diamond 462 83.6 0.990430622009569 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Rhynchophorus Rhynchophorus ferrugineus
27065766 27065766 PRJEB81171_P_NODE_4242_length_322_cov_1.847390_g4115_i0 PRJEB81171 4242 322 1.84739 5.9485958 Folsomia candida 158441 Arthropoda Arthropoda 92.8 1.01e-20   NR OXA45890.1 158441 g4115 i0 57.1 1.96583850931677 70 27 62.4 1 282 82 23 92 OXA45890.1 Cytochrome c oxidase subunit 6B2 [Folsomia candida] diamond 633 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
27255445 27255445 PRJEB81171_P_NODE_9183_length_246_cov_0.878613_g9056_i0 PRJEB81171 9183 246 0.878613 2.16138798 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 43.9 0.0141   NR KAF0308451.1 1232801 g9056 i0 35.8 0.646341463414634 53 32 62.2 1 62 214 122 174 KAF0308451.1 hypothetical protein FJT64_020339 [Amphibalanus amphitrite] diamond 159 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
27382041 27382041 PRJEB81171_P_NODE_8483_length_249_cov_0.886364_g8356_i0 PRJEB81171 8483 249 0.886364 2.20704636 Brassicogethes aeneus 1431903 Arthropoda Arthropoda 53.5 6.46e-6   NR CAH0549306.1 1431903 g8356 i0 43.8 0.963855421686747 80 45 96.4 0 245 6 3459 3538 CAH0549306.1 unnamed protein product [Brassicogethes aeneus] diamond 240 53.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Nitidulidae Brassicogethes Brassicogethes aeneus
27698069 27698069 PRJEB81171_P_NODE_7184_length_260_cov_1.310160_g7057_i0 PRJEB81171 7184 260 1.31016 3.406416 Odontomachus brunneus 486640 Arthropoda Arthropoda 44.3 0.0128   NR XP_032663472.1 486640 g7057 i0 25.9 0.934615384615385 81 58 92.3 2 250 11 219 298 XP_032663472.1 DNA-directed RNA polymerase III subunit RPC5-like [Odontomachus brunneus] diamond 243 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Odontomachus Odontomachus brunneus
27887051 27887051 PRJEB81171_P_NODE_5945_length_280_cov_1.125604_g5818_i0 PRJEB81171 5945 280 1.125604 3.1516912 Schistocerca gregaria 7010 Arthropoda Arthropoda 88.2 6.17e-18   NR XP_049848216.1 7010 g5818 i0 52.2 0.985714285714286 92 40 95.4 2 273 7 318 408 XP_049848216.1 uncharacterized protein LOC126313304 [Schistocerca gregaria] diamond 276 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
28132574 28132574 PRJEB81171_P_NODE_7845_length_252_cov_0.871508_g7718_i0 PRJEB81171 7845 252 0.871508 2.19620016 Metazoa 33208 Arthropoda Arthropoda 101 1.8299999999999994e-23   NR XP_021918782.1 136037 g7718 i0 51.2 3.88095238095238 82 40 97.6 0 251 6 277 358 XP_021918782.1 gamma-glutamyl hydrolase-like [Zootermopsis nevadensis] diamond 978 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
28202658 28202658 PRJEB81171_P_NODE_4266_length_322_cov_0.939759_g4139_i0 PRJEB81171 4266 322 0.939759 3.02602398 Aedes albopictus 7160 Arthropoda Arthropoda 114 3.25e-29   NR XP_062716849.1 7160 g4139 i0 60 1.86335403726708 100 35 88.5 1 321 37 105 204 XP_062716849.1 small ribosomal subunit protein eS8-like [Aedes albopictus] diamond 600 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes albopictus
28543124 28543124 PRJEB81171_P_NODE_5367_length_289_cov_1.541667_g5240_i0 PRJEB81171 5367 289 1.541667 4.45541763 Metazoa 33208 Arthropoda Arthropoda 77 6.05e-14   NR RZF42063.1 195883 g5240 i0 42.4 4.16262975778547 85 44 83 1 240 1 10 94 RZF42063.1 hypothetical protein LSTR_LSTR006656 [Laodelphax striatellus] diamond 1203 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Laodelphax Laodelphax striatellus
28921642 28921642 PRJEB81171_P_NODE_8668_length_248_cov_0.891429_g8541_i0 PRJEB81171 8668 248 0.891429 2.21074392 Opisthokonta 33154 Arthropoda Arthropoda 114 2.5500000000000003e-27   NR XP_055940205.1 94029 g8541 i0 70.5 16.1612903225806 78 23 94.4 0 247 14 442 519 XP_055940205.1 elongation factor G, mitochondrial-like isoform X2 [Argiope bruennichi] diamond 4008 115 0.991304347826087 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
29339646 29339646 PRJEB81171_P_NODE_6169_length_276_cov_1.536946_g6042_i0 PRJEB81171 6169 276 1.536946 4.24197096 Gryllus longicercus 2509291 Arthropoda Arthropoda 90.9 3.44e-19   NR KAK7866132.1 2509291 g6042 i0 59.3 3.82608695652174 91 24 87 2 241 2 5 93 KAK7866132.1 hypothetical protein R5R35_004781 [Gryllus longicercus] diamond 1056 90.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus longicercus
29686529 29686529 PRJEB81171_P_NODE_2510_length_419_cov_1.167630_g2383_i0 PRJEB81171 2510 419 1.16763 4.8923697 Dufourea novaeangliae 178035 Arthropoda Arthropoda 65.1 1.68e-10   NR XP_015428775.1 178035 g2383 i0 48.9 3.04295942720764 88 39 58.7 3 112 357 15 102 XP_015428775.1 PREDICTED: eukaryotic translation initiation factor 4E-binding protein 2 [Dufourea novaeangliae] diamond 1275 65.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Dufourea Dufourea novaeangliae
30034376 30034376 PRJEB81171_P_NODE_9331_length_245_cov_0.906977_g9204_i0 PRJEB81171 9331 245 0.906977 2.22209365 Eriocheir sinensis 95602 Arthropoda Arthropoda 56.6 3.8e-7   NR XP_050686757.1 95602 g9204 i0 55.3 0.575510204081633 47 16 57.6 1 103 243 4 45 XP_050686757.1 aspartate dehydrogenase domain-containing protein-like [Eriocheir sinensis] diamond 141 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Varunidae Eriocheir Eriocheir sinensis
30160413 30160413 PRJEB81171_P_NODE_1492_length_541_cov_2.858974_g1369_i0 PRJEB81171 1492 541 2.858974 15.46704934 Halotydeus destructor 2874060 Arthropoda Arthropoda 77 9.95e-13   NR KAI1292274.1 2874060 g1369 i0 52.1 0.99815157116451 71 31 37.7 2 384 181 257 327 KAI1292274.1 Next to BRCA1 protein [Halotydeus destructor] diamond 540 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30658877 30658877 PRJEB81171_P_NODE_7953_length_252_cov_0.871508_g7826_i0 PRJEB81171 7953 252 0.871508 2.19620016 Arthropoda 6656 Arthropoda Arthropoda 68.2 4.68e-11   NR CAL4129612.1 48144 g7826 i0 48.7 3.89285714285714 78 40 92.9 0 252 19 426 503 CAL4129612.1 unnamed protein product, partial [Meganyctiphanes norvegica] diamond 981 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
31108345 31108345 PRJEB81171_P_NODE_10035_length_242_cov_0.923077_g9908_i0 PRJEB81171 10035 242 0.923077 2.23384634 Cyphomyrmex costatus 456900 Arthropoda Arthropoda 90.5 5.68e-19   NR XP_018394416.1 456900 g9908 i0 57 3.91735537190083 79 33 97.9 1 4 240 348 425 XP_018394416.1 PREDICTED: glycine--tRNA ligase [Cyphomyrmex costatus] diamond 948 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Cyphomyrmex Cyphomyrmex costatus
31424659 31424659 PRJEB81171_P_NODE_7716_length_253_cov_0.866667_g7589_i0 PRJEB81171 7716 253 0.866667 2.19266751 Halotydeus destructor 2874060 Arthropoda Arthropoda 86.3 7.31e-18   NR KAI1301246.1 2874060 g7589 i0 77.4 0.628458498023715 53 12 62.8 0 1 159 270 322 KAI1301246.1 ATP synthase subunit b, mitochondrial [Halotydeus destructor] diamond 159 86.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
31551476 31551476 PRJEB81171_P_NODE_3256_length_365_cov_2.517123_g3129_i0 PRJEB81171 3256 365 2.5171230000000002 9.18749895 Schistocerca gregaria 7010 Arthropoda Arthropoda 49.3 2.77e-4   NR XP_049849111.1 7010 g3129 i0 52.7 0.452054794520548 55 25 45.2 1 22 186 1 54 XP_049849111.1 uncharacterized protein LOC126317486 isoform X2 [Schistocerca gregaria] diamond 165 49.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
31962392 31962392 PRJEB81171_P_NODE_7738_length_253_cov_0.866667_g7611_i0 PRJEB81171 7738 253 0.866667 2.19266751 Halyomorpha halys 286706 Arthropoda Arthropoda 77.8 1.58e-14   NR XP_014275971.1 286706 g7611 i0 51.4 0.877470355731225 74 36 87.7 0 248 27 184 257 XP_014275971.1 pyruvate dehydrogenase (acetyl-transferring) kinase, mitochondrial isoform X1 [Halyomorpha halys] diamond 222 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pentatomidae Halyomorpha Halyomorpha halys
31994084 31994084 PRJEB81171_P_NODE_8518_length_249_cov_0.886364_g8391_i0 PRJEB81171 8518 249 0.886364 2.20704636 Meganyctiphanes norvegica 48144 Arthropoda Arthropoda 43.5 0.0215   NR CAL4169844.1 48144 g8391 i0 40.9 1.6144578313253 66 34 79.5 1 208 11 241 301 CAL4169844.1 unnamed protein product [Meganyctiphanes norvegica] diamond 402 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Euphausiacea Euphausiidae Meganyctiphanes Meganyctiphanes norvegica
32088975 32088975 PRJEB81171_P_NODE_10198_length_231_cov_2.373418_g10071_i0 PRJEB81171 10198 231 2.373418 5.48259558 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 151 2.8399999999999998e-42   NR KAG5680354.1 319348 g10071 i0 97.4 0.987012987012987 76 2 98.7 0 229 2 301 376 KAG5680354.1 hypothetical protein PVAND_009864 [Polypedilum vanderplanki] diamond 228 151 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
32588065 32588065 PRJEB81171_P_NODE_8699_length_248_cov_0.891429_g8572_i0 PRJEB81171 8699 248 0.891429 2.21074392 Coleoptera 7041 Arthropoda Arthropoda 46.6 0.0018   NR XP_023018159.1 7539 g8572 i0 36.6 4.5 71 40 81 2 205 5 299 368 XP_023018159.1 spectrin beta chain, non-erythrocytic 1 isoform X1 [Leptinotarsa decemlineata] diamond 1116 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
32682072 32682072 PRJEB81171_P_NODE_9740_length_243_cov_0.917647_g9613_i0 PRJEB81171 9740 243 0.917647 2.22988221 Calanoida 6833 Arthropoda Arthropoda 100 2.39e-25   NR ALS04085.1 335913 g9613 i0 68.1 1.77777777777778 72 23 88.9 0 217 2 2 73 ALS04085.1 60S acidic ribosomal protein P1 [Acartia pacifica] diamond 432 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Acartiidae Acartia Acartia pacifica

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