RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA814235", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 19 ✖

tax_phylum 1

  • Pisuviricota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA814235 · 19 ✖

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
818737 818737 PRJNA814235_P_NODE_8801_length_635_cov_2.899666_g7723_i0 PRJNA814235 8801 635 2.899666 18.4128791 Comovirus raphani 3048290 Viruses Viruses 1051 0   NTclustered gi|213972516|dbj|AB456532.1| 328061 g7723 i0 96.535 8.99527559055118 635 22 100 0 1 635 1893 2527 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 5712 1051 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
3366753 3366753 PRJNA814235_P_NODE_142003_length_182_cov_1.579310_g140608_i0 PRJNA814235 142003 182 1.57931 2.8743442 Comovirus raphani 3048290 Viruses Viruses 298 1.8e-76   NTclustered gi|213972516|dbj|AB456532.1| 328061 g140608 i0 96.154 2 182 7 100 0 1 182 1786 1605 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 364 298 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
4644152 4644152 PRJNA814235_P_NODE_13204_length_523_cov_6.537037_g11950_i0 PRJNA814235 13204 523 6.537037 34.18870351 Porcine picobirnavirus 442302 Viruses Viruses 549 1.4899999999999993e-151   NTclustered gi|2095880661|gb|MW978536.1| 442302 g11950 i0 86.381 282.072657743786 514 57 96 13 1 504 2382 2892 MAG: Porcine picobirnavirus isolate 15217_NODE_84_len_2958_cov_626.749569 hypothetical protein and capsid protein-like gene, partial sequence blastn 147524 549 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Picobirnaviridae Orthopicobirnavirus Porcine picobirnavirus
4645150 4645150 PRJNA814235_P_NODE_175004_length_156_cov_0.974790_g173609_i0 PRJNA814235 175004 156 0.97479 1.5206724 Comovirus raphani 3048290 Viruses Viruses 278 1.95e-70   NTclustered gi|213972514|dbj|AB456531.1| 328061 g173609 i0 98.718 6.67948717948718 156 2 100 0 1 156 4383 4538 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 1042 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
7194587 7194587 PRJNA814235_P_NODE_162466_length_164_cov_2.700787_g161071_i0 PRJNA814235 162466 164 2.700787 4.42929068 Comovirus raphani 3048290 Viruses Viruses 287 3.45e-73   NTclustered gi|213972514|dbj|AB456531.1| 328061 g161071 i0 98.758 5.92073170731707 161 2 98 0 1 161 5815 5975 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 971 287 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
9746249 9746249 PRJNA814235_P_NODE_64988_length_236_cov_2.542714_g63593_i0 PRJNA814235 64988 236 2.542714 6.00080504 Comovirus raphani 3048290 Viruses Viruses 425 1.08e-114   NTclustered gi|213972516|dbj|AB456532.1| 328061 g63593 i0 99.153 2 236 2 100 0 1 236 1036 801 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 472 425 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
9746744 9746744 PRJNA814235_P_NODE_84948_length_206_cov_2.408284_g83553_i0 PRJNA814235 84948 206 2.408284 4.96106504 Comovirus raphani 3048290 Viruses Viruses 331 2.0700000000000002e-86   NTclustered gi|213972516|dbj|AB456532.1| 328061 g83553 i0 95.631 1 206 9 100 0 1 206 750 545 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 206 331 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
13570390 13570390 PRJNA814235_P_NODE_179931_length_153_cov_1.008621_g178536_i0 PRJNA814235 179931 153 1.008621 1.54319013 Comovirus raphani 3048290 Viruses Viruses 244 1.93e-60   NTclustered gi|213972514|dbj|AB456531.1| 328061 g178536 i0 95.425 2 153 7 100 0 1 153 2553 2705 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 306 244 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
13571123 13571123 PRJNA814235_P_NODE_35991_length_319_cov_1.382979_g34602_i0 PRJNA814235 35991 319 1.382979 4.41170301 Comovirus raphani 3048290 Viruses Viruses 507 5.31e-139   NTclustered gi|213972514|dbj|AB456531.1| 328061 g34602 i0 95.312 3.00940438871473 320 14 100 1 1 319 1491 1810 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 960 507 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
16119613 16119613 PRJNA814235_P_NODE_19353_length_434_cov_3.884131_g18004_i0 PRJNA814235 19353 434 3.884131 16.85712854 Comovirus raphani 3048290 Viruses Viruses 697 0   NTclustered gi|213972516|dbj|AB456532.1| 328061 g18004 i0 95.622 3.00460829493088 434 19 100 0 1 434 3703 3270 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 1304 697 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
16120075 16120075 PRJNA814235_P_NODE_32433_length_336_cov_1.257525_g31047_i0 PRJNA814235 32433 336 1.257525 4.225284 Comovirus raphani 3048290 Viruses Viruses 582 9.09e-162   NTclustered gi|213972514|dbj|AB456531.1| 328061 g31047 i0 97.917 7.99404761904762 336 7 100 0 1 336 5302 5637 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 2686 582 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
17803837 17803837 PRJNA814235_P_NODE_166174_length_162_cov_0.936000_g164779_i0 PRJNA814235 166174 162 0.936 1.51632 Alphapartitivirus 1511808 Viruses Viruses 298 1.57e-76   NTclustered gi|2107898052|gb|MT787572.1| 2043550 g164779 i0 100 31.2839506172839 161 0 99 0 1 161 1687 1847 Medicago sativa alphapartitivirus 1 isolate BJFi1 RNA-dependent RNA polymerase gene, complete cds blastn 5068 298 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Medicago sativa alphapartitivirus 1
18667641 18667641 PRJNA814235_P_NODE_154035_length_171_cov_1.932836_g152640_i0 PRJNA814235 154035 171 1.932836 3.30514956 Comovirus raphani 3048290 Viruses Viruses 274 2.8099999999999996e-69   NTclustered gi|213972516|dbj|AB456532.1| 328061 g152640 i0 96.386 4.88888888888889 166 6 97 0 6 171 1378 1213 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 836 274 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
18667930 18667930 PRJNA814235_P_NODE_16675_length_468_cov_1.480278_g15350_i0 PRJNA814235 16675 468 1.480278 6.92770104 Comovirus raphani 3048290 Viruses Viruses 821 0   NTclustered gi|213972514|dbj|AB456531.1| 328061 g15350 i0 98.291 5.9957264957265 468 8 100 0 1 468 5223 4756 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 2806 821 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
21218206 21218206 PRJNA814235_P_NODE_153017_length_172_cov_1.659259_g151622_i0 PRJNA814235 153017 172 1.659259 2.85392548 Comovirus raphani 3048290 Viruses Viruses 296 6.04e-76   NTclustered gi|213972514|dbj|AB456531.1| 328061 g151622 i0 98.225 6.87790697674419 169 3 98 0 1 169 673 841 Radish mosaic virus genomic RNA, segment RNA1, complete sequence, strain: California blastn 1183 296 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
21220163 21220163 PRJNA814235_P_NODE_5937_length_766_cov_2.636488_g5041_i0 PRJNA814235 5937 766 2.636488 20.19549808 Comovirus raphani 3048290 Viruses Viruses 1212 0   NTclustered gi|213972516|dbj|AB456532.1| 328061 g5041 i0 95.515 9.35248041775457 758 34 99 0 7 764 3259 2502 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 7164 1212 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
22493742 22493742 PRJNA814235_P_NODE_18998_length_439_cov_1.477612_g17654_i0 PRJNA814235 18998 439 1.477612 6.48671668 Comovirus raphani 3048290 Viruses Viruses 726 0   NTclustered gi|213972516|dbj|AB456532.1| 328061 g17654 i0 96.583 7.00227790432802 439 14 100 1 1 439 37 474 Radish mosaic virus genomic RNA, segment RNA2, complete sequence, strain: California blastn 3074 726 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Comovirus Comovirus raphani
29422617 29422617 PRJNA814235_P_NODE_9_length_9636_cov_40.366080_g5_i0 PRJNA814235 9 9636 40.36608 3889.6754688 Chemarfal virus 23 3062885 Viruses Viruses 750 1.5799999999999993e-217   NR WPR17962.1 3062885 g5 i0 27.5 0.799501867995019 2568 1512 75.7 82 7514 219 572 2925 WPR17962.1 MAG: capsid protein [Chemarfal virus 23] diamond 7704 750 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 23
32425638 32425638 PRJNA814235_P_NODE_39_length_4138_cov_111.524262_g24_i0 PRJNA814235 39 4138 111.524262 4614.87396156 Chemarfal virus 23 3062885 Viruses Viruses 325 1.4600000000000001e-86   NR WPR17962.1 3062885 g24 i0 31.8 0.602464958917351 831 469 56.4 24 2550 217 2140 2925 WPR17962.1 MAG: capsid protein [Chemarfal virus 23] diamond 2493 325 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 23

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