RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where tax_clade = "Norovirus GII" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

bioproject 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 3 ✖

tax_clade 1

  • Norovirus GII · 3 ✖

analysis 1

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
20041659 20041659 PRJNA939415_P_NODE_176_length_7555_cov_315.918070_g123_i0 PRJNA939415 176 7555 315.91807 23867.6101885 Norovirus norwalkense 3431196 Viruses Viruses 13570 0   NTclustered gi|2027319263|gb|MW661278.1| 122929 g123 i0 99.087 99.6820648577101 7555 69 100 0 1 7555 7569 15 Norovirus GII isolate BMH19-127, complete genome blastn 753098 13570 1 Viruses Norovirus GII Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae Norovirus Norovirus norwalkense
20594635 20594635 PRJNA1085664_S_NODE_30237_length_161_cov_4.254237_g29818_i0 PRJNA1085664 30237 161 4.254237 6.84932157 Norovirus norwalkense 3431196 Viruses Viruses 279 5.64e-71   NTclustered gi|1189484999|gb|KY905331.1| 122929 g29818 i0 99.351 95.6024844720497 154 1 96 0 8 161 209 56 Norovirus GII strain Hu/GII.P4 New Orleans 2009_GII.4 Sydney 2012/NSW789Z/2016/AU, partial genome blastn 15392 279 1 Viruses Norovirus GII Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae Norovirus Norovirus norwalkense
23145805 23145805 PRJNA1085664_S_NODE_99_length_7351_cov_66.451013_g98_i0 PRJNA1085664 99 7351 66.451013 4884.81396563 Norovirus norwalkense 3431196 Viruses Viruses 13071 0   NTclustered gi|1189484999|gb|KY905331.1| 122929 g98 i0 98.841 99.6180111549449 7336 79 99 1 16 7351 7546 217 Norovirus GII strain Hu/GII.P4 New Orleans 2009_GII.4 Sydney 2012/NSW789Z/2016/AU, partial genome blastn 732292 13071 1 Viruses Norovirus GII Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae Norovirus Norovirus norwalkense

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