RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB6055" 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

  • PRJEB6055 · 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
2267495 2267495 PRJEB6055_S_NODE_242_length_408_cov_9908.254692_g218_i0 PRJEB6055 242 408 9908.254692 40425.67914336 Viruses 10239 Viruses Viruses 76.8 2.32e-9   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g218 i0 95.833 10.8651960784314 48 1 12 1 362 408 2797 2844 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 4433 76.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
3542801 3542801 PRJEB6055_S_NODE_2883_length_193_cov_21356.886076_g2859_i0 PRJEB6055 2883 193 21356.886076 41218.79012668 Viruses 10239 Viruses Viruses 76.8 9.87e-10   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g2859 i0 100 22.8549222797927 41 0 21 0 1 41 2844 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 4411 76.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
11603966 11603966 PRJEB6055_S_NODE_2150_length_213_cov_18926.567416_g2126_i0 PRJEB6055 2150 213 18926.567416 40313.58859608 Microviridae sp. 2202644 Viruses Viruses 76.8 1.11e-9   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g2126 i0 100 20.6948356807512 41 0 19 0 173 213 2804 2844 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 4408 76.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
16294932 16294932 PRJEB6055_S_NODE_1173_length_259_cov_15075.825893_g1149_i0 PRJEB6055 1173 259 15075.825893 39046.38906287 Viruses 10239 Viruses Viruses 76.8 1.4e-9   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g1149 i0 100 16.957528957529 41 0 16 0 1 41 2844 2804 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 4392 76.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
20526488 20526488 PRJEB6055_S_NODE_297_length_390_cov_9525.273239_g273_i0 PRJEB6055 297 390 9525.273239 37148.5656321 Microviridae sp. 2202644 Viruses Viruses 80.5 1.71e-10   NTclustered gi|2056975379|tpg|BK023205.1| 2202644 g273 i0 100 11.3 43 0 11 0 348 390 2802 2844 MAG TPA_asm: Microviridae sp. isolate ctz4L3, partial genome blastn 4407 80.5 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);;