contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA407368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 415027 | 415027 | PRJNA407368_S_NODE_3681_length_305_cov_3.996377_g3579_i0 | PRJNA407368 | 3681 | 305 | 3.996377 | 12.18894985 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 553 | 6.39e-153 | NTclustered | gi|226235018|dbj|AB355139.1| | 12253 | g3579 | i0 | 99.344 | 99.9540983606557 | 305 | 2 | 100 | 0 | 1 | 305 | 4623 | 4319 | Tomato mosaic virus genomic RNA, complete genome, strain: L11Y | blastn | 30486 | 553 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 415041 | 415041 | PRJNA407368_S_NODE_4301_length_276_cov_7.919028_g4199_i0 | PRJNA407368 | 4301 | 276 | 7.919028 | 21.85651728 | Chrocagosk virus | 3129397 | Viruses | Viruses | 359 | 1.34e-94 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g4199 | i0 | 92.771 | 22.0072463768116 | 249 | 17 | 90 | 1 | 28 | 276 | 1 | 248 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 6074 | 359 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 1081742 | 1081742 | PRJNA407368_S_NODE_1921_length_448_cov_3.665871_g1821_i0 | PRJNA407368 | 1921 | 448 | 3.665871 | 16.42310208 | Tobamovirus | 12234 | Viruses | Viruses | 817 | 0 | NTclustered | gi|4377853|gb|AF062519.1|AF062519 | 12242 | g1821 | i0 | 99.554 | 100 | 448 | 2 | 100 | 0 | 1 | 448 | 889 | 442 | Tobacco mosaic virus movement protein and coat protein genes, complete cds | blastn | 44800 | 822 | 0.993917274939173 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 1689957 | 1689957 | PRJNA407368_S_NODE_5442_length_234_cov_1586.517073_g5340_i0 | PRJNA407368 | 5442 | 234 | 1586.517073 | 3712.44995082 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 121 | 5.66e-23 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g5340 | i0 | 94.872 | 36.3760683760684 | 78 | 2 | 32 | 2 | 19 | 94 | 42 | 119 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8512 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2965901 | 2965901 | PRJNA407368_S_NODE_7543_length_188_cov_3.886792_g7441_i0 | PRJNA407368 | 7543 | 188 | 3.886792 | 7.30716896 | Bacteriophage sp. | 38018 | Viruses | Viruses | 348 | 1.84e-91 | NTclustered | gi|2059766425|tpg|BK039054.1| | 38018 | g7441 | i0 | 100 | 564.537234042553 | 188 | 0 | 100 | 0 | 1 | 188 | 16929 | 17116 | MAG TPA_asm: Bacteriophage sp. isolate cttqH15, partial genome | blastn | 106133 | 348 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 2965909 | 2965909 | PRJNA407368_S_NODE_7803_length_184_cov_3.477419_g7701_i0 | PRJNA407368 | 7803 | 184 | 3.477419 | 6.39845096 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 335 | 1.3899999999999996e-87 | NTclustered | gi|2906150747|gb|PQ646533.1| | 2832643 | g7701 | i0 | 99.457 | 1 | 184 | 1 | 100 | 0 | 1 | 184 | 7214 | 7397 | MAG: Caudoviricetes sp. isolate k127_4397921 genomic sequence | blastn | 184 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4909691 | 4909691 | PRJNA407368_S_NODE_5584_length_230_cov_3.194030_g5482_i0 | PRJNA407368 | 5584 | 230 | 3.19403 | 7.346269 | Tobamovirus | 12234 | Viruses | Viruses | 420 | 4.89e-113 | NTclustered | gi|2085776112|gb|MZ388458.1| | 12253 | g5482 | i0 | 99.565 | 99.995652173913 | 230 | 1 | 100 | 0 | 1 | 230 | 4598 | 4827 | Tomato mosaic virus isolate ToMV-WF, complete genome | blastn | 22999 | 420 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 6792811 | 6792811 | PRJNA407368_S_NODE_4786_length_257_cov_3.061404_g4684_i0 | PRJNA407368 | 4786 | 257 | 3.061404 | 7.86780828 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 263 | 9.92e-66 | NTclustered | gi|2015372674|gb|MW046380.1| | 2794556 | g4684 | i0 | 94.675 | 0.929961089494163 | 169 | 9 | 92 | 0 | 21 | 189 | 681 | 513 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | blastn | 239 | 263 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | ||
| 8068344 | 8068344 | PRJNA407368_S_NODE_2067_length_429_cov_24.220000_g1966_i0 | PRJNA407368 | 2067 | 429 | 24.22 | 103.9038 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 538 | 2.6099999999999992e-148 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g1966 | i0 | 89.327 | 435.50582750582703 | 431 | 42 | 100 | 4 | 1 | 429 | 18219 | 17791 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 186832 | 538 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8068446 | 8068446 | PRJNA407368_S_NODE_667_length_786_cov_16.817701_g608_i0 | PRJNA407368 | 667 | 786 | 16.817701 | 132.18712986 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 907 | 0 | NTclustered | gi|2058043668|tpg|BK042394.1| | 2832643 | g608 | i0 | 100 | 1.01017811704835 | 491 | 0 | 100 | 0 | 1 | 491 | 109474 | 109964 | MAG TPA_asm: Caudoviricetes sp. isolate ctStP2, partial genome | blastn | 794 | 907 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9343343 | 9343343 | PRJNA407368_S_NODE_868_length_697_cov_8.908683_g799_i0 | PRJNA407368 | 868 | 697 | 8.908683 | 62.09352051 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 6.209999999999998e-82 | NTclustered | gi|2906148703|gb|PQ646410.1| | 2832643 | g799 | i0 | 81.205 | 1.03730272596844 | 415 | 61 | 100 | 13 | 290 | 697 | 24223 | 23819 | MAG: Caudoviricetes sp. isolate k127_2521799 genomic sequence | blastn | 723 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9343350 | 9343350 | PRJNA407368_S_NODE_8_length_5759_cov_10.239791_g6_i0 | PRJNA407368 | 8 | 5759 | 10.239791 | 589.70956369 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1042 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g6 | i0 | 96.226 | 0.553915610349019 | 636 | 24 | 55 | 0 | 2373 | 3008 | 639 | 4 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 3190 | 1042 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 10618952 | 10618952 | PRJNA407368_S_NODE_1569_length_502_cov_12.181818_g1475_i0 | PRJNA407368 | 1569 | 502 | 12.181818 | 61.15272636 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 375 | 2.5599999999999997e-99 | NTclustered | gi|2906145245|gb|PQ646172.1| | 2832643 | g1475 | i0 | 82.751 | 0.854581673306773 | 429 | 66 | 85 | 8 | 78 | 502 | 36573 | 36997 | MAG: Caudoviricetes sp. isolate k127_1850996 genomic sequence | blastn | 429 | 375 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10619098 | 10619098 | PRJNA407368_S_NODE_8189_length_178_cov_5.342282_g8087_i0 | PRJNA407368 | 8189 | 178 | 5.342282 | 9.50926196 | uncultured virus | 340016 | Viruses | Viruses | 189 | 1.1e-43 | NTclustered | gi|1219813320|gb|KU970679.1| | 340016 | g8087 | i0 | 87.273 | 0.926966292134832 | 165 | 21 | 93 | 0 | 11 | 175 | 211 | 375 | Uncultured virus SERC_Contig_351799 co-chaperonin GroES (groES) gene, complete cds | blastn | 165 | 189 | 1 | Viruses | uncultured virus | ||||||||
| 11893908 | 11893908 | PRJNA407368_S_NODE_3550_length_311_cov_5.946809_g3448_i0 | PRJNA407368 | 3550 | 311 | 5.946809 | 18.49457599 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.5 | 1.71e-14 | NTclustered | gi|2053082307|tpg|BK020121.1| | 2832643 | g3448 | i0 | 94.915 | 0.189710610932476 | 59 | 3 | 19 | 0 | 186 | 244 | 16006 | 15948 | MAG TPA_asm: Caudoviricetes sp. isolate ct1j32, partial genome | blastn | 59 | 93.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11893989 | 11893989 | PRJNA407368_S_NODE_7570_length_188_cov_2.509434_g7468_i0 | PRJNA407368 | 7570 | 188 | 2.509434 | 4.71773592 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 198 | 1.9599999999999998e-46 | NTclustered | gi|2914826573|gb|OR222318.1| | 2832643 | g7468 | i0 | 86.339 | 1.95744680851064 | 183 | 23 | 97 | 2 | 6 | 187 | 8389 | 8208 | MAG: Caudoviricetes sp. isolate MSP1085 genomic sequence | blastn | 368 | 198 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13168867 | 13168867 | PRJNA407368_S_NODE_5151_length_243_cov_1510.425234_g5049_i0 | PRJNA407368 | 5151 | 243 | 1510.425234 | 3670.3333186199998 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 121 | 5.92e-23 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g5049 | i0 | 94.872 | 34.559670781893 | 78 | 2 | 31 | 2 | 150 | 225 | 119 | 42 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8398 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14444032 | 14444032 | PRJNA407368_S_NODE_5352_length_237_cov_3.634615_g5250_i0 | PRJNA407368 | 5352 | 237 | 3.634615 | 8.61403755 | Lentivirus equinfane | 3418648 | Viruses | Viruses | 438 | 1.4e-118 | NTclustered | gi|9944516|gb|AF247394.1|AF247394 | 11665 | g5250 | i0 | 100 | 32.2489451476793 | 237 | 0 | 100 | 0 | 1 | 237 | 3091 | 2855 | Equine infectious anemia virus complete genome | blastn | 7643 | 438 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus equinfane | ||
| 15717852 | 15717852 | PRJNA407368_S_NODE_7673_length_186_cov_3.624204_g7571_i0 | PRJNA407368 | 7673 | 186 | 3.624204 | 6.74101944 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 344 | 2.34e-90 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g7571 | i0 | 100 | 1 | 186 | 0 | 100 | 0 | 1 | 186 | 629 | 444 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 186 | 344 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 15717879 | 15717879 | PRJNA407368_S_NODE_93_length_1983_cov_13.492323_g90_i0 | PRJNA407368 | 93 | 1983 | 13.492323 | 267.55276509 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2514 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g90 | i0 | 92.312 | 0.931921331316188 | 1769 | 132 | 93 | 4 | 1 | 1767 | 7095 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1848 | 2514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 16384126 | 16384126 | PRJNA407368_S_NODE_6973_length_199_cov_2.347059_g6871_i0 | PRJNA407368 | 6973 | 199 | 2.347059 | 4.67064741 | root | 1 | Root_unresolved | Root_unresolved | 252 | 1.59e-62 | NTclustered | gi|2914812517|gb|OR221846.1| | 2832643 | g6871 | i0 | 89.447 | 52.3668341708543 | 199 | 21 | 100 | 0 | 1 | 199 | 22414 | 22216 | MAG: Caudoviricetes sp. isolate MSP1164 genomic sequence | blastn | 10421 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19540924 | 19540924 | PRJNA407368_S_NODE_7436_length_190_cov_13.273292_g7334_i0 | PRJNA407368 | 7436 | 190 | 13.273292 | 25.2192548 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 158 | 3.36e-34 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g7334 | i0 | 81.675 | 495.268421052632 | 191 | 33 | 100 | 2 | 1 | 190 | 17968 | 18157 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 94101 | 158 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20816838 | 20816838 | PRJNA407368_S_NODE_9217_length_165_cov_3.705882_g9115_i0 | PRJNA407368 | 9217 | 165 | 3.705882 | 6.1147053 | Bacteriophage sp. | 38018 | Viruses | Viruses | 300 | 4.46e-77 | NTclustered | gi|2052967766|tpg|BK030349.1| | 38018 | g9115 | i0 | 99.394 | 14.0606060606061 | 165 | 1 | 100 | 0 | 1 | 165 | 58136 | 58300 | MAG TPA_asm: Bacteriophage sp. isolate cteMW17, partial genome | blastn | 2320 | 300 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 22091637 | 22091637 | PRJNA407368_S_NODE_7698_length_186_cov_2.382166_g7596_i0 | PRJNA407368 | 7698 | 186 | 2.382166 | 4.43082876 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 289 | 1.11e-73 | NTclustered | gi|2015372674|gb|MW046380.1| | 2794556 | g7596 | i0 | 94.624 | 1 | 186 | 10 | 100 | 0 | 1 | 186 | 469 | 284 | MAG: Psittacidae aveparvovirus isolate fmg67par043 genomic sequence, sequence | blastn | 186 | 289 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus |
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);;