RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA591127" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA591127 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28595767 28595767 PRJNA591127_P_NODE_22887_length_182_cov_1.344828_g22718_i0 PRJNA591127 22887 182 1.344828 2.44758696 Leviviridae sp. 2027243 Viruses Viruses 75.9 3.43e-14   NR URG16528.1 2027243 g22718 i0 56.7 1.97802197802198 60 26 98.9 0 180 1 509 568 URG16528.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] diamond 360 75.9 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
30585053 30585053 PRJNA591127_P_NODE_21433_length_192_cov_2.754839_g21264_i0 PRJNA591127 21433 192 2.754839 5.28929088 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 49.3 9.26e-5   NR UVF58767.1 2951531 g21264 i0 34.9 0.984375 63 41 98.4 0 3 191 90 152 UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] diamond 189 49.3 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
31944470 31944470 PRJNA591127_P_NODE_26257_length_162_cov_1.248000_g26088_i0 PRJNA591127 26257 162 1.248 2.02176 ssRNA phage Gerhypos.2_3 2786263 Viruses Viruses 70.5 1.98e-12   NR YP_010770593.1 2786264 g26088 i0 75 0.740740740740741 40 10 74.1 0 3 122 368 407 YP_010770593.1 maturation protein, partial [ssRNA phage Gerhypos.2_30] diamond 120 70.5 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Timlovirales Steitzviridae Hodnevirus Hodnevirus neosolivicinum
32166328 32166328 PRJNA591127_P_NODE_25998_length_163_cov_1.857143_g25829_i0 PRJNA591127 25998 163 1.857143 3.02714309 Plasmopara viticola lesion associated ourmia-like virus 82 2686556 Viruses Viruses 108 1.06e-25   NR YP_010800276.1 2686556 g25829 i0 90.6 0.975460122699387 53 5 97.5 0 3 161 231 283 YP_010800276.1 RNA dependent RNA polymerase, partial [Plasmopara viticola lesion associated ourmia-like virus 82] diamond 159 108 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Penoulivirus Penoulivirus alphaplasmoparae

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