RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB48218" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB48218 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
6440934 6440934 PRJEB48218_S_NODE_7526_length_351_cov_3.310559_g6564_i0 PRJEB48218 7526 351 3.310559 11.62006209 Potexvirus flavitrifolii 3433843 Viruses Viruses 562 1.2399999999999997e-155   NTclustered gi|2217161454|gb|OL584354.1| 12177 g6564 i0 96.736 11.9287749287749 337 11 96 0 1 337 6679 7015 Clover yellow mosaic virus isolate DSMZ PV-0851 genomic sequence blastn 4187 562 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus flavitrifolii
8989775 8989775 PRJEB48218_S_NODE_29328_length_155_cov_1.952381_g28366_i0 PRJEB48218 29328 155 1.952381 3.02619055 Potexvirus trifolii 3433859 Viruses Viruses 226 7.1e-55   NTclustered gi|1843793411|gb|MN399740.1| 12188 g28366 i0 92.903 9.92258064516129 155 11 100 0 1 155 2151 1997 White clover mosaic virus isolate Muenster_18 RNA replication protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds blastn 1538 226 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
12816215 12816215 PRJEB48218_S_NODE_5771_length_431_cov_9451.810945_g4816_i0 PRJEB48218 5771 431 9451.810945 40737.30517295 Potexvirus flavitrifolii 3433843 Viruses Viruses 529 1.5799999999999993e-145   NTclustered gi|9629178|ref|NC_001753.1| 12177 g4816 i0 97.125 189.969837587007 313 9 73 0 1 313 313 1 Clover yellow mosaic virus, complete genome blastn 81877 529 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus flavitrifolii
20463291 20463291 PRJEB48218_S_NODE_16077_length_232_cov_1.822660_g15115_i0 PRJEB48218 16077 232 1.82266 4.2285712 Potexvirus trifolii 3433859 Viruses Viruses 366 6.52e-97   NTclustered gi|61317|emb|X06728.1| 12188 g15115 i0 97.222 18.2025862068966 216 6 93 0 17 232 2484 2699 Potexvirus white clover mosaic virus (WC1MV) RNA genome blastn 4223 366 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii
21739503 21739503 PRJEB48218_S_NODE_7758_length_343_cov_3.073248_g6796_i0 PRJEB48218 7758 343 3.073248 10.54124064 Potexvirus trifolii 3433859 Viruses Viruses 599 9.239999999999999e-167   NTclustered gi|1843793429|gb|MN399743.1| 12188 g6796 i0 99.394 22.1195335276968 330 2 96 0 14 343 632 303 White clover mosaic virus isolate Landkreis Rostock_18 RNA replication protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds blastn 7587 599 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus trifolii

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