RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1074408 · 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
4017533 4017533 PRJNA1074408_S_NODE_5844_length_192_cov_2.255034_g5714_i0 PRJNA1074408 5844 192 2.255034 4.32966528 Oedothorax gibbosus 931172 Arthropoda Arthropoda 78.6 4.18e-15   NR KAG8186595.1 931172 g5714 i0 80.5 1.296875 41 8 64.1 0 184 62 430 470 KAG8186595.1 hypothetical protein JTE90_019917 [Oedothorax gibbosus] diamond 249 78.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Linyphiidae Oedothorax Oedothorax gibbosus
27225295 27225295 PRJNA1074408_S_NODE_9823_length_151_cov_3.583333_g9693_i0 PRJNA1074408 9823 151 3.583333 5.41083283 Bos taurus 9913 Chordata Chordata 89.4 1.76e-19   NR XP_024835237.2 9913 g9693 i0 100 0.993377483443709 50 0 99.3 0 2 151 12 61 XP_024835237.2 translation initiation factor IF-2, partial [Bos taurus] diamond 150 89.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Bovidae Bos Bos taurus
27352154 27352154 PRJNA1074408_S_NODE_5123_length_204_cov_1.633540_g4993_i0 PRJNA1074408 5123 204 1.63354 3.3324216 Holothuria leucospilota 206669 Echinodermata other_Eukaryota 47 1.3e-4   NR KAJ8043773.1 206669 g4993 i0 51.1 1.42647058823529 47 23 69.1 0 184 44 53 99 KAJ8043773.1 hypothetical protein HOLleu_11030 [Holothuria leucospilota] diamond 291 47 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Aspidochirotida Holothuriidae Holothuria Holothuria leucospilota
27352156 27352156 PRJNA1074408_S_NODE_8763_length_159_cov_1.655172_g8633_i0 PRJNA1074408 8763 159 1.655172 2.63172348 Trichuris trichiura 36087 Nematoda Nematoda 75.1 1.32e-14   NR CDW54364.1 36087 g8633 i0 55.1 0.924528301886792 49 22 92.5 0 159 13 170 218 CDW54364.1 26S proteasome non ATPase regulatory subunit 10 [Trichuris trichiura] diamond 147 75.1 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichuridae Trichuris Trichuris trichiura
28109583 28109583 PRJNA1074408_S_NODE_7225_length_174_cov_2.198473_g7095_i0 PRJNA1074408 7225 174 2.198473 3.82534302 Soboliphyme baturini 241478 Nematoda Nematoda 97.1 2.85e-24   NR VDP04425.1 241478 g7095 i0 91.1 0.96551724137931 56 5 96.6 0 6 173 39 94 VDP04425.1 unnamed protein product [Soboliphyme baturini] diamond 168 97.1 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Dioctophymatida Soboliphymatidae Soboliphyme Soboliphyme baturini
28330672 28330672 PRJNA1074408_S_NODE_2346_length_299_cov_1.382812_g2216_i0 PRJNA1074408 2346 299 1.382812 4.13460788 Trichuris trichiura 36087 Nematoda Nematoda 132 4.22e-37   NR CDW53661.1 36087 g2216 i0 78.5 0.792642140468227 79 17 79.3 0 293 57 69 147 CDW53661.1 Heme transporter hrg1 B [Trichuris trichiura] diamond 237 132 1 Eukaryota Opisthokonta Metazoa Nematoda Enoplea Trichinellida Trichuridae Trichuris Trichuris trichiura
28827188 28827188 PRJNA1074408_S_NODE_4128_length_228_cov_1.556757_g3998_i0 PRJNA1074408 4128 228 1.556757 3.54940596 Metazoa 33208 Chordata Chordata 49.3 3.62e-5   NR XP_067961094.1 7769 g3998 i0 36.2 5.28947368421053 69 43 89.5 1 219 16 58 126 XP_067961094.1 ragulator complex protein LAMTOR2 [Myxine glutinosa] diamond 1206 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Chordata Myxini Myxiniformes Myxinidae Myxine Myxine glutinosa
28867471 28867471 PRJNA1074408_S_NODE_2788_length_274_cov_20.995671_g2658_i0 PRJNA1074408 2788 274 20.995671 57.52813854 Haliotis asinina 109174 Mollusca Mollusca 43.5 0.0267   NR XP_067657806.1 109174 g2658 i0 35.4 1.4014598540146 65 36 70.1 2 36 227 144 203 XP_067657806.1 uncharacterized protein [Haliotis asinina] diamond 384 43.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
30185218 30185218 PRJNA1074408_S_NODE_9392_length_154_cov_1.297297_g9262_i0 PRJNA1074408 9392 154 1.297297 1.99783738 root 1 Root_unresolved Root_unresolved 96.3 5.68e-24   NR RNA36257.1 10195 g9262 i0 80.4 8.9025974025974 51 10 99.4 0 2 154 71 121 RNA36257.1 40S ribosomal S15Aa [Brachionus plicatilis] diamond 1371 96.3 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
30730933 30730933 PRJNA1074408_S_NODE_4254_length_225_cov_1.054945_g4124_i0 PRJNA1074408 4254 225 1.054945 2.37362625 Myxine glutinosa 7769 Chordata Chordata 56.2 5.49e-7   NR XP_067992270.1 7769 g4124 i0 74.4 1.04 39 10 52 0 117 1 24422 24460 XP_067992270.1 LOW QUALITY PROTEIN: titin [Myxine glutinosa] diamond 234 56.2 1 Eukaryota Opisthokonta Metazoa Chordata Myxini Myxiniformes Myxinidae Myxine Myxine glutinosa
31164464 31164464 PRJNA1074408_S_NODE_4855_length_210_cov_2.011976_g4725_i0 PRJNA1074408 4855 210 2.011976 4.2251496 Trichogramma 7490 Arthropoda Arthropoda 48.1 2.99e-4   NR KAL3385824.1 54128 g4725 i0 50 2.64285714285714 50 21 71.4 1 61 210 290 335 KAL3385824.1 hypothetical protein TKK_018624 [Trichogramma kaykai] diamond 555 48.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Trichogrammatidae Trichogramma Trichogramma kaykai
31195972 31195972 PRJNA1074408_S_NODE_6875_length_178_cov_1.777778_g6745_i0 PRJNA1074408 6875 178 1.777778 3.16444484 Anura 8342 Chordata Chordata 69.7 4.82e-12   NR XP_066447536.1 57060 g6745 i0 84.2 62.123595505618 38 6 64 0 114 1 489 526 XP_066447536.1 kelch-like protein 32 [Eleutherodactylus coqui] diamond 11058 69.7 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Eleutherodactylidae Eleutherodactylus Eleutherodactylus coqui
31679193 31679193 PRJNA1074408_S_NODE_9677_length_152_cov_1.761468_g9547_i0 PRJNA1074408 9677 152 1.761468 2.67743136 Orcinus orca 9733 Chordata Chordata 50.4 2.04e-5   NR XP_049557796.1 9733 g9547 i0 46 1.83552631578947 50 27 98.7 0 150 1 2050 2099 XP_049557796.1 nucleosome-remodeling factor subunit BPTF isoform X18 [Orcinus orca] diamond 279 50.4 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Delphinidae Orcinus Orcinus orca
31765619 31765619 PRJNA1074408_S_NODE_3757_length_238_cov_1.230769_g3627_i0 PRJNA1074408 3757 238 1.230769 2.92923022 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 66.6 7.02e-11   NR XP_071172746.1 6550 g3627 i0 57.6 4.48739495798319 59 24 73.1 1 237 64 208 266 XP_071172746.1 dimethyladenosine transferase-like isoform X2 [Mytilus edulis] diamond 1068 67 0.994029850746269 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
31869015 31869015 PRJNA1074408_S_NODE_7137_length_175_cov_1.818182_g7007_i0 PRJNA1074408 7137 175 1.818182 3.1818185 Canis lupus familiaris 9615 Chordata Chordata 49.3 7.44e-5   NR BAA25253.1 9615 g7007 i0 63.6 3.92571428571429 33 12 56.6 0 76 174 1022 1054 BAA25253.1 unnamed protein product [Canis lupus familiaris] diamond 687 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Canidae Canis Canis lupus
32122415 32122415 PRJNA1074408_S_NODE_9418_length_153_cov_14.609091_g9288_i0 PRJNA1074408 9418 153 14.609091 22.35190923 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 62.4 1.19e-10   NR AAW27122.1 6182 g9288 i0 96.4 0.549019607843137 28 1 54.9 0 151 68 22 49 AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] diamond 84 62.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32280657 32280657 PRJNA1074408_S_NODE_9879_length_151_cov_1.333333_g9749_i0 PRJNA1074408 9879 151 1.333333 2.01333283 Diuraphis noxia 143948 Arthropoda Arthropoda 85.5 9.11e-18   NR XP_015373264.1 143948 g9749 i0 80 1.98675496688742 50 10 99.3 0 151 2 256 305 XP_015373264.1 PREDICTED: lymphoid-specific helicase-like [Diuraphis noxia] diamond 300 85.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Diuraphis Diuraphis noxia
32628014 32628014 PRJNA1074408_S_NODE_8780_length_159_cov_1.655172_g8650_i0 PRJNA1074408 8780 159 1.655172 2.63172348 Ambystoma mexicanum 8296 Chordata Chordata 50.8 1.64e-5   NR XP_069481484.1 8296 g8650 i0 58.1 4.05660377358491 43 18 81.1 0 2 130 1264 1306 XP_069481484.1 mucin-2-like [Ambystoma mexicanum] diamond 645 50.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Caudata Ambystomatidae Ambystoma Ambystoma mexicanum

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