RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJEB14664 · 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
1295426 1295426 PRJEB14664_P_NODE_2_length_9077_cov_27.573877_g1_i0 PRJEB14664 2 9077 27.573877 2502.88081529 Maanshan Dicis tick virus 1 2972097 Viruses Viruses 846 3.18e-261   NR UYL95314.1 2972097 g1 i0 32.7 5.34229370937534 1821 965 58.1 36 440 5710 108 1731 UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1] diamond 48492 846 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Maanshan Dicis tick virus 1
29237374 29237374 PRJEB14664_P_NODE_13649_length_195_cov_1.087500_g13519_i0 PRJEB14664 13649 195 1.0875 2.120625 Viruses 10239 Viruses Viruses 48.5 1.84e-4   NR YP_001686789.1 425010 g13519 i0 46.8 4.47692307692308 47 25 72.3 0 7 147 428 474 YP_001686789.1 RNA-dependent RNA polymerase [Botryotinia fuckeliana partitivirus 1] diamond 873 48.9 0.991820040899796 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Botryotinia fuckeliana partitivirus 1
32625286 32625286 PRJEB14664_P_NODE_13340_length_198_cov_0.981595_g13210_i0 PRJEB14664 13340 198 0.981595 1.9435581 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 84.7 3.45e-17   NR WWZ85593.1 3132542 g13210 i0 53 1 66 31 100 0 1 198 2768 2833 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 198 84.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4

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