contig_metadata
20 rows where bioproject = "PRJNA800053", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 796237 | 796237 | PRJNA800053_P_NODE_24661_length_231_cov_2.132911_g24497_i0 | PRJNA800053 | 24661 | 231 | 2.132911 | 4.92702441 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 427 | 2.9399999999999998e-115 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g24497 | i0 | 100 | 100 | 231 | 0 | 100 | 0 | 1 | 231 | 11866 | 11636 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 23100 | 427 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2071925 | 2071925 | PRJNA800053_P_NODE_10922_length_297_cov_1.375000_g10758_i0 | PRJNA800053 | 10922 | 297 | 1.375 | 4.08375 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 549 | 8.029999999999997e-152 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g10758 | i0 | 100 | 100 | 297 | 0 | 100 | 0 | 1 | 297 | 21292 | 21588 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 29700 | 549 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 3347279 | 3347279 | PRJNA800053_P_NODE_2763_length_522_cov_1.367483_g2603_i0 | PRJNA800053 | 2763 | 522 | 1.367483 | 7.13826126 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 965 | 0 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g2603 | i0 | 100 | 100 | 522 | 0 | 100 | 0 | 1 | 522 | 15671 | 16192 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 52200 | 965 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 7174609 | 7174609 | PRJNA800053_P_NODE_706_length_916_cov_2.922894_g585_i0 | PRJNA800053 | 706 | 916 | 2.922894 | 26.77370904 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 1692 | 0 | NTclustered | gi|1918190895|gb|MW153748.1| | 2697049 | g585 | i0 | 100 | 101.482532751092 | 916 | 0 | 100 | 0 | 1 | 916 | 23799 | 22884 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/AUS/VIC8344/2020, complete genome | blastn | 92958 | 1692 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9724367 | 9724367 | PRJNA800053_P_NODE_3368_length_481_cov_1.485294_g3205_i0 | PRJNA800053 | 3368 | 481 | 1.485294 | 7.14426414 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 889 | 0 | NTclustered | gi|2045000472|gb|MZ287516.1| | 2697049 | g3205 | i0 | 100 | 100 | 481 | 0 | 100 | 0 | 1 | 481 | 12603 | 13083 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-CDC-FG-034863/2021 ORF1ab polyprotein (ORF1ab) and ORF1a polyprotein (ORF1ab) genes, partial cds; and surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds | blastn | 48100 | 889 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 9724369 | 9724369 | PRJNA800053_P_NODE_4228_length_436_cov_2.118457_g4065_i0 | PRJNA800053 | 4228 | 436 | 2.118457 | 9.23647252 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 806 | 0 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g4065 | i0 | 100 | 100 | 436 | 0 | 100 | 0 | 1 | 436 | 24685 | 25120 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 43600 | 806 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11000065 | 11000065 | PRJNA800053_P_NODE_16269_length_257_cov_1.798913_g16105_i0 | PRJNA800053 | 16269 | 257 | 1.798913 | 4.62320641 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 388 | 1.5699999999999998e-103 | NTclustered | gi|2063769173|emb|OU326123.1| | 2697049 | g16105 | i0 | 99.533 | 100.229571984436 | 214 | 0 | 100 | 1 | 1 | 213 | 6367 | 6580 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 25759 | 388 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11000078 | 11000078 | PRJNA800053_P_NODE_17609_length_251_cov_0.865169_g17445_i0 | PRJNA800053 | 17609 | 251 | 0.865169 | 2.17157419 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 344 | 3.3499999999999998e-90 | NTclustered | gi|2756424066|gb|PP745825.1| | 3003959 | g17445 | i0 | 100 | 0.741035856573705 | 186 | 0 | 74 | 0 | 66 | 251 | 1446 | 1261 | MAG: Picornavirales sp. isolate 154_18939 genomic sequence | blastn | 186 | 344 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 11000172 | 11000172 | PRJNA800053_P_NODE_7509_length_345_cov_1.661765_g7345_i0 | PRJNA800053 | 7509 | 345 | 1.661765 | 5.73308925 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 638 | 1.97e-178 | NTclustered | gi|2414454682|gb|OQ063416.1| | 2697049 | g7345 | i0 | 100 | 99.7130434782609 | 345 | 0 | 100 | 0 | 1 | 345 | 17535 | 17191 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CO-CDPHE-2103721117/2022 ORF1ab polyprotein (ORF1ab) and ORF1a polyprotein (ORF1ab) genes, partial cds; and surface glycoprotein (S), ORF3a protein (ORF3a), envelope protein (E), membrane glycoprotein (M), ORF6 protein (ORF6), ORF7a protein (ORF7a), ORF7b (ORF7b), ORF8 protein (ORF8), nucleocapsid phosphoprotein (N), and ORF10 protein (ORF10) genes, complete cds | blastn | 34401 | 638 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13549774 | 13549774 | PRJNA800053_P_NODE_16771_length_254_cov_1.679558_g16607_i0 | PRJNA800053 | 16771 | 254 | 1.679558 | 4.26607732 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2626234388|emb|OY822405.1| | 2697049 | g16607 | i0 | 100 | 100 | 254 | 0 | 100 | 0 | 1 | 254 | 12072 | 12325 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 25400 | 470 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13549796 | 13549796 | PRJNA800053_P_NODE_1871_length_615_cov_2.127306_g1716_i0 | PRJNA800053 | 1871 | 615 | 2.127306 | 13.0829319 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 1136 | 0 | NTclustered | gi|1854182511|gb|MT605815.1| | 2697049 | g1716 | i0 | 100 | 100 | 615 | 0 | 100 | 0 | 1 | 615 | 124 | 738 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WA-S112/2020, complete genome | blastn | 61500 | 1136 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14824662 | 14824662 | PRJNA800053_P_NODE_5272_length_397_cov_1.641975_g5109_i0 | PRJNA800053 | 5272 | 397 | 1.641975 | 6.51864075 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 734 | 0 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g5109 | i0 | 100 | 100 | 397 | 0 | 100 | 0 | 1 | 397 | 3652 | 3256 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 39700 | 734 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 17374697 | 17374697 | PRJNA800053_P_NODE_7514_length_345_cov_1.536765_g7350_i0 | PRJNA800053 | 7514 | 345 | 1.536765 | 5.30183925 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 638 | 1.97e-178 | NTclustered | gi|2418547206|gb|OQ139235.1| | 2697049 | g7350 | i0 | 100 | 100 | 345 | 0 | 100 | 0 | 1 | 345 | 10851 | 10507 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/CA-CDC-STM-7Z7DQ5EQZ/2022, complete genome | blastn | 34500 | 638 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18647621 | 18647621 | PRJNA800053_P_NODE_10715_length_299_cov_3.681416_g10551_i0 | PRJNA800053 | 10715 | 299 | 3.681416 | 11.00743384 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 553 | 6.25e-153 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g10551 | i0 | 100 | 100 | 299 | 0 | 100 | 0 | 1 | 299 | 1063 | 765 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 29900 | 553 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22473385 | 22473385 | PRJNA800053_P_NODE_2778_length_521_cov_2.107143_g2618_i0 | PRJNA800053 | 2778 | 521 | 2.107143 | 10.97821503 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 963 | 0 | NTclustered | gi|2777314969|emb|OZ121841.1| | 2697049 | g2618 | i0 | 100 | 100 | 521 | 0 | 100 | 0 | 1 | 521 | 13790 | 14310 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 52100 | 963 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22473390 | 22473390 | PRJNA800053_P_NODE_558_length_1011_cov_1.892324_g450_i0 | PRJNA800053 | 558 | 1011 | 1.892324 | 19.13139564 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 1868 | 0 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g450 | i0 | 100 | 100 | 1011 | 0 | 100 | 0 | 1 | 1011 | 21642 | 22652 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 101100 | 1868 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23748859 | 23748859 | PRJNA800053_P_NODE_13739_length_274_cov_2.676617_g13575_i0 | PRJNA800053 | 13739 | 274 | 2.676617 | 7.33393058 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 507 | 4.47e-139 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g13575 | i0 | 100 | 100 | 274 | 0 | 100 | 0 | 1 | 274 | 24119 | 24392 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 27400 | 507 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23748950 | 23748950 | PRJNA800053_P_NODE_24879_length_227_cov_2.370130_g24715_i0 | PRJNA800053 | 24879 | 227 | 2.37013 | 5.3801951 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 420 | 4.81e-113 | NTclustered | gi|2499447400|emb|OX492971.1| | 2697049 | g24715 | i0 | 100 | 100 | 227 | 0 | 100 | 0 | 1 | 227 | 19909 | 20135 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 22700 | 420 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 27180240 | 27180240 | PRJNA800053_P_NODE_12382_length_284_cov_1.639810_g12218_i0 | PRJNA800053 | 12382 | 284 | 1.63981 | 4.6570604 | Patatavirales sp. | 2809655 | Viruses | Viruses | 51.6 | 4.7e-5 | NR | WRQ64757.1 | 2809655 | g12218 | i0 | 32.3 | 1.61619718309859 | 96 | 51 | 94 | 3 | 269 | 3 | 544 | 632 | WRQ64757.1 polyprotein 2 [Patatavirales sp.] | diamond | 459 | 51.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Patatavirales sp. | ||||
| 32362246 | 32362246 | PRJNA800053_P_NODE_14039_length_272_cov_1.532663_g13875_i0 | PRJNA800053 | 14039 | 272 | 1.532663 | 4.16884336 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 92.4 | 1.1e-19 | NR | URG14603.1 | 1530251 | g13875 | i0 | 52.8 | 1.94117647058824 | 89 | 41 | 98.2 | 1 | 4 | 270 | 154 | 241 | URG14603.1 MAG: structural protein, partial [Picornaviridae sp.] | diamond | 528 | 92.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. |
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);;