RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA704949" 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

  • PRJNA704949 · 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
27620306 27620306 PRJNA704949_P_NODE_1808504_length_177_cov_1.218750_g1793165_i0 PRJNA704949 1808504 177 1.21875 2.1571875 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 58.2 5.8e-8   NR UNY41988.1 3003959 g1793165 i0 59.3 0.915254237288136 54 16 89.8 2 162 4 157 205 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 162 58.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28125358 28125358 PRJNA704949_P_NODE_1679025_length_186_cov_2.379562_g1663686_i0 PRJNA704949 1679025 186 2.379562 4.42598532 brine shrimp partiti-like virus 3 2900390 Viruses Viruses 42.7 0.0179   NR UNI73913.1 2900390 g1663686 i0 43.8 0.774193548387097 48 25 77.4 1 165 22 257 302 UNI73913.1 MAG: hypothetical protein [brine shrimp partiti-like virus 3] diamond 144 42.7 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   brine shrimp partiti-like virus 3
32612670 32612670 PRJNA704949_P_NODE_983480_length_263_cov_1.457944_g968145_i0 PRJNA704949 983480 263 1.457944 3.83439272 Cryphonectria hypovirus 2 40282 Viruses Viruses 50.1 1.3e-4   NR NP_613266.1 40282 g968145 i0 45.5 0.501901140684411 44 24 50.2 0 260 129 2683 2726 NP_613266.1 polyprotein [Cryphonectria hypovirus 2] diamond 132 50.1 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Alphahypovirus Alphahypovirus americanum

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