RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1242190" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1242190 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
3601601 3601601 PRJNA1242190_S_NODE_283_length_744_cov_2.268256_g278_i0 PRJNA1242190 283 744 2.268256 16.87582464 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 260 3.49e-83   NR XP_012174989.1 30195 g278 i0 60.8 101.310483870968 212 80 85.5 1 1 636 60 268 XP_012174989.1 40S ribosomal protein S2 isoform X1 [Bombus terrestris] diamond 75375 261 0.996168582375479 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus terrestris
11829550 11829550 PRJNA1242190_S_NODE_7090_length_317_cov_2.323770_g7083_i0 PRJNA1242190 7090 317 2.32377 7.3663509 Cloeon dipterum 197152 Arthropoda Arthropoda 139 1.24e-39   NR XP_065346663.1 197152 g7083 i0 74.2 15.0851735015773 89 23 84.2 0 317 51 61 149 XP_065346663.1 nucleoside diphosphate kinase-like [Cloeon dipterum] diamond 4782 140 0.992857142857143 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
27471037 27471037 PRJNA1242190_S_NODE_2543_length_471_cov_4.035176_g2536_i0 PRJNA1242190 2543 471 4.035176 19.00567896 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99 2.1799999999999999e-23   NR XP_054710691.1 327109 g2536 i0 45.2 2.60509554140127 135 58 86 1 18 422 5 123 XP_054710691.1 60S ribosomal protein L35-like [Uloborus diversus] diamond 1227 100 0.99 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Uloboridae Uloborus Uloborus diversus
27894734 27894734 PRJNA1242190_S_NODE_9645_length_277_cov_3.681373_g9638_i0 PRJNA1242190 9645 277 3.681373 10.19740321 Artemia franciscana 6661 Arthropoda Arthropoda 97.4 3.47e-21   NR KAK2725708.1 6661 g9638 i0 48.9 2.85920577617329 94 46 99.6 1 2 277 848 941 KAK2725708.1 hypothetical protein QYM36_000264 [Artemia franciscana] diamond 792 97.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28134076 28134076 PRJNA1242190_S_NODE_10605_length_266_cov_1.056995_g10598_i0 PRJNA1242190 10605 266 1.056995 2.8116067 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 6.19e-25   NR PSN44958.1 6973 g10598 i0 55.6 11.0864661654135 90 38 99.2 1 2 265 83 172 PSN44958.1 ADP/ATP translocase 1 [Blattella germanica] diamond 2949 104 0.990384615384615 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
28923165 28923165 PRJNA1242190_S_NODE_2728_length_460_cov_4.782946_g2721_i0 PRJNA1242190 2728 460 4.782946 22.0015516 Metazoa 33208 Arthropoda Arthropoda 108 5.33e-27   NR XP_059090465.1 6832 g2721 i0 47.1 2.39347826086957 121 58 78.9 2 446 84 24 138 XP_059090465.1 small ribosomal subunit protein eS12-like [Tigriopus californicus] diamond 1101 109 0.990825688073395 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
29649115 29649115 PRJNA1242190_S_NODE_2650_length_464_cov_4.455243_g2643_i0 PRJNA1242190 2650 464 4.455243 20.67232752 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 139 1.0099999999999999e-38   NR EFX61290.1 6669 g2643 i0 62.5 8.74784482758621 120 45 77.6 0 1 360 57 176 EFX61290.1 hypothetical protein DAPPUDRAFT_69961 [Daphnia pulex] diamond 4059 140 0.992857142857143 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
30263425 30263425 PRJNA1242190_S_NODE_12252_length_250_cov_1.661017_g12245_i0 PRJNA1242190 12252 250 1.661017 4.1525425 Papilio polytes 76194 Arthropoda Arthropoda 47.4 2.92e-4   NR BAM20515.1 76194 g12245 i0 100 0.24 20 0 24 0 1 60 115 134 BAM20515.1 ribosomal protein L10Ab [Papilio polytes] diamond 60 47.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Papilionidae Papilio Papilio polytes
30313388 30313388 PRJNA1242190_S_NODE_14232_length_200_cov_5.472441_g14225_i0 PRJNA1242190 14232 200 5.472441 10.944882 Arthropoda 6656 Arthropoda Arthropoda 65.9 1.5e-10   NR XP_026472217.1 7515 g14225 i0 56.5 11.16 62 22 90 3 11 190 271 329 XP_026472217.1 chromodomain-helicase-DNA-binding protein 1 isoform X2 [Ctenocephalides felis] diamond 2232 66.2 0.995468277945619 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
30484408 30484408 PRJNA1242190_S_NODE_2113_length_498_cov_4.929412_g2106_i0 PRJNA1242190 2113 498 4.929412 24.54847176 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 114 2.91e-28   NR ADD38186.1 72036 g2106 i0 42.7 0.789156626506024 131 75 78.9 0 498 106 59 189 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 393 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
30502432 30502432 PRJNA1242190_S_NODE_10373_length_268_cov_2.230769_g10366_i0 PRJNA1242190 10373 268 2.230769 5.97846092 root 1 Root_unresolved Root_unresolved 70.1 5.95e-13   NR XP_063708594.1 469753 g10366 i0 37.5 4.89179104477612 88 50 98.5 1 4 267 16 98 XP_063708594.1 small ribosomal subunit protein eS12 [Culicoides brevitarsis] diamond 1311 70.5 0.994326241134752 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
31748598 31748598 PRJNA1242190_S_NODE_2557_length_470_cov_3.987406_g2550_i0 PRJNA1242190 2557 470 3.987406 18.7408082 Idotea baltica 82763 Arthropoda Arthropoda 100 3.87e-24   NR MCL4168740.1 82763 g2550 i0 48.6 1.31489361702128 105 54 67 0 467 153 5 109 MCL4168740.1 hypothetical protein [Idotea baltica] diamond 618 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
32286897 32286897 PRJNA1242190_S_NODE_9799_length_275_cov_3.217822_g9792_i0 PRJNA1242190 9799 275 3.217822 8.8490105 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 54.3 2.88e-6   NR ADD38577.1 72036 g9792 i0 39.1 0.752727272727273 69 41 74.2 1 8 211 160 228 ADD38577.1 Glutathione S-transferase Mu 2 [Lepeophtheirus salmonis] diamond 207 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
32589528 32589528 PRJNA1242190_S_NODE_14059_length_228_cov_2.290323_g14052_i0 PRJNA1242190 14059 228 2.290323 5.22193644 Insecta 50557 Arthropoda Arthropoda 124 5.17e-31   NR XP_031352115.1 7054 g14052 i0 69.3 22.5263157894737 75 23 98.7 0 226 2 386 460 XP_031352115.1 probable protein phosphatase 2C 60 [Photinus pyralis] diamond 5136 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Photinus Photinus pyralis

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