RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA597223 · 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
568958 568958 PRJNA597223_P_NODE_28261_length_287_cov_2.730159_g26415_i0 PRJNA597223 28261 287 2.730159 7.83555633 Sopafab virus 3131770 Viruses Viruses 440 4.849999999999998e-119   NTclustered gi|2717323354|gb|PP174071.1| 3131770 g26415 i0 96.958 87.0348432055749 263 6 91 2 24 285 4 265 MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence blastn 24979 440 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Sopafab virus
569574 569574 PRJNA597223_P_NODE_84381_length_153_cov_1.796610_g82535_i0 PRJNA597223 84381 153 1.79661 2.7488133 Erysiphe necator associated ourmia-like virus 87 2741867 Viruses Viruses 202 1.1799999999999998e-47   NTclustered gi|1848976707|gb|MN611615.1| 2741867 g82535 i0 90.728 1.97385620915033 151 14 99 0 1 151 1638 1788 Erysiphe necator associated ourmia-like virus 87 isolate PMS5_114, complete genome blastn 302 202 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 87
2416053 2416053 PRJNA597223_P_NODE_40422_length_225_cov_1.189474_g38576_i0 PRJNA597223 40422 225 1.189474 2.6763165 Ourmiavirus 186783 Viruses Viruses 254 5.11e-63   NTclustered gi|1848976557|gb|MN611540.1| 2741780 g38576 i0 87.225 8.07555555555555 227 24 99 5 1 223 84 309 Erysiphe necator associated ourmia-like virus 12 isolate PMS1_143, complete genome blastn 1817 254 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 12
5672742 5672742 PRJNA597223_P_NODE_28625_length_284_cov_11.064257_g26779_i0 PRJNA597223 28625 284 11.064257 31.42248988 Narnaviridae sp. 2583949 Viruses Viruses 76.8 1.56e-9   NTclustered gi|2183471790|gb|MZ680316.1| 2583949 g26779 i0 87.879 3.67253521126761 66 7 23 1 1 65 3334 3269 MAG: Narnaviridae sp. isolate 84b-k141_9447 putative RNA-dependent RNA polymerase gene, complete cds blastn 1043 76.8 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Narnaviridae sp.
19695939 19695939 PRJNA597223_P_NODE_79096_length_159_cov_1.137097_g77250_i0 PRJNA597223 79096 159 1.137097 1.80798423 Lagenaria siceraria associated mitovirus 2867096 Viruses Viruses 281 1.54e-71   NTclustered gi|2079774884|gb|MZ032029.1| 2867096 g77250 i0 98.734 0.993710691823899 158 2 99 0 1 158 488 331 Lagenaria siceraria associated mitovirus strain 1, complete genome blastn 158 281 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Lagenaria siceraria associated mitovirus

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