RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB73599" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB73599 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
135176 135176 PRJEB73599_P_NODE_3661_length_368_cov_1.769912_g3375_i0 PRJEB73599 3661 368 1.769912 6.51327616 Penaeus monodon 6687 Arthropoda Arthropoda 165 4.2999999999999995e-36   NTclustered gi|148646394|gb|EF426560.1| 6687 g3375 i0 85.185 5.6929347826087 162 22 44 2 3 163 1680 1520 Penaeus monodon elongation factor 2 mRNA, complete cds blastn 2095 165 1 Eukaryota Opisthokonta Metazoa Arthropoda Malacostraca Decapoda Penaeidae Penaeus Penaeus monodon
4823564 4823564 PRJEB73599_P_NODE_2464_length_470_cov_12.102041_g2196_i0 PRJEB73599 2464 470 12.102041 56.8795927 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 316 1.4699999999999996e-81   NTclustered gi|1230128092|ref|XM_022322392.1| 13164 g2196 i0 83.631 177.96170212766 336 55 71 0 135 470 795 460 PREDICTED: Myzus persicae polyubiquitin-G (LOC111039080), mRNA blastn 83642 316 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Myzus Myzus persicae
5237730 5237730 PRJEB73599_P_NODE_4665_length_308_cov_2.060932_g4378_i0 PRJEB73599 4665 308 2.060932 6.34767056 Drosophila serrata 7274 Arthropoda Arthropoda 326 1.53e-84   NTclustered gi|1189070371|ref|XM_020947228.1| 7274 g4378 i0 85.902 248.730519480519 305 43 99 0 2 306 2279 1975 PREDICTED: Drosophila serrata polyubiquitin-C (LOC110179621), mRNA blastn 76609 326 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Drosophilidae Drosophila Drosophila serrata
11613723 11613723 PRJEB73599_P_NODE_9270_length_166_cov_2.218978_g8983_i0 PRJEB73599 9270 166 2.218978 3.68350348 Psocoptera sp. PS02 1291676 Arthropoda Arthropoda 78.7 2.29e-10   NTclustered gi|449084630|gb|KC513101.1| 1291676 g8983 i0 92.593 0.650602409638554 54 4 33 0 113 166 1025 1078 Psocoptera sp. PS02 28S ribosomal RNA gene, partial sequence blastn 108 78.7 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Psocodea     Psocoptera sp. PS02
14163562 14163562 PRJEB73599_P_NODE_2592_length_457_cov_3.070093_g2319_i0 PRJEB73599 2592 457 3.070093 14.03032501 Vespula pensylvanica 30213 Arthropoda Arthropoda 182 5.42e-41   NTclustered gi|2098661466|ref|XM_043811691.1| 30213 g2319 i0 86.585 44.054704595186 164 22 36 0 252 415 294 131 PREDICTED: Vespula pensylvanica ubiquitin-40S ribosomal protein S27a (LOC122628880), mRNA blastn 20133 182 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hymenoptera Vespidae Vespula Vespula pensylvanica
16711831 16711831 PRJEB73599_P_NODE_2514_length_465_cov_6.465596_g2243_i0 PRJEB73599 2514 465 6.465596 30.0650214 Nanorchestes sp. AD1283 2051758 Arthropoda Arthropoda 89.8 3.44e-13   NTclustered gi|1282187771|gb|KY921976.1| 2051758 g2243 i0 88.889 15.305376344086 72 8 15 0 129 200 1698 1769 Nanorchestes sp. AD1283 voucher UMMZ BMOC 08-0812-002 AD1283 28S ribosomal RNA gene, partial sequence blastn 7117 89.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Sarcoptiformes Nanorchestidae Nanorchestes Nanorchestes sp. AD1283
16711832 16711832 PRJEB73599_P_NODE_2654_length_450_cov_3.624703_g2379_i0 PRJEB73599 2654 450 3.624703 16.3111635 Arthropoda environmental sample 260574 Arthropoda Arthropoda 520 9.939999999999997e-143   NTclustered gi|683809786|gb|KC266787.1| 260574 g2379 i0 98.328 99.9555555555555 299 0 66 5 153 450 1 295 Arthropoda environmental sample clone HENBPVM09FOE5C1 cytochrome c oxidase 1-like gene, partial sequence; mitochondrial blastn 44980 520 1 Eukaryota Opisthokonta Metazoa Arthropoda         Arthropoda environmental sample
16711846 16711846 PRJEB73599_P_NODE_4134_length_337_cov_3.957792_g3847_i0 PRJEB73599 4134 337 3.957792 13.33775904 Sitophilus oryzae 7048 Arthropoda Arthropoda 115 4e-21   NTclustered gi|1746720267|ref|XM_030895823.1| 7048 g3847 i0 92.5 6.10979228486647 80 6 24 0 1 80 1383 1462 PREDICTED: Sitophilus oryzae tubulin alpha-1 chain (LOC115879149), mRNA blastn 2059 115 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Curculionidae Sitophilus Sitophilus oryzae
19260757 19260757 PRJEB73599_P_NODE_2456_length_471_cov_2.208145_g2189_i0 PRJEB73599 2456 471 2.208145 10.40036295 Anopheles moucheti 186751 Arthropoda Arthropoda 52.8 0.046   NTclustered gi|2429159303|ref|XM_053034811.1| 186751 g2189 i0 100 0.059447983014862 28 0 6 0 411 438 2753 2726 PREDICTED: Anopheles moucheti centrosomal and chromosomal factor (LOC128298985), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Diptera Culicidae Anopheles Anopheles moucheti

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