RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA691918" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA691918 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
30935756 30935756 PRJNA691918_S_NODE_154_length_207_cov_6.835227_g153_i0 PRJNA691918 154 207 6.835227 14.14891989 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 107 5.35e-25   NR XCM67828.1 3003959 g153 i0 73.1 1.94202898550725 67 18 97.1 0 3 203 1210 1276 XCM67828.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 402 107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31030684 31030684 PRJNA691918_S_NODE_255_length_186_cov_28.574194_g254_i0 PRJNA691918 255 186 28.574194 53.14800084 Skomarfal virus 17 3063065 Viruses Viruses 50.4 3.29e-5   NR WPR18321.1 3063065 g254 i0 47.3 0.887096774193548 55 28 88.7 1 9 173 32 85 WPR18321.1 MAG: capsid protein [Skomarfal virus 17] diamond 165 50.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Skomarfal virus 17
31725994 31725994 PRJNA691918_S_NODE_217_length_193_cov_6.413580_g216_i0 PRJNA691918 217 193 6.41358 12.3782094 Picornaviridae sp. 1530251 Viruses Viruses 88.2 1.81e-18   NR URG14535.1 1530251 g216 i0 63.5 1.94300518134715 63 23 97.9 0 191 3 388 450 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 375 88.2 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);;