RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1122875" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1122875 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27375791 27375791 PRJNA1122875_P_NODE_3_length_5644_cov_12.296536_g2_i0 PRJNA1122875 3 5644 12.296536 694.01649184 Orthornavirae 2732396 Viruses Viruses 105 2.6e-19   NR WAY16551.1 2809883 g2 i0 25.9 0.737243090007087 494 276 26.1 13 4012 5484 1 407 WAY16551.1 hypothetical protein [Stellavirales sp.] diamond 4161 105 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales     Stellavirales sp.
28428251 28428251 PRJNA1122875_P_NODE_35286_length_279_cov_1.150485_g35062_i0 PRJNA1122875 35286 279 1.150485 3.20985315 Iflaviridae-like virus 3 3077009 Viruses Viruses 119 7.07e-29   NR WPR18798.1 3077009 g35062 i0 60 1.93548387096774 90 36 96.8 0 3 272 2685 2774 WPR18798.1 MAG: RNA-dependent RNA polymerase [Iflaviridae-like virus 3] diamond 540 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Iflaviridae-like virus 3
28459907 28459907 PRJNA1122875_P_NODE_23206_length_346_cov_1.380952_g22982_i0 PRJNA1122875 23206 346 1.380952 4.77809392 Lentinula eaodes hypovirus 2 2992848 Viruses Viruses 201 3.37e-57   NR UZA97544.1 2992848 g22982 i0 90.4 0.988439306358382 114 11 98.8 0 3 344 743 856 UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] diamond 342 201 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Hypovirus Lentinula eaodes hypovirus 2
29501548 29501548 PRJNA1122875_P_NODE_2350_length_919_cov_1.825059_g2196_i0 PRJNA1122875 2350 919 1.825059 16.77229221 Lentinula eaodes hypovirus 2 2992848 Viruses Viruses 565 2.609999999999999e-181   NR UZA97544.1 2992848 g2196 i0 96.4 0.998911860718172 306 11 99.9 0 918 1 432 737 UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] diamond 918 565 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Hypovirus Lentinula eaodes hypovirus 2
32030085 32030085 PRJNA1122875_P_NODE_21938_length_354_cov_1.597865_g21714_i0 PRJNA1122875 21938 354 1.597865 5.6564421 Lentinula eaodes hypovirus 2 2992848 Viruses Viruses 164 2.3999999999999996e-44   NR UZA97544.1 2992848 g21714 i0 91.9 0.728813559322034 86 7 72.9 0 259 2 1 86 UZA97544.1 RNA-dependent RNA polymerase [Lentinula eaodes hypovirus 2] diamond 258 164 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Hypovirus Lentinula eaodes hypovirus 2
32093280 32093280 PRJNA1122875_P_NODE_54678_length_227_cov_2.142857_g54454_i0 PRJNA1122875 54678 227 2.142857 4.86428539 Plasmopara viticola lesion associated Partitivirus 8 2692006 Viruses Viruses 61.2 9e-9   NR QHD64792.1 2692006 g54454 i0 47.2 0.700440528634361 53 28 70 0 160 2 271 323 QHD64792.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated Partitivirus 8] diamond 159 61.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Plasmopara viticola lesion associated Partitivirus 8

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