RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1093380 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
16776190 16776190 PRJNA1093380_P_NODE_14454_length_246_cov_0.890173_g14348_i0 PRJNA1093380 14454 246 0.890173 2.18982558 Phlebotomus papatasi 29031 Arthropoda Arthropoda 124 5.01e-31   NR XP_055710445.1 29031 g14348 i0 74.1 6.91463414634146 81 21 98.8 0 3 245 338 418 XP_055710445.1 GMP synthase [glutamine-hydrolyzing] [Phlebotomus papatasi] diamond 1701 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Psychodidae Phlebotomus Phlebotomus papatasi
18870794 18870794 PRJNA1093380_P_NODE_1695_length_431_cov_1.500000_g1589_i0 PRJNA1093380 1695 431 1.5 6.465 Opisthokonta 33154 Arthropoda Arthropoda 222 9.61e-69   NR CAG9806093.1 315576 g1589 i0 81.9 11.7354988399072 138 25 96.1 0 429 16 253 390 CAG9806093.1 unnamed protein product [Chironomus riparius] diamond 5058 224 0.991071428571429 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
26615678 26615678 PRJNA1093380_P_NODE_6621_length_281_cov_2.182692_g6515_i0 PRJNA1093380 6621 281 2.182692 6.13336452 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 133 7.21e-34   NR XP_037070084.1 41117 g6515 i0 66.7 10.9430604982206 93 31 99.3 0 1 279 556 648 XP_037070084.1 major vault protein-like isoform X1 [Pollicipes pollicipes] diamond 3075 134 0.992537313432836 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Pollicipedomorpha Pollicipedidae Pollicipes Pollicipes pollicipes
27312057 27312057 PRJNA1093380_P_NODE_17763_length_230_cov_2.222930_g17657_i0 PRJNA1093380 17763 230 2.22293 5.112739 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 112 6e-30   NR KAH7643321.1 6954 g17657 i0 69.7 14.8434782608696 76 23 99.1 0 230 3 21 96 KAH7643321.1 hypothetical protein HUG17_10012 [Dermatophagoides farinae] diamond 3414 113 0.991150442477876 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
27415518 27415518 PRJNA1093380_P_NODE_15943_length_243_cov_0.905882_g15837_i0 PRJNA1093380 15943 243 0.905882 2.20129326 Ilyocryptus agilis 435267 Arthropoda Arthropoda 151 2.6499999999999993e-40   NR CAG4643065.1 435267 g15837 i0 90 0.987654320987654 80 8 98.8 0 242 3 928 1007 CAG4643065.1 EOG090X02EP [Ilyocryptus agilis] diamond 240 151 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Ilyocryptus Ilyocryptus agilis
27888761 27888761 PRJNA1093380_P_NODE_1945_length_408_cov_1.988060_g1839_i0 PRJNA1093380 1945 408 1.98806 8.1112848 Procambarus clarkii 6728 Arthropoda Arthropoda 194 2.77e-58   NR QEE82512.1 6728 g1839 i0 90.1 2.80147058823529 111 11 81.6 0 75 407 1 111 QEE82512.1 putative phospholipase membrane-associated protein, partial [Procambarus clarkii] diamond 1143 194 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
28101122 28101122 PRJNA1093380_P_NODE_9405_length_265_cov_2.218750_g9299_i0 PRJNA1093380 9405 265 2.21875 5.8796875 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 69.3 2.16e-11   NR XP_044744859.1 41139 g9299 i0 36.8 5.96603773584906 87 54 97.4 1 1 258 549 635 XP_044744859.1 DNA mismatch repair protein Mlh1 [Coccinella septempunctata] diamond 1581 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
29656594 29656594 PRJNA1093380_P_NODE_11910_length_251_cov_0.865169_g11804_i0 PRJNA1093380 11910 251 0.865169 2.17157419 Diaphorina citri 121845 Arthropoda Arthropoda 63.2 2.51e-9   NR XP_008479235.2 121845 g11804 i0 42.1 0.908366533864542 76 44 90.8 0 24 251 166 241 XP_008479235.2 serine/threonine-protein phosphatase 2A 65 kDa regulatory subunit A alpha isoform, partial [Diaphorina citri] diamond 228 63.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
30067543 30067543 PRJNA1093380_P_NODE_352_length_955_cov_2.545351_g273_i0 PRJNA1093380 352 955 2.545351 24.30810205 Procambarus clarkii 6728 Arthropoda Arthropoda 556 1.0699999999999999e-181   NR AYD41603.1 6728 g273 i0 83.6 0.998952879581152 318 52 99.9 0 2 955 1216 1533 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 954 556 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
31426409 31426409 PRJNA1093380_P_NODE_3856_length_316_cov_1.868313_g3750_i0 PRJNA1093380 3856 316 1.868313 5.90386908 Procambarus clarkii 6728 Arthropoda Arthropoda 197 6.6699999999999985e-56   NR AYD41603.1 6728 g3750 i0 89.4 0.987341772151899 104 11 98.7 0 314 3 476 579 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 312 197 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
31521460 31521460 PRJNA1093380_P_NODE_5136_length_290_cov_2.129032_g5030_i0 PRJNA1093380 5136 290 2.129032 6.1741928 Planococcus citri 170843 Arthropoda Arthropoda 43.9 0.0255   NR XP_065217451.1 170843 g5030 i0 34 0.517241379310345 50 33 51.7 0 168 19 171 220 XP_065217451.1 uncharacterized protein LOC135843469 [Planococcus citri] diamond 150 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Planococcus Planococcus citri
31774274 31774274 PRJNA1093380_P_NODE_1457_length_459_cov_1.595855_g1352_i0 PRJNA1093380 1457 459 1.595855 7.32497445 Ilyocryptus agilis 435267 Arthropoda Arthropoda 209 1.4899999999999998e-66   NR CAG4643623.1 435267 g1352 i0 86.2 1.59477124183007 123 17 80.4 0 91 459 27 149 CAG4643623.1 EOG090X0ILG [Ilyocryptus agilis] diamond 732 209 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Ilyocryptus Ilyocryptus agilis
31774277 31774277 PRJNA1093380_P_NODE_4397_length_306_cov_1.008584_g4291_i0 PRJNA1093380 4397 306 1.008584 3.08626704 Procambarus clarkii 6728 Arthropoda Arthropoda 187 1.9499999999999993e-52   NR AYD41603.1 6728 g4291 i0 90.2 1 102 10 100 0 306 1 281 382 AYD41603.1 CD109 antigen-like protein, partial [Procambarus clarkii] diamond 306 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Cambaridae Procambarus Procambarus clarkii
31837439 31837439 PRJNA1093380_P_NODE_15197_length_245_cov_0.895349_g15091_i0 PRJNA1093380 15197 245 0.895349 2.19360505 Gryllus bimaculatus 6999 Arthropoda Arthropoda 79.3 5.06e-15   NR GLG97701.1 6999 g15091 i0 73.7 0.697959183673469 57 15 69.8 0 245 75 1282 1338 GLG97701.1 Ecotropic viral integration site 5 ortholog [Gryllus bimaculatus] diamond 171 79.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
32027507 32027507 PRJNA1093380_P_NODE_14138_length_247_cov_0.885057_g14032_i0 PRJNA1093380 14138 247 0.885057 2.18609079 Ilyocryptus agilis 435267 Arthropoda Arthropoda 107 5.13e-25   NR CAG4643681.1 435267 g14032 i0 91.2 3.46153846153846 57 5 69.2 0 247 77 845 901 CAG4643681.1 EOG090X0O5J [Ilyocryptus agilis] diamond 855 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Macrotrichidae Ilyocryptus Ilyocryptus agilis
32154086 32154086 PRJNA1093380_P_NODE_9398_length_265_cov_2.317708_g9292_i0 PRJNA1093380 9398 265 2.317708 6.1419262 Myzus persicae 13164 Arthropoda Arthropoda 42.7 0.0471   NR XP_022177387.1 13164 g9292 i0 86.4 0.249056603773585 22 3 24.9 0 103 38 364 385 XP_022177387.1 uncharacterized protein LOC111038560 [Myzus persicae] diamond 66 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
32272101 32272101 PRJNA1093380_P_NODE_10078_length_261_cov_2.143617_g9972_i0 PRJNA1093380 10078 261 2.143617 5.59484037 Arthropoda 6656 Arthropoda Arthropoda 67.8 6.8e-12   NR EAT38459.1 7159 g9972 i0 55.9 32.2298850574713 59 26 67.8 0 71 247 21 79 EAT38459.1 AAEL009651-PA [Aedes aegypti] diamond 8412 68.2 0.994134897360704 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
32375642 32375642 PRJNA1093380_P_NODE_4019_length_311_cov_1.294118_g3913_i0 PRJNA1093380 4019 311 1.294118 4.02470698 Exocentrus adspersus 1586481 Arthropoda Arthropoda 56.6 1.08e-6   NR KAJ8919026.1 1586481 g3913 i0 35.1 2.37299035369775 94 54 90.7 3 290 9 50 136 KAJ8919026.1 hypothetical protein NQ315_016931 [Exocentrus adspersus] diamond 738 56.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Exocentrus Exocentrus adspersus

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