contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB75227" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5238153 | 5238153 | PRJEB75227_P_NODE_10605_length_245_cov_1.581395_g10434_i0 | PRJEB75227 | 10605 | 245 | 1.581395 | 3.87441775 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 398 | 2.47e-106 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g10434 | i0 | 95.918 | 19.9918367346939 | 245 | 10 | 100 | 0 | 1 | 245 | 1096 | 852 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 4898 | 398 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 6513785 | 6513785 | PRJEB75227_P_NODE_7946_length_256_cov_1.278689_g7775_i0 | PRJEB75227 | 7946 | 256 | 1.278689 | 3.27344384 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 399 | 7.209999999999998e-107 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g7775 | i0 | 94.902 | 24.31640625 | 255 | 13 | 99 | 0 | 2 | 256 | 4852 | 5106 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 6225 | 399 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 9062956 | 9062956 | PRJEB75227_P_NODE_8148_length_253_cov_1.300000_g7977_i0 | PRJEB75227 | 8148 | 253 | 1.3 | 3.289 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 424 | 4.22e-114 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g7977 | i0 | 96.838 | 19.9288537549407 | 253 | 8 | 100 | 0 | 1 | 253 | 3185 | 2933 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 5042 | 424 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 11614163 | 11614163 | PRJEB75227_P_NODE_7470_length_264_cov_1.403141_g7299_i0 | PRJEB75227 | 7470 | 264 | 1.403141 | 3.70429224 | Sopafab virus | 3131770 | Viruses | Viruses | 424 | 4.44e-114 | NTclustered | gi|2717323354|gb|PP174071.1| | 3131770 | g7299 | i0 | 98.739 | 100.80303030303 | 238 | 3 | 90 | 0 | 27 | 264 | 310 | 73 | MAG: Sopafab virus isolate SP1C_k141_220867 genomic sequence | blastn | 26612 | 424 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopafab virus | |||||
| 12889246 | 12889246 | PRJEB75227_P_NODE_9831_length_248_cov_0.891429_g9660_i0 | PRJEB75227 | 9831 | 248 | 0.891429 | 2.21074392 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 407 | 4.16e-109 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g9660 | i0 | 96.356 | 16.9516129032258 | 247 | 9 | 99 | 0 | 1 | 247 | 3349 | 3595 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 4204 | 407 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 14164010 | 14164010 | PRJEB75227_P_NODE_3412_length_393_cov_0.971875_g3241_i0 | PRJEB75227 | 3412 | 393 | 0.971875 | 3.81946875 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 676 | 0 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g3241 | i0 | 97.71 | 35.0661577608142 | 393 | 9 | 100 | 0 | 1 | 393 | 5767 | 5375 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 13781 | 676 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 19261218 | 19261218 | PRJEB75227_P_NODE_4776_length_323_cov_1.228000_g4605_i0 | PRJEB75227 | 4776 | 323 | 1.228 | 3.96644 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 542 | 1.48e-149 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g4605 | i0 | 96.904 | 20.8049535603715 | 323 | 10 | 100 | 0 | 1 | 323 | 2546 | 2224 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 6720 | 542 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 20536550 | 20536550 | PRJEB75227_P_NODE_2837_length_440_cov_1.700272_g2666_i0 | PRJEB75227 | 2837 | 440 | 1.700272 | 7.4811968 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 664 | 0 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g2666 | i0 | 93.864 | 17.1977272727273 | 440 | 27 | 100 | 0 | 1 | 440 | 4796 | 4357 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 7567 | 664 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 23087450 | 23087450 | PRJEB75227_P_NODE_4559_length_332_cov_1.528958_g4388_i0 | PRJEB75227 | 4559 | 332 | 1.528958 | 5.07614056 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 499 | 9.29e-137 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g4388 | i0 | 93.939 | 10.8734939759036 | 330 | 20 | 99 | 0 | 3 | 332 | 1658 | 1329 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 3610 | 499 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii |
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);;