RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax_phylum = "Negarnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Negarnaviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
30710972 30710972 PRJNA561212_P_NODE_16334_length_280_cov_1.091787_g16123_i0 PRJNA561212 16334 280 1.091787 3.0570036 Hangzhou nephotettix cincticeps phenuivirus 1 2905447 Viruses Viruses 71.2 5.74e-12   NR UHK03292.1 2905447 g16123 i0 45.3 0.685714285714286 64 35 68.6 0 208 17 1554 1617 UHK03292.1 MAG: RNA-dependent RNA polymerase [Hangzhou nephotettix cincticeps phenuivirus 1] diamond 192 71.2 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Hareavirales Phenuiviridae   Hangzhou nephotettix cincticeps phenuivirus 1
31975656 31975656 PRJNA561212_P_NODE_1898_length_787_cov_30.278711_g1707_i0 PRJNA561212 1898 787 30.278711 238.29345557 Frijoles virus VP-161A 426788 Viruses Viruses 71.6 1.52e-11   NR YP_009665189.1 426788 g1707 i0 38.7 1.13214739517154 111 66 42.3 1 158 490 27 135 YP_009665189.1 N protein, partial [Frijoles virus VP-161A] diamond 891 71.6 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Hareavirales Phenuiviridae Phlebovirus Phlebovirus limboense
32292475 32292475 PRJNA561212_P_NODE_2199_length_735_cov_1.321752_g2002_i0 PRJNA561212 2199 735 1.321752 9.7148772 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 89 4.23e-16   NR XCO56027.1 3233859 g2002 i0 30.4 1.66530612244898 204 130 83.3 2 114 725 575 766 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 1224 89 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1
32418748 32418748 PRJNA561212_P_NODE_5659_length_465_cov_0.920918_g5448_i0 PRJNA561212 5659 465 0.920918 4.2822687 brine shrimp arlivirus 9 2900384 Viruses Viruses 284 1.13e-92   NR UNI74140.1 2900384 g5448 i0 92.8 1.96129032258065 152 11 98.1 0 10 465 198 349 UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 912 284 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9

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