RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJEB58983", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 8 ✖

tax_phylum 1

  • Pisuviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJEB58983 · 8 ✖

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
12878246 12878246 PRJEB58983_P_NODE_11_length_7976_cov_6.197900_g9_i0 PRJEB58983 11 7976 6.1979 494.344504 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1804 0   NR UNY42121.1 3003959 g9 i0 55 0.625501504513541 1663 711 62.4 12 7973 2997 113 1742 UNY42121.1 MAG: polyprotein 1 [Picornavirales sp.] diamond 4989 1804 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27917967 27917967 PRJEB58983_P_NODE_625_length_1631_cov_3.559692_g449_i0 PRJEB58983 625 1631 3.559692 58.05857652 Qianjiang dicistro-like virus 1 3347351 Viruses Viruses 308 9.349999999999998e-88   NR XHA87906.1 3347355 g449 i0 36.1 2.06192519926425 560 329 98.6 8 9 1616 1963 2517 XHA87906.1 MAG: polyprotein [Qianjiang dicistro-like virus 102] diamond 3363 308 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 102
28581242 28581242 PRJEB58983_P_NODE_7567_length_449_cov_4.795213_g7153_i0 PRJEB58983 7567 449 4.795213 21.53050637 Qianjiang dicistro-like virus 91 3347509 Viruses Viruses 55.5 1.3e-5   NR XHA87884.1 3347509 g7153 i0 25.2 0.76837416481069 115 86 76.8 0 105 449 407 521 XHA87884.1 MAG: polyprotein [Qianjiang dicistro-like virus 91] diamond 345 55.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 91
28833682 28833682 PRJEB58983_P_NODE_848_length_1415_cov_4.379285_g624_i0 PRJEB58983 848 1415 4.379285 61.96688275 Mute swan feces associated picorna-like virus 6 2832207 Viruses Viruses 268 7.000000000000001e-75   NR QUS52702.1 2832207 g624 i0 36.3 2.03533568904594 485 284 99.9 11 1415 3 1562 2035 QUS52702.1 polyprotein [Mute swan feces associated picorna-like virus 6] diamond 2880 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 6
29181179 29181179 PRJEB58983_P_NODE_14509_length_334_cov_2.904215_g14094_i0 PRJEB58983 14509 334 2.904215 9.7000781 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 48.5 0.00106   NR XCM67990.1 3003959 g14094 i0 35.2 0.790419161676647 88 56 79 1 28 291 571 657 XCM67990.1 MAG: polyprotein [Picornavirales sp.] diamond 264 48.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29685865 29685865 PRJEB58983_P_NODE_350_length_2037_cov_3.862525_g250_i0 PRJEB58983 350 2037 3.862525 78.67963425 Qianjiang dicistro-like virus 91 3347509 Viruses Viruses 264 2.68e-71   NR XHA87884.1 3347509 g250 i0 30.7 0.891016200294551 605 386 86.9 13 266 2035 939 1525 XHA87884.1 MAG: polyprotein [Qianjiang dicistro-like virus 91] diamond 1815 264 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 91
30570491 30570491 PRJEB58983_P_NODE_3493_length_658_cov_4.282051_g3090_i0 PRJEB58983 3493 658 4.282051 28.17589558 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 118 1.33e-26   NR XCM68093.1 3003959 g3090 i0 34.7 3.70668693009119 196 119 86.6 3 652 83 732 924 XCM68093.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 2439 118 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32310129 32310129 PRJEB58983_P_NODE_13399_length_346_cov_1.890110_g12984_i0 PRJEB58983 13399 346 1.89011 6.5397806 Partitiviridae sp. 1955170 Viruses Viruses 129 6.16e-33   NR USE08444.1 1955170 g12984 i0 53.5 1.97687861271676 114 53 98.8 0 5 346 255 368 USE08444.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.] diamond 684 129 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.

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