RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 19 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA315314 · 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
7443250 7443250 PRJNA315314_S_NODE_30786_length_153_cov_3.177419_g30465_i0 PRJNA315314 30786 153 3.177419 4.86145107 Metazoa 33208 Chordata Chordata 91.7 1.95e-21   NR XP_064416805.1 7897 g30465 i0 85.7 34.6078431372549 49 7 96.1 0 6 152 12 60 XP_064416805.1 peroxiredoxin-2 [Latimeria chalumnae] diamond 5295 92 0.996739130434783 Eukaryota Opisthokonta Metazoa Chordata   Coelacanthiformes Coelacanthidae Latimeria Latimeria chalumnae
13134610 13134610 PRJNA315314_S_NODE_26551_length_163_cov_2.552239_g26230_i0 PRJNA315314 26551 163 2.552239 4.16014957 Opisthokonta 33154 Chordata Chordata 60.5 1.22e-9   NR CAI9564122.1 386267 g26230 i0 96.3 2.98159509202454 27 1 49.7 0 163 83 114 140 CAI9564122.1 unnamed protein product [Staurois parvus] diamond 486 60.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
23332839 23332839 PRJNA315314_S_NODE_21779_length_178_cov_1.845638_g21458_i0 PRJNA315314 21779 178 1.845638 3.28523564 Lepidosauria 8504 Chordata Chordata 81.6 2.94e-16   NR XP_005998465.1 7897 g21458 i0 70.2 13.4494382022472 57 17 96.1 0 3 173 291 347 XP_005998465.1 bifunctional glutamate/proline--tRNA ligase [Latimeria chalumnae] diamond 2394 81.6 1 Eukaryota Opisthokonta Metazoa Chordata   Coelacanthiformes Coelacanthidae Latimeria Latimeria chalumnae
26617029 26617029 PRJNA315314_S_NODE_1701_length_597_cov_6.441901_g1435_i0 PRJNA315314 1701 597 6.441901 38.45814897 Mammalia 40674 Chordata Chordata 110 1.56e-24   NR XP_049711765.1 99487 g1435 i0 34.3 4.34673366834171 172 104 86.4 2 595 80 302 464 XP_049711765.1 prosaposin isoform X2 [Elephas maximus indicus] diamond 2595 111 0.990990990990991 Eukaryota Opisthokonta Metazoa Chordata Mammalia Proboscidea Elephantidae Elephas Elephas maximus
27010969 27010969 PRJNA315314_S_NODE_16802_length_200_cov_9.076023_g16481_i0 PRJNA315314 16802 200 9.076023 18.152046 Leucoraja erinaceus 7782 Chordata Chordata 61.2 6.24e-9   NR XP_055486636.1 7782 g16481 i0 47.1 1.02 68 33 97.5 1 4 198 43 110 XP_055486636.1 carboxy-terminal kinesin 2-like [Leucoraja erinaceus] diamond 204 61.2 1 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Rajiformes Rajidae Leucoraja Leucoraja erinaceus
27786987 27786987 PRJNA315314_S_NODE_18364_length_192_cov_6.073620_g18043_i0 PRJNA315314 18364 192 6.07362 11.6613504 root 1 Root_unresolved Root_unresolved 129 4.65e-34   NR XP_036010302.1 10090 g18043 i0 100 20.671875 63 0 98.4 0 3 191 52 114 XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus] diamond 3969 129 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
28039472 28039472 PRJNA315314_S_NODE_9825_length_258_cov_8.524017_g9504_i0 PRJNA315314 9825 258 8.524017 21.99196386 root 1 Root_unresolved Root_unresolved 185 1.11e-53   NR XP_030110853.2 10090 g9504 i0 100 16 86 0 100 0 1 258 157 242 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 4128 185 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
28639498 28639498 PRJNA315314_S_NODE_8387_length_279_cov_4.228000_g8066_i0 PRJNA315314 8387 279 4.228 11.79612 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 158 8.919999999999999e-48   NR 3J0L_S 9986 g8066 i0 89.4 2.02150537634409 94 9 100 1 1 279 5 98 3J0L_S Chain S, Ribosomal protein S15 [Oryctolagus cuniculus] diamond 564 158 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Lagomorpha Leporidae Oryctolagus Oryctolagus cuniculus
28653441 28653441 PRJNA315314_S_NODE_4587_length_374_cov_3.075362_g4266_i0 PRJNA315314 4587 374 3.075362 11.50185388 Oryctolagus cuniculus 9986 Chordata Chordata 45.4 0.0155   NR XP_002723759.2 9986 g4266 i0 40.4 0.377005347593583 47 28 37.7 0 227 367 127 173 XP_002723759.2 olfactory receptor 7A17-like [Oryctolagus cuniculus] diamond 141 45.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Lagomorpha Leporidae Oryctolagus Oryctolagus cuniculus
29333940 29333940 PRJNA315314_S_NODE_6329_length_321_cov_2.595890_g6008_i0 PRJNA315314 6329 321 2.59589 8.3328069 Anura 8342 Chordata Chordata 80.5 1.53e-16   NR KAG9490609.1 57060 g6008 i0 39.8 5.29906542056075 98 55 89.7 2 312 25 53 148 KAG9490609.1 hypothetical protein GDO78_006107 [Eleutherodactylus coqui] diamond 1701 80.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Eleutherodactylidae Eleutherodactylus Eleutherodactylus coqui
29631865 29631865 PRJNA315314_S_NODE_30930_length_153_cov_2.129032_g30609_i0 PRJNA315314 30930 153 2.129032 3.25741896 Psammomys obesus 48139 Chordata Chordata 63.2 2.68e-11   NR XP_055480731.1 48139 g30609 i0 63.3 0.96078431372549 49 18 96.1 0 147 1 12 60 XP_055480731.1 cystatin-A-like [Psammomys obesus] diamond 147 63.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Psammomys Psammomys obesus
29758325 29758325 PRJNA315314_S_NODE_13671_length_221_cov_1.770833_g13350_i0 PRJNA315314 13671 221 1.770833 3.91354093 Ranitomeya imitator 111125 Chordata Chordata 70.1 5.79e-12   NR CAJ0964204.1 111125 g13350 i0 73 1.52036199095023 37 10 50.2 0 139 29 15 51 CAJ0964204.1 unnamed protein product [Ranitomeya imitator] diamond 336 70.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
30060100 30060100 PRJNA315314_S_NODE_23891_length_171_cov_1.887324_g23570_i0 PRJNA315314 23891 171 1.887324 3.22732404 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 107 2.45e-25   NR XP_067977688.1 7769 g23570 i0 91.1 2.94736842105263 56 5 98.2 0 170 3 310 365 XP_067977688.1 nucleolar protein 58 isoform X2 [Myxine glutinosa] diamond 504 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Chordata Myxini Myxiniformes Myxinidae Myxine Myxine glutinosa
30168913 30168913 PRJNA315314_S_NODE_17052_length_199_cov_2.764706_g16731_i0 PRJNA315314 17052 199 2.764706 5.50176494 Ranitomeya imitator 111125 Chordata Chordata 45.8 0.00175   NR CAJ0932586.1 111125 g16731 i0 67.7 0.467336683417085 31 7 42.2 1 147 64 846 876 CAJ0932586.1 unnamed protein product [Ranitomeya imitator] diamond 93 45.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
30422296 30422296 PRJNA315314_S_NODE_26553_length_163_cov_2.529851_g26232_i0 PRJNA315314 26553 163 2.529851 4.12365713 Ranitomeya imitator 111125 Chordata Chordata 50.1 3.2e-5   NR XP_069591853.1 111125 g26232 i0 63.3 0.552147239263804 30 11 55.2 0 90 1 272 301 XP_069591853.1 uncharacterized protein [Ranitomeya imitator] diamond 90 50.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
30534117 30534117 PRJNA315314_S_NODE_16273_length_203_cov_3.660920_g15952_i0 PRJNA315314 16273 203 3.66092 7.4316676 Chordata 7711 Chordata Chordata 95.9 2.5600000000000003e-21   NR PIO06985.1 8400 g15952 i0 68.7 33.6650246305419 67 21 99 0 3 203 359 425 PIO06985.1 hypothetical protein AB205_0072860, partial [Aquarana catesbeiana] diamond 6834 95.9 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Aquarana Aquarana catesbeiana
30674557 30674557 PRJNA315314_S_NODE_22933_length_174_cov_1.882759_g22612_i0 PRJNA315314 22933 174 1.882759 3.27600066 Rattus norvegicus 10116 Chordata Chordata 45.4 0.00164   NR EDM11305.1 10116 g22612 i0 43.1 3.55172413793103 51 29 87.9 0 17 169 760 810 EDM11305.1 rCG52946 [Rattus norvegicus] diamond 618 45.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Rattus Rattus norvegicus
31165792 31165792 PRJNA315314_S_NODE_32315_length_150_cov_3.140496_g31994_i0 PRJNA315314 32315 150 3.140496 4.710744 root 1 Root_unresolved Root_unresolved 79.3 1.28e-15   NR XP_039255789.1 7725 g31994 i0 79.2 4.8 48 10 96 0 145 2 800 847 XP_039255789.1 cytoplasmic aconitate hydratase-like [Styela clava] diamond 720 79.3 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Stolidobranchia Styelidae Styela Styela clava
31465036 31465036 PRJNA315314_S_NODE_13036_length_225_cov_8.908163_g12715_i0 PRJNA315314 13036 225 8.908163 20.04336675 Staurois parvus 386267 Chordata Chordata 48.5 2.01e-4   NR CAI9536211.1 386267 g12715 i0 53.2 0.626666666666667 47 15 53.3 3 71 190 179 225 CAI9536211.1 unnamed protein product [Staurois parvus] diamond 141 48.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus

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