RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA855894" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 5 ✖

bioproject 1

  • PRJNA855894 · 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
9770025 9770025 PRJNA855894_P_NODE_19688_length_339_cov_0.928571_g19566_i0 PRJNA855894 19688 339 0.928571 3.14785569 Moss associated narna-like virus 24 3066983 Viruses Viruses 320 7.95e-83   NTclustered gi|2626077281|gb|OQ987521.1| 3066983 g19566 i0 84.226 9.71681415929203 336 46 99 7 4 337 729 1059 MAG: Moss associated narna-like virus 24 isolate DICBIL genomic sequence blastn 3294 320 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Moss associated narna-like virus 24
12321328 12321328 PRJNA855894_P_NODE_25350_length_286_cov_0.981221_g25228_i0 PRJNA855894 25350 286 0.981221 2.80629206 Potexvirus cymbidii 3433819 Viruses Viruses 490 4.729999999999998e-134   NTclustered gi|939193298|gb|KR185347.1| 12178 g25228 i0 97.552 29.8076923076923 286 7 100 0 1 286 3168 2883 Cymbidium mosaic virus isolate China, complete genome blastn 8525 490 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus cymbidii
16144609 16144609 PRJNA855894_P_NODE_13_length_4640_cov_6.881979_g12_i0 PRJNA855894 13 4640 6.881979 319.3238256 Potexvirus cymbidii 3433819 Viruses Viruses 8237 0   NTclustered gi|2232046865|gb|MW316659.1| 12178 g12 i0 98.707 32.9838362068966 4641 59 100 1 1 4640 9 4649 Cymbidium mosaic virus isolate Cy1, complete genome blastn 153045 8237 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus cymbidii
16145239 16145239 PRJNA855894_P_NODE_933_length_1555_cov_15.647420_g893_i0 PRJNA855894 933 1555 15.64742 243.317381 Potexvirus cymbidii 3433819 Viruses Viruses 2772 0   NTclustered gi|2700566920|gb|PP481412.1| 12178 g893 i0 98.842 59.9183279742765 1555 18 100 0 1 1555 4852 6406 Cymbidium mosaic virus isolate IFA191, complete genome blastn 93173 2772 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus cymbidii
21244033 21244033 PRJNA855894_P_NODE_18317_length_354_cov_1.370107_g18195_i0 PRJNA855894 18317 354 1.370107 4.85017878 Potexvirus cymbidii 3433819 Viruses Viruses 621 2.04e-173   NTclustered gi|2520252297|gb|OQ993367.1| 12178 g18195 i0 98.305 37.9774011299435 354 6 100 0 1 354 3695 3342 Cymbidium mosaic virus isolate DSMZ PV-1073, complete genome blastn 13444 621 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus cymbidii

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