contig_metadata
10 rows where bioproject = "PRJNA1074408" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 190997 | 190997 | PRJNA1074408_S_NODE_2401_length_295_cov_6.571429_g2271_i0 | PRJNA1074408 | 2401 | 295 | 6.571429 | 19.38571555 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g2271 | i0 | 100 | 0.196610169491525 | 30 | 0 | 10 | 0 | 266 | 295 | 35 | 6 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 1465576 | 1465576 | PRJNA1074408_S_NODE_1242_length_404_cov_7.454294_g1112_i0 | PRJNA1074408 | 1242 | 404 | 7.454294 | 30.11534776 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 652 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1112 | i0 | 95.771 | 0.995049504950495 | 402 | 17 | 99 | 0 | 1 | 402 | 6654 | 7055 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 402 | 652 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 4017544 | 4017544 | PRJNA1074408_S_NODE_8684_length_160_cov_1.230769_g8554_i0 | PRJNA1074408 | 8684 | 160 | 1.230769 | 1.9692304 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 263 | 5.629999999999999e-66 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8554 | i0 | 96.25 | 1 | 160 | 6 | 100 | 0 | 1 | 160 | 2284 | 2443 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 160 | 263 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 11669667 | 11669667 | PRJNA1074408_S_NODE_5530_length_197_cov_1.870130_g5400_i0 | PRJNA1074408 | 5530 | 197 | 1.87013 | 3.6841561 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 359 | 8.98e-95 | NTclustered | gi|2057146744|tpg|BK058424.1| | 2832643 | g5400 | i0 | 99.492 | 4.57868020304569 | 197 | 1 | 100 | 0 | 1 | 197 | 1390 | 1586 | MAG TPA_asm: Caudoviricetes sp. isolate ctU2V15, partial genome | blastn | 902 | 359 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16767926 | 16767926 | PRJNA1074408_S_NODE_1854_length_333_cov_3.582759_g1724_i0 | PRJNA1074408 | 1854 | 333 | 3.582759 | 11.93058747 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 582 | 8.999999999999997e-162 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g1724 | i0 | 98.198 | 4.54054054054054 | 333 | 6 | 100 | 0 | 1 | 333 | 7840 | 8172 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1512 | 582 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 16767949 | 16767949 | PRJNA1074408_S_NODE_7454_length_172_cov_1.116279_g7324_i0 | PRJNA1074408 | 7454 | 172 | 1.116279 | 1.91999988 | Pestivirus bovis | 3052619 | Viruses | Viruses | 196 | 6.3e-46 | NTclustered | gi|2127986378|gb|MW054934.1| | 11099 | g7324 | i0 | 87.647 | 9.73255813953488 | 170 | 19 | 98 | 2 | 1 | 169 | 811 | 643 | Bovine viral diarrhea virus 1 strain LA/87/05, complete genome | blastn | 1674 | 196 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18042735 | 18042735 | PRJNA1074408_S_NODE_9775_length_152_cov_0.880734_g9645_i0 | PRJNA1074408 | 9775 | 152 | 0.880734 | 1.33871568 | Chronazanb virus | 3129852 | Viruses | Viruses | 119 | 1.21e-22 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g9645 | i0 | 94.737 | 7.72368421052632 | 76 | 4 | 50 | 0 | 77 | 152 | 4398 | 4473 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 1174 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 18868102 | 18868102 | PRJNA1074408_S_NODE_2395_length_295_cov_1009.746032_g2265_i0 | PRJNA1074408 | 2395 | 295 | 1009.746032 | 2978.7507944 | root | 1 | Root_unresolved | Root_unresolved | 122 | 2.06e-23 | NTclustered | gi|1893169343|gb|MT364888.1| | 10310 | g2265 | i0 | 94.937 | 24.335593220339 | 79 | 2 | 27 | 2 | 11 | 89 | 4 | 80 | Human alphaherpesvirus 2, partial genome | blastn | 7179 | 122 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 21867795 | 21867795 | PRJNA1074408_S_NODE_5178_length_203_cov_1.768750_g5048_i0 | PRJNA1074408 | 5178 | 203 | 1.76875 | 3.5905625 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 279 | 7.45e-71 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g5048 | i0 | 91.542 | 0.990147783251232 | 201 | 16 | 99 | 1 | 1 | 201 | 6766 | 6965 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 201 | 279 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 30762625 | 30762625 | PRJNA1074408_S_NODE_6534_length_182_cov_1.726619_g6404_i0 | PRJNA1074408 | 6534 | 182 | 1.726619 | 3.14244658 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 49.3 | 1.55e-5 | NR | QCF47486.1 | 1543320 | g6404 | i0 | 56.9 | 1.68131868131868 | 51 | 21 | 84.1 | 1 | 180 | 28 | 45 | 94 | QCF47486.1 putative RNA-dependent DNA polymerase, partial [Erythrocytic necrosis virus] | diamond | 306 | 49.7 | 0.991951710261569 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus |
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);;