RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA513467" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA513467 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
10690457 10690457 PRJNA513467_S_NODE_4429_length_189_cov_1.105263_g4406_i0 PRJNA513467 4429 189 1.105263 2.08894707 Chironomus tentans 7153 Arthropoda Arthropoda 114 7.79e-28   NR AAN85117.1 7153 g4406 i0 93.3 1.9047619047619 60 4 95.2 0 10 189 298 357 AAN85117.1 HSP70 [Chironomus tentans] diamond 360 114 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tentans
27330149 27330149 PRJNA513467_S_NODE_2203_length_243_cov_1.466019_g2180_i0 PRJNA513467 2203 243 1.466019 3.56242617 Polyplax serrata 468196 Arthropoda Arthropoda 94.7 1.1e-20   NR KAK6633287.1 468196 g2180 i0 63.6 1.91358024691358 77 23 95.1 1 231 1 90 161 KAK6633287.1 hypothetical protein RUM44_003888 [Polyplax serrata] diamond 465 94.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27330150 27330150 PRJNA513467_S_NODE_7103_length_159_cov_1.918033_g7080_i0 PRJNA513467 7103 159 1.918033 3.04967247 Polyplax serrata 468196 Arthropoda Arthropoda 88.6 8.25e-19   NR KAK6637229.1 468196 g7080 i0 88.5 1.9622641509434 52 6 98.1 0 3 158 837 888 KAK6637229.1 hypothetical protein RUM44_007643 [Polyplax serrata] diamond 312 88.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Polyplacidae Polyplax Polyplax serrata
27661368 27661368 PRJNA513467_S_NODE_684_length_385_cov_3.100575_g661_i0 PRJNA513467 684 385 3.100575 11.93721375 Adineta 104781 Rotifera other_Eukaryota 200 4.61e-64   NR UJR14661.1 104782 g661 i0 94.7 1.76103896103896 113 6 88.1 0 2 340 3 115 UJR14661.1 hypothetical protein I4U23_001654 [Adineta vaga] diamond 678 202 0.99009900990099 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
28482185 28482185 PRJNA513467_S_NODE_146_length_722_cov_2.408759_g126_i0 PRJNA513467 146 722 2.408759 17.39123998 Opisthokonta 33154 Mollusca Mollusca 62 4.36e-7   NR XP_045166474.1 6596 g126 i0 43.9 1.45429362880886 57 32 23.7 0 721 551 176 232 XP_045166474.1 UBX domain-containing protein 6-like [Mercenaria mercenaria] diamond 1050 62.4 0.993589743589744 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
28624821 28624821 PRJNA513467_S_NODE_6927_length_161_cov_1.258065_g6904_i0 PRJNA513467 6927 161 1.258065 2.02548465 Pediculus humanus corporis 121224 Arthropoda Arthropoda 98.6 2.4e-25   NR XP_002429279.1 121224 g6904 i0 86.8 0.987577639751553 53 7 98.8 0 159 1 2 54 XP_002429279.1 uncharacterized protein Phum_PHUM426160 [Pediculus humanus corporis] diamond 159 98.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
28656301 28656301 PRJNA513467_S_NODE_8407_length_150_cov_1.805310_g8384_i0 PRJNA513467 8407 150 1.80531 2.707965 Cyamophila willieti 2604842 Arthropoda Arthropoda 46.6 3.19e-5   NR KAL1463159.1 2604842 g8384 i0 81.5 0.54 27 5 54 0 145 65 20 46 KAL1463159.1 hypothetical protein WDU94_014940, partial [Cyamophila willieti] diamond 81 46.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Psyllidae Cyamophila Cyamophila willieti
29887744 29887744 PRJNA513467_S_NODE_3291_length_209_cov_2.267442_g3268_i0 PRJNA513467 3291 209 2.267442 4.73895378 Trichogramma kaykai 54128 Arthropoda Arthropoda 77 2.52e-15   NR KAL3398246.1 54128 g3268 i0 73.7 1.63636363636364 57 14 80.4 1 168 1 111 167 KAL3398246.1 hypothetical protein TKK_008446 [Trichogramma kaykai] diamond 342 77 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma kaykai
30282514 30282514 PRJNA513467_S_NODE_3832_length_199_cov_1.172840_g3809_i0 PRJNA513467 3832 199 1.17284 2.3339516 Opisthokonta 33154 Porifera other_Eukaryota 45.8 0.00176   NR XP_065891074.1 196820 g3809 i0 42.4 3.84422110552764 66 31 99.5 1 198 1 988 1046 XP_065891074.1 transcription elongation factor SPT6-like [Dysidea avara] diamond 765 46.2 0.991341991341991 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30298787 30298787 PRJNA513467_S_NODE_7912_length_153_cov_2.517241_g7889_i0 PRJNA513467 7912 153 2.517241 3.85137873 Ramazzottius varieornatus 947166 Tardigrada other_Eukaryota 48.9 7.48e-5   NR GAU91291.1 947166 g7889 i0 75 0.549019607843137 28 7 54.9 0 4 87 1138 1165 GAU91291.1 hypothetical protein RvY_03574 [Ramazzottius varieornatus] diamond 84 48.9 1 Eukaryota Opisthokonta Metazoa Tardigrada Eutardigrada Parachela Ramazzottiidae Ramazzottius Ramazzottius varieornatus
30456676 30456676 PRJNA513467_S_NODE_1253_length_301_cov_3.276515_g1230_i0 PRJNA513467 1253 301 3.276515 9.86231015 Pediculus humanus corporis 121224 Arthropoda Arthropoda 112 2.56e-26   NR XP_002426469.1 121224 g1230 i0 87.9 0.578073089700997 58 7 57.8 0 50 223 778 835 XP_002426469.1 uncharacterized protein Phum_PHUM255010 [Pediculus humanus corporis] diamond 174 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
30740605 30740605 PRJNA513467_S_NODE_6314_length_166_cov_2.418605_g6291_i0 PRJNA513467 6314 166 2.418605 4.0148843 Anastrepha obliqua 95512 Arthropoda Arthropoda 41.6 0.0334   NR XP_054746255.1 95512 g6291 i0 40.6 0.578313253012048 32 19 57.8 0 149 54 77 108 XP_054746255.1 uncharacterized protein K02A2.6-like [Anastrepha obliqua] diamond 96 41.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Anastrepha Anastrepha obliqua
30898783 30898783 PRJNA513467_S_NODE_694_length_384_cov_2.913545_g671_i0 PRJNA513467 694 384 2.913545 11.1880128 Erpetoichthys calabaricus 27687 Chordata Chordata 130 5.01e-34   NR XP_051791274.1 27687 g671 i0 76.7 6.390625 90 20 69.5 1 58 324 115 204 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 2454 130 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
31246223 31246223 PRJNA513467_S_NODE_3555_length_204_cov_1.682635_g3532_i0 PRJNA513467 3555 204 1.682635 3.4325754 Sus scrofa 9823 Chordata Chordata 136 4.92e-36   NR XP_020938199.1 9823 g3532 i0 100 1.88235294117647 64 0 94.1 0 193 2 64 127 XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] diamond 384 136 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
31720673 31720673 PRJNA513467_S_NODE_6277_length_167_cov_1.200000_g6254_i0 PRJNA513467 6277 167 1.2 2.004 Ramazzottius varieornatus 947166 Tardigrada other_Eukaryota 112 5.3200000000000006e-27   NR GAU91291.1 947166 g6254 i0 98.2 0.988023952095808 55 1 98.8 0 167 3 1087 1141 GAU91291.1 hypothetical protein RvY_03574 [Ramazzottius varieornatus] diamond 165 112 1 Eukaryota Opisthokonta Metazoa Tardigrada Eutardigrada Parachela Ramazzottiidae Ramazzottius Ramazzottius varieornatus
31735906 31735906 PRJNA513467_S_NODE_1717_length_268_cov_2.194805_g1694_i0 PRJNA513467 1717 268 2.194805 5.8820774 Arthropoda 6656 Arthropoda Arthropoda 67.8 1.23e-11   NR KAK8371844.1 85552 g1694 i0 42.9 5.08208955223881 91 49 98.5 2 5 268 1 91 KAK8371844.1 hypothetical protein O3P69_019821 [Scylla paramamosain] diamond 1362 67.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Portunidae Scylla Scylla paramamosain
31847096 31847096 PRJNA513467_S_NODE_6037_length_169_cov_1.386364_g6014_i0 PRJNA513467 6037 169 1.386364 2.34295516 Polypedilum vanderplanki 319348 Arthropoda Arthropoda 63.9 2.98e-11   NR KAG5680192.1 319348 g6014 i0 100 0.568047337278107 32 0 56.8 0 169 74 90 121 KAG5680192.1 putative 30S ribosomal protein S10 [Polypedilum vanderplanki] diamond 96 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Polypedilum Polypedilum vanderplanki
32480188 32480188 PRJNA513467_S_NODE_1819_length_261_cov_2.714286_g1796_i0 PRJNA513467 1819 261 2.714286 7.08428646 Aphis glycines 307491 Arthropoda Arthropoda 111 2.77e-26   NR KAE9523856.1 307491 g1796 i0 90 0.689655172413793 60 6 69 0 259 80 1236 1295 KAE9523856.1 hypothetical protein AGLY_015744 [Aphis glycines] diamond 180 111 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Aphis Aphis glycines

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