contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164745 | 164745 | PRJNA1028258_P_NODE_40381_length_398_cov_1.489362_g39818_i0 | PRJNA1028258 | 40381 | 398 | 1.489362 | 5.92766076 | Chrocaturd virus | 3129638 | Viruses | Viruses | 558 | 1.84e-154 | NTclustered | gi|2717318092|gb|PP172086.1| | 3129638 | g39818 | i0 | 92.386 | 139.552763819095 | 394 | 27 | 99 | 3 | 6 | 398 | 3475 | 3084 | MAG: Chrocaturd virus isolate CC1C_k141_57646 genomic sequence | blastn | 55542 | 558 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocaturd virus | |||||
| 1005298 | 1005298 | PRJNA1028258_P_NODE_3061_length_1297_cov_6.315961_g2830_i0 | PRJNA1028258 | 3061 | 1297 | 6.315961 | 81.91801417 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2379 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g2830 | i0 | 99.769 | 68.9768696993061 | 1297 | 3 | 100 | 0 | 1 | 1297 | 3134 | 4430 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 89463 | 2379 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2281722 | 2281722 | PRJNA1028258_P_NODE_9682_length_807_cov_3.425474_g9226_i0 | PRJNA1028258 | 9682 | 807 | 3.425474 | 27.64357518 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1485 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g9226 | i0 | 99.876 | 66.1970260223048 | 807 | 1 | 100 | 0 | 1 | 807 | 15159 | 14353 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 53421 | 1485 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 4832347 | 4832347 | PRJNA1028258_P_NODE_111544_length_251_cov_1.450549_g110981_i0 | PRJNA1028258 | 111544 | 251 | 1.450549 | 3.64087799 | Orthorubulavirus | 2560195 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g110981 | i0 | 100 | 68 | 251 | 0 | 100 | 0 | 1 | 251 | 13743 | 13993 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17068 | 464 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 5267728 | 5267728 | PRJNA1028258_P_NODE_465_length_2329_cov_66.530531_g400_i0 | PRJNA1028258 | 465 | 2329 | 66.530531 | 1549.49606699 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 4301 | 0 | NTclustered | gi|2239998157|gb|ON160023.1| | 2936548 | g400 | i0 | 100 | 1.6728209531988 | 2329 | 0 | 100 | 0 | 1 | 2329 | 16 | 2344 | Red mite associated cystovirus isolate RMACTV1-S P8, P12, P9, and P5 genes, complete cds | blastn | 3896 | 4301 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 7817561 | 7817561 | PRJNA1028258_P_NODE_47_length_4310_cov_17.946239_g40_i0 | PRJNA1028258 | 47 | 4310 | 17.946239 | 773.4829009 | Pseudomonas phage ER16 | 2917704 | Viruses | Viruses | 99 | 5.69e-15 | NTclustered | gi|2209092821|gb|OM650249.1| | 2917704 | g40 | i0 | 87.5 | 0.0204176334106729 | 88 | 8 | 2 | 3 | 4212 | 4299 | 156 | 72 | Pseudomonas phage ER16 segment M, complete sequence | blastn | 88 | 99 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Pseudomonas phage ER16 | |||
| 8659446 | 8659446 | PRJNA1028258_P_NODE_827_length_1971_cov_5.608833_g734_i0 | PRJNA1028258 | 827 | 1971 | 5.608833 | 110.55009843 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3591 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g734 | i0 | 99.543 | 94.0334855403349 | 1971 | 9 | 100 | 0 | 1 | 1971 | 4512 | 6482 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 185340 | 3596 | 0.99860956618465 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 9090853 | 9090853 | PRJNA1028258_P_NODE_119508_length_245_cov_0.732955_g118945_i0 | PRJNA1028258 | 119508 | 245 | 0.732955 | 1.79573975 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 71.3 | 6.11e-8 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g118945 | i0 | 93.617 | 0.469387755102041 | 47 | 3 | 19 | 0 | 199 | 245 | 72 | 26 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 115 | 71.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 9933809 | 9933809 | PRJNA1028258_P_NODE_4828_length_1084_cov_2.475862_g4522_i0 | PRJNA1028258 | 4828 | 1084 | 2.475862 | 26.83834408 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1986 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g4522 | i0 | 99.723 | 82.789667896679 | 1084 | 3 | 100 | 0 | 1 | 1084 | 7576 | 6493 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 89744 | 1997 | 0.99449173760641 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12483804 | 12483804 | PRJNA1028258_P_NODE_170_length_3044_cov_12.939160_g143_i0 | PRJNA1028258 | 170 | 3044 | 12.93916 | 393.8680304 | Orthorubulavirus | 2560195 | Viruses | Viruses | 5528 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g143 | i0 | 99.442 | 77.4904730617608 | 3044 | 17 | 100 | 0 | 1 | 3044 | 3078 | 35 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 235881 | 5555 | 0.995139513951395 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12917035 | 12917035 | PRJNA1028258_P_NODE_122751_length_242_cov_1.398844_g122188_i0 | PRJNA1028258 | 122751 | 242 | 1.398844 | 3.38520248 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 436 | 5.1499999999999985e-118 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g122188 | i0 | 99.174 | 67 | 242 | 2 | 100 | 0 | 1 | 242 | 13311 | 13552 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 16214 | 436 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 14192093 | 14192093 | PRJNA1028258_P_NODE_12_length_5792_cov_3.769876_g11_i0 | PRJNA1028258 | 12 | 5792 | 3.769876 | 218.35121792 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 10654 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g11 | i0 | 100 | 1.9690953038674 | 5769 | 0 | 99 | 0 | 1 | 5769 | 708 | 6476 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 11405 | 10654 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 14192198 | 14192198 | PRJNA1028258_P_NODE_13632_length_687_cov_6.700647_g13132_i0 | PRJNA1028258 | 13632 | 687 | 6.700647 | 46.03344489 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 1269 | 0 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g13132 | i0 | 100 | 1.27947598253275 | 687 | 0 | 100 | 0 | 1 | 687 | 18 | 704 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 879 | 1269 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 16308186 | 16308186 | PRJNA1028258_P_NODE_53253_length_348_cov_1.594982_g52690_i0 | PRJNA1028258 | 53253 | 348 | 1.594982 | 5.55053736 | Orthorubulavirus | 2560195 | Viruses | Viruses | 632 | 9.25e-177 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g52690 | i0 | 99.425 | 68.9195402298851 | 348 | 2 | 100 | 0 | 1 | 348 | 14340 | 13993 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 23984 | 638 | 0.990595611285266 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 22681024 | 22681024 | PRJNA1028258_P_NODE_10778_length_767_cov_3.194842_g10308_i0 | PRJNA1028258 | 10778 | 767 | 3.194842 | 24.50443814 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1400 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g10308 | i0 | 99.609 | 81.9504563233377 | 767 | 3 | 100 | 0 | 1 | 767 | 7567 | 8333 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 62856 | 1406 | 0.995732574679943 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 23115210 | 23115210 | PRJNA1028258_P_NODE_103719_length_257_cov_6.069149_g103156_i0 | PRJNA1028258 | 103719 | 257 | 6.069149 | 15.59771293 | Mitovirus sp. | 2587224 | Viruses | Viruses | 156 | 1.73e-33 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g103156 | i0 | 94.118 | 3.6147859922179 | 102 | 6 | 40 | 0 | 156 | 257 | 112 | 11 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 929 | 156 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 23957832 | 23957832 | PRJNA1028258_P_NODE_39819_length_401_cov_1.222892_g39256_i0 | PRJNA1028258 | 39819 | 401 | 1.222892 | 4.90379692 | Orthorubulavirus | 2560195 | Viruses | Viruses | 736 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g39256 | i0 | 99.751 | 69.7980049875312 | 401 | 1 | 100 | 0 | 1 | 401 | 9012 | 8612 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 27989 | 736 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis |
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);;