RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA763243 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27621982 27621982 PRJNA763243_P_NODE_57284_length_246_cov_1.156069_g56938_i0 PRJNA763243 57284 246 1.156069 2.84392974 Hobart betaflexivirus 1 2201305 Viruses Viruses 150 1.17e-41   NR AWK77907.1 2201305 g56938 i0 86.4 0.98780487804878 81 11 98.8 0 244 2 123 203 AWK77907.1 movement protein [Hobart betaflexivirus 1] diamond 243 150 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae   Hobart betaflexivirus 1
28852988 28852988 PRJNA763243_P_NODE_19508_length_357_cov_1.869718_g19162_i0 PRJNA763243 19508 357 1.869718 6.67489326 Sand whiting narna-like virus 2903073 Viruses Viruses 46.6 0.00601   NR UHS16731.1 2903073 g19162 i0 54.2 0.403361344537815 48 20 40.3 2 149 6 139 184 UHS16731.1 MAG: RNA-dependent RNA polymerase, partial [Sand whiting narna-like virus] diamond 144 46.6 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Sand whiting narna-like virus
29273155 29273155 PRJNA763243_P_NODE_70209_length_219_cov_10.232877_g69863_i0 PRJNA763243 70209 219 10.232877 22.41000063 Narnavirus 186767 Viruses Viruses 65.9 1.98e-10   NR QJT93778.1 2736403 g69863 i0 65.9 1.20547945205479 44 15 60.3 0 1 132 717 760 QJT93778.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 46] diamond 264 65.9 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Erysiphe necator associated narnavirus 46
29452840 29452840 PRJNA763243_P_NODE_70430_length_218_cov_7.724138_g70084_i0 PRJNA763243 70430 218 7.724138 16.83862084 Yunnan mito-like virus 39 2937245 Viruses Viruses 63.2 1.69e-9   NR UPW42195.1 2937245 g70084 i0 55.4 0.770642201834862 56 25 77.1 0 214 47 104 159 UPW42195.1 MAG: putative RNA dependent RNA polymerase [Yunnan mito-like virus 39] diamond 168 63.2 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Yunnan mito-like virus 39
30401178 30401178 PRJNA763243_P_NODE_28533_length_310_cov_7.029536_g28187_i0 PRJNA763243 28533 310 7.029536 21.7915616 ssRNA phage SRR696 2845112 Viruses Viruses 51.2 8.34e-5   NR YP_010769018.1 2786620 g28187 i0 51.2 1.19032258064516 41 20 39.7 0 26 148 331 371 YP_010769018.1 maturation protein [ssRNA phage SRR6960803_4] diamond 369 51.2 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Duinviridae Kohmavirus Kohmavirus luticola
32298167 32298167 PRJNA763243_P_NODE_65759_length_235_cov_12.123457_g65413_i0 PRJNA763243 65759 235 12.123457 28.49012395 Botourmiaviridae sp. 2808997 Viruses Viruses 70.9 4.17e-12   NR WAK77794.1 2808997 g65413 i0 64.4 0.574468085106383 45 16 57.4 0 231 97 591 635 WAK77794.1 MAG: hypothetical protein [Botourmiaviridae sp.] diamond 135 70.9 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae 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);;