RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA358009 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
1073100 1073100 PRJNA358009_P_NODE_8361_length_199_cov_6.000000_g8292_i0 PRJNA358009 8361 199 6 11.94 Parthenolecanium corni 536013 Arthropoda Arthropoda 123 3.52e-33   NR KAK7600776.1 536013 g8292 i0 100 1.89949748743719 63 0 95 0 10 198 155 217 KAK7600776.1 hypothetical protein V9T40_009812 [Parthenolecanium corni] diamond 378 123 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Coccidae Parthenolecanium Parthenolecanium corni
26979873 26979873 PRJNA358009_P_NODE_4442_length_327_cov_2.133094_g4379_i0 PRJNA358009 4442 327 2.133094 6.97521738 Sus scrofa 9823 Chordata Chordata 107 1.98e-24   NR XP_020938199.1 9823 g4379 i0 98.1 1.45871559633028 53 1 48.6 0 169 327 375 427 XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] diamond 477 107 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
27074825 27074825 PRJNA358009_P_NODE_2482_length_327_cov_3.820144_g2419_i0 PRJNA358009 2482 327 3.820144 12.49187088 Tigriopus californicus 6832 Arthropoda Arthropoda 49.7 3.53e-4   NR TRY78645.1 6832 g2419 i0 70 0.275229357798165 30 9 27.5 0 230 319 263 292 TRY78645.1 hypothetical protein TCAL_06613 [Tigriopus californicus] diamond 90 49.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Hexanauplia Harpacticoida Harpacticidae Tigriopus Tigriopus californicus
27359501 27359501 PRJNA358009_P_NODE_9003_length_188_cov_6.985612_g8934_i0 PRJNA358009 9003 188 6.985612 13.13295056 Parthenolecanium corni 536013 Arthropoda Arthropoda 117 1.79e-29   NR KAK7586115.1 536013 g8934 i0 98.1 0.829787234042553 52 1 83 0 157 2 145 196 KAK7586115.1 hypothetical protein V9T40_003991 [Parthenolecanium corni] diamond 156 117 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Coccidae Parthenolecanium Parthenolecanium corni
27422742 27422742 PRJNA358009_P_NODE_13523_length_166_cov_0.871795_g13454_i0 PRJNA358009 13523 166 0.871795 1.4471797 Engystomops pustulosus 76066 Chordata Chordata 71.6 8.59e-13   NR KAG8571490.1 76066 g13454 i0 60.4 12.5963855421687 53 16 95.8 1 1 159 1125 1172 KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] diamond 2091 71.6 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
27502931 27502931 PRJNA358009_P_NODE_11783_length_172_cov_4.398374_g11714_i0 PRJNA358009 11783 172 4.398374 7.56520328 Metazoa 33208 Mollusca Mollusca 44.3 0.00421   NR XP_062579849.1 36930 g11714 i0 46 7.95348837209302 50 23 87.2 1 160 11 463 508 XP_062579849.1 stalled ribosome sensor GCN1-like, partial [Saccostrea cuccullata] diamond 1368 44.3 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
27770052 27770052 PRJNA358009_P_NODE_3384_length_327_cov_2.679856_g3321_i0 PRJNA358009 3384 327 2.679856 8.76312912 Parthenolecanium corni 536013 Arthropoda Arthropoda 63.9 3.66e-9   NR KAK7576204.1 536013 g3321 i0 93.9 0.302752293577982 33 2 30.3 0 3 101 19 51 KAK7576204.1 hypothetical protein V9T40_012490 [Parthenolecanium corni] diamond 99 63.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Coccidae Parthenolecanium Parthenolecanium corni
29600821 29600821 PRJNA358009_P_NODE_17750_length_155_cov_2.075472_g17681_i0 PRJNA358009 17750 155 2.075472 3.2169816 Dinothrombium tinctorium 1965070 Arthropoda Arthropoda 64.3 5.71e-12   NR RWS00228.1 1965070 g17681 i0 59.2 1.89677419354839 49 20 94.8 0 152 6 10 58 RWS00228.1 NS1-like protein [Dinothrombium tinctorium] diamond 294 64.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Trombidiidae Dinothrombium Dinothrombium tinctorium
30264733 30264733 PRJNA358009_P_NODE_17932_length_154_cov_2.723810_g17863_i0 PRJNA358009 17932 154 2.72381 4.1946674 Brachionus plicatilis 10195 Rotifera other_Eukaryota 72.8 2.81e-13   NR RNA28271.1 10195 g17863 i0 100 0.642857142857143 33 0 64.3 0 2 100 550 582 RNA28271.1 hypothetical protein BpHYR1_024686 [Brachionus plicatilis] diamond 99 72.8 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus plicatilis
30485635 30485635 PRJNA358009_P_NODE_11653_length_173_cov_2.201613_g11584_i0 PRJNA358009 11653 173 2.201613 3.80879049 Ranitomeya imitator 111125 Chordata Chordata 41.6 0.0378   NR CAJ0963082.1 111125 g11584 i0 48.8 3.3121387283237 41 15 71.1 1 50 172 309 343 CAJ0963082.1 unnamed protein product [Ranitomeya imitator] diamond 573 41.6 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Dendrobatidae Ranitomeya Ranitomeya imitator
30896506 30896506 PRJNA358009_P_NODE_1214_length_354_cov_3.796721_g1153_i0 PRJNA358009 1214 354 3.796721 13.44039234 Sus scrofa 9823 Chordata Chordata 146 9.72e-39   NR XP_020938199.1 9823 g1153 i0 97.2 1.83050847457627 72 2 61 0 347 132 159 230 XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] diamond 648 146 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Suidae Sus Sus scrofa
30991236 30991236 PRJNA358009_P_NODE_11074_length_176_cov_2.874016_g11005_i0 PRJNA358009 11074 176 2.874016 5.05826816 Halotydeus destructor 2874060 Arthropoda Arthropoda 60.5 8.25e-9   NR KAI1292898.1 2874060 g11005 i0 62.5 0.818181818181818 48 16 81.8 2 8 151 123 168 KAI1292898.1 Mitochonrial uncharacterized protein [Halotydeus destructor] diamond 144 60.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
31592028 31592028 PRJNA358009_P_NODE_2916_length_327_cov_3.115108_g2853_i0 PRJNA358009 2916 327 3.115108 10.18640316 Engystomops pustulosus 76066 Chordata Chordata 44.3 0.0295   NR KAG8571490.1 76066 g2853 i0 67.7 3.98165137614679 31 10 28.4 0 10 102 979 1009 KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] diamond 1302 44.3 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Leptodactylidae Engystomops Engystomops pustulosus
31686633 31686633 PRJNA358009_P_NODE_12357_length_169_cov_7.758333_g12288_i0 PRJNA358009 12357 169 7.758333 13.11158277 Halotydeus destructor 2874060 Arthropoda Arthropoda 81.6 2.57e-16   NR KAI1293879.1 2874060 g12288 i0 60.4 5.64497041420118 53 21 94.1 0 3 161 175 227 KAI1293879.1 Helicase domino [Halotydeus destructor] diamond 954 81.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Penthaleidae Halotydeus Halotydeus destructor
31813262 31813262 PRJNA358009_P_NODE_6577_length_326_cov_2.725632_g6514_i0 PRJNA358009 6577 326 2.725632 8.88556032 Parthenolecanium corni 536013 Arthropoda Arthropoda 76.3 1.78e-13   NR KAK7601503.1 536013 g6514 i0 100 0.303680981595092 33 0 30.4 0 227 325 427 459 KAK7601503.1 hypothetical protein V9T40_008944 [Parthenolecanium corni] diamond 99 76.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Coccidae Parthenolecanium Parthenolecanium corni
31876384 31876384 PRJNA358009_P_NODE_3157_length_327_cov_2.877698_g3094_i0 PRJNA358009 3157 327 2.877698 9.41007246 Parasteatoda tepidariorum 114398 Arthropoda Arthropoda 66.2 4.94e-10   NR XP_015930466.1 114398 g3094 i0 87.1 0.284403669724771 31 4 28.4 0 319 227 123 153 XP_015930466.1 kelch domain-containing protein 2 [Parasteatoda tepidariorum] diamond 93 66.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Theridiidae Parasteatoda Parasteatoda tepidariorum
32210102 32210102 PRJNA358009_P_NODE_6758_length_326_cov_1.490975_g6695_i0 PRJNA358009 6758 326 1.490975 4.8605785 Opisthokonta 33154 Arthropoda Arthropoda 50.4 1.85e-4   NR XP_028967083.1 34638 g6695 i0 71 4.01226993865031 31 9 28.5 0 322 230 106 136 XP_028967083.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase [Galendromus occidentalis] diamond 1308 50.8 0.992125984251969 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Mesostigmata Phytoseiidae Galendromus Galendromus occidentalis
32319853 32319853 PRJNA358009_P_NODE_2759_length_327_cov_3.284173_g2696_i0 PRJNA358009 2759 327 3.284173 10.73924571 Parthenolecanium corni 536013 Arthropoda Arthropoda 73.9 1.04e-12   NR KAK7586115.1 536013 g2696 i0 97 0.302752293577982 33 1 30.3 0 99 1 248 280 KAK7586115.1 hypothetical protein V9T40_003991 [Parthenolecanium corni] diamond 99 73.9 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Coccidae Parthenolecanium Parthenolecanium corni
32351318 32351318 PRJNA358009_P_NODE_2579_length_327_cov_3.600719_g2516_i0 PRJNA358009 2579 327 3.600719 11.77435113 Polypterus senegalus 55291 Chordata Chordata 57 8.69e-7   NR KAG2456946.1 55291 g2516 i0 78.1 0.293577981651376 32 7 29.4 0 4 99 249 280 KAG2456946.1 TCB1 transposase, partial [Polypterus senegalus] diamond 96 57 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Polypterus Polypterus senegalus

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