RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA561212", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Duplornaviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 4 ✖

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
27566832 27566832 PRJNA561212_P_NODE_1844_length_800_cov_1.343879_g1656_i0 PRJNA561212 1844 800 1.343879 10.751032 Viruses 10239 Viruses Viruses 59.7 5.01e-6   NR UUG74260.1 2952015 g1656 i0 26.3 4.29 232 161 85.9 4 787 101 575 799 UUG74260.1 MAG: hypothetical protein, partial [XiangYun toti-like virus 7] diamond 3432 59.7 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   XiangYun toti-like virus 7
28247506 28247506 PRJNA561212_P_NODE_25886_length_242_cov_0.923077_g25675_i0 PRJNA561212 25886 242 0.923077 2.23384634 Sopuslov virus 3131840 Viruses Viruses 50.1 7.54e-5   NR WZH62005.1 3131840 g25675 i0 37.7 0.954545454545455 77 40 93 3 230 6 92 162 WZH62005.1 MAG: RNA-dependent RNA polymerase, partial [Sopuslov virus] diamond 231 50.1 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales     Sopuslov virus
29731386 29731386 PRJNA561212_P_NODE_430_length_1489_cov_1.766949_g342_i0 PRJNA561212 430 1489 1.766949 26.30987061 Prasiola crispa toti-like virus 2933125 Viruses Viruses 83.6 9.71e-13   NR CAI5383882.1 2933125 g342 i0 23.7 0.979180658159839 486 313 90.1 17 1481 141 193 659 CAI5383882.1 putative capsid protein [Prasiola crispa toti-like virus] diamond 1458 83.6 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Prasiola crispa toti-like virus
31659170 31659170 PRJNA561212_P_NODE_4777_length_507_cov_2.195853_g4568_i0 PRJNA561212 4777 507 2.195853 11.13297471 Prasiola crispa toti-like virus 2933125 Viruses Viruses 67.4 1.57e-9   NR CAI5383883.1 2933125 g4568 i0 31.9 0.834319526627219 141 93 82.2 2 16 432 47 186 CAI5383883.1 RNA-dependent RNA polymerase [Prasiola crispa toti-like virus] diamond 423 67.4 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Prasiola crispa toti-like virus

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