RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA358009 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
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
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
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
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

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