RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "blastn", bioproject = "PRJNA193544" 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

  • PRJNA193544 · 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
1640683 1640683 PRJNA193544_S_NODE_3242_length_155_cov_3.031746_g3227_i0 PRJNA193544 3242 155 3.031746 4.6992063 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 211 1.99e-50   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g3227 i0 100 1.71612903225806 114 0 74 0 42 155 1133 1020 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 266 211 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
1640699 1640699 PRJNA193544_S_NODE_782_length_275_cov_14.991870_g767_i0 PRJNA193544 782 275 14.99187 41.2276425 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 475 1.2699999999999996e-129   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g767 i0 97.818 1 275 6 100 0 1 275 2219 2493 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 275 475 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
2916571 2916571 PRJNA193544_S_NODE_43_length_591_cov_8.996441_g34_i0 PRJNA193544 43 591 8.996441 53.16896631 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 924 0   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g34 i0 95.502 0.978003384094755 578 26 98 0 13 590 3463 2886 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 578 924 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
4192999 4192999 PRJNA193544_S_NODE_44_length_586_cov_16.095153_g35_i0 PRJNA193544 44 586 16.095153 94.31759658 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 867 0   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g35 i0 100 0.800341296928328 469 0 80 0 118 586 1 469 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 469 867 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
5469227 5469227 PRJNA193544_S_NODE_225_length_386_cov_21.969188_g210_i0 PRJNA193544 225 386 21.969188 84.80106568 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 678 0   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g210 i0 98.691 1.97927461139896 382 5 99 0 1 382 860 1241 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 764 678 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
5469250 5469250 PRJNA193544_S_NODE_745_length_281_cov_10.138889_g730_i0 PRJNA193544 745 281 10.138889 28.49027809 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 453 6.08e-123   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g730 i0 95.73 1 281 12 100 0 1 281 3472 3752 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 281 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
6743542 6743542 PRJNA193544_S_NODE_1326_length_223_cov_12.407216_g1311_i0 PRJNA193544 1326 223 12.407216 27.66809168 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 396 7.939999999999995e-106   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g1311 i0 98.655 1 223 3 100 0 1 223 7039 6817 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 223 396 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
6743550 6743550 PRJNA193544_S_NODE_1586_length_209_cov_7.611111_g1571_i0 PRJNA193544 1586 209 7.611111 15.90722199 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 359 9.64e-95   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g1571 i0 97.608 1 209 5 100 0 1 209 6149 5941 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 209 359 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
6743602 6743602 PRJNA193544_S_NODE_966_length_254_cov_9.724444_g951_i0 PRJNA193544 966 254 9.724444 24.70008776 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 425 1.18e-114   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g951 i0 98.745 0.940944881889764 239 3 94 0 16 254 950 712 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 239 425 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
8019243 8019243 PRJNA193544_S_NODE_1387_length_219_cov_18504.005263_g1372_i0 PRJNA193544 1387 219 18504.005263 40523.77152597 Sopidub virus 3131684 Viruses Viruses 137 5.200000000000001e-28   NTclustered gi|2717323145|gb|PP173985.1| 3131684 g1372 i0 86.992 6.44748858447489 123 15 56 1 44 165 2262 2140 MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence blastn 1412 137 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Picobirnaviridae   Sopidub virus
8019282 8019282 PRJNA193544_S_NODE_527_length_311_cov_12600.489362_g512_i0 PRJNA193544 527 311 12600.489362 39187.52191582 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 448 3.169999999999999e-121   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g512 i0 95.683 0.893890675241158 278 12 89 0 1 278 2539 2816 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 278 448 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8019284 8019284 PRJNA193544_S_NODE_607_length_300_cov_11.859779_g592_i0 PRJNA193544 607 300 11.859779 35.579337 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 128 4.51e-25   NTclustered gi|2754691654|gb|PP872616.1| 3003959 g592 i0 74.671 2.02666666666667 304 70 100 7 1 300 6265 6565 MAG: Picornavirales sp. isolate TC-PLV-60 MR233-17E/328 genomic sequence blastn 608 128 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
9294000 9294000 PRJNA193544_S_NODE_748_length_281_cov_7.246032_g733_i0 PRJNA193544 748 281 7.246032 20.36134992 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 475 1.2999999999999999e-129   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g733 i0 97.153 1 281 8 100 0 1 281 4025 3745 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 281 475 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
10569950 10569950 PRJNA193544_S_NODE_1589_length_209_cov_4.355556_g1574_i0 PRJNA193544 1589 209 4.355556 9.10311204 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 370 4.45e-98   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g1574 i0 98.565 1 209 3 100 0 1 209 1912 1704 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 209 370 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
10569995 10569995 PRJNA193544_S_NODE_929_length_257_cov_16873.912281_g914_i0 PRJNA193544 929 257 16873.912281 43365.95456217 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 134 8.12e-27   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g914 i0 95.238 0.326848249027237 84 4 33 0 35 118 1003 920 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 84 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
13119677 13119677 PRJNA193544_S_NODE_2551_length_173_cov_6.041667_g2536_i0 PRJNA193544 2551 173 6.041667 10.45208391 Marnaviridae sp. 2715102 Viruses Viruses 58.4 3.12e-4   NTclustered gi|2196309042|gb|MZ679248.1| 2715102 g2536 i0 81.429 0.404624277456647 70 13 40 0 77 146 1216 1147 MAG: Marnaviridae sp. isolate R65-k141_733993 hypothetical protein gene, complete cds blastn 70 58.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
14395000 14395000 PRJNA193544_S_NODE_52_length_553_cov_11.267176_g43_i0 PRJNA193544 52 553 11.267176 62.30748328 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 941 0   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g43 i0 97.798 0.985533453887884 545 12 99 0 1 545 7353 7897 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 545 941 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
15668671 15668671 PRJNA193544_S_NODE_153_length_423_cov_9.251269_g139_i0 PRJNA193544 153 423 9.251269 39.13286787 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 754 0   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g139 i0 98.818 1.77777777777778 423 5 100 0 1 423 451 873 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 752 754 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
16943180 16943180 PRJNA193544_S_NODE_414_length_334_cov_8.681967_g399_i0 PRJNA193544 414 334 8.681967 28.99776978 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 573 5.43e-159   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g399 i0 97.885 0.991017964071856 331 7 99 0 1 331 4729 5059 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 331 573 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
16943194 16943194 PRJNA193544_S_NODE_914_length_260_cov_14.709957_g899_i0 PRJNA193544 914 260 14.709957 38.2458882 Marnaviridae sp. 2715102 Viruses Viruses 230 1.0199999999999998e-55   NTclustered gi|2196309006|gb|MZ679221.1| 2715102 g899 i0 84 0.961538461538462 250 29 95 11 15 260 273 31 MAG: Marnaviridae sp. isolate 373R-k141_428865 hypothetical protein gene, complete cds blastn 250 230 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
19491879 19491879 PRJNA193544_S_NODE_2016_length_191_cov_26.753086_g2001_i0 PRJNA193544 2016 191 26.753086 51.09839426 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 315 1.9e-81   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g2001 i0 99.422 0.905759162303665 173 1 91 0 1 173 7011 7183 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 173 315 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
19491882 19491882 PRJNA193544_S_NODE_2136_length_186_cov_4.375796_g2121_i0 PRJNA193544 2136 186 4.375796 8.13898056 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 305 1.11e-78   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g2121 i0 96.237 1 186 7 100 0 1 186 5221 5036 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 186 305 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
19491902 19491902 PRJNA193544_S_NODE_496_length_317_cov_41.003472_g481_i0 PRJNA193544 496 317 41.003472 129.98100624 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 507 5.27e-139   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g481 i0 97.945 0.921135646687697 292 6 92 0 1 292 5580 5871 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 292 507 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
19491905 19491905 PRJNA193544_S_NODE_616_length_299_cov_10.877778_g601_i0 PRJNA193544 616 299 10.877778 32.52455622 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 451 2.35e-122   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g601 i0 95.714 0.936454849498328 280 12 94 0 20 299 5479 5200 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 280 451 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
20767434 20767434 PRJNA193544_S_NODE_337_length_351_cov_15.027950_g322_i0 PRJNA193544 337 351 15.02795 52.7481045 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 588 2.0399999999999998e-163   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g322 i0 96.866 1 351 11 100 0 1 351 4382 4732 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 351 588 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22042497 22042497 PRJNA193544_S_NODE_1398_length_219_cov_7.305263_g1383_i0 PRJNA193544 1398 219 7.305263 15.99852597 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 385 1.68e-102   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g1383 i0 99.526 1.92694063926941 211 1 96 0 9 219 1422 1212 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 422 385 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
22042542 22042542 PRJNA193544_S_NODE_58_length_537_cov_9.541339_g49_i0 PRJNA193544 58 537 9.541339 51.23699043 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 942 0   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g49 i0 98.324 1 537 9 100 0 1 537 1560 1024 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 537 942 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22042551 22042551 PRJNA193544_S_NODE_878_length_263_cov_19.572650_g863_i0 PRJNA193544 878 263 19.57265 51.4760695 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 484 1.9999999999999993e-132   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g863 i0 100 0.996197718631179 262 0 99 0 2 263 6789 6528 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 262 484 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23317980 23317980 PRJNA193544_S_NODE_1399_length_219_cov_5.678947_g1384_i0 PRJNA193544 1399 219 5.678947 12.43689393 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 366 6.09e-97   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g1384 i0 96.804 1 219 7 100 0 1 219 4128 4346 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 219 366 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23317989 23317989 PRJNA193544_S_NODE_1639_length_206_cov_7.389831_g1624_i0 PRJNA193544 1639 206 7.389831 15.22305186 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 377 2.62e-100   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g1624 i0 100 0.990291262135922 204 0 99 0 3 206 6536 6333 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 204 377 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23318016 23318016 PRJNA193544_S_NODE_3439_length_151_cov_6.795082_g3424_i0 PRJNA193544 3439 151 6.795082 10.26057382 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 246 5.27e-61   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g3424 i0 96.026 1 151 6 100 0 1 151 6129 6279 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 151 246 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23318019 23318019 PRJNA193544_S_NODE_39_length_606_cov_11.093588_g31_i0 PRJNA193544 39 606 11.093588 67.22714328 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 466 1.8099999999999998e-126   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g31 i0 99.222 0.848184818481848 257 2 42 0 1 257 1400 1656 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 514 466 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
23318024 23318024 PRJNA193544_S_NODE_559_length_306_cov_15.216606_g544_i0 PRJNA193544 559 306 15.216606 46.56281436 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 555 1.7799999999999996e-153   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g544 i0 99.346 1 306 2 100 0 1 306 1937 2242 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 306 555 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);;