contig_metadata
11 rows where bioproject = "PRJEB6584", tax_phylum = "Peploviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25523773 | 25523773 | PRJEB6584f_S_NODE_1937_length_208_cov_40.942197_g1931_i0 | PRJEB6584 | 1937 | 208 | 40.942197 | 85.15976976 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g1931 | i0 | 100 | 0.139423076923077 | 29 | 0 | 14 | 0 | 1 | 29 | 36346 | 36318 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 25524901 | 25524901 | PRJEB6584o_S_NODE_3433_length_405_cov_9018.878378_g3325_i0 | PRJEB6584 | 3433 | 405 | 9018.878378 | 36526.4574309 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 134 | 1.3500000000000002e-26 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3325 | i0 | 98.684 | 22.7185185185185 | 76 | 0 | 19 | 1 | 5 | 79 | 36559 | 36634 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 9201 | 134 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 25752278 | 25752278 | PRJEB6584n_S_NODE_530_length_210_cov_6823.051429_g524_i0 | PRJEB6584 | 530 | 210 | 6823.051429 | 14328.4080009 | root | 1 | Root_unresolved | Root_unresolved | 110 | 1.08e-19 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g524 | i0 | 98.387 | 32.4 | 62 | 1 | 30 | 0 | 1 | 62 | 36573 | 36634 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 6804 | 111 | 0.990990990990991 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 25795699 | 25795699 | PRJEB6584d_S_NODE_8883_length_202_cov_9.203593_g8815_i0 | PRJEB6584 | 8883 | 202 | 9.203593 | 18.59125786 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g8815 | i0 | 100 | 0.143564356435644 | 29 | 0 | 14 | 0 | 2 | 30 | 36346 | 36318 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 25796316 | 25796316 | PRJEB6584o_S_NODE_12651_length_247_cov_2.816038_g12543_i0 | PRJEB6584 | 12651 | 247 | 2.816038 | 6.95561386 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g12543 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 1 | 28 | 36344 | 36317 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 25797620 | 25797620 | PRJEB6584p_S_NODE_555_length_342_cov_1864.970684_g524_i0 | PRJEB6584 | 555 | 342 | 1864.970684 | 6378.19973928 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 110 | 1.89e-19 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g524 | i0 | 96.97 | 19.0175438596491 | 66 | 1 | 19 | 1 | 278 | 342 | 36639 | 36574 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 6504 | 110 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26067509 | 26067509 | PRJEB6584a_S_NODE_1413_length_298_cov_4026.790875_g1393_i0 | PRJEB6584 | 1413 | 298 | 4026.790875 | 11999.8368075 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 135 | 2.67e-27 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g1393 | i0 | 97.5 | 45.7181208053691 | 80 | 0 | 27 | 2 | 3 | 81 | 36559 | 36637 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 13624 | 135 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26068071 | 26068071 | PRJEB6584h_S_NODE_7381_length_219_cov_13.217391_g7319_i0 | PRJEB6584 | 7381 | 219 | 13.217391 | 28.94608629 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 58.4 | 4.16e-4 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g7319 | i0 | 100 | 0.141552511415525 | 31 | 0 | 14 | 0 | 1 | 31 | 167936 | 167966 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 31 | 58.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26204387 | 26204387 | PRJEB6584i_S_NODE_3014_length_203_cov_12.458333_g3002_i0 | PRJEB6584 | 3014 | 203 | 12.458333 | 25.29041599 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3002 | i0 | 100 | 0.142857142857143 | 29 | 0 | 14 | 0 | 173 | 201 | 36318 | 36346 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26340141 | 26340141 | PRJEB6584h_S_NODE_3359_length_280_cov_1366.012245_g3297_i0 | PRJEB6584 | 3359 | 280 | 1366.012245 | 3824.834286 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3297 | i0 | 94.444 | 0.128571428571429 | 36 | 0 | 13 | 2 | 227 | 261 | 167967 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 36 | 54.7 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26476493 | 26476493 | PRJEB6584j_S_NODE_3600_length_219_cov_11765.831522_g3571_i0 | PRJEB6584 | 3600 | 219 | 11765.831522 | 25767.17103318 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 132 | 2.42e-26 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3571 | i0 | 100 | 31.9269406392694 | 71 | 0 | 32 | 0 | 8 | 78 | 36566 | 36636 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 6992 | 132 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 |
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);;