contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA812001" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 810394 | 810394 | PRJNA812001_P_NODE_14001_length_430_cov_5.156863_g13755_i0 | PRJNA812001 | 14001 | 430 | 5.156863 | 22.1745109 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.041 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g13755 | i0 | 100 | 0.0651162790697674 | 28 | 0 | 7 | 0 | 1 | 28 | 7 | 34 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 3361964 | 3361964 | PRJNA812001_P_NODE_9483_length_508_cov_1.593103_g9237_i0 | PRJNA812001 | 9483 | 508 | 1.593103 | 8.09296324 | Alphafusarivirus fusarii | 2955263 | Viruses | Viruses | 887 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g9237 | i0 | 98.225 | 6.66338582677165 | 507 | 9 | 99 | 0 | 2 | 508 | 2174 | 1668 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 3385 | 887 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 3776409 | 3776409 | PRJNA812001_P_NODE_743_length_1549_cov_2.595528_g647_i0 | PRJNA812001 | 743 | 1549 | 2.595528 | 40.20472872 | Alphafusarivirus | 2946790 | Viruses | Viruses | 2772 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g647 | i0 | 98.967 | 6.14267269205939 | 1549 | 16 | 100 | 0 | 1 | 1549 | 3991 | 2443 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 9515 | 2772 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 5914222 | 5914222 | PRJNA812001_P_NODE_56185_length_280_cov_10.382436_g55939_i0 | PRJNA812001 | 56185 | 280 | 10.382436 | 29.0708208 | Tonghua Botou tick virus 2 | 2972055 | Viruses | Viruses | 494 | 3.57e-135 | NTclustered | gi|2819062441|gb|PQ150489.1| | 2972055 | g55939 | i0 | 98.566 | 6.9 | 279 | 4 | 99 | 0 | 1 | 279 | 2003 | 2281 | MAG: Tonghua Botou tick virus 2 isolate Beijing_119 genomic sequence | blastn | 1932 | 494 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Tonghua Botou tick virus 2 | |||
| 5914344 | 5914344 | PRJNA812001_P_NODE_72985_length_258_cov_1.248649_g72739_i0 | PRJNA812001 | 72985 | 258 | 1.248649 | 3.22151442 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 466 | 7.08e-127 | NTclustered | gi|90968201|emb|AM236036.1| | 12178 | g72739 | i0 | 99.225 | 11.2209302325581 | 258 | 2 | 100 | 0 | 1 | 258 | 283 | 26 | Cymbidium mosaic virus partial RdRp gene for RNA-dependent RNA polymerase, isolate FRA07, genomic RNA | blastn | 2895 | 466 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 7189070 | 7189070 | PRJNA812001_P_NODE_61246_length_273_cov_4.155000_g61000_i0 | PRJNA812001 | 61246 | 273 | 4.155 | 11.34315 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g61000 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 246 | 273 | 34 | 7 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 9739082 | 9739082 | PRJNA812001_P_NODE_75668_length_254_cov_1.701657_g75422_i0 | PRJNA812001 | 75668 | 254 | 1.701657 | 4.32220878 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 459 | 1.1599999999999999e-124 | NTclustered | gi|939193298|gb|KR185347.1| | 12178 | g75422 | i0 | 99.213 | 28.9606299212598 | 254 | 2 | 100 | 0 | 1 | 254 | 4747 | 4494 | Cymbidium mosaic virus isolate China, complete genome | blastn | 7356 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 9739161 | 9739161 | PRJNA812001_P_NODE_8_length_6187_cov_10.969905_g3_i0 | PRJNA812001 | 8 | 6187 | 10.969905 | 678.70802235 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 11326 | 0 | NTclustered | gi|1964785387|gb|MT833930.1| | 12178 | g3 | i0 | 99.709 | 35.9754323581704 | 6187 | 18 | 100 | 0 | 1 | 6187 | 6198 | 12 | Cymbidium mosaic virus isolate Chenshan, complete genome | blastn | 222580 | 11326 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 11014680 | 11014680 | PRJNA812001_P_NODE_47649_length_293_cov_9.000000_g47403_i0 | PRJNA812001 | 47649 | 293 | 9 | 26.37 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g47403 | i0 | 100 | 0.194539249146758 | 29 | 0 | 10 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 16527270 | 16527270 | PRJNA812001_P_NODE_8293_length_540_cov_1.800857_g8048_i0 | PRJNA812001 | 8293 | 540 | 1.800857 | 9.7246278 | Alphafusarivirus | 2946790 | Viruses | Viruses | 965 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g8048 | i0 | 98.889 | 5 | 540 | 6 | 100 | 0 | 1 | 540 | 1253 | 714 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 2700 | 970 | 0.994845360824742 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 18661989 | 18661989 | PRJNA812001_P_NODE_25075_length_353_cov_1.650000_g24829_i0 | PRJNA812001 | 25075 | 353 | 1.65 | 5.8245 | Fusarium pseudograminearum fusarivirus 1 | 3036235 | Viruses | Viruses | 647 | 0 | NTclustered | gi|2463884872|gb|OP100308.1| | 3036235 | g24829 | i0 | 99.717 | 7 | 353 | 1 | 100 | 0 | 1 | 353 | 1631 | 1279 | Fusarium pseudograminearum fusarivirus 1 isolate ZZ-1, complete genome | blastn | 2471 | 647 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Fusarium pseudograminearum fusarivirus 1 | |||
| 18662255 | 18662255 | PRJNA812001_P_NODE_51255_length_287_cov_5.294393_g51009_i0 | PRJNA812001 | 51255 | 287 | 5.294393 | 15.19490791 | Skokie picorna-like virus | 2789431 | Viruses | Viruses | 414 | 2.94e-111 | NTclustered | gi|1935607038|gb|MT747994.1| | 2789431 | g51009 | i0 | 92.683 | 3.07665505226481 | 287 | 21 | 100 | 0 | 1 | 287 | 8110 | 7824 | Skokie picorna-like virus strain USAdp-2 polyprotein gene, complete cds | blastn | 883 | 414 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Skokie picorna-like virus | ||||
| 19937671 | 19937671 | PRJNA812001_P_NODE_8376_length_537_cov_4.818966_g8131_i0 | PRJNA812001 | 8376 | 537 | 4.818966 | 25.87784742 | Skokie picorna-like virus | 2789431 | Viruses | Viruses | 383 | 1.6499999999999996e-101 | NTclustered | gi|1935607038|gb|MT747994.1| | 2789431 | g8131 | i0 | 89.216 | 1.70763500931099 | 306 | 33 | 57 | 0 | 232 | 537 | 8356 | 8051 | Skokie picorna-like virus strain USAdp-2 polyprotein gene, complete cds | blastn | 917 | 383 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Skokie picorna-like virus | ||||
| 21212668 | 21212668 | PRJNA812001_P_NODE_28297_length_341_cov_2.317164_g28051_i0 | PRJNA812001 | 28297 | 341 | 2.317164 | 7.90152924 | Alphafusarivirus fusarii | 2955263 | Viruses | Viruses | 608 | 1.5199999999999993e-169 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g28051 | i0 | 98.827 | 5.99706744868035 | 341 | 4 | 100 | 0 | 1 | 341 | 4355 | 4015 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 2045 | 608 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 21212741 | 21212741 | PRJNA812001_P_NODE_35277_length_321_cov_1.241935_g35031_i0 | PRJNA812001 | 35277 | 321 | 1.241935 | 3.98661135 | Potexvirus cymbidii | 3433819 | Viruses | Viruses | 593 | 3.9899999999999986e-165 | NTclustered | gi|284002549|dbj|AB541545.1| | 12178 | g35031 | i0 | 100 | 99.981308411215 | 321 | 0 | 100 | 0 | 1 | 321 | 441 | 121 | Cymbidium mosaic virus CP gene for coat protein, complete cds, strain: CYK12 | blastn | 32094 | 593 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus cymbidii | ||
| 22487361 | 22487361 | PRJNA812001_P_NODE_2698_length_921_cov_2.498821_g2496_i0 | PRJNA812001 | 2698 | 921 | 2.498821 | 23.01414141 | Carpotroche-associated picornavirus | 2975512 | Viruses | Viruses | 1435 | 0 | NTclustered | gi|2292905076|gb|OL964097.1| | 2975512 | g2496 | i0 | 94.788 | 2.98479913137894 | 921 | 48 | 100 | 0 | 1 | 921 | 7845 | 6925 | Carpotroche-associated picornavirus polyprotein gene, complete cds | blastn | 2749 | 1435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Carpotroche-associated picornavirus | |||
| 23763051 | 23763051 | PRJNA812001_P_NODE_2299_length_992_cov_14.678999_g2106_i0 | PRJNA812001 | 2299 | 992 | 14.678999 | 145.61567008 | Tonghua Botou tick virus 2 | 2972055 | Viruses | Viruses | 1622 | 0 | NTclustered | gi|2819062441|gb|PQ150489.1| | 2972055 | g2106 | i0 | 96.169 | 2.0383064516129 | 992 | 38 | 100 | 0 | 1 | 992 | 1011 | 2002 | MAG: Tonghua Botou tick virus 2 isolate Beijing_119 genomic sequence | blastn | 2022 | 1622 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Tonghua Botou tick virus 2 | |||
| 23763072 | 23763072 | PRJNA812001_P_NODE_24619_length_355_cov_2.631206_g24373_i0 | PRJNA812001 | 24619 | 355 | 2.631206 | 9.3407813 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g24373 | i0 | 100 | 0.0788732394366197 | 28 | 0 | 8 | 0 | 328 | 355 | 41 | 14 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 23763142 | 23763142 | PRJNA812001_P_NODE_30719_length_333_cov_3.615385_g30473_i0 | PRJNA812001 | 30719 | 333 | 3.615385 | 12.03923205 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 1.88e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g30473 | i0 | 97.222 | 0.198198198198198 | 36 | 0 | 11 | 1 | 1 | 35 | 8 | 43 | Carnation latent virus isolate KL, complete genome | blastn | 66 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24176001 | 24176001 | PRJNA812001_P_NODE_219_length_2271_cov_4.098726_g168_i0 | PRJNA812001 | 219 | 2271 | 4.098726 | 93.08206746 | Alphafusarivirus | 2946790 | Viruses | Viruses | 4082 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g168 | i0 | 99.119 | 6.35094671950683 | 2271 | 19 | 99 | 1 | 1 | 2270 | 4346 | 6616 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 14423 | 4082 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii | ||
| 25451162 | 25451162 | PRJNA812001_P_NODE_7660_length_560_cov_2.322382_g7415_i0 | PRJNA812001 | 7660 | 560 | 2.322382 | 13.0053392 | Alphafusarivirus | 2946790 | Viruses | Viruses | 1018 | 0 | NTclustered | gi|1861288152|gb|MT024571.1| | 194397 | g7415 | i0 | 99.464 | 5.95535714285714 | 560 | 3 | 100 | 0 | 1 | 560 | 598 | 39 | Fusarium graminearum dsRNA mycovirus-1 isolate HB56-9, complete genome | blastn | 3335 | 1018 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Alphafusarivirus | Alphafusarivirus fusarii |
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);;