RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 8 ✖

bioproject 1

  • PRJEB2925 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
15328292 15328292 PRJEB2925_P_NODE_453_length_7390_cov_9.157988_g332_i0 PRJEB2925 453 7390 9.157988 676.7753132 Viruses 10239 Viruses Viruses 704 3.84e-212   NR QZZ63310.1 2874401 g332 i0 34.3 3.94506089309878 1360 748 53.9 27 5 3985 555 1801 QZZ63310.1 hypothetical protein [Vespula vulgaris Picorna-like virus 1] diamond 29154 704 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Vespula vulgaris Picorna-like virus 1
21702866 21702866 PRJEB2925_P_NODE_458_length_7325_cov_9.220850_g332_i1 PRJEB2925 458 7325 9.22085 675.4272625 Viruses 10239 Viruses Viruses 669 2.7e-200   NR UYL95314.1 2972097 g332 i1 44.3 3.72450511945392 823 428 32.9 12 5781 3373 919 1731 UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1] diamond 27282 673 0.99405646359584 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Maanshan Dicis tick virus 1
26653099 26653099 PRJEB2925_P_NODE_2661_length_941_cov_4.394040_g2007_i0 PRJEB2925 2661 941 4.39404 41.3479164 Downy mildew lesion associated splipalmivirus 3 2719514 Viruses Viruses 90.1 3.95e-17   NR WNA22210.1 2719514 g2007 i0 31 0.586609989373007 184 111 58.3 3 198 746 51 219 WNA22210.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 3] diamond 552 90.1 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Splipalmiviridae Jakapalmivirus Jakapalmivirus ibericum
27538883 27538883 PRJEB2925_P_NODE_3484_length_770_cov_2.609524_g2672_i0 PRJEB2925 3484 770 2.609524 20.0933348 Sjack associated narna-like virus 8 3067056 Viruses Viruses 139 2.12e-36   NR WPR17380.1 3067056 g2672 i0 38 0.861038961038961 221 120 85.3 6 768 112 22 227 WPR17380.1 MAG: RNA-dependent RNA polymerase, partial [Sjack associated narna-like virus 8] diamond 663 139 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Sjack associated narna-like virus 8
30184666 30184666 PRJEB2925_P_NODE_9272_length_390_cov_2.794366_g8004_i0 PRJEB2925 9272 390 2.794366 10.8980274 Viruses 10239 Viruses Viruses 80.5 1.26e-14   NR ULF99782.1 1955144 g8004 i0 33.3 4.47692307692308 117 78 90 0 36 386 490 606 ULF99782.1 MAG: putative replicase [Dicistroviridae sp.] diamond 1746 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
30191109 30191109 PRJEB2925_P_NODE_14892_length_263_cov_1.228070_g13614_i0 PRJEB2925 14892 263 1.22807 3.2298241 Erysiphe necator associated narnavirus 18 2736375 Viruses Viruses 43.1 0.0351   NR QJT93750.1 2736375 g13614 i0 47.9 0.547528517110266 48 24 54.8 1 114 257 18 64 QJT93750.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 18] diamond 144 43.1 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Erysiphe necator associated narnavirus 18
30254708 30254708 PRJEB2925_P_NODE_11692_length_320_cov_2.417544_g10417_i0 PRJEB2925 11692 320 2.417544 7.7361408 Ripuglab virus 3130501 Viruses Viruses 58.2 3.51e-7   NR WZH59752.1 3130501 g10417 i0 34.3 1.0125 108 69 99.4 1 1 318 9 116 WZH59752.1 MAG: RNA-dependent RNA polymerase [Ripuglab virus] diamond 324 58.2 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Ripuglab virus
30538756 30538756 PRJEB2925_P_NODE_9773_length_374_cov_2.513274_g8502_i0 PRJEB2925 9773 374 2.513274 9.39964476 Moss associated narna-like virus 29 3066988 Viruses Viruses 48.9 0.00108   NR WPR17166.1 3066988 g8502 i0 34.2 2.06951871657754 79 51 62.6 1 47 280 160 238 WPR17166.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated narna-like virus 29] diamond 774 48.9 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Moss associated narna-like virus 29

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