RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1036688" 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

  • PRJNA1036688 · 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
2720056 2720056 PRJNA1036688_P_NODE_10803_length_162_cov_1.824000_g10511_i0 PRJNA1036688 10803 162 1.824 2.95488 Opisthokonta 33154 Echinodermata other_Eukaryota 81.6 8.48e-17   NR XP_041481762.1 7654 g10511 i0 72.2 10.962962962963 54 15 100 0 162 1 196 249 XP_041481762.1 60S ribosomal protein L5-like [Lytechinus variegatus] diamond 1776 82.4 0.990291262135922 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
5272523 5272523 PRJNA1036688_P_NODE_6765_length_219_cov_2.120879_g6473_i0 PRJNA1036688 6765 219 2.120879 4.64472501 Metazoa 33208 Chordata Chordata 114 1.63e-29   NR MBZ3884393.1 30640 g6473 i0 76.3 3.97260273972603 76 15 100 1 1 219 29 104 MBZ3884393.1 40S ribosomal protein S2 [Sciurus carolinensis] diamond 870 114 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Sciuridae Sciurus Sciurus carolinensis
7385851 7385851 PRJNA1036688_P_NODE_2986_length_385_cov_1.876437_g2696_i0 PRJNA1036688 2986 385 1.876437 7.22428245 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 163 2.19e-48   NR XP_065070902.1 499914 g2696 i0 72.6 1.63636363636364 106 26 82.6 1 384 67 79 181 XP_065070902.1 LOW QUALITY PROTEIN: large ribosomal subunit protein uL15-like [Rhopilema esculentum] diamond 630 163 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
9097219 9097219 PRJNA1036688_P_NODE_10828_length_162_cov_1.248000_g10536_i0 PRJNA1036688 10828 162 1.248 2.02176 Calicophoron daubneyi 300641 Platyhelminthes Platyhelminthes 89.4 1.5e-19   NR CAL5138391.1 300641 g10536 i0 77.4 0.981481481481482 53 12 98.1 0 3 161 217 269 CAL5138391.1 unnamed protein product [Calicophoron daubneyi] diamond 159 89.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Paramphistomidae Calicophoron Calicophoron daubneyi
9097275 9097275 PRJNA1036688_P_NODE_7188_length_210_cov_2.069364_g6896_i0 PRJNA1036688 7188 210 2.069364 4.3456644 Patiria miniata 46514 Echinodermata other_Eukaryota 132 2.28e-36   NR XP_038051326.1 46514 g6896 i0 85.3 0.971428571428571 68 10 97.1 0 205 2 176 243 XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] diamond 204 132 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
19295487 19295487 PRJNA1036688_P_NODE_5016_length_272_cov_1.991489_g4724_i0 PRJNA1036688 5016 272 1.991489 5.41685008 Metazoa 33208 Mollusca Mollusca 150 4.359999999999999e-43   NR XP_050413940.1 6465 g4724 i0 71.1 78.4191176470588 90 26 99.3 0 2 271 82 171 XP_050413940.1 60S ribosomal protein L8 [Patella vulgata] diamond 21330 150 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
27730518 27730518 PRJNA1036688_P_NODE_8764_length_184_cov_2.639456_g8472_i0 PRJNA1036688 8764 184 2.639456 4.85659904 Caerostris darwini 1538125 Arthropoda Arthropoda 75.9 5.06e-15   NR GIY25719.1 1538125 g8472 i0 72.5 0.831521739130435 51 14 83.2 0 29 181 153 203 GIY25719.1 hypothetical protein CDAR_263751 [Caerostris darwini] diamond 153 75.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris darwini
28290380 28290380 PRJNA1036688_P_NODE_8226_length_192_cov_1.496774_g7934_i0 PRJNA1036688 8226 192 1.496774 2.87380608 root 1 Root_unresolved Root_unresolved 139 8.999999999999999e-37   NR XP_030110853.2 10090 g7934 i0 100 15.75 63 0 98.4 0 2 190 170 232 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 3024 139 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
28898284 28898284 PRJNA1036688_P_NODE_7148_length_211_cov_1.545977_g6856_i0 PRJNA1036688 7148 211 1.545977 3.26201147 Polypterus senegalus 55291 Chordata Chordata 45.8 0.00189   NR KAG2469876.1 55291 g6856 i0 64.3 10.3791469194313 28 10 39.8 0 209 126 299 326 KAG2469876.1 TC1A transposase, partial [Polypterus senegalus] diamond 2190 45.8 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Polypterus Polypterus senegalus
29088026 29088026 PRJNA1036688_P_NODE_9428_length_176_cov_1.676259_g9136_i0 PRJNA1036688 9428 176 1.676259 2.95021584 Staurois parvus 386267 Chordata Chordata 44.7 3.23e-4   NR CAI9580978.1 386267 g9136 i0 56.1 0.698863636363636 41 18 69.9 0 27 149 1 41 CAI9580978.1 unnamed protein product, partial [Staurois parvus] diamond 123 44.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
29308810 29308810 PRJNA1036688_P_NODE_8469_length_188_cov_2.821192_g8177_i0 PRJNA1036688 8469 188 2.821192 5.30384096 Bufotes viridis 30338 Chordata Chordata 42.7 0.018   NR CAK8609802.1 30338 g8177 i0 52.9 1.78723404255319 34 16 54.3 0 107 6 1 34 CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] diamond 336 42.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufotes Bufotes viridis
30406681 30406681 PRJNA1036688_P_NODE_11813_length_153_cov_19.672414_g11521_i0 PRJNA1036688 11813 153 19.672414 30.09879342 Opisthokonta 33154 Chordata Chordata 40.8 0.0169   NR NWZ51675.1 8969 g11521 i0 69.2 2.54901960784314 26 8 51 0 153 76 6 31 NWZ51675.1 ZN252 protein [Haliaeetus albicilla] diamond 390 40.8 1 Eukaryota Opisthokonta Metazoa Chordata Aves Accipitriformes Accipitridae Haliaeetus Haliaeetus albicilla
30659079 30659079 PRJNA1036688_P_NODE_6173_length_235_cov_2.348485_g5881_i0 PRJNA1036688 6173 235 2.348485 5.51893975 Metazoa 33208 Cnidaria other_Eukaryota 103 1.82e-25   NR XP_001639879.2 45351 g5881 i0 67.6 10.9021276595745 71 23 90.6 0 20 232 37 107 XP_001639879.2 40S ribosomal protein S11 [Nematostella vectensis] diamond 2562 103 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Edwardsiidae Nematostella Nematostella vectensis
30825059 30825059 PRJNA1036688_P_NODE_11714_length_154_cov_2.666667_g11422_i0 PRJNA1036688 11714 154 2.666667 4.10666718 Elysia marginata 1093978 Mollusca Mollusca 100 3.47e-26   NR GFS19501.1 1093978 g11422 i0 76.5 6.66233766233766 51 12 99.4 0 154 2 3 53 GFS19501.1 40S ribosomal protein S29 [Elysia marginata] diamond 1026 100 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia marginata
31457386 31457386 PRJNA1036688_P_NODE_11076_length_160_cov_1.089431_g10784_i0 PRJNA1036688 11076 160 1.089431 1.7430896 Chironomus tepperi 113505 Arthropoda Arthropoda 89.7 3.24e-19   NR XP_070497457.1 113505 g10784 i0 88.5 0.975 52 6 97.5 0 158 3 804 855 XP_070497457.1 protein Smaug [Chironomus tepperi] diamond 156 89.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
31552383 31552383 PRJNA1036688_P_NODE_10336_length_166_cov_2.379845_g10044_i0 PRJNA1036688 10336 166 2.379845 3.9505427 Ctenocephalides felis 7515 Arthropoda Arthropoda 92 3.76e-20   NR XP_026467740.1 7515 g10044 i0 75.5 3.79518072289157 53 13 95.8 0 6 164 27 79 XP_026467740.1 aspartate aminotransferase, mitochondrial [Ctenocephalides felis] diamond 630 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Siphonaptera Pulicidae Ctenocephalides Ctenocephalides felis
32026710 32026710 PRJNA1036688_P_NODE_11538_length_156_cov_0.983193_g11246_i0 PRJNA1036688 11538 156 0.983193 1.53378108 Chironomus tepperi 113505 Arthropoda Arthropoda 82.8 1.08e-18   NR XP_070507023.1 113505 g11246 i0 87 0.884615384615385 46 6 88.5 0 151 14 82 127 XP_070507023.1 late histone H2B.2.1-like [Chironomus tepperi] diamond 138 82.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chironomidae Chironomus Chironomus tepperi
32564850 32564850 PRJNA1036688_P_NODE_11419_length_157_cov_0.966667_g11127_i0 PRJNA1036688 11419 157 0.966667 1.51766719 Tricholaema leucomelas 240729 Chordata Chordata 43.5 9.45e-4   NR NXX49186.1 240729 g11127 i0 38.6 2.56050955414013 44 27 84.1 0 134 3 2 45 NXX49186.1 Z585A protein [Tricholaema leucomelas] diamond 402 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Aves Piciformes Lybiidae Tricholaema lacrymosa Tricholaema leucomelas

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