contig_metadata
11 rows where bioproject = "PRJNA681822", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2445180 | 2445180 | PRJNA681822_P_NODE_117042_length_371_cov_1.533557_g115556_i0 | PRJNA681822 | 117042 | 371 | 1.533557 | 5.68949647 | Orthorubulavirus | 2560195 | Viruses | Viruses | 686 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g115556 | i0 | 100 | 68.4420485175202 | 371 | 0 | 100 | 0 | 1 | 371 | 14175 | 13805 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 25392 | 686 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7547720 | 7547720 | PRJNA681822_P_NODE_119546_length_368_cov_2.345763_g118059_i0 | PRJNA681822 | 119546 | 368 | 2.345763 | 8.63240784 | Orthorubulavirus | 2560195 | Viruses | Viruses | 675 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g118059 | i0 | 99.728 | 75.2445652173913 | 368 | 1 | 100 | 0 | 1 | 368 | 964 | 597 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 27690 | 675 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10098827 | 10098827 | PRJNA681822_P_NODE_202108_length_307_cov_1.564103_g200620_i0 | PRJNA681822 | 202108 | 307 | 1.564103 | 4.80179621 | Orthorubulavirus | 2560195 | Viruses | Viruses | 562 | 1.07e-155 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g200620 | i0 | 99.674 | 78.257328990228 | 307 | 1 | 100 | 0 | 1 | 307 | 78 | 384 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 24025 | 562 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15198659 | 15198659 | PRJNA681822_P_NODE_186292_length_316_cov_1.901235_g184804_i0 | PRJNA681822 | 186292 | 316 | 1.901235 | 6.0079026 | Orthorubulavirus | 2560195 | Viruses | Viruses | 575 | 1.4199999999999995e-159 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g184804 | i0 | 99.682 | 67.379746835443 | 314 | 1 | 99 | 0 | 1 | 314 | 3117 | 3430 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 21292 | 575 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15199257 | 15199257 | PRJNA681822_P_NODE_36672_length_619_cov_1.580586_g35256_i0 | PRJNA681822 | 36672 | 619 | 1.580586 | 9.78382734 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1133 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g35256 | i0 | 99.677 | 79.7754442649435 | 619 | 2 | 100 | 0 | 1 | 619 | 2288 | 1670 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 49381 | 1133 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15199657 | 15199657 | PRJNA681822_P_NODE_50472_length_525_cov_1.022124_g49014_i0 | PRJNA681822 | 50472 | 525 | 1.022124 | 5.366151 | Orthorubulavirus | 2560195 | Viruses | Viruses | 965 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g49014 | i0 | 99.81 | 69 | 525 | 1 | 100 | 0 | 1 | 525 | 3519 | 4043 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 36225 | 965 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 23607379 | 23607379 | PRJNA681822_P_NODE_334799_length_265_cov_1.203125_g333310_i0 | PRJNA681822 | 334799 | 265 | 1.203125 | 3.18828125 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 490 | 4.3299999999999986e-134 | NTclustered | gi|1028325827|gb|KX060176.1| | 2905673 | g333310 | i0 | 100 | 84.9509433962264 | 265 | 0 | 100 | 0 | 1 | 265 | 2625 | 2361 | Parainfluenza virus 5 strain AGS, complete genome | blastn | 22512 | 490 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 27619223 | 27619223 | PRJNA681822_P_NODE_5684_length_1582_cov_4.996024_g5009_i0 | PRJNA681822 | 5684 | 1582 | 4.996024 | 79.03709968 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 337 | 2.959999999999999e-105 | NR | BDR95914.1 | 2979708 | g5009 | i0 | 47.7 | 1.2629582806574 | 333 | 174 | 63.1 | 0 | 1582 | 584 | 264 | 596 | BDR95914.1 hypothetical protein [Qingdao RNA virus 4] | diamond | 1998 | 337 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 29639515 | 29639515 | PRJNA681822_P_NODE_23490_length_783_cov_2.783099_g22212_i0 | PRJNA681822 | 23490 | 783 | 2.783099 | 21.79166517 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 164 | 5.299999999999999e-43 | NR | BDR95914.1 | 2979708 | g22212 | i0 | 39.8 | 0.885057471264368 | 231 | 137 | 88.5 | 1 | 698 | 6 | 3 | 231 | BDR95914.1 hypothetical protein [Qingdao RNA virus 4] | diamond | 693 | 164 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 32105099 | 32105099 | PRJNA681822_P_NODE_109178_length_380_cov_1.374593_g107692_i0 | PRJNA681822 | 109178 | 380 | 1.374593 | 5.2234534 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 157 | 1.7e-41 | NR | BDR95913.1 | 2979708 | g107692 | i0 | 63.5 | 0.994736842105263 | 126 | 46 | 99.5 | 0 | 1 | 378 | 1360 | 1485 | BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] | diamond | 378 | 157 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 32548361 | 32548361 | PRJNA681822_P_NODE_213219_length_300_cov_2.268722_g211731_i0 | PRJNA681822 | 213219 | 300 | 2.268722 | 6.806166 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 64.3 | 2.05e-9 | NR | BDR95913.1 | 2979708 | g211731 | i0 | 33.7 | 1.04 | 104 | 63 | 98 | 1 | 1 | 294 | 1685 | 1788 | BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] | diamond | 312 | 64.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 |
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);;