RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1237347", tax_kingdom = "Shotokuvirae" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

analysis 2

tax_superkingdom 1

  • Viruses · 19 ✖

tax_kingdom 1

  • Shotokuvirae · 19 ✖

bioproject 1

  • PRJNA1237347 · 19 ✖
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
342793 342793 PRJNA1237347_P_NODE_421381_length_271_cov_1.166667_g414808_i0 PRJNA1237347 421381 271 1.166667 3.16166757 Cressdnaviricota sp. 2748378 Viruses Viruses 52.8 0.025   NTclustered gi|1436204446|gb|MH616955.1| 2748378 g414808 i0 100 0.103321033210332 28 0 10 0 133 160 3742 3715 MAG: Cressdnaviricota sp. isolate ctbc933, complete genome blastn 28 52.8 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
1617575 1617575 PRJNA1237347_P_NODE_426442_length_269_cov_1.030612_g419869_i0 PRJNA1237347 426442 269 1.030612 2.77234628 Cressdnaviricota sp. 2748378 Viruses Viruses 448 2.6899999999999995e-121   NTclustered gi|1436204076|gb|MH616907.1| 2748378 g419869 i0 96.992 0.988847583643123 266 8 99 0 4 269 620 355 MAG: Cressdnaviricota sp. isolate ctca234, complete genome blastn 266 448 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
4172064 4172064 PRJNA1237347_P_NODE_531304_length_244_cov_0.900585_g524731_i0 PRJNA1237347 531304 244 0.900585 2.1974274 Betapapillomavirus 2 333924 Viruses Viruses 429 8.699999999999998e-116   NTclustered gi|1020234|gb|U31787.1|HPU31787 37959 g524731 i0 98.361 6.61065573770492 244 4 100 0 1 244 4093 4336 Human papillomavirus type 38, complete genome blastn 1613 429 1 Viruses   Shotokuvirae Cossaviricota Papovaviricetes Zurhausenvirales Papillomaviridae Betapapillomavirus Betapapillomavirus 2
9265003 9265003 PRJNA1237347_P_NODE_13008_length_2204_cov_4.557954_g11235_i0 PRJNA1237347 13008 2204 4.557954 100.45730616 Avon-Heathcote Estuary associated circular virus 13 1618236 Viruses Viruses 922 0   NTclustered gi|761263250|gb|KM874331.1| 1618236 g11235 i0 75.885 2.69237749546279 1978 382 88 76 1 1934 1928 2 Avon-Heathcote Estuary associated circular virus 13 isolate AHEaCV-13-NZ-4754GA-2012, complete genome blastn 5934 922 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Avon-Heathcote Estuary associated circular virus 13
18192462 18192462 PRJNA1237347_P_NODE_318235_length_322_cov_1.236948_g311662_i0 PRJNA1237347 318235 322 1.236948 3.98297256 Galvornvirus isengard 2955925 Viruses Viruses 595 1.1099999999999995e-165   NTclustered gi|2725932850|gb|PP750563.1| 1954248 g311662 i0 100 7.18944099378882 322 0 100 0 1 322 847 526 Circoviridae sp. isolate V10 ORF10 gene, complete cds blastn 2315 595 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
20745547 20745547 PRJNA1237347_P_NODE_481157_length_250_cov_0.870056_g474584_i0 PRJNA1237347 481157 250 0.870056 2.17514 Human papillomavirus 10566 Viruses Viruses 462 8.83e-126   NTclustered gi|1480688325|gb|MH777241.1| 10566 g474584 i0 100 3.176 250 0 100 0 1 250 2553 2304 MAG: Human papillomavirus isolate HPV-mSK_098, complete genome blastn 794 462 1 Viruses Human papillomavirus types Shotokuvirae Cossaviricota Papovaviricetes Zurhausenvirales Papillomaviridae   Human papillomavirus
20745611 20745611 PRJNA1237347_P_NODE_485497_length_249_cov_2.011364_g478924_i0 PRJNA1237347 485497 249 2.011364 5.00829636 Galvornvirus isengard 2955925 Viruses Viruses 427 3.2e-115   NTclustered gi|1436204072|gb|MH616906.1| 1954248 g478924 i0 97.59 1 249 6 100 0 1 249 726 478 MAG: Circoviridae sp. isolate ctjd115, complete genome blastn 249 427 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
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);;