contig_metadata
11 rows where bioproject = "PRJNA1028258", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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);;