contig_metadata
22 rows where bioproject = "PRJNA1074407" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188218 | 188218 | PRJNA1074407_P_NODE_112241_length_309_cov_0.966102_g108403_i0 | PRJNA1074407 | 112241 | 309 | 0.966102 | 2.98525518 | Alphaendornavirus miphaseoli | 3426181 | Viruses | Viruses | 468 | 2.42e-127 | NTclustered | gi|2334239746|gb|OM100070.1| | 2268393 | g108403 | i0 | 94.137 | 1.94174757281553 | 307 | 18 | 99 | 0 | 3 | 309 | 3775 | 3469 | Phaseolus vulgaris endornavirus 3 isolate KK072 polyprotein gene, complete cds | blastn | 600 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus miphaseoli | ||
| 1463161 | 1463161 | PRJNA1074407_P_NODE_128242_length_266_cov_0.906736_g124404_i0 | PRJNA1074407 | 128242 | 266 | 0.906736 | 2.41191776 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 486 | 5.629999999999999e-133 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g124404 | i0 | 99.624 | 12.9774436090226 | 266 | 1 | 100 | 0 | 1 | 266 | 13531 | 13266 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 3452 | 486 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 1464313 | 1464313 | PRJNA1074407_P_NODE_43142_length_780_cov_1.763791_g39549_i0 | PRJNA1074407 | 43142 | 780 | 1.763791 | 13.7575698 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 928 | 0 | NTclustered | gi|2697475145|gb|PP215170.1| | 3132532 | g39549 | i0 | 88.175 | 0.997435897435897 | 778 | 92 | 99 | 0 | 3 | 780 | 6930 | 7707 | Macrobrachium rosenbergii hepe-like virus 3 isolate 01/JS/202106 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 778 | 928 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-like virus 3 | |||
| 2738910 | 2738910 | PRJNA1074407_P_NODE_116423_length_297_cov_1.241071_g112585_i0 | PRJNA1074407 | 116423 | 297 | 1.241071 | 3.68598087 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 538 | 1.74e-148 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g112585 | i0 | 99.327 | 12.993265993266 | 297 | 2 | 100 | 0 | 1 | 297 | 12695 | 12399 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 3859 | 538 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 7841442 | 7841442 | PRJNA1074407_P_NODE_140627_length_245_cov_0.883721_g136789_i0 | PRJNA1074407 | 140627 | 245 | 0.883721 | 2.16511645 | Alphaendornavirus phaseoli | 3426184 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|1243012353|gb|MF281670.1| | 1188792 | g136789 | i0 | 100 | 16.9959183673469 | 245 | 0 | 100 | 0 | 1 | 245 | 8886 | 8642 | Phaseolus vulgaris alphaendornavirus 1 isolate SRF36 polyprotein gene, partial cds | blastn | 4164 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus phaseoli | ||
| 9115855 | 9115855 | PRJNA1074407_P_NODE_110988_length_313_cov_0.829167_g107150_i0 | PRJNA1074407 | 110988 | 313 | 0.829167 | 2.59529271 | Alphaendornavirus phaseoli | 3426184 | Viruses | Viruses | 573 | 5.049999999999998e-159 | NTclustered | gi|1243012353|gb|MF281670.1| | 1188792 | g107150 | i0 | 99.681 | 17 | 313 | 1 | 100 | 0 | 1 | 313 | 9011 | 9323 | Phaseolus vulgaris alphaendornavirus 1 isolate SRF36 polyprotein gene, partial cds | blastn | 5321 | 573 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus phaseoli | ||
| 10391473 | 10391473 | PRJNA1074407_P_NODE_109009_length_319_cov_0.926829_g105171_i0 | PRJNA1074407 | 109009 | 319 | 0.926829 | 2.95658451 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 579 | 1.1099999999999996e-160 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g105171 | i0 | 99.373 | 12.9968652037618 | 319 | 2 | 100 | 0 | 1 | 319 | 11595 | 11277 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 4146 | 579 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 10391614 | 10391614 | PRJNA1074407_P_NODE_116149_length_298_cov_1.004444_g112311_i0 | PRJNA1074407 | 116149 | 298 | 1.004444 | 2.99324312 | Alphaendornavirus phaseoli | 3426184 | Viruses | Viruses | 540 | 4.85e-149 | NTclustered | gi|2562627221|gb|OQ750684.1| | 1188792 | g112311 | i0 | 99.329 | 17 | 298 | 2 | 100 | 0 | 1 | 298 | 3467 | 3170 | Phaseolus vulgaris alphaendornavirus 1 isolate PV2 polyprotein gene, complete cds | blastn | 5066 | 540 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus phaseoli | ||
| 10391662 | 10391662 | PRJNA1074407_P_NODE_118929_length_290_cov_1.391705_g115091_i0 | PRJNA1074407 | 118929 | 290 | 1.391705 | 4.0359445 | Alphaendornavirus miphaseoli | 3426181 | Viruses | Viruses | 436 | 6.349999999999999e-118 | NTclustered | gi|2334239746|gb|OM100070.1| | 2268393 | g115091 | i0 | 93.793 | 2 | 290 | 18 | 100 | 0 | 1 | 290 | 4577 | 4866 | Phaseolus vulgaris endornavirus 3 isolate KK072 polyprotein gene, complete cds | blastn | 580 | 436 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus miphaseoli | ||
| 11666765 | 11666765 | PRJNA1074407_P_NODE_104310_length_334_cov_1.000000_g100472_i0 | PRJNA1074407 | 104310 | 334 | 1 | 3.34 | Alphaendornavirus phaseoli | 3426184 | Viruses | Viruses | 612 | 1.15e-170 | NTclustered | gi|109804217|emb|AM284175.1| | 362698 | g100472 | i0 | 99.701 | 21.5658682634731 | 334 | 1 | 100 | 0 | 1 | 334 | 515 | 848 | Phaseolus vulgaris endornavirus partial ORF1 for hypothetical protein, genomic RNA | blastn | 7203 | 612 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus phaseoli | ||
| 11669072 | 11669072 | PRJNA1074407_P_NODE_71950_length_478_cov_1.859259_g68116_i0 | PRJNA1074407 | 71950 | 478 | 1.859259 | 8.88725802 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 569 | 1.0399999999999999e-157 | NTclustered | gi|2697475145|gb|PP215170.1| | 3132532 | g68116 | i0 | 88.26 | 0.997907949790795 | 477 | 55 | 99 | 1 | 1 | 476 | 6278 | 6754 | Macrobrachium rosenbergii hepe-like virus 3 isolate 01/JS/202106 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 477 | 569 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-like virus 3 | |||
| 11669224 | 11669224 | PRJNA1074407_P_NODE_79030_length_438_cov_1.246575_g75194_i0 | PRJNA1074407 | 79030 | 438 | 1.246575 | 5.4599985 | Alphaendornavirus phaseoli | 3426184 | Viruses | Viruses | 800 | 0 | NTclustered | gi|2562627221|gb|OQ750684.1| | 1188792 | g75194 | i0 | 99.771 | 21.4063926940639 | 436 | 1 | 99 | 0 | 1 | 436 | 4211 | 3776 | Phaseolus vulgaris alphaendornavirus 1 isolate PV2 polyprotein gene, complete cds | blastn | 9376 | 800 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus phaseoli | ||
| 12942265 | 12942265 | PRJNA1074407_P_NODE_126811_length_269_cov_1.551020_g122973_i0 | PRJNA1074407 | 126811 | 269 | 1.55102 | 4.1722438 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g122973 | i0 | 99.628 | 16.0297397769517 | 269 | 1 | 100 | 0 | 1 | 269 | 3996 | 4264 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 4312 | 492 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 12942459 | 12942459 | PRJNA1074407_P_NODE_136771_length_248_cov_0.868571_g132933_i0 | PRJNA1074407 | 136771 | 248 | 0.868571 | 2.15405608 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g132933 | i0 | 100 | 13 | 248 | 0 | 100 | 0 | 1 | 248 | 527 | 280 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 3224 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 14217525 | 14217525 | PRJNA1074407_P_NODE_141792_length_244_cov_0.888889_g137954_i0 | PRJNA1074407 | 141792 | 244 | 0.888889 | 2.16888916 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 289 | 1.5400000000000003e-73 | NTclustered | gi|2697475145|gb|PP215170.1| | 3132532 | g137954 | i0 | 88.163 | 1.00409836065574 | 245 | 25 | 99 | 4 | 3 | 244 | 7984 | 8227 | Macrobrachium rosenbergii hepe-like virus 3 isolate 01/JS/202106 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 245 | 289 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-like virus 3 | |||
| 14218268 | 14218268 | PRJNA1074407_P_NODE_37572_length_878_cov_1.463354_g34154_i0 | PRJNA1074407 | 37572 | 878 | 1.463354 | 12.84824812 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 1018 | 0 | NTclustered | gi|2697475145|gb|PP215170.1| | 3132532 | g34154 | i0 | 87.585 | 1 | 878 | 109 | 100 | 0 | 1 | 878 | 4768 | 5645 | Macrobrachium rosenbergii hepe-like virus 3 isolate 01/JS/202106 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 878 | 1018 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-like virus 3 | |||
| 18042227 | 18042227 | PRJNA1074407_P_NODE_77135_length_448_cov_1.600000_g73300_i0 | PRJNA1074407 | 77135 | 448 | 1.6 | 7.168 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 518 | 3.56e-142 | NTclustered | gi|2697475145|gb|PP215170.1| | 3132532 | g73300 | i0 | 87.556 | 1.00446428571429 | 450 | 53 | 100 | 3 | 1 | 448 | 8711 | 8263 | Macrobrachium rosenbergii hepe-like virus 3 isolate 01/JS/202106 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 450 | 518 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-like virus 3 | |||
| 20591656 | 20591656 | PRJNA1074407_P_NODE_80837_length_429_cov_1.337079_g77001_i0 | PRJNA1074407 | 80837 | 429 | 1.337079 | 5.73606891 | Alphaendornavirus phaseoli | 3426184 | Viruses | Viruses | 787 | 0 | NTclustered | gi|2392406202|gb|OM469934.1| | 1188792 | g77001 | i0 | 99.767 | 18 | 429 | 1 | 100 | 0 | 1 | 429 | 6561 | 6989 | Phaseolus vulgaris alphaendornavirus 1 isolate KK022 polyprotein gene, complete cds | blastn | 7722 | 787 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus phaseoli | ||
| 23142838 | 23142838 | PRJNA1074407_P_NODE_80599_length_430_cov_1.658263_g76763_i0 | PRJNA1074407 | 80599 | 430 | 1.658263 | 7.1305309 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 545 | 1.56e-150 | NTclustered | gi|2697475145|gb|PP215170.1| | 3132532 | g76763 | i0 | 89.559 | 1.00232558139535 | 431 | 43 | 100 | 2 | 1 | 430 | 6247 | 5818 | Macrobrachium rosenbergii hepe-like virus 3 isolate 01/JS/202106 RNA-dependent RNA polymerase and hypothetical protein genes, complete cds | blastn | 431 | 545 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-like virus 3 | |||
| 24414008 | 24414008 | PRJNA1074407_P_NODE_103240_length_337_cov_1.284091_g99402_i0 | PRJNA1074407 | 103240 | 337 | 1.284091 | 4.32738667 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 623 | 5.369999999999999e-174 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g99402 | i0 | 100 | 13 | 337 | 0 | 100 | 0 | 1 | 337 | 6592 | 6256 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 4381 | 623 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 24414745 | 24414745 | PRJNA1074407_P_NODE_142140_length_243_cov_1.341176_g138302_i0 | PRJNA1074407 | 142140 | 243 | 1.341176 | 3.25905768 | Alphaendornavirus fuphaseoli | 3426176 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|1493498618|gb|MG640418.2| | 1188793 | g138302 | i0 | 99.588 | 12.9547325102881 | 243 | 1 | 100 | 0 | 1 | 243 | 8700 | 8458 | Phaseolus vulgaris alphaendornavirus 2 isolate INIFAP CG18 polyprotein of PvEV-2 gene, complete cds | blastn | 3148 | 444 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Alphaendornavirus fuphaseoli | ||
| 31742458 | 31742458 | PRJNA1074407_P_NODE_95997_length_362_cov_2.276817_g92160_i0 | PRJNA1074407 | 95997 | 362 | 2.276817 | 8.24207754 | Macrobrachium rosenbergii hepe-like virus 3 | 3132532 | Viruses | Viruses | 234 | 1.5299999999999999e-68 | NR | WWZ85572.1 | 3132532 | g92160 | i0 | 98.3 | 0.994475138121547 | 120 | 2 | 99.4 | 0 | 360 | 1 | 1325 | 1444 | WWZ85572.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii hepe-like virus 3] | diamond | 360 | 234 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepeviridae | Macrobrachium rosenbergii hepe-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);;