RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA611476" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA611476 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
18441231 18441231 PRJNA611476_P_NODE_2035_length_1381_cov_1.941131_g1522_i0 PRJNA611476 2035 1381 1.941131 26.80701911 Picornaviridae sp. 1530251 Viruses Viruses 890 1.55e-305   NR XDJ26655.1 1530251 g1522 i0 92.3 1.01882693700217 469 27 99.9 1 1380 1 1072 1540 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 1407 890 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
20991568 20991568 PRJNA611476_P_NODE_23097_length_418_cov_1.397101_g22306_i0 PRJNA611476 23097 418 1.397101 5.83988218 Apple latent spherical virus 101688 Viruses Viruses 213 6.25e-61   NR NP_620568.1 101688 g22306 i0 76.3 0.997607655502392 139 33 99.8 0 2 418 448 586 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 417 213 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
26649931 26649931 PRJNA611476_P_NODE_54401_length_296_cov_2.475336_g53610_i0 PRJNA611476 54401 296 2.475336 7.32699456 Zebrafish jaw picornavirus RQ13 Viruses Viruses 46.2 0.0044   NR UCS96340.1 RQ13 g53610 i0 40.8 3.31418918918919 71 40 69.9 1 13 219 1208 1278 UCS96340.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 981 46.6 0.991416309012876 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
26668416 26668416 PRJNA611476_P_NODE_29921_length_376_cov_1.283828_g29130_i0 PRJNA611476 29921 376 1.283828 4.82719328 Currant latent virus 1476584 Viruses Viruses 71.6 1.28e-11   NR WMN13751.1 1476584 g29130 i0 42.2 0.86968085106383 109 62 87 1 329 3 17 124 WMN13751.1 polyprotein [Currant latent virus] diamond 327 71.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
27522484 27522484 PRJNA611476_P_NODE_3143_length_1110_cov_1.689489_g2537_i0 PRJNA611476 3143 1110 1.689489 18.7533279 Zebrafish jaw picornavirus RQ13 Viruses Viruses 267 3.63e-76   NR XBH24011.1 RQ13 g2537 i0 51.7 4.18648648648649 259 123 69.5 2 6 776 2127 2385 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 4647 267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
27901227 27901227 PRJNA611476_P_NODE_19965_length_446_cov_1.139410_g19174_i0 PRJNA611476 19965 446 1.13941 5.0817686 Picornaviridae sp. 1530251 Viruses Viruses 276 5.57e-83   NR XDJ26655.1 1530251 g19174 i0 99.3 0.995515695067265 148 1 99.6 0 446 3 29 176 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 444 276 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28438372 28438372 PRJNA611476_P_NODE_67766_length_271_cov_1.166667_g66975_i0 PRJNA611476 67766 271 1.166667 3.16166757 Apple latent spherical virus 101688 Viruses Viruses 182 3.44e-51   NR NP_620568.1 101688 g66975 i0 95.5 1.97047970479705 89 4 98.5 0 269 3 1447 1535 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 534 182 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
28722495 28722495 PRJNA611476_P_NODE_54827_length_295_cov_1.734234_g54036_i0 PRJNA611476 54827 295 1.734234 5.1159903 Apple latent spherical virus 101688 Viruses Viruses 183 3.69e-51   NR NP_620568.1 101688 g54036 i0 90.8 1.99322033898305 98 9 99.7 0 1 294 1975 2072 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 588 183 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
29258883 29258883 PRJNA611476_P_NODE_39569_length_338_cov_1.490566_g38778_i0 PRJNA611476 39569 338 1.490566 5.03811308 Picornaviridae sp. 1530251 Viruses Viruses 209 4.56e-60   NR XDJ26655.1 1530251 g38778 i0 87.5 0.994082840236686 112 14 99.4 0 337 2 1530 1641 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 336 209 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29985441 29985441 PRJNA611476_P_NODE_26771_length_393_cov_1.968750_g25980_i0 PRJNA611476 26771 393 1.96875 7.7371875 Apple latent spherical virus 101688 Viruses Viruses 204 4.26e-58   NR NP_620569.1 101688 g25980 i0 96 2.26717557251908 99 4 75.6 0 1 297 863 961 NP_620569.1 108K polyprotein [Apple latent spherical virus] diamond 891 204 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali
30396618 30396618 PRJNA611476_P_NODE_47573_length_314_cov_2.182573_g46782_i0 PRJNA611476 47573 314 2.182573 6.85327922 Zebrafish jaw picornavirus RQ13 Viruses Viruses 63.9 3.25e-9   NR YP_009552756.1 RQ13 g46782 i0 40.7 3.14331210191083 108 59 99.4 3 1 312 1713 1819 YP_009552756.1 polyprotein [Rhimavirus A] diamond 987 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
31154061 31154061 PRJNA611476_P_NODE_41075_length_333_cov_2.026923_g40284_i0 PRJNA611476 41075 333 2.026923 6.74965359 Picornaviridae sp. 1530251 Viruses Viruses 216 1.21e-62   NR XDJ26655.1 1530251 g40284 i0 93.7 1 111 7 100 0 1 333 620 730 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 333 216 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31280814 31280814 PRJNA611476_P_NODE_24795_length_406_cov_1.228228_g24004_i0 PRJNA611476 24795 406 1.228228 4.98660568 Picornaviridae sp. 1530251 Viruses Viruses 278 1.28e-83   NR XDJ26655.1 1530251 g24004 i0 97 0.997536945812808 135 4 99.8 0 405 1 358 492 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 405 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32798086 32798086 PRJNA611476_P_NODE_51820_length_303_cov_1.339130_g51029_i0 PRJNA611476 51820 303 1.33913 4.0575639 Apple latent spherical virus 101688 Viruses Viruses 193 9.229999999999998e-55   NR NP_620568.1 101688 g51029 i0 91.9 1.96039603960396 99 8 98 0 2 298 1831 1929 NP_620568.1 235K polyprotein [Apple latent spherical virus] diamond 594 193 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus mali

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