RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1233317" and tax_phylum = "Arthropoda"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Arthropoda · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1233317 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
23287907 23287907 PRJNA1233317_S_NODE_3279_length_353_cov_5.472789_g3243_i0 PRJNA1233317 3279 353 5.472789 19.31894517 Arthropoda 6656 Arthropoda Arthropoda 155 4.09e-41   NR XP_021957688.1 158441 g3243 i0 73.5 2.96600566572238 117 31 99.4 0 353 3 1711 1827 XP_021957688.1 myosin heavy chain, muscle [Folsomia candida] diamond 1047 155 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Isotomidae Folsomia Folsomia candida
26660943 26660943 PRJNA1233317_S_NODE_6681_length_291_cov_3.396552_g6645_i0 PRJNA1233317 6681 291 3.396552 9.88396632 Orchesella dallaii 48710 Arthropoda Arthropoda 51.2 7.04e-5   NR CAL8108590.1 48710 g6645 i0 56.9 0.597938144329897 58 22 59.8 1 93 266 536 590 CAL8108590.1 unnamed protein product [Orchesella dallaii] diamond 174 51.2 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella dallaii
28462580 28462580 PRJNA1233317_S_NODE_14446_length_202_cov_2.433566_g14410_i0 PRJNA1233317 14446 202 2.433566 4.91580332 Amphibalanus amphitrite 1232801 Arthropoda Arthropoda 42.4 0.0292   NR XP_043201209.1 1232801 g14410 i0 37.9 1.72277227722772 58 36 86.1 0 2 175 100 157 XP_043201209.1 uncharacterized protein LOC122370034 [Amphibalanus amphitrite] diamond 348 42.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Thecostraca Balanomorpha Balanidae Amphibalanus Amphibalanus amphitrite
29902076 29902076 PRJNA1233317_S_NODE_1671_length_406_cov_8.311239_g1635_i0 PRJNA1233317 1671 406 8.311239 33.74363034 root 1 Root_unresolved Root_unresolved 53.1 5.15e-5   NR GBN61280.1 182803 g1635 i0 50.9 3.60591133004926 53 26 39.2 0 120 278 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
30989157 30989157 PRJNA1233317_S_NODE_14134_length_204_cov_6.731034_g14098_i0 PRJNA1233317 14134 204 6.731034 13.73130936 Rhipicephalus appendiculatus 34631 Arthropoda Arthropoda 42 0.0409   NR KAL1441120.1 34631 g14098 i0 51.6 0.455882352941176 31 15 45.6 0 158 66 117 147 KAL1441120.1 hypothetical protein MTO96_008861 [Rhipicephalus appendiculatus] diamond 93 42 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Rhipicephalus Rhipicephalus appendiculatus
31577005 31577005 PRJNA1233317_S_NODE_3036_length_360_cov_3.275748_g3000_i0 PRJNA1233317 3036 360 3.275748 11.7926928 Caerostris 172845 Arthropoda Arthropoda 42 0.0324   NR GIY98085.1 172846 g3000 i0 40 0.933333333333333 55 29 42.5 2 213 61 10 64 GIY98085.1 hypothetical protein CEXT_436691 [Caerostris extrusa] diamond 336 42.4 0.990566037735849 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Caerostris Caerostris extrusa
31747809 31747809 PRJNA1233317_S_NODE_1377_length_425_cov_3.655738_g1341_i0 PRJNA1233317 1377 425 3.655738 15.5368865 Henosepilachna vigintioctopunctata 420089 Arthropoda Arthropoda 45.4 0.027   NR KAK9885449.1 420089 g1341 i0 38.7 0.437647058823529 62 34 41.6 2 200 24 69 129 KAK9885449.1 hypothetical protein WA026_010945 [Henosepilachna vigintioctopunctata] diamond 186 45.4 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Coleoptera Coccinellidae Henosepilachna Henosepilachna vigintioctopunctata

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