RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1012699 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
158009 158009 PRJNA1012699_P_NODE_261_length_643_cov_3.545614_g232_i0 PRJNA1012699 261 643 3.545614 22.79829802 Ixodidae 6939 Arthropoda Arthropoda 255 4.83e-83   NR XP_050040677.1 34620 g232 i0 80 2.31881804043546 165 33 77 0 33 527 1 165 XP_050040677.1 60S ribosomal protein L19-like [Dermacentor andersoni] diamond 1491 255 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Dermacentor Dermacentor andersoni
5260863 5260863 PRJNA1012699_P_NODE_205_length_704_cov_2.619651_g178_i0 PRJNA1012699 205 704 2.619651 18.44234304 Diploptera punctata 6984 Arthropoda Arthropoda 265 1.1e-83   NR KAJ9596723.1 6984 g178 i0 76.1 7.28693181818182 184 44 78.4 0 703 152 13 196 KAJ9596723.1 hypothetical protein L9F63_012246, partial [Diploptera punctata] diamond 5130 265 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blaberidae Diploptera Diploptera punctata
7810621 7810621 PRJNA1012699_P_NODE_3427_length_246_cov_2.618497_g3395_i0 PRJNA1012699 3427 246 2.618497 6.44150262 Artemia franciscana 6661 Arthropoda Arthropoda 156 4.52e-47   NR KAK2719442.1 6661 g3395 i0 100 0.98780487804878 81 0 98.8 0 244 2 17 97 KAK2719442.1 hypothetical protein QYM36_005062 [Artemia franciscana] diamond 243 156 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
12911603 12911603 PRJNA1012699_P_NODE_1331_length_325_cov_2.242063_g1299_i0 PRJNA1012699 1331 325 2.242063 7.28670475 Halotydeus destructor 2874060 Arthropoda Arthropoda 147 1.28e-42   NR KAI1287469.1 2874060 g1299 i0 68.2 14.8430769230769 107 34 98.8 0 4 324 66 172 KAI1287469.1 60S ribosomal protein L17 [Halotydeus destructor] diamond 4824 147 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
14186640 14186640 PRJNA1012699_P_NODE_3132_length_249_cov_0.886364_g3100_i0 PRJNA1012699 3132 249 0.886364 2.20704636 Insecta 50557 Arthropoda Arthropoda 87.4 1.76e-18   NR GLG92476.1 6999 g3100 i0 75.6 7.04819277108434 45 11 54.2 0 246 112 245 289 GLG92476.1 Calcium-binding mitochondrial carrier protein Aralar1 [Gryllus bimaculatus] diamond 1755 87.8 0.995444191343964 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
23110341 23110341 PRJNA1012699_P_NODE_4079_length_236_cov_2.374233_g4047_i0 PRJNA1012699 4079 236 2.374233 5.60318988 Cinara cedri 506608 Arthropoda Arthropoda 120 8.33e-30   NR VVC31685.1 506608 g4047 i0 76.9 1.98305084745763 78 18 99.2 0 1 234 240 317 VVC31685.1 Myo-inositol-1-phosphate synthase,NAD(P)-binding domain,Myo-inositol-1-phosphate synthase, GAPDH-like [Cinara cedri] diamond 468 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
24384146 24384146 PRJNA1012699_P_NODE_580_length_454_cov_5.950131_g548_i0 PRJNA1012699 580 454 5.950131 27.01359474 Arthropoda 6656 Arthropoda Arthropoda 187 2.82e-58   NR XP_032793488.1 35525 g548 i0 79.7 13.2753303964758 123 24 81.3 1 409 41 1 122 XP_032793488.1 40S ribosomal protein S17 [Daphnia magna] diamond 6027 187 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
27224338 27224338 PRJNA1012699_P_NODE_2503_length_257_cov_2.657609_g2471_i0 PRJNA1012699 2503 257 2.657609 6.83005513 Daphnia magna 35525 Arthropoda Arthropoda 104 1.65e-27   NR XP_032786053.2 35525 g2471 i0 79.7 0.747081712062257 64 13 74.7 0 27 218 1 64 XP_032786053.2 stress-associated endoplasmic reticulum protein 2 [Daphnia magna] diamond 192 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia magna
27469632 27469632 PRJNA1012699_P_NODE_4083_length_235_cov_4.135802_g4051_i0 PRJNA1012699 4083 235 4.135802 9.7191347 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 97.1 7.83e-23   NR XP_059093968.1 6832 g4051 i0 66.7 9.11489361702128 69 21 88.1 1 207 1 29 95 XP_059093968.1 small ribosomal subunit protein uS7 [Tigriopus californicus] diamond 2142 97.8 0.992842535787321 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27509022 27509022 PRJNA1012699_P_NODE_1623_length_299_cov_1.716814_g1591_i0 PRJNA1012699 1623 299 1.716814 5.13327386 Homalodisca vitripennis 197043 Arthropoda Arthropoda 54.3 5.23e-6   NR XP_046659170.1 197043 g1591 i0 34.1 1.66555183946488 82 50 78.3 2 279 46 29 110 XP_046659170.1 uncharacterized protein LOC124353372 [Homalodisca vitripennis] diamond 498 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Homalodisca Homalodisca vitripennis
27540502 27540502 PRJNA1012699_P_NODE_764_length_408_cov_2.161194_g732_i0 PRJNA1012699 764 408 2.161194 8.81767152 Artemia franciscana 6661 Arthropoda Arthropoda 155 2.6299999999999993e-42   NR KAK2715654.1 6661 g732 i0 90.3 0.683823529411765 93 9 68.4 0 36 314 232 324 KAK2715654.1 hypothetical protein QYM36_010283 [Artemia franciscana] diamond 279 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
27856091 27856091 PRJNA1012699_P_NODE_365_length_561_cov_3.776639_g335_i0 PRJNA1012699 365 561 3.776639 21.18694479 Artemia franciscana 6661 Arthropoda Arthropoda 311 1.27e-105   NR KAK2724467.1 6661 g335 i0 99.5 0.994652406417112 186 1 99.5 0 2 559 26 211 KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana] diamond 558 311 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28140601 28140601 PRJNA1012699_P_NODE_2305_length_266_cov_1.207254_g2273_i0 PRJNA1012699 2305 266 1.207254 3.21129564 Artemia franciscana 6661 Arthropoda Arthropoda 88.2 4.81e-18   NR KAK2703289.1 6661 g2273 i0 71.2 0.665413533834586 59 17 66.5 0 264 88 472 530 KAK2703289.1 hypothetical protein QYM36_018206 [Artemia franciscana] diamond 177 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28203251 28203251 PRJNA1012699_P_NODE_4006_length_242_cov_0.923077_g3974_i0 PRJNA1012699 4006 242 0.923077 2.23384634 Artemia franciscana 6661 Arthropoda Arthropoda 67 1.03e-10   NR XP_065573043.1 6661 g3974 i0 71.8 0.991735537190083 39 11 48.3 0 238 122 16 54 XP_065573043.1 mediator of RNA polymerase II transcription subunit 16-like isoform X3 [Artemia franciscana] diamond 240 67 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28613938 28613938 PRJNA1012699_P_NODE_3387_length_247_cov_0.896552_g3355_i0 PRJNA1012699 3387 247 0.896552 2.21448344 Artemia franciscana 6661 Arthropoda Arthropoda 44.7 0.00794   NR CAG4635684.1 6661 g3355 i0 57.9 0.461538461538462 38 16 46.2 0 132 19 152 189 CAG4635684.1 EOG090X0BWU [Artemia franciscana] diamond 114 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28732534 28732534 PRJNA1012699_P_NODE_1267_length_332_cov_1.779923_g1235_i0 PRJNA1012699 1267 332 1.779923 5.90934436 Metazoa 33208 Arthropoda Arthropoda 49.7 3.52e-4   NR XP_023015979.1 7539 g1235 i0 59 2.44879518072289 39 15 34.3 1 206 93 292 330 XP_023015979.1 uncharacterized protein LOC111505411 [Leptinotarsa decemlineata] diamond 813 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Leptinotarsa Leptinotarsa decemlineata
28740255 28740255 PRJNA1012699_P_NODE_1567_length_303_cov_5.034783_g1535_i0 PRJNA1012699 1567 303 5.034783 15.25539249 Armadillidium nasatum 96803 Arthropoda Arthropoda 125 6.810000000000001e-33   NR KAB7497657.1 96803 g1535 i0 76.5 1.65346534653465 85 20 84.2 0 297 43 179 263 KAB7497657.1 40S ribosomal protein S25 [Armadillidium nasatum] diamond 501 125 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium nasatum
28890230 28890230 PRJNA1012699_P_NODE_3008_length_250_cov_0.881356_g2976_i0 PRJNA1012699 3008 250 0.881356 2.20339 root 1 Root_unresolved Root_unresolved 182 3.54e-51   NR KAK2724209.1 6661 g2976 i0 97.6 2.952 82 2 98.4 0 3 248 352 433 KAK2724209.1 hypothetical protein QYM36_000910 [Artemia franciscana] diamond 738 183 0.994535519125683 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29245453 29245453 PRJNA1012699_P_NODE_2369_length_263_cov_1.252632_g2337_i0 PRJNA1012699 2369 263 1.252632 3.29442216 Artemia franciscana 6661 Arthropoda Arthropoda 165 2.73e-45   NR KAK2721567.1 6661 g2337 i0 98.9 0.992395437262357 87 1 99.2 0 2 262 739 825 KAK2721567.1 hypothetical protein QYM36_003755 [Artemia franciscana] diamond 261 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
29553135 29553135 PRJNA1012699_P_NODE_2170_length_272_cov_1.557789_g2138_i0 PRJNA1012699 2170 272 1.557789 4.23718608 Insecta 50557 Arthropoda Arthropoda 85.9 5.61e-20   NR QVD39528.1 7010 g2138 i0 74.1 2.45955882352941 54 14 59.6 0 224 63 1 54 QVD39528.1 Protein stunted [Schistocerca gregaria] diamond 669 85.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca gregaria
29940267 29940267 PRJNA1012699_P_NODE_511_length_481_cov_7.122549_g479_i0 PRJNA1012699 511 481 7.122549 34.25946069 Coptotermes formosanus 36987 Arthropoda Arthropoda 75.9 6.46e-13   NR AFZ78853.1 36987 g479 i0 55.6 1.17879417879418 63 27 39.3 1 466 278 192 253 AFZ78853.1 ricin-type beta-trefoil lectin domain-containing protein [Coptotermes formosanus] diamond 567 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Rhinotermitidae Coptotermes Coptotermes formosanus
30066365 30066365 PRJNA1012699_P_NODE_1892_length_285_cov_1.457547_g1860_i0 PRJNA1012699 1892 285 1.457547 4.15400895 Artemia franciscana 6661 Arthropoda Arthropoda 184 5.899999999999999e-58   NR KAK2707747.1 6661 g1860 i0 98.9 0.989473684210526 94 1 98.9 0 2 283 27 120 KAK2707747.1 hypothetical protein QYM36_015446 [Artemia franciscana] diamond 282 184 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30192766 30192766 PRJNA1012699_P_NODE_2692_length_253_cov_0.866667_g2660_i0 PRJNA1012699 2692 253 0.866667 2.19266751 Artemia franciscana 6661 Arthropoda Arthropoda 57.8 1.81e-7   NR XP_065571124.1 6661 g2660 i0 83.3 0.355731225296443 30 5 35.6 0 90 1 1 30 XP_065571124.1 E3 ubiquitin-protein ligase NRDP1-like isoform X2 [Artemia franciscana] diamond 90 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
30224355 30224355 PRJNA1012699_P_NODE_2372_length_263_cov_1.178947_g2340_i0 PRJNA1012699 2372 263 1.178947 3.10063061 Artemia franciscana 6661 Arthropoda Arthropoda 109 2.93e-27   NR KAK2711678.1 6661 g2340 i0 100 0.570342205323194 50 0 57 0 59 208 190 239 KAK2711678.1 hypothetical protein QYM36_012701 [Artemia franciscana] diamond 150 109 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31077661 31077661 PRJNA1012699_P_NODE_2935_length_250_cov_4.666667_g2903_i0 PRJNA1012699 2935 250 4.666667 11.6666675 Artemia franciscana 6661 Arthropoda Arthropoda 136 8.75e-40   NR KAK2723094.1 6661 g2903 i0 100 1.704 71 0 85.2 0 215 3 1 71 KAK2723094.1 hypothetical protein QYM36_003328 [Artemia franciscana] diamond 426 136 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31457069 31457069 PRJNA1012699_P_NODE_2596_length_254_cov_1.607735_g2564_i0 PRJNA1012699 2596 254 1.607735 4.0836469 Polistes exclamans 27506 Arthropoda Arthropoda 43.5 0.00273   NR KAI4480748.1 27506 g2564 i0 60.6 0.389763779527559 33 13 39 0 109 11 36 68 KAI4480748.1 hypothetical protein M0804_009845 [Polistes exclamans] diamond 99 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Polistes Polistes exclamans
31575783 31575783 PRJNA1012699_P_NODE_4056_length_238_cov_2.339394_g4024_i0 PRJNA1012699 4056 238 2.339394 5.56775772 Diptera 7147 Arthropoda Arthropoda 92.8 1.22e-22   NR NP_730968.1 7227 g4024 i0 55.8 9.65546218487395 77 30 92 1 10 228 6 82 NP_730968.1 Spec2 [Drosophila melanogaster] diamond 2298 93.2 0.995708154506438 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila melanogaster
32057931 32057931 PRJNA1012699_P_NODE_2638_length_253_cov_1.305556_g2606_i0 PRJNA1012699 2638 253 1.305556 3.30305668 Artemia franciscana 6661 Arthropoda Arthropoda 120 9.999999999999999e-34   NR KAK2727819.1 6661 g2606 i0 100 0.8300395256917 70 0 83 0 30 239 1 70 KAK2727819.1 hypothetical protein QYM36_008342 [Artemia franciscana] diamond 210 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana

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