RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA1145276" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1145276 · 23 ✖

analysis 1

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
288439 288439 PRJNA1145276_P_NODE_341_length_1451_cov_2.486212_g319_i0 PRJNA1145276 341 1451 2.486212 36.07493612 Potyvirus jasmini 3240550 Viruses Viruses 2342 0   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g319 i0 95.796 8.6078566505858 1451 61 100 0 1 1451 9346 7896 Jasmine virus T isolate YJ, complete genome blastn 12490 2342 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
1562881 1562881 PRJNA1145276_P_NODE_12322_length_289_cov_1.782407_g12265_i0 PRJNA1145276 12322 289 1.782407 5.15115623 Bactrocera dorsalis cripavirus 2739222 Viruses Viruses 534 2.18e-147   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g12265 i0 100 9.85813148788927 289 0 100 0 1 289 5792 6080 Bactrocera dorsalis cripavirus, complete genome blastn 2849 534 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
5391520 5391520 PRJNA1145276_P_NODE_15225_length_256_cov_1.262295_g15168_i0 PRJNA1145276 15225 256 1.262295 3.2314752 Potyvirus jasmini 3240550 Viruses Viruses 339 1.5999999999999998e-88   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g15168 i0 90.873 1.11328125 252 23 98 0 5 256 738 487 Jasmine virus T isolate YJ, complete genome blastn 285 339 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
6136106 6136106 PRJNA1145276_P_NODE_9885_length_324_cov_1.848606_g9828_i0 PRJNA1145276 9885 324 1.848606 5.98948344 Cripavirus 144051 Viruses Viruses 571 1.8899999999999993e-158   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g9828 i0 98.457 18.4382716049383 324 5 100 0 1 324 1331 1008 Bactrocera dorsalis cripavirus, complete genome blastn 5974 571 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
6666327 6666327 PRJNA1145276_P_NODE_19786_length_226_cov_3.013072_g19729_i0 PRJNA1145276 19786 226 3.013072 6.80954272 Potyvirus jasmini 3240550 Viruses Viruses 300 6.51e-77   NTclustered gi|985485902|ref|NC_029051.1| 1775963 g19729 i0 90.667 2.76548672566372 225 21 99 0 1 225 7632 7408 Jasmine ringspot virus, complete genome blastn 625 300 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
6666400 6666400 PRJNA1145276_P_NODE_6006_length_407_cov_1.826347_g5949_i0 PRJNA1145276 6006 407 1.826347 7.43323229 Bactrocera dorsalis cripavirus 2739222 Viruses Viruses 713 0   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g5949 i0 98.519 10.2702702702703 405 5 99 1 4 407 420 16 Bactrocera dorsalis cripavirus, complete genome blastn 4180 713 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
10492174 10492174 PRJNA1145276_P_NODE_6949_length_381_cov_2.250000_g6892_i0 PRJNA1145276 6949 381 2.25 8.5725 Potyvirus jasmini 3240550 Viruses Viruses 505 2.32e-138   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g6892 i0 90.551 7.54855643044619 381 36 100 0 1 381 7894 8274 Jasmine virus T isolate YJ, complete genome blastn 2876 505 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
10492234 10492234 PRJNA1145276_P_NODE_9469_length_331_cov_1.686047_g9412_i0 PRJNA1145276 9469 331 1.686047 5.58081557 Potyvirus jasmini 3240550 Viruses Viruses 508 1.54e-139   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g9412 i0 94.529 4.23262839879154 329 18 99 0 3 331 3552 3880 Jasmine virus T isolate YJ, complete genome blastn 1401 508 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
11766915 11766915 PRJNA1145276_P_NODE_130_length_1992_cov_3.454403_g122_i0 PRJNA1145276 130 1992 3.454403 68.81170776 Apis cripavirus 2873540 Viruses Viruses 3602 0   NTclustered gi|2111829803|gb|MZ822074.1| 2873540 g122 i0 99.297 7.74447791164659 1992 14 100 0 1 1992 7715 5724 MAG: Apis cripavirus isolate No8-AM-LN-2017-11, complete genome blastn 15427 3602 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Apis cripavirus
11767111 11767111 PRJNA1145276_P_NODE_4050_length_486_cov_1.116223_g3993_i0 PRJNA1145276 4050 486 1.116223 5.42484378 Potyvirus jasmini 3240550 Viruses Viruses 787 0   NTclustered gi|985485902|ref|NC_029051.1| 1775963 g3993 i0 95.885 3.97942386831276 486 20 100 0 1 486 3094 3579 Jasmine ringspot virus, complete genome blastn 1934 787 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
13042228 13042228 PRJNA1145276_P_NODE_791_length_1034_cov_2.163371_g752_i0 PRJNA1145276 791 1034 2.163371 22.36925614 Bactrocera dorsalis cripavirus 2739222 Viruses Viruses 1799 0   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g752 i0 98.157 10.4758220502901 1031 19 99 0 1 1031 2188 3218 Bactrocera dorsalis cripavirus, complete genome blastn 10832 1799 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
13042245 13042245 PRJNA1145276_P_NODE_8491_length_349_cov_1.108696_g8434_i0 PRJNA1145276 8491 349 1.108696 3.86934904 Potyvirus jasmini 3240550 Viruses Viruses 590 5.649999999999998e-164   NTclustered gi|985485902|ref|NC_029051.1| 1775963 g8434 i0 97.135 2.99426934097421 349 10 100 0 1 349 5027 5375 Jasmine ringspot virus, complete genome blastn 1045 590 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
14317166 14317166 PRJNA1145276_P_NODE_1172_length_865_cov_1.539141_g1126_i0 PRJNA1145276 1172 865 1.539141 13.31356965 Potyvirus jasmini 3240550 Viruses Viruses 1445 0   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g1126 i0 96.871 2.99075144508671 863 27 99 0 3 865 5898 6760 Jasmine virus T isolate YJ, complete genome blastn 2587 1445 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
16335630 16335630 PRJNA1145276_P_NODE_1113_length_885_cov_3.615764_g1069_i0 PRJNA1145276 1113 885 3.615764 31.9995114 Cripavirus 144051 Viruses Viruses 1557 0   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g1069 i0 98.418 22.9581920903955 885 14 100 0 1 885 6137 7021 Bactrocera dorsalis cripavirus, complete genome blastn 20318 1557 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
16865714 16865714 PRJNA1145276_P_NODE_934_length_964_cov_1.742985_g894_i0 PRJNA1145276 934 964 1.742985 16.8023754 Potyvirus jasmini 3240550 Viruses Viruses 1526 0   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g894 i0 95.228 3.98547717842324 964 46 100 0 1 964 7725 6762 Jasmine virus T isolate YJ, complete genome blastn 3842 1526 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
18140207 18140207 PRJNA1145276_P_NODE_5455_length_426_cov_1.538244_g5398_i0 PRJNA1145276 5455 426 1.538244 6.55291944 Potyvirus jasmini 3240550 Viruses Viruses 699 0   NTclustered gi|985485902|ref|NC_029051.1| 1775963 g5398 i0 96.244 12.5164319248826 426 16 100 0 1 426 9192 8767 Jasmine ringspot virus, complete genome blastn 5332 699 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
18140317 18140317 PRJNA1145276_P_NODE_9935_length_324_cov_0.920319_g9878_i0 PRJNA1145276 9935 324 0.920319 2.98183356 Potyvirus jasmini 3240550 Viruses Viruses 544 4.12e-150   NTclustered gi|985485902|ref|NC_029051.1| 1775963 g9878 i0 96.914 1 324 10 100 0 1 324 4035 3712 Jasmine ringspot virus, complete genome blastn 324 544 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
18884819 18884819 PRJNA1145276_P_NODE_2835_length_576_cov_1.823062_g2778_i0 PRJNA1145276 2835 576 1.823062 10.50083712 Cripavirus 144051 Viruses Viruses 1031 0   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g2778 i0 98.958 16.9236111111111 576 6 100 0 1 576 2206 1631 Bactrocera dorsalis cripavirus, complete genome blastn 9748 1031 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus
19414355 19414355 PRJNA1145276_P_NODE_14976_length_259_cov_1.241935_g14919_i0 PRJNA1145276 14976 259 1.241935 3.21661165 Potyvirus jasmini 3240550 Viruses Viruses 255 1.68e-63   NTclustered gi|985485902|ref|NC_029051.1| 1775963 g14919 i0 97.333 2.01544401544402 150 4 100 0 1 150 6398 6249 Jasmine ringspot virus, complete genome blastn 522 255 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
23240862 23240862 PRJNA1145276_P_NODE_5119_length_438_cov_1.578082_g5062_i0 PRJNA1145276 5119 438 1.578082 6.91199916 Potyvirus jasmini 3240550 Viruses Viruses 693 0   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g5062 i0 95.205 4.51141552511416 438 21 100 0 1 438 5423 4986 Jasmine virus T isolate YJ, complete genome blastn 1976 693 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
23240875 23240875 PRJNA1145276_P_NODE_5499_length_424_cov_1.994302_g5442_i0 PRJNA1145276 5499 424 1.994302 8.45584048 Potyvirus jasmini 3240550 Viruses Viruses 529 1.5499999999999995e-145   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g5442 i0 89.151 5.40094339622642 424 46 100 0 1 424 6954 7377 Jasmine virus T isolate YJ, complete genome blastn 2290 529 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
23240876 23240876 PRJNA1145276_P_NODE_5539_length_423_cov_1.100000_g5482_i0 PRJNA1145276 5539 423 1.1 4.653 Potyvirus jasmini 3240550 Viruses Viruses 654 0   NTclustered gi|2318781728|gb|MZ962345.1| 1775963 g5482 i0 94.575 2.00472813238771 424 22 100 1 1 423 3814 4237 Jasmine virus T isolate YJ, complete genome blastn 848 654 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus jasmini
23240891 23240891 PRJNA1145276_P_NODE_59_length_2484_cov_1.949399_g54_i0 PRJNA1145276 59 2484 1.949399 48.42307116 Bactrocera dorsalis cripavirus 2739222 Viruses Viruses 4353 0   NTclustered gi|1847622119|gb|MN738553.1| 2739222 g54 i0 98.348 10.9444444444444 2482 38 99 1 3 2484 5788 3310 Bactrocera dorsalis cripavirus, complete genome blastn 27186 4353 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Bactrocera dorsalis cripavirus

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