RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 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
25928166 25928166 PRJEB20058_P_NODE_4308_length_2186_cov_84.472471_g3531_i0 PRJEB20058 4308 2186 84.472471 1846.56821606 Erysiphe necator associated narnavirus 44 2736401 Viruses Viruses 668 5.16e-230   NR QJT93776.1 2736401 g3531 i0 52.4 1.91720036596523 701 317 95 6 2124 49 1 693 QJT93776.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 44] diamond 4191 668 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Erysiphe necator associated narnavirus 44
32945427 32945427 PRJEB20058_P_NODE_235602_length_224_cov_24.877301_g232777_i0 PRJEB20058 235602 224 24.877301 55.72515424 Leviviridae sp. 2027243 Viruses Viruses 77.8 1.29e-14   NR URG15527.1 2027243 g232777 i0 61.2 0.897321428571429 67 26 89.7 0 24 224 291 357 URG15527.1 MAG: RNA dependent RNA polymerase [Leviviridae sp.] diamond 201 77.8 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
33013839 33013839 PRJEB20058_P_NODE_46812_length_615_cov_3.765343_g44113_i0 PRJEB20058 46812 615 3.765343 23.15685945 ssRNA phage SRR797631 2844826 Viruses Viruses 126 1.18e-29   NR YP_010770674.1 2786676 g44113 i0 49.2 0.624390243902439 128 65 62.4 0 230 613 129 256 YP_010770674.1 RNA-directed RNA polymerase [ssRNA phage SRR7976310_14] diamond 384 126 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Timlovirales Steitzviridae Henifovirus Henifovirus sp. 'caenadaptatum'
33115322 33115322 PRJEB20058_P_NODE_116503_length_371_cov_5.167742_g113688_i0 PRJEB20058 116503 371 5.167742 19.17232282 Hangzhou mitovirus 6 2905241 Viruses Viruses 112 8.51e-26   NR UHK03232.1 2905241 g113688 i0 50.4 2.88679245283019 123 56 99.5 2 1 369 380 497 UHK03232.1 MAG: RNA-dependent RNA polymerase [Hangzhou mitovirus 6] diamond 1071 112 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Hangzhou mitovirus 6

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