RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJEB83101" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83101 · 2 ✖

analysis 1

  • diamond · 2 ✖

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
29686596 29686596 PRJEB83101_P_NODE_12830_length_537_cov_1.982759_g12533_i0 PRJEB83101 12830 537 1.982759 10.64741583 Tobacco streak virus 12317 Viruses Viruses 111 4.13e-26   NR NP_620773.1 12317 g12533 i0 75.7 2.06703910614525 74 18 41.3 0 223 2 1 74 NP_620773.1 movement protein [Tobacco streak virus] diamond 1110 111 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus TSV
30034439 30034439 PRJEB83101_P_NODE_66631_length_252_cov_1.391061_g66326_i0 PRJEB83101 66631 252 1.391061 3.50547372 Parietaria mottle virus 64958 Viruses Viruses 148 6.62e-42   NR ACU44511.1 64958 g66326 i0 82.9 6.84523809523809 82 14 97.6 0 250 5 72 153 ACU44511.1 3a protein [Parietaria mottle virus] diamond 1725 148 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus PMV

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