contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 385857 | 385857 | PRJNA315399_S_NODE_95141_length_181_cov_1.881944_g94940_i0 | PRJNA315399 | 95141 | 181 | 1.881944 | 3.40631864 | Alphaendornavirus capsici | 3426171 | Viruses | Viruses | 303 | 3.84e-78 | NTclustered | gi|390608729|gb|JQ951943.1| | 354328 | g94940 | i0 | 100 | 27.1657458563536 | 164 | 0 | 91 | 0 | 18 | 181 | 11947 | 12110 | Bell pepper endornavirus strain IS RNA-dependent RNA polymerase (RdRp) gene, complete cds | blastn | 4917 | 303 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus capsici | ||
| 1066892 | 1066892 | PRJNA315399_S_NODE_33961_length_239_cov_5.866337_g33760_i0 | PRJNA315399 | 33961 | 239 | 5.866337 | 14.02054543 | Tobamovirus | 12234 | Viruses | Viruses | 409 | 1.11e-109 | NTclustered | gi|1821461776|gb|MN267897.1| | 12239 | g33760 | i0 | 98.696 | 90.5271966527197 | 230 | 3 | 96 | 0 | 1 | 230 | 3797 | 3568 | Pepper mild mottle virus isolate PMMoV_WW17-E1-Nben-pos, complete genome | blastn | 21636 | 409 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 2936136 | 2936136 | PRJNA315399_S_NODE_6503_length_404_cov_5.880109_g6304_i0 | PRJNA315399 | 6503 | 404 | 5.880109 | 23.75564036 | Potexvirus pepini | 3433856 | Viruses | Viruses | 741 | 0 | NTclustered | gi|79676039|emb|AM109896.1| | 112229 | g6304 | i0 | 100 | 97.1559405940594 | 401 | 0 | 99 | 0 | 4 | 404 | 5961 | 6361 | Pepino mosaic virus complete genome, isolate SM.74 | blastn | 39251 | 741 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 4211651 | 4211651 | PRJNA315399_S_NODE_131664_length_166_cov_4.093023_g131463_i0 | PRJNA315399 | 131664 | 166 | 4.093023 | 6.79441818 | Potexvirus ecstulipae | 3433839 | Viruses | Viruses | 202 | 1.2999999999999998e-47 | NTclustered | gi|56792907|gb|AY842510.1| | 167132 | g131463 | i0 | 89.024 | 2.98795180722892 | 164 | 17 | 99 | 1 | 3 | 166 | 355 | 517 | Tulip virus X coat protein gene, partial cds | blastn | 496 | 202 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus ecstulipae | ||
| 4212320 | 4212320 | PRJNA315399_S_NODE_27084_length_255_cov_9.532110_g26883_i0 | PRJNA315399 | 27084 | 255 | 9.53211 | 24.3068805 | Avellana capillovirus 1 | 2794427 | Viruses | Viruses | 309 | 1.25e-79 | NTclustered | gi|1950492684|gb|MW328729.1| | 2794427 | g26883 | i0 | 90.295 | 0.929411764705882 | 237 | 21 | 93 | 2 | 14 | 249 | 6195 | 6430 | Avellana capillovirus 1 polyprotein and MP genes, complete cds | blastn | 237 | 309 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Avellana capillovirus 1 | ||
| 5488160 | 5488160 | PRJNA315399_S_NODE_148265_length_161_cov_4.524194_g148064_i0 | PRJNA315399 | 148265 | 161 | 4.524194 | 7.28395234 | Wuhan aphid virus 2 | 1746068 | Viruses | Viruses | 159 | 7.66e-35 | NTclustered | gi|2444492076|gb|OP797725.1| | 1746068 | g148064 | i0 | 87.591 | 0.850931677018634 | 137 | 17 | 85 | 0 | 25 | 161 | 4 | 140 | Wuhan aphid virus 2 isolate 12842-WAV2S4 segment 4 hypothetical protein (VP3) gene, partial cds | blastn | 137 | 159 | 1 | Viruses | Jingmenvirus group | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Wuhan aphid virus 2 | ||
| 9994966 | 9994966 | PRJNA315399_S_NODE_28208_length_252_cov_9.562791_g28007_i0 | PRJNA315399 | 28208 | 252 | 9.562791 | 24.09823332 | Potexvirus | 12176 | Viruses | Viruses | 440 | 4.1699999999999984e-119 | NTclustered | gi|1805119874|gb|MN038406.1| | 112229 | g28007 | i0 | 99.585 | 59.2063492063492 | 241 | 1 | 96 | 0 | 12 | 252 | 1131 | 1371 | Pepino mosaic virus strain MZ3, complete genome | blastn | 14920 | 440 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 14413222 | 14413222 | PRJNA315399_S_NODE_119432_length_170_cov_6.218045_g119231_i0 | PRJNA315399 | 119432 | 170 | 6.218045 | 10.5706765 | Avellana capillovirus 1 | 2794427 | Viruses | Viruses | 169 | 1.35e-37 | NTclustered | gi|1950492684|gb|MW328729.1| | 2794427 | g119231 | i0 | 86.755 | 0.888235294117647 | 151 | 20 | 89 | 0 | 15 | 165 | 6037 | 6187 | Avellana capillovirus 1 polyprotein and MP genes, complete cds | blastn | 151 | 169 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Avellana capillovirus 1 | ||
| 15688197 | 15688197 | PRJNA315399_S_NODE_6193_length_410_cov_67.820375_g5995_i0 | PRJNA315399 | 6193 | 410 | 67.820375 | 278.0635375 | Bromovirus BMV | 3427622 | Viruses | Viruses | 734 | 0 | NTclustered | gi|2239526092|gb|MW568015.1| | 12302 | g5995 | i0 | 99.504 | 36.2560975609756 | 403 | 2 | 98 | 0 | 1 | 403 | 1204 | 802 | Brome mosaic virus isolate BMV-B movement protein and coat protein (CP) genes, complete cds | blastn | 14865 | 734 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 16369133 | 16369133 | PRJNA315399_S_NODE_125273_length_168_cov_5.351145_g125072_i0 | PRJNA315399 | 125273 | 168 | 5.351145 | 8.9899236 | Potexvirus | 12176 | Viruses | Viruses | 305 | 9.81e-79 | NTclustered | gi|2106121581|gb|MW848530.1| | 112229 | g125072 | i0 | 99.405 | 49.9761904761905 | 168 | 1 | 100 | 0 | 1 | 168 | 1290 | 1123 | Pepino mosaic virus isolate NGSTPS18, complete genome | blastn | 8396 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 22060665 | 22060665 | PRJNA315399_S_NODE_11098_length_337_cov_8.966667_g10897_i0 | PRJNA315399 | 11098 | 337 | 8.966667 | 30.21766779 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 558 | 1.54e-154 | NTclustered | gi|2054359742|gb|MW248353.1| | 12188 | g10897 | i0 | 97.833 | 28.2077151335312 | 323 | 7 | 96 | 0 | 13 | 335 | 5843 | 5521 | White clover mosaic virus isolate DSMZ PV-0310 replication-associated protein (ORF1), triple gene block 1 protein (ORF2), triple gene block 2 protein (ORF3), triple gene block 3 protein (ORF4), and capsid protein (ORF5) genes, complete cds | blastn | 9506 | 558 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 22061103 | 22061103 | PRJNA315399_S_NODE_164678_length_157_cov_3.133333_g164477_i0 | PRJNA315399 | 164678 | 157 | 3.133333 | 4.91933281 | Wuhan aphid virus 2 | 1746068 | Viruses | Viruses | 187 | 3.3999999999999993e-43 | NTclustered | gi|943496531|gb|KR902726.1| | 1746068 | g164477 | i0 | 88.462 | 1.98726114649682 | 156 | 16 | 99 | 2 | 2 | 156 | 972 | 818 | Wuhan aphid virus 2 strain WHYC-2 segment 2, complete sequence | blastn | 312 | 187 | 1 | Viruses | Jingmenvirus group | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Wuhan aphid virus 2 | ||
| 24610447 | 24610447 | PRJNA315399_S_NODE_115000_length_172_cov_3.140741_g114799_i0 | PRJNA315399 | 115000 | 172 | 3.140741 | 5.40207452 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 313 | 5.989999999999998e-81 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g114799 | i0 | 99.419 | 100 | 172 | 1 | 100 | 0 | 1 | 172 | 3810 | 3639 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 17200 | 313 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci |
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);;