contig_metadata
16 rows where bioproject = "PRJNA513467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486637 | 486637 | PRJNA513467_S_NODE_3741_length_200_cov_2.024540_g3718_i0 | PRJNA513467 | 3741 | 200 | 2.02454 | 4.04908 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|2054548793|tpg|BK048005.1| | 2832643 | g3718 | i0 | 100 | 0.14 | 28 | 0 | 14 | 0 | 171 | 198 | 12018 | 12045 | MAG TPA_asm: Caudoviricetes sp. isolate ct5Sd10, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 486658 | 486658 | PRJNA513467_S_NODE_5481_length_175_cov_1.586957_g5458_i0 | PRJNA513467 | 5481 | 175 | 1.586957 | 2.77717475 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 270 | 3.739999999999999e-68 | NTclustered | gi|1240393784|gb|MF141071.1| | 2034334 | g5458 | i0 | 96.341 | 3.76 | 164 | 6 | 94 | 0 | 3 | 166 | 2018 | 1855 | Norway luteo-like virus 4 isolate NOR/S5/Kilen/2014 RNA-dependent RNA-polymerase gene, partial cds | blastn | 658 | 270 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 1761857 | 1761857 | PRJNA513467_S_NODE_2382_length_235_cov_89.878788_g2359_i0 | PRJNA513467 | 2382 | 235 | 89.878788 | 211.2151518 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 75 | 4.49e-9 | NTclustered | gi|2565352131|emb|OY625234.1| | 2697049 | g2359 | i0 | 94 | 16.4382978723404 | 50 | 2 | 21 | 1 | 185 | 233 | 23673 | 23722 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3863 | 75 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 3037698 | 3037698 | PRJNA513467_S_NODE_1203_length_306_cov_2.375465_g1180_i0 | PRJNA513467 | 1203 | 306 | 2.375465 | 7.2689229 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 553 | 6.419999999999998e-153 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g1180 | i0 | 99.669 | 2.91830065359477 | 302 | 1 | 99 | 0 | 5 | 306 | 4522 | 4221 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 893 | 553 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 5590504 | 5590504 | PRJNA513467_S_NODE_4725_length_184_cov_2.387755_g4702_i0 | PRJNA513467 | 4725 | 184 | 2.387755 | 4.3934692 | Plant associated sequivirus 3 | 2950831 | Viruses | Viruses | 261 | 2.39e-65 | NTclustered | gi|2273760649|gb|OL472184.1| | 2950831 | g4702 | i0 | 92.391 | 5.45108695652174 | 184 | 13 | 99 | 1 | 2 | 184 | 10123 | 9940 | MAG: Plant associated sequivirus 3 isolate PLE20SW, complete genome | blastn | 1003 | 261 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Sequivirus | Plant associated sequivirus 3 | ||
| 10690438 | 10690438 | PRJNA513467_S_NODE_2809_length_221_cov_2.505435_g2786_i0 | PRJNA513467 | 2809 | 221 | 2.505435 | 5.53701135 | Allexivirus ecsallii | 3433712 | Viruses | Viruses | 375 | 1.0199999999999998e-99 | NTclustered | gi|1722561625|gb|MN059411.1| | 150284 | g2786 | i0 | 97.285 | 93.5927601809955 | 221 | 6 | 100 | 0 | 1 | 221 | 7874 | 7654 | Garlic virus X isolate G40, complete genome | blastn | 20684 | 375 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus ecsallii | ||
| 10690474 | 10690474 | PRJNA513467_S_NODE_549_length_421_cov_2.140625_g526_i0 | PRJNA513467 | 549 | 421 | 2.140625 | 9.01203125 | Allexivirus ecsallii | 3433712 | Viruses | Viruses | 656 | 0 | NTclustered | gi|410131120|gb|JQ807994.1| | 150284 | g526 | i0 | 94.774 | 89.1615201900238 | 421 | 22 | 100 | 0 | 1 | 421 | 7948 | 8368 | Garlic virus X isolate SW3, complete genome | blastn | 37537 | 656 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus ecsallii | ||
| 11965421 | 11965421 | PRJNA513467_S_NODE_3150_length_213_cov_1.363636_g3127_i0 | PRJNA513467 | 3150 | 213 | 1.363636 | 2.90454468 | Fabavirus alphaviciae | 3047701 | Viruses | Viruses | 298 | 2.18e-76 | NTclustered | gi|2904963151|gb|PQ789800.1| | 50817 | g3127 | i0 | 91.981 | 13.3990610328638 | 212 | 17 | 99 | 0 | 1 | 212 | 5784 | 5573 | Broad bean wilt virus 1 isolate QLD-5612 segment RNA1 polyprotein gene, complete cds | blastn | 2854 | 298 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Fabavirus | Fabavirus alphaviciae | ||
| 11965447 | 11965447 | PRJNA513467_S_NODE_530_length_426_cov_5.053985_g507_i0 | PRJNA513467 | 530 | 426 | 5.053985 | 21.5299761 | Erysiphe necator associated deltaflexivirus 4 | 2743097 | Viruses | Viruses | 754 | 0 | NTclustered | gi|2288523299|gb|ON811606.1| | 2743097 | g507 | i0 | 100 | 3.13145539906103 | 408 | 0 | 96 | 0 | 19 | 426 | 7113 | 6706 | MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome | blastn | 1334 | 754 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 4 | ||
| 14515608 | 14515608 | PRJNA513467_S_NODE_2852_length_220_cov_5.464481_g2829_i0 | PRJNA513467 | 2852 | 220 | 5.464481 | 12.0218582 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 407 | 3.61e-109 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g2829 | i0 | 100 | 1 | 220 | 0 | 100 | 0 | 1 | 220 | 5759 | 5540 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 220 | 407 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 18338336 | 18338336 | PRJNA513467_S_NODE_3675_length_201_cov_2.548780_g3652_i0 | PRJNA513467 | 3675 | 201 | 2.54878 | 5.1230478 | Crogonang virus 69 | 3063080 | Viruses | Viruses | 265 | 2.06e-66 | NTclustered | gi|2626079622|gb|OR270394.1| | 3063080 | g3652 | i0 | 95.21 | 4.59203980099502 | 167 | 8 | 83 | 0 | 35 | 201 | 3122 | 2956 | MAG: Crogonang virus 69 isolate CGH03 genomic sequence | blastn | 923 | 265 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Crogonang virus 69 | ||||
| 18338389 | 18338389 | PRJNA513467_S_NODE_7935_length_153_cov_1.793103_g7912_i0 | PRJNA513467 | 7935 | 153 | 1.793103 | 2.74344759 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 4.0799999999999995e-72 | NTclustered | gi|2906147942|gb|PQ646354.1| | 2832643 | g7912 | i0 | 100 | 1 | 153 | 0 | 100 | 0 | 1 | 153 | 19584 | 19432 | MAG: Caudoviricetes sp. isolate k127_298828 genomic sequence | blastn | 153 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19612684 | 19612684 | PRJNA513467_S_NODE_1476_length_284_cov_2.668016_g1453_i0 | PRJNA513467 | 1476 | 284 | 2.668016 | 7.57716544 | Ripabiq virus | 3130194 | Viruses | Viruses | 196 | 1.14e-45 | NTclustered | gi|2717319120|gb|PP172496.1| | 3130194 | g1453 | i0 | 84.848 | 18.8908450704225 | 198 | 26 | 69 | 4 | 83 | 278 | 364 | 169 | MAG: Ripabiq virus isolate DRCP1_k141_78731 genomic sequence | blastn | 5365 | 196 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripabiq virus | |||||
| 20237339 | 20237339 | PRJNA513467_S_NODE_3836_length_198_cov_44.192547_g3813_i0 | PRJNA513467 | 3836 | 198 | 44.192547 | 87.50124306 | root | 1 | Root_unresolved | Root_unresolved | 316 | 5.51e-82 | NTclustered | gi|671698184|gb|KM192300.1| | 10359 | g3813 | i0 | 95.455 | 102 | 198 | 9 | 100 | 0 | 1 | 198 | 39032 | 39229 | Human herpesvirus 5 strain Merlin isolate RCMV1528, complete genome | blastn | 20196 | 316 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 29193120 | 29193120 | PRJNA513467_S_NODE_1369_length_292_cov_2.086275_g1346_i0 | PRJNA513467 | 1369 | 292 | 2.086275 | 6.091923 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 40.4 | 0.0365 | NR | XOS44195.1 | 2832643 | g1346 | i0 | 54.5 | 0.339041095890411 | 33 | 13 | 33.9 | 1 | 109 | 207 | 8 | 38 | XOS44195.1 MAG: hypothetical protein MSP0939_64 [Caudoviricetes sp.] | diamond | 99 | 40.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29713138 | 29713138 | PRJNA513467_S_NODE_6410_length_165_cov_2.742188_g6387_i0 | PRJNA513467 | 6410 | 165 | 2.742188 | 4.5246102 | Gamaleyavirus | 1920753 | Viruses | Viruses | 48.9 | 8.58e-5 | NR | DAE39455.1 | 38018 | g6387 | i0 | 51 | 3.81818181818182 | 51 | 25 | 92.7 | 0 | 164 | 12 | 122 | 172 | DAE39455.1 MAG TPA: RNA polymerase [Bacteriophage sp.] | diamond | 630 | 48.9 | 1 | Viruses | Bacteriophage 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);;