RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA642647 · 33 ✖

analysis 1

  • blastn · 33 ✖

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
617961 617961 PRJNA642647_P_NODE_2581_length_215_cov_2.494382_g2531_i0 PRJNA642647 2581 215 2.494382 5.3629213 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 370 4.609999999999999e-98   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g2531 i0 98.113 0.986046511627907 212 4 99 0 4 215 559 770 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 212 370 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
617992 617992 PRJNA642647_P_NODE_6141_length_154_cov_1.683761_g6091_i0 PRJNA642647 6141 154 1.683761 2.59299194 Qianjiang marna-like virus 4 3347685 Viruses Viruses 174 2.59e-39   NTclustered gi|2806503272|gb|PQ055061.1| 3347685 g6091 i0 91.339 2.93506493506493 127 11 82 0 4 130 5615 5741 MAG: Qianjiang marna-like virus 4 isolate QJ3MG143 genomic sequence blastn 452 174 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 4
1894176 1894176 PRJNA642647_P_NODE_1102_length_337_cov_3.273333_g1052_i0 PRJNA642647 1102 337 3.273333 11.03113221 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 579 1.1799999999999999e-160   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g1052 i0 97.904 3.96439169139466 334 7 99 0 1 334 2109 1776 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 1336 579 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
4445667 4445667 PRJNA642647_P_NODE_244_length_709_cov_5.360119_g206_i0 PRJNA642647 244 709 5.360119 38.00324371 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1293 0   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g206 i0 99.717 0.997179125528914 707 1 99 1 4 709 3718 4424 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 707 1293 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
6996530 6996530 PRJNA642647_P_NODE_1906_length_251_cov_2.565421_g1856_i0 PRJNA642647 1906 251 2.565421 6.43920671 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 442 1.1599999999999995e-119   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g1856 i0 98.79 1.9601593625498 248 3 99 0 4 251 154 401 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 492 442 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8271236 8271236 PRJNA642647_P_NODE_1007_length_352_cov_3.977778_g957_i0 PRJNA642647 1007 352 3.977778 14.00177856 Sobelivirales sp. 2809868 Viruses Viruses 523 5.869999999999998e-144   NTclustered gi|2647548694|gb|OR843429.1| 2809868 g957 i0 93.696 3 349 22 99 0 1 349 4200 3852 Sobelivirales sp. strain MR644-18D/28050 polyprotein and hypothetical protein genes, complete cds blastn 1056 523 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
8271251 8271251 PRJNA642647_P_NODE_187_length_813_cov_3.594072_g155_i0 PRJNA642647 187 813 3.594072 29.21980536 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1485 0   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g155 i0 99.753 0.996309963099631 810 2 99 0 4 813 5742 6551 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 810 1485 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8271291 8271291 PRJNA642647_P_NODE_467_length_509_cov_2.391949_g418_i0 PRJNA642647 467 509 2.391949 12.17502041 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 924 0   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g418 i0 99.411 1 509 3 100 0 1 509 2630 3138 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 509 924 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8271319 8271319 PRJNA642647_P_NODE_827_length_389_cov_2.196023_g777_i0 PRJNA642647 827 389 2.196023 8.54252947 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 702 0   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g777 i0 99.229 1.30077120822622 389 3 100 0 1 389 5621 5233 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 506 702 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
9546607 9546607 PRJNA642647_P_NODE_6328_length_152_cov_1.669565_g6278_i0 PRJNA642647 6328 152 1.669565 2.5377388 Picornaviridae sp. 1530251 Viruses Viruses 86.1 1.23e-12   NTclustered gi|2245485486|gb|ON161860.1| 1530251 g6278 i0 80 2.19078947368421 115 23 76 0 30 144 1069 1183 MAG: Picornaviridae sp. isolate 39R-k141_202243 RNA dependent RNA polymerase gene, partial cds blastn 333 86.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
9546612 9546612 PRJNA642647_P_NODE_848_length_384_cov_5.383285_g798_i0 PRJNA642647 848 384 5.383285 20.6718144 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 682 0   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g798 i0 98.95 0.9921875 381 4 99 0 4 384 6992 7372 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 381 682 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
10822207 10822207 PRJNA642647_P_NODE_2749_length_209_cov_6.063953_g2699_i0 PRJNA642647 2749 209 6.063953 12.67366177 Qianjiang marna-like virus 4 3347685 Viruses Viruses 315 2.12e-81   NTclustered gi|2806503272|gb|PQ055061.1| 3347685 g2699 i0 94.175 3.94258373205742 206 12 99 0 4 209 3463 3668 MAG: Qianjiang marna-like virus 4 isolate QJ3MG143 genomic sequence blastn 824 315 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 4
10822213 10822213 PRJNA642647_P_NODE_3309_length_194_cov_1.942675_g3259_i0 PRJNA642647 3309 194 1.942675 3.7687895 Qianjiang marna-like virus 4 3347685 Viruses Viruses 204 4.37e-48   NTclustered gi|2806503272|gb|PQ055061.1| 3347685 g3259 i0 85.864 0.984536082474227 191 27 98 0 4 194 6729 6919 MAG: Qianjiang marna-like virus 4 isolate QJ3MG143 genomic sequence blastn 191 204 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 4
10822233 10822233 PRJNA642647_P_NODE_549_length_479_cov_12.556561_g500_i0 PRJNA642647 549 479 12.556561 60.14592719 Betacoronavirus pandemicum 3418604 Viruses Viruses 63.9 2.15e-5   NTclustered gi|2565365187|emb|OY637518.1| 2697049 g500 i0 100 8.12734864300626 34 0 7 0 1 34 11667 11634 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3893 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10822237 10822237 PRJNA642647_P_NODE_5949_length_156_cov_2.294118_g5899_i0 PRJNA642647 5949 156 2.294118 3.57882408 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 110 7.52e-20   NTclustered gi|2754692283|gb|PP872849.1| 3003959 g5899 i0 85.321 0.698717948717949 109 12 67 3 48 152 647 539 MAG: Picornavirales sp. isolate TC-PLV-293 MR233-17E/1718 genomic sequence blastn 109 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
12097386 12097386 PRJNA642647_P_NODE_1010_length_352_cov_3.193651_g960_i0 PRJNA642647 1010 352 3.193651 11.24165152 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 627 4.3499999999999997e-175   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g960 i0 99.14 0.991477272727273 349 2 99 1 4 351 6679 7027 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 349 627 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
12097416 12097416 PRJNA642647_P_NODE_3570_length_188_cov_1.456954_g3520_i0 PRJNA642647 3570 188 1.456954 2.73907352 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 285 1.46e-72   NTclustered gi|2754692481|gb|PP872929.1| 3003959 g3520 i0 97.59 0.882978723404255 166 4 88 0 23 188 1595 1760 MAG: Picornavirales sp. isolate TC-PLV-373 MR233-17E/28527 genomic sequence blastn 166 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
13371997 13371997 PRJNA642647_P_NODE_1491_length_285_cov_4.903226_g1441_i0 PRJNA642647 1491 285 4.903226 13.9741941 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 483 7.879999999999998e-132   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g1441 i0 97.518 0.989473684210526 282 7 99 0 1 282 1027 746 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 282 483 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
13372043 13372043 PRJNA642647_P_NODE_591_length_460_cov_6.791962_g542_i0 PRJNA642647 591 460 6.791962 31.2430252 Betacoronavirus pandemicum 3418604 Viruses Viruses 63.9 2.06e-5   NTclustered gi|2565365187|emb|OY637518.1| 2697049 g542 i0 100 8.46304347826087 34 0 7 0 1 34 11667 11634 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 3893 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
14646891 14646891 PRJNA642647_P_NODE_1772_length_260_cov_5.026906_g1722_i0 PRJNA642647 1772 260 5.026906 13.0699556 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 414 2.62e-111   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g1722 i0 95.385 4 260 12 100 0 1 260 3422 3163 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 1040 414 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
17195912 17195912 PRJNA642647_P_NODE_1134_length_332_cov_1.772881_g1084_i0 PRJNA642647 1134 332 1.772881 5.88596492 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 527 4.2599999999999984e-145   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g1084 i0 95.719 3.94578313253012 327 14 98 0 4 330 4962 4636 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 1310 527 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
19744837 19744837 PRJNA642647_P_NODE_2476_length_219_cov_4.104396_g2426_i0 PRJNA642647 2476 219 4.104396 8.98862724 Qianjiang marna-like virus 4 3347685 Viruses Viruses 289 1.36e-73   NTclustered gi|2806503272|gb|PQ055061.1| 3347685 g2426 i0 90.741 1.97260273972603 216 20 99 0 1 216 7376 7161 MAG: Qianjiang marna-like virus 4 isolate QJ3MG143 genomic sequence blastn 432 289 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 4
19744848 19744848 PRJNA642647_P_NODE_3136_length_198_cov_3.925466_g3086_i0 PRJNA642647 3136 198 3.925466 7.77242268 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 335 1.5199999999999996e-87   NTclustered gi|2754692266|gb|PP872842.1| 3003959 g3086 i0 97.449 3.95959595959596 196 5 99 0 3 198 1406 1601 MAG: Picornavirales sp. isolate TC-PLV-286 MR233-17E/1659 genomic sequence blastn 784 335 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
21020361 21020361 PRJNA642647_P_NODE_1357_length_301_cov_2.708333_g1307_i0 PRJNA642647 1357 301 2.708333 8.15208233 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 507 4.97e-139   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g1307 i0 97.627 1.96013289036545 295 7 98 0 4 298 2341 2635 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 590 507 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
21020422 21020422 PRJNA642647_P_NODE_797_length_395_cov_2.614525_g747_i0 PRJNA642647 797 395 2.614525 10.32737375 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 634 2.9499999999999996e-177   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g747 i0 96.134 3.94430379746835 388 15 98 0 5 392 5589 5202 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 1558 634 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22295068 22295068 PRJNA642647_P_NODE_2738_length_210_cov_1.572254_g2688_i0 PRJNA642647 2738 210 1.572254 3.3017334 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 267 6.05e-67   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g2688 i0 89.855 2.96190476190476 207 21 99 0 1 207 2881 2675 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 622 267 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22295113 22295113 PRJNA642647_P_NODE_978_length_358_cov_2.978193_g928_i0 PRJNA642647 978 358 2.978193 10.66193094 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 651 0   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g928 i0 99.718 0.991620111731844 355 1 99 0 1 355 3475 3121 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 355 651 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23570687 23570687 PRJNA642647_P_NODE_1039_length_348_cov_2.971061_g989_i0 PRJNA642647 1039 348 2.971061 10.33929228 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 625 1.5499999999999995e-174   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g989 i0 99.419 0.988505747126437 344 2 99 0 2 345 5078 4735 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 344 625 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23570715 23570715 PRJNA642647_P_NODE_3999_length_180_cov_2.244755_g3949_i0 PRJNA642647 3999 180 2.244755 4.040559 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 320 3.79e-83   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g3949 i0 99.432 0.977777777777778 176 1 98 0 2 177 5759 5584 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 176 320 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23570719 23570719 PRJNA642647_P_NODE_4379_length_173_cov_2.110294_g4329_i0 PRJNA642647 4379 173 2.110294 3.65080862 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 279 6.12e-71   NTclustered gi|2754692481|gb|PP872929.1| 3003959 g4329 i0 96.45 0.976878612716763 169 6 98 0 4 172 669 837 MAG: Picornavirales sp. isolate TC-PLV-373 MR233-17E/28527 genomic sequence blastn 169 279 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23570749 23570749 PRJNA642647_P_NODE_959_length_360_cov_2.560372_g909_i0 PRJNA642647 959 360 2.560372 9.2173392 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 577 4.549999999999999e-160   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g909 i0 95.81 0.994444444444444 358 14 99 1 1 358 8029 7673 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 358 577 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
24844321 24844321 PRJNA642647_P_NODE_4100_length_178_cov_1.893617_g4050_i0 PRJNA642647 4100 178 1.893617 3.37063826 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 248 1.7899999999999997e-61   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g4050 i0 92.045 3.92134831460674 176 14 99 0 2 177 4247 4072 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 698 248 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
24844355 24844355 PRJNA642647_P_NODE_960_length_360_cov_2.343653_g910_i0 PRJNA642647 960 360 2.343653 8.4371508 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 621 2.0699999999999997e-173   NTclustered gi|2754692226|gb|PP872826.1| 3003959 g910 i0 98.039 0.991666666666667 357 7 99 0 4 360 1926 2282 MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence blastn 357 621 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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