contig_metadata
20 rows where bioproject = "PRJNA715462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981841 | 1981841 | PRJNA715462_P_NODE_3522_length_1379_cov_6.535988_g3058_i0 | PRJNA715462 | 3522 | 1379 | 6.535988 | 90.13127452 | Nepovirus avii | 3047741 | Viruses | Viruses | 1029 | 0 | NTclustered | gi|1229202697|emb|LT883166.1| | 12615 | g3058 | i0 | 87.889 | 59.9260333575054 | 900 | 78 | 92 | 10 | 486 | 1379 | 5314 | 6188 | Cherry leaf roll virus Polyprotein 2 gene for polyprotein, 2A, 2B, movement protein, coat protein region, segment RNA2, isolate E327 | blastn | 82638 | 1029 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 1982601 | 1982601 | PRJNA715462_P_NODE_9802_length_682_cov_12.371100_g3058_i3 | PRJNA715462 | 9802 | 682 | 12.3711 | 84.370902 | Nepovirus avii | 3047741 | Viruses | Viruses | 998 | 0 | NTclustered | gi|2108668857|gb|MZ291951.1| | 12615 | g3058 | i3 | 93.235 | 83.0366568914956 | 680 | 43 | 99 | 3 | 2 | 678 | 6350 | 5671 | Cherry leaf roll virus isolate 19SP057 segment RNA2, complete sequence | blastn | 56631 | 998 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 3257780 | 3257780 | PRJNA715462_P_NODE_6823_length_887_cov_3.998771_g3058_i1 | PRJNA715462 | 6823 | 887 | 3.998771 | 35.46909877 | Nepovirus avii | 3047741 | Viruses | Viruses | 652 | 0 | NTclustered | gi|2073341497|gb|MW854282.1| | 12615 | g3058 | i1 | 92.06 | 29.2356257046223 | 466 | 34 | 98 | 2 | 407 | 870 | 6753 | 6289 | Cherry leaf roll virus isolate DSMZ PV-0797 segment RNA 1, partial sequence | blastn | 25932 | 652 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 4534327 | 4534327 | PRJNA715462_P_NODE_41024_length_278_cov_1.248780_g40228_i0 | PRJNA715462 | 41024 | 278 | 1.24878 | 3.4716084 | Nepovirus avii | 3047741 | Viruses | Viruses | 318 | 2.2899999999999995e-82 | NTclustered | gi|378406127|gb|JN104385.1| | 12615 | g40228 | i0 | 87.41 | 9.49640287769784 | 278 | 33 | 99 | 2 | 2 | 278 | 4378 | 4654 | Cherry leaf roll virus isolate Olm1 segment RNA2, complete sequence | blastn | 2640 | 318 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 4534388 | 4534388 | PRJNA715462_P_NODE_43844_length_269_cov_1.964286_g43048_i0 | PRJNA715462 | 43844 | 269 | 1.964286 | 5.28392934 | Nepovirus avii | 3047741 | Viruses | Viruses | 335 | 2.18e-87 | NTclustered | gi|1723623683|gb|MK402281.1| | 12615 | g43048 | i0 | 89.179 | 26.3011152416357 | 268 | 29 | 99 | 0 | 1 | 268 | 4829 | 4562 | Cherry leaf roll virus isolate CLRV_BpenGer407526 segment RNA1 putative polyprotein gene, partial cds | blastn | 7075 | 335 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 5810025 | 5810025 | PRJNA715462_P_NODE_63585_length_244_cov_0.900585_g62789_i0 | PRJNA715462 | 63585 | 244 | 0.900585 | 2.1974274 | Maculavirus vitis | 3047853 | Viruses | Viruses | 424 | 4.05e-114 | NTclustered | gi|2269685740|gb|ON567253.1| | 103722 | g62789 | i0 | 97.951 | 30.6475409836066 | 244 | 5 | 100 | 0 | 1 | 244 | 5538 | 5781 | Grapevine fleck virus isolate A1567c replicase (REP) and coat protein (CP) genes, complete cds; and hypothetical protein (ORF3) and hypothetical protein (ORF4) genes, partial cds | blastn | 7478 | 424 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Maculavirus vitis | ||
| 8359437 | 8359437 | PRJNA715462_P_NODE_49547_length_253_cov_1.688889_g48751_i0 | PRJNA715462 | 49547 | 253 | 1.688889 | 4.27288917 | Foveavirus rupestris | 3428812 | Viruses | Viruses | 462 | 8.95e-126 | NTclustered | gi|2289713684|gb|MZ484931.1| | 196400 | g48751 | i0 | 99.605 | 100.138339920949 | 253 | 1 | 100 | 0 | 1 | 253 | 8331 | 8583 | Grapevine rupestris stem pitting-associated virus isolate 16GVP043B, complete genome | blastn | 25335 | 462 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Foveavirus | Foveavirus rupestris | ||
| 13459727 | 13459727 | PRJNA715462_P_NODE_43451_length_271_cov_0.904040_g42655_i0 | PRJNA715462 | 43451 | 271 | 0.90404 | 2.4499484 | Maculavirus vitis | 3047853 | Viruses | Viruses | 468 | 2.08e-127 | NTclustered | gi|2269685798|gb|ON584185.1| | 103722 | g42655 | i0 | 97.786 | 83.8671586715867 | 271 | 6 | 100 | 0 | 1 | 271 | 5600 | 5330 | Grapevine fleck virus isolate A1587c, partial genome | blastn | 22728 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Maculavirus | Maculavirus vitis | ||
| 13460273 | 13460273 | PRJNA715462_P_NODE_8511_length_758_cov_7.430657_g3058_i2 | PRJNA715462 | 8511 | 758 | 7.430657 | 56.32438006 | Nepovirus avii | 3047741 | Viruses | Viruses | 1114 | 0 | NTclustered | gi|2520246190|gb|OQ731914.1| | 12615 | g3058 | i2 | 93.272 | 80.9406332453826 | 758 | 47 | 99 | 4 | 3 | 758 | 6833 | 7588 | Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA1, complete sequence | blastn | 61353 | 1114 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 14734131 | 14734131 | PRJNA715462_P_NODE_10412_length_655_cov_12.403780_g3058_i4 | PRJNA715462 | 10412 | 655 | 12.40378 | 81.244759 | Nepovirus avii | 3047741 | Viruses | Viruses | 957 | 0 | NTclustered | gi|2520246190|gb|OQ731914.1| | 12615 | g3058 | i4 | 93.364 | 81.7465648854962 | 648 | 42 | 99 | 1 | 5 | 651 | 7858 | 7211 | Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA1, complete sequence | blastn | 53544 | 957 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 17770019 | 17770019 | PRJNA715462_P_NODE_62814_length_244_cov_1.350877_g62018_i0 | PRJNA715462 | 62814 | 244 | 1.350877 | 3.29613988 | Viruses | 10239 | Viruses | Viruses | 440 | 4.019999999999999e-119 | NTclustered | gi|2177952863|gb|OL452263.1| | 2900479 | g62018 | i0 | 99.18 | 3.99590163934426 | 244 | 2 | 100 | 0 | 1 | 244 | 6480 | 6237 | MAG: Brine shrimp chuvirus 1 isolate CHN/15, complete genome | blastn | 975 | 440 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | brine shrimp chuvirus 1 | |||
| 18557424 | 18557424 | PRJNA715462_P_NODE_24455_length_366_cov_1.051195_g23659_i0 | PRJNA715462 | 24455 | 366 | 1.051195 | 3.8473737 | Nepovirus avii | 3047741 | Viruses | Viruses | 429 | 1.37e-115 | NTclustered | gi|2419396262|gb|ON924206.1| | 12615 | g23659 | i0 | 88.825 | 14.4535519125683 | 349 | 39 | 95 | 0 | 18 | 366 | 5734 | 5386 | Cherry leaf roll virus isolate DSMZ PV-0200 segment RNA 1, complete sequence | blastn | 5290 | 429 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 18557504 | 18557504 | PRJNA715462_P_NODE_27515_length_342_cov_1.427509_g26719_i0 | PRJNA715462 | 27515 | 342 | 1.427509 | 4.88208078 | Foveavirus rupestris | 3428812 | Viruses | Viruses | 632 | 9.079999999999999e-177 | NTclustered | gi|2289713751|gb|MZ484941.1| | 196400 | g26719 | i0 | 100 | 99.827485380117 | 342 | 0 | 100 | 0 | 1 | 342 | 8546 | 8205 | Grapevine rupestris stem pitting-associated virus isolate 16GVP057B, complete genome | blastn | 34141 | 632 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Foveavirus | Foveavirus rupestris | ||
| 22382722 | 22382722 | PRJNA715462_P_NODE_1038_length_2589_cov_13.558824_g845_i0 | PRJNA715462 | 1038 | 2589 | 13.558824 | 351.03795336 | brine shrimp chuvirus 1 | 2900479 | Viruses | Viruses | 95.3 | 4.4e-14 | NTclustered | gi|2177952885|gb|OL452274.1| | 2900479 | g845 | i0 | 90.278 | 0.166473541908073 | 72 | 7 | 3 | 0 | 2517 | 2588 | 7030 | 7101 | MAG: Brine shrimp chuvirus 1 isolate YC/91, complete genome | blastn | 431 | 95.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | brine shrimp chuvirus 1 | |||
| 27209811 | 27209811 | PRJNA715462_P_NODE_6942_length_877_cov_2.350746_g6255_i0 | PRJNA715462 | 6942 | 877 | 2.350746 | 20.61604242 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 332 | 3.28e-109 | NR | UNI74120.1 | 2900383 | g6255 | i0 | 55.5 | 0.968072976054732 | 283 | 126 | 96.8 | 0 | 876 | 28 | 85 | 367 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 849 | 332 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 29420161 | 29420161 | PRJNA715462_P_NODE_21689_length_394_cov_1.249221_g20893_i0 | PRJNA715462 | 21689 | 394 | 1.249221 | 4.92193074 | Lone star tick rhabdovirus | 1756186 | Viruses | Viruses | 67.8 | 3.3e-10 | NR | YP_010796342.1 | 1756186 | g20893 | i0 | 32.8 | 1.96446700507614 | 131 | 84 | 97.5 | 3 | 1 | 384 | 237 | 366 | YP_010796342.1 nucleoprotein [Lone star tick rhabdovirus] | diamond | 774 | 67.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lostrhavirus | Lostrhavirus lonestar | ||
| 31885098 | 31885098 | PRJNA715462_P_NODE_2657_length_1618_cov_2.382524_g2273_i0 | PRJNA715462 | 2657 | 1618 | 2.382524 | 38.54923832 | brine shrimp partitivirus 1 | 2900392 | Viruses | Viruses | 536 | 2.7999999999999996e-185 | NR | UNI73932.1 | 2900392 | g2273 | i0 | 60 | 1.68726823238566 | 430 | 166 | 79.7 | 1 | 1322 | 33 | 1 | 424 | UNI73932.1 MAG: coat protein [brine shrimp partitivirus 1] | diamond | 2730 | 536 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 1 | |||
| 32043416 | 32043416 | PRJNA715462_P_NODE_24078_length_369_cov_1.388514_g23282_i0 | PRJNA715462 | 24078 | 369 | 1.388514 | 5.12361666 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 74.3 | 5.24e-13 | NR | UNI74093.1 | 2900380 | g23282 | i0 | 76.6 | 0.382113821138211 | 47 | 11 | 38.2 | 0 | 1 | 141 | 133 | 179 | UNI74093.1 MAG: hypothetical protein [brine shrimp arlivirus 5] | diamond | 141 | 74.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 32738868 | 32738868 | PRJNA715462_P_NODE_55740_length_248_cov_1.114286_g54944_i0 | PRJNA715462 | 55740 | 248 | 1.114286 | 2.76342928 | Cherry leaf roll virus | 12615 | Viruses | Viruses | 145 | 4.19e-38 | NR | WWV46533.1 | 12615 | g54944 | i0 | 81.9 | 1.00403225806452 | 83 | 14 | 99.2 | 1 | 1 | 246 | 1956 | 2038 | WWV46533.1 MAG: polyprotein, partial [Cherry leaf roll virus] | diamond | 249 | 145 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 32864602 | 32864602 | PRJNA715462_P_NODE_39120_length_284_cov_0.853081_g38324_i0 | PRJNA715462 | 39120 | 284 | 0.853081 | 2.42275004 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 60.1 | 5.06e-8 | NR | UNI73808.1 | 2900455 | g38324 | i0 | 53.2 | 1.30985915492958 | 62 | 29 | 65.5 | 0 | 97 | 282 | 1935 | 1996 | UNI73808.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 3] | diamond | 372 | 60.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 |
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);;