RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1123686" and tax_kingdom = "Sangervirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Sangervirae · 5 ✖

bioproject 1

  • PRJNA1123686 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
6658727 6658727 PRJNA1123686_S_NODE_186_length_484_cov_727.740659_g160_i0 PRJNA1123686 186 484 727.740659 3522.26478956 Sinsheimervirus phiX174 10847 Viruses Viruses 143 2.72e-29   NTclustered gi|304442566|gb|HM753711.1| 2886930 g160 i0 80.105 42.4793388429752 191 38 39 0 294 484 1985 1795 Enterobacteria phage phiX174 isolate XC+MbD22ic6, complete genome blastn 20560 143 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Sinsheimervirus Sinsheimervirus phiX174
16858113 16858113 PRJNA1123686_S_NODE_334_length_416_cov_8991.434109_g304_i0 PRJNA1123686 334 416 8991.434109 37404.36589344 Sinsheimervirus phiX174 10847 Viruses Viruses 392 2.08e-104   NTclustered gi|5815306|gb|AF176028.1| 2886930 g304 i0 83.654 100 416 68 100 0 1 416 1383 1798 Coliphage phiX174 isolate SC1, complete genome blastn 41600 392 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Sinsheimervirus Sinsheimervirus phiX174
19406791 19406791 PRJNA1123686_S_NODE_576_length_372_cov_2521.830904_g545_i0 PRJNA1123686 576 372 2521.830904 9381.21096288 Sinsheimervirus phiX174 10847 Viruses Viruses 388 2.3699999999999997e-103   NTclustered gi|304269243|gb|HM775307.1| 2886930 g545 i0 85.484 100 372 54 100 0 1 372 1838 2209 Enterobacteria phage phiX174 strain alpha, complete genome blastn 37200 388 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Sinsheimervirus Sinsheimervirus phiX174
21957701 21957701 PRJNA1123686_S_NODE_438_length_393_cov_8233.879121_g407_i0 PRJNA1123686 438 393 8233.879121 32359.14494553 Sinsheimervirus phiX174 10847 Viruses Viruses 220 9.74e-53   NTclustered gi|14210820|gb|AF299301.1| 2886930 g407 i0 76.786 99.0687022900763 392 91 99 0 2 393 2277 1886 Coliphage phiX174 isolate CM, complete genome blastn 38934 220 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Sinsheimervirus Sinsheimervirus phiX174
23233227 23233227 PRJNA1123686_S_NODE_899_length_342_cov_13619.482428_g867_i0 PRJNA1123686 899 342 13619.482428 46578.62990376 Sinsheimervirus phiX174 10847 Viruses Viruses 289 2.26e-73   NTclustered gi|226973390|gb|FJ849058.1| 2886930 g867 i0 81.871 99.9883040935673 342 62 100 0 1 342 3280 3621 Enterobacteria phage phiX174 isolate JACS, complete genome blastn 34196 289 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Sinsheimervirus Sinsheimervirus phiX174

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