RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA400171 · 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
1688463 1688463 PRJNA400171_S_NODE_102_length_838_cov_6.331273_g45_i0 PRJNA400171 102 838 6.331273 53.05606774 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 211 1.77e-62   NR KAH9392627.1 59818 g45 i0 100 0.644391408114558 180 0 64.4 0 838 299 178 357 KAH9392627.1 hypothetical protein TYRP_005711 [Tyrophagus putrescentiae] diamond 540 211 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
27028882 27028882 PRJNA400171_S_NODE_7042_length_170_cov_3.234043_g6952_i0 PRJNA400171 7042 170 3.234043 5.4978731 Tenebrionidae 7065 Arthropoda Arthropoda 55.8 3.3e-7   NR KAH0810621.1 7067 g6952 i0 51.9 4.55294117647059 52 25 91.8 0 12 167 570 621 KAH0810621.1 hypothetical protein GEV33_012171 [Tenebrio molitor] diamond 774 55.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Tenebrionidae Tenebrio Tenebrio molitor
27233491 27233491 PRJNA400171_S_NODE_8743_length_155_cov_2.492063_g8653_i0 PRJNA400171 8743 155 2.492063 3.86269765 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 96.7 3.58e-22   NR KAH9392627.1 59818 g8653 i0 100 0.987096774193548 51 0 98.7 0 153 1 126 176 KAH9392627.1 hypothetical protein TYRP_005711 [Tyrophagus putrescentiae] diamond 153 96.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
27423323 27423323 PRJNA400171_S_NODE_8663_length_156_cov_1.976378_g8573_i0 PRJNA400171 8663 156 1.976378 3.08314968 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 110 1.18e-26   NR KAH9398535.1 59818 g8573 i0 100 1 52 0 100 0 156 1 89 140 KAH9398535.1 hypothetical protein TYRP_018777 [Tyrophagus putrescentiae] diamond 156 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
28433500 28433500 PRJNA400171_S_NODE_8566_length_157_cov_1.492188_g8476_i0 PRJNA400171 8566 157 1.492188 2.34273516 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 81.3 3.08e-16   NR KAH9389575.1 59818 g8476 i0 100 0.898089171974522 47 0 89.8 0 157 17 579 625 KAH9389575.1 hypothetical protein TYRP_007119 [Tyrophagus putrescentiae] diamond 141 81.3 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
29506860 29506860 PRJNA400171_S_NODE_3310_length_227_cov_2.666667_g3220_i0 PRJNA400171 3310 227 2.666667 6.05333409 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 160 9.45e-44   NR KAH9398535.1 59818 g3220 i0 100 0.991189427312775 75 0 99.1 0 1 225 526 600 KAH9398535.1 hypothetical protein TYRP_018777 [Tyrophagus putrescentiae] diamond 225 160 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30549300 30549300 PRJNA400171_S_NODE_6433_length_177_cov_2.527027_g6343_i0 PRJNA400171 6433 177 2.527027 4.47283779 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 85.5 5.35e-18   NR KAH9401307.1 59818 g6343 i0 90.6 0.898305084745763 53 5 89.8 0 162 4 52 104 KAH9401307.1 hypothetical protein TYRP_002906 [Tyrophagus putrescentiae] diamond 159 85.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
30707258 30707258 PRJNA400171_S_NODE_7434_length_167_cov_1.884058_g7344_i0 PRJNA400171 7434 167 1.884058 3.14637686 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 102 4.41e-24   NR KAH9400571.1 59818 g7344 i0 100 0.988023952095808 55 0 98.8 0 1 165 103 157 KAH9400571.1 hypothetical protein TYRP_002138 [Tyrophagus putrescentiae] diamond 165 102 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31040272 31040272 PRJNA400171_S_NODE_7015_length_171_cov_2.169014_g6925_i0 PRJNA400171 7015 171 2.169014 3.70901394 Sarcoptiformes 83137 Arthropoda Arthropoda 50.4 2.32e-5   NR XP_027199874.1 6956 g6925 i0 100 0.736842105263158 21 0 36.8 0 2 64 243 263 XP_027199874.1 14-3-3 protein zeta isoform X1 [Dermatophagoides pteronyssinus] diamond 126 50.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Pyroglyphidae Dermatophagoides Dermatophagoides pteronyssinus
31149234 31149234 PRJNA400171_S_NODE_2835_length_240_cov_2.848341_g2745_i0 PRJNA400171 2835 240 2.848341 6.8360184 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 112 2.61e-29   NR KAH9406926.1 59818 g2745 i0 100 0.7875 63 0 78.8 0 191 3 1 63 KAH9406926.1 DNA-binding protein inhibitor ID-2 [Tyrophagus putrescentiae] diamond 189 112 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae
31276045 31276045 PRJNA400171_S_NODE_5555_length_187_cov_3.234177_g5465_i0 PRJNA400171 5555 187 3.234177 6.04791099 Tyrophagus putrescentiae 59818 Arthropoda Arthropoda 51.6 6.21e-7   NR KAH9399596.1 59818 g5465 i0 100 0.401069518716578 25 0 40.1 0 185 111 25 49 KAH9399596.1 hypothetical protein TYRP_017584 [Tyrophagus putrescentiae] diamond 75 51.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Acaridae Tyrophagus Tyrophagus putrescentiae

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