contig_metadata
12 rows where bioproject = "PRJNA306153" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 376357 | 376357 | PRJNA306153_S_NODE_961_length_244_cov_12785.716279_g948_i0 | PRJNA306153 | 961 | 244 | 12785.716279 | 31197.14772076 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 80.5 | 1.01e-10 | NTclustered | gi|2165834303|emb|OV196009.1| | 2697049 | g948 | i0 | 100 | 0.631147540983607 | 43 | 0 | 18 | 0 | 186 | 228 | 29949 | 29991 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 154 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 26631093 | 26631093 | PRJNA306153_S_NODE_2701_length_153_cov_3.072581_g2688_i0 | PRJNA306153 | 2701 | 153 | 3.072581 | 4.70104893 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 85.5 | 9.13e-18 | NR | QPN36950.1 | 2789623 | g2688 | i0 | 78 | 0.980392156862745 | 50 | 11 | 98 | 0 | 151 | 2 | 452 | 501 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 150 | 85.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 27137006 | 27137006 | PRJNA306153_S_NODE_1942_length_178_cov_2.637584_g1929_i0 | PRJNA306153 | 1942 | 178 | 2.637584 | 4.69489952 | Skokie reo-like virus | 2789444 | Viruses | Viruses | 53.1 | 3.37e-6 | NR | QPF16729.1 | 2789444 | g1929 | i0 | 40.7 | 0.99438202247191 | 59 | 34 | 99.4 | 1 | 1 | 177 | 759 | 816 | QPF16729.1 hypothetical protein 2, partial [Skokie reo-like virus] | diamond | 177 | 53.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Skokie reo-like virus | ||||
| 27327172 | 27327172 | PRJNA306153_S_NODE_2023_length_175_cov_1.356164_g2010_i0 | PRJNA306153 | 2023 | 175 | 1.356164 | 2.373287 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 96.7 | 1.55e-21 | NR | QPN36950.1 | 2789623 | g2010 | i0 | 72.4 | 0.994285714285714 | 58 | 16 | 99.4 | 0 | 175 | 2 | 778 | 835 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 174 | 96.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 28053277 | 28053277 | PRJNA306153_S_NODE_1665_length_190_cov_3.192547_g1652_i0 | PRJNA306153 | 1665 | 190 | 3.192547 | 6.0658393 | Skokie reo-like virus | 2789444 | Viruses | Viruses | 52.4 | 7.48e-6 | NR | QPF16729.1 | 2789444 | g1652 | i0 | 41.7 | 0.947368421052632 | 60 | 35 | 94.7 | 0 | 180 | 1 | 981 | 1040 | QPF16729.1 hypothetical protein 2, partial [Skokie reo-like virus] | diamond | 180 | 52.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Skokie reo-like virus | ||||
| 28685034 | 28685034 | PRJNA306153_S_NODE_487_length_328_cov_2.789298_g474_i0 | PRJNA306153 | 487 | 328 | 2.789298 | 9.14889744 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 118 | 3.51e-28 | NR | QPN36950.1 | 2789623 | g474 | i0 | 54.1 | 0.996951219512195 | 109 | 50 | 99.7 | 0 | 328 | 2 | 197 | 305 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 327 | 118 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 29568861 | 29568861 | PRJNA306153_S_NODE_810_length_265_cov_4.622881_g797_i0 | PRJNA306153 | 810 | 265 | 4.622881 | 12.25063465 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 66.6 | 1.89e-10 | NR | QPN36950.1 | 2789623 | g797 | i0 | 54.5 | 0.622641509433962 | 55 | 25 | 62.3 | 0 | 233 | 69 | 1198 | 1252 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 165 | 66.6 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 30769414 | 30769414 | PRJNA306153_S_NODE_2534_length_157_cov_2.601562_g2521_i0 | PRJNA306153 | 2534 | 157 | 2.601562 | 4.08445234 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 69.3 | 4.69e-12 | NR | QPN36950.1 | 2789623 | g2521 | i0 | 58.8 | 0.974522292993631 | 51 | 21 | 97.5 | 0 | 3 | 155 | 1052 | 1102 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 153 | 69.3 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 30958997 | 30958997 | PRJNA306153_S_NODE_974_length_243_cov_3.406542_g961_i0 | PRJNA306153 | 974 | 243 | 3.406542 | 8.27789706 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 84.7 | 6.17e-17 | NR | QPN36950.1 | 2789623 | g961 | i0 | 48.1 | 0.975308641975309 | 79 | 41 | 97.5 | 0 | 6 | 242 | 931 | 1009 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 237 | 84.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 31370068 | 31370068 | PRJNA306153_S_NODE_2496_length_158_cov_2.674419_g2483_i0 | PRJNA306153 | 2496 | 158 | 2.674419 | 4.22558202 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 65.5 | 1.11e-10 | NR | QPN36950.1 | 2789623 | g2483 | i0 | 51.9 | 0.987341772151899 | 52 | 25 | 98.7 | 0 | 158 | 3 | 145 | 196 | QPN36950.1 hypothetical protein [Shenzhen reo-like virus 1] | diamond | 156 | 65.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 32097345 | 32097345 | PRJNA306153_S_NODE_578_length_306_cov_2.469314_g565_i0 | PRJNA306153 | 578 | 306 | 2.469314 | 7.55610084 | Skokie reo-like virus | 2789444 | Viruses | Viruses | 85.5 | 7.92e-17 | NR | QPF16729.1 | 2789444 | g565 | i0 | 41.2 | 1 | 102 | 60 | 100 | 0 | 306 | 1 | 145 | 246 | QPF16729.1 hypothetical protein 2, partial [Skokie reo-like virus] | diamond | 306 | 85.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Skokie reo-like virus | ||||
| 32589660 | 32589660 | PRJNA306153_S_NODE_2779_length_151_cov_1.885246_g2766_i0 | PRJNA306153 | 2779 | 151 | 1.885246 | 2.84672146 | Viruses | 10239 | Viruses | Viruses | 52.4 | 4.25e-6 | NR | QPG92977.1 | 2789444 | g2766 | i0 | 68.4 | 2.48344370860927 | 38 | 12 | 75.5 | 0 | 1 | 114 | 893 | 930 | QPG92977.1 hypothetical protein [Skokie reo-like virus] | diamond | 375 | 52.8 | 0.992424242424242 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Skokie reo-like virus |
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);;