RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA473799" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473799 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
14474392 14474392 PRJNA473799_P_NODE_42272_length_247_cov_0.885057_g41998_i0 PRJNA473799 42272 247 0.885057 2.18609079 Sipha flava 143950 Arthropoda Arthropoda 117 2.1e-28   NR XP_025425583.1 143950 g41998 i0 81.9 1.0080971659919 83 10 98.4 2 3 245 1994 2073 XP_025425583.1 protein MON2 homolog isoform X2 [Sipha flava] diamond 249 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Sipha Sipha flava
14474608 14474608 PRJNA473799_P_NODE_57472_length_225_cov_4.019737_g57198_i0 PRJNA473799 57472 225 4.019737 9.04440825 Bradysia coprophila 38358 Arthropoda Arthropoda 115 2.7699999999999993e-28   NR XP_037048654.1 38358 g57198 i0 70.3 0.986666666666667 74 22 98.7 0 225 4 16 89 XP_037048654.1 uncharacterized protein LOC119083123 isoform X2 [Bradysia coprophila] diamond 222 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
26601059 26601059 PRJNA473799_P_NODE_28041_length_262_cov_2.280423_g27767_i0 PRJNA473799 28041 262 2.280423 5.97470826 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 149 1.57e-39   NR KAH9404896.1 59818 g27767 i0 83.7 0.984732824427481 86 14 98.5 0 4 261 548 633 KAH9404896.1 hypothetical protein TYRP_000729 [Tyrophagus putrescentiae] diamond 258 149 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
26664395 26664395 PRJNA473799_P_NODE_47761_length_244_cov_0.900585_g47487_i0 PRJNA473799 47761 244 0.900585 2.1974274 Chironomus riparius 315576 Arthropoda Arthropoda 124 3.16e-31   NR CAG9800586.1 315576 g47487 i0 79.2 0.885245901639344 72 15 88.5 0 244 29 166 237 CAG9800586.1 unnamed protein product [Chironomus riparius] diamond 216 124 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
26743797 26743797 PRJNA473799_P_NODE_55301_length_238_cov_2.593939_g55027_i0 PRJNA473799 55301 238 2.593939 6.17357482 Delphacidae 33362 Arthropoda Arthropoda 69.7 1.13e-11   NR XP_039282928.1 108931 g55027 i0 82.1 3.92016806722689 39 7 49.2 0 117 1 1221 1259 XP_039282928.1 mucin-5AC [Nilaparvata lugens] diamond 933 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Nilaparvata Nilaparvata lugens
27012855 27012855 PRJNA473799_P_NODE_37322_length_250_cov_0.870056_g37048_i0 PRJNA473799 37322 250 0.870056 2.17514 Uranotaenia lowii 190385 Arthropoda Arthropoda 72.8 5.92e-14   NR XP_055598312.1 190385 g37048 i0 47.6 1.008 84 42 98.4 1 247 2 59 142 XP_055598312.1 probable 39S ribosomal protein L23, mitochondrial [Uranotaenia lowii] diamond 252 72.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
27676683 27676683 PRJNA473799_P_NODE_15324_length_289_cov_0.972222_g15050_i0 PRJNA473799 15324 289 0.972222 2.80972158 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 155 1.25e-41   NR KAG5683278.1 319348 g15050 i0 77.1 0.996539792387543 96 20 99.7 1 288 1 560 653 KAG5683278.1 hypothetical protein PVAND_012568 [Polypedilum vanderplanki] diamond 288 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
27692858 27692858 PRJNA473799_P_NODE_49704_length_243_cov_0.905882_g49430_i0 PRJNA473799 49704 243 0.905882 2.20129326 Diptera 7147 Arthropoda Arthropoda 134 2.2499999999999998e-34   NR KAI8118600.1 7375 g49430 i0 78.5 23.4074074074074 79 17 97.5 0 2 238 51 129 KAI8118600.1 Eukaryotic translation initiation factor 4E-binding protein Mextli [Lucilia cuprina] diamond 5688 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
27834200 27834200 PRJNA473799_P_NODE_26444_length_265_cov_2.791667_g26170_i0 PRJNA473799 26444 265 2.791667 7.39791755 Blattella germanica 6973 Arthropoda Arthropoda 52 2.49e-5   NR PSN30184.1 6973 g26170 i0 80 0.39622641509434 35 6 38.5 1 263 162 317 351 PSN30184.1 hypothetical protein C0J52_28225 [Blattella germanica] diamond 105 52 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
27929087 27929087 PRJNA473799_P_NODE_36525_length_250_cov_0.870056_g36251_i0 PRJNA473799 36525 250 0.870056 2.17514 Agrilus planipennis 224129 Arthropoda Arthropoda 44.3 0.0117   NR XP_025831095.1 224129 g36251 i0 39.1 0.552 46 25 55.2 1 100 237 281 323 XP_025831095.1 uncharacterized protein LOC112904667 [Agrilus planipennis] diamond 138 44.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Buprestidae Agrilus Agrilus planipennis
28181383 28181383 PRJNA473799_P_NODE_52746_length_242_cov_0.911243_g52472_i0 PRJNA473799 52746 242 0.911243 2.20520806 Artemia franciscana 6661 Arthropoda Arthropoda 76.3 5.68e-14   NR XP_065557710.1 6661 g52472 i0 39.2 1.95867768595041 79 48 97.9 0 3 239 390 468 XP_065557710.1 uncharacterized protein LOC136025654 [Artemia franciscana] diamond 474 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28529118 28529118 PRJNA473799_P_NODE_46407_length_245_cov_0.895349_g46133_i0 PRJNA473799 46407 245 0.895349 2.19360505 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 107 9.16e-25   NR KAH9391526.1 59818 g46133 i0 93 0.697959183673469 57 4 69.8 0 243 73 435 491 KAH9391526.1 hypothetical protein TYRP_022460 [Tyrophagus putrescentiae] diamond 171 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28623867 28623867 PRJNA473799_P_NODE_57347_length_226_cov_2.346405_g57073_i0 PRJNA473799 57347 226 2.346405 5.3028753 Laodelphax striatellus 195883 Arthropoda Arthropoda 51.2 2.92e-5   NR RZF35701.1 195883 g57073 i0 55.6 0.716814159292035 54 16 71.7 1 1 162 274 319 RZF35701.1 hypothetical protein LSTR_LSTR009569 [Laodelphax striatellus] diamond 162 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Delphacidae Laodelphax Laodelphax striatellus
28655308 28655308 PRJNA473799_P_NODE_25627_length_267_cov_1.386598_g25353_i0 PRJNA473799 25627 267 1.386598 3.70221666 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 48.9 3.42e-4   NR CAI6349505.1 13131 g25353 i0 72.4 0.325842696629214 29 8 32.6 0 121 207 15 43 CAI6349505.1 unnamed protein product [Macrosiphum euphorbiae] diamond 87 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae
29097364 29097364 PRJNA473799_P_NODE_16168_length_287_cov_0.981308_g15894_i0 PRJNA473799 16168 287 0.981308 2.81635396 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 72.4 3.27e-14   NR CAI6367776.1 13131 g15894 i0 82.5 0.418118466898955 40 7 41.8 0 81 200 9 48 CAI6367776.1 unnamed protein product [Macrosiphum euphorbiae] diamond 120 72.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae
29097365 29097365 PRJNA473799_P_NODE_19088_length_280_cov_1.560386_g18814_i0 PRJNA473799 19088 280 1.560386 4.3690808 Uroleucon formosanum 796250 Arthropoda Arthropoda 55.8 1.39e-6   NR KAL4113851.1 796250 g18814 i0 84.8 2.475 33 4 34.3 1 231 136 300 332 KAL4113851.1 hypothetical protein QTP88_017412 [Uroleucon formosanum] diamond 693 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
29444343 29444343 PRJNA473799_P_NODE_11770_length_310_cov_2.527426_g11496_i0 PRJNA473799 11770 310 2.527426 7.8350206 Clunio marinus 568069 Arthropoda Arthropoda 82.8 7.34e-16   NR CRL05558.1 568069 g11496 i0 78 1.74193548387097 50 11 48.4 0 150 1 202 251 CRL05558.1 CLUMA_CG018181, isoform A [Clunio marinus] diamond 540 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
29492263 29492263 PRJNA473799_P_NODE_19950_length_278_cov_2.068293_g19676_i0 PRJNA473799 19950 278 2.068293 5.74985454 Aphididae 27482 Arthropoda Arthropoda 115 1.11e-27   NR XP_060873912.1 44670 g19676 i0 60.4 1.96402877697842 91 36 98.2 0 278 6 514 604 XP_060873912.1 uncharacterized protein LOC132947655 [Metopolophium dirhodum] diamond 546 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Metopolophium Metopolophium dirhodum
29602107 29602107 PRJNA473799_P_NODE_18870_length_281_cov_1.009615_g18596_i0 PRJNA473799 18870 281 1.009615 2.83701815 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 196 1.4699999999999997e-57   NR KAG5677743.1 319348 g18596 i0 100 2.97864768683274 93 0 99.3 0 1 279 297 389 KAG5677743.1 hypothetical protein PVAND_007474 [Polypedilum vanderplanki] diamond 837 196 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
29791709 29791709 PRJNA473799_P_NODE_14111_length_292_cov_1.776256_g13837_i0 PRJNA473799 14111 292 1.776256 5.18666752 Pseudolycoriella hygida 35572 Arthropoda Arthropoda 55.8 1.37e-6   NR KAJ6640774.1 35572 g13837 i0 41.2 0.523972602739726 51 30 52.4 0 2 154 42 92 KAJ6640774.1 hypothetical protein Bhyg_05706, partial [Pseudolycoriella hygida] diamond 153 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Pseudolycoriella Pseudolycoriella hygida
29886797 29886797 PRJNA473799_P_NODE_35991_length_250_cov_1.813559_g35717_i0 PRJNA473799 35991 250 1.813559 4.5338975 Trichonephila clavipes 2585209 Arthropoda Arthropoda 133 6.739999999999999e-37   NR GFV81689.1 2585209 g35717 i0 72.3 36.84 83 23 99.6 0 2 250 95 177 GFV81689.1 transposable element Tcb2 transposase [Trichonephila clavipes] diamond 9210 133 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Nephilidae Trichonephila Trichonephila clavipes
30518521 30518521 PRJNA473799_P_NODE_44493_length_246_cov_0.890173_g44219_i0 PRJNA473799 44493 246 0.890173 2.18982558 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 53.1 4.95e-6   NR KAH9408518.1 59818 g44219 i0 88.9 0.329268292682927 27 3 32.9 0 88 168 1 27 KAH9408518.1 hypothetical protein TYRP_012195 [Tyrophagus putrescentiae] diamond 81 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30802861 30802861 PRJNA473799_P_NODE_20814_length_277_cov_1.029412_g20540_i0 PRJNA473799 20814 277 1.029412 2.85147124 Cinara cedri 506608 Arthropoda Arthropoda 42.7 0.015   NR VVC26991.1 506608 g20540 i0 72.4 0.314079422382672 29 8 31.4 0 10 96 41 69 VVC26991.1 Hypothetical protein CINCED_3A019184, partial [Cinara cedri] diamond 87 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Cinara Cinara cedri
30802868 30802868 PRJNA473799_P_NODE_44934_length_246_cov_0.890173_g44660_i0 PRJNA473799 44934 246 0.890173 2.18982558 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 73.9 4.1e-13   NR KAH9404637.1 59818 g44660 i0 96.3 1 82 3 100 0 246 1 40 121 KAH9404637.1 hypothetical protein TYRP_000463 [Tyrophagus putrescentiae] diamond 246 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31071963 31071963 PRJNA473799_P_NODE_21615_length_275_cov_1.391089_g21341_i0 PRJNA473799 21615 275 1.391089 3.82549475 Aphididae 27482 Arthropoda Arthropoda 62.8 4.75e-9   NR KAF0702148.1 307492 g21341 i0 71.4 1.15636363636364 49 13 53.5 1 24 170 428 475 KAF0702148.1 craniofacial development protein 2-like, partial [Aphis craccivora] diamond 318 63.2 0.993670886075949 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
31181735 31181735 PRJNA473799_P_NODE_56275_length_232_cov_2.628931_g56001_i0 PRJNA473799 56275 232 2.628931 6.09911992 Chironomus riparius 315576 Arthropoda Arthropoda 88.2 3.14e-18   NR CAG9811411.1 315576 g56001 i0 53.9 0.982758620689655 76 35 98.3 0 229 2 249 324 CAG9811411.1 unnamed protein product [Chironomus riparius] diamond 228 88.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
31213216 31213216 PRJNA473799_P_NODE_29255_length_260_cov_1.524064_g28981_i0 PRJNA473799 29255 260 1.524064 3.9625664 Asbolus verrucosus 1661398 Arthropoda Arthropoda 60.8 1.46e-8   NR RZB40008.1 1661398 g28981 i0 71.8 2.76923076923077 39 11 45 0 49 165 39 77 RZB40008.1 phytanoyl-CoA dioxygenase, peroxisomal-like, partial [Asbolus verrucosus] diamond 720 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Asbolus Asbolus verrucosus
31371974 31371974 PRJNA473799_P_NODE_37296_length_250_cov_0.870056_g37022_i0 PRJNA473799 37296 250 0.870056 2.17514 Chironomus riparius 315576 Arthropoda Arthropoda 52.8 1.18e-5   NR CAG9798579.1 315576 g37022 i0 49.4 1.02 85 8 94.8 3 3 239 484 539 CAG9798579.1 unnamed protein product [Chironomus riparius] diamond 255 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus riparius
31388115 31388115 PRJNA473799_P_NODE_17996_length_283_cov_1.000000_g17722_i0 PRJNA473799 17996 283 1 2.83 Opisthokonta 33154 Arthropoda Arthropoda 73.9 4.52e-13   NR XP_065579740.1 6661 g17722 i0 70 7.98233215547703 40 12 42.4 0 239 120 280 319 XP_065579740.1 developmentally-regulated GTP-binding protein 1 [Artemia franciscana] diamond 2259 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
31483083 31483083 PRJNA473799_P_NODE_39476_length_249_cov_0.875000_g39202_i0 PRJNA473799 39476 249 0.875 2.17875 Aphididae 27482 Arthropoda Arthropoda 112 6.43e-28   NR CAI6370351.1 13131 g39202 i0 61 1.97590361445783 82 32 98.8 0 248 3 19 100 CAI6370351.1 unnamed protein product [Macrosiphum euphorbiae] diamond 492 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae
32321157 32321157 PRJNA473799_P_NODE_11939_length_310_cov_2.215190_g11665_i0 PRJNA473799 11939 310 2.21519 6.867089 Carabus blaptoides fortunei 49296 Arthropoda Arthropoda 73.2 1.8e-12   NR GLV40255.1 49296 g11665 i0 82.4 1.91612903225806 51 7 47.4 1 163 309 4749 4799 GLV40255.1 Structural maintenance of chromosomes 1 [Carabus blaptoides fortunei] diamond 594 73.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Carabidae Carabus Carabus blaptoides

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