contig_metadata
14 rows where bioproject = "PRJEB7614", tax_kingdom = "Heunggongvirae" and tax_phylum = "Peploviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1413333 | 1413333 | PRJEB7614_P_NODE_2962_length_227_cov_19749.262626_g2895_i0 | PRJEB7614 | 2962 | 227 | 19749.262626 | 44830.82616102 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g2895 | i0 | 97.059 | 0.149779735682819 | 34 | 0 | 15 | 1 | 111 | 143 | 167933 | 167966 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 1413335 | 1413335 | PRJEB7614_P_NODE_3342_length_217_cov_21022.914894_g3275_i0 | PRJEB7614 | 3342 | 217 | 21022.914894 | 45619.72531998 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3275 | i0 | 97.059 | 0.15668202764977 | 34 | 0 | 15 | 1 | 75 | 107 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 2688780 | 2688780 | PRJEB7614_P_NODE_2263_length_251_cov_19604.238739_g2196_i0 | PRJEB7614 | 2263 | 251 | 19604.238739 | 49206.63923489 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g2196 | i0 | 97.059 | 0.135458167330677 | 34 | 0 | 13 | 1 | 111 | 143 | 167933 | 167966 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 3964847 | 3964847 | PRJEB7614_P_NODE_2404_length_246_cov_18189.562212_g2337_i0 | PRJEB7614 | 2404 | 246 | 18189.562212 | 44746.32304152 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 63.9 | 1.03e-5 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g2337 | i0 | 100 | 0.365853658536585 | 34 | 0 | 14 | 0 | 103 | 136 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 90 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 7790974 | 7790974 | PRJEB7614_P_NODE_1527_length_286_cov_15562.848249_g1460_i0 | PRJEB7614 | 1527 | 286 | 15562.848249 | 44509.74599214 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g1460 | i0 | 97.059 | 0.118881118881119 | 34 | 0 | 12 | 1 | 144 | 176 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 15441166 | 15441166 | PRJEB7614_P_NODE_3813_length_207_cov_22563.932584_g3746_i0 | PRJEB7614 | 3813 | 207 | 22563.932584 | 46707.34044888 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3746 | i0 | 97.059 | 0.164251207729469 | 34 | 0 | 16 | 1 | 65 | 97 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 16715381 | 16715381 | PRJEB7614_P_NODE_3234_length_220_cov_20899.497382_g3167_i0 | PRJEB7614 | 3234 | 220 | 20899.497382 | 45978.8942404 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3167 | i0 | 97.059 | 0.154545454545455 | 34 | 0 | 15 | 1 | 78 | 110 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 16715384 | 16715384 | PRJEB7614_P_NODE_3934_length_205_cov_22837.204545_g3867_i0 | PRJEB7614 | 3934 | 205 | 22837.204545 | 46816.26931725 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3867 | i0 | 97.059 | 0.165853658536585 | 34 | 0 | 16 | 1 | 63 | 95 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 17990216 | 17990216 | PRJEB7614_P_NODE_3075_length_224_cov_20585.625641_g3008_i0 | PRJEB7614 | 3075 | 224 | 20585.625641 | 46111.80143584 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3008 | i0 | 97.059 | 0.151785714285714 | 34 | 0 | 15 | 1 | 82 | 114 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 17990217 | 17990217 | PRJEB7614_P_NODE_3115_length_223_cov_20151.943299_g3048_i0 | PRJEB7614 | 3115 | 223 | 20151.943299 | 44938.83355677 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g3048 | i0 | 97.059 | 0.152466367713004 | 34 | 0 | 15 | 1 | 81 | 113 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 19264226 | 19264226 | PRJEB7614_P_NODE_2856_length_230_cov_27642.860697_g2789_i0 | PRJEB7614 | 2856 | 230 | 27642.860697 | 63578.5796031 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 63.9 | 9.49e-6 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g2789 | i0 | 100 | 0.147826086956522 | 34 | 0 | 15 | 0 | 82 | 115 | 167966 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 19264227 | 19264227 | PRJEB7614_P_NODE_2996_length_226_cov_19991.868020_g2929_i0 | PRJEB7614 | 2996 | 226 | 19991.86802 | 45181.6217252 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 58.4 | 4.32e-4 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g2929 | i0 | 97.143 | 0.154867256637168 | 35 | 0 | 15 | 1 | 83 | 116 | 167967 | 167933 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 35 | 58.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 19264230 | 19264230 | PRJEB7614_P_NODE_4856_length_192_cov_171.141104_g4789_i0 | PRJEB7614 | 4856 | 192 | 171.141104 | 328.59091968 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|1386449979|gb|MG298870.1| | 10376 | g4789 | i0 | 97.059 | 0.177083333333333 | 34 | 0 | 18 | 1 | 1 | 34 | 36602 | 36634 | Human gammaherpesvirus 4 isolate JC_V005, partial genome | blastn | 34 | 56.5 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 26206256 | 26206256 | PRJEB7614e_S_NODE_638_length_274_cov_3216.924686_g630_i0 | PRJEB7614 | 638 | 274 | 3216.924686 | 8814.37363964 | human gammaherpesvirus 4 | 10376 | Viruses | Viruses | 62.1 | 4.18e-5 | NTclustered | gi|1386446244|gb|MG298823.1| | 10376 | g630 | i0 | 100 | 13.3430656934307 | 33 | 0 | 12 | 0 | 227 | 259 | 36572 | 36540 | Human gammaherpesvirus 4 isolate AH_Saliva_8192, partial genome | blastn | 3656 | 62.1 | 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);;