contig_metadata
15 rows where bioproject = "PRJNA1068513" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1013633 | 1013633 | PRJNA1068513_S_NODE_3961_length_449_cov_3.784574_g3916_i0 | PRJNA1068513 | 3961 | 449 | 3.784574 | 16.99273726 | root | 1 | Root_unresolved | Root_unresolved | 84.2 | 1.54e-11 | NTclustered | gi|1953437643|gb|MT157331.1| | 47929 | g3916 | i0 | 94.545 | 14.5991091314031 | 55 | 1 | 12 | 2 | 1 | 54 | 162942 | 162889 | Macacine betaherpesvirus 3 strain UCD59, complete genome | blastn | 6555 | 84.2 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus macacinebeta3 | ||
| 6559714 | 6559714 | PRJNA1068513_S_NODE_11646_length_258_cov_1.345946_g11600_i0 | PRJNA1068513 | 11646 | 258 | 1.345946 | 3.47254068 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 62.1 | 3.9e-5 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g11600 | i0 | 95 | 0.418604651162791 | 40 | 1 | 15 | 1 | 5 | 43 | 12987 | 13026 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 108 | 62.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 9941751 | 9941751 | PRJNA1068513_S_NODE_10088_length_281_cov_2.221154_g10042_i0 | PRJNA1068513 | 10088 | 281 | 2.221154 | 6.24144274 | Viruses | 10239 | Viruses | Viruses | 60.2 | 1.55e-4 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g10042 | i0 | 97.222 | 12.9537366548043 | 36 | 0 | 12 | 1 | 247 | 281 | 13030 | 12995 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 3640 | 60.2 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 10385121 | 10385121 | PRJNA1068513_S_NODE_1649_length_600_cov_40.618596_g1608_i0 | PRJNA1068513 | 1649 | 600 | 40.618596 | 243.711576 | Lymphocryptovirus humangamma4 | 3050299 | Viruses | Viruses | 60.2 | 3.55e-4 | NTclustered | gi|2609791700|gb|OR652422.1| | 10376 | g1608 | i0 | 97.222 | 0.06 | 36 | 0 | 6 | 1 | 562 | 597 | 9245 | 9279 | Human gammaherpesvirus 4 strain 725, partial genome | blastn | 36 | 60.2 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 11217011 | 11217011 | PRJNA1068513_S_NODE_1229_length_652_cov_38.683938_g1189_i0 | PRJNA1068513 | 1229 | 652 | 38.683938 | 252.21927576 | root | 1 | Root_unresolved | Root_unresolved | 87.9 | 1.78e-12 | NTclustered | gi|1953437643|gb|MT157331.1| | 47929 | g1189 | i0 | 94.737 | 10.5030674846626 | 57 | 1 | 9 | 2 | 597 | 652 | 162889 | 162944 | Macacine betaherpesvirus 3 strain UCD59, complete genome | blastn | 6848 | 87.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus macacinebeta3 | ||
| 15041301 | 15041301 | PRJNA1068513_S_NODE_2052_length_564_cov_3.040733_g2010_i0 | PRJNA1068513 | 2052 | 564 | 3.040733 | 17.14973412 | Viruses | 10239 | Viruses | Viruses | 69.4 | 5.52e-7 | NTclustered | gi|1465382783|emb|LS992247.1| | 10376 | g2010 | i0 | 100 | 7.43262411347518 | 37 | 0 | 7 | 0 | 2 | 38 | 58020 | 58056 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 4192 | 69.4 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 16316077 | 16316077 | PRJNA1068513_S_NODE_9393_length_294_cov_0.859729_g9347_i0 | PRJNA1068513 | 9393 | 294 | 0.859729 | 2.52760326 | Viruses | 10239 | Viruses | Viruses | 71.3 | 7.53e-8 | NTclustered | gi|1465382783|emb|LS992247.1| | 10376 | g9347 | i0 | 93.75 | 15.1326530612245 | 48 | 1 | 16 | 2 | 2 | 49 | 58011 | 58056 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 4449 | 71.3 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 17591415 | 17591415 | PRJNA1068513_S_NODE_4974_length_406_cov_5.729730_g4929_i0 | PRJNA1068513 | 4974 | 406 | 5.72973 | 23.2627038 | Viruses | 10239 | Viruses | Viruses | 65.8 | 5e-6 | NTclustered | gi|1465382783|emb|LS992247.1| | 10376 | g4929 | i0 | 100 | 9.66502463054187 | 35 | 0 | 9 | 0 | 1 | 35 | 58022 | 58056 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 3924 | 65.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 17591425 | 17591425 | PRJNA1068513_S_NODE_9494_length_292_cov_1.091324_g9448_i0 | PRJNA1068513 | 9494 | 292 | 1.091324 | 3.18666608 | Viruses | 10239 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g9448 | i0 | 100 | 0.191780821917808 | 28 | 0 | 10 | 0 | 1 | 28 | 12999 | 13026 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 18033649 | 18033649 | PRJNA1068513_S_NODE_7975_length_321_cov_2.322581_g7929_i0 | PRJNA1068513 | 7975 | 321 | 2.322581 | 7.45548501 | Cytomegalovirus macacinebeta3 | 3050308 | Viruses | Viruses | 128 | 4.86e-25 | NTclustered | gi|1953437643|gb|MT157331.1| | 47929 | g7929 | i0 | 97.333 | 25.6635514018692 | 75 | 2 | 23 | 0 | 1 | 75 | 162961 | 162887 | Macacine betaherpesvirus 3 strain UCD59, complete genome | blastn | 8238 | 128 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus macacinebeta3 | ||
| 20140050 | 20140050 | PRJNA1068513_S_NODE_2496_length_530_cov_4.334792_g2453_i0 | PRJNA1068513 | 2496 | 530 | 4.334792 | 22.9743976 | root | 1 | Root_unresolved | Root_unresolved | 60.2 | 3.11e-4 | NTclustered | gi|1465382783|emb|LS992247.1| | 10376 | g2453 | i0 | 97.222 | 6.74528301886792 | 36 | 0 | 7 | 1 | 494 | 529 | 88235 | 88201 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 3575 | 60.2 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 21415609 | 21415609 | PRJNA1068513_S_NODE_8817_length_304_cov_18.467532_g8771_i0 | PRJNA1068513 | 8817 | 304 | 18.467532 | 56.14129728 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 1.31e-5 | NTclustered | gi|1953437643|gb|MT157331.1| | 47929 | g8771 | i0 | 91.489 | 14.5953947368421 | 47 | 2 | 15 | 2 | 1 | 46 | 162934 | 162889 | Macacine betaherpesvirus 3 strain UCD59, complete genome | blastn | 4437 | 63.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus macacinebeta3 | ||
| 22690429 | 22690429 | PRJNA1068513_S_NODE_1478_length_620_cov_1.610603_g1437_i0 | PRJNA1068513 | 1478 | 620 | 1.610603 | 9.9857386 | root | 1 | Root_unresolved | Root_unresolved | 89.8 | 4.69e-13 | NTclustered | gi|1953437643|gb|MT157331.1| | 47929 | g1437 | i0 | 94.828 | 11.1 | 58 | 1 | 9 | 2 | 1 | 57 | 162945 | 162889 | Macacine betaherpesvirus 3 strain UCD59, complete genome | blastn | 6882 | 89.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus macacinebeta3 | ||
| 23134141 | 23134141 | PRJNA1068513_S_NODE_1239_length_651_cov_3.482699_g1199_i0 | PRJNA1068513 | 1239 | 651 | 3.482699 | 22.67237049 | Cytomegalovirus macacinebeta3 | 3050308 | Viruses | Viruses | 117 | 2.26e-21 | NTclustered | gi|1953437643|gb|MT157331.1| | 47929 | g1199 | i0 | 95.89 | 12.3010752688172 | 73 | 1 | 11 | 2 | 32 | 103 | 162960 | 162889 | Macacine betaherpesvirus 3 strain UCD59, complete genome | blastn | 8008 | 117 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus macacinebeta3 | ||
| 23966011 | 23966011 | PRJNA1068513_S_NODE_9679_length_289_cov_1.004630_g9633_i0 | PRJNA1068513 | 9679 | 289 | 1.00463 | 2.9033807 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2609791689|gb|OR652421.1| | 10376 | g9633 | i0 | 100 | 0.200692041522491 | 29 | 0 | 10 | 0 | 250 | 278 | 13026 | 12998 | Human gammaherpesvirus 4 strain 720, partial genome | blastn | 58 | 54.7 | 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);;