RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA799842", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

  • Negarnaviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA799842 · 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
3344401 3344401 PRJNA799842_P_NODE_135263_length_251_cov_0.865169_g133690_i0 PRJNA799842 135263 251 0.865169 2.17157419 brine shrimp yue-like virus 9 2900461 Viruses Viruses 436 5.369999999999999e-118   NTclustered gi|2209094451|gb|OL472856.1| 2900461 g133690 i0 98.008 3 251 5 100 0 1 251 876 626 MAG: Brine shrimp yue-like virus 9 isolate CK/00-16 segment 1 RNA-dependent RNA polymerase gene, complete cds blastn 753 436 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   brine shrimp yue-like virus 9
27465003 27465003 PRJNA799842_P_NODE_26223_length_574_cov_1.421158_g24670_i0 PRJNA799842 26223 574 1.421158 8.15744692 brine shrimp arlivirus 8 2900383 Viruses Viruses 217 9.000000000000002e-66   NR UNI74120.1 2900383 g24670 i0 56.4 0.945993031358885 181 79 94.6 0 560 18 187 367 UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] diamond 543 217 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsaeighalis
27654458 27654458 PRJNA799842_P_NODE_61584_length_363_cov_1.013793_g60011_i0 PRJNA799842 61584 363 1.013793 3.68006859 brine shrimp arlivirus 5 2900380 Viruses Viruses 206 7.76e-63   NR UNI74090.1 2900380 g60011 i0 82.5 0.991735537190083 120 21 99.2 0 2 361 256 375 UNI74090.1 MAG: hypothetical protein [brine shrimp arlivirus 5] diamond 360 206 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);;