contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2166613 | 2166613 | PRJNA911178_P_NODE_105042_length_354_cov_1.128114_g102570_i0 | PRJNA911178 | 105042 | 354 | 1.128114 | 3.99352356 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 501 | 2.77e-137 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g102570 | i0 | 93.023 | 1.7316384180791 | 344 | 22 | 97 | 2 | 12 | 354 | 808 | 466 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 613 | 501 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 8545419 | 8545419 | PRJNA911178_P_NODE_246367_length_250_cov_0.870056_g243893_i0 | PRJNA911178 | 246367 | 250 | 0.870056 | 2.17514 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 357 | 4.28e-94 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g243893 | i0 | 92.771 | 0.996 | 249 | 14 | 98 | 3 | 5 | 249 | 575 | 823 | Malassezia restricta virus MrV40S, complete genome | blastn | 249 | 357 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 9820612 | 9820612 | PRJNA911178_P_NODE_271548_length_245_cov_0.895349_g269074_i0 | PRJNA911178 | 271548 | 245 | 0.895349 | 2.19360505 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 422 | 1.46e-113 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g269074 | i0 | 99.145 | 0.955102040816327 | 234 | 2 | 96 | 0 | 1 | 234 | 493 | 726 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 234 | 422 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 17471607 | 17471607 | PRJNA911178_P_NODE_67694_length_427_cov_3.333333_g65234_i0 | PRJNA911178 | 67694 | 427 | 3.333333 | 14.23333191 | Alternaria botybirnavirus 2 | 3081987 | Viruses | Viruses | 285 | 3.73e-72 | NTclustered | gi|2594582617|gb|OR584149.1| | 3081987 | g65234 | i0 | 83.23 | 4.11709601873536 | 322 | 43 | 74 | 11 | 112 | 426 | 86 | 403 | Alternaria botybirnavirus 2 strain XC21-21C segment RNA1, complete sequence | blastn | 1758 | 285 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Botybirnaviridae | Botybirnavirus | Alternaria botybirnavirus 2 | ||
| 18744277 | 18744277 | PRJNA911178_P_NODE_274955_length_244_cov_1.672515_g272481_i0 | PRJNA911178 | 274955 | 244 | 1.672515 | 4.0809366 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 412 | 8.759999999999998e-111 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g272481 | i0 | 98.707 | 0.950819672131147 | 232 | 3 | 95 | 0 | 10 | 241 | 325 | 94 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 232 | 412 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 22568838 | 22568838 | PRJNA911178_P_NODE_155698_length_300_cov_1.303965_g153225_i0 | PRJNA911178 | 155698 | 300 | 1.303965 | 3.911895 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 296 | 1.17e-75 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g153225 | i0 | 84.932 | 0.973333333333333 | 292 | 44 | 97 | 0 | 2 | 293 | 575 | 866 | Malassezia restricta virus MrV40L, complete genome | blastn | 292 | 296 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 22569601 | 22569601 | PRJNA911178_P_NODE_252998_length_249_cov_0.875000_g250524_i0 | PRJNA911178 | 252998 | 249 | 0.875 | 2.17875 | Totiviridae sp. | 1955172 | Viruses | Viruses | 198 | 2.74e-46 | NTclustered | gi|2396038768|gb|ON812661.1| | 1955172 | g250524 | i0 | 81.481 | 3.14056224899598 | 243 | 43 | 97 | 2 | 8 | 249 | 4212 | 4453 | MAG: Totiviridae sp. isolate TIGMIC_4, complete genome | blastn | 782 | 198 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 23845077 | 23845077 | PRJNA911178_P_NODE_287839_length_242_cov_0.911243_g285365_i0 | PRJNA911178 | 287839 | 242 | 0.911243 | 2.20520806 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 403 | 5.22e-108 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g285365 | i0 | 97.071 | 0.987603305785124 | 239 | 7 | 99 | 0 | 1 | 239 | 1496 | 1734 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 239 | 403 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 25117814 | 25117814 | PRJNA911178_P_NODE_159720_length_296_cov_2.443946_g157247_i0 | PRJNA911178 | 159720 | 296 | 2.443946 | 7.23408016 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 514 | 2.92e-141 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g157247 | i0 | 99.296 | 1.06418918918919 | 284 | 2 | 96 | 0 | 12 | 295 | 287 | 570 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 315 | 514 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 25118173 | 25118173 | PRJNA911178_P_NODE_198580_length_272_cov_2.477387_g196107_i0 | PRJNA911178 | 198580 | 272 | 2.477387 | 6.73849264 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 272 | 1.7599999999999996e-68 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g196107 | i0 | 85.283 | 0.974264705882353 | 265 | 37 | 97 | 2 | 6 | 269 | 4000 | 4263 | Malassezia restricta virus MrV40L, complete genome | blastn | 265 | 272 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L |
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);;