RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA695140" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA695140 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
26607625 26607625 PRJNA695140_S_NODE_3501_length_279_cov_1.979339_g3320_i0 PRJNA695140 3501 279 1.979339 5.52235581 Chemarfal virus 131 3062903 Viruses Viruses 50.1 1.63e-4   NR WPR17990.1 3062903 g3320 i0 42.4 0.634408602150538 59 34 63.4 0 73 249 625 683 WPR17990.1 MAG: capsid protein [Chemarfal virus 131] diamond 177 50.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 131
26639450 26639450 PRJNA695140_S_NODE_1241_length_480_cov_6.986456_g1062_i0 PRJNA695140 1241 480 6.9864560000000004 33.5349888 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 119 6.78e-28   NR UNY42125.1 3003959 g1062 i0 46.9 1.74375 130 67 80 2 389 6 150 279 UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 837 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26639457 26639457 PRJNA695140_S_NODE_7701_length_190_cov_2.535948_g7520_i0 PRJNA695140 7701 190 2.535948 4.8183012 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 52 1.02e-5   NR QDH87818.1 3003959 g7520 i0 38.7 0.978947368421053 62 36 94.7 1 8 187 350 411 QDH87818.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 186 52 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26670817 26670817 PRJNA695140_S_NODE_4901_length_237_cov_2.145000_g4720_i0 PRJNA695140 4901 237 2.145 5.08365 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 62 5.64e-9   NR XDO02803.1 3239337 g4720 i0 49.3 2.31645569620253 67 33 83.5 1 6 203 1548 1614 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 549 62 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
26829596 26829596 PRJNA695140_S_NODE_7961_length_187_cov_2.060000_g7780_i0 PRJNA695140 7961 187 2.06 3.8522 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 93.6 2.14e-20   NR WWZ85593.1 3132542 g7780 i0 66.7 1.01069518716578 63 19 97.9 1 185 3 2656 2718 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 189 93.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
26829597 26829597 PRJNA695140_S_NODE_9041_length_176_cov_7.510791_g8860_i0 PRJNA695140 9041 176 7.510791 13.21899216 Ulva picorna-like virus 3 3051531 Viruses Viruses 72.4 5.25e-13   NR WIR83950.1 3051531 g8860 i0 60.7 0.954545454545455 56 22 95.5 0 9 176 1227 1282 WIR83950.1 MAG: polyprotein [Ulva picorna-like virus 3] diamond 168 72.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Ulva picorna-like virus 3
26861478 26861478 PRJNA695140_S_NODE_5261_length_228_cov_5.785340_g5080_i0 PRJNA695140 5261 228 5.78534 13.1905752 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 66.2 1.64e-10   NR UNY42060.1 3003959 g5080 i0 55.4 0.973684210526316 74 30 97.4 2 228 7 184 254 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 222 66.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27430528 27430528 PRJNA695140_S_NODE_7103_length_198_cov_1.093168_g6922_i0 PRJNA695140 7103 198 1.093168 2.16447264 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 124 5.359999999999999e-31   NR WWZ85593.1 3132542 g6922 i0 84.6 0.984848484848485 65 10 98.5 0 196 2 1167 1231 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 195 124 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
27588268 27588268 PRJNA695140_S_NODE_1344_length_461_cov_5.209906_g1165_i0 PRJNA695140 1344 461 5.209906 24.01766666 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 192 1.47e-53   NR UNY42125.1 3003959 g1165 i0 59.2 0.956616052060738 147 60 95.7 0 18 458 1140 1286 UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 441 192 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27809369 27809369 PRJNA695140_S_NODE_1204_length_488_cov_2.015521_g1027_i0 PRJNA695140 1204 488 2.015521 9.83574248 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 99 1.3e-20   NR QDH87819.1 3003959 g1027 i0 50 1.22950819672131 88 44 54.1 0 66 329 151 238 QDH87819.1 MAG: hypothetical protein H4Bulk4834_000002 [Picornavirales sp.] diamond 600 99 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28219388 28219388 PRJNA695140_S_NODE_4846_length_238_cov_3.885572_g4665_i0 PRJNA695140 4846 238 3.885572 9.24766136 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 76.3 5.34e-14   NR UNY42060.1 3003959 g4665 i0 48.1 1.97899159663866 79 40 98.3 1 236 3 413 491 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 471 76.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28282575 28282575 PRJNA695140_S_NODE_906_length_565_cov_5.693182_g738_i0 PRJNA695140 906 565 5.693182 32.1664783 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 121 5.249999999999999e-28   NR UNY42125.1 3003959 g738 i0 51.6 1.04070796460177 95 46 50.4 0 563 279 1334 1428 UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 588 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28630300 28630300 PRJNA695140_S_NODE_7127_length_197_cov_3.912500_g6946_i0 PRJNA695140 7127 197 3.9125 7.707625 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 70.5 3.36e-12   NR UNY42060.1 3003959 g6946 i0 49.2 0.989847715736041 65 33 99 0 197 3 250 314 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 195 70.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28756354 28756354 PRJNA695140_S_NODE_6207_length_211_cov_2.413793_g6026_i0 PRJNA695140 6207 211 2.413793 5.09310323 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 48.5 2.23e-4   NR XDO02803.1 3239337 g6026 i0 35.7 0.995260663507109 70 42 95.3 1 9 209 1237 1306 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 210 48.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28914020 28914020 PRJNA695140_S_NODE_4588_length_245_cov_1.850962_g4407_i0 PRJNA695140 4588 245 1.850962 4.5348569 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 91.7 2.38e-19   NR XDO02803.1 3239337 g4407 i0 55.6 0.991836734693878 81 36 99.2 0 2 244 1700 1780 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 243 91.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
28946096 28946096 PRJNA695140_S_NODE_5028_length_234_cov_1.974619_g4847_i0 PRJNA695140 5028 234 1.974619 4.62060846 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 65.9 2.38e-10   NR XDO02803.1 3239337 g4847 i0 49.3 0.884615384615385 69 35 88.5 0 27 233 1460 1528 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 207 65.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
29115077 29115077 PRJNA695140_S_NODE_8428_length_182_cov_2.241379_g8247_i0 PRJNA695140 8428 182 2.241379 4.07930978 Viruses 10239 Viruses Viruses 56.2 2.87e-7   NR QDH87819.1 1955153 g8247 i0 50 2.86813186813187 58 29 95.6 0 5 178 76 133 QDH87819.1 MAG: hypothetical protein H4Bulk4834_000002 [Picornavirales sp.] diamond 522 56.6 0.992932862190813 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
30050921 30050921 PRJNA695140_S_NODE_4831_length_239_cov_0.955446_g4650_i0 PRJNA695140 4831 239 0.955446 2.28351594 Ginkgo biloba picorna-like virus 2739851 Viruses Viruses 58.5 9.6e-8   NR QKK82973.1 2739851 g4650 i0 46.6 1.9581589958159 73 36 87.9 2 212 3 820 892 QKK82973.1 hypothetical protein 2, partial [Ginkgo biloba picorna-like virus] diamond 468 58.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Ginkgo biloba picorna-like virus
30114178 30114178 PRJNA695140_S_NODE_6252_length_210_cov_3.531792_g6071_i0 PRJNA695140 6252 210 3.531792 7.4167632 Qianjiang picorna-like virus 65 3348793 Viruses Viruses 55.5 8.13e-7   NR XHA88545.1 3348793 g6071 i0 54.2 0.685714285714286 48 21 68.6 1 147 4 49 95 XHA88545.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 65] diamond 144 55.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 65
30304294 30304294 PRJNA695140_S_NODE_252_length_1127_cov_5.827523_g148_i0 PRJNA695140 252 1127 5.827523 65.67618421 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 209 9.02e-57   NR UNY42060.1 3003959 g148 i0 38.2 0.91304347826087 343 182 90 8 3 1016 506 823 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 1029 209 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30462220 30462220 PRJNA695140_S_NODE_6573_length_205_cov_5.380952_g6392_i0 PRJNA695140 6573 205 5.380952 11.0309516 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 89.7 6.19e-19   NR UNY42060.1 3003959 g6392 i0 59.7 0.980487804878049 67 27 98 0 3 203 307 373 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 201 89.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30588018 30588018 PRJNA695140_S_NODE_11693_length_158_cov_0.900826_g11512_i0 PRJNA695140 11693 158 0.900826 1.42330508 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 45.1 0.00181   NR XCM67741.1 3003959 g11512 i0 43.2 1.40506329113924 37 21 70.3 0 157 47 762 798 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 222 45.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30746150 30746150 PRJNA695140_S_NODE_10714_length_163_cov_5.166667_g10533_i0 PRJNA695140 10714 163 5.166667 8.42166721 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 78.2 4.07e-15   NR UNY42060.1 3003959 g10533 i0 66 0.975460122699387 53 18 97.5 0 162 4 368 420 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 159 78.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30967457 30967457 PRJNA695140_S_NODE_9114_length_176_cov_1.266187_g8933_i0 PRJNA695140 9114 176 1.266187 2.22848912 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 93.6 1.88e-20   NR WWZ85593.1 3132542 g8933 i0 73.2 0.954545454545455 56 15 95.5 0 5 172 1747 1802 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 168 93.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
31042125 31042125 PRJNA695140_S_NODE_12355_length_154_cov_1.974359_g12174_i0 PRJNA695140 12355 154 1.974359 3.04051286 Viruses 10239 Viruses Viruses 80.1 7.18e-16   NR XCM67941.1 1955153 g12174 i0 75.5 5.61038961038961 49 12 95.5 0 3 149 77 125 XCM67941.1 MAG: structural polyprotein [Picornavirales sp.] diamond 864 80.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
31156554 31156554 PRJNA695140_S_NODE_2695_length_318_cov_5.160142_g2514_i0 PRJNA695140 2695 318 5.160142 16.40925156 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 87 2.59e-17   NR UNY42125.1 3003959 g2514 i0 40.4 0.981132075471698 104 62 98.1 0 3 314 279 382 UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 312 87 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31346710 31346710 PRJNA695140_S_NODE_4716_length_241_cov_7.387255_g4535_i0 PRJNA695140 4716 241 7.387255 17.80328455 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 82.8 2.89e-16   NR UNY42060.1 3003959 g4535 i0 63.1 0.809128630705394 65 23 80.9 1 1 195 113 176 UNY42060.1 MAG: polyprotein 2 [Picornavirales sp.] diamond 195 82.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31473266 31473266 PRJNA695140_S_NODE_6876_length_201_cov_1.713415_g6695_i0 PRJNA695140 6876 201 1.713415 3.44396415 Penaeus vannamei picorna-like virus 1 3132564 Viruses Viruses 72 1.01e-12   NR WWZ85688.1 3132564 g6695 i0 69.6 2.05970149253731 46 14 68.7 0 200 63 86 131 WWZ85688.1 RNA-dependent RNA polymerase [Penaeus vannamei picorna-like virus 1] diamond 414 72 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Penaeus vannamei picorna-like virus 1
31631218 31631218 PRJNA695140_S_NODE_96_length_2158_cov_6.479491_g23_i0 PRJNA695140 96 2158 6.479491 139.82741578 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 605 1.4899999999999995e-196   NR UNY42125.1 3003959 g23 i0 44.7 2.13948100092678 767 372 99.8 11 2154 1 378 1141 UNY42125.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 4617 605 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31662728 31662728 PRJNA695140_S_NODE_1437_length_446_cov_3.066015_g1258_i0 PRJNA695140 1437 446 3.066015 13.6744269 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 53.5 5.6e-5   NR XDO02804.1 3239337 g1258 i0 29.4 2.01121076233184 153 87 98.2 5 445 8 872 1010 XDO02804.1 MAG: putative viral coat protein [Qianjiang picorna-like virus 22] diamond 897 53.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22
31884241 31884241 PRJNA695140_S_NODE_10997_length_162_cov_0.936000_g10816_i0 PRJNA695140 10997 162 0.936 1.51632 Qianjiang picorna-like virus 22 3239337 Viruses Viruses 70.9 1.47e-12   NR XDO02803.1 3239337 g10816 i0 55.8 0.962962962962963 52 23 96.3 0 3 158 1779 1830 XDO02803.1 MAG: polyprotein [Qianjiang picorna-like virus 22] diamond 156 70.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 22

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