RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA309466 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
20778319 20778319 PRJNA309466_P_NODE_13497_length_178_cov_2.387597_g13440_i0 PRJNA309466 13497 178 2.387597 4.24992266 Atta colombica 520822 Arthropoda Arthropoda 60.8 6.45e-9   NR XP_018054398.1 520822 g13440 i0 83.3 0.707865168539326 42 7 70.8 0 139 14 838 879 XP_018054398.1 PREDICTED: LOW QUALITY PROTEIN: structural maintenance of chromosomes protein 3 [Atta colombica] diamond 126 60.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Atta Atta colombica
24602805 24602805 PRJNA309466_P_NODE_10640_length_195_cov_2.061644_g10583_i0 PRJNA309466 10640 195 2.061644 4.0202058 Odontomachus brunneus 486640 Arthropoda Arthropoda 119 3.05e-29   NR XP_032666690.1 486640 g10583 i0 88.9 41.6769230769231 63 7 96.9 0 4 192 2293 2355 XP_032666690.1 inositol 1,4,5-trisphosphate receptor isoform X3 [Odontomachus brunneus] diamond 8127 119 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Odontomachus Odontomachus brunneus
26757596 26757596 PRJNA309466_P_NODE_11461_length_189_cov_6.850000_g11404_i0 PRJNA309466 11461 189 6.85 12.9465 Prorops nasuta 863751 Arthropoda Arthropoda 101 8.87e-25   NR XP_066596486.1 863751 g11404 i0 76.2 5 63 15 100 0 1 189 99 161 XP_066596486.1 ferritin heavy chain isoform X1 [Prorops nasuta] diamond 945 101 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta
27674700 27674700 PRJNA309466_P_NODE_18284_length_161_cov_939894.116071_g18227_i0 PRJNA309466 18284 161 939894.116071 1513229.52687431 Vollenhovia emeryi 411798 Arthropoda Arthropoda 42.7 0.00531   NR XP_011861148.1 411798 g18227 i0 85.7 0.391304347826087 21 3 39.1 0 45 107 27 47 XP_011861148.1 PREDICTED: histone H2A-like [Vollenhovia emeryi] diamond 63 42.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Formicidae Vollenhovia Vollenhovia emeryi
28716529 28716529 PRJNA309466_P_NODE_17047_length_164_cov_246513.686957_g16990_i0 PRJNA309466 17047 164 246513.686957 404282.44660948 Eumeta japonica 151549 Arthropoda Arthropoda 44.7 0.00264   NR GBP52952.1 151549 g16990 i0 81 1.20731707317073 21 4 38.4 0 101 39 135 155 GBP52952.1 hypothetical protein EVAR_47607_1 [Eumeta japonica] diamond 198 45.1 0.991130820399113 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Psychidae Eumeta Eumeta japonica
28765481 28765481 PRJNA309466_P_NODE_17127_length_164_cov_2.521739_g17070_i0 PRJNA309466 17127 164 2.521739 4.13565196 Hymenoptera 7399 Arthropoda Arthropoda 50.8 1.79e-5   NR XP_043676134.1 30213 g17070 i0 47.2 3.93292682926829 53 25 91.5 1 6 155 1935 1987 XP_043676134.1 vacuolar protein sorting-associated protein 13 isoform X3 [Vespula pensylvanica] diamond 645 50.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula pensylvanica
29442388 29442388 PRJNA309466_P_NODE_19830_length_151_cov_388587.627451_g19773_i0 PRJNA309466 19830 151 388587.627451 586767.31745101 Aedes aegypti 7159 Arthropoda Arthropoda 47 9.48e-5   NR XP_021696082.1 7159 g19773 i0 90.9 1.09271523178808 22 2 43.7 0 38 103 100 121 XP_021696082.1 histone H3-like [Aedes aegypti] diamond 165 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Aedes Aedes aegypti
29789789 29789789 PRJNA309466_P_NODE_18531_length_160_cov_2.720721_g18474_i0 PRJNA309466 18531 160 2.720721 4.3531536 Microplitis demolitor 69319 Arthropoda Arthropoda 112 3.520000000000001e-27   NR XP_053597377.1 69319 g18474 i0 94.3 5.9625 53 3 99.4 0 160 2 263 315 XP_053597377.1 glycerol-3-phosphate dehydrogenase, mitochondrial isoform X2 [Microplitis demolitor] diamond 954 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Braconidae Microplitis Microplitis demolitor
31085328 31085328 PRJNA309466_P_NODE_10715_length_194_cov_3143.820690_g10658_i0 PRJNA309466 10715 194 3143.82069 6099.0121386 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 43.1 0.0146   NR RWS09620.1 1965070 g10658 i0 45.7 0.711340206185567 46 25 71.1 0 166 29 347 392 RWS09620.1 uncharacterized protein B4U79_17676 [Dinothrombium tinctorium] diamond 138 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
32002495 32002495 PRJNA309466_P_NODE_18618_length_159_cov_4.345455_g18561_i0 PRJNA309466 18618 159 4.345455 6.90927345 Periplaneta americana 6978 Arthropoda Arthropoda 48.1 1.29e-4   NR KAJ4429891.1 6978 g18561 i0 57.6 23.0566037735849 33 14 62.3 0 3 101 71 103 KAJ4429891.1 hypothetical protein ANN_22095 [Periplaneta americana] diamond 3666 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
32350720 32350720 PRJNA309466_P_NODE_13899_length_176_cov_2.401575_g13842_i0 PRJNA309466 13899 176 2.401575 4.226772 Prorops nasuta 863751 Arthropoda Arthropoda 43.1 0.0114   NR XP_066597229.1 863751 g13842 i0 54.3 1.19318181818182 35 16 59.7 0 146 42 1349 1383 XP_066597229.1 uncharacterized protein [Prorops nasuta] diamond 210 43.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Bethylidae Prorops Prorops nasuta

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