RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1134759" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1134759 · 5 ✖

analysis 1

  • diamond · 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
18135930 18135930 PRJNA1134759_P_NODE_455_length_1728_cov_4.331722_g423_i0 PRJNA1134759 455 1728 4.331722 74.85215616 Viruses 10239 Viruses Viruses 161 5.76e-38   NR QXV86620.1 1955144 g423 i0 28.8 3.50347222222222 503 236 84.9 14 7 1473 441 835 QXV86620.1 capsid protein [Dicistroviridae sp.] diamond 6054 161 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28302045 28302045 PRJNA1134759_P_NODE_33886_length_292_cov_0.904110_g33710_i0 PRJNA1134759 33886 292 0.90411 2.6400012 Dicistroviridae sp. 1955144 Viruses Viruses 75.1 2.85e-13   NR XCO49088.1 1955144 g33710 i0 33.3 0.986301369863014 96 64 98.6 0 290 3 403 498 XCO49088.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 288 75.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28796144 28796144 PRJNA1134759_P_NODE_13747_length_427_cov_1.974576_g13571_i0 PRJNA1134759 13747 427 1.974576 8.43143952 Cripavirus 144051 Viruses Viruses 164 4.999999999999998e-44   NR ULF99858.1 1955141 g13571 i0 51.8 16.8407494145199 141 68 99.1 0 426 4 13 153 ULF99858.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 7191 165 0.993939393939394 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
30955256 30955256 PRJNA1134759_P_NODE_23074_length_341_cov_1.746269_g22898_i0 PRJNA1134759 23074 341 1.746269 5.95477729 Dicistroviridae sp. 1955144 Viruses Viruses 103 3.9399999999999996e-23   NR QXV86620.1 1955144 g22898 i0 53.2 1.91788856304985 109 50 95 1 16 339 226 334 QXV86620.1 capsid protein [Dicistroviridae sp.] diamond 654 103 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
31871937 31871937 PRJNA1134759_P_NODE_27977_length_315_cov_2.314050_g27801_i0 PRJNA1134759 27977 315 2.31405 7.2892575 Cripavirus sp. 1955141 Viruses Viruses 94 9.02e-20   NR ULF99842.1 1955141 g27801 i0 46.7 1 105 52 96.2 2 313 11 326 430 ULF99842.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 315 94 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus 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);;