RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA492280" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA492280 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
26680790 26680790 PRJNA492280_P_NODE_24141_length_164_cov_2.708661_g24034_i0 PRJNA492280 24141 164 2.708661 4.44220404 root 1 Root_unresolved Root_unresolved 49.3 6.15e-5   NR XP_044591021.1 32391 g24034 i0 84 6.78658536585366 25 4 45.7 0 2 76 327 351 XP_044591021.1 acetyl-CoA acetyltransferase, cytosolic [Cotesia glomerata] diamond 1113 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Cotesia Cotesia glomerata
26791663 26791663 PRJNA492280_P_NODE_24641_length_164_cov_2.637795_g24534_i0 PRJNA492280 24641 164 2.637795 4.3259838 Rhagoletis pomonella 28610 Arthropoda Arthropoda 70.9 1.54e-12   NR XP_036327461.1 28610 g24534 i0 58.6 2.1219512195122 58 18 95.1 1 7 162 669 726 XP_036327461.1 uncharacterized protein LOC118740074 [Rhagoletis pomonella] diamond 348 70.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis pomonella
27834405 27834405 PRJNA492280_P_NODE_25604_length_164_cov_2.425197_g25497_i0 PRJNA492280 25604 164 2.425197 3.97732308 Penaeus vannamei 6689 Arthropoda Arthropoda 42.4 0.0179   NR XP_069990679.1 6689 g25497 i0 88.9 1.04268292682927 18 2 32.9 0 5 58 1517 1534 XP_069990679.1 uncharacterized protein [Penaeus vannamei] diamond 171 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
27992495 27992495 PRJNA492280_P_NODE_16185_length_164_cov_4.173228_g16078_i0 PRJNA492280 16185 164 4.173228 6.84409392 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 51.2 1.3e-5   NR KAH9406654.1 59818 g16078 i0 96 0.457317073170732 25 1 45.7 0 1 75 552 576 KAH9406654.1 hypothetical protein TYRP_013637 [Tyrophagus putrescentiae] diamond 75 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28055390 28055390 PRJNA492280_P_NODE_31805_length_151_cov_2.745614_g31698_i0 PRJNA492280 31805 151 2.7456140000000002 4.14587714 Eurytemora carolleeae 1294199 Arthropoda Arthropoda 51.6 5.65e-6   NR XP_023327384.1 1294199 g31698 i0 45.5 6.05960264900662 44 24 87.4 0 136 5 180 223 XP_023327384.1 uncharacterized protein LOC111700633 [Eurytemora carolleeae] diamond 915 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Calanoida Temoridae Eurytemora Eurytemora carolleeae
28513570 28513570 PRJNA492280_P_NODE_21827_length_164_cov_3.000000_g21720_i0 PRJNA492280 21827 164 3 4.92 Orchesella 48705 Arthropoda Arthropoda 48.9 8.56e-5   NR ODM95243.1 48709 g21720 i0 88 1.8109756097561 25 3 45.7 0 2 76 440 464 ODM95243.1 Multidrug resistance-associated protein 1 [Orchesella cincta] diamond 297 49.3 0.991886409736308 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
28703108 28703108 PRJNA492280_P_NODE_34507_length_150_cov_3.000000_g34400_i0 PRJNA492280 34507 150 3 4.5 Muscidae 7366 Arthropoda Arthropoda 46.2 6.37e-4   NR XP_058978795.1 7370 g34400 i0 75 2.4 24 6 48 0 4 75 179 202 XP_058978795.1 calreticulin [Musca domestica] diamond 360 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Musca Musca domestica
28987411 28987411 PRJNA492280_P_NODE_22188_length_164_cov_2.968504_g22081_i0 PRJNA492280 22188 164 2.968504 4.86834656 Metazoa 33208 Arthropoda Arthropoda 46.6 5.47e-4   NR XP_059223477.1 35570 g22081 i0 84 5.98170731707317 25 4 45.7 0 163 89 107 131 XP_059223477.1 uncharacterized protein K02A2.6-like [Stomoxys calcitrans] diamond 981 47 0.991489361702128 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Muscidae Stomoxys Stomoxys calcitrans
29081984 29081984 PRJNA492280_P_NODE_18908_length_164_cov_3.519685_g18801_i0 PRJNA492280 18908 164 3.519685 5.7722834 Arthropoda 6656 Arthropoda Arthropoda 43.9 0.00498   NR XP_063222713.1 93214 g18801 i0 78.3 6.76829268292683 23 5 42.1 0 89 157 359 381 XP_063222713.1 RNA-binding protein 42 isoform X2 [Bacillus rossius redtenbacheri] diamond 1110 43.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Bacillidae Bacillus Bacillus rossius
29081987 29081987 PRJNA492280_P_NODE_23168_length_164_cov_2.842520_g23061_i0 PRJNA492280 23168 164 2.84252 4.6617328 Diptera 7147 Arthropoda Arthropoda 48.5 1.12e-4   NR XP_062535392.1 124917 g23061 i0 95.8 1.31707317073171 24 1 43.9 0 75 4 70 93 XP_062535392.1 exosome complex component RRP41-like [Armigeres subalbatus] diamond 216 48.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Armigeres Armigeres subalbatus
29271133 29271133 PRJNA492280_P_NODE_30109_length_151_cov_4.877193_g30002_i0 PRJNA492280 30109 151 4.877193 7.36456143 Diptera 7147 Arthropoda Arthropoda 54.3 8.89e-7   NR XP_004518408.1 7213 g30002 i0 100 34.0728476821192 24 0 47.7 0 148 77 533 556 XP_004518408.1 homeotic protein female sterile isoform X1 [Ceratitis capitata] diamond 5145 54.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
29981629 29981629 PRJNA492280_P_NODE_29471_length_151_cov_8.271930_g29364_i0 PRJNA492280 29471 151 8.27193 12.4906143 Halotydeus destructor 2874060 Arthropoda Arthropoda 48.1 1.34e-4   NR KAI1303134.1 2874060 g29364 i0 42.9 1.39072847682119 70 18 97.4 3 150 4 498 566 KAI1303134.1 Coagulation factor X [Halotydeus destructor] diamond 210 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
30566008 30566008 PRJNA492280_P_NODE_24873_length_164_cov_2.590551_g24766_i0 PRJNA492280 24873 164 2.590551 4.24850364 Arthropoda 6656 Arthropoda Arthropoda 77.8 7.37e-16   NR XP_017461387.1 28612 g24766 i0 77.8 2.30487804878049 63 5 98.8 1 163 2 49 111 XP_017461387.1 PREDICTED: ATPase family AAA domain-containing protein 3-A-like, partial [Rhagoletis zephyria] diamond 378 77.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
30803043 30803043 PRJNA492280_P_NODE_28554_length_155_cov_1.838983_g28447_i0 PRJNA492280 28554 155 1.838983 2.85042365 Anthophora plagiata 597819 Arthropoda Arthropoda 43.1 0.00818   NR CAK9813121.1 597819 g28447 i0 48.6 3.34838709677419 35 18 67.7 0 48 152 222 256 CAK9813121.1 Transposable element Tc1 transposase [Anthophora plagiata] diamond 519 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Anthophora Anthophora plagiata
31340349 31340349 PRJNA492280_P_NODE_33156_length_150_cov_4.362832_g33049_i0 PRJNA492280 33156 150 4.362832 6.544248 Cimex lectularius 79782 Arthropoda Arthropoda 41.2 0.0379   NR XP_014244694.1 79782 g33049 i0 52.3 0.88 44 17 80 1 123 4 172 215 XP_014244694.1 protein LTV1 homolog [Cimex lectularius] diamond 132 41.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Cimicidae Cimex Cimex lectularius
31672597 31672597 PRJNA492280_P_NODE_26377_length_163_cov_13.396825_g26270_i0 PRJNA492280 26377 163 13.396825 21.83682475 Arachnida 6854 Arthropoda Arthropoda 76.3 1.94e-14   NR KAH7637540.1 6954 g26270 i0 73.1 3.88343558282209 52 14 95.7 0 8 163 910 961 KAH7637540.1 c2 domain-containing protein [Dermatophagoides farinae] diamond 633 77 0.990909090909091 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides farinae
31909716 31909716 PRJNA492280_P_NODE_23717_length_164_cov_2.771654_g23610_i0 PRJNA492280 23717 164 2.771654 4.54551256 Halotydeus destructor 2874060 Arthropoda Arthropoda 42 0.0242   NR KAI1290044.1 2874060 g23610 i0 37 0.98780487804878 54 18 98.8 1 164 3 427 464 KAI1290044.1 Pancreatic triacylglycerol lipase [Halotydeus destructor] diamond 162 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
31957280 31957280 PRJNA492280_P_NODE_26037_length_164_cov_2.244094_g25930_i0 PRJNA492280 26037 164 2.244094 3.68031416 Diptera 7147 Arthropoda Arthropoda 52.8 3.71e-6   NR XP_053958698.1 28586 g25930 i0 92 4.97560975609756 25 2 45.7 0 163 89 665 689 XP_053958698.1 vacuolar protein sorting-associated protein 53 homolog [Anastrepha ludens] diamond 816 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Anastrepha Anastrepha ludens
32226279 32226279 PRJNA492280_P_NODE_24998_length_164_cov_2.566929_g24891_i0 PRJNA492280 24998 164 2.566929 4.20976356 Oppiella nova 334625 Arthropoda Arthropoda 45.4 5.67e-4   NR CAD7655861.1 334625 g24891 i0 95.5 1.42682926829268 22 1 40.2 0 12 77 88 109 CAD7655861.1 unnamed protein product [Oppiella nova] diamond 234 45.8 0.991266375545852 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Oppiidae Oppiella Oppiella nova
32621517 32621517 PRJNA492280_P_NODE_14420_length_164_cov_4.834646_g14313_i0 PRJNA492280 14420 164 4.834646 7.92881944 Diptera 7147 Arthropoda Arthropoda 53.5 1.99e-6   NR XP_004523018.1 7213 g14313 i0 96 5.94512195121951 25 1 45.7 0 164 90 1366 1390 XP_004523018.1 disco-interacting protein 2 isoform X1 [Ceratitis capitata] diamond 975 53.9 0.992578849721707 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Ceratitis Ceratitis capitata
32857475 32857475 PRJNA492280_P_NODE_14640_length_164_cov_4.724409_g14533_i0 PRJNA492280 14640 164 4.724409 7.74803076 Leptotrombidium deliense 299467 Arthropoda Arthropoda 42 0.0245   NR RWS30132.1 299467 g14533 i0 51.1 1.64634146341463 45 16 71.3 1 117 1 617 661 RWS30132.1 protein unc-79-like protein [Leptotrombidium deliense] diamond 270 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense

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