RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA799842", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 13 ✖

tax_phylum 1

  • Kitrinoviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA799842 · 13 ✖

tax_clade 0

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
793694 793694 PRJNA799842_P_NODE_154181_length_248_cov_0.880000_g152608_i0 PRJNA799842 154181 248 0.88 2.1824 Tobamovirus odontoglossi 3432881 Viruses Viruses 449 6.81e-122   NTclustered gi|1861660922|dbj|LC556233.1| 12238 g152608 i0 99.593 16.8629032258065 246 1 99 0 1 246 15 260 Odontoglossum ringspot virus 1 ISC-2019-PKO gene for 183 kDa replicase protein, partial cds blastn 4182 449 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus odontoglossi
4623342 4623342 PRJNA799842_P_NODE_42944_length_434_cov_2.188366_g41372_i0 PRJNA799842 42944 434 2.188366 9.49750844 Tobamovirus tomatotessellati 3432892 Viruses Viruses 802 0   NTclustered gi|2463200702|gb|ON987477.1| 12253 g41372 i0 100 99.3271889400922 434 0 100 0 1 434 437 4 Tomato mosaic virus isolate NPPO-NL 41833930 RdRp, small replicase subunit, MP, and CP genes, complete cds blastn 43108 802 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
5899077 5899077 PRJNA799842_P_NODE_7225_length_1158_cov_1.277419_g6296_i0 PRJNA799842 7225 1158 1.277419 14.79251202 Tobamovirus tomatotessellati 3432892 Viruses Viruses 2111 0   NTclustered gi|2744300783|gb|PP915779.1| 12253 g6296 i0 99.568 99.2564766839378 1158 5 100 0 1 1158 3943 5100 Tomato mosaic virus isolate Pi20, complete genome blastn 114939 2111 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
5899604 5899604 PRJNA799842_P_NODE_97905_length_294_cov_1.036199_g96332_i0 PRJNA799842 97905 294 1.036199 3.04642506 Alphacarmovirus dianthi 3047728 Viruses Viruses 117 9.54e-22   NTclustered gi|2217167995|gb|OM867874.1| 11986 g96332 i0 98.485 8.07823129251701 66 1 22 0 1 66 3201 3136 Carnation mottle virus isolate DSMZ PV-1234, partial sequence blastn 2375 117 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae Alphacarmovirus Alphacarmovirus dianthi
12698249 12698249 PRJNA799842_P_NODE_129130_length_257_cov_1.255435_g127557_i0 PRJNA799842 129130 257 1.255435 3.22646795 Tobamovirus 12234 Viruses Viruses 475 1.1699999999999999e-129   NTclustered gi|2085776112|gb|MZ388458.1| 12253 g127557 i0 100 99.9922178988327 257 0 100 0 1 257 793 537 Tomato mosaic virus isolate ToMV-WF, complete genome blastn 25698 475 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
14822455 14822455 PRJNA799842_P_NODE_176792_length_243_cov_0.905882_g175219_i0 PRJNA799842 176792 243 0.905882 2.20129326 Pestivirus ovis 3052622 Viruses Viruses 52.8 0.022   NTclustered gi|3851352|gb|AF026726.1| 60990 g175219 i0 100 0.11522633744856 28 0 12 0 183 210 200 173 Border disease virus strain D1586/2 polyprotein gene, partial cds and partial 3'-noncoding region blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus ovis
18645599 18645599 PRJNA799842_P_NODE_175_length_3964_cov_37.838859_g109_i0 PRJNA799842 175 3964 37.838859 1499.93237076 Alphacarmovirus dianthi 3047728 Viruses Viruses 7055 0   NTclustered gi|2217167995|gb|OM867874.1| 11986 g109 i0 98.789 46.0146316851665 3965 47 100 1 1 3964 3972 8 Carnation mottle virus isolate DSMZ PV-1234, partial sequence blastn 182402 7055 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae Alphacarmovirus Alphacarmovirus dianthi
19921641 19921641 PRJNA799842_P_NODE_38356_length_462_cov_1.658098_g36785_i0 PRJNA799842 38356 462 1.658098 7.66041276 Tobamovirus tomatotessellati 3432892 Viruses Viruses 848 0   NTclustered gi|2085776112|gb|MZ388458.1| 12253 g36785 i0 99.784 99.8528138528139 462 1 100 0 1 462 5854 6315 Tomato mosaic virus isolate ToMV-WF, complete genome blastn 46132 848 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
22471223 22471223 PRJNA799842_P_NODE_178338_length_243_cov_0.905882_g176765_i0 PRJNA799842 178338 243 0.905882 2.20129326 Potexvirus ecspitayae 3433835 Viruses Viruses 448 2.39e-121   NTclustered gi|385282600|gb|JF930327.1| 1176736 g176765 i0 100 9.66666666666667 242 0 99 0 2 243 4257 4016 Pitaya virus X isolate P37, complete genome blastn 2349 448 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspitayae
22896100 22896100 PRJNA799842_P_NODE_11378_length_930_cov_2.256709_g10184_i0 PRJNA799842 11378 930 2.256709 20.9873937 Tobamovirus 12234 Viruses Viruses 1696 0   NTclustered gi|2744300783|gb|PP915779.1| 12253 g10184 i0 99.57 97.9698924731183 930 4 100 0 1 930 3164 2235 Tomato mosaic virus isolate Pi20, complete genome blastn 91112 1696 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
22896518 22896518 PRJNA799842_P_NODE_178618_length_243_cov_0.905882_g177045_i0 PRJNA799842 178618 243 0.905882 2.20129326 Alphaendornavirus 2003394 Viruses Viruses 388 1.47e-103   NTclustered gi|2837369272|gb|PQ408681.1| 362693 g177045 i0 95.473 7 243 11 100 0 1 243 2187 1945 Oryza sativa alphaendornavirus isolate Andong polyprotein gene, complete cds blastn 1701 388 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Endornaviridae Alphaendornavirus Alphaendornavirus oryzae
25021217 25021217 PRJNA799842_P_NODE_31580_length_515_cov_2.748869_g30016_i0 PRJNA799842 31580 515 2.748869 14.15667535 Tobamovirus tomatotessellati 3432892 Viruses Viruses 929 0   NTclustered gi|2744300783|gb|PP915779.1| 12253 g30016 i0 99.223 99.9961165048544 515 4 100 0 1 515 5245 5759 Tomato mosaic virus isolate Pi20, complete genome blastn 51498 929 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
29043710 29043710 PRJNA799842_P_NODE_162268_length_246_cov_0.890173_g160695_i0 PRJNA799842 162268 246 0.890173 2.18982558 Botryosphaeria dothidea botrexvirus 1 2785370 Viruses Viruses 102 9.87e-25   NR QQD86175.1 2785370 g160695 i0 59.8 1 82 33 100 0 1 246 129 210 QQD86175.1 coat protein [Botryosphaeria dothidea botrexvirus 1] diamond 246 102 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Botrexvirus Botryosphaeria dothidea botrexvirus 1

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