contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25791273 | 25791273 | PRJEB20058_P_NODE_31131_length_752_cov_2.308249_g28639_i0 | PRJEB20058 | 31131 | 752 | 2.308249 | 17.35803248 | Sonemauk virus | 3131582 | Viruses | Viruses | 144 | 2.98e-35 | NR | WZH61623.1 | 3131582 | g28639 | i0 | 38.5 | 1.78723404255319 | 221 | 126 | 85.4 | 5 | 69 | 710 | 1069 | 1286 | WZH61623.1 MAG: RNA-dependent RNA polymerase [Sonemauk virus] | diamond | 1344 | 144 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Sonemauk virus | ||||
| 25928166 | 25928166 | PRJEB20058_P_NODE_4308_length_2186_cov_84.472471_g3531_i0 | PRJEB20058 | 4308 | 2186 | 84.472471 | 1846.56821606 | Erysiphe necator associated narnavirus 44 | 2736401 | Viruses | Viruses | 668 | 5.16e-230 | NR | QJT93776.1 | 2736401 | g3531 | i0 | 52.4 | 1.91720036596523 | 701 | 317 | 95 | 6 | 2124 | 49 | 1 | 693 | QJT93776.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 44] | diamond | 4191 | 668 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 44 | ||
| 26329952 | 26329952 | PRJEB20058_P_NODE_1199_length_4958_cov_18.301613_g932_i0 | PRJEB20058 | 1199 | 4958 | 18.301613 | 907.39397254 | Viruses | 10239 | Viruses | Viruses | 526 | 7.310000000000001e-154 | NR | XCO48968.1 | 1955144 | g932 | i0 | 51.7 | 3.25413473174667 | 489 | 234 | 29.5 | 2 | 4947 | 3487 | 1241 | 1729 | XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.] | diamond | 16134 | 528 | 0.996212121212121 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dicistroviridae sp. | |||
| 32928044 | 32928044 | PRJEB20058_P_NODE_19417_length_942_cov_2.770715_g17366_i0 | PRJEB20058 | 19417 | 942 | 2.770715 | 26.1001353 | Plasmopara viticola lesion associated mycobunyavirales-like virus 1 | 2689124 | Viruses | Viruses | 147 | 1.7199999999999998e-35 | NR | QGY72638.1 | 2689124 | g17366 | i0 | 34.3 | 0.993630573248408 | 312 | 185 | 93.6 | 8 | 2 | 883 | 615 | 924 | QGY72638.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mycobunyavirales-like virus 1] | diamond | 936 | 147 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Plasmopara viticola lesion associated mycobunyavirales-like virus 1 | ||||
| 32945427 | 32945427 | PRJEB20058_P_NODE_235602_length_224_cov_24.877301_g232777_i0 | PRJEB20058 | 235602 | 224 | 24.877301 | 55.72515424 | Leviviridae sp. | 2027243 | Viruses | Viruses | 77.8 | 1.29e-14 | NR | URG15527.1 | 2027243 | g232777 | i0 | 61.2 | 0.897321428571429 | 67 | 26 | 89.7 | 0 | 24 | 224 | 291 | 357 | URG15527.1 MAG: RNA dependent RNA polymerase [Leviviridae sp.] | diamond | 201 | 77.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 32962904 | 32962904 | PRJEB20058_P_NODE_54810_length_567_cov_27.339921_g52065_i0 | PRJEB20058 | 54810 | 567 | 27.339921 | 155.01735207 | Rhizoctonia cerealis bunyavirus | 3068840 | Viruses | Viruses | 56.6 | 6.96e-6 | NR | WMI40170.1 | 3068840 | g52065 | i0 | 26.3 | 0.804232804232804 | 152 | 105 | 79.9 | 2 | 45 | 497 | 84 | 229 | WMI40170.1 MAG: hypothetical protein [Rhizoctonia cerealis bunyavirus] | diamond | 456 | 56.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Rhizoctonia cerealis bunyavirus | ||||
| 32962935 | 32962935 | PRJEB20058_P_NODE_60458_length_539_cov_2.054393_g57698_i0 | PRJEB20058 | 60458 | 539 | 2.054393 | 11.07317827 | Equine rhinitis B virus 1 | 47001 | Viruses | Viruses | 58.5 | 2.01e-6 | NR | NP_740368.1 | 47001 | g57698 | i0 | 31.3 | 2.13729128014842 | 128 | 71 | 69 | 2 | 13 | 384 | 272 | 386 | NP_740368.1 3D (RNA polymerase) [Equine rhinitis B virus 1] | diamond | 1152 | 58.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Erbovirus | Erbovirus aequirhi | ||
| 32979963 | 32979963 | PRJEB20058_P_NODE_5459_length_1880_cov_276.865860_g4516_i0 | PRJEB20058 | 5459 | 1880 | 276.86586 | 5205.078168 | Qianjiang picorna-like virus 21 | 3348746 | Viruses | Viruses | 123 | 6.08e-25 | NR | XHA88474.1 | 3348746 | g4516 | i0 | 28.3 | 0.552127659574468 | 346 | 238 | 54.7 | 6 | 1849 | 821 | 2428 | 2766 | XHA88474.1 MAG: polyprotein [Qianjiang picorna-like virus 21] | diamond | 1038 | 123 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Qianjiang picorna-like virus 21 | ||||
| 33013644 | 33013644 | PRJEB20058_P_NODE_229780_length_232_cov_3.491228_g226955_i0 | PRJEB20058 | 229780 | 232 | 3.491228 | 8.09964896 | Sonemauk virus | 3131582 | Viruses | Viruses | 75.9 | 7.14e-14 | NR | WZH61623.1 | 3131582 | g226955 | i0 | 50.6 | 0.995689655172414 | 77 | 38 | 99.6 | 0 | 231 | 1 | 1150 | 1226 | WZH61623.1 MAG: RNA-dependent RNA polymerase [Sonemauk virus] | diamond | 231 | 75.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Sonemauk virus | ||||
| 33013839 | 33013839 | PRJEB20058_P_NODE_46812_length_615_cov_3.765343_g44113_i0 | PRJEB20058 | 46812 | 615 | 3.765343 | 23.15685945 | ssRNA phage SRR797631 | 2844826 | Viruses | Viruses | 126 | 1.18e-29 | NR | YP_010770674.1 | 2786676 | g44113 | i0 | 49.2 | 0.624390243902439 | 128 | 65 | 62.4 | 0 | 230 | 613 | 129 | 256 | YP_010770674.1 RNA-directed RNA polymerase [ssRNA phage SRR7976310_14] | diamond | 384 | 126 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Henifovirus | Henifovirus sp. 'caenadaptatum' | ||
| 33030920 | 33030920 | PRJEB20058_P_NODE_30508_length_759_cov_30.325215_g28033_i0 | PRJEB20058 | 30508 | 759 | 30.325215 | 230.16838185 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 125 | 1.47e-28 | NR | WLN26256.1 | 3065075 | g28033 | i0 | 44.1 | 0.573122529644269 | 145 | 81 | 57.3 | 0 | 736 | 302 | 90 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 435 | 125 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 33059575 | 33059575 | PRJEB20058_P_NODE_5733_length_1820_cov_12.065378_g4749_i0 | PRJEB20058 | 5733 | 1820 | 12.065378 | 219.5898796 | Viruses | 10239 | Viruses | Viruses | 116 | 7.42e-23 | NR | WFS39126.1 | 3038626 | g4749 | i0 | 26.9 | 1.72912087912088 | 350 | 195 | 56.7 | 9 | 759 | 1790 | 65 | 359 | WFS39126.1 MAG: putative replicase polyprotein [StochSRVP_1 picorna-like virus] | diamond | 3147 | 116 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | StochSRVP_1 picorna-like virus | |||
| 33065274 | 33065274 | PRJEB20058_P_NODE_8621_length_1433_cov_44.546647_g7316_i0 | PRJEB20058 | 8621 | 1433 | 44.546647 | 638.35345151 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 245 | 2.2799999999999999e-69 | NR | QDH87375.1 | 3003959 | g7316 | i0 | 37.9 | 3.28053035589672 | 398 | 230 | 81.9 | 10 | 1411 | 239 | 334 | 721 | QDH87375.1 MAG: hypothetical protein H3RhizoLitter1458_000001 [Picornavirales sp.] | diamond | 4701 | 245 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 33076598 | 33076598 | PRJEB20058_P_NODE_48501_length_604_cov_1.994475_g45788_i0 | PRJEB20058 | 48501 | 604 | 1.994475 | 12.046629 | Viruses | 10239 | Viruses | Viruses | 230 | 7.2e-66 | NR | QYF50205.1 | 2824532 | g45788 | i0 | 53.9 | 1.7682119205298 | 178 | 82 | 88.4 | 0 | 23 | 556 | 233 | 410 | QYF50205.1 MAG: polyprotein, partial [Sichuan deltaflexi-like virus 1] | diamond | 1068 | 232 | 0.991379310344828 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Sichuan deltaflexi-like virus 1 | |||
| 33099161 | 33099161 | PRJEB20058_P_NODE_47998_length_607_cov_4.179487_g45287_i0 | PRJEB20058 | 47998 | 607 | 4.179487 | 25.36948609 | Sclerotinia sclerotiorum deltaflexivirus 1 | 1788309 | Viruses | Viruses | 75.9 | 2.64e-13 | NR | UOJ41055.1 | 1788309 | g45287 | i0 | 59 | 0.602965403624382 | 61 | 25 | 30.1 | 0 | 27 | 209 | 71 | 131 | UOJ41055.1 hypothetical protein [Sclerotinia sclerotiorum deltaflexivirus 1] | diamond | 366 | 75.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Deltaflexivirus sclerotiniae | ||
| 33115322 | 33115322 | PRJEB20058_P_NODE_116503_length_371_cov_5.167742_g113688_i0 | PRJEB20058 | 116503 | 371 | 5.167742 | 19.17232282 | Hangzhou mitovirus 6 | 2905241 | Viruses | Viruses | 112 | 8.51e-26 | NR | UHK03232.1 | 2905241 | g113688 | i0 | 50.4 | 2.88679245283019 | 123 | 56 | 99.5 | 2 | 1 | 369 | 380 | 497 | UHK03232.1 MAG: RNA-dependent RNA polymerase [Hangzhou mitovirus 6] | diamond | 1071 | 112 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Hangzhou mitovirus 6 | ||
| 33161801 | 33161801 | PRJEB20058_P_NODE_188976_length_266_cov_3.121951_g186152_i0 | PRJEB20058 | 188976 | 266 | 3.121951 | 8.30438966 | Durnavirales | 2732549 | Viruses | Viruses | 125 | 1.45e-33 | NR | AIS37549.1 | 1551557 | g186152 | i0 | 80 | 2.75187969924812 | 80 | 16 | 90.2 | 0 | 26 | 265 | 148 | 227 | AIS37549.1 hypothetical protein, partial [Valsa cypri partitivirus] | diamond | 732 | 125 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Valsa cypri partitivirus |
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);;