RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1136957" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 10 ✖

bioproject 1

  • PRJNA1136957 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
27355015 27355015 PRJNA1136957_S_NODE_11883_length_249_cov_1.284211_g11786_i0 PRJNA1136957 11883 249 1.284211 3.19768539 Pseudomonas phage OBP 1124849 Viruses Viruses 45.1 0.00574   NR YP_004958196.1 1124849 g11786 i0 35.6 0.710843373493976 59 38 71.1 0 230 54 1 59 YP_004958196.1 hypothetical protein OBP_289 [Pseudomonas phage OBP] diamond 177 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Petsuvirus Pseudomonas phage OBP
27512816 27512816 PRJNA1136957_S_NODE_1703_length_498_cov_6.223235_g1607_i0 PRJNA1136957 1703 498 6.223235 30.9917103 Gammaretrovirus murleu 3428959 Viruses Viruses 336 1.39e-111   NR 8WUS_E 11801 g1607 i0 99.4 7.95180722891566 165 1 99.4 0 497 3 136 300 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] diamond 3960 336 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
28890891 28890891 PRJNA1136957_S_NODE_12928_length_240_cov_1.082873_g12831_i0 PRJNA1136957 12928 240 1.082873 2.5988952 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 57.8 1.83e-7   NR QHX39772.1 2951531 g12831 i0 43.8 2.6375 73 39 88.8 1 3 215 7 79 QHX39772.1 RNA-dependent RNA polymerase [Herr Frank virus 1] diamond 633 57.8 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
28997039 28997039 PRJNA1136957_S_NODE_15608_length_220_cov_2.273292_g15511_i0 PRJNA1136957 15608 220 2.273292 5.0012424 Pseudomonas phage ER16 2917704 Viruses Viruses 87.8 2.84e-18   NR UNI73401.1 2917704 g15511 i0 64.3 0.954545454545455 70 25 95.5 0 6 215 273 342 UNI73401.1 hypothetical protein ER16_Medium3 [Pseudomonas phage ER16] diamond 210 87.8 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Pseudomonas phage ER16
29217958 29217958 PRJNA1136957_S_NODE_2269_length_457_cov_5.741206_g2172_i0 PRJNA1136957 2269 457 5.741206 26.23731142 Pacmanvirus lostcity 3078859 Viruses Viruses 53.9 1.81e-5   NR XCN23187.1 3078859 g2172 i0 33 1.2472647702407 97 52 63.7 2 7 297 111 194 XCN23187.1 zinc finger C2H2-type domain-containing protein [Pacmanvirus lostcity] diamond 570 53.9 1 Viruses               Pacmanvirus lostcity
30733832 30733832 PRJNA1136957_S_NODE_16114_length_217_cov_1.500000_g16017_i0 PRJNA1136957 16114 217 1.5 3.255 Caudoviricetes sp. 2832643 Viruses Viruses 43.5 0.0033   NR DAV53031.1 2832643 g16017 i0 88.9 0.248847926267281 18 2 24.9 0 62 9 2 19 DAV53031.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 54 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30733837 30733837 PRJNA1136957_S_NODE_4034_length_383_cov_1.929012_g3937_i0 PRJNA1136957 4034 383 1.929012 7.38811596 Pacmanvirus lostcity 3078859 Viruses Viruses 48.9 6.54e-4   NR XCN23187.1 3078859 g3937 i0 31.8 0.66579634464752 85 45 66.6 2 7 261 111 182 XCN23187.1 zinc finger C2H2-type domain-containing protein [Pacmanvirus lostcity] diamond 255 48.9 1 Viruses               Pacmanvirus lostcity
31112828 31112828 PRJNA1136957_S_NODE_13855_length_232_cov_1.554913_g13758_i0 PRJNA1136957 13855 232 1.554913 3.60739816 Caudoviricetes sp. 2832643 Viruses Viruses 145 1.4099999999999999e-42   NR DAV52985.1 2832643 g13758 i0 88 0.969827586206897 75 9 97 0 6 230 38 112 DAV52985.1 MAG TPA: Terminase small subunit [Caudoviricetes sp.] diamond 225 145 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31808786 31808786 PRJNA1136957_S_NODE_457_length_728_cov_4.113602_g393_i0 PRJNA1136957 457 728 4.113602 29.94702256 Moloney murine leukemia virus 11801 Viruses Viruses 459 9.519999999999999e-147   NR NP_057933.2 11801 g393 i0 97.5 0.976648351648352 237 6 97.7 0 725 15 1094 1330 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 711 459 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
31840241 31840241 PRJNA1136957_S_NODE_14957_length_224_cov_2.957576_g14860_i0 PRJNA1136957 14957 224 2.957576 6.62497024 Caudoviricetes sp. 2832643 Viruses Viruses 39.7 0.0345   NR DAV53021.1 2832643 g14860 i0 42.5 0.535714285714286 40 23 53.6 0 86 205 1 40 DAV53021.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 120 39.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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