RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA415636 · 11 ✖

analysis 1

  • blastn · 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
419116 419116 PRJNA415636_S_NODE_6761_length_198_cov_2.384106_g6714_i0 PRJNA415636 6761 198 2.384106 4.72052988 Chlorops oryzae 1046848 Arthropoda Arthropoda 176 9.76e-40   NTclustered gi|1678416163|gb|MK225558.1| 1046848 g6714 i0 83.246 87.8030303030303 191 32 96 0 1 191 450 260 Chlorops oryzae actin mRNA, partial cds blastn 17385 176 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Chloropidae Chlorops Chlorops oryzae
2969828 2969828 PRJNA415636_S_NODE_903_length_420_cov_15.517426_g856_i0 PRJNA415636 903 420 15.517426 65.1731892 Timema californicum 61474 Arthropoda Arthropoda 56.5 0.003   NTclustered gi|1965181363|emb|OE475415.1| 61474 g856 i0 90.909 0.104761904761905 44 1 10 2 60 100 309 266 2_Tcm_b3v08 blastn 44 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema californicum
5522886 5522886 PRJNA415636_S_NODE_3745_length_255_cov_1.711538_g3698_i0 PRJNA415636 3745 255 1.711538 4.3644219 Chelidurella thaleri 2546182 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|2919608728|emb|OZ238409.1| 2546182 g3698 i0 100 0.333333333333333 29 0 11 0 217 245 17092230 17092202 Chelidura thaleri genome assembly, chromosome: 10 blastn 85 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Dermaptera Forficulidae Chelidurella Chelidurella thaleri
5522890 5522890 PRJNA415636_S_NODE_4665_length_234_cov_2.449198_g4618_i0 PRJNA415636 4665 234 2.449198 5.73112332 Rhagoletis zephyria 28612 Arthropoda Arthropoda 150 7.22e-32   NTclustered gi|1048065036|ref|XM_017608015.1| 28612 g4618 i0 88.618 2.85042735042735 123 14 53 0 112 234 428 306 PREDICTED: Rhagoletis zephyria 60S ribosomal protein L11 (LOC108356914), mRNA blastn 667 150 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Tephritidae Rhagoletis Rhagoletis zephyria
5522891 5522891 PRJNA415636_S_NODE_4885_length_230_cov_2.273224_g4838_i0 PRJNA415636 4885 230 2.273224 5.2284152 Glossina fuscipes 7396 Arthropoda Arthropoda 54.7 0.006   NTclustered gi|1939361499|ref|XM_038045242.1| 7396 g4838 i0 100 1.89130434782609 29 0 13 0 97 125 8392 8420 PREDICTED: Glossina fuscipes titin (LOC119645211), transcript variant X8, mRNA blastn 435 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Glossinidae Glossina Glossina fuscipes
11897955 11897955 PRJNA415636_S_NODE_6510_length_203_cov_2.243590_g6463_i0 PRJNA415636 6510 203 2.24359 4.5544877 Tetra sinicae 1316262 Arthropoda Arthropoda 110 1.04e-19   NTclustered gi|472278790|gb|KC422563.1| 1316262 g6463 i0 85.586 3.1871921182266 111 9 54 5 64 172 180 285 Tetra sinicae isolate OUT2 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 647 110 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Trombidiformes Eriophyidae Tetra Tetra sinicae
18934719 18934719 PRJNA415636_S_NODE_815_length_432_cov_5.735065_g768_i0 PRJNA415636 815 432 5.735065 24.7754808 Timema 61471 Arthropoda Arthropoda 54.7 0.012   NTclustered gi|1947819235|emb|OD566261.1| 61472 g768 i0 100 0.134259259259259 29 0 7 0 282 310 111505 111477 4_Tbi_b3v08 blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Phasmatodea Timematidae Timema Timema bartmani
19544934 19544934 PRJNA415636_S_NODE_3636_length_258_cov_2.658768_g3589_i0 PRJNA415636 3636 258 2.658768 6.85962144 Anopheles albimanus 7167 Arthropoda Arthropoda 67.6 8.39e-7   NTclustered gi|1894959010|ref|XM_035929323.1| 7167 g3589 i0 74.375 0.953488372093023 160 39 62 2 3 161 351 509 PREDICTED: Anopheles albimanus 40S ribosomal protein S24-like (LOC118463066), mRNA blastn 246 67.6 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles albimanus
19544936 19544936 PRJNA415636_S_NODE_4276_length_242_cov_1.830769_g4229_i0 PRJNA415636 4276 242 1.830769 4.43046098 Euthrix potatoria 624169 Arthropoda Arthropoda 93.5 1.28e-14   NTclustered gi|2918370000|emb|OZ237887.1| 624169 g4229 i0 91.176 1.38429752066116 68 6 28 0 145 212 13118106 13118039 Euthrix potatoria genome assembly, chromosome: 15 blastn 335 93.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Lepidoptera Lasiocampidae Euthrix Euthrix potatoria
19544938 19544938 PRJNA415636_S_NODE_4576_length_236_cov_1.015873_g4529_i0 PRJNA415636 4576 236 1.015873 2.3974602800000002 Zootermopsis nevadensis 136037 Arthropoda Arthropoda 215 2.55e-51   NTclustered gi|1227986958|ref|XM_022069474.1| 136037 g4529 i0 84.071 38.4110169491525 226 33 95 3 10 233 490 266 PREDICTED: Zootermopsis nevadensis RING-box protein 1A (LOC110832453), transcript variant X4, mRNA blastn 9065 215 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Blattodea Termopsidae Zootermopsis Zootermopsis nevadensis
23371226 23371226 PRJNA415636_S_NODE_5919_length_212_cov_33.254545_g5872_i0 PRJNA415636 5919 212 33.254545 70.4996354 Penaeus monodon 6687 Arthropoda Arthropoda 56.5 0.001   NTclustered gi|1832334880|gb|MK599468.1| 6687 g5872 i0 100 0.674528301886792 30 0 14 0 1 30 87 116 Penaeus monodon C-type lectin mRNA, complete cds blastn 143 56.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon

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