contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2317842 | 2317842 | PRJNA1195374_P_NODE_12382_length_636_cov_1.651865_g12047_i0 | PRJNA1195374 | 12382 | 636 | 1.651865 | 10.5058614 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1170 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g12047 | i0 | 99.843 | 70.4795597484277 | 636 | 1 | 100 | 0 | 1 | 636 | 8637 | 9272 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 44825 | 1170 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2318202 | 2318202 | PRJNA1195374_P_NODE_562_length_1849_cov_25.340653_g475_i0 | PRJNA1195374 | 562 | 1849 | 25.340653 | 468.54867397 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3356 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g475 | i0 | 99.459 | 82.7003785830179 | 1847 | 10 | 99 | 0 | 3 | 1849 | 8371 | 6525 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 152913 | 3373 | 0.994959976282241 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2872073 | 2872073 | PRJNA1195374_P_NODE_24603_length_458_cov_1.000000_g24259_i0 | PRJNA1195374 | 24603 | 458 | 1 | 4.58 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 785 | 0 | NTclustered | gi|2169232273|gb|MZ209969.1| | 2905415 | g24259 | i0 | 97.598 | 7.92139737991266 | 458 | 11 | 100 | 0 | 1 | 458 | 5653 | 6110 | MAG: Sanya dicistrovirus 1 isolate TSYSY197, complete genome | blastn | 3628 | 785 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 4148764 | 4148764 | PRJNA1195374_P_NODE_53924_length_297_cov_1.031250_g53580_i0 | PRJNA1195374 | 53924 | 297 | 1.03125 | 3.0628125 | Capillovirus mali | 28347 | Viruses | Viruses | 422 | 1.83e-113 | NTclustered | gi|1249614036|dbj|LC184612.1| | 28347 | g53580 | i0 | 93.333 | 37.7575757575758 | 285 | 19 | 96 | 0 | 13 | 297 | 3744 | 3460 | Apple stem grooving virus genomic RNA, complete genome, isolate: Nagami | blastn | 11214 | 422 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 6145749 | 6145749 | PRJNA1195374_P_NODE_685_length_1750_cov_67.106738_g592_i0 | PRJNA1195374 | 685 | 1750 | 67.106738000000007 | 1174.367915 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3205 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g592 | i0 | 99.714 | 76.0194285714286 | 1750 | 5 | 100 | 0 | 1 | 1750 | 1812 | 63 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 133034 | 3210 | 0.998442367601246 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 6699383 | 6699383 | PRJNA1195374_P_NODE_37926_length_364_cov_1.323024_g37582_i0 | PRJNA1195374 | 37926 | 364 | 1.323024 | 4.81580736 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 562 | 1.29e-155 | NTclustered | gi|2169232273|gb|MZ209969.1| | 2905415 | g37582 | i0 | 94.505 | 1 | 364 | 20 | 100 | 0 | 1 | 364 | 7334 | 7697 | MAG: Sanya dicistrovirus 1 isolate TSYSY197, complete genome | blastn | 364 | 562 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 7420645 | 7420645 | PRJNA1195374_P_NODE_46_length_4459_cov_34.137255_g25_i0 | PRJNA1195374 | 46 | 4459 | 34.137255 | 1522.18020045 | Orthorubulavirus | 2560195 | Viruses | Viruses | 8172 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g25 | i0 | 99.753 | 78.94797039695 | 4458 | 11 | 99 | 0 | 1 | 4458 | 1795 | 6252 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 352029 | 8189 | 0.997924044449872 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7975662 | 7975662 | PRJNA1195374_P_NODE_78747_length_245_cov_2.598837_g78403_i0 | PRJNA1195374 | 78747 | 245 | 2.598837 | 6.36715065 | Chrocagost virus | 3129398 | Viruses | Viruses | 289 | 1.55e-73 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g78403 | i0 | 88.333 | 280.334693877551 | 240 | 28 | 98 | 0 | 6 | 245 | 5619 | 5858 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 68682 | 289 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 8695820 | 8695820 | PRJNA1195374_P_NODE_5867_length_873_cov_1.673750_g5593_i0 | PRJNA1195374 | 5867 | 873 | 1.67375 | 14.6118375 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1596 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g5593 | i0 | 99.656 | 68.3367697594502 | 873 | 3 | 100 | 0 | 1 | 873 | 12420 | 13292 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 59658 | 1596 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10525409 | 10525409 | PRJNA1195374_P_NODE_4569_length_963_cov_3.225843_g4318_i0 | PRJNA1195374 | 4569 | 963 | 3.225843 | 31.06486809 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 1469 | 0 | NTclustered | gi|2169232273|gb|MZ209969.1| | 2905415 | g4318 | i0 | 94.185 | 6.94911734164071 | 963 | 56 | 100 | 0 | 1 | 963 | 8813 | 7851 | MAG: Sanya dicistrovirus 1 isolate TSYSY197, complete genome | blastn | 6692 | 1469 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 10525439 | 10525439 | PRJNA1195374_P_NODE_47869_length_319_cov_1.247967_g47525_i0 | PRJNA1195374 | 47869 | 319 | 1.247967 | 3.98101473 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 523 | 5.269999999999999e-144 | NTclustered | gi|2169232273|gb|MZ209969.1| | 2905415 | g47525 | i0 | 96.238 | 1 | 319 | 12 | 100 | 0 | 1 | 319 | 5426 | 5108 | MAG: Sanya dicistrovirus 1 isolate TSYSY197, complete genome | blastn | 319 | 523 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 11800877 | 11800877 | PRJNA1195374_P_NODE_80590_length_244_cov_0.900585_g80246_i0 | PRJNA1195374 | 80590 | 244 | 0.900585 | 2.1974274 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 324 | 4.22e-84 | NTclustered | gi|2169232273|gb|MZ209969.1| | 2905415 | g80246 | i0 | 90.574 | 1 | 244 | 23 | 100 | 0 | 1 | 244 | 4345 | 4588 | MAG: Sanya dicistrovirus 1 isolate TSYSY197, complete genome | blastn | 244 | 324 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 13075727 | 13075727 | PRJNA1195374_P_NODE_68291_length_257_cov_10.983696_g67947_i0 | PRJNA1195374 | 68291 | 257 | 10.983696 | 28.22809872 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 466 | 7.05e-127 | NTclustered | gi|2562721692|gb|OQ994985.1| | 2905673 | g67947 | i0 | 99.608 | 68.9805447470817 | 255 | 1 | 99 | 0 | 3 | 257 | 6489 | 6235 | Parainfluenza virus 5 strain GX2020, complete genome | blastn | 17728 | 466 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15623895 | 15623895 | PRJNA1195374_P_NODE_1753_length_1342_cov_45.498030_g1600_i0 | PRJNA1195374 | 1753 | 1342 | 45.49803 | 610.5835626 | Betahypovirus cryphonectriae | 2955457 | Viruses | Viruses | 54.7 | 0.038 | NTclustered | gi|10644642|gb|AF276421.1|AF276421 | 106962 | g1600 | i0 | 100 | 0.0648286140089419 | 29 | 0 | 2 | 0 | 202 | 230 | 414 | 442 | Cryphonectria hypovirus 3 segment 4 satellite sequence | blastn | 87 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Betahypovirus | Betahypovirus cryphonectriae | ||
| 18173256 | 18173256 | PRJNA1195374_P_NODE_42735_length_340_cov_1.715356_g42391_i0 | PRJNA1195374 | 42735 | 340 | 1.715356 | 5.8322104 | Sanya dicistrovirus 1 | 2905415 | Viruses | Viruses | 470 | 7.479999999999999e-128 | NTclustered | gi|2169232273|gb|MZ209969.1| | 2905415 | g42391 | i0 | 91.716 | 0.994117647058824 | 338 | 28 | 99 | 0 | 3 | 340 | 7322 | 6985 | MAG: Sanya dicistrovirus 1 isolate TSYSY197, complete genome | blastn | 338 | 470 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Sanya dicistrovirus 1 | |||
| 18893968 | 18893968 | PRJNA1195374_P_NODE_14495_length_592_cov_1.870906_g14156_i0 | PRJNA1195374 | 14495 | 592 | 1.870906 | 11.07576352 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1077 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14156 | i0 | 99.493 | 69.3817567567568 | 592 | 3 | 100 | 0 | 1 | 592 | 10549 | 9958 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 41074 | 1083 | 0.994459833795014 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21444450 | 21444450 | PRJNA1195374_P_NODE_14617_length_590_cov_1.189555_g14278_i0 | PRJNA1195374 | 14617 | 590 | 1.189555 | 7.0183745 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g14278 | i0 | 99.661 | 70.1389830508475 | 590 | 2 | 100 | 0 | 1 | 590 | 11268 | 10679 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 41382 | 1085 | 0.994470046082949 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21444949 | 21444949 | PRJNA1195374_P_NODE_897_length_1641_cov_3.095663_g796_i0 | PRJNA1195374 | 897 | 1641 | 3.095663 | 50.79982983 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3003 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g796 | i0 | 99.695 | 67.1602681291895 | 1641 | 5 | 100 | 0 | 1 | 1641 | 13575 | 15215 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 110210 | 3003 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21998574 | 21998574 | PRJNA1195374_P_NODE_52398_length_302_cov_1.344978_g52054_i0 | PRJNA1195374 | 52398 | 302 | 1.344978 | 4.06183356 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 438 | 1.8499999999999999e-118 | NTclustered | gi|2245485953|gb|ON162094.1| | 1530251 | g52054 | i0 | 92.763 | 1.00662251655629 | 304 | 20 | 100 | 1 | 1 | 302 | 829 | 526 | MAG: Picornaviridae sp. isolate 184-k141_264499 polyprotein gene, partial cds | blastn | 304 | 438 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 24548306 | 24548306 | PRJNA1195374_P_NODE_70960_length_251_cov_0.865169_g70616_i0 | PRJNA1195374 | 70960 | 251 | 0.865169 | 2.17157419 | Capillovirus mali | 28347 | Viruses | Viruses | 420 | 5.41e-113 | NTclustered | gi|2700566162|gb|ON820668.1| | 33759 | g70616 | i0 | 96.813 | 99.6494023904382 | 251 | 8 | 100 | 0 | 1 | 251 | 5625 | 5875 | Citrus tatter leaf virus isolate SC-BJNM, complete genome | blastn | 25012 | 420 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali | ||
| 24548311 | 24548311 | PRJNA1195374_P_NODE_71080_length_251_cov_0.865169_g70736_i0 | PRJNA1195374 | 71080 | 251 | 0.865169 | 2.17157419 | Capillovirus mali | 28347 | Viruses | Viruses | 442 | 1.1599999999999995e-119 | NTclustered | gi|525333947|gb|JX885576.1| | 28347 | g70736 | i0 | 98.406 | 100 | 251 | 4 | 100 | 0 | 1 | 251 | 85 | 335 | Apple stem grooving virus isolate MH coat protein gene, complete cds | blastn | 25100 | 442 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Capillovirus | Capillovirus mali |
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);;