contig_metadata
16 rows where bioproject = "PRJEB10140" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1286010 | 1286010 | PRJEB10140_P_NODE_153842_length_242_cov_1.331606_g136534_i0 | PRJEB10140 | 153842 | 242 | 1.331606 | 3.22248652 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 405 | 1.45e-108 | NTclustered | gi|1933757591|gb|MW177750.1| | 2789423 | g136534 | i0 | 96.721 | 2.01652892561983 | 244 | 6 | 100 | 1 | 1 | 242 | 296 | 53 | Skokie tombus-like virus strain USAdp hypothetical protein 2 gene, partial cds | blastn | 488 | 405 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 6391391 | 6391391 | PRJEB10140_P_NODE_56426_length_650_cov_5.490849_g40005_i0 | PRJEB10140 | 56426 | 650 | 5.490849 | 35.6905185 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 54.7 | 0.018 | NTclustered | gi|2560523083|emb|OY698888.1| | 2697049 | g40005 | i0 | 100 | 0.0446153846153846 | 29 | 0 | 4 | 0 | 558 | 586 | 12031 | 12003 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10216144 | 10216144 | PRJEB10140_P_NODE_80249_length_457_cov_2.232843_g63000_i0 | PRJEB10140 | 80249 | 457 | 2.232843 | 10.20409251 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 54.7 | 0.012 | NTclustered | gi|2560523083|emb|OY698888.1| | 2697049 | g63000 | i0 | 100 | 0.0634573304157549 | 29 | 0 | 6 | 0 | 216 | 244 | 12003 | 12031 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12766729 | 12766729 | PRJEB10140_P_NODE_41791_length_858_cov_8.461063_g27258_i0 | PRJEB10140 | 41791 | 858 | 8.461063 | 72.59592054 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 54.7 | 0.024 | NTclustered | gi|2560523083|emb|OY698888.1| | 2697049 | g27258 | i0 | 100 | 0.0337995337995338 | 29 | 0 | 3 | 0 | 450 | 478 | 12031 | 12003 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22659131 | 22659131 | PRJEB10140_P_NODE_183858_length_209_cov_0.975000_g166549_i0 | PRJEB10140 | 183858 | 209 | 0.975 | 2.03775 | Viruses | 10239 | Viruses | Viruses | 215 | 2.21e-51 | NTclustered | gi|2214127666|tpg|BK059611.1| | 2904742 | g166549 | i0 | 85.167 | 2 | 209 | 31 | 100 | 0 | 1 | 209 | 8412 | 8204 | TPA_asm: Leptasterias associated picornavirus 2, complete genome | blastn | 418 | 215 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Leptasterias associated picornavirus 2 | |||
| 26747352 | 26747352 | PRJEB10140_P_NODE_286701_length_162_cov_2.300885_g269392_i0 | PRJEB10140 | 286701 | 162 | 2.300885 | 3.7274337 | Marine RNA virus BC-3 | 2315693 | Viruses | Viruses | 56.6 | 1.62e-7 | NR | YP_009666861.1 | 2315693 | g269392 | i0 | 74.3 | 1.88888888888889 | 35 | 7 | 61.1 | 1 | 37 | 135 | 791 | 825 | YP_009666861.1 structural polyprotein [Marine RNA virus BC-3] | diamond | 306 | 56.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Sogarnavirus | Sogarnavirus kitsilanoensis | ||
| 27158704 | 27158704 | PRJEB10140_P_NODE_188682_length_204_cov_2.258065_g171373_i0 | PRJEB10140 | 188682 | 204 | 2.258065 | 4.6064526 | Mute swan feces associated picorna-like virus 13 | 2832186 | Viruses | Viruses | 94.7 | 1.08e-20 | NR | QUS52710.1 | 2832186 | g171373 | i0 | 56.1 | 0.970588235294118 | 66 | 29 | 97.1 | 0 | 3 | 200 | 745 | 810 | QUS52710.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 13] | diamond | 198 | 94.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Mute swan feces associated picorna-like virus 13 | ||||
| 28485436 | 28485436 | PRJEB10140_P_NODE_218567_length_183_cov_2.283582_g201258_i0 | PRJEB10140 | 218567 | 183 | 2.283582 | 4.17895506 | Leptasterias associated picornavirus 2 | 2904742 | Viruses | Viruses | 105 | 1.0099999999999999e-24 | NR | DAZ87500.1 | 2904742 | g201258 | i0 | 70.5 | 1 | 61 | 18 | 100 | 0 | 183 | 1 | 1199 | 1259 | DAZ87500.1 TPA_asm: non-structural polyprotein [Leptasterias associated picornavirus 2] | diamond | 183 | 105 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Leptasterias associated picornavirus 2 | |||
| 28959213 | 28959213 | PRJEB10140_P_NODE_211968_length_187_cov_1.992754_g194659_i0 | PRJEB10140 | 211968 | 187 | 1.992754 | 3.72644998 | Orbilia oligospora narnavirus 1 | 3380797 | Viruses | Viruses | 55.5 | 5.85e-7 | NR | BFU49212.1 | 3380797 | g194659 | i0 | 44.4 | 2.63101604278075 | 54 | 30 | 86.6 | 0 | 2 | 163 | 219 | 272 | BFU49212.1 RNA-dependent RNA polymerase [Orbilia oligospora narnavirus 1] | diamond | 492 | 55.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Orbilia oligospora narnavirus 1 | |||
| 29874764 | 29874764 | PRJEB10140_P_NODE_224431_length_180_cov_1.496183_g207122_i0 | PRJEB10140 | 224431 | 180 | 1.496183 | 2.6931294 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 44.7 | 0.00335 | NR | UNY41971.1 | 3003959 | g207122 | i0 | 43.9 | 1.68333333333333 | 41 | 23 | 68.3 | 0 | 3 | 125 | 267 | 307 | UNY41971.1 MAG: polyprotein 2 [Picornavirales sp.] | diamond | 303 | 44.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30759327 | 30759327 | PRJEB10140_P_NODE_127974_length_286_cov_3.565401_g110667_i0 | PRJEB10140 | 127974 | 286 | 3.565401 | 10.19704686 | Barns Ness breadcrumb sponge aquatic picorna-like virus 4 | 2021880 | Viruses | Viruses | 151 | 2.8699999999999993e-40 | NR | ASM94058.1 | 2021880 | g110667 | i0 | 77.4 | 1.95104895104895 | 93 | 21 | 97.6 | 0 | 3 | 281 | 265 | 357 | ASM94058.1 hypothetical protein, partial [Barns Ness breadcrumb sponge aquatic picorna-like virus 4] | diamond | 558 | 151 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Barns Ness breadcrumb sponge aquatic picorna-like virus 4 | ||||
| 30917543 | 30917543 | PRJEB10140_P_NODE_81814_length_448_cov_1.533835_g64555_i0 | PRJEB10140 | 81814 | 448 | 1.533835 | 6.8715808 | Marine RNA virus BC-3 | 2315693 | Viruses | Viruses | 199 | 8.54e-56 | NR | YP_009666860.1 | 2315693 | g64555 | i0 | 59.5 | 2.96651785714286 | 148 | 60 | 99.1 | 0 | 446 | 3 | 559 | 706 | YP_009666860.1 non-structural polyprotein [Marine RNA virus BC-3] | diamond | 1329 | 199 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Sogarnavirus | Sogarnavirus kitsilanoensis | ||
| 31075385 | 31075385 | PRJEB10140_P_NODE_242895_length_170_cov_1.239669_g225586_i0 | PRJEB10140 | 242895 | 170 | 1.239669 | 2.1074373 | Marine RNA virus BC-2 | 2315692 | Viruses | Viruses | 65.5 | 1.33e-10 | NR | YP_009666859.1 | 2315692 | g225586 | i0 | 87.5 | 0.564705882352941 | 32 | 4 | 56.5 | 0 | 154 | 59 | 826 | 857 | YP_009666859.1 structural polyprotein, partial [Marine RNA virus BC-2] | diamond | 96 | 65.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Sogarnavirus | Sogarnavirus gustavseniae | ||
| 31391529 | 31391529 | PRJEB10140_P_NODE_156696_length_238_cov_1.772487_g139388_i0 | PRJEB10140 | 156696 | 238 | 1.772487 | 4.21851906 | Marine RNA virus BC-2 | 2315692 | Viruses | Viruses | 139 | 2.76e-36 | NR | YP_009666859.1 | 2315692 | g139388 | i0 | 87.3 | 0.995798319327731 | 79 | 10 | 99.6 | 0 | 238 | 2 | 339 | 417 | YP_009666859.1 structural polyprotein, partial [Marine RNA virus BC-2] | diamond | 237 | 139 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Sogarnavirus | Sogarnavirus gustavseniae | ||
| 31960702 | 31960702 | PRJEB10140_P_NODE_146598_length_252_cov_2.458128_g129290_i0 | PRJEB10140 | 146598 | 252 | 2.458128 | 6.19448256 | Marine RNA virus BC-2 | 2315692 | Viruses | Viruses | 163 | 1.1999999999999998e-44 | NR | YP_009666859.1 | 2315692 | g129290 | i0 | 88.9 | 0.964285714285714 | 81 | 9 | 96.4 | 0 | 245 | 3 | 425 | 505 | YP_009666859.1 structural polyprotein, partial [Marine RNA virus BC-2] | diamond | 243 | 163 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Sogarnavirus | Sogarnavirus gustavseniae | ||
| 32372322 | 32372322 | PRJEB10140_P_NODE_256679_length_167_cov_0.881356_g239370_i0 | PRJEB10140 | 256679 | 167 | 0.881356 | 1.47186452 | Marine RNA virus PAL156 | 1804154 | Viruses | Viruses | 65.5 | 1.27e-10 | NR | YP_009230120.1 | 1804154 | g239370 | i0 | 53.8 | 1.90419161676647 | 52 | 24 | 93.4 | 0 | 160 | 5 | 920 | 971 | YP_009230120.1 polyprotein [Marine RNA virus PAL156] | diamond | 318 | 65.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Sogarnavirus | Sogarnavirus palmerensis |
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);;