RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 16 ✖

bioproject 1

  • PRJEB6584 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
25660679 25660679 PRJEB6584o_S_NODE_22802_length_194_cov_5.207547_g22694_i0 PRJEB6584 22802 194 5.207547 10.102641180000001 uncultured virus 340016 Viruses Viruses 90.9 1.16e-19   NR CAH6419174.1 340016 g22694 i0 68.4 3.52577319587629 57 18 88.1 0 3 173 332 388 CAH6419174.1 S-adenosylmethionine synthetase [uncultured virus] diamond 684 90.9 1 Viruses               uncultured virus
25932150 25932150 PRJEB6584l_S_NODE_10076_length_206_cov_1.865497_g9924_i0 PRJEB6584 10076 206 1.865497 3.84292382 Erysiphe necator associated virus 2 2741903 Viruses Viruses 117 6.91e-29   NR QKI79984.1 2741903 g9924 i0 75 0.990291262135922 68 17 99 0 1 204 273 340 QKI79984.1 RNA-dependent RNA polymerase [Erysiphe necator associated virus 2] diamond 204 117 1 Viruses               Erysiphe necator associated virus 2
26068370 26068370 PRJEB6584l_S_NODE_733_length_466_cov_6.129930_g630_i0 PRJEB6584 733 466 6.12993 28.5654738 Erysiphe necator associated virus 2 2741903 Viruses Viruses 195 1.4299999999999998e-56   NR QKI79984.1 2741903 g630 i0 76.4 0.791845493562232 123 29 79.2 0 3 371 408 530 QKI79984.1 RNA-dependent RNA polymerase [Erysiphe necator associated virus 2] diamond 369 195 1 Viruses               Erysiphe necator associated virus 2
32911952 32911952 PRJEB6584h_S_NODE_57185_length_162_cov_1.685039_g57123_i0 PRJEB6584 57185 162 1.685039 2.72976318 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 94 1.1e-20   NR WWZ85593.1 3132542 g57123 i0 84.9 0.981481481481482 53 8 98.1 0 3 161 739 791 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 159 94 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
32929082 32929082 PRJEB6584b_S_NODE_4425_length_186_cov_3.735099_g4407_i0 PRJEB6584 4425 186 3.735099 6.94728414 uncultured Caudovirales phage 2100421 Viruses Viruses 68.6 2.8e-12   NR CAB4124438.1 2100421 g4407 i0 62.1 0.935483870967742 58 22 93.5 0 8 181 57 114 CAB4124438.1 putative protease [uncultured Caudovirales phage] diamond 174 68.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32957499 32957499 PRJEB6584o_S_NODE_53234_length_165_cov_3.053846_g53126_i0 PRJEB6584 53234 165 3.053846 5.0388459 Viruses 10239 Viruses Viruses 43.9 0.0053   NR AWK77852.1 2201285 g53126 i0 40.4 1.61818181818182 47 28 85.5 0 159 19 259 305 AWK77852.1 nonstructural polyprotein, partial [Bundaberg bee virus 2] diamond 267 44.3 0.99097065462754 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Bundaberg bee virus 2
32997451 32997451 PRJEB6584h_S_NODE_2315_length_315_cov_4.560714_g2253_i0 PRJEB6584 2315 315 4.560714 14.3662491 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 110 1.47e-25   NR WWZ85593.1 3132542 g2253 i0 65 0.761904761904762 80 28 76.2 0 314 75 1800 1879 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 240 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
32997504 32997504 PRJEB6584l_S_NODE_20907_length_161_cov_2.222222_g20755_i0 PRJEB6584 20907 161 2.222222 3.57777742 Caudoviricetes sp. 2832643 Viruses Viruses 90.5 5.110000000000001e-21   NR XOF03948.1 2832643 g20755 i0 90.6 0.987577639751553 53 5 98.8 0 159 1 50 102 XOF03948.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 159 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32997507 32997507 PRJEB6584l_S_NODE_21803_length_159_cov_1.903226_g21651_i0 PRJEB6584 21803 159 1.903226 3.02612934 Erysiphe necator associated virus 2 2741903 Viruses Viruses 88.6 7.92e-19   NR QKI79984.1 2741903 g21651 i0 91.1 3.37735849056604 45 4 84.9 0 157 23 223 267 QKI79984.1 RNA-dependent RNA polymerase [Erysiphe necator associated virus 2] diamond 537 88.6 1 Viruses               Erysiphe necator associated virus 2
33065566 33065566 PRJEB6584b_S_NODE_2909_length_209_cov_2.068966_g2891_i0 PRJEB6584 2909 209 2.068966 4.32413894 uncultured Caudovirales phage 2100421 Viruses Viruses 52.8 4.38e-6   NR CAB4124966.1 2100421 g2891 i0 65.8 0.545454545454545 38 13 54.5 0 96 209 1 38 CAB4124966.1 hypothetical protein UFOVP61_51 [uncultured Caudovirales phage] diamond 114 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
33066012 33066012 PRJEB6584o_S_NODE_33021_length_178_cov_1.881119_g32913_i0 PRJEB6584 33021 178 1.881119 3.34839182 Tubulavirales sp. 2833306 Viruses Viruses 53.1 3.31e-6   NR XOF05256.1 2833306 g32913 i0 43.8 0.808988764044944 48 27 80.9 0 168 25 104 151 XOF05256.1 MAG: replication initiation protein [Tubulavirales sp.] diamond 144 53.1 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales     Tubulavirales sp.
33133995 33133995 PRJEB6584f_S_NODE_2975_length_187_cov_3.914474_g2969_i0 PRJEB6584 2975 187 3.914474 7.32006638 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 47 5.83e-4   NR WKU61618.1 3063761 g2969 i0 91.3 0.368983957219251 23 2 36.9 0 184 116 2198 2220 WKU61618.1 polyprotein [Zebrafish picornavirus 2] diamond 69 47 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
33134016 33134016 PRJEB6584h_S_NODE_615_length_447_cov_22.189320_g555_i0 PRJEB6584 615 447 22.18932 99.1862604 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 119 4.7000000000000005e-28   NR WWZ85593.1 3132542 g555 i0 44.6 0.932885906040268 139 75 91.9 2 445 35 145 283 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 417 119 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
33134320 33134320 PRJEB6584o_S_NODE_2455_length_449_cov_4.398551_g2357_i0 PRJEB6584 2455 449 4.398551 19.74949399 Spodoptera frugiperda ascovirus 1a 113370 Viruses Viruses 51.6 1.5e-4   NR YP_762380.1 113370 g2357 i0 39 0.394209354120267 59 33 39.4 1 428 252 170 225 YP_762380.1 25.7 Inhibitor of apoptosis/RING/U box [Spodoptera frugiperda ascovirus 1a] diamond 177 51.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Ascoviridae Ascovirus Ascovirus sfav1a
33150962 33150962 PRJEB6584e_S_NODE_1416_length_227_cov_8.692708_g1401_i0 PRJEB6584 1416 227 8.692708 19.73244716 Diatraea saccharalis granulovirus 1675862 Viruses Viruses 70.1 2.28e-13   NR YP_009182246.1 1675862 g1401 i0 41.1 0.964757709251101 73 43 96.5 0 220 2 22 94 YP_009182246.1 ubiquitin-like protein [Diatraea saccharalis granulovirus] diamond 219 70.1 1 Viruses       Naldaviricetes Lefavirales Baculoviridae Betabaculovirus Betabaculovirus disaccharalis
33150999 33150999 PRJEB6584l_S_NODE_10712_length_201_cov_2.722892_g10560_i0 PRJEB6584 10712 201 2.722892 5.47301292 Erysiphe necator associated virus 2 2741903 Viruses Viruses 114 1.2e-27   NR QKI79984.1 2741903 g10560 i0 77.6 1 67 15 100 0 201 1 9 75 QKI79984.1 RNA-dependent RNA polymerase [Erysiphe necator associated virus 2] diamond 201 114 1 Viruses               Erysiphe necator associated virus 2

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