contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA665531" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3180104 | 3180104 | PRJNA665531_P_NODE_11943_length_300_cov_2.440529_g11707_i0 | PRJNA665531 | 11943 | 300 | 2.440529 | 7.321587 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 512 | 1.07e-140 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g11707 | i0 | 99.643 | 0.933333333333333 | 280 | 1 | 93 | 0 | 21 | 300 | 799 | 520 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 280 | 512 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 7007948 | 7007948 | PRJNA665531_P_NODE_16706_length_253_cov_1.238889_g16470_i0 | PRJNA665531 | 16706 | 253 | 1.238889 | 3.13438917 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 468 | 1.92e-127 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g16470 | i0 | 100 | 1 | 253 | 0 | 100 | 0 | 1 | 253 | 3028 | 2776 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 253 | 468 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 8282643 | 8282643 | PRJNA665531_P_NODE_2927_length_667_cov_1.437710_g2705_i0 | PRJNA665531 | 2927 | 667 | 1.43771 | 9.5895257 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 797 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g2705 | i0 | 88.386 | 0.99400299850075 | 663 | 75 | 99 | 2 | 6 | 667 | 1925 | 2586 | Malassezia restricta virus MrV40L, complete genome | blastn | 663 | 797 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9557711 | 9557711 | PRJNA665531_P_NODE_12288_length_296_cov_1.381166_g12052_i0 | PRJNA665531 | 12288 | 296 | 1.381166 | 4.08825136 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 516 | 8.11e-142 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g12052 | i0 | 98.311 | 1 | 296 | 2 | 100 | 1 | 1 | 296 | 2215 | 2507 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 296 | 516 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 17207492 | 17207492 | PRJNA665531_P_NODE_3494_length_606_cov_1.632270_g3267_i0 | PRJNA665531 | 3494 | 606 | 1.63227 | 9.8915562 | Totivirus sp. | 2776824 | Viruses | Viruses | 429 | 2.37e-115 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g3267 | i0 | 81.89 | 1.1963696369637 | 508 | 92 | 84 | 0 | 13 | 520 | 832 | 1339 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 725 | 429 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 18481848 | 18481848 | PRJNA665531_P_NODE_35_length_2724_cov_21.030177_g28_i0 | PRJNA665531 | 35 | 2724 | 21.030177 | 572.86202148 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 4748 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g28 | i0 | 98.372 | 1.43355359765051 | 2703 | 44 | 99 | 0 | 1 | 2703 | 2703 | 1 | Malassezia restricta virus MrV40L, complete genome | blastn | 3905 | 4748 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 19756106 | 19756106 | PRJNA665531_P_NODE_11056_length_313_cov_1.283333_g10820_i0 | PRJNA665531 | 11056 | 313 | 1.283333 | 4.01683229 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 579 | 1.0899999999999999e-160 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g10820 | i0 | 100 | 1.89137380191693 | 313 | 0 | 100 | 0 | 1 | 313 | 1253 | 941 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 592 | 579 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 19756444 | 19756444 | PRJNA665531_P_NODE_6016_length_441_cov_1.796196_g5780_i0 | PRJNA665531 | 6016 | 441 | 1.796196 | 7.92122436 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 815 | 0 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g5780 | i0 | 100 | 1 | 441 | 0 | 100 | 0 | 1 | 441 | 799 | 1239 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 441 | 815 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 22306516 | 22306516 | PRJNA665531_P_NODE_1198_length_1063_cov_49.200000_g1069_i0 | PRJNA665531 | 1198 | 1063 | 49.2 | 522.996 | Totivirus sp. | 2776824 | Viruses | Viruses | 630 | 1.0899999999999997e-175 | NTclustered | gi|1918615619|gb|MT949668.1| | 2776824 | g1069 | i0 | 81.952 | 0.703668861712135 | 748 | 131 | 70 | 4 | 129 | 874 | 1 | 746 | Totivirus sp. isolate sequence_10295 genomic sequence | blastn | 748 | 630 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 22306604 | 22306604 | PRJNA665531_P_NODE_15898_length_259_cov_2.080645_g15662_i0 | PRJNA665531 | 15898 | 259 | 2.080645 | 5.38887055 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 263 | 1e-65 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g15662 | i0 | 95.706 | 1 | 163 | 7 | 63 | 0 | 1 | 163 | 163 | 1 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 259 | 263 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 23582203 | 23582203 | PRJNA665531_P_NODE_7399_length_391_cov_2.292453_g7163_i0 | PRJNA665531 | 7399 | 391 | 2.292453 | 8.96349123 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 656 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g7163 | i0 | 96.931 | 1.77493606138107 | 391 | 12 | 100 | 0 | 1 | 391 | 3260 | 2870 | Malassezia restricta virus MrV40L, complete genome | blastn | 694 | 656 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 24855831 | 24855831 | PRJNA665531_P_NODE_8660_length_358_cov_1.487719_g8424_i0 | PRJNA665531 | 8660 | 358 | 1.487719 | 5.32603402 | Totivirus sp. | 2776824 | Viruses | Viruses | 296 | 1.42e-75 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g8424 | i0 | 82.738 | 1.36033519553073 | 336 | 54 | 93 | 4 | 1 | 334 | 898 | 1231 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 487 | 296 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus 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);;