RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 29 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1192965 · 29 ✖

analysis 1

  • diamond · 29 ✖
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
320571 320571 PRJNA1192965_P_NODE_3881_length_248_cov_0.880000_g3862_i0 PRJNA1192965 3881 248 0.88 2.1824 Arthropoda 6656 Arthropoda Arthropoda 119 1.0699999999999999e-31   NR KAK7086517.1 373956 g3862 i0 73.8 65.4798387096774 80 21 96.8 0 2 241 92 171 KAK7086517.1 40S ribosomal protein S20 [Halocaridina rubra] diamond 16239 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Atyidae Halocaridina Halocaridina rubra
4147433 4147433 PRJNA1192965_P_NODE_5124_length_241_cov_0.916667_g5105_i0 PRJNA1192965 5124 241 0.916667 2.20916747 Condylostylus longicornis 2530218 Arthropoda Arthropoda 132 6.210000000000001e-36   NR XP_055388586.1 2530218 g5105 i0 75.6 0.970954356846473 78 19 97.1 0 236 3 168 245 XP_055388586.1 cyclin-dependent kinase 2 homolog [Condylostylus longicornis] diamond 234 132 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
13074113 13074113 PRJNA1192965_P_NODE_4611_length_244_cov_0.900585_g4592_i0 PRJNA1192965 4611 244 0.900585 2.1974274 Metazoa 33208 Arthropoda Arthropoda 99.8 3.39e-22   NR KAK2712820.1 6661 g4592 i0 62.2 15.5655737704918 82 29 99.6 2 243 1 421 501 KAK2712820.1 hypothetical protein QYM36_011497 [Artemia franciscana] diamond 3798 99.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
19446556 19446556 PRJNA1192965_P_NODE_496_length_520_cov_1.281879_g477_i0 PRJNA1192965 496 520 1.281879 6.6657708 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 223 1.45e-69   NR GLH16729.1 6999 g477 i0 62.4 43.9038461538462 173 62 99.8 1 1 519 29 198 GLH16729.1 ADP,ATP carrier protein 1 [Gryllus bimaculatus] diamond 22830 223 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Gryllidae Gryllus Gryllus bimaculatus
20721859 20721859 PRJNA1192965_P_NODE_1297_length_354_cov_1.359431_g1278_i0 PRJNA1192965 1297 354 1.359431 4.81238574 Megalopta genalis 115081 Arthropoda Arthropoda 117 1.25e-27   NR XP_033331808.1 115081 g1278 i0 57.1 6.27118644067797 98 42 83.1 0 37 330 534 631 XP_033331808.1 sodium/potassium-transporting ATPase subunit alpha-like [Megalopta genalis] diamond 2220 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Halictidae Megalopta Megalopta genalis
23272670 23272670 PRJNA1192965_P_NODE_1499_length_334_cov_1.727969_g1480_i0 PRJNA1192965 1499 334 1.727969 5.77141646 Metazoa 33208 Arthropoda Arthropoda 99.4 1.9099999999999994e-24   NR XP_046980956.1 7009 g1480 i0 52.3 2.31736526946108 86 41 77.2 0 307 50 18 103 XP_046980956.1 thioredoxin-T-like [Schistocerca americana] diamond 774 100 0.994 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca americana
23272680 23272680 PRJNA1192965_P_NODE_3379_length_251_cov_0.865169_g3360_i0 PRJNA1192965 3379 251 0.865169 2.17157419 Metazoa 33208 Arthropoda Arthropoda 104 8.05e-26   NR XP_046440920.1 6669 g3360 i0 70.3 15.3107569721116 74 22 88.4 0 249 28 92 165 XP_046440920.1 60S ribosomal protein L19-like [Daphnia pulex] diamond 3843 105 0.990476190476191 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Daphniidae Daphnia Daphnia pulex
27103826 27103826 PRJNA1192965_P_NODE_862_length_411_cov_1.366864_g843_i0 PRJNA1192965 862 411 1.366864 5.61781104 Idotea baltica 82763 Arthropoda Arthropoda 229 1.79e-73   NR MCL4112850.1 82763 g843 i0 78.7 0.992700729927007 136 28 99.3 1 3 410 73 207 MCL4112850.1 hypothetical protein [Idotea baltica] diamond 408 229 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27186024 27186024 PRJNA1192965_P_NODE_5182_length_241_cov_0.916667_g5163_i0 PRJNA1192965 5182 241 0.916667 2.20916747 Insecta 50557 Arthropoda Arthropoda 111 7.05e-27   NR CAH2232927.1 348720 g5163 i0 73.4 5.86307053941909 79 20 98.3 1 3 239 205 282 CAH2232927.1 jg12430 [Pararge aegeria aegeria] diamond 1413 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Nymphalidae Pararge Pararge aegeria
27420283 27420283 PRJNA1192965_P_NODE_4163_length_246_cov_0.890173_g4144_i0 PRJNA1192965 4163 246 0.890173 2.18982558 Idotea baltica 82763 Arthropoda Arthropoda 98.6 1.2399999999999999e-23   NR MCL4120794.1 82763 g4144 i0 84.2 0.695121951219512 57 9 69.5 0 171 1 21 77 MCL4120794.1 hypothetical protein [Idotea baltica] diamond 171 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
27609531 27609531 PRJNA1192965_P_NODE_384_length_578_cov_4.732673_g366_i0 PRJNA1192965 384 578 4.732673 27.35484994 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 129 4.84e-34   NR ADD38186.1 72036 g366 i0 37.5 0.996539792387543 192 115 99.7 1 577 2 3 189 ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis] diamond 576 129 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
27672778 27672778 PRJNA1192965_P_NODE_964_length_395_cov_1.329193_g945_i0 PRJNA1192965 964 395 1.329193 5.25031235 Macrosteles quadrilineatus 74068 Arthropoda Arthropoda 135 4.2899999999999995e-37   NR XP_054280180.1 74068 g945 i0 62.2 6.82025316455696 98 37 74.4 0 101 394 5 102 XP_054280180.1 peroxiredoxin 1-like isoform X3 [Macrosteles quadrilineatus] diamond 2694 135 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cicadellidae Macrosteles Macrosteles quadrilineatus
27925225 27925225 PRJNA1192965_P_NODE_3405_length_251_cov_0.865169_g3386_i0 PRJNA1192965 3405 251 0.865169 2.17157419 Leptotrombidium deliense 299467 Arthropoda Arthropoda 67.8 1.23e-11   NR RWS26082.1 299467 g3386 i0 51.6 1.49402390438247 62 30 74.1 0 246 61 134 195 RWS26082.1 hypothetical protein B4U80_08294 [Leptotrombidium deliense] diamond 375 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
27944282 27944282 PRJNA1192965_P_NODE_765_length_430_cov_3.313725_g746_i0 PRJNA1192965 765 430 3.313725 14.2490175 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 99.4 9.95e-24   NR CAG4636732.1 186181 g746 i0 45.9 4.64651162790698 133 56 92.8 1 417 19 7 123 CAG4636732.1 EOG090X0NXS [Eubosmina coregoni] diamond 1998 100 0.994 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Bosminidae Eubosmina Eubosmina coregoni
27988392 27988392 PRJNA1192965_P_NODE_3885_length_248_cov_0.880000_g3866_i0 PRJNA1192965 3885 248 0.88 2.1824 Cydia amplana 1869771 Arthropoda Arthropoda 44.7 0.00824   NR XP_063369892.1 1869771 g3866 i0 37.3 2.29838709677419 75 36 87.1 3 25 240 532 598 XP_063369892.1 uncharacterized protein LOC134658213 [Cydia amplana] diamond 570 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Tortricidae Cydia Cydia amplana
29756352 29756352 PRJNA1192965_P_NODE_1731_length_316_cov_1.489712_g1712_i0 PRJNA1192965 1731 316 1.489712 4.70748992 Hyposmocoma kahamanoa 1477025 Arthropoda Arthropoda 121 1.36e-29   NR XP_026318882.1 1477025 g1712 i0 59.6 3.9493670886076 104 40 98.7 1 5 316 190 291 XP_026318882.1 T-complex protein 1 subunit theta [Hyposmocoma kahamanoa] diamond 1248 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Cosmopterigidae Hyposmocoma Hyposmocoma kahamanoa
29901974 29901974 PRJNA1192965_P_NODE_5231_length_241_cov_0.869048_g5212_i0 PRJNA1192965 5231 241 0.869048 2.09440568 Arthropoda 6656 Arthropoda Arthropoda 75.5 2.99e-15   NR XP_046915356.1 6954 g5212 i0 55 3.98340248962656 80 36 99.6 0 1 240 21 100 XP_046915356.1 fatty acid-binding protein-like [Dermatophagoides farinae] diamond 960 75.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
30186093 30186093 PRJNA1192965_P_NODE_4432_length_245_cov_0.895349_g4413_i0 PRJNA1192965 4432 245 0.895349 2.19360505 Opisthokonta 33154 Arthropoda Arthropoda 65.5 1.86e-11   NR EEC13790.1 6945 g4413 i0 64.8 5.51020408163265 54 19 66.1 0 244 83 16 69 EEC13790.1 ribosomal protein, putative, partial [Ixodes scapularis] diamond 1350 65.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
30293917 30293917 PRJNA1192965_P_NODE_1432_length_340_cov_2.052434_g1413_i0 PRJNA1192965 1432 340 2.052434 6.9782756 Colias eurytheme 42296 Arthropoda Arthropoda 69.7 2.82e-11   NR CAG4972968.1 42296 g1413 i0 41.3 0.705882352941177 80 46 70.6 1 256 17 31 109 CAG4972968.1 unnamed protein product [Colias eurytheme] diamond 240 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Pieridae Colias Colias eurytheme
30957230 30957230 PRJNA1192965_P_NODE_1454_length_338_cov_2.339623_g1435_i0 PRJNA1192965 1454 338 2.339623 7.90792574 Condylostylus longicornis 2530218 Arthropoda Arthropoda 45.8 0.0019   NR XP_055388520.1 2530218 g1435 i0 38.2 0.488165680473373 55 33 48.8 1 166 2 47 100 XP_055388520.1 dynein light chain 1, cytoplasmic-like [Condylostylus longicornis] diamond 165 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
31102305 31102305 PRJNA1192965_P_NODE_1135_length_371_cov_1.352349_g1116_i0 PRJNA1192965 1135 371 1.352349 5.01721479 Metazoa 33208 Arthropoda Arthropoda 101 6.85e-23   NR XP_054153714.1 1686743 g1116 i0 55.8 5.83827493261456 95 37 74.4 3 96 371 38 130 XP_054153714.1 cathepsin B-like [Oppia nitens] diamond 2166 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
31114790 31114790 PRJNA1192965_P_NODE_535_length_503_cov_3.420930_g516_i0 PRJNA1192965 535 503 3.42093 17.2072779 Lepeophtheirus salmonis 72036 Arthropoda Arthropoda 100 8.059999999999999e-23   NR ADD38577.1 72036 g516 i0 34.7 1.01391650099404 170 106 99.6 4 3 503 6 173 ADD38577.1 Glutathione S-transferase Mu 2 [Lepeophtheirus salmonis] diamond 510 100 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Siphonostomatoida Caligidae Lepeophtheirus Lepeophtheirus salmonis
31620923 31620923 PRJNA1192965_P_NODE_4476_length_245_cov_0.895349_g4457_i0 PRJNA1192965 4476 245 0.895349 2.19360505 Phyllotreta striolata 444603 Arthropoda Arthropoda 73.6 2.72e-13   NR CAG9856382.1 444603 g4457 i0 51.2 1.00408163265306 82 39 99.2 1 3 245 200 281 CAG9856382.1 unnamed protein product [Phyllotreta striolata] diamond 246 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Phyllotreta Phyllotreta striolata
32190496 32190496 PRJNA1192965_P_NODE_3478_length_250_cov_0.870056_g3459_i0 PRJNA1192965 3478 250 0.870056 2.17514 Diabrotica balteata 107213 Arthropoda Arthropoda 69.7 1.26e-11   NR CAG9826768.1 107213 g3459 i0 49.3 0.9 75 37 90 1 238 14 320 393 CAG9826768.1 unnamed protein product [Diabrotica balteata] diamond 225 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica balteata
32254047 32254047 PRJNA1192965_P_NODE_5338_length_226_cov_2.013072_g5319_i0 PRJNA1192965 5338 226 2.013072 4.54954272 Schistocerca nitens 7011 Arthropoda Arthropoda 42.4 0.0394   NR XP_049803830.1 7011 g5319 i0 37 0.969026548672566 73 38 96.9 3 221 3 169 233 XP_049803830.1 dipeptidyl peptidase 1-like [Schistocerca nitens] diamond 219 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca nitens
32399449 32399449 PRJNA1192965_P_NODE_4619_length_244_cov_0.900585_g4600_i0 PRJNA1192965 4619 244 0.900585 2.1974274 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 89 2.08e-18   NR XP_053595735.1 69319 g4600 i0 54.9 18.9590163934426 82 35 99.6 2 244 2 365 445 XP_053595735.1 dihydropyrimidine dehydrogenase [NADP(+)] [Microplitis demolitor] diamond 4626 89.7 0.992196209587514 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
32431065 32431065 PRJNA1192965_P_NODE_2419_length_281_cov_1.894231_g2400_i0 PRJNA1192965 2419 281 1.894231 5.32278911 Arthropoda 6656 Arthropoda Arthropoda 106 2.5699999999999997e-24   NR XP_067126174.1 120091 g2400 i0 50 14.9572953736655 90 45 96.1 0 2 271 467 556 XP_067126174.1 protein phosphatase 1G [Centruroides vittatus] diamond 4203 106 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides vittatus
32475394 32475394 PRJNA1192965_P_NODE_159_length_853_cov_4.760256_g146_i0 PRJNA1192965 159 853 4.760256 40.60498368 Diaphorina citri 121845 Arthropoda Arthropoda 262 7.2999999999999995e-84   NR KAI5700884.1 121845 g146 i0 50 6.48886283704572 264 123 92.5 3 851 63 2 257 KAI5700884.1 hypothetical protein M8J75_003817 [Diaphorina citri] diamond 5535 262 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Diaphorina Diaphorina citri
32620514 32620514 PRJNA1192965_P_NODE_3260_length_251_cov_1.449438_g3241_i0 PRJNA1192965 3260 251 1.449438 3.63808938 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 69.3 8.63e-12   NR KAJ8937210.1 1265417 g3241 i0 42.9 4.0398406374502 84 46 99.2 2 250 2 81 163 KAJ8937210.1 hypothetical protein NQ318_006631 [Aromia moschata] diamond 1014 69.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Cerambycidae Aromia Aromia moschata

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