RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB83101" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJEB83101 · 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
26749004 26749004 PRJEB83101_P_NODE_41121_length_292_cov_1.780822_g40816_i0 PRJEB83101 41121 292 1.780822 5.20000024 Morogoro maize-associated virus 2497337 Viruses Viruses 171 1.32e-50   NR QYU75380.1 2497337 g40816 i0 83.5 0.996575342465753 97 16 99.7 0 292 2 159 255 QYU75380.1 putative movement protein [Morogoro maize-associated virus] diamond 291 171 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Alphanucleorhabdovirus Alphanucleorhabdovirus morogoromaydis
27698128 27698128 PRJEB83101_P_NODE_43724_length_287_cov_1.635514_g43419_i0 PRJEB83101 43724 287 1.635514 4.69392518 Morogoro maize-associated virus 2497337 Viruses Viruses 108 1.01e-26   NR YP_010087199.1 2497337 g43419 i0 94.4 0.564459930313589 54 3 56.4 0 285 124 181 234 YP_010087199.1 matrix protein [Morogoro maize-associated virus] diamond 162 108 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Alphanucleorhabdovirus Alphanucleorhabdovirus morogoromaydis
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);;