RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Shotokuvirae · 12 ✖

bioproject 1

  • PRJNA1237347 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
27199066 27199066 PRJNA1237347_P_NODE_169982_length_483_cov_1.592683_g163412_i0 PRJNA1237347 169982 483 1.592683 7.69265889 Ecklonia radiata-associated virus 3 2480193 Viruses Viruses 107 2.09e-24   NR YP_009553619.1 2480193 g163412 i0 44.9 0.732919254658385 118 57 69.6 3 80 415 10 125 YP_009553619.1 Rep-C [Ecklonia radiata-associated virus 3] diamond 354 107 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Ecklonia radiata-associated virus 3
27231316 27231316 PRJNA1237347_P_NODE_526123_length_244_cov_1.754386_g519550_i0 PRJNA1237347 526123 244 1.754386 4.28070184 Ecklonia radiata-associated virus 3 2480193 Viruses Viruses 81.6 3.84e-16   NR YP_009553619.1 2480193 g519550 i0 50 0.909836065573771 74 37 91 0 223 2 139 212 YP_009553619.1 Rep-C [Ecklonia radiata-associated virus 3] diamond 222 81.6 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Ecklonia radiata-associated virus 3
27957699 27957699 PRJNA1237347_P_NODE_490365_length_249_cov_0.875000_g483792_i0 PRJNA1237347 490365 249 0.875 2.17875 Cressdnaviricota sp. 2748378 Viruses Viruses 66.6 2.87e-11   NR AXH73392.1 2748378 g483792 i0 45.2 0.879518072289157 73 39 88 1 249 31 90 161 AXH73392.1 MAG: putative replicase [Cressdnaviricota sp.] diamond 219 66.6 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
28021018 28021018 PRJNA1237347_P_NODE_496685_length_248_cov_0.880000_g490112_i0 PRJNA1237347 496685 248 0.88 2.1824 Cressdnaviricota sp. 2748378 Viruses Viruses 108 9.02e-26   NR AXH77886.1 2748378 g490112 i0 54.9 0.991935483870968 82 37 99.2 0 248 3 146 227 AXH77886.1 MAG: helicase [Cressdnaviricota sp.] diamond 246 108 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
28620577 28620577 PRJNA1237347_P_NODE_232527_length_392_cov_6.401254_g225955_i0 PRJNA1237347 232527 392 6.401254 25.09291568 Circoviridae sp. 1954248 Viruses Viruses 46.2 8.89e-4   NR UOF78025.1 1954248 g225955 i0 43.8 0.36734693877551 48 27 36.7 0 234 91 19 66 UOF78025.1 hypothetical protein [Circoviridae sp.] diamond 144 46.2 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
29472969 29472969 PRJNA1237347_P_NODE_499610_length_248_cov_0.880000_g493037_i0 PRJNA1237347 499610 248 0.88 2.1824 Cressdnaviricota sp. 2748378 Viruses Viruses 48.9 1.86e-4   NR AXQ65655.1 2748378 g493037 i0 44.4 0.653225806451613 54 26 60.5 1 161 12 146 199 AXQ65655.1 MAG: putative replicase [Cressdnaviricota sp.] diamond 162 48.9 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
29883939 29883939 PRJNA1237347_P_NODE_520991_length_245_cov_0.895349_g514418_i0 PRJNA1237347 520991 245 0.895349 2.19360505 Circoviridae sp. 1954248 Viruses Viruses 96.3 1.72e-22   NR AXQ66263.1 1954248 g514418 i0 63 0.991836734693878 81 29 99.2 1 2 244 55 134 AXQ66263.1 MAG: replication protein [Circoviridae sp.] diamond 243 96.3 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
30167964 30167964 PRJNA1237347_P_NODE_540132_length_243_cov_0.905882_g533559_i0 PRJNA1237347 540132 243 0.905882 2.20129326 Shdaciful virus 4 3132057 Viruses Viruses 58.2 1.2e-7   NR WXG22996.1 3132057 g533559 i0 35 0.987654320987654 80 52 98.8 0 243 4 136 215 WXG22996.1 MAG: replication protein, partial [Shdaciful virus 4] diamond 240 58.2 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Shdaciful virus 4
30358133 30358133 PRJNA1237347_P_NODE_482012_length_250_cov_0.870056_g475439_i0 PRJNA1237347 482012 250 0.870056 2.17514 Cressdnaviricota sp. 2748378 Viruses Viruses 146 9.319999999999997e-42   NR AXQ66408.1 2748378 g475439 i0 89 0.984 82 9 98.4 0 248 3 26 107 AXQ66408.1 MAG: coat protein [Cressdnaviricota sp.] diamond 246 146 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
30421165 30421165 PRJNA1237347_P_NODE_462593_length_254_cov_1.701657_g456020_i0 PRJNA1237347 462593 254 1.701657 4.32220878 Motacilla cinerea CRESS-DNA-virus sp. 2815043 Viruses Viruses 79 1.12e-15   NR QTE03521.1 2815043 g456020 i0 60 0.708661417322835 60 24 70.9 0 252 73 166 225 QTE03521.1 MAG: replication-associated protein [Motacilla cinerea CRESS-DNA-virus sp.] diamond 180 79 1 Viruses   Shotokuvirae Cressdnaviricota         Motacilla cinerea CRESS-DNA-virus sp.
31146707 31146707 PRJNA1237347_P_NODE_18715_length_1830_cov_4.021059_g16313_i0 PRJNA1237347 18715 1830 4.021059 73.5853797 Cressdnaviricota sp. 2748378 Viruses Viruses 498 5.429999999999998e-171   NR AXQ66115.1 2748378 g16313 i0 78.5 0.986885245901639 311 58 50.2 3 961 44 1 307 AXQ66115.1 MAG: putative capsid protein [Cressdnaviricota sp.] diamond 1806 498 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
32476079 32476079 PRJNA1237347_P_NODE_307719_length_329_cov_1.054688_g301146_i0 PRJNA1237347 307719 329 1.054688 3.46992352 Circoviridae sp. 1954248 Viruses Viruses 63.5 3.64e-9   NR QJI53605.1 1954248 g301146 i0 42.7 2.81762917933131 96 48 87.5 3 1 288 63 151 QJI53605.1 MAG: replication associated protein [Circoviridae sp.] diamond 927 63.5 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard

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