RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA665531" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA665531 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
14658194 14658194 PRJNA665531_P_NODE_12692_length_291_cov_1.233945_g12456_i0 PRJNA665531 12692 291 1.233945 3.59077995 Trombidiformes 83136 Arthropoda Arthropoda 196 5.53e-59   NR XP_015793326.1 32264 g12456 i0 93.8 4.94845360824742 96 6 99 0 290 3 219 314 XP_015793326.1 rab GDP dissociation inhibitor beta [Tetranychus urticae] diamond 1440 197 0.99492385786802 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
27429370 27429370 PRJNA665531_P_NODE_13983_length_277_cov_1.509804_g13747_i0 PRJNA665531 13983 277 1.509804 4.18215708 Tetranychus urticae 32264 Arthropoda Arthropoda 164 1.91e-46   NR XP_015793326.1 32264 g13747 i0 90.1 2.95667870036101 91 9 98.6 0 275 3 21 111 XP_015793326.1 rab GDP dissociation inhibitor beta [Tetranychus urticae] diamond 819 164 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Tetranychidae Tetranychus Tetranychus urticae
27883219 27883219 PRJNA665531_P_NODE_14325_length_274_cov_1.338308_g14089_i0 PRJNA665531 14325 274 1.338308 3.66696392 Diptera 7147 Arthropoda Arthropoda 98.2 2.2699999999999994e-23   NR XP_037894365.1 7396 g14089 i0 63.3 2.7043795620438 79 23 86.5 1 238 2 49 121 XP_037894365.1 ADP-ribose glycohydrolase OARD1 isoform X1 [Glossina fuscipes] diamond 741 99 0.991919191919192 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
28313270 28313270 PRJNA665531_P_NODE_12026_length_299_cov_2.429204_g11790_i0 PRJNA665531 12026 299 2.429204 7.26331996 Pediculus humanus corporis 121224 Arthropoda Arthropoda 105 1.4699999999999999e-24   NR XP_002432521.1 121224 g11790 i0 50 0.862876254180602 86 43 86.3 0 260 3 10 95 XP_002432521.1 uncharacterized protein Phum_PHUM589680 [Pediculus humanus corporis] diamond 258 105 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea Pediculidae Pediculus Pediculus humanus
29039648 29039648 PRJNA665531_P_NODE_19048_length_242_cov_1.112426_g18812_i0 PRJNA665531 19048 242 1.112426 2.69207092 Notodromas monacha 399045 Arthropoda Arthropoda 42 0.00756   NR CAD7275672.1 399045 g18812 i0 43.6 0.91735537190082606 39 22 48.3 0 213 97 19 57 CAD7275672.1 unnamed protein product [Notodromas monacha] diamond 222 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Ostracoda Podocopida Cyprididae Notodromas Notodromas monacha
29146612 29146612 PRJNA665531_P_NODE_19289_length_241_cov_1.339286_g19053_i0 PRJNA665531 19289 241 1.339286 3.22767926 Insecta 50557 Arthropoda Arthropoda 166 2e-45   NR XP_069682867.1 6978 g19053 i0 91.1 8.91286307053942 79 7 98.3 0 241 5 1158 1236 XP_069682867.1 Ig-like and fibronectin type-III domain-containing protein 1 isoform X2 [Periplaneta americana] diamond 2148 167 0.994011976047904 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Blattidae Periplaneta Periplaneta americana
30903019 30903019 PRJNA665531_P_NODE_12174_length_297_cov_2.401786_g11938_i0 PRJNA665531 12174 297 2.401786 7.13330442 Dalotia coriaria 877792 Arthropoda Arthropoda 57.8 3.59e-7   NR XP_065171304.1 877792 g11938 i0 42.4 1.96969696969697 59 32 57.6 1 3 173 504 562 XP_065171304.1 LOW QUALITY PROTEIN: kelch-like protein 9 [Dalotia coriaria] diamond 585 57.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Staphylinidae Dalotia Dalotia coriaria
31736979 31736979 PRJNA665531_P_NODE_19777_length_234_cov_2.124224_g19541_i0 PRJNA665531 19777 234 2.124224 4.97068416 Metazoa 33208 Arthropoda Arthropoda 46.6 0.00144   NR DBA43570.1 207636 g19541 i0 47.7 3.6025641025641 44 22 55.1 1 231 103 338 381 DBA43570.1 TPA_asm: CYTB [Bombus haemorrhoidalis] diamond 843 47 0.991489361702128 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Apidae Bombus Bombus haemorrhoidalis

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