contig_metadata
15 rows where bioproject = "PRJNA1085664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1468171 | 1468171 | PRJNA1085664_S_NODE_24822_length_177_cov_1.074627_g24403_i0 | PRJNA1085664 | 24822 | 177 | 1.074627 | 1.90208979 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 58.4 | 3.21e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g24403 | i0 | 97.143 | 0.19774011299435 | 35 | 0 | 19 | 1 | 1 | 34 | 15 | 49 | Carnation latent virus isolate KL, complete genome | blastn | 35 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 2744310 | 2744310 | PRJNA1085664_S_NODE_7223_length_320_cov_3.122744_g6804_i0 | PRJNA1085664 | 7223 | 320 | 3.122744 | 9.9927808 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g6804 | i0 | 100 | 0.18125 | 30 | 0 | 9 | 0 | 291 | 320 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 9121114 | 9121114 | PRJNA1085664_S_NODE_12828_length_242_cov_22.422111_g12409_i0 | PRJNA1085664 | 12828 | 242 | 22.422111 | 54.26150862 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g12409 | i0 | 100 | 0.235537190082645 | 29 | 0 | 12 | 0 | 214 | 242 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 11672185 | 11672185 | PRJNA1085664_S_NODE_17030_length_211_cov_0.857143_g16611_i0 | PRJNA1085664 | 17030 | 211 | 0.857143 | 1.80857173 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g16611 | i0 | 100 | 0.274881516587678 | 30 | 0 | 14 | 0 | 182 | 211 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 15496175 | 15496175 | PRJNA1085664_S_NODE_18193_length_204_cov_1.490683_g17774_i0 | PRJNA1085664 | 18193 | 204 | 1.490683 | 3.04099332 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g17774 | i0 | 100 | 0.279411764705882 | 29 | 0 | 14 | 0 | 1 | 29 | 6 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18045322 | 18045322 | PRJNA1085664_S_NODE_36635_length_151_cov_0.870370_g36216_i0 | PRJNA1085664 | 36635 | 151 | 0.87037 | 1.3142587 | Pestivirus bovis | 3052619 | Viruses | Viruses | 230 | 5.299999999999999e-56 | NTclustered | gi|972905812|gb|KU200260.1| | 11099 | g36216 | i0 | 94.04 | 93.6291390728477 | 151 | 9 | 100 | 0 | 1 | 151 | 8809 | 8959 | Bovine viral diarrhea virus 1, partial genome | blastn | 14138 | 230 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 18868989 | 18868989 | PRJNA1085664_S_NODE_6755_length_330_cov_1.637631_g6336_i0 | PRJNA1085664 | 6755 | 330 | 1.637631 | 5.4041823 | Pestivirus | 11095 | Viruses | Viruses | 584 | 2.48e-162 | NTclustered | gi|2672396898|gb|PP277983.1| | 11099 | g6336 | i0 | 98.78 | 52.4212121212121 | 328 | 4 | 99 | 0 | 1 | 328 | 10047 | 9720 | Bovine viral diarrhea virus 1 isolate NX2023, complete genome | blastn | 17299 | 584 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 19319256 | 19319256 | PRJNA1085664_S_NODE_19856_length_196_cov_1.117647_g19437_i0 | PRJNA1085664 | 19856 | 196 | 1.117647 | 2.19058812 | Gammaretrovirus porConc | 3428960 | Viruses | Viruses | 287 | 4.27e-73 | NTclustered | gi|119393850|gb|EF133960.1| | 509154 | g19437 | i0 | 97.059 | 83.5765306122449 | 170 | 5 | 87 | 0 | 26 | 195 | 2243 | 2412 | Porcine endogenous type C retrovirus clone 6 from China, complete genome | blastn | 16381 | 287 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus porConc | ||
| 19319349 | 19319349 | PRJNA1085664_S_NODE_7376_length_317_cov_3.281022_g6957_i0 | PRJNA1085664 | 7376 | 317 | 3.281022 | 10.40083974 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 58.4 | 6.38e-4 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g6957 | i0 | 100 | 0.0977917981072555 | 31 | 0 | 10 | 0 | 1 | 31 | 8 | 38 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 31 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 20143699 | 20143699 | PRJNA1085664_S_NODE_12656_length_244_cov_2.034826_g12237_i0 | PRJNA1085664 | 12656 | 244 | 2.034826 | 4.96497544 | Pestivirus | 11095 | Viruses | Viruses | 442 | 1.1199999999999994e-119 | NTclustered | gi|1093530907|gb|KT943518.1| | 11099 | g12237 | i0 | 99.587 | 49.7377049180328 | 242 | 1 | 99 | 0 | 3 | 244 | 8195 | 7954 | Bovine viral diarrhea virus 1 isolate BJ1201, complete genome | blastn | 12136 | 446 | 0.991031390134529 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 20594635 | 20594635 | PRJNA1085664_S_NODE_30237_length_161_cov_4.254237_g29818_i0 | PRJNA1085664 | 30237 | 161 | 4.254237 | 6.84932157 | Norovirus norwalkense | 3431196 | Viruses | Viruses | 279 | 5.64e-71 | NTclustered | gi|1189484999|gb|KY905331.1| | 122929 | g29818 | i0 | 99.351 | 95.6024844720497 | 154 | 1 | 96 | 0 | 8 | 161 | 209 | 56 | Norovirus GII strain Hu/GII.P4 New Orleans 2009_GII.4 Sydney 2012/NSW789Z/2016/AU, partial genome | blastn | 15392 | 279 | 1 | Viruses | Norovirus GII | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Norovirus | Norovirus norwalkense | |
| 21870415 | 21870415 | PRJNA1085664_S_NODE_34618_length_153_cov_0.872727_g34199_i0 | PRJNA1085664 | 34618 | 153 | 0.872727 | 1.33527231 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 54.7 | 0.003 | NTclustered | gi|1839143214|emb|LR796235.1| | 2100421 | g34199 | i0 | 100 | 0.189542483660131 | 29 | 0 | 19 | 0 | 4 | 32 | 109159 | 109131 | uncultured Caudovirales phage genome assembly | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 23145805 | 23145805 | PRJNA1085664_S_NODE_99_length_7351_cov_66.451013_g98_i0 | PRJNA1085664 | 99 | 7351 | 66.451013 | 4884.81396563 | Norovirus norwalkense | 3431196 | Viruses | Viruses | 13071 | 0 | NTclustered | gi|1189484999|gb|KY905331.1| | 122929 | g98 | i0 | 98.841 | 99.6180111549449 | 7336 | 79 | 99 | 1 | 16 | 7351 | 7546 | 217 | Norovirus GII strain Hu/GII.P4 New Orleans 2009_GII.4 Sydney 2012/NSW789Z/2016/AU, partial genome | blastn | 732292 | 13071 | 1 | Viruses | Norovirus GII | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Norovirus | Norovirus norwalkense | |
| 24419324 | 24419324 | PRJNA1085664_S_NODE_11920_length_252_cov_1.267943_g11501_i0 | PRJNA1085664 | 11920 | 252 | 1.267943 | 3.19521636 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g11501 | i0 | 100 | 11.5079365079365 | 29 | 0 | 12 | 0 | 179 | 207 | 119274 | 119302 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 28204312 | 28204312 | PRJNA1085664_S_NODE_32126_length_157_cov_1.684211_g31707_i0 | PRJNA1085664 | 32126 | 157 | 1.684211 | 2.64421127 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 58.2 | 2.49e-8 | NR | DAC81394.1 | 2609864 | g31707 | i0 | 69.4 | 0.687898089171974 | 36 | 11 | 68.8 | 0 | 108 | 1 | 7 | 42 | DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] | diamond | 108 | 58.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus |
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);;