contig_metadata
18 rows where bioproject = "PRJNA721440" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1986174 | 1986174 | PRJNA721440_S_NODE_2202_length_373_cov_3.283951_g2076_i0 | PRJNA721440 | 2202 | 373 | 3.283951 | 12.24913723 | Aparavirus sp. | 1955142 | Viruses | Viruses | 311 | 5.3e-80 | NTclustered | gi|2196304182|gb|MZ679100.1| | 1955142 | g2076 | i0 | 82.192 | 3.27345844504021 | 365 | 61 | 97 | 4 | 2 | 364 | 4518 | 4880 | MAG: Aparavirus sp. isolate s48-k141_542821 hypothetical protein 1 and hypothetical protein 2 genes, complete cds | blastn | 1221 | 311 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 8363477 | 8363477 | PRJNA721440_S_NODE_5307_length_259_cov_196.723810_g5181_i0 | PRJNA721440 | 5307 | 259 | 196.72381 | 509.5146679 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 122 | 1.7699999999999998e-23 | NTclustered | gi|2165833299|emb|OV195597.1| | 2697049 | g5181 | i0 | 95 | 0.602316602316602 | 80 | 1 | 30 | 3 | 183 | 259 | 120 | 41 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 156 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9638626 | 9638626 | PRJNA721440_S_NODE_19308_length_163_cov_1.824561_g19182_i0 | PRJNA721440 | 19308 | 163 | 1.824561 | 2.97403443 | Aparavirus sp. | 1955142 | Viruses | Viruses | 109 | 3.15e-26 | NR | ULF99835.1 | 1955142 | g19182 | i0 | 92.5 | 0.975460122699387 | 53 | 4 | 97.5 | 0 | 161 | 3 | 1164 | 1216 | ULF99835.1 MAG: hypothetical protein 1 [Aparavirus sp.] | diamond | 159 | 109 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 9638635 | 9638635 | PRJNA721440_S_NODE_5748_length_251_cov_72.539604_g5622_i0 | PRJNA721440 | 5748 | 251 | 72.539604 | 182.07440604 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 119 | 2.21e-22 | NTclustered | gi|2165835426|emb|OV196492.1| | 2697049 | g5622 | i0 | 94.872 | 14.9482071713147 | 78 | 1 | 30 | 2 | 1 | 75 | 61 | 138 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3752 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12189465 | 12189465 | PRJNA721440_S_NODE_3090_length_323_cov_59.204380_g2964_i0 | PRJNA721440 | 3090 | 323 | 59.20438 | 191.2301474 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 122 | 2.2799999999999994e-23 | NTclustered | gi|2165835005|emb|OV196273.1| | 2697049 | g2964 | i0 | 96.104 | 0.439628482972136 | 77 | 0 | 23 | 2 | 250 | 323 | 112 | 36 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 142 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13463892 | 13463892 | PRJNA721440_S_NODE_14331_length_179_cov_2.961538_g14205_i0 | PRJNA721440 | 14331 | 179 | 2.961538 | 5.30115302 | Ampelovirus tetravitis | 3426346 | Viruses | Viruses | 60.2 | 9.06e-5 | NTclustered | gi|2452977696|gb|OP752675.1| | 70177 | g14205 | i0 | 100 | 0.17877094972067 | 32 | 0 | 18 | 0 | 1 | 32 | 13853 | 13822 | Grapevine leafroll-associated virus 4 isolate LC9_N5, complete genome | blastn | 32 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Ampelovirus | Ampelovirus tetravitis | ||
| 13463901 | 13463901 | PRJNA721440_S_NODE_1771_length_408_cov_6.448468_g1645_i0 | PRJNA721440 | 1771 | 408 | 6.448468 | 26.30974944 | Aparavirus sp. | 1955142 | Viruses | Viruses | 212 | 1.9e-61 | NR | ULF99836.1 | 1955142 | g1645 | i0 | 72 | 1.05147058823529 | 143 | 32 | 99.3 | 1 | 3 | 407 | 475 | 617 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 429 | 212 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 13463915 | 13463915 | PRJNA721440_S_NODE_2551_length_351_cov_1.033113_g2425_i0 | PRJNA721440 | 2551 | 351 | 1.033113 | 3.62622663 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 69.4 | 3.29e-7 | NTclustered | gi|2557639802|emb|OY695838.1| | 2697049 | g2425 | i0 | 95.455 | 0.216524216524217 | 44 | 1 | 12 | 1 | 304 | 346 | 4713 | 4756 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 76 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18561997 | 18561997 | PRJNA721440_S_NODE_5695_length_252_cov_208.211823_g5569_i0 | PRJNA721440 | 5695 | 252 | 208.211823 | 524.69379396 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 82.4 | 2.9099999999999998e-11 | NTclustered | gi|2046845739|emb|OU076650.1| | 2697049 | g5569 | i0 | 96.078 | 0.468253968253968 | 51 | 0 | 19 | 1 | 204 | 252 | 204 | 154 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 118 | 82.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 19837074 | 19837074 | PRJNA721440_S_NODE_14176_length_180_cov_1.793893_g14050_i0 | PRJNA721440 | 14176 | 180 | 1.793893 | 3.2290074 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 305 | 1.06e-78 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g14050 | i0 | 97.222 | 3 | 180 | 5 | 100 | 0 | 1 | 180 | 5633 | 5454 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 540 | 305 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 19837105 | 19837105 | PRJNA721440_S_NODE_3716_length_298_cov_256.232932_g3590_i0 | PRJNA721440 | 3716 | 298 | 256.232932 | 763.57413736 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 121 | 7.489999999999999e-23 | NTclustered | gi|2165835426|emb|OV196492.1| | 2697049 | g3590 | i0 | 94.937 | 0.76510067114094 | 79 | 1 | 26 | 2 | 1 | 76 | 176 | 254 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 228 | 121 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 27241634 | 27241634 | PRJNA721440_S_NODE_9363_length_209_cov_5.337500_g9237_i0 | PRJNA721440 | 9363 | 209 | 5.3375 | 11.155375 | Aparavirus sp. | 1955142 | Viruses | Viruses | 122 | 2.18e-30 | NR | ULF99836.1 | 1955142 | g9237 | i0 | 82.4 | 0.976076555023923 | 68 | 12 | 97.6 | 0 | 206 | 3 | 199 | 266 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 204 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 27652488 | 27652488 | PRJNA721440_S_NODE_3024_length_327_cov_2.118705_g2898_i0 | PRJNA721440 | 3024 | 327 | 2.118705 | 6.9281653499999996 | Aparavirus sp. | 1955142 | Viruses | Viruses | 167 | 1.17e-45 | NR | ULF99826.1 | 1955142 | g2898 | i0 | 76.4 | 1.95412844036697 | 106 | 25 | 97.2 | 0 | 5 | 322 | 58 | 163 | ULF99826.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 639 | 167 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 28062698 | 28062698 | PRJNA721440_S_NODE_14105_length_180_cov_4.206107_g13979_i0 | PRJNA721440 | 14105 | 180 | 4.206107 | 7.5709926 | Aparavirus sp. | 1955142 | Viruses | Viruses | 98.6 | 3.41e-22 | NR | ULF99835.1 | 1955142 | g13979 | i0 | 83.1 | 0.983333333333333 | 59 | 9 | 98.3 | 1 | 179 | 3 | 600 | 657 | ULF99835.1 MAG: hypothetical protein 1 [Aparavirus sp.] | diamond | 177 | 98.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 30241714 | 30241714 | PRJNA721440_S_NODE_4192_length_285_cov_5.245763_g4066_i0 | PRJNA721440 | 4192 | 285 | 5.245763 | 14.95042455 | Aparavirus sp. | 1955142 | Viruses | Viruses | 147 | 6.94e-39 | NR | ULF99836.1 | 1955142 | g4066 | i0 | 77.4 | 0.978947368421053 | 93 | 21 | 97.9 | 0 | 6 | 284 | 311 | 403 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 279 | 147 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 30273528 | 30273528 | PRJNA721440_S_NODE_17172_length_168_cov_3.050420_g17046_i0 | PRJNA721440 | 17172 | 168 | 3.05042 | 5.1247056 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 64.3 | 3.26e-10 | NR | WLN26256.1 | 3065075 | g17046 | i0 | 57.7 | 0.928571428571429 | 52 | 22 | 92.9 | 0 | 5 | 160 | 260 | 311 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 156 | 64.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 31063341 | 31063341 | PRJNA721440_S_NODE_17115_length_168_cov_5.806723_g16989_i0 | PRJNA721440 | 17115 | 168 | 5.806723 | 9.75529464 | Aparavirus sp. | 1955142 | Viruses | Viruses | 48.9 | 9.29e-5 | NR | ULF99836.1 | 1955142 | g16989 | i0 | 90.5 | 0.375 | 21 | 2 | 37.5 | 0 | 1 | 63 | 791 | 811 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 63 | 48.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus sp. | ||
| 32297047 | 32297047 | PRJNA721440_S_NODE_11439_length_195_cov_2.130137_g11313_i0 | PRJNA721440 | 11439 | 195 | 2.130137 | 4.15376715 | Aparavirus sp. | 1955142 | Viruses | Viruses | 102 | 2.67e-23 | NR | ULF99836.1 | 1955142 | g11313 | i0 | 67.7 | 1 | 65 | 21 | 100 | 0 | 1 | 195 | 418 | 482 | ULF99836.1 MAG: hypothetical protein 2 [Aparavirus sp.] | diamond | 195 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus 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);;