RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1227535" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1227535 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
20736817 20736817 PRJNA1227535_P_NODE_26917_length_246_cov_2.959538_g26793_i0 PRJNA1227535 26917 246 2.959538 7.28046348 Coleoptera 7041 Arthropoda Arthropoda 82.8 3.05e-16   NR XP_044766292.1 41139 g26793 i0 54.1 3.64634146341463 74 33 90.2 1 245 24 938 1010 XP_044766292.1 uncharacterized protein LOC123322410 [Coccinella septempunctata] diamond 897 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
26788057 26788057 PRJNA1227535_P_NODE_30081_length_243_cov_0.917647_g29957_i0 PRJNA1227535 30081 243 0.917647 2.22988221 Contarinia nasturtii 265458 Arthropoda Arthropoda 48.9 2.53e-4   NR XP_031623911.1 265458 g29957 i0 66.7 1.40740740740741 27 9 33.3 0 93 13 324 350 XP_031623911.1 zinc finger CCHC domain-containing protein 7-like [Contarinia nasturtii] diamond 342 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Cecidomyiidae Contarinia Contarinia nasturtii
27452208 27452208 PRJNA1227535_P_NODE_33563_length_218_cov_4.482759_g33439_i0 PRJNA1227535 33563 218 4.482759 9.77241462 Linepithema humile 83485 Arthropoda Arthropoda 130 1.31e-36   NR XP_067210080.1 83485 g33439 i0 77.5 1.95412844036697 71 16 97.7 0 5 217 69 139 XP_067210080.1 histone-lysine N-methyltransferase SETMAR-like [Linepithema humile] diamond 426 130 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Linepithema Linepithema humile
27483551 27483551 PRJNA1227535_P_NODE_7843_length_312_cov_2.548117_g7720_i0 PRJNA1227535 7843 312 2.548117 7.95012504 Panonychus citri 50023 Arthropoda Arthropoda 73.6 1.22e-12   NR XP_053200629.1 50023 g7720 i0 54.8 0.807692307692308 84 35 78.8 2 3 248 495 577 XP_053200629.1 nucleolar protein 14-like [Panonychus citri] diamond 252 73.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
27767942 27767942 PRJNA1227535_P_NODE_29204_length_244_cov_0.912281_g29080_i0 PRJNA1227535 29204 244 0.912281 2.22596564 Parasacculina yatsui 2836420 Arthropoda Arthropoda 89.4 2.59e-20   NR UEK51488.1 2836420 g29080 i0 62.9 0.860655737704918 70 26 86.1 0 35 244 1 70 UEK51488.1 HOX-like protein 2, partial [Parasacculina yatsui] diamond 210 89.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca   Polyascidae Parasacculina Parasacculina yatsui
27944391 27944391 PRJNA1227535_P_NODE_10165_length_292_cov_1.237443_g10042_i0 PRJNA1227535 10165 292 1.237443 3.61333356 Chironomus 7150 Arthropoda Arthropoda 91.3 5.41e-19   NR XP_070502689.1 113505 g10042 i0 75.9 1.10958904109589 54 13 55.5 0 292 131 460 513 XP_070502689.1 ubiquitin carboxyl-terminal hydrolase MINDY-3 homolog [Chironomus tepperi] diamond 324 91.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
29207450 29207450 PRJNA1227535_P_NODE_11289_length_288_cov_1.372093_g11166_i0 PRJNA1227535 11289 288 1.372093 3.95162784 Arthropoda 6656 Arthropoda Arthropoda 83.2 3.8e-16   NR XP_044747737.1 41139 g11166 i0 68.2 8.10416666666667 66 18 67.7 2 195 1 6 69 XP_044747737.1 probable methylmalonate-semialdehyde dehydrogenase [acylating], mitochondrial [Coccinella septempunctata] diamond 2334 83.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Coccinella Coccinella septempunctata
29440842 29440842 PRJNA1227535_P_NODE_11390_length_287_cov_2.967290_g11267_i0 PRJNA1227535 11390 287 2.96729 8.5161223 Schistocerca nitens 7011 Arthropoda Arthropoda 64.7 1.14e-9   NR XP_049808976.1 7011 g11267 i0 45.7 0.731707317073171 70 36 72.1 2 81 287 345 413 XP_049808976.1 stromelysin-1-like [Schistocerca nitens] diamond 210 64.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Orthoptera Acrididae Schistocerca Schistocerca nitens
29883400 29883400 PRJNA1227535_P_NODE_22831_length_252_cov_0.871508_g22707_i0 PRJNA1227535 22831 252 0.871508 2.19620016 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 105 4.74e-24   NR KAH9407772.1 59818 g22707 i0 100 0.619047619047619 52 0 61.9 0 63 218 14 65 KAH9407772.1 hypothetical protein TYRP_012595 [Tyrophagus putrescentiae] diamond 156 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30167387 30167387 PRJNA1227535_P_NODE_21032_length_255_cov_2.104396_g20908_i0 PRJNA1227535 21032 255 2.104396 5.3662098 Clunio marinus 568069 Arthropoda Arthropoda 45.1 0.00658   NR CRL04832.1 568069 g20908 i0 95.7 0.270588235294118 23 1 27.1 0 34 102 157 179 CRL04832.1 CLUMA_CG017885, isoform A [Clunio marinus] diamond 69 45.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
30344836 30344836 PRJNA1227535_P_NODE_6452_length_312_cov_3.355649_g6329_i0 PRJNA1227535 6452 312 3.355649 10.46962488 Syrphidae 34680 Arthropoda Arthropoda 72 4.35e-12   NR XP_055837555.1 286459 g6329 i0 62 3.83653846153846 50 19 48.1 0 312 163 51 100 XP_055837555.1 dynein regulatory complex subunit 2 [Episyrphus balteatus] diamond 1197 72 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Syrphidae Episyrphus Episyrphus balteatus
30357624 30357624 PRJNA1227535_P_NODE_24152_length_250_cov_0.881356_g24028_i0 PRJNA1227535 24152 250 0.881356 2.20339 Odynerus spinipes 1348599 Arthropoda Arthropoda 46.2 0.00207   NR KAK2575428.1 1348599 g24028 i0 40.7 0.972 81 32 86.4 3 1 216 88 161 KAK2575428.1 hypothetical protein KPH14_008337 [Odynerus spinipes] diamond 243 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Odynerus Odynerus spinipes
30389124 30389124 PRJNA1227535_P_NODE_13393_length_280_cov_3.396135_g13270_i0 PRJNA1227535 13393 280 3.396135 9.509178 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 48.9 3.52e-4   NR RWS16504.1 1965070 g13270 i0 58.3 0.385714285714286 36 15 38.6 0 279 172 233 268 RWS16504.1 outer dense fiber protein 3-like protein [Dinothrombium tinctorium] diamond 108 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
30389126 30389126 PRJNA1227535_P_NODE_6293_length_312_cov_3.502092_g6170_i0 PRJNA1227535 6293 312 3.502092 10.92652704 Lucilia cuprina 7375 Arthropoda Arthropoda 49.7 1.55e-5   NR KAI8117165.1 7375 g6170 i0 100 0.519230769230769 23 0 22.1 0 211 279 34 56 KAI8117165.1 Mitochondrial folate transporter/carrier [Lucilia cuprina] diamond 162 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Calliphoridae Lucilia Lucilia cuprina
30641315 30641315 PRJNA1227535_P_NODE_22893_length_252_cov_0.871508_g22769_i0 PRJNA1227535 22893 252 0.871508 2.19620016 Araneus ventricosus 182803 Arthropoda Arthropoda 61.6 1.26e-9   NR GBN98214.1 182803 g22769 i0 43.8 0.952380952380952 80 37 95.2 2 240 1 25 96 GBN98214.1 hypothetical protein AVEN_149174-1 [Araneus ventricosus] diamond 240 61.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30831013 30831013 PRJNA1227535_P_NODE_12994_length_282_cov_1.449761_g12871_i0 PRJNA1227535 12994 282 1.449761 4.08832602 Psylliodes chrysocephala 3402493 Arthropoda Arthropoda 69.7 1.96e-11   NR CAH1114773.1 2598218 g12871 i0 34.1 0.968085106382979 91 60 96.8 0 9 281 263 353 CAH1114773.1 unnamed protein product [Psylliodes chrysocephala] diamond 273 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Chrysomelidae Psylliodes Psylliodes chrysocephala
31355580 31355580 PRJNA1227535_P_NODE_1756_length_496_cov_2.380615_g1634_i0 PRJNA1227535 1756 496 2.380615 11.8078504 root 1 Root_unresolved Root_unresolved 53.1 1.2e-4   NR GBN61280.1 182803 g1634 i0 50.9 2.95161290322581 53 26 32.1 0 385 227 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
32095861 32095861 PRJNA1227535_P_NODE_27438_length_246_cov_0.901734_g27314_i0 PRJNA1227535 27438 246 0.901734 2.21826564 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 134 3.2399999999999993e-34   NR KAG5677167.1 319348 g27314 i0 79 0.98780487804878 81 17 98.8 0 3 245 785 865 KAG5677167.1 hypothetical protein PVAND_006948 [Polypedilum vanderplanki] diamond 243 134 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
32872483 32872483 PRJNA1227535_P_NODE_6060_length_312_cov_3.874477_g5937_i0 PRJNA1227535 6060 312 3.874477 12.08836824 Arthropoda 6656 Arthropoda Arthropoda 99.4 1.09e-21   NR XP_046917860.1 6954 g5937 i0 82 42.7884615384615 50 9 48.1 0 1 150 319 368 XP_046917860.1 DNA-binding protein P3A2-like isoform X2 [Dermatophagoides farinae] diamond 13350 99.8 0.995991983967936 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae

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