RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA1200128 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
17622476 17622476 PRJNA1200128_S_NODE_534_length_2446_cov_18.053267_g532_i0 PRJNA1200128 534 2446 18.053267 441.58291082 Moloney murine leukemia virus 11801 Viruses Viruses 1295 0   NR NP_057933.2 11801 g532 i0 97.6 2.42477514309076 659 16 80.8 0 143 2119 677 1335 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 5931 1295 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
26692668 26692668 PRJNA1200128_S_NODE_28921_length_181_cov_1.021739_g28812_i0 PRJNA1200128 28921 181 1.021739 1.84934759 Erythrocytic necrosis virus 1543320 Viruses Viruses 71.2 2e-14   NR QCF47502.1 1543320 g28812 i0 82.1 1.50828729281768 39 7 64.6 0 46 162 43 81 QCF47502.1 hypothetical protein, partial [Erythrocytic necrosis virus] diamond 273 71.2 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae   Erythrocytic necrosis virus
27198770 27198770 PRJNA1200128_S_NODE_47542_length_152_cov_1.724771_g47433_i0 PRJNA1200128 47542 152 1.724771 2.62165192 Bovine herpesvirus type 1.1 79889 Viruses Viruses 45.1 0.0011   NR YP_010374251.1 79889 g47433 i0 45.8 0.947368421052632 48 22 86.8 1 12 143 67 114 YP_010374251.1 product of latency-related protein [Bovine herpesvirus type 1.1] diamond 144 45.1 1 Viruses   Heunggongvirae Peploviricota Herviviricetes Herpesvirales Orthoherpesviridae Varicellovirus Varicellovirus bovinealpha1
28683350 28683350 PRJNA1200128_S_NODE_39847_length_162_cov_1.403361_g39738_i0 PRJNA1200128 39847 162 1.403361 2.27344482 Erythrocytic necrosis virus 1543320 Viruses Viruses 41.6 0.0114   NR QCF47486.1 1543320 g39738 i0 71 1.14814814814815 31 8 57.4 1 2 94 55 84 QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] diamond 186 42 0.990476190476191 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae   Erythrocytic necrosis virus
29030711 29030711 PRJNA1200128_S_NODE_14008_length_227_cov_1.532609_g13899_i0 PRJNA1200128 14008 227 1.532609 3.47902243 Erythrocytic necrosis virus 1543320 Viruses Viruses 42 0.0266   NR QCF47477.1 1543320 g13899 i0 66.7 0.713656387665198 27 9 35.7 0 227 147 102 128 QCF47477.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] diamond 162 42 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae   Erythrocytic necrosis virus
32885052 32885052 PRJNA1200128_S_NODE_22740_length_196_cov_1.176471_g22631_i0 PRJNA1200128 22740 196 1.176471 2.30588316 Adintovirus anguilla10665 3115889 Viruses Viruses 95.9 2.7e-23   NR DBA49781.1 3115889 g22631 i0 67.2 1.95918367346939 64 21 98 0 192 1 7 70 DBA49781.1 MAG TPA_asm: Cupiennin [Adintovirus anguilla10665] diamond 384 95.9 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus anguilla10665

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