RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA942359" 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

  • PRJNA942359 · 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
26867250 26867250 PRJNA942359_P_NODE_1_length_6986_cov_11.346159_g0_i0 PRJNA942359 1 6986 11.346159 792.64266774 Crogonang virus 23 3062946 Viruses Viruses 374 1.35e-100   NR WPR18076.1 3062946 g0 i0 34.1 0.691812195820212 768 450 31.6 23 4693 2483 339 1081 WPR18076.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 23] diamond 4833 374 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 23
26898799 26898799 PRJNA942359_P_NODE_2301_length_517_cov_1.051802_g2187_i0 PRJNA942359 2301 517 1.051802 5.43781634 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 129 5.989999999999999e-31   NR XCM67742.1 3003959 g2187 i0 43.4 1.01547388781431 175 78 99.8 5 517 2 85 241 XCM67742.1 MAG: structural polyprotein [Picornavirales sp.] diamond 525 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27119794 27119794 PRJNA942359_P_NODE_2002_length_552_cov_1.789144_g1888_i0 PRJNA942359 2002 552 1.789144 9.8760748799999991 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 50.1 0.002   NR XCM68034.1 3003959 g1888 i0 28.4 1.07065217391304 197 104 93.5 8 2 517 683 867 XCM68034.1 MAG: structural polyprotein [Picornavirales sp.] diamond 591 50.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27373252 27373252 PRJNA942359_P_NODE_5483_length_355_cov_1.106383_g5368_i0 PRJNA942359 5483 355 1.106383 3.92765965 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 78.6 3.87e-14   NR AVM87455.1 3063761 g5368 i0 35.2 1.03098591549296 122 72 97.2 1 350 6 861 982 AVM87455.1 polyprotein [Wenling hoplichthys picornavirus] diamond 366 78.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28256861 28256861 PRJNA942359_P_NODE_4306_length_391_cov_3.657233_g4191_i0 PRJNA942359 4306 391 3.657233 14.29978103 Picornaviridae sp. 1530251 Viruses Viruses 270 6.72e-81   NR XDJ26655.1 1530251 g4191 i0 100 0.989769820971867 129 0 99 0 389 3 307 435 XDJ26655.1 polyprotein [Picornaviridae sp.] diamond 387 270 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28351699 28351699 PRJNA942359_P_NODE_3646_length_419_cov_1.919075_g3531_i0 PRJNA942359 3646 419 1.919075 8.04092425 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 181 9.39e-50   NR AVM87439.1 3063761 g3531 i0 61.3 1.60381861575179 137 53 98.1 0 417 7 92 228 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 672 181 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28541399 28541399 PRJNA942359_P_NODE_5567_length_353_cov_1.114286_g5452_i0 PRJNA942359 5567 353 1.114286 3.93342958 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 122 1.56e-29   NR XCM67838.1 3003959 g5452 i0 51.3 0.994334277620397 117 55 97.7 1 351 7 655 771 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 351 122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28667650 28667650 PRJNA942359_P_NODE_3287_length_438_cov_2.736986_g3172_i0 PRJNA942359 3287 438 2.736986 11.98799868 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 166 2.1200000000000001e-44   NR AVM87439.1 3063761 g3172 i0 51.7 1.03424657534247 151 66 98.6 1 5 436 988 1138 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 453 166 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
29993765 29993765 PRJNA942359_P_NODE_1211_length_698_cov_2.740800_g1105_i0 PRJNA942359 1211 698 2.7408 19.130784 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 102 7.87e-21   NR XCM67741.1 3003959 g1105 i0 41.2 0.636103151862464 148 86 63.6 1 1 444 1972 2118 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 444 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30278390 30278390 PRJNA942359_P_NODE_3312_length_437_cov_1.706044_g3197_i0 PRJNA942359 3312 437 1.706044 7.45541228 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 135 9.11e-34   NR XCM68142.1 3003959 g3197 i0 49.3 1.97025171624714 144 69 98.2 2 1 429 279 419 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 861 135 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30341747 30341747 PRJNA942359_P_NODE_11972_length_261_cov_1.755319_g11857_i0 PRJNA942359 11972 261 1.755319 4.58138259 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 109 1.78e-25   NR AVM87439.1 3063761 g11857 i0 57.6 0.977011494252874 85 36 97.7 0 260 6 251 335 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 255 109 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
30752038 30752038 PRJNA942359_P_NODE_1194_length_704_cov_2.469097_g1089_i0 PRJNA942359 1194 704 2.469097 17.38244288 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 140 3.4199999999999992e-34   NR XCM68034.1 3003959 g1089 i0 41.6 1.84943181818182 202 88 86.1 5 697 92 450 621 XCM68034.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1302 140 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31327558 31327558 PRJNA942359_P_NODE_835_length_832_cov_2.168643_g736_i0 PRJNA942359 835 832 2.168643 18.04310976 Viruses 10239 Viruses Viruses 63.2 4.19e-7   NR WZH59727.1 3130490 g736 i0 28.6 2.09495192307692 189 117 64.9 6 255 794 572 751 WZH59727.1 MAG: RNA-dependent RNA polymerase [Ripidurd virus] diamond 1743 63.2 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Ripidurd virus
32428138 32428138 PRJNA942359_P_NODE_6679_length_328_cov_2.203922_g6564_i0 PRJNA942359 6679 328 2.203922 7.22886416 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 103 6.189999999999999e-23   NR XCM68033.1 3003959 g6564 i0 47.5 1.77439024390244 99 52 90.5 0 311 15 934 1032 XCM68033.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 582 103 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32774971 32774971 PRJNA942359_P_NODE_6020_length_343_cov_1.151852_g5905_i0 PRJNA942359 6020 343 1.151852 3.95085236 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 78.6 3.4e-14   NR XCM68033.1 3003959 g5905 i0 47.2 0.778425655976676 89 46 77.8 1 1 267 678 765 XCM68033.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 267 78.6 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);;