contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1136957" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 284576 | 284576 | PRJNA1136957_S_NODE_16141_length_217_cov_1.158228_g16044_i0 | PRJNA1136957 | 16141 | 217 | 1.158228 | 2.51335476 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.5 | 1.13e-14 | NTclustered | gi|2059642312|tpg|BK028639.1| | 2832643 | g16044 | i0 | 100 | 0.230414746543779 | 50 | 0 | 23 | 0 | 1 | 50 | 36832 | 36881 | MAG TPA_asm: Caudoviricetes sp. isolate ctcSv2, partial genome | blastn | 50 | 93.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1559171 | 1559171 | PRJNA1136957_S_NODE_16702_length_213_cov_1.850649_g16605_i0 | PRJNA1136957 | 16702 | 213 | 1.850649 | 3.94188237 | Moovirus moo | 3060392 | Viruses | Viruses | 344 | 2.76e-90 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g16605 | i0 | 95.775 | 9.22065727699531 | 213 | 9 | 100 | 0 | 1 | 213 | 18536 | 18324 | Shigella virus Moo19, complete genome | blastn | 1964 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 2307313 | 2307313 | PRJNA1136957_S_NODE_11282_length_255_cov_1.091837_g11185_i0 | PRJNA1136957 | 11282 | 255 | 1.091837 | 2.78418435 | Gammaretrovirus | 153135 | Viruses | Viruses | 377 | 3.37e-100 | NTclustered | gi|509019|gb|M59898.1|MCFENVBE | 11785 | g11185 | i0 | 96.491 | 123.019607843137 | 228 | 8 | 89 | 0 | 1 | 228 | 477 | 250 | Mink cell focus-forming virus proviral long terminal repeat, clone TE3/3 | blastn | 31370 | 377 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 2835270 | 2835270 | PRJNA1136957_S_NODE_3423_length_403_cov_8.293605_g3326_i0 | PRJNA1136957 | 3423 | 403 | 8.293605 | 33.42322815 | Potexvirus pepini | 3433856 | Viruses | Viruses | 728 | 0 | NTclustered | gi|1674914793|gb|MK391570.1| | 112229 | g3326 | i0 | 99.5 | 95.3126550868486 | 400 | 2 | 99 | 0 | 1 | 400 | 6016 | 6415 | Pepino mosaic virus isolate PMV/DIA131, complete genome | blastn | 38411 | 728 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 4860079 | 4860079 | PRJNA1136957_S_NODE_20904_length_193_cov_0.910448_g20807_i0 | PRJNA1136957 | 20904 | 193 | 0.910448 | 1.75716464 | Pandoravirus | 2060084 | Viruses | Viruses | 52.8 | 0.017 | NTclustered | gi|751661011|gb|KP136319.1| | 1605721 | g20807 | i0 | 100 | 0.435233160621762 | 28 | 0 | 15 | 0 | 165 | 192 | 1403389 | 1403362 | Pandoravirus inopinatum isolate KlaHel, complete genome | blastn | 84 | 52.8 | 1 | Viruses | Pandoravirus | Pandoravirus inopinatum | |||||||
| 5387753 | 5387753 | PRJNA1136957_S_NODE_12205_length_246_cov_1.957219_g12108_i0 | PRJNA1136957 | 12205 | 246 | 1.957219 | 4.81475874 | Potexvirus pepini | 3433856 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|336288971|gb|HQ663890.1| | 112229 | g12108 | i0 | 100 | 57.9918699186992 | 246 | 0 | 100 | 0 | 1 | 246 | 1699 | 1454 | Pepino mosaic virus isolate SAR09, complete genome | blastn | 14266 | 455 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 6662409 | 6662409 | PRJNA1136957_S_NODE_15026_length_224_cov_1.472727_g14929_i0 | PRJNA1136957 | 15026 | 224 | 1.472727 | 3.29890848 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 161 | 3.1699999999999996e-35 | NTclustered | gi|2059642312|tpg|BK028639.1| | 2832643 | g14929 | i0 | 90.909 | 0.540178571428571 | 121 | 9 | 54 | 2 | 100 | 219 | 16879 | 16998 | MAG TPA_asm: Caudoviricetes sp. isolate ctcSv2, partial genome | blastn | 121 | 161 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6662457 | 6662457 | PRJNA1136957_S_NODE_3666_length_395_cov_2.261905_g3569_i0 | PRJNA1136957 | 3666 | 395 | 2.261905 | 8.93452475 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g3569 | i0 | 100 | 0.146835443037975 | 30 | 0 | 8 | 0 | 1 | 30 | 6 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 10488142 | 10488142 | PRJNA1136957_S_NODE_19329_length_199_cov_0.871429_g19232_i0 | PRJNA1136957 | 19329 | 199 | 0.871429 | 1.73414371 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 237 | 4.44e-58 | NTclustered | gi|2239998150|gb|ON160022.1| | 2936548 | g19232 | i0 | 92.683 | 0.824120603015075 | 164 | 12 | 82 | 0 | 35 | 198 | 841 | 1004 | Red mite associated cystovirus isolate RMACTV1-L P14, P15, P7, P2, P4, and P1 genes, complete cds | blastn | 164 | 237 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 11235365 | 11235365 | PRJNA1136957_S_NODE_4589_length_366_cov_1.397394_g4492_i0 | PRJNA1136957 | 4589 | 366 | 1.397394 | 5.11446204 | Potexvirus | 12176 | Viruses | Viruses | 676 | 0 | NTclustered | gi|957761914|gb|KT253432.1| | 112229 | g4492 | i0 | 100 | 90.3579234972678 | 366 | 0 | 100 | 0 | 1 | 366 | 529 | 164 | Pepino mosaic virus isolate MA10 RNA-dependent RNA polymerase (RdRp) gene, partial cds | blastn | 33071 | 676 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 15587465 | 15587465 | PRJNA1136957_S_NODE_16973_length_211_cov_2.427632_g16876_i0 | PRJNA1136957 | 16973 | 211 | 2.427632 | 5.12230352 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|306477570|gb|HM990251.1| | 11676 | g16876 | i0 | 100 | 1.06161137440758 | 28 | 0 | 13 | 0 | 50 | 77 | 2451 | 2478 | HIV-1 isolate pt_12 clone 17 from Italy pol protein (pol) gene, partial cds | blastn | 224 | 52.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 15587467 | 15587467 | PRJNA1136957_S_NODE_17173_length_210_cov_2.019868_g17076_i0 | PRJNA1136957 | 17173 | 210 | 2.019868 | 4.2417228 | Pseudomonas phage ER16 | 2917704 | Viruses | Viruses | 193 | 1.04e-44 | NTclustered | gi|2209092829|gb|OM650250.1| | 2917704 | g17076 | i0 | 83.333 | 1 | 210 | 34 | 100 | 1 | 1 | 210 | 967 | 1175 | Pseudomonas phage ER16 segment S, complete sequence | blastn | 210 | 193 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Pseudomonas phage ER16 | |||
| 16861666 | 16861666 | PRJNA1136957_S_NODE_12974_length_239_cov_2.605556_g12877_i0 | PRJNA1136957 | 12974 | 239 | 2.605556 | 6.22727884 | Orthopoxvirus monkeypox | 3431483 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2309594316|gb|OP536747.1| | 10244 | g12877 | i0 | 100 | 12.1338912133891 | 29 | 0 | 12 | 0 | 137 | 165 | 119274 | 119302 | Monkeypox virus isolate 9000365, partial genome | blastn | 2900 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 18136307 | 18136307 | PRJNA1136957_S_NODE_19895_length_197_cov_0.855072_g19798_i0 | PRJNA1136957 | 19895 | 197 | 0.855072 | 1.68449184 | Moovirus moo | 3060392 | Viruses | Viruses | 353 | 4.18e-93 | NTclustered | gi|2438080420|ref|NC_070850.1| | 2886042 | g19798 | i0 | 98.985 | 29.5583756345178 | 197 | 2 | 100 | 0 | 1 | 197 | 58212 | 58408 | Shigella virus Moo19, complete genome | blastn | 5823 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Moovirus | Moovirus moo | |||
| 20686024 | 20686024 | PRJNA1136957_S_NODE_4857_length_358_cov_1.254181_g4760_i0 | PRJNA1136957 | 4857 | 358 | 1.254181 | 4.48996798 | Varicellovirus cervidalpha2 | 3050260 | Viruses | Viruses | 63.9 | 1.57e-5 | NTclustered | gi|2500372361|ref|NC_075563.1| | 365327 | g4760 | i0 | 84.615 | 1.09497206703911 | 65 | 8 | 18 | 2 | 251 | 314 | 94531 | 94594 | Cervid alphaherpesvirus 2 strain Norway, complete genome | blastn | 392 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus cervidalpha2 | ||
| 20686046 | 20686046 | PRJNA1136957_S_NODE_9237_length_279_cov_1.109091_g9140_i0 | PRJNA1136957 | 9237 | 279 | 1.109091 | 3.09436389 | Pijolavirus UFJFPfSW6 | 3431677 | Viruses | Viruses | 488 | 1.6499999999999999e-133 | NTclustered | gi|2416396763|gb|OP924544.1| | 3003725 | g9140 | i0 | 98.208 | 3.86021505376344 | 279 | 5 | 100 | 0 | 1 | 279 | 36140 | 36418 | Pseudomonas phage UFJF_PfSW6, complete genome | blastn | 1077 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Pijolavirus | Pijolavirus UFJFPfSW6 |
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);;