RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA508758" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA508758 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
18336375 18336375 PRJNA508758_P_NODE_5375_length_1048_cov_2.548718_g4655_i0 PRJNA508758 5375 1048 2.548718 26.71056464 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 656 1.51e-213   NR UNY42028.1 3003959 g4655 i0 93.4 1.99809160305344 349 23 99.9 0 1 1047 1820 2168 UNY42028.1 MAG: polyprotein [Picornavirales sp.] diamond 2094 656 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27645989 27645989 PRJNA508758_P_NODE_15044_length_528_cov_1.015385_g14013_i0 PRJNA508758 15044 528 1.015385 5.3612328 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 191 1.74e-52   NR UNY42028.1 3003959 g14013 i0 57.8 2.04545454545455 180 71 100 3 1 528 1917 2095 UNY42028.1 MAG: polyprotein [Picornavirales sp.] diamond 1080 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28103089 28103089 PRJNA508758_P_NODE_51525_length_296_cov_1.381166_g50477_i0 PRJNA508758 51525 296 1.381166 4.08825136 Picornavirales 464095 Viruses Viruses 101 1.99e-22   NR UNY42173.1 1955153 g50477 i0 49 4.83445945945946 96 49 97.3 0 295 8 1297 1392 UNY42173.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 1431 102 0.990196078431373 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
28119341 28119341 PRJNA508758_P_NODE_57765_length_282_cov_1.827751_g56717_i0 PRJNA508758 57765 282 1.827751 5.15425782 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 176 8e-49   NR UNY42028.1 3003959 g56717 i0 88.2 0.98936170212766 93 11 98.9 0 281 3 223 315 UNY42028.1 MAG: polyprotein [Picornavirales sp.] diamond 279 176 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28593105 28593105 PRJNA508758_P_NODE_36127_length_343_cov_1.140741_g35079_i0 PRJNA508758 36127 343 1.140741 3.91274163 Flumine Astrovirus 22 2940951 Viruses Viruses 148 2.62e-41   NR UQB75984.1 2940951 g35079 i0 67.5 0.997084548104956 114 37 99.7 0 1 342 93 206 UQB75984.1 RNA-dependent RNA polymerase [Flumine Astrovirus 22] diamond 342 148 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Flumine Astrovirus 22
28656249 28656249 PRJNA508758_P_NODE_29207_length_375_cov_1.274834_g28159_i0 PRJNA508758 29207 375 1.274834 4.7806275 Stellavirales sp. 2809883 Viruses Viruses 179 2.23e-49   NR WAY16553.1 2809883 g28159 i0 70.2 0.992 124 37 99.2 0 374 3 873 996 WAY16553.1 RNA-dependent RNA polymerase, partial [Stellavirales sp.] diamond 372 179 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales     Stellavirales sp.
28940507 28940507 PRJNA508758_P_NODE_10628_length_655_cov_2.192440_g9649_i0 PRJNA508758 10628 655 2.19244 14.360482 Stellavirales sp. 2809883 Viruses Viruses 225 4.26e-64   NR WAY16553.1 2809883 g9649 i0 54.8 0.993893129770992 217 95 99.4 1 653 3 594 807 WAY16553.1 RNA-dependent RNA polymerase, partial [Stellavirales sp.] diamond 651 225 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales     Stellavirales sp.
29413826 29413826 PRJNA508758_P_NODE_16889_length_494_cov_1.463183_g15842_i0 PRJNA508758 16889 494 1.463183 7.22812402 Qianjiang marna-like virus 162 3347588 Viruses Viruses 95.5 2.41e-19   NR XHA88335.1 3347588 g15842 i0 47.9 0.582995951417004 96 49 57.7 1 290 6 1092 1187 XHA88335.1 MAG: polyprotein [Qianjiang marna-like virus 162] diamond 288 95.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 162
30171848 30171848 PRJNA508758_P_NODE_67992_length_262_cov_1.296296_g66944_i0 PRJNA508758 67992 262 1.296296 3.39629552 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 142 5.99e-37   NR XCM68434.1 3003959 g66944 i0 74.7 0.950381679389313 83 21 95 0 250 2 615 697 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 249 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32416838 32416838 PRJNA508758_P_NODE_88359_length_241_cov_0.916667_g87311_i0 PRJNA508758 88359 241 0.916667 2.20916747 Zebrafish gut calicivirus RQ08 Viruses Viruses 120 1.2299999999999998e-29   NR DAZ91097.1 RQ08 g87311 i0 62.5 0.995850622406639 80 30 99.6 0 241 2 1792 1871 DAZ91097.1 TPA_asm: nonstructural protein, partial [Newt calicivirus] diamond 240 120 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Zebrafish gut calicivirus
32732415 32732415 PRJNA508758_P_NODE_42640_length_321_cov_0.931452_g41592_i0 PRJNA508758 42640 321 0.931452 2.98996092 Zebrafish jaw picornavirus RQ13 Viruses Viruses 58.5 2.73e-7   NR YP_009552756.1 RQ13 g41592 i0 38.9 1.00934579439252 108 61 97.2 3 313 2 1707 1813 YP_009552756.1 polyprotein [Rhimavirus A] diamond 324 58.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus

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