RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA715462", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Kitrinoviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA715462 · 4 ✖

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
5810025 5810025 PRJNA715462_P_NODE_63585_length_244_cov_0.900585_g62789_i0 PRJNA715462 63585 244 0.900585 2.1974274 Maculavirus vitis 3047853 Viruses Viruses 424 4.05e-114   NTclustered gi|2269685740|gb|ON567253.1| 103722 g62789 i0 97.951 30.6475409836066 244 5 100 0 1 244 5538 5781 Grapevine fleck virus isolate A1567c replicase (REP) and coat protein (CP) genes, complete cds; and hypothetical protein (ORF3) and hypothetical protein (ORF4) genes, partial cds blastn 7478 424 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Maculavirus Maculavirus vitis
8359437 8359437 PRJNA715462_P_NODE_49547_length_253_cov_1.688889_g48751_i0 PRJNA715462 49547 253 1.688889 4.27288917 Foveavirus rupestris 3428812 Viruses Viruses 462 8.95e-126   NTclustered gi|2289713684|gb|MZ484931.1| 196400 g48751 i0 99.605 100.138339920949 253 1 100 0 1 253 8331 8583 Grapevine rupestris stem pitting-associated virus isolate 16GVP043B, complete genome blastn 25335 462 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Foveavirus rupestris
13459727 13459727 PRJNA715462_P_NODE_43451_length_271_cov_0.904040_g42655_i0 PRJNA715462 43451 271 0.90404 2.4499484 Maculavirus vitis 3047853 Viruses Viruses 468 2.08e-127   NTclustered gi|2269685798|gb|ON584185.1| 103722 g42655 i0 97.786 83.8671586715867 271 6 100 0 1 271 5600 5330 Grapevine fleck virus isolate A1587c, partial genome blastn 22728 468 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae Maculavirus Maculavirus vitis
18557504 18557504 PRJNA715462_P_NODE_27515_length_342_cov_1.427509_g26719_i0 PRJNA715462 27515 342 1.427509 4.88208078 Foveavirus rupestris 3428812 Viruses Viruses 632 9.079999999999999e-177   NTclustered gi|2289713751|gb|MZ484941.1| 196400 g26719 i0 100 99.827485380117 342 0 100 0 1 342 8546 8205 Grapevine rupestris stem pitting-associated virus isolate 16GVP057B, complete genome blastn 34141 632 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Foveavirus Foveavirus rupestris

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