contig_metadata
12 rows where bioproject = "PRJNA550047" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2396590 | 2396590 | PRJNA550047_P_NODE_352942_length_284_cov_3.962085_g350971_i0 | PRJNA550047 | 352942 | 284 | 3.962085 | 11.2523214 | Enterovirus | 12059 | Viruses | Viruses | 481 | 2.82e-131 | NTclustered | gi|1726249435|gb|MN306023.1| | 463676 | g350971 | i0 | 97.183 | 26.8591549295775 | 284 | 8 | 100 | 0 | 1 | 284 | 1451 | 1734 | Rhinovirus C strain SC0323, complete genome | blastn | 7628 | 481 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus cerhino | ||
| 11992761 | 11992761 | PRJNA550047_P_NODE_230170_length_301_cov_6.197368_g228201_i0 | PRJNA550047 | 230170 | 301 | 6.197368 | 18.65407768 | Linepithema humile picorna-like virus 1 | 2259776 | Viruses | Viruses | 274 | 5.49e-69 | NTclustered | gi|2306450120|gb|MW314667.1| | 2259776 | g228201 | i0 | 99.338 | 2.99003322259136 | 151 | 1 | 99 | 0 | 151 | 301 | 1782 | 1932 | Linepithema humile picorna-like virus 1 from Italy, complete genome | blastn | 900 | 274 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Linepithema humile picorna-like virus 1 | ||||
| 13874462 | 13874462 | PRJNA550047_P_NODE_234711_length_301_cov_4.100877_g232742_i0 | PRJNA550047 | 234711 | 301 | 4.100877 | 12.34363977 | Enterovirus | 12059 | Viruses | Viruses | 276 | 1.53e-69 | NTclustered | gi|2917992924|gb|PV178572.1| | 185905 | g232742 | i0 | 99.342 | 14.1328903654485 | 152 | 1 | 100 | 0 | 1 | 152 | 5328 | 5177 | Rhinovirus A34 isolate Rhinovirus A34/human/USA/MA-Broad_BWH-19894/2023 polyprotein gene, partial cds | blastn | 4254 | 276 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus alpharhino | ||
| 15817037 | 15817037 | PRJNA550047_P_NODE_261813_length_300_cov_4.409692_g259844_i0 | PRJNA550047 | 261813 | 300 | 4.409692 | 13.229076 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 9.76e-22 | NTclustered | gi|2165837707|emb|OV197600.1| | 2697049 | g259844 | i0 | 93.671 | 73.2666666666667 | 79 | 3 | 48 | 2 | 211 | 287 | 29995 | 29917 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 21980 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 18368960 | 18368960 | PRJNA550047_P_NODE_511095_length_227_cov_3.857143_g509122_i0 | PRJNA550047 | 511095 | 227 | 3.857143 | 8.75571461 | Enterovirus cerhino | 3428504 | Viruses | Viruses | 409 | 1.04e-109 | NTclustered | gi|2278964070|dbj|LC720414.1| | 1219378 | g509122 | i0 | 99.119 | 53.7753303964758 | 227 | 2 | 100 | 0 | 1 | 227 | 3447 | 3673 | Rhinovirus C6 HRV_C6_Fukushima_C6_2021 RNA, nearly complete genome | blastn | 12207 | 409 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus cerhino | ||
| 18369006 | 18369006 | PRJNA550047_P_NODE_515695_length_225_cov_10.059211_g513722_i0 | PRJNA550047 | 515695 | 225 | 10.059211 | 22.63322475 | Ripigleb virus | 3130924 | Viruses | Viruses | 267 | 6.559999999999999e-67 | NTclustered | gi|2717321151|gb|PP173226.1| | 3130924 | g513722 | i0 | 88.393 | 157.857777777778 | 224 | 23 | 99 | 2 | 3 | 225 | 8270 | 8491 | MAG: Ripigleb virus isolate KCAP3_k141_261307 genomic sequence | blastn | 35518 | 267 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Ripigleb virus | |||
| 20246951 | 20246951 | PRJNA550047_P_NODE_20756_length_482_cov_3.476773_g18861_i0 | PRJNA550047 | 20756 | 482 | 3.476773 | 16.75804586 | Enterovirus | 12059 | Viruses | Viruses | 603 | 1.03e-167 | NTclustered | gi|1594445172|dbj|LC428166.1| | 463676 | g18861 | i0 | 99.104 | 88.7385892116183 | 335 | 3 | 93 | 0 | 148 | 482 | 344 | 10 | Rhinovirus C 0089-OsakaC-JPN-2016 gene for VP1 protein, partial cds | blastn | 42772 | 603 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus cerhino | ||
| 20919008 | 20919008 | PRJNA550047_P_NODE_47497_length_347_cov_8.343066_g45537_i0 | PRJNA550047 | 47497 | 347 | 8.343066 | 28.95043902 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 67.6 | 1.17e-6 | NTclustered | gi|2560502367|emb|OY629453.1| | 2697049 | g45537 | i0 | 91.667 | 11.8328530259366 | 48 | 4 | 14 | 0 | 15 | 62 | 5949 | 5902 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 4106 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 23469915 | 23469915 | PRJNA550047_P_NODE_531059_length_220_cov_6.265306_g529086_i0 | PRJNA550047 | 531059 | 220 | 6.265306 | 13.7836732 | Enterovirus cerhino | 3428504 | Viruses | Viruses | 383 | 6.08e-102 | NTclustered | gi|1726249435|gb|MN306023.1| | 463676 | g529086 | i0 | 98.174 | 72.0727272727273 | 219 | 4 | 99 | 0 | 1 | 219 | 4915 | 4697 | Rhinovirus C strain SC0323, complete genome | blastn | 15856 | 383 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Enterovirus | Enterovirus cerhino | ||
| 27204309 | 27204309 | PRJNA550047_P_NODE_41842_length_368_cov_4.237288_g39887_i0 | PRJNA550047 | 41842 | 368 | 4.237288 | 15.59321984 | Lysoka partiti-like virus | 2169481 | Viruses | Viruses | 101 | 3.27e-22 | NR | AWV67005.1 | 2169481 | g39887 | i0 | 79.7 | 0.480978260869565 | 59 | 12 | 48.1 | 0 | 368 | 192 | 43 | 101 | AWV67005.1 RdRp, partial [Lysoka partiti-like virus] | diamond | 177 | 101 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Lysoka partiti-like virus | |||
| 28909332 | 28909332 | PRJNA550047_P_NODE_208068_length_318_cov_4.975510_g206100_i0 | PRJNA550047 | 208068 | 318 | 4.97551 | 15.8221218 | Lysoka partiti-like virus | 2169481 | Viruses | Viruses | 92.4 | 2.64e-19 | NR | AWV67005.1 | 2169481 | g206100 | i0 | 50 | 0.905660377358491 | 96 | 42 | 86.8 | 3 | 2 | 277 | 367 | 460 | AWV67005.1 RdRp, partial [Lysoka partiti-like virus] | diamond | 288 | 92.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Lysoka partiti-like virus | |||
| 29730298 | 29730298 | PRJNA550047_P_NODE_25390_length_448_cov_15.338667_g23477_i0 | PRJNA550047 | 25390 | 448 | 15.338667 | 68.71722816 | Lysoka partiti-like virus | 2169481 | Viruses | Viruses | 136 | 2.17e-34 | NR | AWV67004.1 | 2169481 | g23477 | i0 | 39 | 1.37276785714286 | 205 | 65 | 97.1 | 2 | 11 | 445 | 329 | 533 | AWV67004.1 RdRp, partial [Lysoka partiti-like virus] | diamond | 615 | 136 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Lysoka partiti-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);;