RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA564810" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA564810 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
3684973 3684973 PRJNA564810_S_NODE_6743_length_226_cov_2.447205_g6721_i0 PRJNA564810 6743 226 2.447205 5.5306833 Culicoides brevitarsis 469753 Arthropoda Arthropoda 100 5.66e-23   NR XP_063706923.1 469753 g6721 i0 68.2 3.50442477876106 66 21 87.6 0 28 225 306 371 XP_063706923.1 obg-like ATPase 1 [Culicoides brevitarsis] diamond 792 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Ceratopogonidae Culicoides Culicoides brevitarsis
5657986 5657986 PRJNA564810_S_NODE_5045_length_253_cov_1.446809_g5023_i0 PRJNA564810 5045 253 1.446809 3.66042677 Choristoneura fumiferana 7141 Arthropoda Arthropoda 84.7 7.24e-17   NR KAI8420991.1 7141 g5023 i0 50 6.28458498023715 88 26 86.6 2 35 253 786 870 KAI8420991.1 hypothetical protein MSG28_008132 [Choristoneura fumiferana] diamond 1590 84.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Choristoneura Choristoneura fumiferana
15856851 15856851 PRJNA564810_S_NODE_4473_length_263_cov_2.015152_g4451_i0 PRJNA564810 4473 263 2.015152 5.29984976 Cotesia 32390 Arthropoda Arthropoda 92 1.02e-20   NR QBB02026.1 89804 g4451 i0 84.4 8.12167300380228 45 7 51.3 0 263 129 175 219 QBB02026.1 putative peroxiredoxin 1, partial [Cotesia chilonis] diamond 2136 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia chilonis
26649696 26649696 PRJNA564810_S_NODE_1861_length_343_cov_4.892086_g1839_i0 PRJNA564810 1861 343 4.892086 16.77985498 root 1 Root_unresolved Root_unresolved 61.6 2.69e-8   NR CAD7240335.1 69355 g1839 i0 44.9 6.76967930029155 69 37 60.3 1 263 57 403 470 CAD7240335.1 unnamed protein product [Darwinula stevensoni] diamond 2322 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
26649697 26649697 PRJNA564810_S_NODE_5141_length_251_cov_2.225806_g5119_i0 PRJNA564810 5141 251 2.225806 5.58677306 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 63.2 1.34e-9   NR XP_017304202.1 121845 g5119 i0 39.5 3.70517928286853 81 49 96.8 0 2 244 158 238 XP_017304202.1 EARP-interacting protein homolog [Diaphorina citri] diamond 930 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
27029768 27029768 PRJNA564810_S_NODE_6542_length_229_cov_1.243902_g6520_i0 PRJNA564810 6542 229 1.243902 2.84853558 Vanessa 42274 Arthropoda Arthropoda 43.9 0.0122   NR XP_047536348.1 42275 g6520 i0 55.9 0.890829694323144 34 15 44.5 0 221 120 622 655 XP_047536348.1 guanine nucleotide exchange factor subunit Rich isoform X3 [Vanessa atalanta] diamond 204 44.3 0.99097065462754 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Vanessa Vanessa atalanta
27945889 27945889 PRJNA564810_S_NODE_3565_length_283_cov_2.477064_g3543_i0 PRJNA564810 3565 283 2.477064 7.01009112 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 73.6 5.48e-13   NR CAD7630303.1 1979941 g3543 i0 47.5 4.25088339222615 80 38 80.6 2 3 230 46 125 CAD7630303.1 unnamed protein product [Medioppia subpectinata] diamond 1203 74.3 0.990578734858681 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Medioppia Medioppia subpectinata
28311113 28311113 PRJNA564810_S_NODE_1386_length_370_cov_4.134426_g1364_i0 PRJNA564810 1386 370 4.134426 15.2973762 Nymphon striatum 424472 Arthropoda Arthropoda 68.2 2.1e-10   NR KAG1680693.1 424472 g1364 i0 41.7 2.25405405405405 96 52 74.6 2 2 277 2085 2180 KAG1680693.1 ATP-binding cassette sub-family A member 1 [Nymphon striatum] diamond 834 68.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Pycnogonida Pantopoda Nymphonidae Nymphon Nymphon striatum
30237318 30237318 PRJNA564810_S_NODE_5672_length_242_cov_1.937853_g5650_i0 PRJNA564810 5672 242 1.937853 4.68960426 Nephila pilipes 299642 Arthropoda Arthropoda 60.8 1.42e-8   NR GFU28543.1 299642 g5650 i0 52.7 4.67355371900826 55 23 64.5 1 3 158 316 370 GFU28543.1 NSFL1 cofactor p47 [Nephila pilipes] diamond 1131 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Nephila Nephila pilipes
30346322 30346322 PRJNA564810_S_NODE_3692_length_280_cov_2.209302_g3670_i0 PRJNA564810 3692 280 2.209302 6.1860456 Hymenoptera 7399 Arthropoda Arthropoda 50.4 1.13e-4   NR XP_020284655.1 219809 g3670 i0 50.8 1.875 59 26 60 1 2 169 551 609 XP_020284655.1 signal recognition particle subunit SRP72 [Pseudomyrmex gracilis] diamond 525 50.8 0.992125984251969 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Pseudomyrmex Pseudomyrmex gracilis
30427278 30427278 PRJNA564810_S_NODE_7193_length_221_cov_1.583333_g7171_i0 PRJNA564810 7193 221 1.583333 3.49916593 Larinioides sclopetarius 280406 Arthropoda Arthropoda 92.8 2.08e-20   NR CAL1295832.1 280406 g7171 i0 55.7 0.950226244343891 70 31 95 0 211 2 222 291 CAL1295832.1 unnamed protein product [Larinioides sclopetarius] diamond 210 92.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Larinioides Larinioides sclopetarius
30630017 30630017 PRJNA564810_S_NODE_5033_length_253_cov_2.015957_g5011_i0 PRJNA564810 5033 253 2.0159570000000002 5.10037121 Drosophila 7215 Arthropoda Arthropoda 82 5.7e-16   NR XP_020806043.1 7274 g5011 i0 72.7 3.26086956521739 55 15 65.2 0 10 174 408 462 XP_020806043.1 phosphoglycerate kinase [Drosophila serrata] diamond 825 82.8 0.990338164251208 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila serrata
30882869 30882869 PRJNA564810_S_NODE_1634_length_354_cov_3.089965_g1612_i0 PRJNA564810 1634 354 3.089965 10.9384761 Metazoa 33208 Arthropoda Arthropoda 136 2.8e-36   NR XP_065584830.1 6661 g1612 i0 80 9.58474576271187 75 15 63.6 0 3 227 257 331 XP_065584830.1 cathepsin B-like isoform X4 [Artemia franciscana] diamond 3393 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31198464 31198464 PRJNA564810_S_NODE_4815_length_257_cov_1.765625_g4793_i0 PRJNA564810 4815 257 1.765625 4.53765625 Mesostigmata 34634 Arthropoda Arthropoda 52.8 6.52e-6   NR XP_003744333.1 34638 g4793 i0 83.3 1.4124513618677 30 5 35 0 3 92 165 194 XP_003744333.1 synaptobrevin homolog YKT6 [Galendromus occidentalis] diamond 363 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
31515425 31515425 PRJNA564810_S_NODE_196_length_663_cov_19.245819_g179_i0 PRJNA564810 196 663 19.245819 127.59977997 root 1 Root_unresolved Root_unresolved 53.1 3.8e-4   NR GBN61280.1 182803 g179 i0 50.9 2.20814479638009 53 26 24 0 126 284 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
31533269 31533269 PRJNA564810_S_NODE_5536_length_244_cov_3.290503_g5514_i0 PRJNA564810 5536 244 3.290503 8.02882732 Episyrphus balteatus 286459 Arthropoda Arthropoda 103 1.1e-23   NR XP_055853046.1 286459 g5514 i0 59.7 1.64754098360656 67 27 82.4 0 234 34 698 764 XP_055853046.1 neprilysin-2 isoform X2 [Episyrphus balteatus] diamond 402 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Episyrphus Episyrphus balteatus
31754400 31754400 PRJNA564810_S_NODE_1777_length_347_cov_1.159574_g1755_i0 PRJNA564810 1777 347 1.159574 4.02372178 Stegodyphus dumicola 202533 Arthropoda Arthropoda 61.2 4.14e-8   NR XP_035212509.1 202533 g1755 i0 50 0.518731988472622 60 26 51.9 2 249 70 587 642 XP_035212509.1 ADAMTS-like protein 1 [Stegodyphus dumicola] diamond 180 61.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Eresidae Stegodyphus Stegodyphus dumicola
31926298 31926298 PRJNA564810_S_NODE_2557_length_313_cov_2.858871_g2535_i0 PRJNA564810 2557 313 2.858871 8.94826623 Pteromalidae 7423 Arthropoda Arthropoda 81.6 1.81e-15   NR XP_016836497.1 7425 g2535 i0 63.6 1.05431309904153 55 20 52.7 0 3 167 699 753 XP_016836497.1 neprilysin-2 isoform X2 [Nasonia vitripennis] diamond 330 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
32007568 32007568 PRJNA564810_S_NODE_1938_length_340_cov_1.730909_g1916_i0 PRJNA564810 1938 340 1.730909 5.8850906 Athalia rosae 37344 Arthropoda Arthropoda 77.4 3.13e-14   NR XP_020706374.1 37344 g1916 i0 52.6 1.59705882352941 57 27 50.3 0 6 176 201 257 XP_020706374.1 transcriptional activator protein Pur-beta-B isoform X4 [Athalia rosae] diamond 543 77.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Athaliidae Athalia Athalia rosae
32021315 32021315 PRJNA564810_S_NODE_5418_length_246_cov_1.878453_g5396_i0 PRJNA564810 5418 246 1.878453 4.62099438 root 1 Root_unresolved Root_unresolved 66.6 1.47e-10   NR CAB3382484.1 197152 g5396 i0 50 9.5609756097561 50 25 61 0 1 150 398 447 CAB3382484.1 Hypothetical predicted protein [Cloeon dipterum] diamond 2352 66.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Ephemeroptera Baetidae Cloeon Cloeon dipterum
32070805 32070805 PRJNA564810_S_NODE_7878_length_214_cov_1.476510_g7856_i0 PRJNA564810 7878 214 1.47651 3.1597314 Araneus ventricosus 182803 Arthropoda Arthropoda 48.9 6.73e-5   NR GBN21262.1 182803 g7856 i0 35.2 3.43457943925234 71 39 89.7 1 209 18 87 157 GBN21262.1 Peroxisomal carnitine O-octanoyltransferase [Araneus ventricosus] diamond 735 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
32260968 32260968 PRJNA564810_S_NODE_2778_length_305_cov_3.095833_g2756_i0 PRJNA564810 2778 305 3.095833 9.44229065 Gonioctena quinquepunctata 63699 Arthropoda Arthropoda 44.3 0.0219   NR KAG5885625.1 63699 g2756 i0 50 1.45573770491803 48 23 46.2 1 300 160 304 351 KAG5885625.1 hypothetical protein JTB14_006171, partial [Gonioctena quinquepunctata] diamond 444 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Gonioctena Gonioctena quinquepunctata
32450761 32450761 PRJNA564810_S_NODE_3119_length_295_cov_1.478261_g3097_i0 PRJNA564810 3119 295 1.478261 4.36086995 Phaedon cochleariae 80249 Arthropoda Arthropoda 60.1 5.58e-8   NR CAH1119198.1 80249 g3097 i0 43.2 6.94576271186441 74 40 73.2 1 293 78 1286 1359 CAH1119198.1 unnamed protein product [Phaedon cochleariae] diamond 2049 60.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Phaedon Phaedon cochleariae

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