RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA600413", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 10 ✖

tax_kingdom 1

  • Orthornavirae · 10 ✖

bioproject 1

  • PRJNA600413 · 10 ✖

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
572871 572871 PRJNA600413_P_NODE_111281_length_166_cov_0.871795_g110580_i0 PRJNA600413 111281 166 0.871795 1.4471797 Trichovirus mali 12175 Viruses Viruses 239 9.94e-59   NTclustered gi|1700710788|gb|MK929796.1| 12175 g110580 i0 92.727 24.4277108433735 165 12 99 0 1 165 5248 5084 Trichovirus mali isolate BR-Brae3, complete genome blastn 4055 239 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Trichovirus Trichovirus mali
573459 573459 PRJNA600413_P_NODE_152721_length_158_cov_2.807339_g152020_i0 PRJNA600413 152721 158 2.807339 4.43559562 Ilarvirus ApNMV 3429914 Viruses Viruses 287 3.29e-73   NTclustered gi|2705262685|gb|OR889814.1| 1779339 g152020 i0 99.367 20.873417721519 158 1 100 0 1 158 3120 2963 MAG: Apple necrotic mosaic virus isolate A11 segment RNA1, complete sequence blastn 3298 287 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
4401206 4401206 PRJNA600413_P_NODE_1544_length_1147_cov_3.121129_g1193_i0 PRJNA600413 1544 1147 3.121129 35.79934963 Ilarvirus ApNMV 3429914 Viruses Viruses 2063 0   NTclustered gi|2842974871|gb|OR801699.1| 1779339 g1193 i0 99.129 25.9886660854403 1148 9 100 1 1 1147 1532 385 Apple necrotic mosaic virus isolate A5 segment RNA1, complete sequence blastn 29809 2063 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
6952189 6952189 PRJNA600413_P_NODE_3086_length_835_cov_3.298982_g2567_i0 PRJNA600413 3086 835 3.298982 27.5464997 Ilarvirus ApNMV 3429914 Viruses Viruses 1520 0   NTclustered gi|2705262680|gb|OR889806.1| 1779339 g2567 i0 99.521 64.3796407185629 835 4 100 0 1 835 2288 1454 MAG: Apple necrotic mosaic virus isolate A15 segment RNA2, complete sequence blastn 53757 1520 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
10779568 10779568 PRJNA600413_P_NODE_909_length_1398_cov_3.359526_g660_i0 PRJNA600413 909 1398 3.359526 46.96617348 Ilarvirus ApNMV 3429914 Viruses Viruses 2514 0   NTclustered gi|2705262678|gb|OR889805.1| 1779339 g660 i0 99.211 25.7589413447783 1394 11 99 0 5 1398 2919 1526 MAG: Apple necrotic mosaic virus isolate A15 segment RNA1, complete sequence blastn 36011 2514 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
13326912 13326912 PRJNA600413_P_NODE_1131_length_1289_cov_3.029032_g849_i0 PRJNA600413 1131 1289 3.029032 39.04422248 Ilarvirus ApNMV 3429914 Viruses Viruses 2314 0   NTclustered gi|2705262680|gb|OR889806.1| 1779339 g849 i0 99.069 24.7013188518231 1289 12 100 0 1 1289 1300 12 MAG: Apple necrotic mosaic virus isolate A15 segment RNA2, complete sequence blastn 31840 2314 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
13328227 13328227 PRJNA600413_P_NODE_411_length_1886_cov_17.379423_g266_i0 PRJNA600413 411 1886 17.379423 327.77591778 Ilarvirus ApNMV 3429914 Viruses Viruses 3319 0   NTclustered gi|2705262682|gb|OR889807.1| 1779339 g266 i0 98.412 42.084835630965 1889 26 100 3 1 1886 24 1911 MAG: Apple necrotic mosaic virus isolate A15 segment RNA3, complete sequence blastn 79372 3319 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
19700061 19700061 PRJNA600413_P_NODE_153196_length_157_cov_3.768519_g152495_i0 PRJNA600413 153196 157 3.768519 5.91657483 Ilarvirus ApNMV 3429914 Viruses Viruses 283 4.22e-72   NTclustered gi|2705262678|gb|OR889805.1| 1779339 g152495 i0 99.359 21.8152866242038 156 1 99 0 2 157 3217 3062 MAG: Apple necrotic mosaic virus isolate A15 segment RNA1, complete sequence blastn 3425 283 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
19702026 19702026 PRJNA600413_P_NODE_9976_length_469_cov_2.138095_g9280_i0 PRJNA600413 9976 469 2.138095 10.02766555 Ilarvirus ApNMV 3429914 Viruses Viruses 861 0   NTclustered gi|2842974873|gb|OR801700.1| 1779339 g9280 i0 99.787 31.4456289978678 469 1 100 0 1 469 2748 2280 Apple necrotic mosaic virus isolate A5 segment RNA2, complete sequence blastn 14748 861 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV
23526069 23526069 PRJNA600413_P_NODE_20119_length_318_cov_2.635688_g19418_i0 PRJNA600413 20119 318 2.635688 8.38148784 Ilarvirus ApNMV 3429914 Viruses Viruses 571 1.8499999999999996e-158   NTclustered gi|2842974871|gb|OR801699.1| 1779339 g19418 i0 99.057 21.0377358490566 318 3 100 0 1 318 7 324 Apple necrotic mosaic virus isolate A5 segment RNA1, complete sequence blastn 6690 571 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus ApNMV

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