RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1263632" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1263632 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
363801 363801 PRJNA1263632_P_NODE_8301_length_241_cov_1.833333_g8283_i0 PRJNA1263632 8301 241 1.833333 4.41833253 Metazoa 33208 Arthropoda Arthropoda 107 3.87e-26   NR XP_037897914.1 7396 g8283 i0 67.5 7.63070539419087 77 25 95.9 0 233 3 1 77 XP_037897914.1 60S ribosomal protein L5 [Glossina fuscipes] diamond 1839 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
1638446 1638446 PRJNA1263632_P_NODE_1502_length_488_cov_1.257831_g1484_i0 PRJNA1263632 1502 488 1.257831 6.13821528 root 1 Root_unresolved Root_unresolved 137 1.8199999999999999e-34   NR XP_063603433.1 29960 g1484 i0 45 21.1598360655738 169 79 98.4 4 481 2 237 400 XP_063603433.1 cathepsin F-like isoform X4 [Penaeus indicus] diamond 10326 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus indicus
2914468 2914468 PRJNA1263632_P_NODE_6403_length_251_cov_0.865169_g6385_i0 PRJNA1263632 6403 251 0.865169 2.17157419 Callosobruchus maculatus 64391 Arthropoda Arthropoda 75.9 7.31e-14   NR VEN43922.1 64391 g6385 i0 60 1.43426294820717 55 22 65.7 0 165 1 3 57 VEN43922.1 unnamed protein product [Callosobruchus maculatus] diamond 360 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Callosobruchus Callosobruchus maculatus
12532657 12532657 PRJNA1263632_P_NODE_3510_length_330_cov_1.852140_g3492_i0 PRJNA1263632 3510 330 1.85214 6.112062 Insecta 50557 Arthropoda Arthropoda 131 6.64e-33   NR XP_071454236.1 62018 g3492 i0 56.1 12.6636363636364 107 47 97.3 0 3 323 947 1053 XP_071454236.1 uncharacterized protein [Hetaerina americana] diamond 4179 131 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Calopterygidae Hetaerina Hetaerina americana
15081626 15081626 PRJNA1263632_P_NODE_8032_length_243_cov_0.905882_g8014_i0 PRJNA1263632 8032 243 0.905882 2.20129326 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 109 1.15e-26   NR KAF0291935.1 1232801 g8014 i0 64.1 2.80246913580247 78 27 96.3 1 239 6 148 224 KAF0291935.1 Cathepsin L [Amphibalanus amphitrite] diamond 681 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
20765179 20765179 PRJNA1263632_P_NODE_1357_length_514_cov_0.913832_g1339_i0 PRJNA1263632 1357 514 0.913832 4.69709648 Metazoa 33208 Arthropoda Arthropoda 249 8.240000000000001e-80   NR XP_059099471.1 6832 g1339 i0 72.6 3.92217898832685 168 46 98.1 0 9 512 9 176 XP_059099471.1 uncharacterized protein LOC131893451 [Tigriopus californicus] diamond 2016 250 0.996 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
20765246 20765246 PRJNA1263632_P_NODE_3497_length_331_cov_1.193798_g3479_i0 PRJNA1263632 3497 331 1.193798 3.95147138 Idotea baltica 82763 Arthropoda Arthropoda 191 3.22e-59   NR MCL4112850.1 82763 g3479 i0 78.9 0.987915407854985 109 23 98.8 0 3 329 81 189 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 327 191 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27091764 27091764 PRJNA1263632_P_NODE_7902_length_243_cov_1.805882_g7884_i0 PRJNA1263632 7902 243 1.805882 4.38829326 Diptera 7147 Arthropoda Arthropoda 42.7 0.0301   NR XP_030376772.1 7225 g7884 i0 34.4 1.59259259259259 64 42 79 0 241 50 146 209 XP_030376772.1 60S ribosomal protein L13 [Scaptodrosophila lebanonensis] diamond 387 43.1 0.990719257540603 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Scaptodrosophila Scaptodrosophila lebanonensis
27723917 27723917 PRJNA1263632_P_NODE_6684_length_250_cov_0.870056_g6666_i0 PRJNA1263632 6684 250 0.870056 2.17514 Ixodes 6944 Arthropoda Arthropoda 43.1 0.0298   NR EEC19875.1 6945 g6666 i0 64.3 1.344 28 10 33.6 0 87 4 417 444 EEC19875.1 translation elongation factor EF-1 alpha/Tu, putative, partial [Ixodes scapularis] diamond 336 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
28084488 28084488 PRJNA1263632_P_NODE_4265_length_301_cov_2.021930_g4247_i0 PRJNA1263632 4265 301 2.02193 6.0860093 Daphnia pulex 6669 Arthropoda Arthropoda 144 4.72e-41   NR EFX61295.1 6669 g4247 i0 80 0.946843853820598 95 12 87.7 1 296 33 1 95 EFX61295.1 hypothetical protein DAPPUDRAFT_274173, partial [Daphnia pulex] diamond 285 144 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
28652961 28652961 PRJNA1263632_P_NODE_6407_length_251_cov_0.865169_g6389_i0 PRJNA1263632 6407 251 0.865169 2.17157419 Schistocerca gregaria 7010 Arthropoda Arthropoda 95.1 7.78e-21   NR XP_049849336.1 7010 g6389 i0 50 1.9601593625498 82 41 98 0 246 1 85 166 XP_049849336.1 elongation factor 1-gamma-A-like isoform X2 [Schistocerca gregaria] diamond 492 95.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29396960 29396960 PRJNA1263632_P_NODE_5829_length_263_cov_1.052632_g5811_i0 PRJNA1263632 5829 263 1.052632 2.76842216 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 126 2.36e-34   NR XP_027197667.1 6956 g5811 i0 71.3 51.1825095057034 87 25 99.2 0 263 3 31 117 XP_027197667.1 60S ribosomal protein L19-like [Dermatophagoides pteronyssinus] diamond 13461 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
29459797 29459797 PRJNA1263632_P_NODE_4810_length_287_cov_1.098131_g4792_i0 PRJNA1263632 4810 287 1.098131 3.15163597 Metazoa 33208 Arthropoda Arthropoda 127 1.04e-33   NR XP_050525217.1 58002 g4792 i0 63.8 6.89895470383275 94 34 98.3 0 4 285 121 214 XP_050525217.1 probable very-long-chain enoyl-CoA reductase art-1 [Daktulosphaira vitifoliae] diamond 1980 128 0.9921875 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
30010863 30010863 PRJNA1263632_P_NODE_2551_length_381_cov_1.331169_g2533_i0 PRJNA1263632 2551 381 1.331169 5.07175389 Idotea baltica 82763 Arthropoda Arthropoda 114 3.5400000000000003e-29   NR MCL4113740.1 82763 g2533 i0 54.7 0.834645669291339 106 47 82.7 1 316 2 6 111 MCL4113740.1 hypothetical protein [Idotea baltica] diamond 318 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
31071320 31071320 PRJNA1263632_P_NODE_5555_length_269_cov_1.168367_g5537_i0 PRJNA1263632 5555 269 1.168367 3.14290723 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 115 3.32e-29   NR AXR98485.1 6728 g5537 i0 75.7 3.43494423791822 74 17 82.5 1 45 266 70 142 AXR98485.1 papain family cysteine protease, partial [Procambarus clarkii] diamond 924 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
32065341 32065341 PRJNA1263632_P_NODE_6938_length_248_cov_1.320000_g6920_i0 PRJNA1263632 6938 248 1.32 3.2736 Schistocerca americana 7009 Arthropoda Arthropoda 96.7 4.230000000000001e-21   NR XP_047003416.1 7009 g6920 i0 74.6 5.95161290322581 59 15 71.4 0 178 2 203 261 XP_047003416.1 nucleolar GTP-binding protein 2 [Schistocerca americana] diamond 1476 96.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca americana
32083171 32083171 PRJNA1263632_P_NODE_8178_length_242_cov_0.911243_g8160_i0 PRJNA1263632 8178 242 0.911243 2.20520806 Arthropoda 6656 Arthropoda Arthropoda 119 1.73e-32   NR NP_001091751.1 7091 g8160 i0 75.3 22.8223140495868 73 18 90.5 0 23 241 19 91 NP_001091751.1 ribosomal protein L31 [Bombyx mori] diamond 5523 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Bombycidae Bombyx Bombyx mori
32508644 32508644 PRJNA1263632_P_NODE_8359_length_241_cov_0.916667_g8341_i0 PRJNA1263632 8359 241 0.916667 2.20916747 Macrobrachium nipponense 159736 Arthropoda Arthropoda 43.9 0.00493   NR XP_064109159.1 159736 g8341 i0 34.3 0.83402489626556 67 39 77.2 1 219 34 39 105 XP_064109159.1 profilin-like [Macrobrachium nipponense] diamond 201 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Palaemonidae Macrobrachium Macrobrachium nipponense
32886323 32886323 PRJNA1263632_P_NODE_8460_length_241_cov_0.916667_g8442_i0 PRJNA1263632 8460 241 0.916667 2.20916747 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 91.3 2.18e-19   NR RWS02087.1 1965070 g8442 i0 55.1 1.95435684647303 78 35 97.1 0 236 3 330 407 RWS02087.1 hypothetical protein B4U79_12664, partial [Dinothrombium tinctorium] diamond 471 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium

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