RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA326068" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA326068 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
11868004 11868004 PRJNA326068_P_NODE_10490_length_305_cov_1.576087_g9530_i0 PRJNA326068 10490 305 1.576087 4.80706535 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 147 4.1399999999999996e-42   NR MCL4117824.1 82763 g9530 i0 66.3 2.98032786885246 101 34 99.3 0 303 1 47 147 MCL4117824.1 hypothetical protein [Idotea baltica] diamond 909 148 0.993243243243243 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
13142968 13142968 PRJNA326068_P_NODE_14311_length_229_cov_2.175000_g13348_i0 PRJNA326068 14311 229 2.175 4.98075 Arthropoda 6656 Arthropoda Arthropoda 118 6.28e-31   NR KAK8785384.1 6943 g13348 i0 74.1 13.7685589519651 81 16 99.6 1 1 228 56 136 KAK8785384.1 hypothetical protein V5799_008250 [Amblyomma americanum] diamond 3153 118 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Amblyomma Amblyomma americanum
18241090 18241090 PRJNA326068_P_NODE_915_length_1062_cov_3.829622_g642_i0 PRJNA326068 915 1062 3.829622 40.67058564 Rangifer tarandus platyrhynchus 3082113 Chordata Chordata 368 1.82e-123   NR CAI9170285.1 3082113 g642 i0 68.7 0.740112994350282 262 70 70.6 1 205 954 63 324 CAI9170285.1 unnamed protein product [Rangifer tarandus platyrhynchus] diamond 786 368 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Cervidae Rangifer Rangifer tarandus
19515297 19515297 PRJNA326068_P_NODE_17436_length_191_cov_2.746914_g16473_i0 PRJNA326068 17436 191 2.746914 5.24660574 Metazoa 33208 Chordata Chordata 92 1.51e-20   NR XP_038649770.1 7830 g16473 i0 68.3 12.5026178010471 63 20 99 0 1 189 135 197 XP_038649770.1 60S ribosomal protein L5-A [Scyliorhinus canicula] diamond 2388 92.8 0.991379310344828 Eukaryota Opisthokonta Metazoa Chordata Chondrichthyes Carcharhiniformes Scyliorhinidae Scyliorhinus Scyliorhinus canicula
20790923 20790923 PRJNA326068_P_NODE_19777_length_154_cov_1.672000_g18814_i0 PRJNA326068 19777 154 1.672 2.57488 Opisthokonta 33154 Arthropoda Arthropoda 92 2.66e-22   NR KAB7497964.1 96803 g18814 i0 76.5 38.7467532467532 51 12 99.4 0 1 153 73 123 KAB7497964.1 40S ribosomal protein S15a [Armadillidium nasatum] diamond 5967 92 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Armadillidiidae Armadillidium Armadillidium nasatum
27390837 27390837 PRJNA326068_P_NODE_11383_length_283_cov_13.141732_g10421_i0 PRJNA326068 11383 283 13.141732 37.19110156 Bos taurus 9913 Chordata Chordata 41.2 0.0421   NR DAA22930.1 9913 g10421 i0 40 0.583038869257951 55 29 58.3 1 29 193 28 78 DAA22930.1 TPA: rCG59649-like [Bos taurus] diamond 165 41.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos taurus
27390838 27390838 PRJNA326068_P_NODE_12903_length_253_cov_2.406250_g11940_i0 PRJNA326068 12903 253 2.40625 6.0878125 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 46.2 4.75e-4   NR KAJ8043773.1 206669 g11940 i0 52.3 1.07905138339921 44 21 52.2 0 5 136 56 99 KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] diamond 273 46.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
28053607 28053607 PRJNA326068_P_NODE_11645_length_278_cov_15.678715_g10683_i0 PRJNA326068 11645 278 15.678715 43.5868277 Tribolium castaneum 7070 Arthropoda Arthropoda 46.2 0.00341   NR XP_008199173.3 7070 g10683 i0 35.8 0.87410071942446 81 49 85.3 3 2 238 470 549 XP_008199173.3 protein bride of sevenless [Tribolium castaneum] diamond 243 46.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tribolium Tribolium castaneum
28576167 28576167 PRJNA326068_P_NODE_17667_length_187_cov_1.322785_g16704_i0 PRJNA326068 17667 187 1.322785 2.47360795 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 86.7 1.05e-18   NR XP_065826415.1 121494 g16704 i0 68.9 110.534759358289 61 19 97.9 0 185 3 90 150 XP_065826415.1 small ribosomal subunit protein uS5 isoform X2 [Oscarella lobularis] diamond 20670 87 0.996551724137931 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28622214 28622214 PRJNA326068_P_NODE_10967_length_292_cov_5.501901_g10006_i0 PRJNA326068 10967 292 5.501901 16.06555092 Acanthosepion pharaonis 158019 Mollusca Mollusca 43.1 0.0468   NR CAE1265857.1 158019 g10006 i0 44 0.770547945205479 75 19 75 4 39 257 85 138 CAE1265857.1 unnamed protein product [Acanthosepion pharaonis] diamond 225 43.1 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Sepiida Sepiidae Acanthosepion Acanthosepion pharaonis
28639566 28639566 PRJNA326068_P_NODE_18827_length_167_cov_2.181159_g17864_i0 PRJNA326068 18827 167 2.181159 3.64253553 Opisthokonta 33154 Arthropoda Arthropoda 91.3 2.43e-20   NR RWS31359.1 299467 g17864 i0 81.5 19.4011976047904 54 10 97 0 165 4 73 126 RWS31359.1 60S ribosomal protein L5-like protein [Leptotrombidium deliense] diamond 3240 91.7 0.995637949836423 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombiculidae Leptotrombidium Leptotrombidium deliense
29064215 29064215 PRJNA326068_P_NODE_11648_length_278_cov_9.771084_g10686_i0 PRJNA326068 11648 278 9.771084 27.16361352 Tenebrio molitor 7067 Arthropoda Arthropoda 43.5 0.0304   NR CAH1375291.1 7067 g10686 i0 35 2.27697841726619 80 51 85.3 1 277 41 479 558 CAH1375291.1 unnamed protein product [Tenebrio molitor] diamond 633 43.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
29176311 29176311 PRJNA326068_P_NODE_16949_length_199_cov_1.347059_g15986_i0 PRJNA326068 16949 199 1.347059 2.68064741 Opisthokonta 33154 Arthropoda Arthropoda 63.5 6.37e-11   NR CAG4636732.1 186181 g15986 i0 55.4 7.8391959798995 65 29 98 0 197 3 12 76 CAG4636732.1 EOG090X0NXS [Eubosmina coregoni] diamond 1560 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Branchiopoda Diplostraca Bosminidae Eubosmina Eubosmina coregoni
29284954 29284954 PRJNA326068_P_NODE_13349_length_245_cov_2.018519_g12386_i0 PRJNA326068 13349 245 2.018519 4.94537155 Dirofilaria immitis 6287 Nematoda Nematoda 49.3 9.98e-5   NR MCP9259222.1 6287 g12386 i0 66.7 0.808163265306122 33 11 40.4 0 122 220 92 124 MCP9259222.1 putative serine acetyltransferase [Dirofilaria immitis] diamond 198 49.3 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Onchocercidae Dirofilaria Dirofilaria immitis
29348358 29348358 PRJNA326068_P_NODE_14749_length_223_cov_2.108247_g13786_i0 PRJNA326068 14749 223 2.108247 4.70139081 Heterobilharzia americana 39320 Platyhelminthes Platyhelminthes 45.8 1.69e-4   NR CAH8478127.1 39320 g13786 i0 51.2 0.57847533632287 43 21 57.8 0 62 190 10 52 CAH8478127.1 unnamed protein product [Heterobilharzia americana] diamond 129 45.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Heterobilharzia Heterobilharzia americana
29902468 29902468 PRJNA326068_P_NODE_15471_length_215_cov_1.440860_g14508_i0 PRJNA326068 15471 215 1.44086 3.097849 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 55.5 3.65e-8   NR MCL4117871.1 82763 g14508 i0 46.4 2.69302325581395 69 37 96.3 0 215 9 2 70 MCL4117871.1 hypothetical protein [Idotea baltica] diamond 579 55.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Isopoda Idoteidae Idotea Idotea baltica
30345212 30345212 PRJNA326068_P_NODE_17712_length_186_cov_1.605096_g16749_i0 PRJNA326068 17712 186 1.605096 2.98547856 Caenorhabditis 6237 Nematoda Nematoda 85.9 1.56e-19   NR NP_001379167.1 6239 g16749 i0 67.9 2.56451612903226 53 17 85.5 0 160 2 1 53 NP_001379167.1 Small ribosomal subunit protein uS9 [Caenorhabditis elegans] diamond 477 85.9 1 Eukaryota Opisthokonta Metazoa Nematoda Chromadorea Rhabditida Rhabditidae Caenorhabditis Caenorhabditis elegans
30485387 30485387 PRJNA326068_P_NODE_12733_length_256_cov_14.480176_g11770_i0 PRJNA326068 12733 256 14.480176 37.06925056 Bos taurus 9913 Chordata Chordata 41.2 0.032   NR DAA22930.1 9913 g11770 i0 40 0.64453125 55 29 64.5 1 228 64 28 78 DAA22930.1 TPA: rCG59649-like [Bos taurus] diamond 165 41.2 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos taurus
30706410 30706410 PRJNA326068_P_NODE_12734_length_256_cov_14.374449_g11771_i0 PRJNA326068 12734 256 14.374449 36.79858944 Bos taurus 9913 Chordata Chordata 41.6 0.0227   NR DAA22930.1 9913 g11771 i0 38.3 0.703125 60 33 70.3 1 228 49 28 83 DAA22930.1 TPA: rCG59649-like [Bos taurus] diamond 180 41.6 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos taurus
30864373 30864373 PRJNA326068_P_NODE_11954_length_272_cov_2.201646_g10991_i0 PRJNA326068 11954 272 2.201646 5.98847712 Maconellicoccus hirsutus 177089 Arthropoda Arthropoda 68.9 7e-12   NR ABM55665.1 177089 g10991 i0 49.4 9.79411764705882 83 38 88.2 2 272 33 71 152 ABM55665.1 putative ribosomal protein S8e [Maconellicoccus hirsutus] diamond 2664 68.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Pseudococcidae Maconellicoccus Maconellicoccus hirsutus
32824255 32824255 PRJNA326068_P_NODE_19620_length_156_cov_1.299213_g18657_i0 PRJNA326068 19620 156 1.299213 2.02677228 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 44.7 0.00237   NR KAJ8031644.1 206669 g18657 i0 51 1.80769230769231 49 15 90.4 2 12 152 2109 2150 KAJ8031644.1 IgGFc-binding protein [Holothuria leucospilota] diamond 282 44.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota

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