contig_metadata
13 rows where bioproject = "PRJNA854078" and tax_phylum = "Pisuviricota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2117144 | 2117144 | PRJNA854078_P_NODE_82_length_2978_cov_6.330465_g36_i2 | PRJNA854078 | 82 | 2978 | 6.330465 | 188.5212477 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 881 | 1.94e-290 | NR | AVM87439.1 | 3063761 | g36 | i2 | 45.5 | 1.06380120886501 | 1056 | 457 | 99.8 | 12 | 2975 | 3 | 528 | 1529 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 3168 | 881 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 7219877 | 7219877 | PRJNA854078_P_NODE_266_length_1779_cov_2.700469_g208_i0 | PRJNA854078 | 266 | 1779 | 2.700469 | 48.04134351 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 708 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g208 | i0 | 95.1 | 0.594154019111861 | 449 | 22 | 59 | 0 | 1222 | 1670 | 2100 | 2548 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1057 | 708 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 9769772 | 9769772 | PRJNA854078_P_NODE_48_length_3522_cov_12.359524_g36_i0 | PRJNA854078 | 48 | 3522 | 12.359524 | 435.30243528 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2881 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g36 | i0 | 95.85 | 0.856331629755821 | 1783 | 69 | 86 | 5 | 1726 | 3506 | 5329 | 7108 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 3016 | 2881 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 11045374 | 11045374 | PRJNA854078_P_NODE_329_length_1603_cov_2.347712_g257_i0 | PRJNA854078 | 329 | 1603 | 2.347712 | 37.63382336 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 650 | 1.969999999999999e-210 | NR | AVM87439.1 | 3063761 | g257 | i0 | 61.6 | 0.963817841547099 | 515 | 194 | 95.6 | 2 | 69 | 1601 | 1 | 515 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 1545 | 650 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 11045382 | 11045382 | PRJNA854078_P_NODE_49_length_3490_cov_12.729002_g36_i1 | PRJNA854078 | 49 | 3490 | 12.729002 | 444.2421698 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2580 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g36 | i1 | 93.039 | 0.859598853868195 | 1767 | 118 | 86 | 5 | 1 | 1765 | 7092 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 3000 | 2580 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 11045419 | 11045419 | PRJNA854078_P_NODE_929_length_985_cov_2.825658_g769_i0 | PRJNA854078 | 929 | 985 | 2.825658 | 27.8327313 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1090 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g769 | i0 | 97.492 | 0.712690355329949 | 638 | 16 | 71 | 0 | 197 | 834 | 639 | 2 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 702 | 1090 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 23793900 | 23793900 | PRJNA854078_P_NODE_159_length_2313_cov_7.856696_g36_i3 | PRJNA854078 | 159 | 2313 | 7.856696 | 181.72537848 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 876 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g36 | i3 | 97.647 | 0.412019022913965 | 510 | 12 | 41 | 0 | 255 | 764 | 4704 | 4195 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 953 | 876 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 26999773 | 26999773 | PRJNA854078_P_NODE_3582_length_503_cov_1.493023_g3370_i0 | PRJNA854078 | 3582 | 503 | 1.493023 | 7.50990569 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 47 | 0.0169 | NR | UCS96340.1 | RQ13 | g3370 | i0 | 38.4 | 2.43936381709742 | 73 | 43 | 42.3 | 1 | 291 | 503 | 1203 | 1275 | UCS96340.1 MAG: polyprotein, partial [Picornaviridae sp.] | diamond | 1227 | 47.4 | 0.991561181434599 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish jaw picornavirus | |||
| 30181364 | 30181364 | PRJNA854078_P_NODE_1632_length_749_cov_4.998521_g261_i1 | PRJNA854078 | 1632 | 749 | 4.998521 | 37.43892229 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 150 | 3.909999999999999e-37 | NR | QKE55033.1 | RQ13 | g261 | i1 | 47.9 | 0.660881174899867 | 165 | 84 | 65.3 | 2 | 5 | 493 | 2152 | 2316 | QKE55033.1 MAG: polyprotein [Picornaviridae sp.] | diamond | 495 | 150 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish jaw picornavirus | |||
| 31192101 | 31192101 | PRJNA854078_P_NODE_335_length_1586_cov_4.488434_g261_i0 | PRJNA854078 | 335 | 1586 | 4.488434 | 71.18656324 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 426 | 9.12e-129 | NR | XBH24011.1 | RQ13 | g261 | i0 | 50.8 | 2.52522068095839 | 445 | 209 | 83.4 | 8 | 1582 | 260 | 1947 | 2385 | XBH24011.1 MAG: polyprotein [Coleura bat picornavirus] | diamond | 4005 | 426 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 31232089 | 31232089 | PRJNA854078_P_NODE_3535_length_506_cov_2.404157_g3323_i0 | PRJNA854078 | 3535 | 506 | 2.404157 | 12.16503442 | Megrivirus | 1330069 | Viruses | Viruses | 52.8 | 1.82e-4 | NR | YP_009552756.1 | 2218594 | g3323 | i0 | 36.9 | 1.1798418972332 | 103 | 60 | 58.7 | 3 | 305 | 9 | 1703 | 1804 | YP_009552756.1 polyprotein [Rhimavirus A] | diamond | 597 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Rhimavirus A | |||
| 31888232 | 31888232 | PRJNA854078_P_NODE_3357_length_519_cov_2.421525_g3145_i0 | PRJNA854078 | 3357 | 519 | 2.421525 | 12.56771475 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 112 | 5.25e-25 | NR | WZI33259.1 | RQ13 | g3145 | i0 | 45.7 | 2.45664739884393 | 127 | 69 | 73.4 | 0 | 518 | 138 | 440 | 566 | WZI33259.1 MAG: polyprotein [Crocidura lasiura picornavirus 2] | diamond | 1275 | 112 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Zebrafish jaw picornavirus | ||||
| 32394655 | 32394655 | PRJNA854078_P_NODE_1179_length_879_cov_1.101737_g1005_i0 | PRJNA854078 | 1179 | 879 | 1.101737 | 9.68426823 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 80.9 | 7.5e-13 | NR | XEQ84337.1 | RQ13 | g1005 | i0 | 26.2 | 2.08532423208191 | 301 | 185 | 93.5 | 7 | 6 | 827 | 165 | 455 | XEQ84337.1 polyprotein, partial [Mink kobuvirus] | diamond | 1833 | 80.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus |
Advanced export
JSON shape: default, array, newline-delimited
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);;