contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA722925" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1193691 | 1193691 | PRJNA722925_S_NODE_601_length_532_cov_3.977778_g542_i0 | PRJNA722925 | 601 | 532 | 3.977778 | 21.16177896 | Tobamovirus | 12234 | Viruses | Viruses | 972 | 0 | NTclustered | gi|2463200702|gb|ON987477.1| | 12253 | g542 | i0 | 99.624 | 99.7763157894737 | 532 | 2 | 100 | 0 | 1 | 532 | 3270 | 3801 | Tomato mosaic virus isolate NPPO-NL 41833930 RdRp, small replicase subunit, MP, and CP genes, complete cds | blastn | 53081 | 972 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 3261594 | 3261594 | PRJNA722925_S_NODE_8503_length_166_cov_1.193798_g8440_i0 | PRJNA722925 | 8503 | 166 | 1.193798 | 1.98170468 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 246 | 5.94e-61 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g8440 | i0 | 93.865 | 2.18072289156627 | 163 | 10 | 100 | 0 | 1 | 163 | 10146 | 10308 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 362 | 246 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10914274 | 10914274 | PRJNA722925_S_NODE_10909_length_153_cov_1.008621_g10846_i0 | PRJNA722925 | 10909 | 153 | 1.008621 | 1.54319013 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 283 | 4.0799999999999995e-72 | NTclustered | gi|924441762|emb|LN827938.1| | 12253 | g10846 | i0 | 100 | 100 | 153 | 0 | 100 | 0 | 1 | 153 | 179 | 27 | Tomato mosaic virus viral cRNA for coat and movement proteins (MP and CP genes), isolate AH9 | blastn | 15300 | 283 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 17288297 | 17288297 | PRJNA722925_S_NODE_11514_length_150_cov_1.336283_g11451_i0 | PRJNA722925 | 11514 | 150 | 1.336283 | 2.0044245 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 8.609999999999998e-69 | NTclustered | gi|2054782182|tpg|BK049745.1| | 2832643 | g11451 | i0 | 99.333 | 98.6933333333333 | 150 | 1 | 100 | 0 | 1 | 150 | 14216 | 14067 | MAG TPA_asm: Caudoviricetes sp. isolate ctRES18, partial genome | blastn | 14804 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19045483 | 19045483 | PRJNA722925_S_NODE_4995_length_203_cov_1.879518_g4932_i0 | PRJNA722925 | 4995 | 203 | 1.879518 | 3.81542154 | Tobamovirus | 12234 | Viruses | Viruses | 370 | 4.3e-98 | NTclustered | gi|1338641205|gb|KY967228.1| | 12253 | g4932 | i0 | 99.507 | 100 | 203 | 1 | 100 | 0 | 1 | 203 | 4849 | 4647 | Tomato mosaic virus isolate HHHT, complete genome | blastn | 20300 | 370 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 19837238 | 19837238 | PRJNA722925_S_NODE_9676_length_159_cov_0.959016_g9613_i0 | PRJNA722925 | 9676 | 159 | 0.959016 | 1.52483544 | Gammapapillomavirus 9 | 1175851 | Viruses | Viruses | 294 | 1.98e-75 | NTclustered | gi|1273499269|gb|MF588712.1| | 1175851 | g9613 | i0 | 100 | 2 | 159 | 0 | 100 | 0 | 1 | 159 | 1741 | 1899 | Gammapapillomavirus 9 isolate Gamma09_w27c39c, complete genome | blastn | 318 | 294 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Gammapapillomavirus | Gammapapillomavirus 9 | ||
| 21595871 | 21595871 | PRJNA722925_S_NODE_5097_length_201_cov_1.664634_g5034_i0 | PRJNA722925 | 5097 | 201 | 1.664634 | 3.34591434 | Tobamovirus | 12234 | Viruses | Viruses | 366 | 5.5e-97 | NTclustered | gi|4377853|gb|AF062519.1|AF062519 | 12242 | g5034 | i0 | 99.502 | 100 | 201 | 1 | 100 | 0 | 1 | 201 | 165 | 365 | Tobacco mosaic virus movement protein and coat protein genes, complete cds | blastn | 20100 | 366 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 22871203 | 22871203 | PRJNA722925_S_NODE_3518_length_236_cov_2.095477_g3455_i0 | PRJNA722925 | 3518 | 236 | 2.095477 | 4.94532572 | root | 1 | Root_unresolved | Root_unresolved | 436 | 4.999999999999999e-118 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g3455 | i0 | 100 | 99.9618644067797 | 236 | 0 | 100 | 0 | 1 | 236 | 3882 | 3647 | Moloney murine leukemia virus, complete genome | blastn | 23591 | 436 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 24145219 | 24145219 | PRJNA722925_S_NODE_4219_length_218_cov_1.292818_g4156_i0 | PRJNA722925 | 4219 | 218 | 1.292818 | 2.81834324 | root | 1 | Root_unresolved | Root_unresolved | 383 | 6.02e-102 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g4156 | i0 | 100 | 94.9449541284404 | 207 | 0 | 95 | 0 | 12 | 218 | 2596 | 2802 | Moloney murine leukemia virus, complete genome | blastn | 20698 | 383 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;