RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1160211 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27217508 27217508 PRJNA1160211_S_NODE_40082_length_609_cov_7.777985_g38943_i0 PRJNA1160211 40082 609 7.777985 47.36792865 Fiersviridae 2842319 Viruses Viruses 68.9 8.66e-10   NR YP_010769172.1 2786366 g38943 i0 47 1.04926108374384 83 40 40.4 2 336 581 105 184 YP_010769172.1 maturation protein, partial [ssRNA phage Gerhypos.4_61] diamond 639 69.3 0.994227994227994 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Cahrpivirus Cahrpivirus humenecus
28966965 28966965 PRJNA1160211_S_NODE_270688_length_247_cov_1.942529_g269455_i0 PRJNA1160211 270688 247 1.942529 4.79804663 Magnaporthe oryzae botourmiavirus 7 2755484 Viruses Viruses 67.4 8.11e-11   NR QVU39995.1 2755484 g269455 i0 48.2 2.01619433198381 83 41 98.4 1 5 247 392 474 QVU39995.1 RNA-dependent RNA polymerase [Magnaporthe oryzae botourmiavirus 7] diamond 498 67.4 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Epsilonscleroulivirus Epsilonscleroulivirus alphaoryzae
29345725 29345725 PRJNA1160211_S_NODE_10509_length_808_cov_17.221769_g9710_i0 PRJNA1160211 10509 808 17.221769 139.15189352 Sclerotinia sclerotiorum mitovirus 39 2822890 Viruses Viruses 102 2.32e-20   NR QUE49178.1 2822890 g9710 i0 43.2 0.516089108910891 139 75 51.2 3 347 760 15 150 QUE49178.1 MAG: RNA-dependent RNA polymerase, partial [Sclerotinia sclerotiorum mitovirus 39] diamond 417 102 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Sclerotinia sclerotiorum mitovirus 39

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