contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA527965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4323773 | 4323773 | PRJNA527965_S_NODE_1564_length_309_cov_65.069343_g1481_i0 | PRJNA527965 | 1564 | 309 | 65.069343 | 201.06426987 | Sopozig virus | 3131662 | Viruses | Viruses | 492 | 1.4299999999999999e-134 | NTclustered | gi|2717323079|gb|PP173963.1| | 3131662 | g1481 | i0 | 96.622 | 266.466019417476 | 296 | 10 | 96 | 0 | 4 | 299 | 588 | 293 | MAG: Sopozig virus isolate SP1B_k141_130621 genomic sequence | blastn | 82338 | 492 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Sopozig virus | |||
| 6874521 | 6874521 | PRJNA527965_S_NODE_2506_length_243_cov_14.793269_g2423_i0 | PRJNA527965 | 2506 | 243 | 14.793269 | 35.94764367 | Chronaparn virus | 3129907 | Viruses | Viruses | 87.9 | 6e-13 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g2423 | i0 | 90 | 13.559670781893 | 70 | 3 | 27 | 3 | 1 | 66 | 3687 | 3756 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 3295 | 87.9 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 9425158 | 9425158 | PRJNA527965_S_NODE_4928_length_168_cov_10.939850_g4845_i0 | PRJNA527965 | 4928 | 168 | 10.93985 | 18.378948 | Chronaparn virus | 3129907 | Viruses | Viruses | 76.8 | 8.37e-10 | NTclustered | gi|2717318620|gb|PP172304.1| | 3129907 | g4845 | i0 | 91.228 | 19.6964285714286 | 57 | 4 | 33 | 1 | 1 | 56 | 3687 | 3743 | MAG: Chronaparn virus isolate CN1B_k141_97147 genomic sequence | blastn | 3309 | 76.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronaparn virus | |||
| 11975631 | 11975631 | PRJNA527965_S_NODE_2850_length_227_cov_0.921875_g2767_i0 | PRJNA527965 | 2850 | 227 | 0.921875 | 2.09265625 | Pahexavirus procrass1 | 1982304 | Viruses | Viruses | 407 | 3.7499999999999994e-109 | NTclustered | gi|906476013|ref|NC_027626.1| | 1655019 | g2767 | i0 | 99.115 | 99.0748898678414 | 226 | 2 | 99 | 0 | 1 | 226 | 5597 | 5372 | Propionibacterium phage Procrass1, complete genome | blastn | 22490 | 407 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus procrass1 | ||||
| 12593308 | 12593308 | PRJNA527965_S_NODE_5010_length_167_cov_2.227273_g4927_i0 | PRJNA527965 | 5010 | 167 | 2.227273 | 3.71954591 | Pahexavirus | 1982251 | Viruses | Viruses | 298 | 1.63e-76 | NTclustered | gi|330858398|ref|NC_015454.1| | 504501 | g4927 | i0 | 98.81 | 87.6766467065868 | 168 | 1 | 100 | 1 | 1 | 167 | 26322 | 26489 | Propionibacterium phage PAD20 endogenous virus, complete genome | blastn | 14642 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PAD20 | ||||
| 13250746 | 13250746 | PRJNA527965_S_NODE_3731_length_197_cov_2.253086_g3648_i0 | PRJNA527965 | 3731 | 197 | 2.253086 | 4.43857942 | Chronazork virus | 3129863 | Viruses | Viruses | 91.6 | 3.62e-14 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g3648 | i0 | 90 | 0.532994923857868 | 70 | 7 | 36 | 0 | 3 | 72 | 97 | 166 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 105 | 91.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 14525808 | 14525808 | PRJNA527965_S_NODE_5492_length_160_cov_1.264000_g5409_i0 | PRJNA527965 | 5492 | 160 | 1.264 | 2.0224 | Propionibacterium phage pa63 | 2079410 | Viruses | Viruses | 267 | 4.35e-67 | NTclustered | gi|1338076744|gb|MG820637.1| | 2079410 | g5409 | i0 | 96.855 | 99.28125 | 159 | 5 | 99 | 0 | 1 | 159 | 6789 | 6947 | Propionibacterium phage pa63, complete genome | blastn | 15885 | 267 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa63 | ||||
| 15799523 | 15799523 | PRJNA527965_S_NODE_3353_length_208_cov_2.254335_g3270_i0 | PRJNA527965 | 3353 | 208 | 2.254335 | 4.6890168 | Sopawad virus | 3131649 | Viruses | Viruses | 281 | 2.13e-71 | NTclustered | gi|2717323044|gb|PP173950.1| | 3131649 | g3270 | i0 | 91.748 | 9.87019230769231 | 206 | 12 | 98 | 4 | 3 | 206 | 4340 | 4138 | MAG: Sopawad virus isolate SP1A_k141_78953 genomic sequence | blastn | 2053 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawad virus | |||||
| 17074188 | 17074188 | PRJNA527965_S_NODE_4254_length_183_cov_3.763514_g4171_i0 | PRJNA527965 | 4254 | 183 | 3.763514 | 6.88723062 | Chronazork virus | 3129863 | Viruses | Viruses | 124 | 3.26e-24 | NTclustered | gi|2717318517|gb|PP172260.1| | 3129863 | g4171 | i0 | 81.437 | 0.912568306010929 | 167 | 18 | 85 | 11 | 5 | 160 | 264 | 100 | MAG: Chronazork virus isolate CN1B_k141_46390 genomic sequence | blastn | 167 | 124 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazork virus | |||||
| 18965929 | 18965929 | PRJNA527965_S_NODE_4415_length_179_cov_2.576389_g4332_i0 | PRJNA527965 | 4415 | 179 | 2.576389 | 4.61173631 | Pahexavirus | 1982251 | Viruses | Viruses | 326 | 8.09e-85 | NTclustered | gi|408905837|ref|NC_018842.1| | 1229792 | g4332 | i0 | 99.441 | 100.134078212291 | 179 | 1 | 100 | 0 | 1 | 179 | 162 | 340 | Propionibacterium phage P1.1, complete genome | blastn | 17924 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P11 | ||||
| 19622885 | 19622885 | PRJNA527965_S_NODE_2616_length_237_cov_6.945545_g2533_i0 | PRJNA527965 | 2616 | 237 | 6.945545 | 16.46094165 | Ripasluj virus | 3131271 | Viruses | Viruses | 220 | 5.51e-53 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g2533 | i0 | 85.253 | 56.9831223628692 | 217 | 28 | 92 | 4 | 10 | 226 | 213 | 1 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 13505 | 220 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj virus | |||||
| 22173688 | 22173688 | PRJNA527965_S_NODE_4538_length_176_cov_10.645390_g4455_i0 | PRJNA527965 | 4538 | 176 | 10.64539 | 18.7358864 | Ripasluj virus | 3131271 | Viruses | Viruses | 111 | 2.42e-20 | NTclustered | gi|2717322074|gb|PP173573.1| | 3131271 | g4455 | i0 | 78.771 | 35.6647727272727 | 179 | 28 | 100 | 8 | 1 | 176 | 48 | 219 | MAG: Ripasluj virus isolate MP3_k141_176986 genomic sequence | blastn | 6277 | 111 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripasluj 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);;