RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJEB2925" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 14 ✖

bioproject 1

  • PRJEB2925 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
5128458 5128458 PRJEB2925_P_NODE_14145_length_273_cov_1.798319_g12867_i0 PRJEB2925 14145 273 1.798319 4.90941087 Caudoviricetes sp. 2832643 Viruses Viruses 141 3.98e-39   NR XOR79776.1 2832643 g12867 i0 82.6 0.945054945054945 86 15 94.5 0 260 3 1 86 XOR79776.1 MAG: N-acetylmuramidase [Caudoviricetes sp.] diamond 258 141 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
22664934 22664934 PRJEB2925_P_NODE_11018_length_337_cov_1.897351_g9744_i0 PRJEB2925 11018 337 1.897351 6.39407287 Caudoviricetes sp. 2832643 Viruses Viruses 70.9 1.52e-11   NR XOR07127.1 2832643 g9744 i0 59.4 1.22848664688427 69 21 55.2 1 3 188 556 624 XOR07127.1 MAG: methyltransferase [Caudoviricetes sp.] diamond 414 70.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
27602141 27602141 PRJEB2925_P_NODE_10604_length_349_cov_1.656051_g9332_i0 PRJEB2925 10604 349 1.656051 5.77961799 Caudoviricetes sp. 2832643 Viruses Viruses 66.2 7.06e-10   NR XOR69375.1 2832643 g9332 i0 38.8 0.885386819484241 103 57 86 4 37 336 158 257 XOR69375.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 309 66.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29843722 29843722 PRJEB2925_P_NODE_10591_length_349_cov_2.289809_g9319_i0 PRJEB2925 10591 349 2.289809 7.99143341 Caudoviricetes sp. 2832643 Viruses Viruses 212 1.3999999999999996e-68   NR DAJ56265.1 2832643 g9319 i0 87.9 1.99426934097421 116 14 99.7 0 349 2 11 126 DAJ56265.1 MAG TPA: putative nuclease [Caudoviricetes sp.] diamond 696 212 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
30286432 30286432 PRJEB2925_P_NODE_12112_length_310_cov_2.909091_g10836_i0 PRJEB2925 12112 310 2.909091 9.0181821 Caudoviricetes sp. 2832643 Viruses Viruses 104 1.65e-24   NR XOR79776.1 2832643 g10836 i0 77.2 0.551612903225806 57 12 54.2 1 308 141 84 140 XOR79776.1 MAG: N-acetylmuramidase [Caudoviricetes sp.] diamond 171 104 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
31518706 31518706 PRJEB2925_P_NODE_12856_length_295_cov_2.057692_g11579_i0 PRJEB2925 12856 295 2.057692 6.0701914 Caudoviricetes sp. 2832643 Viruses Viruses 85.9 7.71e-20   NR DAJ56266.1 2832643 g11579 i0 86.7 0.457627118644068 45 6 45.8 0 287 153 1 45 DAJ56266.1 MAG TPA: putative RNA-binding protein [Caudoviricetes sp.] diamond 135 85.9 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);;