RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA565584" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA565584 · 14 ✖

analysis 1

  • diamond · 14 ✖
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
556053 556053 PRJNA565584_P_NODE_201_length_9209_cov_32.356611_g134_i0 PRJNA565584 201 9209 32.356611 2979.72030699 Hangzhou marna-like virus 1 3029006 Viruses Viruses 3395 0   NR WEU70895.1 3029006 g134 i0 62.6 0.891301987186448 2736 964 88.9 17 8372 186 12 2694 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 8208 3395 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
13310925 13310925 PRJNA565584_P_NODE_41991_length_462_cov_2.347044_g40840_i0 PRJNA565584 41991 462 2.347044 10.84334328 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 299 1.1e-90   NR XCM67774.1 3003959 g40840 i0 89.5 0.993506493506494 153 16 99.4 0 1 459 1522 1674 XCM67774.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 459 299 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26667574 26667574 PRJNA565584_P_NODE_148701_length_263_cov_1.594737_g147549_i0 PRJNA565584 148701 263 1.594737 4.19415831 Norovirus GI 122928 Viruses Viruses 44.3 0.014   NR AMD33537.1 122928 g147549 i0 30.9 0.923954372623574 81 55 91.3 1 243 4 190 270 AMD33537.1 polyprotein, partial [Norovirus GI] diamond 243 44.3 1 Viruses Norovirus GI Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae Norovirus Norovirus norwalkense
26730790 26730790 PRJNA565584_P_NODE_180621_length_248_cov_1.668571_g179469_i0 PRJNA565584 180621 248 1.668571 4.13805608 Qianjiang dicistro-like virus 45 3347460 Viruses Viruses 48.9 2.68e-4   NR XHA87792.1 3347460 g179469 i0 37.3 0.810483870967742 67 32 81 1 7 207 531 587 XHA87792.1 MAG: putative viral coat protein [Qianjiang dicistro-like virus 45] diamond 201 48.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 45
26889832 26889832 PRJNA565584_P_NODE_24941_length_623_cov_2.178182_g23807_i0 PRJNA565584 24941 623 2.178182 13.57007386 Patatavirales sp. 2809655 Viruses Viruses 100 2.2e-20   NR WRQ64764.1 2809655 g23807 i0 33.1 1.62760834670947 169 108 79 3 1 492 265 433 WRQ64764.1 polyprotein 2 [Patatavirales sp.] diamond 1014 100 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales     Patatavirales sp.
26984491 26984491 PRJNA565584_P_NODE_8882_length_1144_cov_3.309991_g8011_i0 PRJNA565584 8882 1144 3.309991 37.86629704 Durnavirales sp. 2809355 Viruses Viruses 193 5.97e-53   NR WRQ64726.1 2809355 g8011 i0 32.1 0.938811188811189 358 230 91.8 7 80 1129 10 362 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 1074 193 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
27945911 27945911 PRJNA565584_P_NODE_149245_length_263_cov_1.089474_g148093_i0 PRJNA565584 149245 263 1.089474 2.86531662 Zebrafish jaw picornavirus RQ13 Viruses Viruses 77.8 1.77e-14   NR ADI48258.1 RQ13 g148093 i0 58.8 2.29277566539924 51 21 58.2 0 108 260 139 189 ADI48258.1 3D, partial [Bat kobuvirus TM003k] diamond 603 77.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Kobuvirus Zebrafish jaw picornavirus
28721595 28721595 PRJNA565584_P_NODE_118487_length_283_cov_1.100000_g117335_i0 PRJNA565584 118487 283 1.1 3.113 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 47.4 0.0015   NR UNY41988.1 3003959 g117335 i0 33.7 1.74911660777385 86 43 76.3 1 216 1 1032 1117 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 495 47.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29163893 29163893 PRJNA565584_P_NODE_24549_length_629_cov_1.645683_g23415_i0 PRJNA565584 24549 629 1.645683 10.35134607 StochSev_1 picorna-like virus 3038638 Viruses Viruses 373 3.8199999999999997e-121   NR WFS39095.1 3038638 g23415 i0 84.7 0.996820349761526 209 32 99.7 0 627 1 562 770 WFS39095.1 MAG: putative capsid protein [StochSev_1 picorna-like virus] diamond 627 373 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   StochSev_1 picorna-like virus
29858206 29858206 PRJNA565584_P_NODE_25691_length_612_cov_1.387755_g24554_i0 PRJNA565584 25691 612 1.387755 8.4930606 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 362 3.389999999999999e-112   NR XCM67774.1 3003959 g24554 i0 80.3 0.995098039215686 203 40 99.5 0 611 3 979 1181 XCM67774.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 609 362 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30016396 30016396 PRJNA565584_P_NODE_93711_length_309_cov_2.330508_g92559_i0 PRJNA565584 93711 309 2.330508 7.20126972 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 207 3.71e-60   NR XCM67775.1 3003959 g92559 i0 96.1 1 103 4 100 0 1 309 401 503 XCM67775.1 MAG: structural polyprotein [Picornavirales sp.] diamond 309 207 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31375098 31375098 PRJNA565584_P_NODE_189156_length_246_cov_2.398844_g188004_i0 PRJNA565584 189156 246 2.398844 5.90115624 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 102 2.86e-23   NR XCM68071.1 3003959 g188004 i0 77.8 0.658536585365854 54 12 65.9 0 2 163 2014 2067 XCM68071.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 162 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32084560 32084560 PRJNA565584_P_NODE_101238_length_297_cov_1.026786_g100086_i0 PRJNA565584 101238 297 1.026786 3.04955442 Viruses 10239 Viruses Viruses 61.2 2.12e-8   NR USE08364.1 1955170 g100086 i0 43.4 2.44444444444444 76 36 69.7 1 81 287 148 223 USE08364.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.] diamond 726 61.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
32292773 32292773 PRJNA565584_P_NODE_195879_length_245_cov_0.895349_g194727_i0 PRJNA565584 195879 245 0.895349 2.19360505 Picornaviridae sp. 1530251 Viruses Viruses 72.8 6.79e-13   NR URG14875.1 1530251 g194727 i0 42.9 2.84081632653061 77 43 94.3 1 7 237 186 261 URG14875.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 696 72.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;