contig_metadata
13 rows where bioproject = "PRJDB14274" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8580 | 8580 | PRJDB14274_S_NODE_6901_length_241_cov_1.233333_g6823_i0 | PRJDB14274 | 6901 | 241 | 1.233333 | 2.97233253 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 351 | 1.91e-92 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g6823 | i0 | 92.946 | 1 | 241 | 17 | 100 | 0 | 1 | 241 | 6666 | 6426 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 241 | 351 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8590 | 8590 | PRJDB14274_S_NODE_8801_length_214_cov_1.248366_g8723_i0 | PRJDB14274 | 8801 | 214 | 1.248366 | 2.67150324 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 396 | 7.559999999999996e-106 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g8723 | i0 | 100 | 1.98598130841122 | 214 | 0 | 100 | 0 | 1 | 214 | 5323 | 5110 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 425 | 396 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 1282782 | 1282782 | PRJDB14274_S_NODE_2102_length_421_cov_1.500000_g2024_i0 | PRJDB14274 | 2102 | 421 | 1.5 | 6.315 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 91.6 | 8.59e-14 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g2024 | i0 | 93.651 | 17.2256532066508 | 63 | 1 | 15 | 3 | 360 | 421 | 121 | 61 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 7252 | 91.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 1282801 | 1282801 | PRJDB14274_S_NODE_4302_length_297_cov_156.110169_g4224_i0 | PRJDB14274 | 4302 | 297 | 156.110169 | 463.64720193 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 91.6 | 5.85e-14 | NTclustered | gi|2560502367|emb|OY629453.1| | 2697049 | g4224 | i0 | 95 | 23.7070707070707 | 60 | 0 | 20 | 3 | 1 | 58 | 5976 | 5918 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 7041 | 91.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2558415 | 2558415 | PRJDB14274_S_NODE_4083_length_305_cov_1.331967_g4005_i0 | PRJDB14274 | 4083 | 305 | 1.331967 | 4.06249935 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 536 | 6.439999999999998e-148 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g4005 | i0 | 98.361 | 1 | 305 | 5 | 100 | 0 | 1 | 305 | 6451 | 6147 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 305 | 536 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15310668 | 15310668 | PRJDB14274_S_NODE_9733_length_206_cov_0.896552_g9655_i0 | PRJDB14274 | 9733 | 206 | 0.896552 | 1.84689712 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 326 | 9.61e-85 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g9655 | i0 | 95.567 | 1.97087378640777 | 203 | 9 | 99 | 0 | 1 | 203 | 5004 | 4802 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 406 | 326 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 20409171 | 20409171 | PRJDB14274_S_NODE_4777_length_284_cov_1.062780_g4699_i0 | PRJDB14274 | 4777 | 284 | 1.06278 | 3.0182952 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 215 | 3.16e-51 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g4699 | i0 | 92.105 | 0.535211267605634 | 152 | 12 | 54 | 0 | 133 | 284 | 4915 | 5066 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 152 | 215 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 21685125 | 21685125 | PRJDB14274_S_NODE_3078_length_348_cov_2.567944_g3000_i0 | PRJDB14274 | 3078 | 348 | 2.567944 | 8.93644512 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 604 | 2.0199999999999992e-168 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3000 | i0 | 97.989 | 1 | 348 | 7 | 100 | 0 | 1 | 348 | 6767 | 6420 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 348 | 604 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 21685139 | 21685139 | PRJDB14274_S_NODE_4998_length_278_cov_1.838710_g4920_i0 | PRJDB14274 | 4998 | 278 | 1.83871 | 5.1116138 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 420 | 6.09e-113 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g4920 | i0 | 93.885 | 1 | 278 | 17 | 100 | 0 | 1 | 278 | 6174 | 6451 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 278 | 420 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 27759320 | 27759320 | PRJDB14274_S_NODE_5984_length_257_cov_0.913265_g5906_i0 | PRJDB14274 | 5984 | 257 | 0.913265 | 2.34709105 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 158 | 1.23e-42 | NR | XDJ26655.1 | 1530251 | g5906 | i0 | 95.3 | 0.992217898832685 | 85 | 4 | 99.2 | 0 | 1 | 255 | 533 | 617 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 255 | 158 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 29148650 | 29148650 | PRJDB14274_S_NODE_3389_length_333_cov_1.639706_g3311_i0 | PRJDB14274 | 3389 | 333 | 1.639706 | 5.46022098 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 216 | 2.99e-67 | NR | XDJ26656.1 | 1530251 | g3311 | i0 | 95.5 | 0.990990990990991 | 110 | 5 | 99.1 | 0 | 2 | 331 | 45 | 154 | XDJ26656.1 capsid protein [Picornaviridae sp.] | diamond | 330 | 216 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31517855 | 31517855 | PRJDB14274_S_NODE_1896_length_442_cov_1.472441_g1818_i0 | PRJDB14274 | 1896 | 442 | 1.4724410000000001 | 6.50818922 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 274 | 2.8699999999999998e-89 | NR | XDJ26656.1 | 1530251 | g1818 | i0 | 91.2 | 0.997737556561086 | 147 | 13 | 99.8 | 0 | 442 | 2 | 154 | 300 | XDJ26656.1 capsid protein [Picornaviridae sp.] | diamond | 441 | 274 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 31738950 | 31738950 | PRJDB14274_S_NODE_5497_length_267_cov_0.902913_g5419_i0 | PRJDB14274 | 5497 | 267 | 0.902913 | 2.41077771 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 175 | 1.6399999999999998e-48 | NR | XDJ26655.1 | 1530251 | g5419 | i0 | 93.2 | 0.98876404494382 | 88 | 6 | 98.9 | 0 | 2 | 265 | 1573 | 1660 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 264 | 175 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. |
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);;