contig_metadata
22 rows where bioproject = "PRJNA356682" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4225206 | 4225206 | PRJNA356682_P_NODE_5104_length_627_cov_4.009025_g4428_i0 | PRJNA356682 | 5104 | 627 | 4.009025 | 25.13658675 | Sonabek virus | 3131524 | Viruses | Viruses | 342 | 3.3e-89 | NTclustered | gi|2717322744|gb|PP173825.1| | 3131524 | g4428 | i0 | 83.161 | 0.615629984051037 | 386 | 54 | 61 | 11 | 191 | 571 | 846 | 467 | MAG: Sonabek virus isolate SN1_k141_109124 genomic sequence | blastn | 386 | 342 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sonabek virus | |||
| 8051159 | 8051159 | PRJNA356682_P_NODE_42487_length_243_cov_2.094118_g41796_i0 | PRJNA356682 | 42487 | 243 | 2.094118 | 5.08870674 | Chrocagosk virus | 3129397 | Viruses | Viruses | 161 | 3.4899999999999997e-35 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g41796 | i0 | 79.297 | 1.19341563786008 | 256 | 33 | 100 | 13 | 1 | 243 | 546 | 298 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 290 | 161 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 11876621 | 11876621 | PRJNA356682_P_NODE_46330_length_230_cov_2.484076_g45639_i0 | PRJNA356682 | 46330 | 230 | 2.484076 | 5.7133748 | Sopawol virus | 3131668 | Viruses | Viruses | 370 | 4.99e-98 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g45639 | i0 | 95.652 | 121.8 | 230 | 10 | 100 | 0 | 1 | 230 | 6 | 235 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 28014 | 370 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 13150914 | 13150914 | PRJNA356682_P_NODE_13251_length_387_cov_1.942675_g12561_i0 | PRJNA356682 | 13251 | 387 | 1.942675 | 7.51815225 | Sonabek virus | 3131524 | Viruses | Viruses | 590 | 6.329999999999998e-164 | NTclustered | gi|2717322744|gb|PP173825.1| | 3131524 | g12561 | i0 | 94.315 | 1 | 387 | 18 | 99 | 4 | 3 | 386 | 414 | 799 | MAG: Sonabek virus isolate SN1_k141_109124 genomic sequence | blastn | 387 | 590 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sonabek virus | |||
| 18249556 | 18249556 | PRJNA356682_P_NODE_44215_length_241_cov_2.750000_g43524_i0 | PRJNA356682 | 44215 | 241 | 2.75 | 6.6275 | Tolivirales sp. | 2809914 | Viruses | Viruses | 335 | 1.9199999999999993e-87 | NTclustered | gi|2647549416|gb|OR843641.1| | 2809914 | g43524 | i0 | 91.701 | 1 | 241 | 20 | 100 | 0 | 1 | 241 | 3967 | 3727 | Tolivirales sp. strain MR233-17E/1966 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds; and hypothetical protein gene, complete cds | blastn | 241 | 335 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 22074261 | 22074261 | PRJNA356682_P_NODE_34878_length_254_cov_1.558011_g34187_i0 | PRJNA356682 | 34878 | 254 | 1.558011 | 3.95734794 | Tolivirales sp. | 2809914 | Viruses | Viruses | 436 | 5.45e-118 | NTclustered | gi|2647549416|gb|OR843641.1| | 2809914 | g34187 | i0 | 97.638 | 1 | 254 | 6 | 100 | 0 | 1 | 254 | 1772 | 1519 | Tolivirales sp. strain MR233-17E/1966 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds; and hypothetical protein gene, complete cds | blastn | 254 | 436 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 26726267 | 26726267 | PRJNA356682_P_NODE_40701_length_245_cov_2.255814_g40010_i0 | PRJNA356682 | 40701 | 245 | 2.255814 | 5.5267443 | Sonabek virus | 3131524 | Viruses | Viruses | 48.9 | 1.2e-4 | NR | WZH61556.1 | 3131524 | g40010 | i0 | 74.4 | 0.477551020408163 | 39 | 10 | 47.8 | 0 | 131 | 15 | 41 | 79 | WZH61556.1 MAG: hypothetical protein [Sonabek virus] | diamond | 117 | 48.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sonabek virus | |||
| 27454265 | 27454265 | PRJNA356682_P_NODE_18203_length_336_cov_1.543726_g17512_i0 | PRJNA356682 | 18203 | 336 | 1.543726 | 5.18691936 | ssRNA phage SRR5467 | 2845702 | Viruses | Viruses | 50.4 | 1.98e-4 | NR | YP_010770102.1 | 2786474 | g17512 | i0 | 35.2 | 0.633928571428571 | 71 | 46 | 63.4 | 0 | 2 | 214 | 321 | 391 | YP_010770102.1 maturation protein [ssRNA phage SRR5467091_9] | diamond | 213 | 50.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Oekfovirus | Oekfovirus sp. 'lutivicinum' | ||
| 27864403 | 27864403 | PRJNA356682_P_NODE_35205_length_253_cov_1.377778_g34514_i0 | PRJNA356682 | 35205 | 253 | 1.377778 | 3.48577834 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 52.4 | 1.77e-5 | NR | WLN26256.1 | 3065075 | g34514 | i0 | 52.4 | 1.39920948616601 | 42 | 20 | 49.8 | 0 | 252 | 127 | 193 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 354 | 52.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 28148821 | 28148821 | PRJNA356682_P_NODE_3185_length_817_cov_4.658602_g2565_i0 | PRJNA356682 | 3185 | 817 | 4.658602 | 38.06077834 | Beihai sipunculid worm virus 6 | 1922678 | Viruses | Viruses | 114 | 2.5699999999999997e-24 | NR | YP_009333562.1 | 1922678 | g2565 | i0 | 35.2 | 0.793145654834761 | 216 | 127 | 77.5 | 5 | 817 | 185 | 535 | 742 | YP_009333562.1 polyprotein [Beihai sipunculid worm virus 6] | diamond | 648 | 114 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Deltahypovirus | Deltahypovirus sipunculidi | ||
| 28180058 | 28180058 | PRJNA356682_P_NODE_43806_length_242_cov_0.911243_g43115_i0 | PRJNA356682 | 43806 | 242 | 0.911243 | 2.20520806 | ssRNA phage ESE | 3430437 | Viruses | Viruses | 138 | 3.3e-36 | NR | YP_010769154.1 | 2786005 | g43115 | i0 | 78.8 | 0.991735537190083 | 80 | 17 | 99.2 | 0 | 242 | 3 | 442 | 521 | YP_010769154.1 RNA-directed RNA polymerase [ssRNA phage ESE029] | diamond | 240 | 138 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Lohngkovirus | Lohngkovirus defluviicola | ||
| 28180060 | 28180060 | PRJNA356682_P_NODE_906_length_1678_cov_7.350779_g569_i0 | PRJNA356682 | 906 | 1678 | 7.350779 | 123.34607162 | Sichuan sediment hypo-like virus 1 | 2824573 | Viruses | Viruses | 325 | 1.24e-95 | NR | QYF49601.1 | 2824573 | g569 | i0 | 34.3 | 1.99165673420739 | 571 | 354 | 99.6 | 8 | 6 | 1676 | 180 | 743 | QYF49601.1 MAG: polyprotein, partial [Sichuan sediment hypo-like virus 1] | diamond | 3342 | 325 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Sichuan sediment hypo-like virus 1 | |||
| 28386784 | 28386784 | PRJNA356682_P_NODE_3086_length_831_cov_8.138522_g2473_i0 | PRJNA356682 | 3086 | 831 | 8.138522 | 67.63111782 | Deltahypovirus | 2948675 | Viruses | Viruses | 145 | 2.8099999999999997e-35 | NR | YP_009333562.1 | 1922678 | g2473 | i0 | 35.9 | 1.88086642599278 | 259 | 156 | 93.1 | 7 | 7 | 780 | 2379 | 2628 | YP_009333562.1 polyprotein [Beihai sipunculid worm virus 6] | diamond | 1563 | 145 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Deltahypovirus | Deltahypovirus sipunculidi | ||
| 29127700 | 29127700 | PRJNA356682_P_NODE_15569_length_359_cov_6.076923_g14879_i0 | PRJNA356682 | 15569 | 359 | 6.076923 | 21.81615357 | Henan cystovirus 3 | 2824305 | Viruses | Viruses | 43.9 | 0.048 | NR | QYF49798.1 | 2824305 | g14879 | i0 | 41.2 | 0.568245125348189 | 68 | 35 | 55.2 | 2 | 344 | 147 | 203 | 267 | QYF49798.1 MAG: hypothetical protein 2 [Henan cystovirus 3] | diamond | 204 | 43.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Henan cystovirus 3 | ||
| 29917051 | 29917051 | PRJNA356682_P_NODE_2251_length_1001_cov_14.232759_g1701_i0 | PRJNA356682 | 2251 | 1001 | 14.232759 | 142.46991759 | Ripuglab virus | 3130501 | Viruses | Viruses | 107 | 1.7e-21 | NR | WZH59752.1 | 3130501 | g1701 | i0 | 30.2 | 0.743256743256743 | 248 | 158 | 71.9 | 7 | 967 | 248 | 388 | 628 | WZH59752.1 MAG: RNA-dependent RNA polymerase [Ripuglab virus] | diamond | 744 | 107 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Ripuglab virus | |||
| 30517167 | 30517167 | PRJNA356682_P_NODE_27733_length_280_cov_10.159420_g27042_i0 | PRJNA356682 | 27733 | 280 | 10.15942 | 28.446376 | Yunnan farmland cysto-like virus | 2824594 | Viruses | Viruses | 53.5 | 9.33e-6 | NR | QYF49822.1 | 2824594 | g27042 | i0 | 37.3 | 1.85357142857143 | 83 | 44 | 88.9 | 1 | 25 | 273 | 254 | 328 | QYF49822.1 MAG: putative RNA-dependent RNA polymerase [Yunnan farmland cysto-like virus] | diamond | 519 | 53.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Yunnan farmland cysto-like virus | |||
| 30548726 | 30548726 | PRJNA356682_P_NODE_6913_length_535_cov_5.138528_g6226_i0 | PRJNA356682 | 6913 | 535 | 5.138528 | 27.4911248 | Jiangsu sediment hypo-like virus 2 | 2824572 | Viruses | Viruses | 66.6 | 3.92e-9 | NR | QYF49615.1 | 2824572 | g6226 | i0 | 31.5 | 0.71214953271028 | 127 | 78 | 67.3 | 5 | 66 | 425 | 1114 | 1238 | QYF49615.1 MAG: polyprotein [Jiangsu sediment hypo-like virus 2] | diamond | 381 | 66.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Jiangsu sediment hypo-like virus 2 | |||
| 31686630 | 31686630 | PRJNA356682_P_NODE_8877_length_469_cov_3.174242_g8188_i0 | PRJNA356682 | 8877 | 469 | 3.174242 | 14.88719498 | Qianjiang levi-like virus 15 | 3348422 | Viruses | Viruses | 49.7 | 0.00126 | NR | XHA87311.1 | 3348422 | g8188 | i0 | 40 | 0.479744136460554 | 75 | 39 | 44.8 | 2 | 108 | 317 | 1 | 74 | XHA87311.1 MAG: putative phage maturation protein [Qianjiang levi-like virus 15] | diamond | 225 | 49.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Qianjiang levi-like virus 15 | |||||
| 31749824 | 31749824 | PRJNA356682_P_NODE_6837_length_538_cov_4.634409_g6151_i0 | PRJNA356682 | 6837 | 538 | 4.634409 | 24.93312042 | Ripujyp virus | 3130530 | Viruses | Viruses | 97.1 | 6.2600000000000005e-21 | NR | WZH59806.1 | 3130530 | g6151 | i0 | 31 | 1.04275092936803 | 187 | 120 | 99.3 | 1 | 3 | 536 | 30 | 216 | WZH59806.1 MAG: RNA-dependent RNA polymerase, partial [Ripujyp virus] | diamond | 561 | 97.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Ripujyp virus | |||
| 31876367 | 31876367 | PRJNA356682_P_NODE_10537_length_431_cov_1.656425_g9847_i0 | PRJNA356682 | 10537 | 431 | 1.656425 | 7.13919175 | ssRNA phage SRR5467 | 2845702 | Viruses | Viruses | 102 | 2.25e-22 | NR | YP_010770102.1 | 2786474 | g9847 | i0 | 39.3 | 0.939675174013921 | 135 | 81 | 94 | 1 | 2 | 406 | 189 | 322 | YP_010770102.1 maturation protein [ssRNA phage SRR5467091_9] | diamond | 405 | 102 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Solspiviridae | Oekfovirus | Oekfovirus sp. 'lutivicinum' | ||
| 32382760 | 32382760 | PRJNA356682_P_NODE_1079_length_1513_cov_4.670139_g697_i0 | PRJNA356682 | 1079 | 1513 | 4.670139 | 70.65920307 | Yunnan sediment hypo-like virus | 2824570 | Viruses | Viruses | 455 | 2.2199999999999993e-152 | NR | QYF49612.1 | 2824570 | g697 | i0 | 54.1 | 0.876404494382023 | 442 | 201 | 87.4 | 2 | 191 | 1513 | 86 | 526 | QYF49612.1 MAG: polyprotein, partial [Yunnan sediment hypo-like virus] | diamond | 1326 | 455 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Yunnan sediment hypo-like virus | |||
| 32792714 | 32792714 | PRJNA356682_P_NODE_10000_length_442_cov_3.907859_g9310_i0 | PRJNA356682 | 10000 | 442 | 3.907859 | 17.27273678 | Leviviridae sp. | 2027243 | Viruses | Viruses | 103 | 1.08e-22 | NR | URG15324.1 | 2027243 | g9310 | i0 | 46.5 | 0.773755656108597 | 114 | 61 | 77.4 | 0 | 87 | 428 | 88 | 201 | URG15324.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 342 | 103 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. |
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);;