RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA669701" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 11 ✖

bioproject 1

  • PRJNA669701 · 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
1911944 1911944 PRJNA669701_P_NODE_422_length_3738_cov_1175.568076_g68_i10 PRJNA669701 422 3738 1175.568076 43942.73468088 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1072 0   NR AVM87439.1 3063761 g68 i10 49.3 0.912520064205458 1137 469 85.9 10 3214 5 1 1096 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 3411 1072 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
8289001 8289001 PRJNA669701_P_NODE_367_length_3997_cov_1174.693425_g68_i7 PRJNA669701 367 3997 1174.693425 46952.49619725 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1122 0   NR AVM87439.1 3063761 g68 i7 49.3 0.896922692019014 1195 495 84.7 11 525 3908 1 1151 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 3585 1122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
12114841 12114841 PRJNA669701_P_NODE_170_length_5544_cov_1296.123561_g68_i3 PRJNA669701 170 5544 1296.123561 71857.09022184 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1706 0   NR AVM87439.1 3063761 g68 i3 51.8 0.917748917748918 1696 695 88 14 5020 140 1 1642 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 5088 1706 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
13389822 13389822 PRJNA669701_P_NODE_411_length_3782_cov_1164.054732_g68_i9 PRJNA669701 411 3782 1164.054732 44024.54996424 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1033 0   NR AVM87439.1 3063761 g68 i9 49.7 0.860655737704918 1085 445 81.3 9 525 3599 1 1044 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 3255 1033 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
14664515 14664515 PRJNA669701_P_NODE_192_length_5250_cov_1291.678965_g68_i5 PRJNA669701 192 5250 1291.678965 67813.1456625 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1643 0   NR AVM87439.1 3063761 g68 i5 51.6 0.939428571428571 1644 672 90 14 525 5249 1 1590 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 4932 1643 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
18487925 18487925 PRJNA669701_P_NODE_175_length_5484_cov_1261.243763_g68_i4 PRJNA669701 175 5484 1261.243763 69166.60796292 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1610 0   NR AVM87439.1 3063761 g68 i4 49.4 0.942013129102845 1722 671 90.4 16 525 5483 1 1590 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 5166 1610 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
19762490 19762490 PRJNA669701_P_NODE_216_length_5070_cov_1228.319792_g68_i6 PRJNA669701 216 5070 1228.319792 62275.8134544 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1549 0   NR AVM87439.1 3063761 g68 i6 51.1 0.937278106508876 1584 652 89.6 15 4546 2 1 1530 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 4752 1549 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
28186857 28186857 PRJNA669701_P_NODE_83126_length_278_cov_1.502439_g82731_i0 PRJNA669701 83126 278 1.502439 4.17678042 Chrocajirn virus 3129512 Viruses Viruses 165 4.249999999999999e-47   NR WZH58443.1 3129512 g82731 i0 79.3 0.992805755395683 92 19 99.3 0 278 3 130 221 WZH58443.1 MAG: maturation protein [Chrocajirn virus] diamond 276 165 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Chrocajirn virus
29797186 29797186 PRJNA669701_P_NODE_151_length_5761_cov_8.498418_g139_i0 PRJNA669701 151 5761 8.498418 489.59386098 Zebrafish jaw picornavirus RQ13 Viruses Viruses 519 2.78e-147   NR XBH24011.1 RQ13 g139 i0 32.9 0.660822773823989 1269 679 64.3 36 1729 5430 1256 2385 XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] diamond 3807 519 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Zebrafish jaw picornavirus
30366390 30366390 PRJNA669701_P_NODE_1892_length_1837_cov_4.238095_g1740_i0 PRJNA669701 1892 1837 4.238095 77.85380515 Zebrafish jaw picornavirus RQ13 Viruses Viruses 88.6 5.65e-14   NR WXG28549.1 RQ13 g1740 i0 25.4 0.565051714752314 346 203 49.3 12 1076 171 284 618 WXG28549.1 MAG: polyprotein [Pteropodidae bat teschovirus] diamond 1038 88.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Teschovirus Zebrafish jaw picornavirus
32263276 32263276 PRJNA669701_P_NODE_55818_length_324_cov_952.286853_g55423_i0 PRJNA669701 55818 324 952.286853 3085.4094037199998 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 91.7 7.07e-19   NR AVM87439.1 3063761 g55423 i0 42.7 1.01851851851852 110 41 100 3 1 324 1460 1549 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 330 91.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2

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