RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB8827", tax_phylum = "Phixviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Phixviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB8827 · 6 ✖

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
12898544 12898544 PRJEB8827_P_NODE_911_length_229_cov_15144.405000_g889_i0 PRJEB8827 911 229 15144.405 34680.68745 Microviridae sp. 2202644 Viruses Viruses 63.9 9.44e-6   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g889 i0 100 14.7729257641921 34 0 15 0 128 161 2801 2834 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3383 63.9 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
16721720 16721720 PRJEB8827_P_NODE_114_length_414_cov_7845.407792_g94_i0 PRJEB8827 114 414 7845.407792 32479.98825888 Microviridae sp. 2202644 Viruses Viruses 62.1 6.61e-5   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g94 i0 100 8.1304347826087 33 0 8 0 314 346 2802 2834 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3366 62.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25617670 25617670 PRJEB8827f_S_NODE_1673_length_309_cov_17.251825_g1653_i0 PRJEB8827 1673 309 17.251825 53.30813925 Viruses 10239 Viruses Viruses 58.4 6.2e-4   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g1653 i0 100 10.915857605178 31 0 10 0 271 301 2804 2834 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3373 58.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
25889539 25889539 PRJEB8827c_S_NODE_595_length_199_cov_8.524390_g582_i0 PRJEB8827 595 199 8.52439 16.9635361 Viruses 10239 Viruses Viruses 60.2 1.03e-4   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g582 i0 100 17.5025125628141 32 0 16 0 1 32 2835 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3483 60.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26433836 26433836 PRJEB8827b_S_NODE_1231_length_274_cov_16.322176_g1179_i0 PRJEB8827 1231 274 16.322176 44.72276224 Viruses 10239 Viruses Viruses 60.2 1.5e-4   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g1179 i0 100 12.7080291970803 32 0 12 0 2 33 2835 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 3482 60.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
26434068 26434068 PRJEB8827f_S_NODE_7551_length_190_cov_82.154839_g7531_i0 PRJEB8827 7551 190 82.154839 156.0941941 Viruses 10239 Viruses Viruses 54.7 0.005   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g7531 i0 100 2.67894736842105 29 0 15 0 12 40 2832 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 509 54.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae 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);;