contig_metadata
13 rows where bioproject = "PRJNA1111448" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 217351 | 217351 | PRJNA1111448_S_NODE_115701_length_255_cov_2.027473_g114878_i0 | PRJNA1111448 | 115701 | 255 | 2.027473 | 5.17005615 | Wufeng shrew picornavirus 2 | 3084773 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|2633074035|gb|OQ716065.1| | 3084773 | g114878 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 103 | 130 | 9748 | 9721 | MAG: Wufeng shrew picornavirus 2 isolate WF_Ch.smithii_picorna_3 polyprotein gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Wufeng shrew picornavirus 2 | ||||
| 4044368 | 4044368 | PRJNA1111448_S_NODE_128324_length_247_cov_0.885057_g127501_i0 | PRJNA1111448 | 128324 | 247 | 0.885057 | 2.18609079 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 73.1 | 1.71e-8 | NTclustered | gi|2557639027|emb|OY695365.1| | 2697049 | g127501 | i0 | 97.674 | 16.2388663967611 | 43 | 0 | 17 | 1 | 2 | 44 | 19286 | 19245 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4011 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5320401 | 5320401 | PRJNA1111448_S_NODE_133085_length_244_cov_1.222222_g132262_i0 | PRJNA1111448 | 133085 | 244 | 1.222222 | 2.98222168 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 82.4 | 2.81e-11 | NTclustered | gi|2557415206|emb|OY652159.1| | 2697049 | g132262 | i0 | 90.625 | 21.9180327868852 | 64 | 3 | 25 | 3 | 177 | 238 | 7114 | 7176 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 5348 | 82.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8675843 | 8675843 | PRJNA1111448_S_NODE_137347_length_242_cov_0.911243_g136524_i0 | PRJNA1111448 | 137347 | 242 | 0.911243 | 2.20520806 | Orthorubulavirus | 2560195 | Viruses | Viruses | 335 | 1.9299999999999993e-87 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g136524 | i0 | 99.457 | 64.0247933884298 | 184 | 1 | 76 | 0 | 1 | 184 | 296 | 113 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 15494 | 335 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 9145719 | 9145719 | PRJNA1111448_S_NODE_4828_length_747_cov_2.074184_g4189_i0 | PRJNA1111448 | 4828 | 747 | 2.074184 | 15.49415448 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.006 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g4189 | i0 | 100 | 0.0789825970548862 | 30 | 0 | 4 | 0 | 718 | 747 | 85 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 59 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 10420891 | 10420891 | PRJNA1111448_S_NODE_114809_length_256_cov_1.683060_g113986_i0 | PRJNA1111448 | 114809 | 256 | 1.68306 | 4.3086336 | Chronazanb virus | 3129852 | Viruses | Viruses | 145 | 3.73e-30 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g113986 | i0 | 94.624 | 16.74609375 | 93 | 5 | 36 | 0 | 20 | 112 | 4485 | 4393 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 4287 | 145 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 11696232 | 11696232 | PRJNA1111448_S_NODE_124810_length_249_cov_0.801136_g123987_i0 | PRJNA1111448 | 124810 | 249 | 0.801136 | 1.99482864 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 97.1 | 1.03e-15 | NTclustered | gi|2165836885|emb|OV197189.1| | 2697049 | g123987 | i0 | 93.846 | 23.6987951807229 | 65 | 2 | 26 | 2 | 3 | 67 | 29973 | 29911 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 5901 | 97.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12971896 | 12971896 | PRJNA1111448_S_NODE_49291_length_349_cov_4.376812_g48468_i0 | PRJNA1111448 | 49291 | 349 | 4.376812 | 15.27507388 | Capillovirus mali | 28347 | Viruses | Viruses | 640 | 5.529999999999999e-179 | NTclustered | gi|1486551909|gb|MH144342.1| | 33759 | g48468 | i0 | 99.713 | 99.7077363896848 | 349 | 1 | 100 | 0 | 1 | 349 | 6148 | 6496 | Citrus tatter leaf virus isolate ASGV-1-HJY, complete genome | blastn | 34798 | 640 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 16795613 | 16795613 | PRJNA1111448_S_NODE_96314_length_276_cov_1.098522_g95491_i0 | PRJNA1111448 | 96314 | 276 | 1.098522 | 3.03192072 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 93.5 | 1.5e-14 | NTclustered | gi|2165836885|emb|OV197189.1| | 2697049 | g95491 | i0 | 95 | 19.6521739130435 | 60 | 1 | 22 | 2 | 1 | 60 | 29968 | 29911 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 5424 | 93.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20619237 | 20619237 | PRJNA1111448_S_NODE_59337_length_329_cov_1.152344_g58514_i0 | PRJNA1111448 | 59337 | 329 | 1.152344 | 3.79121176 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 73.1 | 2.38e-8 | NTclustered | gi|2557399578|emb|OY642376.1| | 2697049 | g58514 | i0 | 92.308 | 13.3434650455927 | 52 | 2 | 16 | 2 | 1 | 52 | 19297 | 19248 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4390 | 73.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 30384190 | 30384190 | PRJNA1111448_S_NODE_23353_length_444_cov_1.940701_g22531_i0 | PRJNA1111448 | 23353 | 444 | 1.940701 | 8.61671244 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 59.7 | 4.04e-7 | NR | UNY42093.1 | 3003959 | g22531 | i0 | 66.7 | 0.263513513513513 | 39 | 13 | 26.4 | 0 | 327 | 443 | 25 | 63 | UNY42093.1 MAG: polyprotein 1 [Picornavirales sp.] | diamond | 117 | 59.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30668126 | 30668126 | PRJNA1111448_S_NODE_96213_length_276_cov_1.137931_g95390_i0 | PRJNA1111448 | 96213 | 276 | 1.137931 | 3.14068956 | Vallisneria spiralis virus 1 | 3351449 | Viruses | Viruses | 143 | 6.439999999999998e-41 | NR | DBA60344.1 | 3351449 | g95390 | i0 | 88.6 | 0.858695652173913 | 79 | 9 | 85.9 | 0 | 276 | 40 | 131 | 209 | DBA60344.1 TPA_asm: coat protein [Vallisneria spiralis virus 1] | diamond | 237 | 143 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Tepovirus | Vallisneria spiralis virus 1 | ||
| 32691427 | 32691427 | PRJNA1111448_S_NODE_73040_length_306_cov_0.991416_g72217_i0 | PRJNA1111448 | 73040 | 306 | 0.991416 | 3.03373296 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 180 | 2.05e-51 | NR | URG14993.1 | 1530251 | g72217 | i0 | 78.4 | 1 | 102 | 22 | 100 | 0 | 1 | 306 | 34 | 135 | URG14993.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] | diamond | 306 | 180 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae 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);;