RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1237347", tax_kingdom = "Sangervirae" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

tax_kingdom 1

  • Sangervirae · 5 ✖

bioproject 1

  • PRJNA1237347 · 5 ✖

analysis 1

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
19463547 19463547 PRJNA1237347_P_NODE_154516_length_514_cov_1.219955_g147960_i0 PRJNA1237347 154516 514 1.219955 6.2705687 Microvirus sp. 2202559 Viruses Viruses 110 8.91e-28   NR QJB20200.1 2202559 g147960 i0 59.1 3.44941634241245 93 38 54.3 0 5 283 11 103 QJB20200.1 MAG: hypothetical protein [Microvirus sp.] diamond 1773 110 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
24570934 24570934 PRJNA1237347_P_NODE_521100_length_245_cov_0.895349_g514527_i0 PRJNA1237347 521100 245 0.895349 2.19360505 Ariapismic virus 4 3376543 Viruses Viruses 96.3 1.82e-21   NR XJW04240.1 3376543 g514527 i0 61.3 0.979591836734694 80 31 98 0 241 2 33 112 XJW04240.1 MAG: replication initiator protein [Ariapismic virus 4] diamond 240 96.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 4
29757055 29757055 PRJNA1237347_P_NODE_315451_length_324_cov_0.900398_g308878_i0 PRJNA1237347 315451 324 0.900398 2.91728952 Ariapismic virus 1 3376325 Viruses Viruses 51.2 9.91e-5   NR XJW04215.1 3376325 g308878 i0 42.9 0.583333333333333 63 36 58.3 0 190 2 332 394 XJW04215.1 MAG: major capsid protein [Ariapismic virus 1] diamond 189 51.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 1
31242117 31242117 PRJNA1237347_P_NODE_414995_length_273_cov_1.835000_g408422_i0 PRJNA1237347 414995 273 1.835 5.00955 Microvirus sp. 2202559 Viruses Viruses 100 2.2899999999999998e-23   NR UXQ88023.1 2202559 g408422 i0 52.8 0.978021978021978 89 41 97.8 1 273 7 159 246 UXQ88023.1 MAG: replication initiation protein [Microvirus sp.] diamond 267 100 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32476009 32476009 PRJNA1237347_P_NODE_258599_length_367_cov_0.976190_g252026_i0 PRJNA1237347 258599 367 0.97619 3.5826173 Microvirus sp. 2202559 Viruses Viruses 59.7 7.43e-9   NR UXQ88024.1 2202559 g252026 i0 61.9 0.343324250681199 42 16 34.3 0 238 363 4 45 UXQ88024.1 MAG: hypothetical protein [Microvirus sp.] diamond 126 59.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus 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);;