RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax_phylum = "Negarnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Negarnaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1123436 · 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
27828383 27828383 PRJNA1123436_P_NODE_65844_length_307_cov_1.645299_g64630_i0 PRJNA1123436 65844 307 1.645299 5.05106793 brine shrimp arlivirus 5 2900380 Viruses Viruses 170 4.21e-49   NR UNI74090.1 2900380 g64630 i0 84 0.977198697068404 100 16 97.7 0 306 7 251 350 UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5] diamond 300 170 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsafivalis
30860131 30860131 PRJNA1123436_P_NODE_65174_length_309_cov_1.080508_g63960_i0 PRJNA1123436 65174 309 1.080508 3.33876972 brine shrimp arlivirus 8 2900383 Viruses Viruses 49.3 3.88e-4   NR UNI74120.1 2900383 g63960 i0 39.7 0.563106796116505 58 35 56.3 0 183 10 1 58 UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] diamond 174 49.3 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsaeighalis
31524088 31524088 PRJNA1123436_P_NODE_18536_length_621_cov_0.956204_g17342_i0 PRJNA1123436 18536 621 0.956204 5.93802684 brine shrimp arlivirus 5 2900380 Viruses Viruses 187 9.47e-53   NR UNI74091.1 2900380 g17342 i0 49.5 0.995169082125604 206 104 99.5 0 1 618 160 365 UNI74091.1 MAG: hypothetical protein [brine shrimp arlivirus 5] diamond 618 187 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsafivalis

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