contig_metadata
13 rows where bioproject = "PRJNA763243", tax_phylum = "Pisuviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 743065 | 743065 | PRJNA763243_P_NODE_30721_length_306_cov_8.618026_g30375_i0 | PRJNA763243 | 30721 | 306 | 8.618026 | 26.37115956 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 545 | 1.07e-150 | NTclustered | gi|2522444418|emb|OX894531.1| | 2697049 | g30375 | i0 | 98.706 | 101.058823529412 | 309 | 1 | 100 | 1 | 1 | 306 | 29383 | 29691 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 30924 | 545 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4571849 | 4571849 | PRJNA763243_P_NODE_48684_length_257_cov_1.500000_g48338_i0 | PRJNA763243 | 48684 | 257 | 1.5 | 3.855 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 475 | 1.1699999999999999e-129 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g48338 | i0 | 100 | 100 | 257 | 0 | 100 | 0 | 1 | 257 | 27366 | 27622 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 25700 | 475 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4572250 | 4572250 | PRJNA763243_P_NODE_66984_length_231_cov_13.373418_g66638_i0 | PRJNA763243 | 66984 | 231 | 13.373418 | 30.89259558 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 427 | 2.9399999999999998e-115 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g66638 | i0 | 100 | 100 | 231 | 0 | 100 | 0 | 1 | 231 | 28769 | 28539 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 23100 | 427 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 4572314 | 4572314 | PRJNA763243_P_NODE_69964_length_220_cov_16.938776_g69618_i0 | PRJNA763243 | 69964 | 220 | 16.938776 | 37.2653072 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 407 | 3.61e-109 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g69618 | i0 | 100 | 100 | 220 | 0 | 100 | 0 | 1 | 220 | 5978 | 5759 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 22000 | 407 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5847041 | 5847041 | PRJNA763243_P_NODE_48425_length_257_cov_7.483696_g48079_i0 | PRJNA763243 | 48425 | 257 | 7.483696 | 19.23309872 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 475 | 1.1699999999999999e-129 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g48079 | i0 | 100 | 100 | 257 | 0 | 100 | 0 | 1 | 257 | 19660 | 19404 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 25700 | 475 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7121896 | 7121896 | PRJNA763243_P_NODE_34026_length_293_cov_6.322727_g33680_i0 | PRJNA763243 | 34026 | 293 | 6.322727 | 18.52559011 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 542 | 1.32e-149 | NTclustered | gi|2080688819|emb|OU532432.1| | 2697049 | g33680 | i0 | 100 | 100 | 293 | 0 | 100 | 0 | 1 | 293 | 2687 | 2395 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 29300 | 542 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8396271 | 8396271 | PRJNA763243_P_NODE_29007_length_310_cov_4.708861_g28661_i0 | PRJNA763243 | 29007 | 310 | 4.708861 | 14.5974691 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 278 | 4.39e-70 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g28661 | i0 | 100 | 96.7741935483871 | 150 | 0 | 97 | 0 | 161 | 310 | 17957 | 18106 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 30000 | 278 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10947096 | 10947096 | PRJNA763243_P_NODE_2769_length_805_cov_10.346995_g2504_i0 | PRJNA763243 | 2769 | 805 | 10.346995 | 83.29330975 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 110 | 4.73e-19 | NTclustered | gi|2155043488|emb|OV016109.1| | 2697049 | g2504 | i0 | 95.652 | 7.71925465838509 | 69 | 1 | 8 | 2 | 1 | 67 | 30059 | 29991 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 6214 | 110 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14772501 | 14772501 | PRJNA763243_P_NODE_52672_length_250_cov_1.717514_g52326_i0 | PRJNA763243 | 52672 | 250 | 1.717514 | 4.293785 | Sobemovirus sp. | 2809869 | Viruses | Viruses | 187 | 5.949999999999998e-43 | NTclustered | gi|2171145024|gb|MZ218240.1| | 2809869 | g52326 | i0 | 81.356 | 1.588 | 236 | 38 | 93 | 5 | 6 | 238 | 5149 | 5381 | MAG: Sobemovirus sp. isolate 267-k141_60134 genomic sequence | blastn | 397 | 187 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus sp. | ||
| 16045687 | 16045687 | PRJNA763243_P_NODE_29093_length_310_cov_4.417722_g28747_i0 | PRJNA763243 | 29093 | 310 | 4.417722 | 13.6949382 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 278 | 4.39e-70 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g28747 | i0 | 100 | 96.4451612903226 | 150 | 0 | 96 | 0 | 161 | 310 | 19289 | 19438 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 29898 | 278 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 21146476 | 21146476 | PRJNA763243_P_NODE_67697_length_229_cov_5.102564_g67351_i0 | PRJNA763243 | 67697 | 229 | 5.102564 | 11.68487156 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 272 | 1.4399999999999999e-68 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g67351 | i0 | 100 | 64.1921397379913 | 147 | 0 | 64 | 0 | 1 | 147 | 29356 | 29210 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 14700 | 272 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22421315 | 22421315 | PRJNA763243_P_NODE_71858_length_211_cov_14.217391_g71512_i0 | PRJNA763243 | 71858 | 211 | 14.217391 | 29.99869501 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 374 | 3.4799999999999995e-99 | NTclustered | gi|1935607040|gb|MT747995.1| | 2789378 | g71512 | i0 | 98.585 | 1.99526066350711 | 212 | 2 | 100 | 1 | 1 | 211 | 3078 | 2867 | Shenzhen dicistro-like virus strain USAdp-3 polyprotein gene, complete cds | blastn | 421 | 374 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 24970467 | 24970467 | PRJNA763243_P_NODE_64280_length_240_cov_5.443114_g63934_i0 | PRJNA763243 | 64280 | 240 | 5.443114 | 13.0634736 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 444 | 3.05e-120 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g63934 | i0 | 100 | 100 | 240 | 0 | 100 | 0 | 1 | 240 | 22927 | 22688 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 24000 | 444 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum |
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);;