RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA758087" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA758087 · 15 ✖

analysis 1

  • diamond · 15 ✖
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
27189040 27189040 PRJNA758087_P_NODE_43742_length_241_cov_0.916667_g42422_i0 PRJNA758087 43742 241 0.916667 2.20916747 Tetranychidae 32262 Arthropoda Arthropoda 53.1 7.79e-6   NR XP_015791180.1 32264 g42422 i0 100 0.970954356846473 26 0 32.4 0 239 162 272 297 XP_015791180.1 cadherin-23 [Tetranychus urticae] diamond 234 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
27748172 27748172 PRJNA758087_P_NODE_39424_length_280_cov_1.115942_g38104_i0 PRJNA758087 39424 280 1.115942 3.1246376 Monodon monoceros 40151 Chordata Chordata 48.9 3.82e-4   NR XP_029065241.1 40151 g38104 i0 54.8 0.45 42 19 45 0 161 36 18 59 XP_029065241.1 LOW QUALITY PROTEIN: zona pellucida sperm-binding protein 1 [Monodon monoceros] diamond 126 48.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Monodontidae Monodon Monodon monoceros
27842490 27842490 PRJNA758087_P_NODE_40744_length_262_cov_2.809524_g39424_i0 PRJNA758087 40744 262 2.809524 7.36095288 Phyllostomus discolor 89673 Chordata Chordata 44.7 0.00581   NR KAF6119919.1 89673 g39424 i0 42.9 1.04198473282443 91 43 99.6 4 262 2 37 122 KAF6119919.1 hypothetical protein HJG60_010298 [Phyllostomus discolor] diamond 273 44.7 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Phyllostomidae Phyllostomus Phyllostomus discolor
28189736 28189736 PRJNA758087_P_NODE_18166_length_663_cov_9.018644_g16881_i0 PRJNA758087 18166 663 9.018644 59.79360972 Adineta ricciae 249248 Rotifera other_Eukaryota 300 7.109999999999999e-101   NR CAF1018632.1 249248 g16881 i0 94.8 1.55656108597285 173 8 78.3 1 566 48 7 178 CAF1018632.1 unnamed protein product [Adineta ricciae] diamond 1032 300 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta ricciae
28695360 28695360 PRJNA758087_P_NODE_42127_length_249_cov_0.875000_g40807_i0 PRJNA758087 42127 249 0.875 2.17875 Panonychus citri 50023 Arthropoda Arthropoda 45.8 0.00328   NR XP_053213919.1 50023 g40807 i0 51 0.590361445783133 49 17 57.8 2 87 230 385 427 XP_053213919.1 probable serine/threonine-protein kinase DDB_G0282963 isoform X2 [Panonychus citri] diamond 147 45.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Panonychus Panonychus citri
29168956 29168956 PRJNA758087_P_NODE_43809_length_239_cov_2.759036_g42489_i0 PRJNA758087 43809 239 2.759036 6.59409604 Monodon monoceros 40151 Chordata Chordata 43.9 0.0144   NR TKC47074.1 40151 g42489 i0 55.9 0.426778242677824 34 15 42.7 0 177 76 3296 3329 TKC47074.1 hypothetical protein EI555_021570, partial [Monodon monoceros] diamond 102 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Monodontidae Monodon Monodon monoceros
29295053 29295053 PRJNA758087_P_NODE_39489_length_279_cov_1.427184_g38169_i0 PRJNA758087 39489 279 1.427184 3.98184336 Branchiostoma floridae 7739 Chordata Chordata 44.3 0.00789   NR XP_035667307.1 7739 g38169 i0 38 0.537634408602151 50 31 53.8 0 115 264 99 148 XP_035667307.1 ankycorbin-like [Branchiostoma floridae] diamond 150 44.3 1 Eukaryota Opisthokonta Metazoa Chordata Leptocardii Amphioxiformes Branchiostomatidae Branchiostoma Branchiostoma floridae
29642066 29642066 PRJNA758087_P_NODE_35930_length_323_cov_2.556000_g34610_i0 PRJNA758087 35930 323 2.556 8.25588 Bradysia coprophila 38358 Arthropoda Arthropoda 69.7 3.29e-11   NR XP_037044623.1 38358 g34610 i0 94.1 0.631578947368421 34 2 31.6 0 23 124 896 929 XP_037044623.1 prominin-like protein isoform X6 [Bradysia coprophila] diamond 204 69.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Sciaridae Bradysia Bradysia coprophila
30179217 30179217 PRJNA758087_P_NODE_24672_length_509_cov_2.119266_g23352_i0 PRJNA758087 24672 509 2.119266 10.78706394 Trichechus manatus latirostris 127582 Chordata Chordata 68.6 4.94e-10   NR XP_023593449.1 127582 g23352 i0 57.6 0.388998035363458 66 26 37.7 2 508 317 324 389 XP_023593449.1 tumor susceptibility gene 101 protein isoform X2 [Trichechus manatus latirostris] diamond 198 68.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Sirenia Trichechidae Trichechus Trichechus manatus
30621546 30621546 PRJNA758087_P_NODE_13133_length_842_cov_54.745124_g11947_i0 PRJNA758087 13133 842 54.745124 460.95394408 Penaeus vannamei 6689 Arthropoda Arthropoda 48.9 0.0144   NR ROT71108.1 6689 g11947 i0 41.7 0.580760095011877 163 58 50.2 10 61 483 94 241 ROT71108.1 hypothetical protein C7M84_010575 [Penaeus vannamei] diamond 489 48.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus vannamei
31633141 31633141 PRJNA758087_P_NODE_22816_length_549_cov_4.218487_g21501_i0 PRJNA758087 22816 549 4.218487 23.15949363 Clunio marinus 568069 Arthropoda Arthropoda 250 1.23e-81   NR CRL05315.1 568069 g21501 i0 77.4 0.868852459016393 159 36 86.9 0 6 482 47 205 CRL05315.1 CLUMA_CG018253, isoform A, partial [Clunio marinus] diamond 477 250 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Clunio Clunio marinus
31832599 31832599 PRJNA758087_P_NODE_31057_length_394_cov_4.971963_g29737_i0 PRJNA758087 31057 394 4.971963 19.58953422 Hymenoptera 7399 Arthropoda Arthropoda 104 5.79e-23   NR KAL3402717.1 54128 g29737 i0 55.2 13.8883248730964 87 39 66.2 0 303 43 228 314 KAL3402717.1 hypothetical protein TKK_004638 [Trichogramma kaykai] diamond 5472 104 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma kaykai
32085861 32085861 PRJNA758087_P_NODE_40618_length_264_cov_3.047120_g39298_i0 PRJNA758087 40618 264 3.04712 8.0443968 Chiroptera 9397 Chordata Chordata 43.1 0.0369   NR ELK13967.1 9402 g39298 i0 33.3 1.56818181818182 69 32 75 2 261 64 861 918 ELK13967.1 Disintegrin and metalloproteinase domain-containing protein 17 [Pteropus alecto] diamond 414 43.1 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Chiroptera Pteropodidae Pteropus Pteropus alecto
32465776 32465776 PRJNA758087_P_NODE_35079_length_335_cov_2.729008_g33759_i0 PRJNA758087 35079 335 2.729008 9.1421768 root 1 Root_unresolved Root_unresolved 76.6 1.13e-13   NR XP_032458646.1 42100 g33759 i0 58.8 1.8 68 28 60.9 0 331 128 205 272 XP_032458646.1 ras-related protein Rab-31 isoform X1 [Phocoena sinus] diamond 603 76.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Phocoenidae Phocoena Phocoena sinus
32896949 32896949 PRJNA758087_P_NODE_31420_length_389_cov_1.743671_g30100_i0 PRJNA758087 31420 389 1.743671 6.78288019 Pleurodeles waltl 8319 Chordata Chordata 43.9 0.0262   NR KAJ1120134.1 8319 g30100 i0 40.4 0.401028277634961 52 24 34.7 1 164 298 68 119 KAJ1120134.1 hypothetical protein NDU88_008309 [Pleurodeles waltl] diamond 156 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Caudata Salamandridae Pleurodeles Pleurodeles waltl

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