RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJEB75227" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 19 ✖

bioproject 1

  • PRJEB75227 · 19 ✖

analysis 1

  • blastn · 19 ✖

tax_clade 0

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
135616 135616 PRJEB75227_P_NODE_11421_length_243_cov_0.917647_g11250_i0 PRJEB75227 11421 243 0.917647 2.22988221 Caudoviricetes sp. 2832643 Viruses Viruses 333 6.989999999999999e-87   NTclustered gi|2914753680|gb|OR221409.1| 2832643 g11250 i0 91.358 3.03292181069959 243 21 100 0 1 243 36180 36422 MAG: Caudoviricetes sp. isolate MSP1678 genomic sequence blastn 737 333 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
135652 135652 PRJEB75227_P_NODE_6901_length_273_cov_1.660000_g6730_i0 PRJEB75227 6901 273 1.66 4.5318 Pseudomonas phage PS-1 1573458 Viruses Viruses 326 1.34e-84   NTclustered gi|985757644|ref|NC_029066.1| 1573458 g6730 i0 88.235 0.996336996336996 272 32 99 0 2 273 28496 28225 Pseudomonas phage PS-1 DNA, complete sequence blastn 272 326 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage PS-1
135660 135660 PRJEB75227_P_NODE_8461_length_252_cov_0.871508_g8290_i0 PRJEB75227 8461 252 0.871508 2.19620016 Caudoviricetes sp. 2832643 Viruses Viruses 422 1.51e-113   NTclustered gi|2059825520|tpg|BK040067.1| 2832643 g8290 i0 96.825 20.0396825396825 252 8 100 0 1 252 11099 11350 MAG TPA_asm: Caudoviricetes sp. isolate ctJwv2, partial genome blastn 5050 422 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
2685755 2685755 PRJEB75227_P_NODE_9083_length_250_cov_0.881356_g8912_i0 PRJEB75227 9083 250 0.881356 2.20339 Caudoviricetes sp. 2832643 Viruses Viruses 78.7 3.74e-10   NTclustered gi|2914887418|gb|OR222536.1| 2832643 g8912 i0 94.118 0.608 51 3 20 0 46 96 9501 9451 MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence blastn 152 78.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
6513729 6513729 PRJEB75227_P_NODE_10886_length_245_cov_0.906977_g10715_i0 PRJEB75227 10886 245 0.906977 2.22209365 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 403 5.299999999999998e-108   NTclustered gi|1707910805|gb|MK892832.1| 2591644 g10715 i0 96.694 0.987755102040816 242 8 99 0 4 245 67477 67236 MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome blastn 242 403 1 Viruses               Prokaryotic dsDNA virus sp.
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
14164032 14164032 PRJEB75227_P_NODE_6852_length_274_cov_1.407960_g6681_i0 PRJEB75227 6852 274 1.40796 3.8578104 Caudoviricetes sp. 2832643 Viruses Viruses 63.9 1.16e-5   NTclustered gi|2054560186|tpg|BK048230.1| 2832643 g6681 i0 88.889 0.197080291970803 54 3 19 3 160 212 39598 39649 MAG TPA_asm: Caudoviricetes sp. isolate ctSe04, partial genome blastn 54 63.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
14164036 14164036 PRJEB75227_P_NODE_7392_length_265_cov_1.625000_g7221_i0 PRJEB75227 7392 265 1.625 4.30625 Pormufvirus salinum 3431827 Viruses Viruses 171 6.41e-38   NTclustered gi|2231638396|ref|NC_062761.1| 2878009 g7221 i0 80 0.943396226415094 250 34 94 10 17 265 12526 12292 Halorubrum virus HRTV-28, complete genome blastn 250 171 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Suolaviridae Pormufvirus Pormufvirus salinum
15023558 15023558 PRJEB75227_P_NODE_11052_length_244_cov_0.912281_g10881_i0 PRJEB75227 11052 244 0.912281 2.22596564 Viruses 10239 Viruses Viruses 296 9.21e-76   NTclustered gi|2548228115|gb|MZ573780.2| 2861056 g10881 i0 88.797 1.98770491803279 241 27 99 0 1 241 120320 120560 Mammaliicoccus phage vB_MscM-PMS3, complete genome blastn 485 296 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae   Mammaliicoccus phage vB_MscM-PMS3
15438129 15438129 PRJEB75227_P_NODE_7993_length_255_cov_1.714286_g7822_i0 PRJEB75227 7993 255 1.714286 4.3714293 Caudoviricetes sp. 2832643 Viruses Viruses 472 1.5e-128   NTclustered gi|2914852811|gb|OR221766.1| 2832643 g7822 i0 100 1 255 0 100 0 1 255 18855 19109 MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence blastn 255 472 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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
21812444 21812444 PRJEB75227_P_NODE_6618_length_278_cov_1.258537_g6447_i0 PRJEB75227 6618 278 1.258537 3.49873286 Percavirus equidgamma2 3050281 Viruses Viruses 353 6.26e-93   NTclustered gi|2271301500|gb|MW322569.1| 12657 g6447 i0 89.606 14.7086330935252 279 28 100 1 1 278 104003 104281 Equid gammaherpesvirus 2 strain 1-141/67, complete genome blastn 4089 353 1 Viruses   Heunggongvirae Peploviricota Herviviricetes Herpesvirales Orthoherpesviridae Percavirus Percavirus equidgamma2
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

CSV options: 

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);;