RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA641991 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
26701244 26701244 PRJNA641991_S_NODE_801_length_586_cov_2.130354_g691_i0 PRJNA641991 801 586 2.130354 12.48387444 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 121 6.93e-28   NR XCM67914.1 3003959 g691 i0 40.4 2.6877133105802 171 98 85.5 3 15 515 1879 2049 XCM67914.1 MAG: polyprotein [Picornavirales sp.] diamond 1575 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26828248 26828248 PRJNA641991_S_NODE_6301_length_218_cov_1.207101_g6182_i0 PRJNA641991 6301 218 1.207101 2.63148018 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 57.8 1.37e-7   NR WZI33513.1 3063761 g6182 i0 43.5 0.94954128440367 69 37 92.2 2 1 201 887 955 WZI33513.1 MAG: polyprotein, partial [Crohivirus A] diamond 207 57.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Crohivirus Danio blood picornavirus/Zebrafish picornavirus 2
27429155 27429155 PRJNA641991_S_NODE_4563_length_250_cov_1.716418_g4444_i0 PRJNA641991 4563 250 1.716418 4.2910450000000004 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 47.8 7.2e-4   NR XCM68033.1 3003959 g4444 i0 39.4 0.792 66 38 78 2 23 217 545 609 XCM68033.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 198 47.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27586851 27586851 PRJNA641991_S_NODE_1664_length_405_cov_1.741573_g1545_i0 PRJNA641991 1664 405 1.741573 7.05337065 Zebrafish jaw picornavirus RQ13 Viruses Viruses 132 1.3399999999999998e-32   NR XBH24011.1 RQ13 g1545 i0 54.5 2.98518518518519 134 54 97.8 5 5 400 1966 2094 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 1209 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
28692058 28692058 PRJNA641991_S_NODE_67_length_1478_cov_4.344997_g42_i0 PRJNA641991 67 1478 4.344997 64.21905566 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 106 3.23e-20   NR XCM68034.1 3003959 g42 i0 28.7 0.842354533152909 415 209 74.3 17 46 1143 525 901 XCM68034.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1245 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28849532 28849532 PRJNA641991_S_NODE_1428_length_441_cov_2.362245_g1309_i0 PRJNA641991 1428 441 2.362245 10.41750045 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 63.9 1.38e-8   NR XCM68142.1 3003959 g1309 i0 44.3 0.476190476190476 70 39 47.6 0 4 213 1495 1564 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 210 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29512621 29512621 PRJNA641991_S_NODE_170_length_1129_cov_4.179630_g120_i0 PRJNA641991 170 1129 4.17963 47.1880227 Zebrafish jaw picornavirus RQ13 Viruses Viruses 268 1.82e-76   NR XBH24011.1 RQ13 g120 i0 50 5.7422497785651 270 132 71.2 3 4 807 2117 2385 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 6483 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
30049472 30049472 PRJNA641991_S_NODE_3851_length_270_cov_3.936652_g3732_i0 PRJNA641991 3851 270 3.936652 10.6289604 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 96.3 8.28e-21   NR UNY41988.1 3003959 g3732 i0 53.6 1.92222222222222 84 37 91.1 1 267 22 2507 2590 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 519 96.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30207327 30207327 PRJNA641991_S_NODE_1772_length_393_cov_2.744186_g1653_i0 PRJNA641991 1772 393 2.744186 10.78465098 Zebrafish jaw picornavirus RQ13 Viruses Viruses 73.6 3.62e-12   NR QUS52515.1 RQ13 g1653 i0 37.9 0.946564885496183 124 64 93.1 5 25 390 1912 2024 QUS52515.1 polyprotein [ludopivirus A1] diamond 372 73.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Ludopivirus Zebrafish jaw picornavirus
31250256 31250256 PRJNA641991_P_NODE_2235_length_204_cov_0.987097_g2194_i0 PRJNA641991 2235 204 0.987097 2.01367788 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 49.7 8.03e-5   NR UNY41988.1 3003959 g2194 i0 37.7 0.897058823529412 61 38 89.7 0 188 6 2411 2471 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 183 49.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31661323 31661323 PRJNA641991_S_NODE_11577_length_169_cov_1.275000_g11458_i0 PRJNA641991 11577 169 1.275 2.15475 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 43.1 0.0104   NR XCM68033.1 3003959 g11458 i0 35.7 0.994082840236686 56 34 99.4 1 169 2 901 954 XCM68033.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 168 43.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31863429 31863429 PRJNA641991_S_NODE_2837_length_313_cov_1.761364_g2718_i0 PRJNA641991 2837 313 1.761364 5.51306932 Viruses 10239 Viruses Viruses 93.6 1.23e-19   NR AVM87418.1 2116203 g2718 i0 58.4 1.37060702875399 77 28 71.9 3 33 257 779 853 AVM87418.1 polyprotein [Yancheng osbecks grenadier anchovy picornavirus] diamond 429 93.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Yancheng osbecks grenadier anchovy picornavirus
32528271 32528271 PRJNA641991_S_NODE_1539_length_423_cov_2.267380_g1420_i0 PRJNA641991 1539 423 2.26738 9.5910174 Viruses 10239 Viruses Viruses 110 8.18e-25   NR WPV63372.1 3084702 g1420 i0 45.5 1.75886524822695 123 67 87.2 0 1 369 445 567 WPV63372.1 MAG: RNA-dependent RNA polymerase [Wenzhou shrew picornavirus 1] diamond 744 111 0.990990990990991 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Wenzhou shrew picornavirus 1
32547623 32547623 PRJNA641991_S_NODE_1279_length_466_cov_1.577938_g1160_i0 PRJNA641991 1279 466 1.577938 7.35319108 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 140 3.98e-35   NR XCM67742.1 3003959 g1160 i0 47.4 0.991416309012876 154 71 97.9 2 2 457 37 182 XCM67742.1 MAG: structural polyprotein [Picornavirales sp.] diamond 462 140 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32799172 32799172 PRJNA641991_P_NODE_480_length_519_cov_1.334043_g440_i0 PRJNA641991 480 519 1.334043 6.92368317 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 123 6.37e-29   NR XCM68034.1 3003959 g440 i0 45.4 1.65895953757225 141 70 81.5 2 517 95 455 588 XCM68034.1 MAG: structural polyprotein [Picornavirales sp.] diamond 861 123 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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