RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA493244", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 10 ✖

tax_phylum 1

  • Kitrinoviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493244 · 10 ✖

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
1730058 1730058 PRJNA493244_P_NODE_1268122_length_306_cov_34.432653_g1244998_i0 PRJNA493244 1268122 306 34.432653 105.36391818 Carlavirus uniglycinis 3427801 Viruses Viruses 516 8.42e-142   NTclustered gi|2500382213|ref|NC_076917.1| 2796532 g1244998 i0 99.645 3.40522875816993 282 1 92 0 2 283 8680 8399 Soybean carlavirus 1 strain SCV1-IL, complete genome blastn 1042 516 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus uniglycinis
1731072 1731072 PRJNA493244_P_NODE_1699382_length_204_cov_0.895105_g1676257_i0 PRJNA493244 1699382 204 0.895105 1.8260142 Potexvirus pepini 3433856 Viruses Viruses 377 2.59e-100   NTclustered gi|375808845|gb|JN835466.1| 112229 g1676257 i0 100 62.843137254902 204 0 100 0 1 204 1888 2091 Pepino mosaic virus strain CH2, complete genome blastn 12820 377 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
4928235 4928235 PRJNA493244_P_NODE_67744_length_1728_cov_7.638272_g62593_i0 PRJNA493244 67744 1728 7.638272 131.98934016 Tobamovirus 12234 Viruses Viruses 3081 0   NTclustered gi|927657516|dbj|LC082099.1| 12239 g62593 i0 98.843 95.9548611111111 1728 20 100 0 1 1728 3048 4775 Pepper mild mottle virus genomic RNA, complete genome, strain: P2 blastn 165810 3097 0.994833710041976 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus capsici
5560047 5560047 PRJNA493244_P_NODE_1733725_length_196_cov_2.770370_g1710600_i0 PRJNA493244 1733725 196 2.7703700000000002 5.4299252 Hainan alphaflexivirus 2 2824425 Viruses Viruses 87.9 4.65e-13   NTclustered gi|2075444288|gb|MW897284.1| 2824425 g1710600 i0 87.838 1.94897959183673 74 9 38 0 4 77 4236 4163 MAG: Hainan alphaflexivirus 2 isolate R87-k141_314575 replicase gene, partial cds; and NTP-binding helicase and hypothetical protein genes, complete cds blastn 382 87.9 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae   Hainan alphaflexivirus 2
6834489 6834489 PRJNA493244_P_NODE_316346_length_953_cov_4.123318_g300405_i0 PRJNA493244 316346 953 4.123318 39.29522054 Tobamovirus capsici 3432865 Viruses Viruses 1729 0   NTclustered gi|2737472510|dbj|LC817996.1| 12239 g300405 i0 99.474 94.0745015739769 951 5 99 0 1 951 4606 5556 Pepper mild mottle virus PMMoV_YE_CNU1 genes for replication-associated protein, movement protein, coat protein, complete cds blastn 89653 1729 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus capsici
9384016 9384016 PRJNA493244_P_NODE_1603808_length_219_cov_7.841772_g1580683_i0 PRJNA493244 1603808 219 7.841772 17.17348068 Potexvirus pepini 3433856 Viruses Viruses 326 1.0299999999999999e-84   NTclustered gi|375808845|gb|JN835466.1| 112229 g1580683 i0 99.441 76.1552511415525 179 1 82 0 1 179 6412 6234 Pepino mosaic virus strain CH2, complete genome blastn 16678 326 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus pepini
10658461 10658461 PRJNA493244_P_NODE_1004189_length_405_cov_2.220930_g981096_i0 PRJNA493244 1004189 405 2.22093 8.9947665 Tobamovirus tabaci 3432891 Viruses Viruses 723 0   NTclustered gi|388240269|emb|HE818446.1| 12242 g981096 i0 99.746 97.2888888888889 394 1 97 0 1 394 3812 3419 Tobacco mosaic virus isolate Wenxing, complete genome blastn 39402 723 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
12578481 12578481 PRJNA493244_P_NODE_1017410_length_399_cov_3.218935_g994310_i0 PRJNA493244 1017410 399 3.218935 12.84355065 Pestivirus 11095 Viruses Viruses 58.4 8.22e-4   NTclustered gi|3851366|gb|AF026733.1| 61001 g994310 i0 100 0.380952380952381 31 0 8 0 6 36 171 141 Border disease virus strain V1414 polyprotein gene, partial cds and partial 3'-noncoding region blastn 152 58.4 1 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus ovis
28276489 28276489 PRJNA493244_P_NODE_367266_length_879_cov_10.913203_g349853_i0 PRJNA493244 367266 879 10.913203 95.92705437 Tomato associated alphaendornavirus 1 2950884 Viruses Viruses 522 3.329999999999999e-166   NR UTQ50503.1 2950884 g349853 i0 89.8 0.969283276450512 284 29 96.9 0 853 2 2599 2882 UTQ50503.1 MAG: polyprotein (domains: helicase - caspase/glycosyltransferase - RNA-dependent RNA polymerase) [Tomato associated alphaendornavirus 1] diamond 852 522 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Endornaviridae Alphaendornavirus Tomato associated alphaendornavirus 1
29918632 29918632 PRJNA493244_P_NODE_1222211_length_321_cov_2.961538_g1199087_i0 PRJNA493244 1222211 321 2.961538 9.50653698 Tomato associated alphaendornavirus 1 2950884 Viruses Viruses 209 4.8899999999999997e-60   NR UTQ50503.1 2950884 g1199087 i0 91.5 0.990654205607477 106 9 99.1 0 319 2 1817 1922 UTQ50503.1 MAG: polyprotein (domains: helicase - caspase/glycosyltransferase - RNA-dependent RNA polymerase) [Tomato associated alphaendornavirus 1] diamond 318 209 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Endornaviridae Alphaendornavirus Tomato associated alphaendornavirus 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);;