contig_metadata
21 rows where bioproject = "PRJNA287283" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646942 | 1646942 | PRJNA287283_P_NODE_1262_length_633_cov_1.846552_g1056_i0 | PRJNA287283 | 1262 | 633 | 1.846552 | 11.68867416 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 224 | 9.38e-64 | NR | AVM87439.1 | 3063761 | g1056 | i0 | 51.9 | 1.01421800947867 | 214 | 96 | 98.1 | 1 | 632 | 12 | 948 | 1161 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 642 | 224 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 5475606 | 5475606 | PRJNA287283_P_NODE_5785_length_242_cov_1.439153_g5561_i0 | PRJNA287283 | 5785 | 242 | 1.439153 | 3.48275026 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 92.8 | 8.98e-20 | NR | AVM87439.1 | 3063761 | g5561 | i0 | 59.3 | 1.00413223140496 | 81 | 30 | 96.7 | 1 | 8 | 241 | 440 | 520 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 243 | 92.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 6749886 | 6749886 | PRJNA287283_P_NODE_646_length_910_cov_1.495916_g491_i0 | PRJNA287283 | 646 | 910 | 1.495916 | 13.6128356 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1026 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g491 | i0 | 95.755 | 0.698901098901099 | 636 | 27 | 70 | 0 | 134 | 769 | 639 | 4 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 636 | 1026 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 6749888 | 6749888 | PRJNA287283_P_NODE_726_length_857_cov_2.381841_g562_i0 | PRJNA287283 | 726 | 857 | 2.381841 | 20.41237737 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 396 | 3.46e-105 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g562 | i0 | 92.143 | 0.568261376896149 | 280 | 22 | 57 | 0 | 346 | 625 | 5194 | 4915 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 487 | 396 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8025465 | 8025465 | PRJNA287283_P_NODE_3927_length_319_cov_2.710526_g3703_i0 | PRJNA287283 | 3927 | 319 | 2.710526 | 8.64657794 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 398 | 3.3299999999999993e-106 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3703 | i0 | 94.882 | 0.796238244514107 | 254 | 13 | 80 | 0 | 66 | 319 | 2543 | 2290 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 254 | 398 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 9300257 | 9300257 | PRJNA287283_P_NODE_6348_length_226_cov_1.913295_g6124_i0 | PRJNA287283 | 6348 | 226 | 1.913295 | 4.3240467 | Biavirus raunefjordenense | 3059777 | Viruses | Viruses | 143 | 1.16e-29 | NTclustered | gi|2500387999|ref|NC_077221.1| | 1499987 | g6124 | i0 | 79.227 | 5.3141592920354 | 207 | 41 | 91 | 2 | 21 | 226 | 944132 | 943927 | Prymnesium kappa virus genome assembly, chromosome: 1 | blastn | 1201 | 143 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Schizomimiviridae | Biavirus | Biavirus raunefjordenense | ||
| 9300260 | 9300260 | PRJNA287283_P_NODE_708_length_867_cov_3.098280_g545_i0 | PRJNA287283 | 708 | 867 | 3.09828 | 26.8620876 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1206 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g545 | i0 | 91.705 | 1.00115340253749 | 868 | 70 | 100 | 2 | 1 | 867 | 5951 | 6817 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 868 | 1206 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13126019 | 13126019 | PRJNA287283_P_NODE_1731_length_523_cov_3.670213_g1514_i0 | PRJNA287283 | 1731 | 523 | 3.670213 | 19.19521399 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 315 | 5.92e-81 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1514 | i0 | 90.987 | 0.445506692160612 | 233 | 21 | 45 | 0 | 288 | 520 | 4195 | 4427 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 233 | 315 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 14401167 | 14401167 | PRJNA287283_P_NODE_3372_length_348_cov_1.067797_g3148_i0 | PRJNA287283 | 3372 | 348 | 1.067797 | 3.71593356 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 90.5 | 2.44e-18 | NR | WLN26256.1 | 3065075 | g3148 | i0 | 51.7 | 0.75 | 87 | 42 | 75 | 0 | 64 | 324 | 229 | 315 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 261 | 90.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 15674908 | 15674908 | PRJNA287283_P_NODE_4273_length_303_cov_1.344000_g4049_i0 | PRJNA287283 | 4273 | 303 | 1.344 | 4.07232 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 179 | 9.16e-50 | NR | BCT22673.1 | RQ14 | g4049 | i0 | 79.2 | 1 | 101 | 21 | 100 | 0 | 1 | 303 | 1060 | 1160 | BCT22673.1 DNA-dependent RNA polymerase subunit rpo132 [Carp edema virus] | diamond | 303 | 179 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 15674910 | 15674910 | PRJNA287283_P_NODE_4693_length_283_cov_2.256522_g4469_i0 | PRJNA287283 | 4693 | 283 | 2.256522 | 6.38595726 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 424 | 4.8e-114 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g4469 | i0 | 93.64 | 1 | 283 | 18 | 100 | 0 | 1 | 283 | 5537 | 5819 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 283 | 424 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 27105571 | 27105571 | PRJNA287283_P_NODE_2442_length_421_cov_1.521739_g2219_i0 | PRJNA287283 | 2442 | 421 | 1.521739 | 6.40652119 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 79.7 | 4.77e-15 | NR | BCT22683.1 | RQ14 | g2219 | i0 | 33.3 | 0.961995249406176 | 135 | 88 | 94.8 | 1 | 412 | 14 | 29 | 163 | BCT22683.1 hypothetical protein [Carp edema virus] | diamond | 405 | 79.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27327077 | 27327077 | PRJNA287283_P_NODE_8863_length_181_cov_1.312500_g8639_i0 | PRJNA287283 | 8863 | 181 | 1.3125 | 2.375625 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 54.3 | 1.37e-6 | NR | BCT22635.1 | RQ14 | g8639 | i0 | 64.7 | 0.56353591160221 | 34 | 12 | 56.4 | 0 | 103 | 2 | 181 | 214 | BCT22635.1 NTPase [Carp edema virus] | diamond | 102 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27422016 | 27422016 | PRJNA287283_P_NODE_4803_length_279_cov_0.991150_g4579_i0 | PRJNA287283 | 4803 | 279 | 0.99115 | 2.7653085 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 57.8 | 2.41e-7 | NR | BCT22575.1 | RQ14 | g4579 | i0 | 33 | 0.946236559139785 | 88 | 57 | 94.6 | 1 | 266 | 3 | 215 | 300 | BCT22575.1 thymidine kinase [Carp edema virus] | diamond | 264 | 57.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 27516521 | 27516521 | PRJNA287283_P_NODE_483_length_1055_cov_4.129741_g361_i0 | PRJNA287283 | 483 | 1055 | 4.129741 | 43.56876755 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 181 | 3.27e-50 | NR | BCT22626.1 | RQ14 | g361 | i0 | 36.4 | 0.890047393364929 | 313 | 182 | 85 | 6 | 965 | 69 | 3 | 312 | BCT22626.1 putative DNA-binding virion core protein [Carp edema virus] | diamond | 939 | 181 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 28179326 | 28179326 | PRJNA287283_P_NODE_5266_length_260_cov_1.251208_g5042_i0 | PRJNA287283 | 5266 | 260 | 1.251208 | 3.2531408 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 105 | 5.4499999999999996e-24 | NR | AVM87439.1 | 3063761 | g5042 | i0 | 51.2 | 0.992307692307692 | 86 | 42 | 99.2 | 0 | 260 | 3 | 299 | 384 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 258 | 105 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 28779341 | 28779341 | PRJNA287283_P_NODE_9007_length_181_cov_0.875000_g8783_i0 | PRJNA287283 | 9007 | 181 | 0.875 | 1.58375 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 95.1 | 5.6200000000000006e-21 | NR | BCT22721.1 | RQ14 | g8783 | i0 | 76.3 | 0.977900552486188 | 59 | 14 | 97.8 | 0 | 179 | 3 | 914 | 972 | BCT22721.1 RNA polymerase subunit RPO147 [Carp edema virus] | diamond | 177 | 95.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30642722 | 30642722 | PRJNA287283_P_NODE_1813_length_504_cov_3.155211_g1594_i0 | PRJNA287283 | 1813 | 504 | 3.155211 | 15.90226344 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 68.9 | 9.44e-11 | NR | BCT22707.1 | RQ14 | g1594 | i0 | 30.5 | 0.976190476190476 | 164 | 93 | 94.6 | 7 | 20 | 496 | 1 | 148 | BCT22707.1 hypothetical protein [Carp edema virus] | diamond | 492 | 68.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 30990570 | 30990570 | PRJNA287283_P_NODE_5654_length_246_cov_1.160622_g5430_i0 | PRJNA287283 | 5654 | 246 | 1.160622 | 2.85513012 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 105 | 6.57e-25 | NR | BCT22728.1 | RQ14 | g5430 | i0 | 61.7 | 0.98780487804878 | 81 | 31 | 98.8 | 0 | 4 | 246 | 14 | 94 | BCT22728.1 DNA topoisomerase I [Carp edema virus] | diamond | 243 | 105 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 31085230 | 31085230 | PRJNA287283_P_NODE_8175_length_186_cov_1.263158_g7951_i0 | PRJNA287283 | 8175 | 186 | 1.263158 | 2.34947388 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 90.9 | 1.87e-19 | NR | BCT22616.1 | RQ14 | g7951 | i0 | 70 | 0.967741935483871 | 60 | 18 | 96.8 | 0 | 184 | 5 | 322 | 381 | BCT22616.1 poly(A)-polymerase catalytic subunit PAPL [Carp edema virus] | diamond | 180 | 90.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus | |||
| 32634598 | 32634598 | PRJNA287283_P_NODE_8240_length_185_cov_1.272727_g8016_i0 | PRJNA287283 | 8240 | 185 | 1.272727 | 2.35454495 | Zebrafish jaw poxvirus | RQ14 | Viruses | Viruses | 78.2 | 5.52e-15 | NR | BCT22635.1 | RQ14 | g8016 | i0 | 58.3 | 0.972972972972973 | 60 | 25 | 97.3 | 0 | 185 | 6 | 723 | 782 | BCT22635.1 NTPase [Carp edema virus] | diamond | 180 | 78.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Zebrafish jaw poxvirus |
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);;