RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA814235 · 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
29422617 29422617 PRJNA814235_P_NODE_9_length_9636_cov_40.366080_g5_i0 PRJNA814235 9 9636 40.36608 3889.6754688 Chemarfal virus 23 3062885 Viruses Viruses 750 1.5799999999999993e-217   NR WPR17962.1 3062885 g5 i0 27.5 0.799501867995019 2568 1512 75.7 82 7514 219 572 2925 WPR17962.1 MAG: capsid protein [Chemarfal virus 23] diamond 7704 750 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 23
32425638 32425638 PRJNA814235_P_NODE_39_length_4138_cov_111.524262_g24_i0 PRJNA814235 39 4138 111.524262 4614.87396156 Chemarfal virus 23 3062885 Viruses Viruses 325 1.4600000000000001e-86   NR WPR17962.1 3062885 g24 i0 31.8 0.602464958917351 831 469 56.4 24 2550 217 2140 2925 WPR17962.1 MAG: capsid protein [Chemarfal virus 23] diamond 2493 325 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 23

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