contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA484127" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1723562 | 1723562 | PRJNA484127_P_NODE_8702_length_404_cov_1.552870_g8553_i0 | PRJNA484127 | 8702 | 404 | 1.55287 | 6.2735948 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 265 | 4.57e-66 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8553 | i0 | 89.855 | 0.512376237623762 | 207 | 19 | 51 | 2 | 199 | 404 | 5329 | 5534 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 207 | 265 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 2372798 | 2372798 | PRJNA484127_P_NODE_26442_length_264_cov_2.308901_g26293_i0 | PRJNA484127 | 26442 | 264 | 2.308901 | 6.09549864 | Orthorubulavirus | 2560195 | Viruses | Viruses | 488 | 1.5499999999999999e-133 | NTclustered | gi|1540352612|gb|MK117734.1| | 2560580 | g26293 | i0 | 100 | 97.9848484848485 | 264 | 0 | 100 | 0 | 1 | 264 | 774 | 511 | Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds | blastn | 25868 | 488 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2999318 | 2999318 | PRJNA484127_P_NODE_2923_length_640_cov_2.109347_g2781_i0 | PRJNA484127 | 2923 | 640 | 2.109347 | 13.4998208 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 867 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g2781 | i0 | 91.195 | 0.99375 | 636 | 55 | 99 | 1 | 5 | 640 | 7028 | 6394 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 636 | 867 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 2999320 | 2999320 | PRJNA484127_P_NODE_29303_length_254_cov_1.464088_g29154_i0 | PRJNA484127 | 29303 | 254 | 1.464088 | 3.71878352 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 414 | 2.5499999999999998e-111 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g29154 | i0 | 96.063 | 3 | 254 | 10 | 100 | 0 | 1 | 254 | 6587 | 6334 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 762 | 414 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 3648457 | 3648457 | PRJNA484127_P_NODE_39463_length_238_cov_2.715152_g39314_i0 | PRJNA484127 | 39463 | 238 | 2.715152 | 6.46206176 | Orthorubulavirus | 2560195 | Viruses | Viruses | 440 | 3.899999999999999e-119 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g39314 | i0 | 100 | 82.9915966386555 | 238 | 0 | 100 | 0 | 1 | 238 | 7967 | 7730 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 19752 | 440 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 3648459 | 3648459 | PRJNA484127_P_NODE_4023_length_558_cov_3.156701_g3878_i0 | PRJNA484127 | 4023 | 558 | 3.156701 | 17.61439158 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1031 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g3878 | i0 | 100 | 85.1057347670251 | 558 | 0 | 100 | 0 | 1 | 558 | 2481 | 3038 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 47489 | 1031 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6200395 | 6200395 | PRJNA484127_P_NODE_11025_length_368_cov_2.538983_g10876_i0 | PRJNA484127 | 11025 | 368 | 2.538983 | 9.34345744 | Orthorubulavirus | 2560195 | Viruses | Viruses | 673 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g10876 | i0 | 99.728 | 67.7472826086957 | 367 | 1 | 99 | 0 | 2 | 368 | 4381 | 4015 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 24931 | 673 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11300526 | 11300526 | PRJNA484127_P_NODE_21989_length_284_cov_1.985782_g21840_i0 | PRJNA484127 | 21989 | 284 | 1.985782 | 5.63962088 | Orthorubulavirus | 2560195 | Viruses | Viruses | 525 | 1.2899999999999994e-144 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g21840 | i0 | 100 | 68.9823943661972 | 284 | 0 | 100 | 0 | 1 | 284 | 3540 | 3823 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 19591 | 525 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11300531 | 11300531 | PRJNA484127_P_NODE_2529_length_681_cov_3.518092_g2390_i0 | PRJNA484127 | 2529 | 681 | 3.518092 | 23.95820652 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1258 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2390 | i0 | 100 | 70.5154185022026 | 681 | 0 | 100 | 0 | 1 | 681 | 1709 | 1029 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 48021 | 1258 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11300578 | 11300578 | PRJNA484127_P_NODE_6749_length_448_cov_1.434667_g6601_i0 | PRJNA484127 | 6749 | 448 | 1.434667 | 6.42730816 | Orthorubulavirus | 2560195 | Viruses | Viruses | 822 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g6601 | i0 | 99.777 | 81.9375 | 448 | 1 | 100 | 0 | 1 | 448 | 6549 | 6996 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 36708 | 822 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 11927054 | 11927054 | PRJNA484127_P_NODE_18710_length_302_cov_2.362445_g18561_i0 | PRJNA484127 | 18710 | 302 | 2.362445 | 7.1345839 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 309 | 1.5100000000000002e-79 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g18561 | i0 | 96.277 | 0.622516556291391 | 188 | 7 | 62 | 0 | 2 | 189 | 4517 | 4704 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 188 | 309 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 12576236 | 12576236 | PRJNA484127_P_NODE_10550_length_374_cov_5.511628_g10401_i0 | PRJNA484127 | 10550 | 374 | 5.511628 | 20.61348872 | Orthorubulavirus | 2560195 | Viruses | Viruses | 691 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g10401 | i0 | 100 | 80.9465240641711 | 374 | 0 | 100 | 0 | 1 | 374 | 1802 | 2175 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 30274 | 691 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13201937 | 13201937 | PRJNA484127_P_NODE_1431_length_886_cov_2.367774_g1313_i0 | PRJNA484127 | 1431 | 886 | 2.367774 | 20.97847764 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1238 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1313 | i0 | 91.883 | 1.00112866817156 | 887 | 70 | 100 | 2 | 1 | 886 | 5537 | 6422 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 887 | 1238 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 15751015 | 15751015 | PRJNA484127_P_NODE_16073_length_320_cov_1.202429_g15924_i0 | PRJNA484127 | 16073 | 320 | 1.202429 | 3.8477728 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 569 | 6.699999999999998e-158 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g15924 | i0 | 98.75 | 3 | 320 | 4 | 100 | 0 | 1 | 320 | 5825 | 6144 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 960 | 569 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 15751252 | 15751252 | PRJNA484127_P_NODE_28793_length_256_cov_1.278689_g28644_i0 | PRJNA484127 | 28793 | 256 | 1.278689 | 3.27344384 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 219 | 2.1699999999999993e-52 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g28644 | i0 | 92.763 | 0.59375 | 152 | 10 | 59 | 1 | 103 | 254 | 1105 | 955 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 152 | 219 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 17025548 | 17025548 | PRJNA484127_P_NODE_11954_length_357_cov_2.169014_g11805_i0 | PRJNA484127 | 11954 | 357 | 2.169014 | 7.74337998 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 309 | 1.8200000000000003e-79 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g11805 | i0 | 92.202 | 0.610644257703081 | 218 | 17 | 61 | 0 | 140 | 357 | 4915 | 5132 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 218 | 309 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 18948774 | 18948774 | PRJNA484127_P_NODE_1055_length_1000_cov_3.362460_g952_i0 | PRJNA484127 | 1055 | 1000 | 3.36246 | 33.6246 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1838 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g952 | i0 | 99.9 | 79.519 | 998 | 1 | 99 | 0 | 3 | 1000 | 68 | 1065 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 79519 | 1842 | 0.997828447339848 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22774317 | 22774317 | PRJNA484127_P_NODE_7378_length_431_cov_4.156425_g7230_i0 | PRJNA484127 | 7378 | 431 | 4.156425 | 17.91419175 | Orthorubulavirus | 2560195 | Viruses | Viruses | 797 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g7230 | i0 | 100 | 67.9814385150812 | 431 | 0 | 100 | 0 | 1 | 431 | 3118 | 3548 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 29300 | 797 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis |
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);;