RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA688736", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 8 ✖

tax_phylum 1

  • Pisuviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA688736 · 8 ✖

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
22345566 22345566 PRJNA688736_P_NODE_50878_length_242_cov_0.923077_g50593_i0 PRJNA688736 50878 242 0.923077 2.23384634 Iflavirus betaspexiguae 3048332 Viruses Viruses 387 5.26e-103   NTclustered gi|612400726|gb|KJ186788.1| 1228012 g50593 i0 95.455 5.99173553719008 242 11 100 0 1 242 8122 7881 Spodoptera exigua iflavirus 2 from Spain, complete genome blastn 1450 387 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Iflavirus betaspexiguae
27788870 27788870 PRJNA688736_P_NODE_36264_length_266_cov_1.212435_g35979_i0 PRJNA688736 36264 266 1.212435 3.2250771 Zebrafish jaw picornavirus RQ13 Viruses Viruses 112 1.18e-26   NR YP_010796394.1 RQ13 g35979 i0 56.8 1.98496240601504 88 38 99.2 0 264 1 2235 2322 YP_010796394.1 polyprotein [Wenling triplecross lizardfish picornavirus] diamond 528 112 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Symapivirus Zebrafish jaw picornavirus
29924409 29924409 PRJNA688736_P_NODE_6591_length_570_cov_1.380282_g6310_i0 PRJNA688736 6591 570 1.380282 7.8676074 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 102 2.36e-21   NR XCM68300.1 3003959 g6310 i0 30.2 1.94210526315789 182 121 95.8 1 547 2 109 284 XCM68300.1 MAG: structural polyprotein, partial [Picornavirales sp.] diamond 1107 102 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29955898 29955898 PRJNA688736_P_NODE_19651_length_351_cov_1.402878_g19366_i0 PRJNA688736 19651 351 1.402878 4.92410178 Zebrafish jaw picornavirus RQ13 Viruses Viruses 141 3.84e-36   NR QKE55033.1 RQ13 g19366 i0 59.5 3.96581196581197 116 47 99.1 0 2 349 2126 2241 QKE55033.1 MAG: polyprotein [Picornaviridae sp.] diamond 1392 141 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish jaw picornavirus
30587648 30587648 PRJNA688736_P_NODE_27213_length_305_cov_2.659483_g26928_i0 PRJNA688736 27213 305 2.659483 8.11142315 Zebrafish jaw picornavirus RQ13 Viruses Viruses 75.5 2.55e-13   NR QJX58422.1 RQ13 g26928 i0 45.6 4.42622950819672 90 47 86.6 2 296 33 2270 2359 QJX58422.1 polyprotein [Salivirus A] diamond 1350 75.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Salivirus Zebrafish jaw picornavirus
31030390 31030390 PRJNA688736_P_NODE_1175_length_1180_cov_1.788618_g1040_i0 PRJNA688736 1175 1180 1.788618 21.1056924 Mute swan feces associated picorna-like virus 16 2832189 Viruses Viruses 116 4.07e-24   NR QUS52716.1 2832189 g1040 i0 28.4 2.09491525423729 409 245 99.4 12 1179 7 559 937 QUS52716.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 16] diamond 2472 116 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 16
32212005 32212005 PRJNA688736_P_NODE_15158_length_393_cov_2.206250_g14873_i0 PRJNA688736 15158 393 2.20625 8.6705625 Picornavirales 464095 Viruses Viruses 91.7 1.61e-18   NR QXV86619.1 1955144 g14873 i0 38.1 9.3969465648855 139 76 99.2 2 3 392 1459 1596 QXV86619.1 nonstructural polyprotein [Dicistroviridae sp.] diamond 3693 91.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
32654151 32654151 PRJNA688736_P_NODE_8120_length_519_cov_2.307175_g7837_i0 PRJNA688736 8120 519 2.307175 11.97423825 Picornavirales 464095 Viruses Viruses 115 4.14e-26   NR URG14494.1 1530251 g7837 i0 44.1 2.47398843930636 145 77 83.8 2 30 464 357 497 URG14494.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 1284 115 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);;