RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA546018 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
511406 511406 PRJNA546018_S_NODE_7781_length_635_cov_6.895470_g7475_i0 PRJNA546018 7781 635 6.89547 43.7862345 Metazoa 33208 Arthropoda Arthropoda 68.9 6.53e-10   NR KAG5870089.1 63699 g7475 i0 70.6 1.92755905511811 34 10 16.1 0 78 179 270 303 KAG5870089.1 hypothetical protein JTB14_015188 [Gonioctena quinquepunctata] diamond 1224 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Gonioctena Gonioctena quinquepunctata
18362352 18362352 PRJNA546018_S_NODE_21915_length_343_cov_4.985816_g21590_i0 PRJNA546018 21915 343 4.985816 17.10134888 Clunio marinus 568069 Arthropoda Arthropoda 92.4 6.41e-20   NR CRL01702.1 568069 g21590 i0 66.2 0.620991253644315 71 20 58.6 2 22 222 213 283 CRL01702.1 CLUMA_CG014918, isoform A [Clunio marinus] diamond 213 92.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
26744178 26744178 PRJNA546018_S_NODE_27161_length_304_cov_2.069959_g26836_i0 PRJNA546018 27161 304 2.069959 6.29267536 Insecta 50557 Arthropoda Arthropoda 79 1.2e-14   NR XP_050528175.1 58002 g26836 i0 56.8 9.7203947368421 74 32 73 0 278 57 136 209 XP_050528175.1 uncharacterized protein LOC126898277 [Daktulosphaira vitifoliae] diamond 2955 79 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Phylloxeridae Daktulosphaira Daktulosphaira vitifoliae
26982952 26982952 PRJNA546018_S_NODE_29002_length_292_cov_4.095238_g28677_i0 PRJNA546018 29002 292 4.095238 11.95809496 Uroleucon formosanum 796250 Arthropoda Arthropoda 76.6 8.06e-14   NR KAL4121718.1 796250 g28677 i0 68.4 0.585616438356164 57 10 50.3 1 9 155 162 218 KAL4121718.1 hypothetical protein QTP88_014174 [Uroleucon formosanum] diamond 171 76.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
27014562 27014562 PRJNA546018_S_NODE_18042_length_385_cov_2.055556_g17717_i0 PRJNA546018 18042 385 2.055556 7.9138906 Popillia japonica 7064 Arthropoda Arthropoda 90.5 9.16e-21   NR KAK9711049.1 7064 g17717 i0 71.2 3.56883116883117 66 19 51.4 0 286 89 34 99 KAK9711049.1 Translation machinery associated TMA7 [Popillia japonica] diamond 1374 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Scarabaeidae Popillia Popillia japonica
27109332 27109332 PRJNA546018_S_NODE_59562_length_194_cov_2.902256_g59237_i0 PRJNA546018 59562 194 2.902256 5.63037664 Aphis glycines 307491 Arthropoda Arthropoda 107 1.01e-25   NR KAE9521772.1 307491 g59237 i0 88.5 1.60824742268041 52 6 80.4 0 37 192 1 52 KAE9521772.1 hypothetical protein AGLY_017823 [Aphis glycines] diamond 312 107 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines
27804625 27804625 PRJNA546018_S_NODE_21804_length_344_cov_6.791519_g21479_i0 PRJNA546018 21804 344 6.791519 23.36282536 Notodromas monacha 399045 Arthropoda Arthropoda 70.9 4.24e-13   NR CAD7273964.1 399045 g21479 i0 61.5 2.23255813953488 52 19 44.5 1 323 171 21 72 CAD7273964.1 unnamed protein product [Notodromas monacha] diamond 768 70.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
28467640 28467640 PRJNA546018_S_NODE_19386_length_369_cov_1.451299_g19061_i0 PRJNA546018 19386 369 1.451299 5.35529331 Penaeus vannamei 6689 Arthropoda Arthropoda 48.9 0.00108   NR XP_069999512.1 6689 g19061 i0 48.7 0.91869918699187 113 43 87.8 6 42 365 95 197 XP_069999512.1 obscurin isoform X1 [Penaeus vannamei] diamond 339 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
28797878 28797878 PRJNA546018_S_NODE_20287_length_359_cov_2.251678_g19962_i0 PRJNA546018 20287 359 2.251678 8.08352402 Hymenoptera 7399 Arthropoda Arthropoda 139 5.709999999999999e-37   NR XP_008209070.1 7425 g19962 i0 57.4 1.8050139275766 108 46 90.3 0 21 344 299 406 XP_008209070.1 aspartate aminotransferase, cytoplasmic [Nasonia vitripennis] diamond 648 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
29099022 29099022 PRJNA546018_S_NODE_23288_length_332_cov_1.619926_g22963_i0 PRJNA546018 23288 332 1.619926 5.37815432 Uranotaenia lowii 190385 Arthropoda Arthropoda 44.7 0.0163   NR XP_055585512.1 190385 g22963 i0 56.7 0.271084337349398 30 13 27.1 0 161 72 59 88 XP_055585512.1 uncharacterized protein LOC129738354 [Uranotaenia lowii] diamond 90 44.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Uranotaenia Uranotaenia lowii
29730219 29730219 PRJNA546018_S_NODE_51830_length_210_cov_2.469799_g51505_i0 PRJNA546018 51830 210 2.469799 5.1865779 Aphis craccivora 307492 Arthropoda Arthropoda 57 2.17e-7   NR KAF0759904.1 307492 g51505 i0 87.5 0.457142857142857 32 4 45.7 0 112 17 127 158 KAF0759904.1 paramyosin-like, partial [Aphis craccivora] diamond 96 57 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis craccivora
30551701 30551701 PRJNA546018_S_NODE_26953_length_305_cov_4.610656_g26628_i0 PRJNA546018 26953 305 4.610656 14.0625008 Rhagoletis zephyria 28612 Arthropoda Arthropoda 68.6 6.15e-11   NR XP_017487444.1 28612 g26628 i0 43.2 2.52786885245902 88 43 80.7 2 303 58 337 423 XP_017487444.1 PREDICTED: uncharacterized protein LOC108375808 [Rhagoletis zephyria] diamond 771 68.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
30583232 30583232 PRJNA546018_S_NODE_34553_length_264_cov_2.566502_g34228_i0 PRJNA546018 34553 264 2.566502 6.77556528 Uroleucon formosanum 796250 Arthropoda Arthropoda 45.4 0.00544   NR KAL4141879.1 796250 g34228 i0 90.5 0.238636363636364 21 2 23.9 0 236 174 1077 1097 KAL4141879.1 hypothetical protein QTP88_004434 [Uroleucon formosanum] diamond 63 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Uroleucon Uroleucon formosanum
31310136 31310136 PRJNA546018_S_NODE_40795_length_241_cov_3.011111_g40470_i0 PRJNA546018 40795 241 3.011111 7.25677751 Clunio marinus 568069 Arthropoda Arthropoda 62 5.77e-9   NR CRK95782.1 568069 g40470 i0 46.9 1.00829875518672 81 38 95.9 2 9 239 837 916 CRK95782.1 CLUMA_CG009239, isoform A [Clunio marinus] diamond 243 62 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
32607087 32607087 PRJNA546018_S_NODE_16580_length_404_cov_8.586006_g16255_i0 PRJNA546018 16580 404 8.586006 34.68746424 Plutella xylostella 51655 Arthropoda Arthropoda 120 5.52e-29   NR KAG7296542.1 51655 g16255 i0 76.7 1.08415841584158 73 16 53.5 1 381 166 398 470 KAG7296542.1 hypothetical protein JYU34_020332 [Plutella xylostella] diamond 438 120 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Plutellidae Plutella Plutella xylostella
32733233 32733233 PRJNA546018_S_NODE_24440_length_323_cov_2.232824_g24115_i0 PRJNA546018 24440 323 2.232824 7.21202152 Araneus ventricosus 182803 Arthropoda Arthropoda 54.3 2.55e-6   NR GBL87773.1 182803 g24115 i0 56.8 1.19814241486068 44 18 39.9 1 129 1 31 74 GBL87773.1 hypothetical protein AVEN_81372-1 [Araneus ventricosus] diamond 387 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus

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