contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA550047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 513039 | 513039 | PRJNA550047_P_NODE_1661_length_1724_cov_59.719564_g722_i0 | PRJNA550047 | 1661 | 1724 | 59.719564 | 1029.56528336 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 1530 | 0 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g722 | i0 | 91.802 | 0.64385150812065 | 1110 | 74 | 64 | 15 | 624 | 1724 | 1103 | 2 | Malassezia restricta virus MrV40S, complete genome | blastn | 1110 | 1530 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 1790510 | 1790510 | PRJNA550047_P_NODE_310322_length_296_cov_4.381166_g308353_i0 | PRJNA550047 | 310322 | 296 | 4.381166 | 12.96825136 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 270 | 6.97e-68 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g308353 | i0 | 99.329 | 1.01351351351351 | 149 | 1 | 100 | 0 | 1 | 149 | 851 | 703 | Malassezia restricta virus MrV40S, complete genome | blastn | 300 | 270 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 4344224 | 4344224 | PRJNA550047_P_NODE_493764_length_232_cov_13.830189_g491791_i0 | PRJNA550047 | 493764 | 232 | 13.830189 | 32.08603848 | Xian Totiv tick virus 2 | 2972358 | Viruses | Viruses | 187 | 5.449999999999998e-43 | NTclustered | gi|2320153247|gb|ON746556.1| | 2972358 | g491791 | i0 | 97.273 | 0.474137931034483 | 110 | 3 | 47 | 0 | 1 | 110 | 4422 | 4531 | MAG: Xian Totiv tick virus 2 isolate TIGMIC 1 genomic sequence | blastn | 110 | 187 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Xian Totiv tick virus 2 | |||
| 11996490 | 11996490 | PRJNA550047_P_NODE_532230_length_219_cov_16.267123_g530257_i0 | PRJNA550047 | 532230 | 219 | 16.267123 | 35.62499937 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 217 | 6.489999999999999e-52 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g530257 | i0 | 85.507 | 0.945205479452055 | 207 | 30 | 95 | 0 | 7 | 213 | 1536 | 1742 | Malassezia restricta virus MrV40L, complete genome | blastn | 207 | 217 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 15820836 | 15820836 | PRJNA550047_P_NODE_577453_length_205_cov_4.787879_g575480_i0 | PRJNA550047 | 577453 | 205 | 4.787879 | 9.81515195 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 346 | 7.33e-91 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g575480 | i0 | 97.087 | 1.34146341463415 | 206 | 5 | 100 | 1 | 1 | 205 | 3026 | 2821 | Malassezia restricta virus MrV40L, complete genome | blastn | 275 | 346 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 18365466 | 18365466 | PRJNA550047_P_NODE_234495_length_301_cov_4.219298_g232526_i0 | PRJNA550047 | 234495 | 301 | 4.219298 | 12.70008698 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 440 | 5.119999999999999e-119 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g232526 | i0 | 92.675 | 1.04318936877076 | 314 | 9 | 100 | 2 | 1 | 301 | 23 | 335 | Malassezia restricta virus MrV40S, complete genome | blastn | 314 | 440 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 19641693 | 19641693 | PRJNA550047_P_NODE_356056_length_282_cov_14.870813_g354085_i0 | PRJNA550047 | 356056 | 282 | 14.870813 | 41.93569266 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 435 | 2.21e-117 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g354085 | i0 | 94.643 | 3.84751773049645 | 280 | 15 | 99 | 0 | 1 | 280 | 205 | 484 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 1085 | 435 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 20918407 | 20918407 | PRJNA550047_P_NODE_425397_length_255_cov_11.362637_g423425_i0 | PRJNA550047 | 425397 | 255 | 11.362637 | 28.97472435 | Shenzhen reo-like virus 1 | 2789623 | Viruses | Viruses | 294 | 3.4900000000000003e-75 | NTclustered | gi|1940198125|gb|MT757494.1| | 2789623 | g423425 | i0 | 87.451 | 1 | 255 | 32 | 100 | 0 | 1 | 255 | 381 | 635 | Shenzhen reo-like virus 1 strain CHNdp-4 hypothetical protein gene, complete cds | blastn | 255 | 294 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Shenzhen reo-like virus 1 | ||||
| 22192789 | 22192789 | PRJNA550047_P_NODE_398038_length_265_cov_50.817708_g396066_i0 | PRJNA550047 | 398038 | 265 | 50.817708 | 134.6669262 | Chrocurosk virus | 3129322 | Viruses | Viruses | 285 | 2.19e-72 | NTclustered | gi|2717317280|gb|PP171770.1| | 3129322 | g396066 | i0 | 88.608 | 272.864150943396 | 237 | 23 | 89 | 4 | 2 | 236 | 1662 | 1896 | MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence | blastn | 72309 | 285 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Chrocurosk virus | |||
| 22797340 | 22797340 | PRJNA550047_P_NODE_169138_length_345_cov_3.437500_g167178_i0 | PRJNA550047 | 169138 | 345 | 3.4375 | 11.859375 | Totivirus | 11007 | Viruses | Viruses | 257 | 6.45e-64 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g167178 | i0 | 97.351 | 1.75072463768116 | 151 | 4 | 88 | 0 | 1 | 151 | 1354 | 1204 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 604 | 257 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 24740964 | 24740964 | PRJNA550047_P_NODE_314560_length_295_cov_8.765766_g312591_i0 | PRJNA550047 | 314560 | 295 | 8.765766 | 25.8590097 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 189 | 2e-43 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g312591 | i0 | 91.367 | 0.471186440677966 | 139 | 10 | 47 | 2 | 1 | 138 | 4372 | 4235 | Malassezia restricta virus MrV40L, complete genome | blastn | 139 | 189 | 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);;