RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA520845", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Kitrinoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA520845 · 6 ✖

analysis 1

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
3040082 3040082 PRJNA520845_P_NODE_17043_length_941_cov_3.603687_g15853_i0 PRJNA520845 17043 941 3.603687 33.91069467 Potexvirus ecspotati 3433837 Viruses Viruses 1672 0   NTclustered gi|2025366110|gb|MT752864.1| 12183 g15853 i0 98.725 100.995749202976 941 12 100 0 1 941 6378 5438 Potato virus X isolate Jin170B, complete genome blastn 95037 1672 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspotati
9420335 9420335 PRJNA520845_P_NODE_44088_length_566_cov_2.527383_g42605_i0 PRJNA520845 44088 566 2.527383 14.30498778 Potexvirus ecspotati 3433837 Viruses Viruses 1000 0   NTclustered gi|2025365372|gb|MT752741.1| 12183 g42605 i0 98.584 99.773851590106 565 8 99 0 1 565 2804 3368 Potato virus X isolate Hco038-2, complete genome blastn 56472 1000 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspotati
10692018 10692018 PRJNA520845_P_NODE_139409_length_316_cov_2.366255_g137910_i0 PRJNA520845 139409 316 2.366255 7.4773658 Potexvirus ecspotati 3433837 Viruses Viruses 556 5.14e-154   NTclustered gi|2025366320|gb|MT752899.1| 12183 g137910 i0 98.418 100.25 316 5 100 0 1 316 5063 5378 Potato virus X isolate Lim089, complete genome blastn 31679 556 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspotati
13245175 13245175 PRJNA520845_P_NODE_25251_length_765_cov_3.050578_g23866_i0 PRJNA520845 25251 765 3.050578 23.3369217 Potexvirus ecspotati 3433837 Viruses Viruses 1308 0   NTclustered gi|2025366020|gb|MT752849.1| 12183 g23866 i0 97.516 100 765 19 100 0 1 765 2684 1920 Potato virus X isolate Jin134-2, complete genome blastn 76500 1308 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspotati
20889661 20889661 PRJNA520845_P_NODE_11617_length_1147_cov_2.222533_g10644_i0 PRJNA520845 11617 1147 2.222533 25.49245351 Potexvirus ecspotati 3433837 Viruses Viruses 1997 0   NTclustered gi|2025365972|gb|MT752841.1| 12183 g10644 i0 98.082 99.998256320837 1147 22 100 0 1 1147 14 1160 Potato virus X isolate Jin128, complete genome blastn 114698 1997 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspotati
23440417 23440417 PRJNA520845_P_NODE_13199_length_1076_cov_2.595214_g12151_i0 PRJNA520845 13199 1076 2.595214 27.92450264 Potexvirus ecspotati 3433837 Viruses Viruses 1849 0   NTclustered gi|2669656572|gb|OR991833.1| 12183 g12151 i0 97.677 99.9814126394052 1076 25 100 0 1 1076 4997 3922 MAG: Potato virus X isolate PLAVIT-IFA80, complete genome blastn 107580 1849 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus ecspotati

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