contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA964500" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 941836 | 941836 | PRJNA964500_S_NODE_821_length_473_cov_5.592342_g737_i0 | PRJNA964500 | 821 | 473 | 5.592342 | 26.45177766 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 627 | 6.01e-175 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g737 | i0 | 92.342 | 377.012684989429 | 444 | 29 | 93 | 5 | 1 | 442 | 18323 | 17883 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 178327 | 627 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2217093 | 2217093 | PRJNA964500_S_NODE_262_length_671_cov_30486.048287_g226_i0 | PRJNA964500 | 262 | 671 | 30486.048287 | 204561.38400577 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 339 | 4.58e-88 | NTclustered | gi|2183471093|gb|MZ679981.1| | 2809572 | g226 | i0 | 78.374 | 128.229508196721 | 578 | 85 | 82 | 37 | 52 | 603 | 564 | 1 | MAG: Mitoviridae sp. isolate s48-k141_498684 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 86042 | 339 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 4770154 | 4770154 | PRJNA964500_S_NODE_2564_length_318_cov_3.352941_g2472_i0 | PRJNA964500 | 2564 | 318 | 3.352941 | 10.66235238 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 267 | 9.78e-67 | NTclustered | gi|2183471093|gb|MZ679981.1| | 2809572 | g2472 | i0 | 82.109 | 0.984276729559748 | 313 | 54 | 98 | 2 | 6 | 318 | 774 | 1084 | MAG: Mitoviridae sp. isolate s48-k141_498684 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 313 | 267 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 9869954 | 9869954 | PRJNA964500_S_NODE_11248_length_178_cov_11.610738_g11156_i0 | PRJNA964500 | 11248 | 178 | 11.610738 | 20.66711364 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 58.4 | 3.24e-4 | NTclustered | gi|2797671158|gb|PQ281491.1| | 10244 | g11156 | i0 | 100 | 2.15168539325843 | 31 | 0 | 17 | 0 | 1 | 31 | 197069 | 197039 | Monkeypox virus isolate Monkeypox virus/Human/Thailand/DDCBIDI-002/2024, partial genome | blastn | 383 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 11145444 | 11145444 | PRJNA964500_S_NODE_11489_length_177_cov_2.540541_g11397_i0 | PRJNA964500 | 11489 | 177 | 2.540541 | 4.49675757 | uncultured mitochondrial RNA virus | 1075823 | Viruses | Viruses | 230 | 6.439999999999999e-56 | NTclustered | gi|379055532|emb|HE579569.1| | 1075823 | g11397 | i0 | 94.595 | 1.80790960451977 | 148 | 8 | 84 | 0 | 27 | 174 | 149 | 2 | Uncultured mitochondrial RNA virus genomic RNA containing putative RdRp, contig 162Hv2_cloning_4 | blastn | 320 | 230 | 1 | Viruses | uncultured mitochondrial RNA virus | ||||||||
| 12420898 | 12420898 | PRJNA964500_S_NODE_15130_length_159_cov_2.700000_g15038_i0 | PRJNA964500 | 15130 | 159 | 2.7 | 4.293 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g15038 | i0 | 100 | 18.2389937106918 | 29 | 0 | 18 | 0 | 68 | 96 | 119302 | 119274 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 12420967 | 12420967 | PRJNA964500_S_NODE_8630_length_198_cov_36.213018_g8538_i0 | PRJNA964500 | 8630 | 198 | 36.213018 | 71.70177564 | CrAssphage cat_SB2894 | 2781373 | Viruses | Viruses | 62.1 | 2.85e-5 | NTclustered | gi|1933200211|gb|MW063138.1| | 2781373 | g8538 | i0 | 100 | 5.53030303030303 | 33 | 0 | 17 | 0 | 1 | 33 | 33566 | 33598 | MAG: CrAssphage cat_SB2894, partial genome | blastn | 1095 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Crassvirales | Intestiviridae | Carjivirus | CrAssphage cat_SB2894 | ||
| 13695431 | 13695431 | PRJNA964500_S_NODE_10071_length_186_cov_356.401274_g9979_i0 | PRJNA964500 | 10071 | 186 | 356.401274 | 662.90636964 | Parvovirus emberiza5276 | 3117079 | Viruses | Viruses | 76.8 | 9.44e-10 | NTclustered | gi|2710394588|tpg|BK066855.1| | 3117079 | g9979 | i0 | 100 | 227.747311827957 | 41 | 0 | 22 | 0 | 1 | 41 | 5104 | 5064 | MAG TPA_asm: Parvovirus emberiza5276 isolate Parvo5276 genomic sequence | blastn | 42361 | 76.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus emberiza5276 | |||
| 13695485 | 13695485 | PRJNA964500_S_NODE_3391_length_287_cov_4.728682_g3299_i0 | PRJNA964500 | 3391 | 287 | 4.728682 | 13.57131734 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g3299 | i0 | 94.286 | 0.121951219512195 | 35 | 1 | 12 | 1 | 89 | 122 | 153475 | 153509 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 15293444 | 15293444 | PRJNA964500_S_NODE_2852_length_307_cov_2.809353_g2760_i0 | PRJNA964500 | 2852 | 307 | 2.809353 | 8.62471371 | root | 1 | Root_unresolved | Root_unresolved | 568 | 2.3e-157 | NTclustered | gi|2583941926|gb|OP431890.1| | 10298 | g2760 | i0 | 100 | 100 | 307 | 0 | 100 | 0 | 1 | 307 | 50956 | 50650 | Human alphaherpesvirus 1 strain HSV1-v63_d84_oral, partial genome | blastn | 30700 | 568 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 20391789 | 20391789 | PRJNA964500_S_NODE_1836_length_357_cov_30250.756098_g1744_i0 | PRJNA964500 | 1836 | 357 | 30250.756098 | 107995.19926986 | root | 1 | Root_unresolved | Root_unresolved | 457 | 6.1299999999999984e-124 | NTclustered | gi|2583942922|gb|OP431909.1| | 10298 | g1744 | i0 | 100 | 134.294117647059 | 247 | 0 | 69 | 0 | 57 | 303 | 130534 | 130780 | Human alphaherpesvirus 1 strain HSV1-v62_d3_gen_les, partial genome | blastn | 47943 | 457 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha1 | ||
| 22618892 | 22618892 | PRJNA964500_S_NODE_1058_length_433_cov_2.688119_g968_i0 | PRJNA964500 | 1058 | 433 | 2.688119 | 11.63955527 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 401 | 3.599999999999999e-107 | NTclustered | gi|2183471000|gb|MZ679929.1| | 2809572 | g968 | i0 | 85.287 | 0.926096997690531 | 401 | 46 | 91 | 12 | 35 | 427 | 437 | 42 | MAG: Mitoviridae sp. isolate s48-k141_272859 putative RNA-dependent RNA polymerase gene, partial cds | blastn | 401 | 401 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 22943248 | 22943248 | PRJNA964500_S_NODE_9518_length_191_cov_2.925926_g9426_i0 | PRJNA964500 | 9518 | 191 | 2.925926 | 5.58851866 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1774769601|gb|MN158206.1| | 2656629 | g9426 | i0 | 100 | 0.303664921465969 | 29 | 0 | 15 | 0 | 1 | 29 | 42039 | 42011 | Escherichia phage BEK2, complete genome | blastn | 58 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Escherichia phage BEK2 |
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);;