RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA688736" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 25 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA688736 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
1177109 1177109 PRJNA688736_P_NODE_13821_length_409_cov_3.651786_g13536_i0 PRJNA688736 13821 409 3.651786 14.93580474 Ladona fulva 123851 Arthropoda Arthropoda 231 2.49e-72   NR KAG8230017.1 123851 g13536 i0 83.5 8.7799511002445 133 22 97.6 0 409 11 258 390 KAG8230017.1 hypothetical protein J437_LFUL008458 [Ladona fulva] diamond 3591 231 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Libellulidae Ladona Ladona fulva
1944151 1944151 PRJNA688736_P_NODE_48142_length_245_cov_0.872093_g47857_i0 PRJNA688736 48142 245 0.872093 2.13662785 Odonata 6961 Arthropoda Arthropoda 142 1.09e-38   NR XP_071440773.1 62018 g47857 i0 79 8.9265306122449 81 17 99.2 0 243 1 6 86 XP_071440773.1 proteasomal ubiquitin receptor ADRM1-B [Hetaerina americana] diamond 2187 142 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Odonata Calopterygidae Hetaerina Hetaerina americana
7046071 7046071 PRJNA688736_P_NODE_18446_length_361_cov_1.100694_g18161_i0 PRJNA688736 18446 361 1.100694 3.97350534 Abscondita terminalis 2069292 Arthropoda Arthropoda 121 9.4e-31   NR KAF5270405.1 2069292 g18161 i0 82.6 2.30193905817175 69 12 57.3 0 361 155 248 316 KAF5270405.1 hypothetical protein FQR65_LT05593 [Abscondita terminalis] diamond 831 121 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Lampyridae Abscondita Abscondita terminalis
17246255 17246255 PRJNA688736_P_NODE_9374_length_486_cov_2.440678_g9090_i0 PRJNA688736 9374 486 2.440678 11.86169508 Anthonomus grandis grandis 2921223 Arthropoda Arthropoda 239 1.05e-77   NR XP_050300592.1 2921223 g9090 i0 73.6 7.35802469135802 159 42 98.1 0 10 486 19 177 XP_050300592.1 nucleoside diphosphate kinase isoform X2 [Anthonomus grandis grandis] diamond 3576 239 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Anthonomus Anthonomus grandis
25404267 25404267 PRJNA688736_P_NODE_44680_length_248_cov_0.891429_g44395_i0 PRJNA688736 44680 248 0.891429 2.21074392 Diorhabda sublineata 1163346 Arthropoda Arthropoda 83.2 2.07e-16   NR XP_056638180.1 1163346 g44395 i0 49.4 2.10483870967742 87 39 99.2 1 1 246 99 185 XP_056638180.1 serine/threonine-protein kinase grp [Diorhabda sublineata] diamond 522 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diorhabda Diorhabda sublineata
27018994 27018994 PRJNA688736_P_NODE_37082_length_263_cov_1.000000_g36797_i0 PRJNA688736 37082 263 1 2.63 Diabrotica virgifera virgifera 50390 Arthropoda Arthropoda 80.1 1.66e-15   NR XP_028138895.1 50390 g36797 i0 74.4 1.95057034220532 39 10 44.5 0 239 123 288 326 XP_028138895.1 procathepsin L-like [Diabrotica virgifera virgifera] diamond 513 80.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Diabrotica Diabrotica virgifera
27113681 27113681 PRJNA688736_P_NODE_37162_length_262_cov_1.809524_g36877_i0 PRJNA688736 37162 262 1.809524 4.74095288 Oppia nitens 1686743 Arthropoda Arthropoda 116 4.35e-31   NR XP_054167156.1 1686743 g36877 i0 65.6 3.01145038167939 90 23 93.9 1 16 261 43 132 XP_054167156.1 60S ribosomal protein L35a-like [Oppia nitens] diamond 789 116 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppia Oppia nitens
27220005 27220005 PRJNA688736_P_NODE_45582_length_247_cov_0.896552_g45297_i0 PRJNA688736 45582 247 0.896552 2.21448344 Insecta 50557 Arthropoda Arthropoda 109 5.56e-26   NR CAB3512195.1 7109 g45297 i0 65.4 40.336032388664 81 28 98.4 0 2 244 42 122 CAB3512195.1 unnamed protein product [Spodoptera littoralis] diamond 9963 110 0.990909090909091 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Noctuidae Spodoptera Spodoptera littoralis
27504786 27504786 PRJNA688736_P_NODE_46563_length_246_cov_0.901734_g46278_i0 PRJNA688736 46563 246 0.901734 2.21826564 Arthropoda 6656 Arthropoda Arthropoda 86.7 1.06e-18   NR XP_065579952.1 6661 g46278 i0 47.4 4.48780487804878 76 36 92.7 1 233 6 2 73 XP_065579952.1 probable thiopurine S-methyltransferase isoform X2 [Artemia franciscana] diamond 1104 87 0.996551724137931 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Anostraca Artemiidae Artemia Artemia franciscana
28136233 28136233 PRJNA688736_P_NODE_20585_length_344_cov_3.627306_g20300_i0 PRJNA688736 20585 344 3.627306 12.47793264 Araneidae 6913 Arthropoda Arthropoda 139 2.6e-40   NR XP_055942678.1 94029 g20300 i0 77.3 4.20348837209302 97 22 84.6 0 1 291 10 106 XP_055942678.1 60S ribosomal protein L36-like [Argiope bruennichi] diamond 1446 139 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Argiope Argiope bruennichi
28408750 28408750 PRJNA688736_P_NODE_44086_length_249_cov_0.886364_g43801_i0 PRJNA688736 44086 249 0.886364 2.20704636 Anastatus japonicus 1890437 Arthropoda Arthropoda 64.3 1.01e-9   NR WKZ09232.1 1890437 g43801 i0 45.3 0.771084337349398 64 29 71.1 2 248 72 1057 1119 WKZ09232.1 VgR, partial [Anastatus japonicus] diamond 192 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Eupelmidae Anastatus Anastatus japonicus
28578155 28578155 PRJNA688736_P_NODE_48707_length_244_cov_0.912281_g48422_i0 PRJNA688736 48707 244 0.912281 2.22596564 Insecta 50557 Arthropoda Arthropoda 58.2 1.26e-8   NR PSN46147.1 6973 g48422 i0 42.9 1.90573770491803 77 42 92.2 1 237 13 4 80 PSN46147.1 hypothetical protein C0J52_22063 [Blattella germanica] diamond 465 58.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattellidae Blattella Blattella germanica
28693059 28693059 PRJNA688736_P_NODE_45687_length_247_cov_0.896552_g45402_i0 PRJNA688736 45687 247 0.896552 2.21448344 Nasonia vitripennis 7425 Arthropoda Arthropoda 43.5 0.0174   NR XP_001605379.1 7425 g45402 i0 67.9 0.340080971659919 28 9 34 0 245 162 207 234 XP_001605379.1 bax inhibitor 1 [Nasonia vitripennis] diamond 84 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Pteromalidae Nasonia Nasonia vitripennis
28818848 28818848 PRJNA688736_P_NODE_24728_length_319_cov_0.951220_g24443_i0 PRJNA688736 24728 319 0.95122 3.0343918 Centruroides sculpturatus 218467 Arthropoda Arthropoda 89.7 2.81e-18   NR XP_023237015.1 218467 g24443 i0 46.1 4.88087774294671 89 46 83.7 2 278 12 507 593 XP_023237015.1 uncharacterized protein LOC111636053 isoform X1 [Centruroides sculpturatus] diamond 1557 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Scorpiones Buthidae Centruroides Centruroides sculpturatus
28862137 28862137 PRJNA688736_P_NODE_32808_length_280_cov_1.396135_g32523_i0 PRJNA688736 32808 280 1.396135 3.909178 Ixodidae 6939 Arthropoda Arthropoda 138 5.78e-37   NR EEC00832.1 6945 g32523 i0 76.3 8.96785714285714 93 22 99.6 0 2 280 225 317 EEC00832.1 sorting nexin, putative [Ixodes scapularis] diamond 2511 139 0.992805755395683 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes scapularis
29746093 29746093 PRJNA688736_P_NODE_45470_length_247_cov_0.896552_g45185_i0 PRJNA688736 45470 247 0.896552 2.21448344 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 1.57e-24   NR ROT79987.1 6689 g45185 i0 67.1 14.9392712550607 82 26 99.6 1 247 2 211 291 ROT79987.1 hypothetical protein C7M84_001258 [Penaeus vannamei] diamond 3690 103 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
29955902 29955902 PRJNA688736_P_NODE_36611_length_264_cov_2.130890_g36326_i0 PRJNA688736 36611 264 2.13089 5.6255496 Tigriopus californicus 6832 Arthropoda Arthropoda 69.7 4.6e-12   NR XP_059083140.1 6832 g36326 i0 47.3 0.840909090909091 74 38 84.1 1 236 15 56 128 XP_059083140.1 hematopoietic prostaglandin D synthase-like [Tigriopus californicus] diamond 222 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
29987517 29987517 PRJNA688736_P_NODE_50071_length_243_cov_0.917647_g49786_i0 PRJNA688736 50071 243 0.917647 2.22988221 Darwinula stevensoni 69355 Arthropoda Arthropoda 79.7 7.35e-16   NR CAD7251128.1 69355 g49786 i0 56.8 1 81 35 100 0 243 1 85 165 CAD7251128.1 unnamed protein product [Darwinula stevensoni] diamond 243 79.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Darwinulidae Darwinula Darwinula stevensoni
30050528 30050528 PRJNA688736_P_NODE_35851_length_267_cov_1.788660_g35566_i0 PRJNA688736 35851 267 1.78866 4.7757222 Condylostylus longicornis 2530218 Arthropoda Arthropoda 157 5.4699999999999995e-45   NR XP_055388387.1 2530218 g35566 i0 86.4 0.98876404494382 88 12 98.9 0 2 265 159 246 XP_055388387.1 ribose-phosphate pyrophosphokinase-like [Condylostylus longicornis] diamond 264 157 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Dolichopodidae Condylostylus Condylostylus longicornis
30082106 30082106 PRJNA688736_P_NODE_41312_length_252_cov_0.871508_g41027_i0 PRJNA688736 41312 252 0.871508 2.19620016 Allacma fusca 39272 Arthropoda Arthropoda 90.5 2.59e-19   NR CAG7719944.1 39272 g41027 i0 49.4 1.97619047619048 83 42 98.8 0 1 249 28 110 CAG7719944.1 unnamed protein product [Allacma fusca] diamond 498 90.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Symphypleona Sminthuridae Allacma Allacma fusca
30208368 30208368 PRJNA688736_P_NODE_47192_length_245_cov_2.395349_g46907_i0 PRJNA688736 47192 245 2.395349 5.86860505 Limulus polyphemus 6850 Arthropoda Arthropoda 110 7.76e-26   NR XP_022246373.1 6850 g46907 i0 66.2 14.1183673469388 77 24 94.3 1 231 1 45 119 XP_022246373.1 LOW QUALITY PROTEIN: talin-1-like [Limulus polyphemus] diamond 3459 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
30378560 30378560 PRJNA688736_P_NODE_27152_length_306_cov_1.047210_g26867_i0 PRJNA688736 27152 306 1.04721 3.2044626 Arthropoda 6656 Arthropoda Arthropoda 126 2.6799999999999996e-32   NR XP_013785551.1 6850 g26867 i0 63.5 17.8333333333333 96 35 94.1 0 1 288 190 285 XP_013785551.1 nucleosome assembly protein 1-like 1-B [Limulus polyphemus] diamond 5457 126 1 Eukaryota Opisthokonta Metazoa Arthropoda Merostomata Xiphosura Limulidae Limulus Limulus polyphemus
31757404 31757404 PRJNA688736_P_NODE_30437_length_290_cov_1.576037_g30152_i0 PRJNA688736 30437 290 1.576037 4.5705073 Cotesia chilonis 89804 Arthropoda Arthropoda 137 2.56e-38   NR QBB02043.1 89804 g30152 i0 77.8 6.20689655172414 81 18 83.8 0 245 3 48 128 QBB02043.1 putative peptidyl-prolyl cis-trans isomerase-like, partial [Cotesia chilonis] diamond 1800 137 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia chilonis
31852190 31852190 PRJNA688736_P_NODE_45517_length_247_cov_0.896552_g45232_i0 PRJNA688736 45517 247 0.896552 2.21448344 Petrolisthes cinctipes 88211 Arthropoda Arthropoda 59.3 5.61e-8   NR KAK3856540.1 88211 g45232 i0 56.1 1.61538461538462 57 25 69.2 0 172 2 414 470 KAK3856540.1 hypothetical protein Pcinc_037149 [Petrolisthes cinctipes] diamond 399 59.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Porcellanidae Petrolisthes Petrolisthes cinctipes
32768795 32768795 PRJNA688736_P_NODE_33540_length_277_cov_1.387255_g33255_i0 PRJNA688736 33540 277 1.387255 3.84269635 Bradysia coprophila 38358 Arthropoda Arthropoda 45.1 0.00827   NR XP_037045353.1 38358 g33255 i0 33.3 0.779783393501805 72 43 76.9 2 233 21 3 70 XP_037045353.1 prestalk protein-like [Bradysia coprophila] diamond 216 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila

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