RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJEB80557 · 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
10342014 10342014 PRJEB80557_S_NODE_11489_length_271_cov_2.261261_g11093_i0 PRJEB80557 11489 271 2.261261 6.12801731 Cytospora ribis mitovirus 2 1551549 Viruses Viruses 114 2.21e-28   NR AIS37556.1 1551549 g11093 i0 62.1 1.92619926199262 87 33 96.3 0 10 270 168 254 AIS37556.1 RNA-dependent RNA polymerase, partial [Cytospora ribis mitovirus 2] diamond 522 114 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Cytospora ribis mitovirus 2
27128634 27128634 PRJEB80557_S_NODE_10142_length_287_cov_1.987395_g9746_i0 PRJEB80557 10142 287 1.987395 5.70382365 Xinjiang mito-like virus 7 2937216 Viruses Viruses 87.4 1.26e-17   NR UPW42224.1 2937216 g9746 i0 50.6 0.909407665505226 87 33 87.8 2 36 287 468 547 UPW42224.1 MAG: putative RNA dependent RNA polymerase [Xinjiang mito-like virus 70] diamond 261 87.4 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Xinjiang mito-like virus 70
28234183 28234183 PRJEB80557_S_NODE_20386_length_210_cov_2.677019_g19990_i0 PRJEB80557 20386 210 2.677019 5.6217399 Soybean thrips tombus-like virus 1 2802943 Viruses Viruses 77.8 8.02e-15   NR QPZ88368.1 2796562 g19990 i0 53.6 2.95714285714286 69 32 98.6 0 2 208 236 304 QPZ88368.1 RNA-dependent RNA polymerase, partial [Soybean thrips tombus-like virus 10] diamond 621 77.8 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Soybean thrips tombus-like virus 10

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